Hello, World.

I'm Jade.

Executive Informantion Officer Data Analyst Software Developer

Personal Finance Power BI Report

The Personal Finance Power BI Report is a report for GnuCash, an open source accounting software for Windows and Linux. GnuCash uses a PostgreSql database. The report is mobile friendly if you use the Power BI Mobile App. The Personal Finance Report measures net-worth and cash flow on a monthly basis.


The embedded report is only available on screens wider than 900 pixels.

Pages

default-image

Dashboard

Shows all the main KPIs, including debt-to-income ratio and savings rate. It also shows a graph of the income allocation and it's targets, according to Ramit Sethi's book, "I'll Teach You To Be Rich". The Dashboard also give a breakdown on the assets, with a toggle button to switch to liability allocation (showing the use of bookmnarks).

default-image

Monthly Cash Flow

On this page the user can see categories by actual vs last month and actual vs budget, showing the use of field parameters. The bars are also color coded depending on whether both last month and budget is worst off or only one of the two measures. The user can also drill-through to the Subcategory Detail page by selecting a subcategory in the Top 5 by Subcategory bar chart.

default-image

Subcategory Detail

Shows the deeper details of each transaction for that subcategory. The year and month slicers are synced across all 3 pages, so whatever is selected on one page, it will pull through to all the pages, creating a seemless user experience. Finally there is a bar chart for the actual expenditure over time, which ignores the year and month slicer selection.

Support

Do you want a copy of this report?

Do you use GnuCash as well and want to use this report?

Sending...
Your message was sent, thank you!