General Ledger Support Document
Open as: PDF or Word Document
8. Account Reconciliation
Table of Contents
The "General" tab, Reconciliation
The "General" tab, Un-Reconciliation
The "Deposits (Bank Credits)" tab
The "Withdraws (Bank Debits)" tab
Click on "8. Account Reconciliation" from the Main Menu and the following window will appear:
Account Reconciliation
The "General" tab, Reconciliation
- Tool to Use: If you want to Reconcile, click "Reconcile," if you want to Un-Reconcile, click "Un-Reconcile," and refer below to "Un-Reconciliation."
- Account to Reconcile: Enter the General Ledger account number that represents the bank account you are reconciling or click the "Find" button to select from the look up table.
- Beginning Bal. on Statement: This value will carry forward from your last reconciliation. Click on the "Edit" button if you are entering this value for the first time.
- Ending Balance on Statement: Enter the ending balance as shown on the bank statement you are reconciling.
- Do not show transactions dated on or after: Enter a date here to eliminate any activities from showing that are beyond the one provided. Use caution as some activities required to reconcile may have been dated beyond the statement cut off which is commonly used here.
- Statement Date: Enter the statement date being reconciled.
- Diskette Reconciliation: Enter the proper values for reading values from a file for reconciling checks.
- Reconcile Diskette Now: Click this button to begin reading the file from diskette to reconcile cashed checks.
- This area will display reconciliation values as you process through deposit, withdrawals and checks.
- Qty: If you need to force an adjustment to reconcile the statement that does not require a journal entry then you may use this area to record a quantity of items, amounts to adjust and with the adjustment button to define why the adjustment was made. This will print on the bottom of the reconciliation report.
- Save: Click this button to save to this computer. Refer to GENERAL FILE for more information.
- Finish Later: Click this button if you would like to save your work and finish reconciling at a later time.
- Report: Print or Preview the reconciliation report review and/or to store with your bank statement.
- Cancel: Click "Cancel" to cancel and return to the previous window.
The "General" tab, Un-Reconciliation
- Account to Reconcile: Enter the General Ledger account number that represents the bank account you are reconciling or click the "Find" button to select from the look up table.
- Do not show transactions dated on or after: Enter a date here to eliminate any activities from showing that are beyond the one provided. Use caution as some activities required to reconcile may have been dated beyond the statement cut off which is commonly used here.
- Statement Date: Enter the statement date being reconciled.
- Save: Click this button to save to this computer. Refer to GENERAL FILE for more information.
- Cancel: Click "Cancel" to cancel and return to the previous screen.
The "Checks" tab
- Reconcile: Review the check number detail lines with your bank statement and check off those checks that appear that have cleared on a statement.
- Mark all: Mark all checks as Reconciled.
- Clear all: Un-mark all checks.
- Save: Click this button to save to this computer. Refer to GENERAL FILE for more information.
- Finish Later: Click this button if you would like to save your work and finish reconciling at a later time.
- Report: Click this button to choose an output option for a report of what you've just done.
- Cancel: Click "Cancel" to cancel and return to the previous screen.
The "Deposits (Bank Credits)" tab
- Reconcile: Review the Deposits with your bank statement and check off those Deposits that appear that have cleared on a statement
- Mark all: Mark all Deposits as Reconciled.
- Clear all: Un-mark all Deposits.
The "Withdraws (Bank Debits)" tab
- Reconcile: Review the Withdrawals with your bank statement and check off those Withdrawals that appear that have cleared on a statement.
- Mark all: Mark all Withdrawals as Reconciled.
- Clear all: Un-mark all Withdrawals.