Introducing My First Financial App – Visualizing Monthly Spending

plantBonsai.JPG
4 min read

In my opinion, the first step anyone should take to improve their financial situation is to first understand their monthly cash flow. This means understanding how much you earn and how much you spend each month.

Once you have a grasp on your monthly cash flow, you can begin to see where you’re overspending, how much you’re saving, and where you can make improvements.

Most people know exactly how much they earn, but surprisingly few people know exactly how much they spend. So, I built an app that summarizes and visualizes monthly spending. You can find the app here:

www.fourpillarfreedom.com/spending

The app will be completely free to use this week. Starting on July 1, 2018, the app will be available for a $5 monthly subscription.

My goal is to help people visualize their monthly expenses for less than the price of one burrito per month. 🙂

Here is a quick overview of the app, how to use it, and why I think it’s useful:

The App in a Nutshell

The app asks you to upload a CSV file of your monthly transactions. It then takes that file and summarizes your monthly spending with tables and graphs.

1. Upload Your Monthly Transactions

app_1

Personally I use credit cards for all my spending so I can directly download my transactions online. For this example, I’ll head to my credit card login page and download all of my transactions from May 2018, opting to download them in a Microsoft Excel format:

app_2.JPG

Here is the one step that requires a little work on your part. The app only needs a CSV file with four columns: transaction name, date, amount paid, and category.

The CSV file that I downloaded happens to show date, transaction type, transaction name, and amount spent:

app_3.JPG

Your CSV file that you download from your own institution might have extra columns like “Memo” too. So, I’m going to do a couple things to get this data in the right format:

1. I only want the debit transactions since I don’t care about the credit transactions which show that I made my payments. So, I’ll remove any row that has credit in the transaction column.

app_4.JPG

Then, I’ll delete the transaction column entirely:

app_5.JPG

2. Lastly, I’ll add one extra column called “category” and go through and label each transaction:

app_6.JPG

For this step, you can be as specific or as vague as you want. I differentiate between “coffee” and “dining out” because I like seeing the granularity in the graphs. If you want to label all coffee, restaurant, and grocery transactions as “food”, you’re more than welcome to do so.

Now you’re done with the one step that requires some work on your part.

NOTE: It’s OK that the values in the “Amount” column are negative. The app takes care of this.

I go ahead and save this file somewhere on my laptop under the name may18_spending.csv. Then, under the “Upload Transactions” tab on the app, I click “browse”, navigate to this CSV file, and upload it:

app_1

2. Overview of Your Monthly Spending

The Total Spending tab shows your total monthly spending:

app_graph1.JPG

The Every Transaction tab shows every single transaction you made, sorted from largest to smallest amount:

app_graph2.JPG

3. Spending By Day

The Day of Month tab shows how much you spent on every individual day, broken down by category:

app_graph3.JPG

The Day of Week tab shows how much you spent by day of the week, broken down by category:

app_graph4.JPG

4. Spending By Category

The Bar Chart tab shows how much you spent by day category:

app_graph5.JPG

The Table tab shows how much you spent by category, both as total amount spent and as a percentage of total monthly spending. You can sort this table by any of the three columns as well:

app_graph6.JPG

The Mini Category Plots tab shows how much you spent each day of the month, broken down by category:

app_graph7.JPG

5. Spending By Transaction

The Scatterplot tab shows total transactions and average spend per transaction by category:

app_graph8.JPG

The Table tab shows the actual numbers used in the previous graph:

app_graph9.JPG

FAQ:

Q: Where can I access the app?
www.fourpillarfreedom.com/spending

Q: Is there a mobile version?
No. The app is only available for desktop.

Q: When I uploaded my file, the screen turned grey and said “Disconnected from server.”  What does this mean?
This means your file does not have the correct format. Make sure your file is a CSV with only four columns named: Name, Date, Amount, Category. The order of the columns does not matter.

Q: What if I use more than one credit card for my monthly spending?
Feel free to combine your monthly transactions into one CSV file. Or manually type in the transactions into Excel and save the file as a CSV.

Q: How will the subscription work?
The app is available for free until July 1, 2018. At that point, the app will be available as a monthly subscription for $5 per month. You can cancel the subscription at any time and there is no limit on how many times per month you can use the app once you have a  subscription.

Feel free to leave feedback about the app in the comments below or contact me directly at fourpillarfreedom@gmail.com or through my contact form.


My favorite free financial tool I use is Personal Capital. I use it to track my net worth, manage my spending, and keep an eye on my monthly cash flow. It only takes a few minutes to set up and it makes tracking your finances simple and easy. I recommend trying it out.

Sign up to have my most recent articles sent straight to your email inbox for free ?

Full Disclosure: Nothing on this site should ever be considered to be advice, research or an invitation to buy or sell any securities, please see my Terms & Conditions page for a full disclaimer.

9 Replies to “Introducing My First Financial App – Visualizing Monthly Spending”

    1. Thanks Robert! Some financial institutions include the category column, but most don’t. To get this column, you have to enter it yourself in Excel. This is the one part of the app that requires a little work on the user’s end.

  1. Hi, I tried to feed the app dates like 06/08/2018 (8th of June 2018) – which is how the dates came out of my database – but it doesn’t seem to be able to work with that kind of data. Or is it the fact that the dates are not in the right order which makes the app not work?

    1. Hi Petra,

      The order of the dates shouldn’t matter – the app can handle dates in any order. Did you include the “Category” column in the data? And save the file as a CSV? I’ll shoot you an email and help you get it sorted out.

  2. Hey Zach,

    Finally got a chance to try out the app and I really like it!! I especially like the charts that break down the total spending by category – this helps me see where I can cut down on a few areas. Just wanted to say thanks for making the app and I hope it does well for you. Keep up the great work! Mick

  3. First time commenter long time reader. Just wanted to drop by and say thanks for making this app. It’s unlike most tools available in the sense that the charts give an eye-opening view that really help you see where your money is going each month. I showed it to my husband and he found it just as useful as I did. We plan on using it each month 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *