Article ID: 8722

Correcting an Imbalance That Begins After Your Start Date Between the General Bank Journal and the G/L

The imbalance between the General Bank Journal and G/L also appears in the Journal/G/L column under the General Bank section of the G/L Reconciliation Report.

Take the following steps to reconcile differences that appear under the Journal/G/L column if the imbalance occurs after the accounting start date of your books:

  1. Make a backup of the program.
  2. Click G/L and select G/L Statements... to open the Statements window.
  3. Click to check the General Ledger box under the Statement Selection Options and select GL in the Template box.
  4. Click to uncheck the other three Statement Selection Options.
  5. Select the Selected option in the G/L Account Selection box and click Select... to open the List - G/L Accounts window.
  6. Click to check mark the General Bank G/L control account (1000).
  7. Click OK to return to the Statements window.
  8. Enter the first day of the imbalance in both the Start Date and End Date boxes.
  9. Click to check the Detailed Report box.
  10. Click to check mark Screen in the Output box.
  11. Click OK to generate the General Ledger report for the day of the imbalance.
    NOTE: Click Yes if you get the Do you want to re-read G/L information? prompt.
  12. Locate any entries with a source code other than GB under the Srce column for the General Bank G/L control account (1000).
  13. Double-click any entries that have a source code other than GB under the Srce column and change the G/L allocation on them to something other than the General Bank G/L control account.
    NOTE: If you get the This entry is in a closed period and cannot be changed prompt, click OK and take either of the following actions:
    • Enter a G/L Adjustment in the amount of the imbalance to reallocate the item from the General Bank G/L control account to the correct G/L account.
    • Reopen your months back to the date of the entry and change the G/L allocation on the transaction to something other than the General Bank G/L control account.
  14. Locate any items with matching entry numbers under the Entry # column if you still have an imbalance (one item has a debit to the G/L account 1000 and the item with the matching entry number has a credit to the G/L account 1000).
  15. Double-click one of the items with matching entry numbers and change the G/L allocation on them to something other than the General Bank G/L control account.
    NOTE: If you get the This entry is in a closed period and cannot be changed prompt, click OK and take one of the following actions:
    • Enter a G/L Adjustment in the amount of the imbalance to reallocate the item from the General Bank G/L control account to the correct G/L account.
    • Reopen your months back to the date of the entry and change the G/L allocation on the transaction to something other than the General Bank G/L control account.
  16. Locate any items with an entry number out of sequential order (indicates the item is back-dated into a closed period) if you still have an imbalance.
  17. Take one of the following actions if you find back-dated items:
    • Reopen your months back to the date of the entry and re-close your months.
    • Back-date another entry with a negative amount to offset the first back-dated entry.
  18. Rerun the G/L Reconciliation Report and check mark Reread G/L Information to ensure there is no longer an imbalance.