Variance between AP and GL

  • 3 May 2023
  • 1 reply

Userlevel 4

How do you confirm and be sure that AP balance is equals to GL balance and their is no variance?


Best answer by Laura02 3 May 2023, 15:10

View original

1 reply

Badge +18


Begin by adjusting the GL Control Account balance(s) to match the AP Period-Sensitive Aging report.  Keep in mind, it is possible to use multiple AP Control accounts, such as Due to Employee/Owner in addition to AP Trade.  Reconciliation is much easier when there is only one AP Control account in the GL.

Once the combined balances of all AP Control Accounts in the GL match the balance on the AP Period Sensitive Aging report, then go to Chart of Accounts and make the following changes:

  1. Identify AP as the Control Account Module for every AP Control Account. 
  1. Do NOT check Allow Manual Entry.

To determine how many AP Control Accounts you have, check the Vendor settings and the Finance tab of your open Documents.

I  recommend adding the AP Account into the Vendor Profile preview list GI and the Bills & Adjustments preview list GI, for easier visibility into which GL accounts are used as AP Control Accounts.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved