cancel
Showing results for 
Search instead for 
Did you mean: 
JK Bookkeeping
Level 3

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I saw the answer where I need to export to excel, yet when I try to move the year-to-date etc. around in excel, they are just formulas and the totals disappear.  How do I go about creating this?
Solved
Best answer January 10, 2019

Best Answers
JonpriL
Moderator

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thank you for these details, @JK Bookkeeping.

 

Currently, QuickBooks Online (QBO) doesn't have an option to customize a statement which details your budget and actual amounts that same way as you've described. But you can pull up your Sales by Client Detail and Sales by Client Summary reports, then export them to MS Excel. From there, you can merge their data the way you want it to be presented.

 

Here's how to customize a report:

  1. Go to Reports.
  2. Under Sales and Customers, locate the reports mentioned above one at a time.
  3. Click Customize.
  4. Change the report period.
  5. Select Run report.

Also, saving this customized report will allow you to pull it up easily in the future. To save it, just click on the Save customization button. Then, you can locate it on the Custom Reports tab when needed.

 

You can also read this article to learn more about customizing a report: How to Customize Reports?

 

It'll be our pleasure to assist you if you have other concerns. Have a great day!

View solution in original post

26 Comments
Adrian_A
Moderator

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Hi, Anna123.

 

You can use another browser and try exporting again the budget vs. actual report. If it's still not working, you can enable excel macros.

 

Here's how to do it:

  1. Click the File tab.
  2. Click Options.
  3. Click Trust Center, then click Trust Center Settings.
  4. In the Trust Center tab, click Macro Settings.
  5. Make the selections that you want.
  6. Click OK.

Let me know if you need more help.

JK Bookkeeping
Level 3

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thank you.  I don't have a problem exporting them.  (Maybe there is now a way to do it within QBO?)

I guess my real question is:   How do I create neat and tidy statement for my client that will show the current month budget vs actual in the fist columns to the left, Year-to-date in the second columns in the middle, and a reminder of the yearly budget in the last column on the right.  

JonpriL
Moderator

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thank you for these details, @JK Bookkeeping.

 

Currently, QuickBooks Online (QBO) doesn't have an option to customize a statement which details your budget and actual amounts that same way as you've described. But you can pull up your Sales by Client Detail and Sales by Client Summary reports, then export them to MS Excel. From there, you can merge their data the way you want it to be presented.

 

Here's how to customize a report:

  1. Go to Reports.
  2. Under Sales and Customers, locate the reports mentioned above one at a time.
  3. Click Customize.
  4. Change the report period.
  5. Select Run report.

Also, saving this customized report will allow you to pull it up easily in the future. To save it, just click on the Save customization button. Then, you can locate it on the Custom Reports tab when needed.

 

You can also read this article to learn more about customizing a report: How to Customize Reports?

 

It'll be our pleasure to assist you if you have other concerns. Have a great day!

View solution in original post

Anonymous
Not applicable

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Hi,

Can anyone tell me how to do this same thing, but in desktop Mac? I used to have a report with month, monthly budget, year-to-date and relative budget performance....don't know how to make it in Mac..... :(

Charies_M
Moderator

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thanks for joining this thread, GCC.

 

I want to make sure your concern about budget report get's taken care of.

 

At the moment, QuickBooks Desktop for Mac doesn't have an available report that shows monthly budget, year-to-date and relative performance.

 

I'd appreciate if you'd let our product developers know this idea through the feedback feature. I have also submitted a product enhancement request to hopefully have this report in the future.

 

Here's how:

  1. Choose the Help menu.
  2. Click Send Feedback Online.
  3. Select Product Suggestion.
  4. Enter your feature request.
  5. Click Send Feedback.

You might find this article helpful to learn more about creating reports for your budget (Please proceed to page 200): https://qblittlesquare.com/wp-content/uploads/2018/09/QuickBooks-for-Mac-2019-1809.pdf

 

For your QuickBooks Desktop Mac inquiries, you can visit this link: https://qblittlesquare.com/

 

Let me know if there's anything else that I can help you with. I'm just a post away. Have great day.

KaroSue
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I use 2019 Desktop and it looks like Budget vs Actual Report no longer shows budget amount when running a monthly report. YTD report shows ytd budget amount in budget column but monthly report shows zeroes in budget column. How do I show the YTD budget when running a monthly report like I have all these many years. Has this now changed?

