Web App Development
Tracking my personal spending.

Annual overview

I got a job in Shanghai in March, so my accomodation costs have been relatively stable at £485 a month plus bills any hotels for travel.
My company provides breakfast, lunch, and dinner, but in October I started getting sick of having rice twice a day and started going to restaurants in the evening. Because I don't really eat at home "Everyday items" is very low throughout the year.
My fun budget goes up in August because I started taking Chinese lessons.

Monthly detail


Month Accomodation Transportation Eating Out Fun Donations Everyday Purchases Other Productivity Occasional Purchases Exercise Total
Jan 2017£279£293£164£78£43£136£65£122£22£25£1,226
Feb 2017£407£973£264£145£42£75£99£77£22£55£2,159
Mar 2017£522£428£220£53£42£123£70£16£73£47£1,593
Apr 2017£601£41£162£52£121£88£125£43£0£46£1,279
May 2017£522£36£164£123£117£51£40£24£6£18£1,100
Jun 2017£509£800£107£49£119£73£89£25£114£7£1,892
Jul 2017£509£870£203£167£116£177£29£16£63£3£2,152
Aug 2017£513£58£162£181£118£97£24£16£0£3£1,171
Sep 2017£541£48£177£240£112£114£24£16£0£5£1,278
Oct 2017£765£874£261£195£114£108£24£16£27£10£2,394
Nov 2017£727£221£307£113£115£60£24£16£0£75£1,658
Dec 2017£531£64£365£62£114£67£24£26£42£70£1,364


Month Accomodation Fun Eating Out Transportation Exercise Other Everyday Purchases Productivity Donations Occasional Purchases Total
Jan 2018£557£272£322£77£70£47£81£13£1£0£1,440
Feb 2018£496£36£67£5£70£22£23£13£1£0£733
Mar 2018£0£36£0£0£70£22£4£8£1£0£141
Apr 2018£0£36£0£0£70£17£0£8£1£0£348
May 2018£0£36£0£0£0£17£0£8£1£0£62
Jun 2018£0£36£0£0£0£17£0£8£1£0£62
Jul 2018£0£36£0£0£0£17£0£8£1£0£62
Aug 2018£0£36£0£0£0£17£0£8£1£0£62
Sep 2018£0£18£0£0£0£17£0£8£1£0£43
Oct 2018£0£18£0£0£0£17£0£8£1£0£43
Nov 2018£0£18£0£0£0£17£0£8£1£0£43
Dec 2018£0£18£0£0£0£17£0£8£1£0£43


I keep track of things in a plain text file on my phone that looks something like this:

--- january 2018
use rmb
50o   starbucks
9.99gbp monthly spotify

This means that in January 2018 I spent 50rmb eating out, spent 20rmb on everyday items (basically means supermarket), and will spend 9.99gbp a month on Spotify (categorized as "Fun").

Using a plaintext file makes it super easy to enter new items. Much simpler than clicking "New", entering a value, selecting a currency, entering category, ....

I then have a Node script that takes the text file and generates CSV report. Email me if you're interested in it.


Who doesn't love accounting! 😍

I have the following main categories, with some examples of what they contain:

I also have deeper levels of categories like "Everyday Purchases>Haircut" and "Accomodation>Bills>Gas".

For some items I book the cost over several months or years. For example, my phone cost £654 but instead of booking it as a one-off I depreciate it over 3 years, and book an expense of £18.17 a month.
What should be split over several months? One criterium is, could I could recover a meaningful percentage of the purchase price if I sold the item? Or, is the item meant to be consumed over a longer period of time (e.g. gym membership, Chinese lessons)?

Tracking productivity expenses is a bit tricky. Most of my travel expenses in 2017 were related to travelling to conferences. So that could also be tracked as productivity.
You can also see that unlike in October the travel in June and July did not increase my accomodation costs, because the conferences paid for it.
Any items that either my own company or my current employer pays for also won't be tracked here.