To reconcile your bank transactions you must import your bank data into Sage 200.
We recommend that you import transactions in the bank file, up to the end of the previous day. This makes sure you include a complete record of transactions when you import your bank file.
You can match the transactions automatically or manually. We recommend you use the automatic options, for the majority of your transactions. You can then use the manual option for the rest.
There are two stages to the electronic reconciliation process:
Confirm.
This saves the matched transactions. You can view and change the status of these transactions, and also how they are matched.
Reconcile.
This completes the reconciliation process and changes the status of the transactions to reconciled.
If you need to change an existing a Cash Book transaction, you must switch off e-banking on the bank account. Then you must use manual reconciliation.
You must have:
Open: Cash Book > Period End Routines > Bank Reconciliation.
Enter the Statement End Date and Statement End Balance. These are in your electronic banking software.
The Statement End Date and Statement End Balance can be amended after you import your bank file. From the file menu on the Reconciliation window, select Tools > Amend Bank Statement Details.
To import transactions select File > Import Bank Transactions.
Note: If you import a file with half a day's transactions, any transactions from the rest of that day will not be included on subsequently imported files. If this happens, you will need to delete all the imported transactions for that day and import the file again.
Select the bank file you want to import from the list displayed, and click Open. The bank information is displayed.
To limit the transactions displayed, enter a date in the Bank Transactions to box and Sage Transactions to box.
When reconciling you will see several values. They show the following:
|
Book Balance at Date |
This is the trial balance in the Cash Book. |
|
Statement End Balance |
This is the balance on your bank statement. |
|
Difference |
This is the difference between the transactions you have reconciled and the Statement End balance. As you match each transaction, the Difference reduces to zero, if all transactions are correctly matched. If there are no bank charges or interest in the imported file, that have not been entered on the Cash Book, you will need to add these separately. |
|
Automatic |
You can match transactions by amount (Match Amounts), by reference (Match Refs), or both (Match Full). The transactions will update to show the matches. If several possible matches are found, a Duplicate Transaction window appears for you to make the final selection. |
|
Manual |
Select a transaction from the Bank transactions list and the matching one from the Sage transactions list. Then click Match Manual. |
To save the matches made, click Confirm. The Conf column updates to confirm matched transactions.
Note: This is done for you if you have chosen to Automatically confirm Manual Matches when setting the matching facility.
Other tasks
Amend transactions from the imported bank file
Delete transactions imported from the bank file
Reference