JessT
QuickBooks Team

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Hi there, KaroSue.

 

We can run some tools to see if the zero amounts are due to damaged data.

 

You can run the Verify utility to check for damaged data. If the QuickBooks detects one, you can the Verify utility to fix it. But first, please be sure to back up your file to avoid data loss.

  1. From the File menu, select Utilities.
  2. Choose Verify Data.
  3. If QuickBooks finds an error, you'll be prompted to run the Rebuild utility. You'll also be prompted to back up your file before running the tool.

For more information, you can check out this article: Verify and Rebuild Data in QuickBooks Desktop.

 

Please let me know you what you'll find out. Thanks in advance.

KaroSue
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thank you for responding. I had already ran what you suggested but ran the verify data utility process again and my data is not corrupted. Any other suggestions I might try??

 

Kristine Mae
QuickBooks Team

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I have another suggestion before we can conclude this isn't a file issue, KaroSue.

 

There are instances the verify/rebuild tool is unable to find the damaged data/component. Aside from using it, let's restore a recent backup copy of your company data.

 

To restore the backup data:

  1. Click the File menu, then go to Open or Restore Company.
  2. Select a backup copy, then click Next.
  3. Select Local backup, then click Next.
  4. Look for the backup file, click Open, then click Next.
  5. Click the Save in drop-down arrow, then select a location where you want to save the copy.
  6. Click Save.

Once done, pull up the Budget vs Actual Report, and check if it's showing the correct figures.

 

If you're still experiencing the same thing, I'd suggest reaching out to our technical support so an agent can take a better look at this. Here's how:

  1. Click Help, then select QuickBooks Desktop Help.
  2. In the Have a Question window?, click Contact us.
  3. Enter a brief description of your concern, then click Continue.
  4. Choose either Message an agent or Talk to a Specialist

Feel free to drop by in the Community if you need something else. Have a good one! 

