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.

Learn more

Did this answer your question?