Skip to main content

BudgetSpeech - I made something!

· 3 min read
Kyle Oettle
Software Engineer

Hi Everyone 👋

I made something cool! budgetspeech

I love personal finance, sometimes it can be hard, sometimes it can be stressful, but it's something all of us have to deal with in some capacity.

My wife and I have a bi-weekly meeting called Budget Speech - Where either of us get to be the Minister of Finance for the evening and, you know, give the Budget Speech :satisfied:

We have a big Excel document with all our budgets for different expenses and we track it throughout the month. This workes pretty great and we can be really specific about which expenses gets allocated against which category. This way we're always on the same page whether we're getting McDonalds on Friday, or if we should rather stick to the leftovers in the fridge.

Here is a small snippit of what the excel document used to look like child-in-parent

There are a few issues though...

  • You have to download your bank statements manually. We share a single bank account for expenses and only one of us can receive the In App Authentication request to log in. So only one of us has access to the statements.
  • You can't download the statements from the Investec Mobile App, so you need to use a laptop.
  • Every now and then we create a copy of the Excel document or save it in a different location. You would think two smart people could keep track of a single document on a shared drive...
  • It's still a very manual process you need to dedicate time for.
  • It's hard to keep track of your historical trends and you need to flip through Excel sheets
  • I am a fan of Vault22 (formerly 22Seven) but it never really did what I wanted. When you go to Checkers you might buy food for yourself and dog food. They aren't both "groceries". One is "pets"
  • It's boring and I love coding.

This is where budgetspeech comes in.

I bank with Investec and they support Open Banking, and in South Africa they have a similar set of api's based on the same standard called Programmable Banking

I decided to have fun, over engineer and play around while automating my Excel version of BudgetSpeech.
Read along the next couple of episodes as I discuss what and how I built budgetspeech.

In the video below I used Investec's sandbox environment and credentials. You're welcome to play around with it or just create a Mock Account - no bank account required 😉