| | Create and manage automated Bank feeds transactions |
| 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: 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.
Manage rules - Click Bank accounts, select the relevant bank account.
- Click Bank feeds then click Manage rules.
- Choose one of the following options:
- View - to show more details about a rule
- Edit - to make changes to the rule
- Delete - to delete the rule
- If you don't want to review transactions posted using this rule, you can clear the Review transaction before posting check box.
- Click Close.
Set up a Bank Feeds rule - Open the Bank feeds window and download transactions.
- Match the bank feed transaction(s) with the relevant Sage transactions.
TIP: Once matched, the transactions will appear in the Matched tab. - Select the transaction you want to create a rule for and click the Create rule link
 - 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 approval, 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 the Confirmed tab in your bank feed. 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 are removed from the approval screen.
Manage rules - Click Bank feeds.
- Next to the required bank account click Open.
- Click Manage rules.
- Choose one of the following options:
- View - to show more details about a rule
- Edit - to make changes to the rule
- Delete - to delete the rule
- If you don't want to review transactions posted using this rule, you can clear the Review transaction before posting check box.
- Click Close.
[BCB:99:Limitless - 50 Accounts - Bank:ECB] |
|
