Question
I have an Excel table of all supplier payment populations for the year of 2018 from Jan 2 to Dec 31: Excel includes a list
I have an Excel table of all supplier payment populations for the year of 2018 from Jan 2 to Dec 31: Excel includes a list of Dates, Paid to Whom, Amount of Payment, Check Number, and Account Nunmer. I need to define what counts as success and what counts as a failure in regard to that info.
The First Step Question Stated:
Before processing payment to those suppliers, the accounts payable department must verify that the details on the vendor invoice correspond to those on the purchase order and the receipt.
To establish the matching control, an accounts payable clerk combines the check, purchase order, and invoice and files them alphabetically by the supplier in the accounts payable section.
How do I go about it using excel tools? Can you show me what tools in excel to use step by step because I have very weak knowledge of excel? In excel how do I check the control of the three-way match for cash disbursements?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started