It's really easy to split transactions between multiple categories with our Google Sheets Add-on. 

Install the Add-on for Google Sheets here: https://chrome.google.com/webstore/detail/tiller/eaaijilcmebmmdimibbbakmjicikohie?utm_source=permalink 

To split a transaction after you've installed the add-on:

  1. Select the entire row by clicking the row number
  2. Open the Google Sheets Add-on Menu
  3. Hover over Tiller
  4. Choose Split Transaction...
  5. Update the description, category and amounts to correspond to the way you'd like to see the transaction split. 
  6. Ensure that the remainder totals $0.
  7. Click save to insert the split transactions. 

Note: It's best practice to update the first line in the transaction splitter to use the amount that you want to split out as a separate category from the original transaction.

Read more about this feature on the Tiller Blog

Did this answer your question?