cancel
Showing results for 
Search instead for 
Did you mean: 
msiegel
Level 2

Budget vs Actual report

is it possible to run a budget vs actual report and have a column for the full year budget also?

11 Comments 11
msiegel
Level 2

Budget vs Actual report

I am specifically looking to run a budget vs actual with columns for the one month, YTD, and the whole year budget.  Help!!

Jen_D
Moderator

Budget vs Actual report

Good to see you here, @msiegel,

 

There are two sets of budget reports in QuickBooks Online, namely, Budget vs. Actuals and Budget Overview. This is the reason why we're currently unable to merge elements on both reports.

 

If you want the Budget vs. Actuals to have a column for the total annual budget, you will need to pull up those 2 reports and customize them in Excel. To do the export process, use the Export icon so you can start modifying them on the worksheet.

 

See this:

 

I'll be adding some related links to help you get your way around the Reports feature in QBO:

Let me know if there are other things I can help you. I'll be right here if you need anything else. Have a lovely day!

msiegel
Level 2

Budget vs Actual report

I know I can do it myself.  I was hoping there was a way to do it in QBO since I already have to pull 2 reports for Budget vs Actual, one for the month and one for the YTD, which also can't be done on one report.  So, now I have to pull 3 reports and combine them in excel just to get what's needed, for each and every class and for the overall.  That's a lot of manual steps for an accounting system that should be able to do it for me.

SteveVA
Level 1

Budget vs Actual report

Exactly, since it can be done in QuickBooks Desktop!   Seems like so many things in QBO are a step down from desktop.

MirriamM
Moderator

Budget vs Actual report

Thanks for joining the thread, SteveVA.

 

QuickBooks Desktop (QBDT) and QuickBooks Online (QBO) are two different product with unique features. QBDT has more complex accounting needs and requires more customizable features than QBO. 

 

I can see how the feature you're looking for in QBO is beneficial to your business. We recognize that each company has unique needs. Since the feature you're looking for isn't currently an option, I encourage you to submit feedback to our Product Development Team. They look through submitted feedback for future updates and use those suggestions to develop changes for the product.

 

You may also want to visit our QuickBooks Blog. And be the first one to know about any updates that you'll find beneficial for your business. The QuickBooks Blog is our way of letting you know the latest features released and what the product team is working on. They update the site every time new information is available. 

 

If there's anything else you need help with, let me know by adding a comment. I'm more than happy to assist you. Have a great day!

msiegel
Level 2

Budget vs Actual report

Yes, they are two different products, but they should be basically the same.  There's no reason for desktop to be more complex than online.  Accounting needs are the same however we purchase the program.

JWhitehurst
Level 2

Budget vs Actual report

This report is needed by most businesses.  I have never seen a company that uses the Budget to Actual report the way it runs out of Quickbooks Online.  We are in the process of leaving this platform due to its many limitations and quirks.  This software has been around long enough that users shouldn't be asking for basic needs that can't be met by the system. 

account4
Level 2

Budget vs Actual report

How do you do it in QB desktop? 

JessT
QuickBooks Team

Budget vs Actual report

Hello account4!

 

I'm happy to provide the steps to pull up your Budget vs. Actual report.

 

The said report in QuickBooks Desktop can be customized to show the monthly, quarterly, or annual budgets, etc. By default, there is a column for the total budgeted and actual amounts of the date range you set. Therefore, if you want to see the totals for a certain year, just set the From and To dates accordingly.

 

  1. Go to Reports.
  2. Choose Budgets & Forecasts.
  3. Select Budget vs Actual.
  4. Set the date range and drag the bottom slider to the right for the totals. 

 

 

If you want to do some customizations, this article is your best resource: Customize reports in QuickBooks Desktop.

 

Feel free to comment below if you need more assistance with your report. The QuickBooks Team is always here to help you.

account4
Level 2

Budget vs Actual report

Hi,

I was actually looking for a monthly report with Year budget

 

For example: Fiscal Jan - dec

 

I want the column on the report to show:

- Month: March Actuals

- Budget for the entire year

- $ over budget = how much remaining ( Jan-March actuals minus budget)

 

RIght now in order for me to get this report, I extract budget vs actual to excel then delete future months (april - dec) , hide the columns i don't need and print.

 

This takes a while and i am trying to simply my process.

 

Thank you. 

RCV
QuickBooks Team
QuickBooks Team

Budget vs Actual report

Thanks for checking in with us, account4. 

 

I appreciate you for coming up with a workaround to come up with a monthly report with a yearly budget. Alternatively, we can use the Export icon to export the report on the worksheet. We can customize reports and save them to run the same report in the future in QuickBooks Online (QBO). Here's how:

  1. After you customize a report, select Save customization.
  2. Give your report a name.
  3. Press Save.

 

Feel free to browse this link here if you need help with managing your financial report. It'll route you to our report topics with articles.

 

Make the most of QuickBooks exploration. If you have any debrief about the process, feel free to share them with us in this post. I welcome the opportunity to respond immediately. You have a good one.

Need to get in touch?

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