Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I created a new budget (from previous year actual data) and when I ran the report for Budget vs. Actual, I can't figure out where the "budget" numbers are coming from. This is the first budget created. Any help would be appreciated.
Hello there, @Patti W.
It’s nice to have you in the Community today. I’m here to lend a hand in verifying where the budget numbers are coming from.
We need to make sure everything is correct by checking the fiscal year setting within the company file and examining how the budget is being set up in QuickBooks Desktop.
To verify if the fiscal year setting is correct, follow the steps below:
1. Go to Company at the top menu and select My Company.
2. Click the Pencil icon and choose Report Information.
3. Go to the First month in your fiscal year field to see the month and update if necessary.
4. Hit OK to save the changes.
I've attached screenshots for your reference.
Now, determine how the budget is set up. Here’s how:
1. Go to Company at the top menu and select Planning & Budgeting.
2. Choose Set Up Budgets. If you’ve set up one before, the most recent budget will be displayed in the Set Up Budgets window.
3. Click Create New Budget.
4. Specify the budget year, and then choose between Profit and Loss and Balance Sheet.
5. For the Profit and Loss Budget, specify additional criteria of either Customer: Job or Class, if class tracking is turned on.
6. Select whether you want to Create a budget from scratch or Create a budget from the previous year’s actual data for Profit and Loss Budget.
7. Once done, hit Finish.
You may check out this article for more information about budgeting in QuickBooks Desktop: Create a budget or forecast in QuickBooks Desktop.
That’s it. I want to ensure this concern gets taken care of, so please feel free to let me know how it goes by leaving a comment below. Looking forward to hearing from you soon. Take care!
Run Reports menu > Budgets & Forecasts, there are two reports to look at to understand the data you are using:
Budget Overview = shows the Numbers you entered for that budget.
Now run Budget vs Actuals.
Thanks for the input but it's not answering my question. I had no prior budgets established. When I do create one, then run the Budget vs. Actual report, I don't know where the "budget" numbers are coming from. All I did was set up a budget and select "create budget from previous year's actual data".
This is what you asked: "I can't figure out where the "budget" numbers are coming from"
And that is what I answered. It's the same thing I would do if your file was in front of me. You asked Where the budget values are coming from. You made them when you did this: "All I did was set up a budget and select "create budget from previous year's actual data"."
When you made a budget, you had to assign it to a Fiscal Year.
When you run the Reports I suggested, you have to Pick a Fiscal Year budget, for the reports to use.
That's how you examine what you did. By Fiscal Year.
We have a fiscal year that runs July 1 through June 30. We have that set up in our Company profile. But when we input a budget, it seems to ignore the fiscal year and create it in the calendar year where the fiscal year starts. Then our Budget vs. Actual reports do not pull in the proper budget numbers.
We are running desktop version for Mac 2016 - all software updates completed. Any help would be appreciated.
I'd be happy to help you with that, Town Clerk.
A quick and easy way to fix this is to set up your company preferences and indicate when your Fiscal Year starts. With this, the budgets that you'll input will be reflected on the Fiscal Year, instead of the Calendar Year. The steps below will guide you on how to do this:
If you need further assistance in setting this up, you can always reach out to the Customer Care Team. They have specialized tools and initiate screen sharing to guide you throughout the process. Here's how you can reach them:
Please know that I'm only a post away if there's anything else I can help you with. I'm always here to provide help and answer any questions that you may have. Wishing you and your business all the best!
Mac has known issues for fiscal year budgets.
For my town clerk and governmental entity QB clients, I always recommend they should be using QB Accountant, which was spun off of the Premier "Industry Editions" family years ago. On Mac, you can simulate Windows by running VM Ware or Parallels for ways to install and run the Accountant Edition.
Thank you qbteachmt. Do you know whether Quickbooks online would handle the fiscal year budgets correctly? We are a tiny town with very little tech knowledge among staff. I am worried that the parallel environment might flummox everyone.
I don't use, nor do I recommend, QB Online for the Governmental unit.
Thank you. But can I do last fiscal year to compare? I have never done this before and so confusing what the board wants.
Can you do What, about last year?
If you don't know what the board is asking for, you need to ask them for more details.
I appreciate your answer. I am working on my first budget
I am not able to find this step. I use DT Accountants version. I would like to import last years data for 2019 budget.
Hello there, @ktd.
Thanks for joining this thread. I can help you import last year's data for 2019 budget.
The acceptable file type when importing a budget is Intuit Interchange Format (.IIF). Make sure to meet this requirement to add the information in QuickBooks.
Once done, here's how to upload the file:
Next, here's how you can create a budget from previous year's data:
That should do it, ktd. For additional reference, you can check the articles below:
Let me know if there's anything else you need or you have follow up questions. I'm still here to help you more. Have a good one.
Hello,
Sorry if I missed this in the thread. When I create a new budget what will happen to the old budget?I have 2018-19 right now and I need to build one for July 1 to June 1 2019-20. This is our second budget - and I didn't set up the first one. I don't want to override data.
Thanks for any assistance!
Good day, JJessen.
Let me help and provide you with some information regarding creating a budget in QuickBooks Desktop.
Creating a new budget will not override your 2018-2019 data. You will first need to ensure that your fiscal year is set correctly. It's also a good practice to review last fiscal year's financial reports.
To set up the first one:
Please be reminded that when you rename an account used for a budget, the account will no longer be associated with it and you need to recreate the budget using the new account name.
For detailed information, you can check out this recommended article: Create a budget or forecast in QuickBooks Desktop.
If you require more information about budgeting in QuickBooks Desktop, don't hesitate to fill me in. I'm here to help.
Thanks Rose. You wrote:
Please be reminded that when you rename an account used for a budget, the account will no longer be associated with it and you need to recreate the budget using the new account name.
I'm worried about overriding my present budget. Will I be able to have multiple years?
Also, speaking of worry: Is there anything like a system restore. In case I really screw something up. Can I go back a day or two and start fresh?
Thanks for your help! QuickBooks is amazing!
Thanks for choosing QuickBooks as your accounting partner, @JJessen.
You can have multiple years to reflect on the budget report. You just need to customize the date range on the report (see the screenshot below). However, you can create one budget per fiscal year from scratch or based on previous year's data.
To make sure you can protect your company file against accidental data loss, you can always create a backup copy. Here's how:
For more information, please refer to this article: Create A Backup of Your Company File. If you lose data while setting up your present budget, you can restore your company file using your backup copy.
This will point you in the right direction, @JJessen.
If there's anything else you need, please let me know. I'll gladly help.
Thanks!
I'm looking to run a report to run budget comparisons. Is this possible? How many years can you do. I want to be able to average 2-3 years to see the trend so I can forecast for next year.
Thanks!
Thanks for the additional informtaion, JJessen.
The option to set the Budget report showing two to three years of trend in one report is unavailable. In the meantime, you can export these reports to Excel and collate it from there.
Here's how:
You can check out this article that will help you customize reports.
I'm just a post away if you need more help. Have a great day!
I am trying to set up a budget in quick books online. My brower I am using is firefox as my quick books seems to work well with that browser. In the process of creating the budget, my computer stops working and I get a message that a web page is slowing down your brower, what would you like to do? Stop it or wait? If I click wait it takes about 5-10 minutes before the information populates a single line. If I stop it my computer freezes and I have to start over. So I switched browser to Google Crome. Same thing. I've started this budget 6 times now. Getting frustrated with Quick Books Online. Ready to switch to another accounting software.
Hello there, @lynnh.
This must be a challenging experience for you. But I'm here to ensure that you'll be able to set up a budget in QuickBooks Online.
In the meantime, let's perform some troubleshooting steps that can help us isolate this. Let's try logging into your QuickBooks account using a private browser. There are times that the browser is full of frequently accessed page resources, thus causing unusual responses.
To use a private browser, here's how:
If it works, return to your default browser and perform clear cache to remove temporary internet files on your computer.
If the issue persists, I recommend reaching out to our Customer Care Support. This way, they can investigate this issue further why you can't set up a budget.
To reach them, click Help (question mark icon) at the top right, then hit Contact us.
Please keep in touch with us here in the Community should you need any further assistance. We're always here to help.
I recently spoke with a quickbooks representative and she told me that only quickbooks plus online does budgeting. This thread seems to contradict that. Does quickbooks desktop premium 2019 do budgeting?
Thanks for taking the time joining us here in the Community, @cmagic99.
Allow me to provide clarifications about the availability of creating budgets in QuickBooks Desktop.
QuickBooks Desktop has the ability to do budgets and forecast for your business. All you have to do is to set the budget properly to have a detailed outline for your company’s revenues, expenses, cash flow, and financial position.
To set up the budget:
Once done, a budget transaction can be viewed by running the Budgets and Forecasts report.
For more insights about this process, you may read through these articles:
This information should get you going today.
Please let me know if you have further questions about budgets. I'll be around to help you out. Have a great week ahead!
I think "Patty" is telling you that when she does what you said to do, as I have to, the budget numbers for 2020 should be 2019 actuals - and they are NOT. Re-quoting her is condescending. So, what if the budget numbers are not the previous year actuals?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here