Reconcile using bank feeds

Find this screen

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

Open: Cash Book > Bank Account List and click Bank Feeds.

How to

Reconcile using bank feeds

Use Bank Feeds Reconciliation to download transactions from your online bank account and compare them to transactions posted to your bank account in Sage 200cloud.

  1. Download your bank transactions using the bank feeds service.
  2. Match your transactions using automatic or manual matching.
  3. Save your matched transactions as a draft, or continue to reconcile.

Before you begin

You must have:

  • Set up bank feeds to connect your bank account with a bank account in Sage 200cloud.

    See Set up Sage bank feeds.

  • To allow a user to download and reconcile transactions, ensure that they have access to Bank Feeds Download Transactions and Bank Feeds Reconciliation.

    See User access for Sage bank feeds.

Download transactions

First you will need to download transactions from your bank.

If you are not sure when you last downloaded transactions, you can see the date of the last import and the number of transactions that were downloaded.

  1. Select the Bank Account, if you haven't already.
  2. Select Download Transactions.
  3. For the first time you download transactions, enter the date of the earliest transactions you want to download from your bank, then click OK.

    We recommend you enter the day after your last bank reconciliation date. This means you don't import transactions that you've already reconciled.

Approve transactions for bank feeds rules

If you use bank feeds rules and have chosen to Review transactions before posting, the next time you download transactions for this account, you will be asked to approve any transactions that will be created by your bank feeds rules.

You can also approve transactions at any time by using Bank Feeds Approval.

Open: Period End Routines > Bank Feeds > Bank Feeds Approval.

  • Choose the Bank to display transactions for. You can only select a bank that's been enabled for bank feeds.
  • The list displays transactions that will be created in Sage 200cloud according to your bank feeds rules.

    You can see which Rule is linked to the transaction, details of the transaction, and the transaction Type, such as a Customer Receipt or Nominal Payment with VAT.

  • To create transactions, select the transactions and click Approve.
  • If you don't want to create transactions, select those transactions and click Reject.
  • If you want to check the rule, click the link for the Rule column.

For information on setting up bank feeds rules, see Bank feeds rules.

What happens next?
  • If you approve transactions, the transactions will be created for you in Sage 200cloud, and they will be displayed as Matched transactions in bank feeds reconciliation.
  • If you reject transactions, the transactions will not be created, and you will not be asked about these transactions again. You can then deal with these manually in bank feeds reconciliation.
  • You will be notified if any of the approved transactions cannot be created from your bank feeds rules. See View failed transactions.

Reconcile bank transactions

To reconcile transactions, match the transactions downloaded from your bank to the transactions from Sage 200cloud.

  1. To match the transactions:
    • Use the Auto Match to get started, then manually match any remaining transactions.
    • To manually match transactions, select individual transactions or a group of transactions from your bank and from Sage (in the top lists), then select Match to mark them as matched.

      The matched transactions are then moved to the lower list, so you can easily see what's been reconciled and what's still to do.

  2. When you have finished matching, confirm the matches before you reconcile.
    • If you don't want to complete the reconciliation yet, select Confirm Matches to save your matched transactions as a draft reconciliation.
    • If you want to complete the reconciliation, select Confirm and continue to reconcile. Your matched transactions will be displayed in the Bank Reconciliation screen, where you can complete the reconciliation.

Auto match transactions

You can automatically match your bank transactions with your Sage 200cloud transactions. You can use this first to match most of the transactions, and then use manual matching to add or change anything before you finish the reconciliation.

To auto match transactions:

  1. Select Auto Match.
  2. Pairs of individual matching transactions will be added to the Matched transactions list, based on the following:

    • Date: The transaction dates must be within 4 days of each other.
    • Amount: The transaction values must be identical.
    • Type: The type of transaction must be the same; payments can only match other payments, and receipts can only match other receipts.

    Note: A transaction will not be matched if there is more than one possible match, or it must be matched against multiple transactions.

Manually match transactions

You can manually match transactions instead of, or after, using automatic matching.

Use manual matching if any single transaction needs to be matched against multiple transactions, or you need to part reconcile a transaction.

To match transactions:

  1. Select the transactions to match.

    • You can select more than one transaction in a list, for example one bank transaction could be linked to several in Sage 200cloud.
    • You can see a running total of the selected transactions in the Match difference box.
    • If you don't want to reconcile the full amount of the transaction, you can part reconcile the transaction by entering the Amount to Reconcile.
    • You can't select Sage transactions if:

      • The transaction has been queried. These transaction will include a Query description.
      • The transaction is included in a draft reconciliation. The transaction Status will show the name of the draft reconciliation.
  2. Click Match to move the selected transactions down to the Matched transactions list.

    Note: You can only match the transactions when the Match difference is zero.

  3. When you've finished matching all the transactions, click Confirm Matches.

Unmatch a transaction

