Thinking about manually track your finances? This is a deep dive into my customized Airtable system.
The base currently consists of 8 tables: transactions, budget, recurring bills, debtors, projects, assets, monthly review and notes.
This is the main table which houses income, expenses and interpersonal transactions. The master view shows all fields (columns) of the transactions table.
The budget is a work in progress. Right now, it serves as a sort of checklist view so that I know which expenses are budgeted vs. those that I’ve already paid. This will become more useful from next month as I will begin to use the majority of these fields after moving. For now, I can easily see what my projected budget will look like. I don’t actually add records to this table, these are added in the ‘Recurring Bills’ table.
The idea here is to copy and paste these recurring monthly expenses when I do my budgeting for the next month. This way, I have a log of the amounts that I’ve paid on a monthly basis for each expense as the table is grouped by month. I will be able to post an update on how this works practically at the end of April 2022.
I’m working on an automation to update the 💰 Budget status to paid based on triggers in the Recurring Bills table but I’ll definitely need more time to set this up properly (if it’s possible without being too clunky).
This is linked to the transactions view and contains names of persons who owe money to me, as well as the amount, previous payments, transaction date and the date paid.
This table has a gallery view which links all expense records tagged with a given project. There is also a rollup field which sums up the total amount of money that I’ve spent on the project.
This is a grid view to track investments with the following fields: name, amount, description (e.g. short and long term emergency fund, insurance), provider (bank/financial institution), type (e.g. fixed deposit, mutual fund), start date, interest rate, status (acting, inactive, pending), attachments (for certificates and receipts) and notes.
Allows me to easily see my total income, expenses and the amount that I have remaining. I think that I should also add a field for total savings here as well, but this view gives an overall summary of the month.
In notes, I have random things that I want to view or calculate. I’m thinking that I should create a new base for this purpose as it won’t be very practical to either add additional tables to this base.
That’s it. It’s not perfect and there are quite a few parts that I would like to adjust but for now I’m enjoying the process of building it out. In addition to making this base more efficient, I think it would be fun to build this in Notion as well. I’d love to know if anyone else is using Airtable to plan their personal finances and, as you can tell, I love screenshots so feel free to message on twitter or leave a comment if you have any suggestions!
Last updated: January 16th, 2024. Write your own now page.
My 29th Year
I am now living through the last year of my 20s. It's comical to ponder that I thought I would have my life all "figured out" by now. I don't, and I'm finding that I am more and more okay with this fact. There is an underlying evolution rumbling within me and witnessing it unfold is a fascinating process.
After leaving medicine last year, I am enjoying the freedom of self-employment and continuing on in the journey of establishing consistent work online. I'm using my innate skills to create courses around the digital tools that I find joy using and to find work as a digital business manager and Notion consultant.
Writing is lighting me up and I'm using my spare time to learn photography.