Personal Financial Tracker and Projector

I’ve been using an excel sheet to keep track of my finances and predict what they’ll look like for about a year and a half now. However, it doesn’t work in LibreOffice Calc. Since I’ve started moving towards a FOSS-based ecosystem, I will need to port over my work from excel to some other medium. Why not make a programming project out of it?!

Contributors

This is a solo project.

1. Description

There are two major functionalities for this program:

  • Display and analyze historical data (tracking).
  • Display and analyze projections based on that data (projecting).

As a bonus, I would like to be able to compare past projections to real data.

1.1 Tracking

1.1.1 Purpose

The purpose of tracking is manifold. I want to see my:

  • Current financial status (present-oriented).
  • Actions to take (present-oriented).
  • Spending habits (past-oriented).
  • Income (tax-oriented).
  • Investments, both formal and informal (hybrid).
  1. My current financial status consists of:
  • Savings balance.
  • Invesments balance.
    • Retirement.
    • Other.
  • Wiggle room.
  1. Actions to take consist of:
  • Add to savings.
  • Add to investments.
  1. Spending habits consist of:
  • Rent
  • Utilities
  • Groceries
  • Travel
  • Car
  • Donation
  • Entertainment
  • Gift
  • Misc
  1. Income consists of:
  • W-2 sources.
  • Investment gains.
  • Self-employment.
  • Gifts.
  1. Investments consist of:
  • Retirement
  • Personal Formal
  • Personal Informal

1.1.2 Plan

The following file structure under the “data” folder are used:

File Structure
Data is loaded into the .CSV files manually (webscraping project ahead?) with the appropriate categories.
CSV Structure
When the application opens and the user selects the tracking function, they will be prompted to select the following options:

  • Finances at a glance.
  • Custom figure.

1.2 Projecting

This is where things really get fun.

1.3 Comparison

Results

TBD

Challenges

TBD