It's really easy to split transactions between multiple categories with the Tiller Splitter add-on for Google Sheets. 

Install the Tiller Splitter Add-on for Google Sheets here:

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

Did this answer your question?