Closing out the year... 3 months late

For tax accounting purposes, I'd like to have a record of each budget year separably.    With Q1 having just ended, I realize i should have hit "Fresh Start" on Jan 1, 2019 - but didn't.  Any ideas on how to best handle the situation now?

2 reasons for dividing years:  1. I export things to excel and don't want to deal with years of old transaction weighting me down and 2. Several people have access to my budget and sometimes someone deletes a transaction by accident - I want to limit the amount of damage/back looking I have to do when that happens. 

If there was a duplicate budget option, I'd duplicate and erase old stuff - but there isn't.

thank you for any ideas!

-Alex

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Abby
    • Toolkit for YNAB Designer & Developer
    • abbydawn
    • 2 yrs ago
    • 1
    • Reported - view

    Honestly, I don't think there really is much you can do. Your options are basically:

    • Continue with your current budget
    • Do a fresh start and continue from now
    • Do a fresh start, then manually adjust balances back to Jan 1st levels and re-add three month's worth of transactions (which sounds horrible, IMO).

    You can submit a feature request (https://docs.google.com/forms/d/e/1FAIpQLSfNVCZCXFaokj9PjsnKXDau5-F2-cu-rdK9AgrBkdAa_xgjww/viewform) for a budget duplication feature, but that really won't help you right now.

    Like 1
    • Ben  thank you!  what if I  exported my current budget, did a fresh start, re-imported the entire budget and then deleted 2018? Do you think that would work?

      Like
      • Abby
      • Toolkit for YNAB Designer & Developer
      • abbydawn
      • 2 yrs ago
      • 1
      • Reported - view

      Tomato Rhythm Unfortunately the export files that YNAB provides are really just a one-way export, for financial record keeping purposes, and can't be re-used to regenerate the same exact budget in YNAB by re-importing the export file.

      You may be able to do a partial import of just the transaction data as long as the formatting matches up (https://docs.youneedabudget.com/article/921-importing-a-csv-file), but I haven't personally played with it and I'm not sure what the limitations are. 

      Like 1
      • Chrissy
      • YNAB Technical Support Manager
      • chrissy_ynab
      • 2 yrs ago
      • 1
      • Reported - view

      Tomato Rhythm As Ben mentioned, there's not a great way to re-import exported data, so you'd have to either 1) start a new budget and re-categorize all of your transactions after bringing them in with a file from your bank or 2) just keep using the same budget and then filter/export for your 2019 transactions. Depending on the number of transactions you have it's your choice what the best fit is here! 

      Like 1
  • It's very easy to exclude the years you don't want in Excel. The other issue is thornier.

    Like 1
      • MXMOM
      • MXMOM
      • 2 yrs ago
      • Reported - view

      mamster unfortunately there is no way to exclude the years from exporting.   You can filter/delete once they are in Excel but if you have years of data, it will bog it down.  I wish there was a way to filter the export.

      Like
    • nolesrule
    • Stealing From the Future fix is an improvement but is incomplete....
    • nolesrule
    • 2 yrs ago
    • 1
    • Reported - view

    I wouldn't Fresh Start a budget just to close out the year. Historical averages are built into many of the budgeting functions, and starting over every Jan 1 renders them useless.

    Better would be a feature request to export filtered data, or just do it in excel.

    Like 1
  • Also wish there was a way to duplicate a budget to create a new budget.  Not only for fresh start but also for hypothetical budget analysis.

    Like 2
  • You would never exclude or delete old years in a QB file, I would never recommend that you do it - it's the only way to easily report on year over year / period over period information and watch for trends as your business grows. That being said, I am anti-fresh start for personal budgets, too. I want all of my data available to me at all times :)

    Like
Like Follow
  • 2 yrs agoLast active
  • 9Replies
  • 121Views
  • 6 Following