How to Split a Transaction

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 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.

Use Percentages Instead of Dollar Amounts

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."

How to Merge Two or More Transactions

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 final details for the one transaction that will survive.

What Types of Transactions Should I Split?

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.

Still Having Trouble With Splits or Merges?

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

Did this answer your question?