CATS makes it easy to square your general ledger with your physical invoices (invoices that pertain to inventory). For every charge made to the Accounts Receivable and Accounts Payable general ledger accounts in CATS, you should have a corresponding invoice. While individual invoice items may go against particular G/L accounts related to these expenses or charges, the total amount of each invoice should go against the G/L accounts for AR and AP.

CATS that the expected opening and current balances for the AR and AP accounts matches the open invoice listing every time you run an Accounting Recalculation. If the procedure finds a discrepancy, CATS will warn you of this fact.

Another place you can see this discrepancy is viewing the Trial Balance and comparing it to the Report of Open Invoices.

If you get a message that the opening balance for the AR and AP accounts is incorrect, then the opening balance for those G/L accounts that was input in the G/L Scan Accounts area is off from the calculated opening balance based on the report of open invoices. Follow these steps to attempt to find the cause.

1. From the current area, print a summary report of open invoices.
   • Under the Invoice Type filter choose either Purchases or Sales.
   • Under Balance filter select Opening Bal.
   • Select one G/L account, for either the GL_AP or GL_AR system account.
   • On Screen 5, choose Summary.
   • On the Select Order screen, order and subtotal by Account.
   • Print the report and note the bottom total.
2. From the fiscal year-end isolated area, print a summary report of open invoices.
   • Under the Invoice Type filter choose either Purchases or Sales.
   • Under Balance filter select Balance All.
   • Select one G/L account, for either the GL_AP or GL_AR system account.
   • On Screen 5, choose Summary.
   • On the Select Order screen, order and subtotal by Account.
   • Print the report and note the bottom total.
3. From the isolated area, print a G/L Statement.
   • In the filter for G/L Account Range, select the G/L account for GL_AR or GL_AP.
   • Choose columns for Opening Balance, Debit, Credit, and Current Balance (or whichever period is the one you need to balance, such as Period 12 balance).
4. Compare the totals for each report to one another.
   • Once you find a discrepancy, narrow down the issue to one account (if possible).
   • Print the invoices just for that counterparty account code using the Account Range on the reports.
   • Then, you can determine which invoices have balance discrepancies.

If you have a discrepancy with the current balance, you can follow these steps to find the cause:

1. Run the Accounting Recalculation with default options.
   Click here to see the default Accounting Recalculation options
2. Review the report and look for errors related to “Non-invoice transaction posted to GL_AR” or “Non-GL_AP invoice” on the printout.
   Click here to see an example of these errors.
3. Fix these transactions.
   • Reverse them OR
   • Correct these errors.

1. From the current or an isolated area, print a summary report of open invoices.
   • Under the Invoice Type filter choose either Purchases or Sales.
   • Under Balance filter select Balance All.
   • Select one G/L account, for either the GL_AP or GL_AR system account.
   • On Screen 5, choose Summary.
   • On the Select Order screen, order and subtotal by Account then order by Invoice Number.
   • Print the report and note the bottom total.
2. Also from the isolated area, print a Trial Balance.
   • In the filter for G/L Accts Bal/Act, select Current/Opn Bal.
   • Choose columns for Opening Balance, Period 11 Balance, Period 12 amount, and Period 12 balance (or Current Balance) - or whichever period is the one you need to balance.
   • On Screen 5, choose Summary.
   • On the Select Order screen, order and subtotal by Account, then order by Invoice Number.
   • Print the report and compare the bottom total to the Report of Open Invoices.
3. Compare the totals for each account until you find the discrepancy.
   • Once you find a discrepancy, narrow down the issue to one account (if possible).
   • Print the invoices just for that counterparty account code using the Account Range on the reports.
   • Then, you can determine which invoices have balance discrepancies.