How to Split, Duplicate, and Merge Transactions

Navigate to your Transactions page and click the checkbox to the left of the transaction in question. Four buttons with blue outlines will now show as enabled towards the upper right of your screen: Edit, Duplicate, Split, and Delete.
 

Click the one labeled "Split" and then enter details for each transaction you'd like to create. If you need to split it more than two ways, click "Add Split." You can split a single transaction into as many as twenty (20) child transactions with this feature.

By default, the window will split the parent transaction evenly among as many child transactions as you wish, until you edit any amount directly. To edit an amount, simply click the dollar figure and edit it in place. In the rare event that you'd like to convert an expense to an income line item, click the dash under the "Money In" column and input the amount.

You can also update the Description, Category, and Property assignment directly in the Split window. Click "Save" and you should now see your new transactions, assuming they meet your current page filter settings (if any). Note that the sum of all child transaction amounts MUST exactly match the parent transaction before the "Save" button will show as enabled.

To make things even easier for you, we've included a secret capability in the Split feature. If you want to allocate a transaction by percentage, just include the percent sign the number in the dollar amount input box. We'll do the math for you and insert the correct figure, based on the parent transaction amount. For example, inputting "30%" in the second line item below will yield $37.50 when you hit "Tab" or "Return."

If you've completed a split in error or just want to clean things up a bit by merging two or more transactions, start by clicking the checkboxes to the left of the transactions in question. You'll see that once you click more than one checkbox, the "Split" button becomes "Merge." Click the "Merge" button and then enter the final details for the one transaction that will survive.

Once the transaction is selected and the "Duplicate" button is clicked, the duplicate transaction will appear above the original transaction.

You will have the ability to edit the transaction once the duplicate is created by clicking on any of the fields you wish to edit.

Please note, that only one transaction can be duplicated at a time.

Splitting transactions can be a really effective way to fairly allocate costs to various Properties in a larger Portfolio. You might have a single insurance policy covering multiple addresses or a mortgage that's secured by more than one property. In these instances, splitting transactions and assigning the correct amount to each property is a critical step in generating reliable financial reports.

The particular methodology you use to allocate income and expenses over multiple properties is up to you. Some investors allocate according to square footage ratios, while others use relative valuations or acquisition costs. The most important aspect is that you stay consistent over time so that you can accurately compare results from month to month and year to year.

Other types of transactions you might want to split if you have more than one property include common overhead items like mileage and travel expenses, CPA fees, and office supplies.
 

Use the blue circle icon in the lower right to drop us a quick note. We'll get back to you shortly.