Household budgeting

[mtbc]

In Boston I could accumulate savings with little effort but since moving to Scotland we have found ourselves short of money. I routinely keep an eye on bank and credit card statements but it became necessary to more properly track our spending and I thought it worth describing what I do.

I have a spreadsheet with a monthly budget. Annual and weekly expenses get converted to being per month. Similar occurs for income, except there are rather fewer lines for that. So, I can check that the budgeted expenses are within our income.

For the non-fixed expenses such as grocery shopping or electricity bills I have a single-entry system where for each expense line item I have per-month ledger cards that receive weekly or monthly credits corresponding to the spreadsheet then our actual spending is debited accordingly. Infrequently I review the current month's ledger cards to ensure that the balances are staying in line.

Some expenses occur less than annually. For those I have a separate section on the spreadsheet that tracks their amplitude, period and phase, from which I calculate two numbers. First, how much I should now have accumulated in savings to be able to meet the expenses when they do arrive. Second, how large a monthly expense line item is required in the main part of the spreadsheet to sustain a sufficient savings rate for these less common expenses.

I find that this approach gives me a good handle on our home finances without being overly onerous. I wonder how it compares to what others do.

Comments

[emperor]

I download my transactions (in CSV, though Nationwide do now offer a more standard format, IIRC) monthly, and have a python script that goes through them, classifies them (it remembers the answers, roughly) and spits out an email with what we spent on each class of thing (groceries / going out / fuel / etc.). The shortcoming is that it doesn't know about how the credit card bills break down, but it's BALGE of letting us keep track of where the money goes.

[goldibehr]

I track every individual expense in quicken, using fine-grain categories. Getting my other half to consistently provide receipts is a challenge.

Cash expenses are tracked in an app on my phone, then manually transferred to quicken once a week or so. I run a report about once a year, just to see where the money went.