Reconciliation between AP Subledger and Open AP Invoices
SummaryUnable to do Transaction Matching due to the nature of data sources
We have two levels of reconciliation for Account Payables. One is between GL and Subledger, which will be balance comparison with transaction matching and is pretty straight forward with proper matching identifiers available.
Second is reconciliation between Subledger and Aging report. In this case subledger has all transactions coming in (new invoices, payments invoices, adjustments etc) Aging report has only the open amount of invoices i.e. net of any partial payments and it excludes the invoices that have been paid. Both the sources also have closing balances.