How to Reconcile Sage 100 Accounts Payable Detail to the General ledger

The Sage City community has answered a frequently asked question about which AP report to use when reconciling your Accounts Payable detail to the General Ledger Trial Balance. The answer is the AP Trial Balance Report because it produces a cutoff based on the posting date, which can be reconciled to General Ledger.

The Accounts Payable Aging Report is used to manage payables based on their invoice date, which may not always be correlated to the accounting date they were posted in.

From Sage City:

When reconciling AP to the GL and using the AP Trial balance, does the invoice date have an impact on differences? As I understand it using the AP Trial balance goes by transaction date which is the GL posting date. I’m reconciling day by day and sometimes the AP invoice date does not equal the transaction date. Would this scenario be a valid difference in balancing the AP Trial Balance to GL or no because the the trial balance does not use invoice date?

Read the answer here and background information on why the AP Trial Balance is the correct report to use.

For timely updates about Sage 100 accounting software, please subscribe to our Thursday Sage 100 email newsletter.