Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

If you have transactions that regularly appear in your bank feeds, you can set up rules to automatically create matching transactions in AccountRight, or to help match payments to invoices and bills.

Rules search for a word or phrase in your bank feed and, when found, an AccountRight transaction is suggested as a match, or created and matched, ready for you to approve. You can make the search as simple or as complex as you need.

The type of rule you apply, and the way the rule works depends on the type of transaction.

UI Text Box
sizemedium
typenote

Recurring transactions

Recurring transactions have pre-defined amounts that might not match the bank feed amount. We don't recommended using rules for recurring transactions that come through the bank feed.

 

There are three types of rules you can create:

RuleDescription

Transaction

Use transaction rules when you receive or pay money that is not for an invoice or bill you’ve recorded in AccountRight. A transaction rule can create a transaction and allocate the transaction amount to one or more accounts, jobs or tax codes.

Say you regularly buy stationery from a business called Office Supplies, you can create a transaction rule, so that each time a transaction from Office Supplies comes through in your bank feed, a matching transaction is automatically created and matched in AccountRight.

You can create similar rules for utility payments, rent, petrol purchases or other Spend Money or Receive Money transactions.

Invoice

Use invoice rules to help match customer payments to the invoice they relate to. When the rule is applied in AccountRight, a list of possible invoice matches are provided, all you need to do is select the correct one and approve it.

Bill

(Not Basics) If you record purchases in AccountRight, you can use bill rules to match payments to the bills they relate to. When a payment appears in the feed, and the rule is applied, a list of possible bills are provided, so you can easily match it to the correct supplier and bill.
UI Expand
titleTo create a transaction rule

To create a transaction rule

  1. Anchor
    1387209
    1387209
    Go to the Banking command centre and click Bank Feeds. The Bank Feeds window appears.
  2. Select the bank statement transaction that you want to create the rule for and click New > Transaction Rule. The New Rule window appears.

    Note that the rule automatically contains the description from the bank feed transaction.
  3. Choose whether to apply the rule to one selected account, or all bank feeds accounts.
  4. Specify the rule conditions using one or more of the following fields. If you enter conditions in both the description and dollar amount areas, all conditions must be met for the rule to be applied. Separate each word, phrase or amount with a comma. For more information and examples, see Search options.

    this exact word or phrase

    Enter an exact word or phrase that the bank transaction description will contain. If the exact text is found in the bank feed transaction’s description, the rule will be applied.

    and/or any of these wordsEnter one or more words or phrases that the bank transaction description might contain. If one of the words or phrases is found in the bank transaction, the rule will be applied.
    equals one of the followingIn AccountRight 2019.3 and later, you can enter one or more amounts for the bank transaction. If a bank transaction for that amount is found, the rule will be applied.
  5. Enter the allocation details. Click Show advanced options if you want to:
    • allocate to more than one account, job or tax code
    • enter a Memo for the transaction
    • select a Card for the transaction
    • (AccountRight 2019.3 and later, Australia only) select Reportable Payment to automatically mark the transaction as reportable. Learn more about Reporting taxable payments.
  6. Click OK. The Bank Feeds window reappears. The rule you have created is applied to the bank feed transaction.
    Bank feed transaction with rule applied
    The next time a bank feed transaction appears matching the rule conditions you have selected, the rule will be automatically applied.
  7. Click the refresh icon ( circular green arrow ) to update the Bank Feeds window. This will apply the rule to any applicable unmatched transactions.
UI Expand
titleTo create an invoice rule

