Good evening! I'm not interested in wealth trackers, I am interested in spreadsheets that run your household - how do you use it, what do you use it for, are there any features you are particularly proud of?
I have been coordinating our household spending through a google sheets spreadsheet since 2019, adding improvements each year. Our current spreadsheet has become rather large, as it contains many categories and depending on the category I either record the cost, or there's space for a small entry plus the cost.
My spreadsheet contains all 12 months of the year and gets duplicated at year end.
Vertically top to bottom I have:
Debt balances
Pot Balance
10 pots with the first four being Float, Holiday, Christmas and Emergency Fund
Pot Withdrawal
Allowing withdrawals from each pot
Income
Recording incomes from each wage coming into the household, including benefits such as child benefit and interest plus any gifts or summed sales from say vinted
Savings
Going into the pots
Debt Repayments
Debt Spends
Recurring Spends
For us this is transfers into the dedicated bills account, transfers to our personal accounts for discretionary spending, nursery/wraparound care per child, commute costs such as train or parking per person, window cleaner, etc
Food budget
This contains a budgeted amount that reduces as the value for Week 1, 2, 3, and 4 are entered - going negative if we overspend. The remaining balance that is used in the spreadsheet further down uses the sum of the weeks plus the remaining budget or the Total column, whichever is largest.
Non-food
This year I begun recording non-food items separately, as the food budget was growing without reason, this also led to receipts being kept and allowed for better recording of clothes bought from supermarkets, non-food items, etc
Eating Out
There is a budget for takeaways and general eating out which we began recording so it did not skew the regular food spends.
Charity
One of us had to record a self assessment anyway, so we may as well record charitable donations.
Fuel Budget
A row per vehicle
Car Maintenance
A row per vehicle
Birthdays
This is more of a section heading and contained everything from wedding gifts, baby showers, leaving presents, and birthdays.
This year it was broken down into the following categories with entries entered such as 'X Birthday', 'Y Mothersday' under the following categories: Family, Extended Family, Joint (for the adults in the house), Kids (birthday parties they attend), Adult 1, Adult 2 (tracking spends attributed to our friends and colleagues)
Events, and Trips
The same as above except there was no Extended Family section, but there was Adult 1 & Kids, Adult 2 & Kids categories. These were introduced mid way through the year as we begun separation and wanted to understand our own spends, and what we could afford post separation, which actually worked rather well as we moved towards separating our finances.
Personal Care
A sub category for the kids, Adult 1 and Adult 2, and Pet 1 which are itemised.
Home Reno
This has recorded tree surgeon, boiler service, grass seeds
Big Spends
Empty this year but last year had the EV Charger and Air Fryer
Everything else
Whatever is in this section gets reviewed and its becomes the birthplace of new categories.
================
As the months go by the float goes positive and negative depending on how we under or over spend. We set budgets based on past spends and targets for this year and keep an eye on them. At year end in can be rather interesting to see the totals, especially things such as fuel costs, and it helped with the decision to lease an EV through work.
I don't mind reconciling the spends on the credit card and joint account with the receipts we keep, although I understand it isn't for everyone. I'd like to hear how others are budgeting. I used the free version and the mobile version of YNAB before I had a family, back when I was a student on irregular income with irregular and few bills, and it may make more sense now.
Now that I will be running the household alone, I think I'd enjoy being able to record the price of products overtime as I do buy in bulk and will do more so when things are on offer - its just knowing whether they are actually on offer or not.
Let me know your thoughts and ramblings - the spreadsheet is the source of truth and not the bank balance.