Any Dashboards or Templates to Analyze and Project using YNAB Exports?
I've started on a Workbook that takes the YNAB export and breaks it into various pivot tables with calculated fields, tables with actual and projected account balances, trends, cashflow analysis (with/without transfers and payoff rates), loan/net worth tracking, graphs, and useful worksheets as tools (Interest rate, amort tables, etc).
Someone has to already done something like this though, right? I can't find one and wouldn't mind paying if it is even better than what I currently know how to create. A nice dashboard layout for instance with 'what-if's' as I near early retirement which let me compare various scenarios. Options like Tableau just don't fit my needs well enough.
All the ones I've found do not lend themselves well to the tabular export format which I would have figured be common in the personal finance market like it is most anywhere in finance/accounting.
Note: Just to get ahead of it. I am not blaming YNAB for lacking this sort of functionality nor am I saying that YNAB'ers should use something like what I am describing. Quicken had a lot of analysis features that I miss but YNAB is strictly better so I plan on supplementing it with something that continues where it leaves off.
Hi, there! We have a list of all of the community applications created to work with YNAB here, and it seems like the closest APIs are:
- The Insights for YNAB connector to Google Data Studio—which links your data to GDS, but leaves creating the reports up to you.
- Budget Reports, which offers a variety of trend graphs and a retirement calculator.
I haven't seen any tools yet that offer YNABers the ability to forecast and run simulations. I'm curious about this, too! :)