To create an invoice rule

  1. Anchor
    1387233
    1387233
    Go to the Banking command centre and click Bank Feeds. The Bank Feeds window appears.
  2. Select the bank statement transaction that you want to create the rule for and click New > Invoice Rule. The New Invoice Rule window appears.

    Note that the rule automatically contains the description from the bank feed transaction.

    UI Text Box
    sizemedium
    typetip

    If a lot of your customers transfer their payment directly to your account, ask them to add their name or customer reference number to their internet banking transfer, to help with the matching process.

  3. If you have bank feeds set up for more than one bank account, choose whether to apply the rule to all accounts or just one account.

  4. Specify the rule conditions using one or more of the following fields. If you enter conditions in both the description and dollar amount areas, all conditions must be met for the rule to be applied. Separate each word, phrase or amount with a comma. For more information and examples, see Search options.

    this exact word or phrase

    Enter an exact word or phrase that the bank transaction description will contain. If the exact text is found in the bank feed transaction’s description, the rule will be applied.

    and/or any of these wordsEnter one or more words or phrases that the bank transaction description might contain. If one of the words or phrases is found in the bank transaction, the rule will be applied.
    equals one of the followingIn AccountRight 2019.3 and later, you can enter one or more amounts for the bank transaction. If a bank transaction for that amount is found, the rule will be applied.
  5. Select the customer you want to create the rule for. When the rule is applied, all open invoices for this customer will be found.
  6. Click OK. The Bank Feeds window reappears. The rule you have created is applied to the bank feed transaction and the Possible invoice match link appears.
    Bank feed transaction with rule applied and link for possible invoice match
    The next time a bank feed transaction appears matching the rule conditions you have selected, the rule will be automatically applied.
  7. Click the refresh icon ( circular green arrow ) to update the Bank Feeds window. This will apply the rule to any applicable unmatched transactions.
UI Expand
titleTo create a bill rule (Not Basics)

To create a bill rule (Not Basics)

  1. Anchor
    1431544
    1431544
    Go to the Banking command centre and click Bank Feeds. The Bank Feeds window appears.
  2. Select the bank statement transaction that you want to create the rule for and click New > Bill Rule. The New Bill Rule window appears.

    Note that the rule automatically contains the description from the bank feed transaction.

    UI Text Box
    sizemedium
    typetip
    If you use AccountRight’s electronic payment features, you can enter default bank statement information in the supplier’s card (Card Information window > Payment Details tab). Or, you can enter a description in the Statement Text field when recording a bill payment in AccountRight. 
  3. Choose whether to apply the rule to one selected account, or all bank feeds accounts.

  4. Specify the rule conditions using one or more of the following fields. If you enter conditions in both the description and dollar amount areas, all conditions must be met for the rule to be applied. Separate each word, phrase or amount with a comma. For more information and examples, see Search options.

    this exact word or phrase

    Enter an exact word or phrase that the bank transaction description will contain. If the exact text is found in the bank feed transaction’s description, the rule will be applied.

    and/or any of these wordsEnter one or more words or phrases that the bank transaction description might contain. If one of the words or phrases is found in the bank transaction, the rule will be applied.
    equals one of the followingIn AccountRight 2019.3 and later, you can enter one or more amounts for the bank transaction. If a bank transaction for that amount is found, the rule will be applied.
  5. Select the supplier you want to create the rule for. When the rule is applied, all open bills for this supplier will be found.
  6. Click OK. The Bank Feeds window reappears. The rule you have created is applied to the bank feed transaction and the Possible invoice match link appears.
    Bank feed transaction with rule applied and link for possible bill match
    The next time a bank feed transaction appears matching the rule conditions you have selected, the rule will be automatically applied.
  7. Click the refresh icon ( circular green arrow ) to update the Bank Feeds window. This will apply the rule to any applicable unmatched transactions.
UI Expand
titleTo edit a rule

To edit a rule

  1. Anchor
    1387250
    1387250
    Go to the Banking command centre and click Bank Feeds. The Bank Feeds window appears.
  2. Click Manage Rules. The Manage Rules window appears.
  3. Select a rule and click Edit.
  4. In the window that appears, make the changes to the rule and click OK. The Manage Rules window reappears.
  5. Click Close. The Bank Feeds window reappears.
  6. Click the refresh icon ( circular green arrow ) to update the Bank Feeds window with the changes. 
UI Expand
titleTo delete a rule

To delete a rule

Deleting a rule doesn't affect any transactions where the rule has been applied.

  1. Anchor
    1387261
    1387261
    Go to the Banking command centre and click Bank Feeds. The Bank Feeds window appears.
  2. Click Manage Rules. The Manage Rules window appears.
  3. Select a rule and click the delete icon ( rubbish bin icon with green circular arrows ). The rule disappears from the Manage Rules window.
  4. Click Close. The Bank Feeds window reappears.
  5. Click the refresh icon ( circular green arrow ) to update the Bank Feeds window with the change. 
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

How bank feeds can work for you

Set up bank feeds

Approving a bank feed

Search options

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max10
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=bank+feed+rules&filter=labels%2Clocation%2CsolvedThreads%2CincludeForums&include_forums=true&location=category%3AAccountRight&search_type=thread&solved=true

HTML Wrap
classmorelinks

More »