Zer0 Tool - Historical data conversion tool

Whilst the basis for importing historical data is nYNAB (The cloud based version), you can use this tool to convert your exported data from YNAB 4 or YNAB 3. Use the contact form or @Zer0Budgeting for support/praise, etc.!

Zer0 Code/Scripts

The code that is contained within the Zer0 sheet is available for viewing here

If anyone has any issues, suggestions, comments, please use the contact form or @Zer0Budgeting

Release 2018 Q2.1

The latest release is available here

Let me know if you encounter any issues via the contact form or @Zer0Budgeting

Changelog - 01/24/2018

• Added Currency formatting option - see Navigation: Zer0 > Setup > Change Currency
• Updated the formula on the Budget sheet to remove dependency of entering the 1st day of any particular month in D6
• Updated Changelog sheet
• Corrected chart format on Main sheet
• Changed Register sheet no longer requires manual completion of Category Group/Category (columns F:G), that's derived based on the category in column H.

Release 2018 Q1.4

Changelog - 01/24/2018

• Fixed spelling error
• Added protected ranges to some sheets

Release 2018 Q1.3

Changelog - 01/24/2018

• Added credit and checking import templates to the migration function

Release 2018 Q1.2

Changelog - 01/23/2018

• Fixed formula in cells Main!C9:C39 that was incorrect
• Fixed Formula in Net Worth Details sheet that incorrectly referenced the History
• Fixed migration macro
• Added alternate row color to Register sheet to help with readability

Release 2018 Q1.1

Changelog - 01/22/2018

• Added Changelog directly in the sheet and a mechanism to tell you if there was a later version available for download
• Added more options to the custom Zer0 menu - hide, setup and reports
• Added Added migration option from previous version - input your existing sheet url and the data from the various sheets will be copied to the latest spreadsheet.
• Fixed Setup-Time: Fixed formula in cell B5
• Fixed Project Tracking: Fixed array formula in cell A6

Release notes for previous versions will be stored on the Release Notes page

Some screenshots from the latest version