Transaction Matching Rules

If you have transactions that reoccur on a regular basis, then you may enjoy REI Hub's Rules feature.  Rules help the system recognize newly imported transactions by matching to either a part of the description or the exact amount of the transaction and then assigning the property and accounts you have specified.  

Some key things to know about Transaction Matching Rules in REI Hub:
  • Rules are currently available for Revenue, Expense, Fixed Asset Purchase, and Transfer Between Accounts transactions.  You can also automate splitting transactions with rules. Other transaction types may be supported in the future.  
  • You can optionally ask the system to book transactions that match your rule automatically.  If you do so, all existing and future matches in your import feed will automatically be booked on your behalf.  So make sure your rule is specific enough!
  • Uncheck the box if you do not want transactions to be automatically booked on your behalf.  When you click 'Book' on the transaction from the Import Feed, you will see the Rule match. You need to click through and confirm to complete booking the transaction. 

To add a new Rule from an imported transaction:

1) Navigate to the Import Feed and click Book on an imported transaction

Find the Import Feed under the Transactions header of the left-hand side menu.

After clicking Book, fill out the property and relevant accounts as appropriate. If this is a recurring transaction that will be booked to the same property and accounts again in the future, you will: 

2) Check the box at the bottom to 'Create a new transaction matching rule.'

3) Choose how to set up your rule

To match by description:

  • Check 'Match by description' 
  • Choose part or all of the description of the imported transaction to base your match on. Make sure that your choice, such as a business name or account number, will be the same every time. 
  • Click Save at the bottom.
To match by amount:

  • Check 'Match by amount'. The exact amount of the transaction, which is already recorded above, will be used for your match. 
  • The REI Hub system will look for future transactions of the same amount and offer this rule as a match. 
  • Click Save at the bottom.

4) Automatic Transaction Booking

REI Hub can use the Rules you create to book transactions on your behalf automatically.  If you check the 'Automatically book matching transactions' box, the system will scan your entire import feed and immediately book all transactions that fit the Rule.  When new transactions are imported, they will be scanned, and any that match the Rule will be automatically booked.
This can save you lots of time— but make sure your match is specific enough that only intended transactions are caught in the Rule and automatically booked.

5) If not using auto booking, a Match will be presented after clicking Book

When booking a transaction that matches one of your Rules, you will see the Action updated to Match (instead of Create New) and a prefilled checkbox for the match.

6) Select which accounts the rule applies to

Leave the box unchecked to have this rule apply to only the individual account you are currently working in.
Check the box to have this rule apply to all transactions that it matches across all of your bank and credit card account

7) Visit the Rules page to add, view, edit, or delete rules

Navigate to the Import Feed and click Rules at the top.  Click on the blue part of the description to edit or delete the rule. Click the Add Rule button to add a rule without going through the import feed. 

8) Contact us with any questions!

Still need help? Contact Us Contact Us