Remove ads

Introducing the LemonFools Personal Finance Calculators

Expenditure tracking spreadsheet

Discussions regarding financial software
Bhoddhisatva
Posts: 31
Joined: July 31st, 2017, 11:30 am
Has thanked: 17 times
Been thanked: 9 times

Expenditure tracking spreadsheet

#162605

Postby Bhoddhisatva » August 28th, 2018, 1:34 pm

It's probably my incompetence (or lack of patience perhaps!) with searching on the LemonFool but I cannot find:

- a spreadsheet template for expenditure
- that I can use to enter and track expenditure over a few years
- to establish a baseline for expenditure in retirement.

Anyone know of one - before I go an create my own which will no doubt be inferior and incomplete!

Thanks in advance!

B

Itsallaguess
Lemon Quarter
Posts: 2562
Joined: November 4th, 2016, 1:16 pm
Has thanked: 587 times
Been thanked: 1348 times

Re: Expenditure tracking spreadsheet

#162689

Postby Itsallaguess » August 28th, 2018, 7:15 pm

Bhoddhisatva wrote:
It's probably my incompetence (or lack of patience perhaps!) with searching on the LemonFool but I cannot find:

- a spreadsheet template for expenditure
- that I can use to enter and track expenditure over a few years
- to establish a baseline for expenditure in retirement.

Anyone know of one - before I go an create my own which will no doubt be inferior and incomplete!


Does it need to be a spreadsheet?

I only ask because Microsoft Money is still available to download, and I've been using it for years for exactly the purpose you're envisaging -

https://www.lemonfool.co.uk/viewtopic.php?f=9&t=11163&p=131837#p131837

The above was posted in April, but I've just checked the links and they are still working fine.

You can export from Microsoft Money into a spreadsheet, by the way, if you're thinking of a specific scenario where you may need to do that.

Money is good in that you can set up your own granular categories, so you can be as high-level or low-level as you like - it's entirely up to you, but for the task you're looking to do, I'd say that it's probably ideal and certainly worth a play with to check and see if it's suitable.

This single piece of software absolutely transformed my money-management processes overnight - I highly recommend it.

Cheers,

Itsallaguess

spiderbill
Lemon Slice
Posts: 286
Joined: November 4th, 2016, 9:12 am
Has thanked: 12 times
Been thanked: 38 times

Re: Expenditure tracking spreadsheet

#162811

Postby spiderbill » August 29th, 2018, 11:07 am

There's one at moneysavingexpert.com that might be of use
https://www.moneysavingexpert.com/content/dam/mse/documents/guides/budget_planner.xls

I don't use it myself - basically I don't need it - but I downloaded a copy a while back just to see what it contained and it looked pretty decent.

cheers
Spiderbill

MyNameIsUrl
2 Lemon pips
Posts: 146
Joined: November 4th, 2016, 1:56 pm
Has thanked: 194 times
Been thanked: 19 times

Re: Expenditure tracking spreadsheet

#162883

Postby MyNameIsUrl » August 29th, 2018, 2:29 pm

Itsallaguess wrote:Does it need to be a spreadsheet?

I only ask because Microsoft Money is still available to download, and I've been using it for years for exactly the purpose you're envisaging


I can also vouch for Microsoft Money - I've been using it for years to track spending by various categories. It's fascinating to see the trends over time (eg when my kids got to 17 and there is a spike in car insurance and petrol), and it gives a good basis for confident forecasting of future spending.

I download all the transactions from Money into excel on an annual basis, and use a pivot table to summarise spending by category in each year - double-clicking a total then shows every transaction that makes up the total.

Unlike Itsallaguess, I download all the transactions from my bank, so there is a difference in purpose there: I think Itsallaguess sees it as a way of verifying bank statements, whereas I see it just as a copy of the statements. Transactions are automatically assigned a category (if the payee has been used before) so it requires little effort to update.

I have an issue to solve though, which is that I've started using a credit card on holiday abroad (to avoid the 2% surcharge on my debit card), so the detail of those transactions is lost. All I see currently in Money is the total monthly payment made from the debit card categorised under, say, "Mallorca 2018".

genou
Lemon Slice
Posts: 252
Joined: November 4th, 2016, 1:12 pm
Has thanked: 6 times
Been thanked: 52 times

Re: Expenditure tracking spreadsheet

#162897

Postby genou » August 29th, 2018, 3:02 pm

MyNameIsUrl wrote:I have an issue to solve though, which is that I've started using a credit card on holiday abroad (to avoid the 2% surcharge on my debit card), so the detail of those transactions is lost.


I'd also vote for MSMoney. On this specific issue, you don't need to lose the granularity. I track CC spending in the same way as a debit card - when you set up a CC account ( or afterwards in "Change account settings" ) there is an option "Account Tracking", where you can opt to track individual charges. The CC account then allows you to follow your spend in the same detail as a debit card.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 2 guests