Product Details
Downloads/Installations
Using the Program
Technical Support
Related Resources
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:
- Make a backup of the program.
- Click G/L and select G/L Statements... to open the Statements window.
- Click to check the General Ledger box under the Statement Selection Options and select GL in the Template box.
- Click to uncheck the other three Statement Selection Options.
- Select the Selected option in the G/L Account Selection box and click Select... to open the List - G/L Accounts window.
- Click to check mark the General Bank G/L control account (1000).
- Click OK to return to the Statements window.
- Enter the first day of the imbalance in both the Start Date and End Date boxes.
- Click to check the Detailed Report box.
- Click to check mark Screen in the Output box.
- 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. - Locate any entries with a source code other than GB under the Srce column for the General Bank G/L control account (1000).
- 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.
- 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).
- 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.
- 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.
- 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.
- Rerun the G/L Reconciliation Report and check mark Reread G/L Information to ensure there is no longer an imbalance.