Automatically split reoccurring transactions

The AutoCat feature is a handy way to solve this. But another option would be to create a new sheet for your split reoccurring transactions to hold a template.

Create a new sheet for storing Template transactions.

Copy the rows of a transaction you already split into the new sheet. For example, your cable, phone and internet rows.

When you get a new bill, insert 3 rows in your transactions sheet. (Don’t worry about where you do this, since when you add the correct date, it will get auto-sorted when updated.)

Go to your Template sheet and copy the 3 rows for the transaction and paste them into the Transactions sheet where you have the empty 3 new rows.

Let us know if that works for you.

2 Likes