All Collections
Categories
Basics
Splitting Transactions Between Multiple Categories
Splitting Transactions Between Multiple Categories

Sometimes it's nice to break up a single transaction into multiple categories.

Heather Phillips avatar
Written by Heather Phillips
Updated over a week ago

If you're like most people when you spend money at some places it doesn't all get lumped into a single expense category.

When you use Tiller's automated bank to spreadsheet feeds there are a couple ways you can split transactions

Manually split transactions

If you're using Microsoft Excel you can manually split transaction by inserting rows.

  1. Insert one or more rows above the transaction you want to split based on how many times you need to split the transaction. To make sure you split the entire amount accurately, leave the original row for now.

  2. Type in the details of each split.

  3. After you've entered all the split amounts, select the amount cells for all the splits and make sure the sum equals the amount of the original.

  4. Delete the row for the original.

Optionally, you can also add a Note column to keep track of the details of the original transaction.

Use Tiller Money Feeds for Google Sheets

If you're using Google Sheets you can split transactions right from the Tiller Money Feeds add-on sidebar.

Did this answer your question?