To reconcile your accounts payable activity for April, make the following calculation:“Accounts Payable Trial Balance” as of March 31+ “Posted Invoice Register” for the period between April 1 and April 30
Run the GL “Account Analysis” report for the liability account and for the date range in question. Look for transactions with a source other than Payables. This can quickly pinpoint any transactions incorrectly charged to the account. Make sure that you have not made manual journal entries to your liability account in General Ledger.When you identify the accounts you go back to AP and do a query on the account to find the invoices out of balance.
Q: How is the as-of-date used in the “Accounts Payable Trial Balance” report?