Select the Reconciliation operation (click it or press letter R).
Select the bank account to be reconciled (double-click it or select it, with a single click or by moving the cursor with the display keys, then press Enter key).
Type in the bank statement date.
| The default date is the current date. If this is the bank statement date, click OK button. |
| If not, change any of the three parts of the date using the + and - keys or by typing the numbers, or click the down arrow to the right to display a calendar and select a date. |
| Use the left arrow and right arrow keys to move the cursor within the field. |
| Click OK button. |
The reconciliation is displayed, with cursor on first unreconciled line.
Use the mouse or the display keys to browse the record.
For reconciliation purposes, cheques (-) and deposits (+) dated on or before the bank statement are listed together to make it easier to compare it to the bank statement.
Note: journal entries are automatically reconciled when posted.
Purpose of reconciliation:
| A bank reconciliation serves to verify the accuracy of the Deposit and Cheque account by checking them against an outside source. |
Note: we recommend recording bank charges using the Cheque operation.
Reconciling a transaction
| Click the last field at the end of the line or press / key to reconcile the line where the cursor is. |
| A check mark appears at the end of the line. |
| The total of unreconciled cheques or the total of unreconciled deposits and the bank statement balance change. |
| The document reconciled total increases. (when this total is equal to the document total, the total amount has been reconciled) |
| Press Enter key to move to the next line. |
Unreconciling a transaction
| Click the check mark at the end of the line or press / key to unreconcile the line where the cursor is. |
| The check mark at the end of the line is removed. |
| The total of unreconciled cheques or the total of unreconciled deposits and the bank statement balance change. |
| The document reconciled total decreases. (when this total is equal to zero, the total amount has been unreconciled) |
| Press Enter key to move to the next line. |
Close
| Close the dialog. |
NOTE: Your changes are preserved whether you dismiss the dialog by clicking either the 'X' or the Close button.
| Displays the bank reconciliation report, which can be exported to excel, print previewed or printed. |
Export to excel
| Export the bank reconciliation report to an excel file. |
| The default file name <enterprise Prefix>_Reconciliation_<bank account name>, ex: A_Reconciliation_Bank. |
Print preview
| Display the preview window to check the layout the bank reconciliation report before printing. |
| Print the bank reconciliation report. |
Close
| Close the dialog. |