PersonalFinanceAnalyst
What is it?
This is a set of scripts to transofrm Revolut monthly expense report to a easy read table. The goal is to automatically categorize personal expenses.
How to use
Prerequires
- Upload Spreadsheets to your Google Drive
- Create new project in Google scripts (https://script.google.com/) in your personal account and upload all scripts from repo there
- Download monthly reports from Revolut app in Excell format
Usage
- Fill in table IDs in main.gs
- Run main.gs
Categories update
- Add a few of your usual expense categories to the Budget template table
- Populate missing data in your newly created report with a new column with categories
- Run populateExpensesCfg.gs
- Updadte expensesCfg.gs with the output