I am trying to figure the best way to track inventory purchases. I purchase inventory and get an invoice that includes inventory, supplies (non-inventory), equipment, taxes, fees, and personal use. With accrual accounting, I figure Cost of Goods Sold for taxes by declaring inventory purchases and va…

Maybe tags might work. But I have a follow-up question. I pay multiple invoices once a month, so a single transaction covers multiple invoices. On the Tag Report template, can I specify the invoice? And then on the transaction sheet tag multiple invoices from the Tag Report?

When you pay multiple invoices is this so it shows up as one transaction on tiller or separate? if one you can split using https://help.tiller.com/en/articles/6326655-automate-splitting-transactions and then you’ll be able to specify. But even if you don’t so long as you don’t mind directing back t…

When I pay multiple invoices, it’s one transaction on Tiller. I am good at splitting transactions. I’m looking for a way to link the one transaction (the payment to a company) to the split designations for whichever invoices that payment covers. It’s never the same number of invoices or the same $ a…

With the three way tagging you don’t need to necessarily split, but say you do pay more than 3 invoices per transaction that does make the tag report not as helpful, unfortunately. Because tiller can only see what the bank sees in terms of transactions so at some point you’ll need to manually split …

I have been thinking that this is sort of the reverse of reconciling bank or credit card statements. My own spreadsheet of invoices is like the Tiller Transactions sheet and each Tiller transaction that pays an invoice should be at least marked. I like how the Tiller transactions sheet can just keep…

[image] dianne: Would be nice if the invoice spreadsheet could just grow like the transactions sheet, but seems like extracting the sums for any given time period then becomes challenging. Yes, because as the transaction listing grows the cells references would change. So if thinking about wh…

Translate paid invoices into transaction splits?

Conversation Ask Anything

ctlee January 29, 2026, 6:40pm 2

If i’m understanding this correctly you need to identify either on an invoice basis the different items that come and and which invoice it relates to? if so you could try the tags report below

and code by invoice:type to make it more traceable?

Topic		Replies	Views
Tags in the Transactions sheet Google Sheets	21	357	January 16, 2025
:trophy: Tags Report v2 with Multi-level Tag Support gSheets Templates google-sheets , tcs-tags	19	2246	August 15, 2025
New: Split transactions using Tiller Money Feeds for Google Sheets News from Tiller	24	1813	March 1, 2023
Freelance Contractor trying to manage job spending Ask Anything	12	614	April 21, 2023
Docs: Tags Report for Transaction Tagging gSheets Templates google-sheets , tracking , tcs-tags , tcs-gallery	15	15260	May 28, 2020

Translate paid invoices into transaction splits?

Related topics