cancel
Showing results for 
Search instead for 
Did you mean: 
chrisvesper
Level 1

Create a budget using year other than previous year's actual data?

When creating a new budget, using Profit and Loss, you can "Create budget from scratch or Create budget from the previous year's actual data."

 

It is currently 2021.  The previous years actual data is not representative because of Covid.  I'd like to create a budget, but use 2019 data.  

 

Can you force Quickbooks to use an arbitrary year when creating a budget? 

I have not tried it, but can you set the compute date to a date in 2020, and it will then use 2019 data?

If you have to do it from scratch, what report(s) should I run for 2019 to get the numbers to enter manually?

 

Here's the documented steps to create a budget 

  1. Go to the Company menu and hover over Planning & Budgeting. Then select Set Up Budgets.
  2. Select Create New Budget.
  3. Set the fiscal year for the budget, then choose either Profit and Loss and Balance Sheet. Then select Next. If you select Profit and Loss, you can add additional criteria, such as Jobs or Class tracking.
  4. If you select Profit and Loss, select either Create budget from scratch or Create budget from the previous year's actual data.
  5. Select Finish.

 

Quickbooks Desktop Pro 2019 for Windows

5 Comments 5
RenjolynC
QuickBooks Team

Create a budget using year other than previous year's actual data?

Hi there, chrisvesper.

 

I appreciate your time reaching out to the Community. 

 

With the steps you've shared, you can record a budget based on the year selected. Just make sure to specify the year and type of the new budget. Then, select if you want to create the budget from scratch or use the previous data.

 

Once done, you can go to the Reports menu and select Budgets and Forecasts to view the one you've recorded.

 

In this sample screenshot I've run the Budget Overview report and selected the new budget dated 2019: 

 

 

To learn more about the process, you can read this article: Create a budget or forecast in QuickBooks Desktop.

 

Please let me know any follow-up questions you have by clicking on the Reply button below. I'd be glad to provide the solutions. Take care and stay safe!

chrisvesper
Level 1

Create a budget using year other than previous year's actual data?

When you choose  "Create budget from the previous year's actual data." it always uses the previous calendar year, not the previous year to the budget.

 

So, when you said "Then, select if you want to create the budget from scratch or use the previous data." you seem to be implying that "use the previous data" mean the year previous to the budget.  It does not seem to work that way.

 

Are you able to test it, or access more detailed documentation to confirm how it really works?

 

An example: if today is August 18, 2021, and you create a budget for 2020, it will use the profit and loss from 2020 to create it.   

Then if you create a budget for 2022, it will also use the profit and loss from 2020 to create it.  

 

I can't use 2020 data to create my budget since the numbers are off due to Covid, I'd like to create a budget for 2022, but use 2019 data. 

 

  • Can you force Quickbooks to use an arbitrary year when creating a budget?
  • I have not tried it, but can you set the computer date to a date in 2020, and it will then use 2019 data?
  • If you have to do it from scratch, what report(s) should I run for 2019 to get the numbers to enter manually?

 

 

 

 

 

FritzF
Moderator

Create a budget using year other than previous year's actual data?

Hello, @chrisvesper.

 

Thanks for getting back to us and for sharing some additional information. I'm here to answer the questions that you've listed above.

 

For your first question, that option to force QuickBooks Desktop (QBDT) to use an arbitrary year when creating a budget is currently unavailable. It will only use the previous calendar year.

 

For your second question, the data on your file is not based on your computer date. It will be based on the date the data is entered.

 

For the last one, if you choose to do it from scratch, you can use the report ( Budget Overview report) shared by my colleague above as a reference.

 

To learn more about managing and creating a budget in QBDT, please visit this article: Create a budget or forecast in QuickBooks Desktop.

 

If you need further assistance, please let me know and I'll get back to you as soon as possible. Have a good one!

SueT4T
Level 1

Create a budget using year other than previous year's actual data?

In the past I have had to change the date on my computer to the next year to get the current year's data in my budget. Is this still the case? For example, I want to do the budget for 2022 but if I select previous year data I am pretty sure it will give me 2020 unless I change the computer date to fool it. Today is 11/16/2021. 

Thanks

MJoy_D
Moderator

Create a budget using year other than previous year's actual data?

I can share some information about creating a budget in QuickBooks Desktop (QBDT), @SueT4T.

 

If you run or create a budget, it'll use last year's Profit and Loss data to start one. This means that if you generate a budget for 2022 today, we'll base it on your 2020's data. 

 

The ability to generate a budget based on what year or financial year we prefer will be a great addition to the current features that we have, so I'll take note of it. 

 

Check this article for more information about creating a budget or forecast in QuickBooks Desktop. That’ll help you review your data and set up a budget.

 

From here, you can generate budgets and forecast reports to review what you've created from the Reports menu. Refer to these articles on how to customize any report that you generate and then save it using the same settings:

 

 

If you require more information about budgeting in QuickBooks Desktop, don't hesitate to let me know. I'm here to help. Keep safe and have a wonderful day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us