Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
msevenstar
Level 1

Is there a way to run the budget vs actual report using this year to last month (Jan 1 through Feb 28) but showing the yearly budgeted amount, not "prorated" by month?

I need to close out reports on the last day of each month, but we like to see the budgeted yearly amount as our spending as a Church fluctuates.

1 Comment 1
Ethel_A
QuickBooks Team

Is there a way to run the budget vs actual report using this year to last month (Jan 1 through Feb 28) but showing the yearly budgeted amount, not "prorated" by month?

At present, there is no option to customize the display of the annual budgeted amount when selecting only two months of the year. In the meantime, I will offer a workaround that will enable you to monitor your budget versus actual report according to your preferences.

 

When running a Budget vs Actual report and changing the period from January to February this year, the report will only show the prorated amount.

 

As a workaround, you can export the report to Excel and customize it from there. I'll show you the steps to export the report below:

 

  1. Go to Reports, and choose the desired data to export.
  2. Select the Export/Print ▼ dropdown, then select the following options:
  • Choose Export to Excel.
    1. Click Downloads from your browser.
    2. Hit the Excel report you want to export to run it.

 

Once downloaded, you can modify it and add the necessary details.

 

To learn more about creating budgets in QuickBooks Online, here is an article you can check for guidance: Create budgets.

 

You may want to save your customized report for easier access in the future, refer to this article for the steps: Save a customized report in QuickBooks Online.

 

Comment below if you need clarifications regarding the Budget vs. Actuals report in QuickBooks Online, and I'll be happy to assist you. Have a great day.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us