Sometimes, a single transaction in your bank account includes several different expenses or needs to be booked to multiple properties. REI Hub offers the ability to 'split' imported transactions to allow you to easily turn one imported transaction into multiple.
Splitting an imported transaction will result in multiple transactions in your import feed, each needing to be booked individually. The split transactions will have the word 'Split' added to the beginning of the description (the rest of the description is the same as the original transaction).
To Split an Imported Transaction
1) Navigate to the transaction on the import feed, click Book
You can access the import feed in two ways: first,
From the Banking page, by clicking 'View All' next to a specific account.
You can navigate directly to the import feed page under the Transactions menu tab.
2) Toggle the action selector to 'Split'
By default, the action defaults to the 'Create' option to book new transactions. Select the 'Split' option instead.
3) Click 'Add Line' as needed
You can split a transaction into as many pieces, or lines, as necessary.
If you have added too many lines, click Cancel and start over.
4) Enter an amount for each line, click Save Transaction
The system will split the original transaction into the number of lines specified and the amounts entered per line. Ensure that all lines sum up to the total of the original transaction!
5) Find the Split transactions and book as appropriate
The split transactions will have the word 'Split' added to the beginning of the description (the rest of the description is the same as the original transaction). Click Book on each transaction and book as appropriate!
Please note that if you are filtering the import feed by 'Unbooked Transactions,' you will not see the original transaction, now denoted by 'Unsplit' next to the transaction.
6) If you need to Unsplit the transaction
First, undo the booked transactions for the split pieces. Find the split pieces in the import feed, click the View button next to the transaction, and click the 'undo' button in the bottom right corner.
Second, click 'Unsplit' on the original imported transaction after you have already unbooked all the split pieces of the transaction.
Finally, re-book the transaction as appropriate. Click Book, and you can split it again as desired or book it as appropriate.
7) Optionally choose to automate the split in the future
Transaction matching rules allow you to automate certain actions in your import feed. To have the system automatically split a transaction each time it is imported, click the box to 'Create a new transaction matching rule.'
Matching by amount is required for split rules. We also strongly recommend you check the box to 'Match by description' to ensure that only the appropriate transactions are split in accordance with the rule.
Still have questions? Reach out to our Support Team via email at [email protected] or call us at (888)939-6865.