We add the second row for the safe for $200 and the add-on tells us we have $0 remaining, which is exactly what we want. For example our trip to Costco where we spent $500, we’d change the first transaction row to account for the groceries of $300, and the add-on tells us we have $200 remaining. It’s best practice to enter your split amounts first so that the Add-on can help you calculate the remaining amount. Select any transaction row by the row number in your finance sheet and then open the Tiller Splitter Add-on menu, choose “Split transaction…” and then you’ll be able to split the transaction however makes sense for your purchases. The add-on runs in your sheet, but it does not share your sheet data with Tiller nor anyone else. ![]() These are standard permissions for a Google Add-on that allow it access to your sheet so it can do its work. You’ll see a series of three screens to set up and install the add-on. You’ll need to give some permission to the add-on in order for it to be able to run in your Google Sheet. Let’s dive into how this super tool works!įirst, you’ll want to install the Tiller Splitter Add-on from the Google Sheets Add-on store. It does the math for you, and it lets you categorize right then and there before the new rows are inserted. Tiller created a Google Sheets Add-on that allows you to split a single transaction into two or more components. You’re in luck! We have just the solution for splitting transactions across multiple categories in your Google Sheet. Split Transactions in Google Sheets with the Tiller Splitter Add-on ![]() You want to categorize this transaction, but first, you’d really love to split that transaction into two parts. Thanks to Tiller, the $500 Costco transaction will soon automatically appear on the Transactions sheet in your money management Google Sheet. ![]() Maybe most of the shopping was for $300 of groceries, but you also purchased a $200 safe, which was on sale recently at a Costco outside Seattle. When you visit Target, Costco or even shop online with Amazon your money is likely going in a few different directions.Ī single purchase may include items you want to categorize in different ways.
0 Comments
Leave a Reply. |