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 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.