Import and reconcile statement

Find this screen

Open: Cash Book > Bank Account List > Bank Reconciliation

Configure your options

Set a discard date

This prevents imported transactions before a certain date being displayed.

  1. Choose Tools > Set Discard Date.
  2. Enter the required date. All transactions dated before the discard date will not appear in the bank transactions list when the bank file is imported.
  3. To delete all bank transactions before the discard date, select the Delete Discarded Data check box.

Choose how to match transactions

Here you can choose whether to the use transactions entered in Sage 200 or the imported transactions as the basis for matching.

  1. Choose Tools > Options.
  2. Select the required Match Mode.
    • Match each Bank transaction to transactions in the Sage list.

      Each transaction in the bank statement is selected in turn and the Sage statement is searched for matching transactions. This is the default setting.

    • Match each Sage transaction to transactions in the Bank list.

      Each transaction in the Sage statement is selected in turn and the bank statement is searched for matching transactions.

  3. Choose how you want to deal with manual matches.
    • To skip the confirmation stage of reconciliation ensure the Automatically confirm Manual Matches check box is selected.
    • If you want to confirm manually, clear the Automatically confirm Manual Matches check box.

Import and reconcile the statement from your bank

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 Cash Book transaction, you must switch off e-Banking on the bank account. Then you must use manual reconciliation.

  1. Select the bank account.
  2. 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.

  3. Click OK.
  4. 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.

  5. Open the folder containing your bank file.
  6. 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 total of all the unreconciled transactions to the current statement date.

    Note: The value will be 0.0 (zero) if there are no unreconciled transactions.

    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 bank charges or interest in the imported file, that have not been entered on the Cash Book, you will need to add these separately.

  7. Match the transactions using one of the following methods. We recommend that you use both the automatic and manual matching options.
  8. 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.

  9. 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.

  10. To ignore all confirmed and matched transactions and start again, click Discard.
  11. To complete the reconciliation process, click Reconcile.