Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Japanese Management Accounting A World Class Approach To Profit Management

Authors: Michiharu Sakurai, Yasuhiro Monden

1st Edition

091529950X, 978-0915299508

More Books

Students also viewed these Accounting questions