Some general notes: My aim in setting up the tracking portion for cash spending on my spreadsheet was to see what percentage of income I was spending on certain categories. So I have a cash section and a banking section, for what of a better word. The banking section is divided into the following sections:
- Private pension/investments
- Various charities
- Transfer to Irish account
- Basic income supporter (see here for details - I've just started contributing €6/month to this)
- Annual expenses (incl. holiday savings)
- Other house related
- Dental insurance
- Visa (my old Irish credit card)
- Mastercard (my German points-earning credit card)
- Misc. (food etc.) - cash
- Misc. (food etc.) - debit card
- Bills (not including phone)
- Tax account
- Bank charges
- One-off out
- One-off in
Private pension/investments: At the moment I'm still just contributing a very small amount to my private pension. I reduced it once I knew I was going to be on unemployment for a while and since I now have some debt, I won't increase it again until I'm a bit more secure, if at all. It's mostly a tax efficicency vehicle so I'll see what my accountant has to say about it next year. I added a field for investments as I wanted to start at least investing a small amount into an ETF fund but still haven't gotten around to setting that up.
Phone/internet at the moment just covers the landline and internet as the topping-up of my current mobile phone happens online and I use my mastercard for that.
Bills is generally just the gas and electricity, although in my new place I don't have a gas bill.
At the moment one-off in includes the income from my translation work and I'm happy enough with that. To the side of my main spreadsheet I have a small box to list the one-off things happening in any month and those numbers feed in here. So at the start of a month I check if any annual or quarterly bills will be due, note if I'll need money for a particular trip or gift and so on. I don't add one-off income until if has actually hit my bank account. Trying to keep it as real as possible. I also use this category to account for any money that I transfer from savings to my current account in order to, for example, pay for annual expenses. Basically this spreadsheet is focused on my current account, in case that wasn't already clear.
In an ideal world, and if I was better at tracking (and accounting, come to think of it), the amounts for misc. cash and misc. debit card would equal the amounts that I track in the daily cash portion of my spreadsheet. As I do sometimes use my mastercard for these expenses however, things were always a bit skewy. So I've now added the mastercard amount to the reconciliation for that portion, as well as including mastercard expenses in the tracking. Much better.
The only thing is that the billing period for the mastercard is different than everything else and I can't change it. So, since it runs from around 10th to 10th (sometimes 9th or 11th, depending on weekends), I track any spending on that card after the bill has been isssued in the following month's numbers. It means I'm not really tracking one month in one place but it's the least complicated way I've come up with, at least for me. I must stress that my spreadsheet is generally focused on helping me to not overspend and to get control of my debt. If I ever move fully into needing something to figure out more than that, well, this should be a good basis for it I think.
The cash section of my spreadsheet is divided into the following categories:
- Food - necessities
- Food - luxuries
- Canteen food
- Gifts (incl. postage, card and wrapping)
- Other (lotto, etc.)
For all of the above categories, both from the banking section and the cash section, I also have space in my spreadsheet to show me what percentage of income each one is. Of course, everything all together should give me 100% but that has never happened. So it's more of a general guideline really. Not sure if it's my spreadshset or my tracking that leads to difficulties but for now, it's close enough for me.
So, that grew to be a much longer post than I had planned on. I'll post actual numbers on Thursday when I know exactly how it has shaped up. So far it's telling me that I've spent (or will spend, as non-cleared items are already included in the totals) 91.36% of my income.
If anyone has any questions about any of that, let me know and I'll try to explain. There are lots of ways I could improve this spreadsheet (starting over from scratch perhaps) but it works pretty well for me so I'll stick with it for another while.