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 new 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 automatically book transactions that match your Rule.  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!
  • If you do not want transactions to be automatically booked on your behalf, uncheck the box.  When you click 'Book' on the transaction from the Import Feed, you will see the Rule match and will 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 will be the same every time, such as a business name or account number. 
  • Click Save at the bottom.
To match by amount:

  • Check 'Match by amount' The exact amount of the transaction, which already recorded above, will be used for your match. 
  • The REI Hub system will look for future transactions of the exact 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 automatically book transactions on your behalf.  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 autobooking, 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