To remove transactions from the Matched transactions list at the bottom:

  • Select the transaction to unmatch, then click Unmatch.

    Tip: You can select a transaction from either your bank (left) or from Sage (right). The other transactions included in the match are highlighted.

Add a new transaction

When comparing your transactions, you may find a bank transaction on your statement that has not been posted in Sage 200cloud. For example, this could be for bank charges or interest paid or received, or for transactions that you have missed. You can enter the details of the transaction that's on your bank statement but not yet entered into Sage 200cloud.

  1. From the Transactions from your bank list, select the bank transaction(s) that you want to create a transaction for in Sage 200cloud.
  2. Select the type of transaction to post from the Add transaction of type drop-down list.

    The type of transaction that's available will depend on the bank transaction you select.

  3. Enter the details.
  4. Save the transaction.

    • Click Save.

      If the new transaction amount matches the original bank transaction, the transactions are added to your Matched transactions.

    • Click Save & Create Rule, if you also want to set up a bank feeds rule that will create this transaction for you automatically in the future. See Bank feeds rules.

Reconcile part of a transaction

If you don't want to reconcile the full amount of the transaction, you can part reconcile the transaction by entering the Amount to Reconcile for the transaction, before you match it.

The remaining amount of the transaction can be reconciled the next time you do your bank reconciliation.

The transaction will be marked with a status of Part, to indicate it has been part reconciled.

Ignore a transaction

If you download transactions from your bank that you don't want to appear in the list, you can use Ignore to permanently remove them. You might want to do this if the list contains transactions that have already been reconciled, or duplicate transactions.

  1. From the Transactions from your bank list, select the bank transaction(s) that you want to remove.
  2. Click Ignore.

Find a transaction

To locate a specific transaction in any list:

  1. Right-click in the list section.
  2. Choose Find.
  3. Enter the text to search for in the Find field.
  4. Choose the column to search from the In column list.
  5. Choose whether to match the Start, Any or Whole text.

Show transactions in a date range

Only transactions for the current month are displayed by default, so if you want to see more transactions then you can change the date range.

To filter the transactions list by date, enter the date range in Show transactions from - To.

Save matched transactions as a draft

If you are part way through reconciling your statement, you can save a draft and continue later.

To save a bank reconciliation draft:

  1. Click Confirm Matches.
  2. Add a description so that you can identify this reconciliation.
  3. Click Save.

When you reconcile the bank account using Bank Reconciliation, you will be able to select the draft reconciliation and it will contain your matched transactions.

Reconcile matched transactions

If you want to complete the reconciliation:

  1. Select Confirm and continue to reconcile.
  2. Your matched transactions will be displayed in the Bank Reconciliation screen, where you can complete the reconciliation.

When the reconciliation is complete, the transactions are marked as reconciled, so they will not appear in a future reconciliation.

Open a saved draft reconciliation

If you have an incomplete reconciliation saved as a draft, you can resume it at the point you left off.

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

  1. Select the bank account.
  2. If the bank account has a saved draft reconciliation, they will be displayed.

    Select the draft reconciliation record from the list.

  3. Click Recall.
  4. Continue your statement reconciliation from the point you saved it.

Useful info

Tips for bank feeds reconciliation

Set up Sage bank feeds

Before you can download and reconcile your bank transactions, you must set up Sage bank feeds to connect your bank account with a bank account in Sage 200cloud.

Set up bank feeds rules

When you use Bank Feeds Reconciliation to reconcile your bank account, you may find that some bank transactions that were downloaded from bank feeds do not have equivalent transactions in Sage 200cloud.

If these transactions are regular or frequent, then instead of adding individual transactions each time that you reconcile, you can set up a bank feeds rule to automatically create these transactions in Sage 200cloud for you.

This saves you time entering transactions, and helps you reconcile your bank accounts more efficiently and reduce errors.


Fix it

Some transactions are missing

If you think a transaction is missing from the lists, this may be because:

  • The transaction is not in the current date range. Only transactions for the current month are displayed by default, but you can change this by entering a date range in Show transactions from - To.
  • The transaction has already been reconciled.
  • The transaction is not included in the date range selected in Show transactions from - To.
  • The bank transaction has already been matched in a saved draft reconciliation.
  • The Sage transaction was not posted to this cash book bank account. You can check this using the Bank Transaction Enquiry.
  • Recent bank transactions may have not been downloaded. Check the last import date, and download transactions if required.

Unreconcile a transaction

If you've reconciled a transaction by mistake, you can unreconcile it using the Unreconcile Bank Transactions screen.

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

Note: When you unreconcile, the Sage transaction will be marked as unreconciled, but the matched bank transaction will not reappear for bank feeds reconciliation. To reconcile this bank transaction, use the Bank Reconciliation screen instead.

I've over reconciled a transaction

If you have over reconciled a transaction, then you need to unreconcile it. See Unreconcile transactions.

Note: You will be warned if you enter an Amount to Reconcile that is greater than the transaction value.