Reconcile using e-Banking

Find this screen

Open: Period End Routines > Bank Reconciliation > Bank Reconciliation.

How to

Set the Statement date and balance

Open: Period End Routines > Bank Reconciliation > Bank Reconciliation.

  1. Select bank account from the Account selection list.

  2. Enter the Statement End Date and Statement End Balance and click OK. This should match the balance and end date of you imported statement.

If you need to change this, go to Tools > Amend bank statement details.

Import the bank file

  1. Go to File > Import Bank Transactions.
  2. Browse to the folder that holds the bank file.

  3. Select the file you want to reconcile and then click Open.

    The transactions in the file are displayed in the top section.

    The transactions in Sage 200cloud are displayed in the bottom section.

Reconcile using automatic matching

This checks the imported transactions and matches them to the transactions in Sage 200cloud.

Selected transactions are highlighted in yellow

Matched transactions are highlighted in green.

  1. To match the amounts for all transactions:
    1. Click Match amounts.
    2. All transactions with matching amounts are highlighted.
    3. If there's more than one transaction of the same amount, choose the one to match.
  2. To match the amounts for selected transactions:
    1. Go to Tasks > Match amounts > Selected transactions.
    2. All transactions with matching amounts are highlighted.
    3. If there's more than one transaction of the same amount, choose the one to match.
  3. To match the references for all transactions:
    1. Click Match Refs.
    2. All transactions with matching references are highlighted.
    3. If there's more than one transaction with the same reference, choose the one to match.
  4. To match the references for selected transactions:
    1. Go to Tasks > Match Refs > Selected transactions.
    2. All transactions with matching references are highlighted.
    3. If there's more than one transaction of the same reference, choose the one to match.
  5. To match the references and amounts for all transactions:
    1. Click Match Full.
    2. All transactions with matching references and amounts are highlighted.
    3. If there's more than one transaction with the same reference and amount, choose the one to match.
  6. To match the references and amounts for selected transactions:
    1. Go to Tasks > Match Full > Selected.
    2. All transactions with matching references and amounts are highlighted.
    3. If there's more than one transaction with the same reference and amount, choose the one to match.
  7. Click Confirm to save the matches you have made.
  8. To ignore all confirmed and matched transactions and restart the reconciliation, click Discard.
  9. When you have finished matching transactions click Reconcile.

Tip: We advise you to use both methods. Use the automatic matching first to match the bulk of the listed transactions then manually match any remaining transactions.

Reconcile using manual matching

You choose an imported transaction and match it to a transaction in Sage 200cloud.

Selected transactions are highlighted in yellow.

Matched transactions are highlighted in green.

  1. Select a transaction from each table.
  2. Click Match Manual.

  3. Click Confirm to save the matches you have made.
  4. To ignore all confirmed and matched transactions and restart the reconciliation process, click Discard.
  5. When you have finished matching transactions click Reconcile.

Tip: We advise you to use both methods. Use the automatic matching first to match the bulk of the listed transactions then manually match any remaining transactions.

Unreconcile an imported transaction

When you reconcile the bank account, the transactions in the imported file are marked as reconciled, so they are not displayed again. To unreconcile a transaction, you change this status.

You can also mark an imported transaction as reconciled

  1. Go to Tools > Amend Bank Transactions.

  2. Select the transaction to be changed and click Reconcile or Unreconcile where appropriate.

  3. Click Save.

Remove processed dates

Once you've imported a file of bank transactions, you can't import another file with transactions for the same date. If you need to re-import your transactions because there are some missing from your import file for example, you'll need to delete these stored dates.

  1. Open Tools > Remove Processed Dates.

  2. Enter the date range for the transactions you want to remove.

  3. Click OK.

Set a discard date

When you import a file, you can choose not to display transactions before a certain date.

If you're never going to need these transactions, you can also choose tor remove them from the import file.

  1. Open 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.

Choose how to match transactions

If you're using automatic matching, you can choose whether to match imported transactions with those in Sage 200cloud or vice versa.

  1. Open Tools > Options.
  2. Select the required Match Mode.
  3. To skip the confirmation stage of reconciliation, select Automatically confirm Manual Matches.

Clear confirmed matches

  1. Open Tools > Tasks > Confirm or Tools > Tasks > Unconfirm
  2. Choose whether to change this for All or Selected transactions.

Clear selected transactions

  1. Open Tools > Tasks > Clear Selections.
  2. Choose whether to clear All or Selected transactions.

Useful info

Using e-Banking to reconcile your bank statements - key facts

  • You must use e-Banking software that is compatible with Sage and provides a bank reconciliation service.

  • You import the information from your bank using a compatible file. This is usually in CSV format.
  • You can't add any transactions to Sage 200cloud when you reconcile electronically.

  • You can't save a draft reconciliation.
  • When the bank file is imported, Sage 200cloud notes the date of the transactions and won't show transactions with the same date from another file. This is to prevent you importing and reconciling the same transactions twice.
  • We recommend when you create the bank file that you include in it transactions up to the end of the previous day.

    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'll l need to delete all the imported transactions for that day and import the file again.

  • If you need to change a transaction in Sage 200cloud, you must switch off e-Banking on the bank account and then use manual reconciliation.


Set up e-Banking

Before you can reconcile your bank statement this way, you must set up e-Banking for your company and the bank account in Sage 200cloud.

See How to set up e-Banking.


Fix it

Some imported transactions are not showing

This may be due to the following:

  • The discard date.

    If the transaction is dated before the Discard date, it won't be displayed. Go to Tools > Set discard date to change this.

  • The Bank transactions up to date.

    If the transaction is dated after this date, it won't be displayed. You can change this date if you need to.

  • Transactions have been removed from the import file.

    If you've chosen to delete transactions dated before the Discard date, they are removed from the import file. If you Remove the processed dates (Tools menu), you can re-import the file.

  • If you've already imported transactions for that date.

    Transactions for the same date can't be imported in two separate files. If you Remove the processed dates (Tools menu), you can re-import the file.

  • The transaction has already been reconciled.

    To unreconcile a transaction in the import file, go to Tools > Amend transactions.

Some Sage 200cloud transactions are not showing

This may be due to the following:

  • The Bank transactions up to date

    If the transaction is dated after this date, it won't be displayed. You can change this date if you need to.

I reconciled a transaction by mistake

It is easy to unreconcile a previously reconciled transaction; see:

Why don't my statement balances match up?

We recommend that you check the following:

  • Opening Balance - Check this is the same as the opening balance on your bank statement.
  • Statement End Balance - Check that this is the same as the end balance on the bank statement.
  • Bank transactions to and Sage transactions to - Check this is correct. Try changing the dates to see if any missing transactions appear.
  • Matched transactions - Make sure all the matched transactions appear on your bank statement. You may have accidentally flagged a transaction as reconciled - especially if it is on the same date, or has the same amount as another transaction.
  • Transaction values - Make sure all matched transaction values match the values on your bank statement.

If you can't find out what's causing the difference we recommend that you cancel the reconciliation and start again.

Bank reconciliation can be a lot harder if your company processes lots of transactions. If that is the case for your business, it might be worth reconciling more often. The fewer transactions you have to work through, the easier it will be to spot what is wrong.