DataShare can assist with reviewing the accounts payable sub-ledger for unusual items, such as significant debit balances or unexpected amounts. To access this report, go into your client's DataShare View and click on "Generate Working Papers" under Reporting Packs on the left hand side.
Next, select the period you wish to review the accounts payable sub-ledger. Click on "Generate" to produce the working papers. The working papers will appear in the form of a zip file.
Click on the zip file to open your client's set of standardized excel working papers.
Select the accounts payable excel sheet to open.
Within the A/P excel file, scroll through the tabs to find the "Payables Open Item List". On this sheet you will find all outstanding accounts payable. You can look in the "Outstanding" column for unusual or large negative balances. You can also review the "Type" column for any unusual transactions.
Please sign in to leave a comment.