PS: Even though all my bills are auto paid this has already proven useful in that I previously didn’t notice that my Netflix bill was higher than usual.
PPS: I think it would be neat to see some more info, such as a total and average, under the query. Total would be good for helping spot potential targets for cutting back expenses (for me at least, it’s a lot easier to justify paying a few bucks a month for something than paying hundreds of dollars a year). The average is useful for planning ahead.
As you will see from the Bill Payment Tracker documentation linked to above, the bill frequency options are:
Monthly, Every 2 Months, Quarterly, Twice a Year and One-Time only
Since the checkbox columns are by month only, options for weekly or fortnightly (every other week) are not available.
But as the FAQ notes:
You could setup 2 monthly bills and call them Payee 1 and Payee 2. You would need to adjust your Transactions sheet to match these names in order for the Last Paid, Last Amount and Bill History Query to work.
Huh, I thought the “one-time” option was an oddly named “annual.” It actually worked the same, as I had put in an annual payment (for Tiller, in fact) with a start date of Nov 2019 and it showed the box for Nov 2020 and listed it as upcoming for next month.
I haven’t yet because it’s working and I’m not sure I’m going to keep using this sheet, but I definitely wanted to try it out. (Also on the last upgrade I accidently overwrote instead of archive and haven’t been motivated enough to redo all of my entries yet)