We have an excel spreadsheet for our income and expenditure, it’s been running for about 15 years now and is invaluable
One place to see them all! Bank accounts and others that is?
- Thread starter Time Waster
- Start date
Page may contain affiliate links. Please see terms for details.
We have an excel spreadsheet for our income and expenditure, it’s been running for about 15 years now and is invaluable
Jenkins
Legendary Member
- Location
- Felixstowe
I did something like that for a few years to keep track of how much money I was spending each year following motor racing - this is from 2013, note how little the diesel price has changed since then. A simple Excel spreadsheet and formulas to produce the final figures. I daren't do that for my current hobby of live music events!"
Date (s) | Destination | Ticket | Programme | Hotels, Tolls, Parking | Mileage | Diesel price | MPG | Fuel Cost | Total Cost |
| | | | | | | | | |
Tuesday 1 January 2013 | MSVR Season Pass | £178.99 | | | | | | | £178.99 |
5th January 2013 | Evans Lakeside | | | | 147.5 | £1.399 | 50.5 | £18.55 | £18.55 |
Saturday 16 March 2013 | MSVR, Snetterton | | | | 102.9 | £1.449 | 49.4 | £13.70 | £13.70 |
Sunday 17 March 2013 | HSCC, Donington Park | £15.00 | £3.00 | | 329.2 | £1.439 | 52.2 | £41.20 | £59.20 |
Saturday 30 March 2013 | BTCC, Brands Hatch | | | £2.66 | 169.3 | £1.429 | 52.2 | £21.04 | £23.70 |
Saturday 6 April 2013 | BARC, Donington Park | £15.00 | £3.00 | £29.00 | 204.2 | £1.429 | 51.4 | £25.77 | £72.77 |
Sunday 7 April 2013 | BRSCC, Rockingham | £11.00 | £3.00 | | 156.6 | £1.429 | 51.4 | £19.77 | £33.77 |
12-14 April 2013 | WEC Silverstone | £35.00 | £5.00 | £44.00 | 338.7 | £1.399 | 50.2 | £42.85 | £126.85 |
28-29 April 2013 | 750MC, Brands Hatch | | £2.00 | | 344.6 | £1.389 | 52.5 | £41.39 | £43.39 |
Saturday 11 May 2013 | BARC, Snetterton | | | | 104.9 | £1.379 | 52.5 | £12.51 | £12.51 |
Sunday 12 May 2013 | BARC, Rockingham | £15.00 | £3.00 | | 227.5 | £1.379 | 49.4 | £28.83 | £46.83 |
25th & 26th May 2013 | F3 & GT, Silverstone | £20.00 | £5.00 | £24.00 | 306.4 | £1.399 | 52.2 | £37.28 | £86.28 |
Monday 27 May 2013 | Masters, Brands Hatch | | | £2.66 | 169.2 | £1.399 | 52.8 | £20.35 | £23.01 |
Saturday 1 June 2013 | HSCC, Snetterton | | | | 102.3 | £1.399 | 55.9 | £11.62 | £11.62 |
Sunday 2 June 2013 | Blanpain, Silverstone | £18.20 | | | 271.8 | £1.399 | 49.1 | £35.16 | £53.36 |
Tuesday 11 June 2013 | Rutland Water Cycling | | | £5.00 | 238.1 | £1.399 | 57.6 | £26.25 | £31.25 |
15th & 16th June 2013 | British GTs, Snetterton | | £5.00 | | 204.4 | £1.399 | 55.0 | £23.60 | £28.60 |
29th & 30th June 2013 | BARC, Brands Hatch | | | £5.32 | 346.1 | £1.389 | 53.9 | £40.49 | £45.81 |
6th & 7th July 2013 | AMOC, Brands Hatch | | | £7.32 | 343.8 | £1.399 | 52.5 | £41.59 | £48.91 |
13th & 14th July 2013 | HSCC, Brands Hatch | | | £5.32 | 345.7 | £1.419 | 52.8 | £42.18 | £47.50 |
Sunday 28 July 2013 | MSVR, Brands Hatch | | | £2.66 | 173.9 | £1.419 | 49.7 | £22.54 | £25.20 |
3rd & 4th August 2013 | BTCC, Snetterton | | £5.00 | | 198.2 | £1.419 | 53.6 | £23.82 | £28.82 |
10th & 11th August 2013 | F3 & GT, Brands Hatch | | | £7.32 | 345.1 | £1.409 | 53.1 | £41.57 | £48.89 |
31st Aug & 1st Sept 2013 | Superstars, Donington | £28.50 | £5.00 | £29.00 | 375.7 | £1.439 | 53.6 | £45.79 | £108.29 |
14th September 2013 | BTCC, Rockingham | £15.00 | | | 246.2 | £1.419 | 52.8 | £30.04 | £45.04 |
28th & 29th September 2013 | BTCC, Silverstone | £29.00 | £5.00 | £21.00 | 310.8 | £1.409 | 51.6 | £38.53 | £93.53 |
5th & 6th October 2013 | British GTs, Donington | £25.00 | £5.00 | £27.00 | 383.0 | £1.389 | 52.8 | £45.74 | £102.74 |
19th October 2013 | HSCC, Silverstone | £10.00 | £2.50 | | 271.2 | £1.389 | 50.8 | £33.67 | £46.17 |
20th October 2013 | CSCC, Snetterton | | | | 99.0 | £1.389 | 53.9 | £11.58 | £11.58 |
2nd & 3rd November 2013 | W.H.T. Silverstone | £18.00 | £3.00 | £20.00 | 301.4 | £1.399 | 51.6 | £37.10 | £78.10 |
9th November 2013 | MSVR, Snetterton | | | | 99.9 | £1.399 | 51.1 | £12.42 | £12.42 |
10th November 2013 | Vee Festival, Brands Hatch | | | £2.66 | 170.9 | £1.369 | 52.2 | £20.35 | £23.01 |
16th November 2013 | BARC, Rockingham | £15.00 | | | 234.8 | £1.379 | 52.8 | £27.84 | £42.84 |
| | | | | | | | | |
FINAL TOTALS | | £448.69 | £54.50 | £234.92 | 7663.3 | | | £907.32 | £1,630.43 |
Edit to add - a simple spreadsheet to keep track of income & outgoings for my accounts is all I use now.
PaulSB
Squire
- Location
- Chorley, Lancashire
With the greatest respect I can't help but feel you are overthinking this on a massive scale. You could probably have solved the problem by now if you applied less "rationalising" and more practical "get on with it".
When my family was young we were permanently broke. The solution was simple, the "book". Every month we totalled our income, deducted monthly bills and what was left we could spend. The monthly balance was divided by 4 or 5 and written in the "book." Every purchase was deducted from the running balance. An overspend in week one was accounted for by an underspend in week two. This was 30-40 years ago, with today's technology far greater detail is possible.
I retired nine years ago, my only concern over this was running out of money with little, if any, ability to increase income. I did what I could to address my concerns and a year or so before retiring addressed this.
Pull together your annual income and expenses, analyse these and apply cost centres
Create or purchase online a simple cash accounting or bookkeeping spreadsheet. I bought one online and adapted it to my purposes. I could have built one, it would have taken days. An hour online found one for £5.99.
Set budgets and YTD information, create a worksheet that pulls all the detail together in a monthly management report.
Enter your monthly income and expenditure as frequently as you wish, doing this regularly takes less time and is more accurate.
If you wish include the value of savings, ISAS etc.
If you keep the data updated you will know your financial position at any given time. It will be held securely on your own device. The accuracy of the net worth you're interested in will depend on how often you're prepared to check this detail.
All our savings are in long-term plans. I use to check monthly. A waste of time as a drop simply depressed me while an increase had no real impact on day to day life. Clearly if you're heavily into buying and selling daily data is vital, for longer term stuff it's pretty pointless.
In summary get a spreadsheet and do it yourself. After the initial work it's quick and easy to get the information you want, not what a random app thinks you want.
When my family was young we were permanently broke. The solution was simple, the "book". Every month we totalled our income, deducted monthly bills and what was left we could spend. The monthly balance was divided by 4 or 5 and written in the "book." Every purchase was deducted from the running balance. An overspend in week one was accounted for by an underspend in week two. This was 30-40 years ago, with today's technology far greater detail is possible.
I retired nine years ago, my only concern over this was running out of money with little, if any, ability to increase income. I did what I could to address my concerns and a year or so before retiring addressed this.
Pull together your annual income and expenses, analyse these and apply cost centres
Create or purchase online a simple cash accounting or bookkeeping spreadsheet. I bought one online and adapted it to my purposes. I could have built one, it would have taken days. An hour online found one for £5.99.
Set budgets and YTD information, create a worksheet that pulls all the detail together in a monthly management report.
Enter your monthly income and expenditure as frequently as you wish, doing this regularly takes less time and is more accurate.
If you wish include the value of savings, ISAS etc.
If you keep the data updated you will know your financial position at any given time. It will be held securely on your own device. The accuracy of the net worth you're interested in will depend on how often you're prepared to check this detail.
All our savings are in long-term plans. I use to check monthly. A waste of time as a drop simply depressed me while an increase had no real impact on day to day life. Clearly if you're heavily into buying and selling daily data is vital, for longer term stuff it's pretty pointless.
In summary get a spreadsheet and do it yourself. After the initial work it's quick and easy to get the information you want, not what a random app thinks you want.
Last edited:
