Reconciling bank accounts with bank statements
Important!
When your cursor is in the grid area of the 1-5 Bank Reconciliation window, no function keys except F1 are available. You may launch the calculator (F3) after displaying the 1-5 Bank Reconciliation window by clicking in the Statement Cutoff Date text box and then pressing F3.
Before you reconcile a bank account with a bank statement, enter any extra charges or income in 1-3 Journal Transactions that appear on your bank statement that you have not already entered in Sage 100 Contractor. These include automatic transfers, interest, or check charges. To maintain accurate records, it is a good idea to reconcile accounts each month when you receive the bank statements.
If you need to clear a majority of the transactions, it might be easier to clear all transactions and reopen only the items that do not appear on your bank statement. Select all items, and then click the Clear button. Then you can reopen individual items by selecting the item and clicking the Open button.
To reconcile a bank account with a bank statement:
|
1
|
Open 1-5 Bank Reconciliation. |
|
2
|
In the Account# box, enter the bank account number. |
|
3
|
In the Statement Cutoff Date box, enter the statement ending date. |
|
4
|
Click the Display button. |
|
5
|
For each item you want to clear, select the item and click the Clear button. |
|
6
|
Compare the amount displayed in the Statement Ending Balance box to the ending balance on the statement. |
|
7
|
If the amount in the Statement Ending Balance box does not match the ending balance on the bank statement, you need to determine the cause of the discrepancy and correct the problem. |
|
8
|
On the File menu, click Save. |
Important! To save a copy of the Reconciliation report for future reference, make sure the Create PDF of the report file check box is selected before you click [Final]. If check box is cleared before you click Final, a report is not created. You cannot go back and perform the reconciliation again to create the same report.
|
9
|
On the Save Bank Reconciliation window, do one of the following: |
|
a
|
If you are not finished reconciling the account, click the Trial button. How? |
|
b
|
If you are finished reconciling the account, click the Final button. |
Note: A P displayed with a transaction in the Record# column indicates that the transaction is from a prior year.