Create and manage automated Bank feeds transactions

Summary

How to set up and manage Bank Feeds Rules to automatically post bank transactions in Sage 50 Accounts.

Description

This guide explains how to set up and use Bank Feeds Rules. If it doesn't answer your question, you can find further help in our Banking Help Centre >

With Bank Feeds Rules it's easy to automate your regular bank transaction postings, reducing the time you spend processing. As you match transactions in Bank feeds, if you match a transaction that you know occurs on a regular basis, you can quickly create a rule to post future ones automatically. Simple.

Resolution

Before you start

If you haven't already, you need to Set up your bank feed
If you use Sage 50 Accounts v27 and are using Remote Data Access, make sure you're at the main site. You can check your software version in Help, About

TIP: You cannot create a bank feed rule for bank transfers or foreign bank accounts.

Select your version below for more information:

Version 29.0 or below >

Set up a Bank Feeds rule

Open the Bank feeds window and download transactions.
Select the transaction you want to create a rule for and either Match or Create a transaction.
Select the transaction in Matched transactions then click Create rule.
TIP: If you don't want to approve every transaction separately, you can clear the Review transactions before approving check-box in the bottom left corner of the window.
In Give your rule a name, enter a new name for the rule.
Set one or more conditions that will be used to identify future transactions to automate:

The Reference is shown against the transactions from your bank
If the Amount can vary, don't include the amount as a condition

Click Add.
Enter the details to use when the transaction is automatically posted, such as nominal code and details such as department and tax code.
Click Add, click Save Rule, then click OK.

You've now set up a Bank feeds rule, by default you will need to approve the automated transactions, however, you can turn this off in Manage rules.

NOTE: New rules will only apply to feeds downloaded after the rule has been created, they are not retrospective.

CAUTION: If you need to disconnect and reconnect Bank Feeds, all rules are lost and need to be re-created.

Approving transactions

If you have Bank feed transactions that need approving, when you open Sage 50 Accounts you're prompted to approve them.

To do this straight away, click Yes. Alternatively you can click No and review them later in Bank accounts by clicking Bank feeds approval.

If you want to, enter a Date range to filter the transactions.
Select the transactions you want to approve, then click Approve.
To reject any transactions, select the transactions then click Reject.
Click OK.

That's it. Approved transactions will appear in the Transactions in Sage pane in Bank Feeds and are posted to the audit trail.

Rejected transactions are returned to the transaction pane in Bank feeds and be removed from the approval screen.