Wednesday, July 14, 2010

AP-GL Reconciliation

Month End reconciliation between GL and AP is highly recommended. If AP is interfaced to GL, verifying the balance between the two applications is usually done through comparing account balances of the liability (A/P) account.

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 -
"Posted Payment Register" for the period between April 1 and April 30 =
"Accounts Payable Trial Balance" as of April 30

> If total is not matching you will need to find out the root casue of difference:
Eg. Invalidated Invoice for the period
> For the PTD activity check the "period Close Exception" if there are any invoices and payments which are not transferred to GL.
> If the current period does not reconcile, please complete the reconciliation process for all prior periodsfrom the most recent to the earliest until you get to one that reconciles.

Common Reasons for balance mismatch between AP & GL
1) Manual journal entries in the general ledger that involve an AP liability account will cause the AP Trialbalance not to reconcile to the GL. These entries are not included in the AP subledger so they will not be reflected on the AP Trial Balance Report.
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.

2) You performed a datafix in the past where you used the undo accounting script and swept a transaction forward from a closed period to reaccount it, this will cause an imbalance between AP and GL. The imbalancewill be corrected in the period in which you made a GL adjustment to account for the fix.

3) Any correction you make during the journal import process will result in the line being changed in the general ledger, but not in AP

4) If you have deleted any AP batches or lines from AP batches out of the GL Interface, this will cause AP and GL to be out of balance

5) If the AP batch is still in the GL Interface, it will not be reflected in the GL reports and this will cause a difference between AP and GL.

6) Any AP batches that are unposted in GL will cause a difference between AP and GL


  1. Really very helpfull......thank u chintwar

  2. I have another diff. that due to the revaluation currencies in GL and I am asking if there is any way to revaluation currencies in AP liabilities balances!
    I'd be grateful if I have answer to my problem.

    1. Hi Shihab, we cannot post revaluation entries in AP, reason being all the functional currencies will be converted to Global reporting currency(eg.USD). So the exchange rate may differ from one period to other as this is decided by Treasury... Only thing to resolve this GL team will pass a manual entry for difference in AP balance and the same will get reversed next period.

      Hope this clarifies.

  3. Well, I would hire the experts to get professional guidance regarding accounts payable reconciliation to make sure that my business accounting is going in the right direction.

  4. Thanks lot. The blog is very helpful to understand the reconcilliation process.

  5. hi admin.Good postI got More information from this blog.Keep in blogging.Thanks for sharing that wonderful blog.Vendor Reconciliation | Internal Audit


Note: Only a member of this blog may post a comment.