cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 01-10-2019

Best Answers
Highlighted
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

17 Comments
Highlighted
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.

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

Highlighted
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

Highlighted
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..... :(

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

Highlighted
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?

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

Highlighted
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??

 

Highlighted
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! 

Highlighted
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 :( 

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

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

 

 

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

 

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

Highlighted
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!

Highlighted
New Member

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.

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

Need to get in touch?

Contact us