Saving Analyst

Personal finance web app for Sparkasse Germany account transactions

Goal of the project:

I built this app to help me understand my family's monthly income and expenditure, and to run analytics to see how much we are saving and how long it will take to reach a saving goal

Note: This is for people with Sparkasse Germany bank accounts. I don't know if it will work with any other accounts

Cool features:

• No need for a database, all of your transaction data is stored in the browser in localStorage
• Only need to categorise each counterparty once: all transactions relating to the same account are automatically categorised with the same label
• You get a suggested category based on a machine learning algorithm
• You can see nice charts of income, expenditure, net savings and projected savings broken down by month and category
• You can choose a saving goal and see how long it will take to save up for your goal
• You can download your transaction categories. When you upload your saved file, the categories will be automatically applied

Technologies used:

React.js, Chart.js, D3.js

Installation and running:

Just use the web version

https://tomswales.github.io/saving_analyst/

Run on your own computer

• git clone https://github.com/tomswales/saving_analyst.git
• npm install
• npm start

Usage:

Note: this only works for Sparkasse Germany online banking, not tried with any other banks

• Login to Sparkasse Online-Banking
• Go to "Online-Banking Startseite"
• Go to "Umsätze" and select the account you want to analyse (if more than one)
• Choose transaction period start and end date (you may need to put in a TAN)
• Click on "Exportieren" (you may need to put in a TAN) and select "CSV-CAMT-Format"
• Now, in Saving Analyst, click "Click to import" and then find your csv download
• Your transactions should be imported into the app - now you can get started with analysis