aneiberger
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Not being able to run Budget vs. Actual with month, YTD and Annual budget is a huge issue.  We have reported this to our Board of Directors for many years.  The Budget vs. Actual report in QuickBooks online doesn't even let you customize this report by Class, the report is useless.  This just seems ridiculous that they wouldn't give you the same reporting options that we have always had in desktop :( 

familiar
Level 2

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I was having the same problem with multiple accounts. I actually had to go in under Multiple Accounts and select each account individually for the Budget data to show.

familiar
Level 2

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

The Desktop version doesn't allow you to do Budget vs. Actual with month, YTD and Annual budget. It's a serious issue because this is a standard reporting tool for organizations. Exporting to Excel is an option but very tedious and time consuming on a monthly basis.

 

 

ShiellaGraceA
QuickBooks Team

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Hi @familiar,

 

You can filter your report column to see the budget vs. actual with month, YTD, and annual budget. Let me guide you how.

 

  1. Go to Reports, then Budgets & Forecasts.
  2. Choose Budget vs. Actual. Then, "Account by Month" in your report layout.
  3. Hit Next and Finish.
  4. In the report, select your desired date in the Dates drop-down (you can also choose Custom).
  5. Click Month in the Show Columns drop-down.
  6. Snap Refresh. See added screenshot below to see how it looks like.

Feel free to check this handy article about creating a budget or forecast in QuickBooks Desktop for more information. I'm also adding this awesome article for details about: Customize reports in QuickBooks Desktop.

 

Should you have questions or concerns I can help, please don't hesitate to reach out. I'll be around for you. Thanks for visiting us and have a nice day.

 

Katrina Bywater
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Looking for this report online. “Budget Performance”. I tried to modify the only budget to actual report to show ytd but couldn’t.  This is for a not for profit that relies heavily on contributions so it’s extremely important to monitor the ytd budget vs actual fundraising. Any recommendations? I’ve looked and can’t seem to find any available modifications. 

Charies_M
Moderator

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Hi there, Katrina Bywater.

 

You can run the Profit and Loss Budget Performance report and filter the date to show year-to-date transactions. This report summarizes how your actual income and expenses compare to what you've budgeted for the current month and year. 

 

Here's how to pull up the report:

 

  1. Go to Reports.
  2. Choose Budgets & Forecasts.
  3. Select Profit & Loss Budget Performance.
  4. Choose the budget to use from the drop down. Then, click Next.
  5. Select a report layout and click Next.
  6. Click Finish.
  7. Customize the date t show This Fiscal Year-to-date.

Feel free to check out this article for more information about customizing reports in QuickBooks Desktop.

 

You can always get back to me if you have other questions. I'd be more than happy to help you some more. Stay safe and enjoy the rest of the day!

SueCPA11
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I would like a report that shows quarterly actual, quarterly budget, $ over (under) budget, annual budget.  Any suggestions?  When I run the sample reports that others have saved, the budget information doesn't populate.

katherinejoyceO
QuickBooks Team

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thanks for joining in the thread, @SueCPA11. It could be that your data file has been damaged which is why the budget information isn't populated. 

 

We can run some tools to see to check for damaged data by using the Verify utility tool. Then, Rebuild the damage which the Verify tool finds to fix it. Here's how: 

 

  1. Ensure to back up your file to avoid data loss.
  2. From the File menu, select Utilities.
  3. Choose Verify Data.

 

If QuickBooks finds an error, you'll be prompted to run the Rebuild utility. You'll also be prompted to back up your file before running the tool.

 

For more insights and further instructions, check out this article: Verify and Rebuild Data in QuickBooks Desktop.

 

For future reference, you can visit our QuickBooks Desktop Article hub to search for related topics related such as customizing, running, and sharing reports. 

 

 

Let me know if you have more concerns. We're always here to help. 

Everett_Richardson
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

That's kind of a lame response.  A budget vs actual report with current month, year-to-date, and yearly budget is the life blood of a lot of businesses, including ours.  I hope your techs are busy working on this for the next edition of QBO.  I'm starting to wonder if I moved to QBO too soon.

jeffyonker
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I am a QBs Desktop Pro user.  I like your sample report for one month.  But I also need to break the report out so I can have a similar report for each class because I have assigned a budget owner to each class that we've created.  How can I get a report like your example by class?

jeffyonker
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I like the sample report you created.  But I need to show the same report for each class I've created.  I have budget owners for each class and need to be able to give them a budget vs. actual report by class.  How can I do that.

Steve_C
QuickBooks Team

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

 Hi jeffyonker.   Thanks for stopping by, I'm happy to provide some feedback on how to create a report broken down by classes.

 

In the following articles you can find the process for multiple different types, including AR Aging Detail report filtered by class, Unpaid Bills Detail report sorted by class, P&L report showing subclasses only, and many more. 

 

Under the Class, you are running the report for QuickZoom on your Credit Card account by double-clicking the Amount. If you want to rename the report prior to printing, Select Customize Report, then go to the Header/Footer tab. In the Report Title field, enter the name you want to use for the report. Select OK. If you have any other questions or concerns, you can post them down below at any time. Thanks for dropping by and have a nice evening

jeffyonker
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Steve.

Thanks for the response.  What I am trying to do relates to a different thread.  I want to show Actuals vs. Budget for expenses for the current month and YTD by class.  Can you help me with that?  I haven't been able to figure that one out.

IamjuViel
QuickBooks Team

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

I'm here to guide how to generate an Actual vs Budget report for the current month and YTD by class , @jeffyonker.

 

First, you'd want to make sure to create the Budget by class. Here's how:

  1. Go to the Company menu.
  2. Choose Planning and Budgeting.
  3. Select Set Up Budgets.
  4. From the Create New Budget window, set the specific year and the type of budget you want to create.
  5. Click the Next button. 
  6. Pick Class from the Additional Profit and Loss Criteria window, then click Next
  7. Select how'd you want to create a budget. 
  8. Click the Finish button.
  9. Once you're in the Set Up Budgets window, you can now manually enter your budget per month. Also, you can assign it to a specific Class. 
  10. Click the Save button.

Once your budget is set, you can now run the Budget vs Actual report.

  1. Click the Report menu.
  2. Scroll down to Budgets.
  3. Select Budget vs. Actual.
  4. Choose the Budget report you want to generate then click Next.
  5. Pick the report layout for the budget report then click Next
  6. Click Finish.

Keep me posted if you have other questions about managing your business financials using QuickBooks. I'm always here to help.

jeffyonker
Level 1

How can I create a budget vs actual report with current month, year-to-date, and yearly budget?

Thanks for the help.  I already had my budgets set up in QBs and I know how to run the reports.  But the report you show is not what I'm looking for.  Please see attached and let me know if there is a way to replicate that in QBs.

Thanks

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us