cancel
Showing results for 
Search instead for 
Did you mean: 
Nevets-54
Level 1

budget vs actual report

How do I show a report of Budget vs Actual for YTD without showing the monthly totals?

 

Obviously new to the online version and technically challenged......

9 Comments 9
SophiaAnnL
Moderator

budget vs actual report

I'll be your guide today to generate the data you need, Nevets-54.

You can customize the Budget vs. Actuals report to show the YTD total.

Here's how:

  1. From the report, click the Customize button in the upper right-hand corner.
  2. Maximize the Rows/Columns section.
  3. Under Show Grid, select Accounts vs. Totals from the drop-down menu.
  4. Filter the Report period.
  5. Click Run report.

You will now see the year to date totals of each account after following the steps above.

If you have more questions about this report, just leave a reply. Thanks.

NicoleTCE19
Level 1

budget vs actual report

I do not see a rows and column option when I customize option. The only tabs I see are display/filters/headers and footer/Fonts and Numbers. Where can I see the rows and column?

I am using desktop Quickbooks 2020

Ryan_M
Moderator

budget vs actual report

Hi @NicoleTCE19,

 

Thank you for confirming the type of product you're using. It allows me to provide you with the appropriate steps.

 

For QuickBooks Desktop 2020, the option to edit the rows and columns of a Budget vs. Actual report can be found under the Display tab.

 

 

You can change the Display columns by drop-down menu to Total only. This will show a single column for the Actual amount of the period selected. You also have the option to uncheck sub-columns.

 

You can learn more about how you can customize reports in this article: Customize company and financial reports

 

Leave additional questions below, and I'll be sure to get back to you.

NicoleTCE19
Level 1

budget vs actual report

I did what you suggested and changed it to total but it does not actually give me the total. For instance in one account I put $15000 in the budget for Oct, we did not actually pay anything towards that account until Dec  in the amount of $13602.14. I am looking for a report that would show the account with a total of +$1397.86 towards that budget account. This report is only reflecting the $13602.14 and showing the budget % at 100. 

 

Does that make sense? I am not sure if I am explaining this right. 

MJoy_D
Moderator

budget vs actual report

Thank you for the response, @NicoleTCE19

 

If I got the concern correctly, the $13602.14 is the actual income and expense and the $1397.8 is the difference between your budget and the actual income and expense.

 

When you run the Budget vs. Actual report, this will show you how well you are meeting your budget for income and expenses.

 

Make sure to add sub columns for Show Actuals, $ Difference and % of Budget when customizing the report. That’ll show you the actual income and expenses and the budgeted amounts.

 

I’m always here if you still need further help with your account by leaving a comment below. Take care and have a wonderful day!

NicoleTCE19
Level 1

budget vs actual report

Yes, you understand my concern. I want to see budget $15000- $13602.14 actual paid and a balance of a positive $1397.80.

 

I am doing everything you tell me. I see where to put total only in display, the subaccounts for Show Actuals and $ Difference and % of Budget but I am only getting the report to reflect the actual amount. 

 

The amount was put in the Budget in Oct 19, we bought the machine in Dec 19. I am running a Balance Sheet Budget vs Actual, on Desktop 2020, with all the suggestions but only see the amount we actually paid in December. The Budget amount made in Oct does not come up on the report at all. I have the dates correct, so it is not a date issue. Please tell me what I am doing wrong. 

 

 

 

 

GraceC
QuickBooks Team

budget vs actual report


Hello there, @NicoleTCE19.

 

Let me provide some information about this issue.

 

Since the budget in QuickBooks Online only applies for a Monthly Budget. In the meantime, we can't make the actual paid last December to reflect in Both October and December.

 

I've attached our help article for QuickBooks to learn more some tips.

 

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

NicoleTCE19
Level 1

budget vs actual report

Does that apply to QuickBooks 2020 as well? 

RCV
QuickBooks Team
QuickBooks Team

budget vs actual report

We can perform a troubleshooting step to reflect the budget amount in October, NicoleTCE19.

 

In QuickBooks desktop 2020, you can set the Report Basis to Cash and customize the period to October only. This way, we filter the report to show the budget amounts for that specific period.

 

Here's how:

 

  1. In the Profit & Loss Budget v. Actual report, click the Customize Report button.
  2. Choose Display.
  3. Select Custom in the Dates drop-down. Then, enter the October date in the From and To section.
  4. Place a checkmark for Cash in the Report Basis section.
  5. Hit OK.

actual 01.PNG

 

For more details about Budget and Forecast, you can check out this article: Create a Budget or Forecast in QuickBooks Desktop.

 

To learn more on how to customize your report, you can refer to this article: How to Customize reports in QuickBooks Desktop.

 

Feel free to leave a comment below if you need anything else with the Budget vs. Actual report. I'll be here to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us