You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reconciliation between AP Subledger and Open AP Invoices

Received Response
61
Views
4
Comments
edited Oct 1, 2020 5:43AM in Account Reconciliation 4 comments

Summary

Unable to do Transaction Matching due to the nature of data sources

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!