How to manage gift card spending (Costco)

Costco in Canada switched to accepting only Mastercard in warehouse a while ago so I buy $2000 Shop cards online with a Visa and use those in warehouse.

Having a $2000 charge every few months isn’t very helpful for seeing how much we actually spend on groceries per month though.

I’ve only just started using Tiller so I didn’t want to mess around too much in the Transactions sheet. I had considered splitting the $2000 and then manually changing the date on the split transactions but I’m not sure if that’s the best way to go about it.

Any other thoughts on potential workflows?

You know, I think I’d make an account (manual). Then I’d move the $2k into it from your Visa account and draw off that account (manual transactions). Seems like that would be easier to do carving up the 2K with split transactions.

I’ll be interested to see what others come up with.


Ah, so think of the $2000 spend as a transfer to a Shop Card account and then make expense transactions off of that.
That does seem like a pretty good idea, I like it!


I like Susan’s idea too!

I currently just highlight all of my big Costco purchases to use the transaction splitter every few months in one go. That way I sit down with the receipts and make sure it’s all accounted for but it does make my budget wonky in the meantime.