To Reconcile AP Accounts and AR Accounts with the General Ledger Accounts

You use the Discrepancy by Account (AP409010) and Discrepancy by Account (AR409010) forms to find discrepancies between the balances of AP accounts and AR accounts in the GL and in a subledger (AP or AR) with the accounts listed for a particular range of financial periods.

Note: To open any form, you can navigate to it or search for it (by its name or by its form ID without periods). For more information about search capabilities, see Search.

To Reconcile AP Accounts and AR Accounts with General Ledger Accounts

  1. Open the Discrepancy by Account (AP409010) or Discrepancy by Account (AR409010) form.
  2. In the Branch box, select the branch for which you want to view data.
  3. In the From Period and To Period boxes, specify the start and end of the range of financial periods where you want to find discrepancies.
  4. In the Account box, select the AP or AR account in which you want to find discrepancies.
  5. Optional (if subaccounts are used in your system): In the Subaccount box, do one of the following:
    • Specify a subaccount to view account information, including any discrepancy, for the account-subaccount pair.
    • Specify a mask to view information on a group of subaccounts. To define a mask, specify the values for only some of the segments. The system will list a row for each account-subaccount pair that meets the selection criteria.
    • Leave this box blank to view the balances of the account detailed by all relevant subaccounts of the account.
  6. Select the Show Only Documents with Discrepancy check box.
  7. In the table, view the list of accounts displayed by the system and the discrepancies in them (shown in the Discrepancy column). Notice the records with nonzero amounts in the Non-AP Transactions or Non-AR Transactions column.
  8. Optional: Click the link in the Discrepancy column for a particular row to open the Discrepancy by Vendor (AP409020) or Discrepancy by Customer (AR409020) form to view more details.

Notes About the Procedure

The notes in this section describe the nuances of the UI elements available on the form, such as when an element is required and when it is not, and when the system fills in settings by default. This section can include other notes.

Note the following about the Summary area of the form:
  • The Branch box is available only if the Multibranch Support feature is enabled on the Enable/Disable Features (CS100000) form.
  • The Subaccount box is available only if the Subaccounts feature is enabled on the Enable/Disable Features form.