Skip to main content
N
nonprofit23230
March 4, 2021
Question

Run Report Budget vs Actuals for This Fiscal Year and also Last Fiscal Year

  • March 4, 2021
  • 2 replies
  • 0 views
Original commenter did not share additional details

2 replies

BettyJaneB
BettyJaneB
March 4, 2021

I got you covered in running your Budget vs Actuals report, @nonprofit23230.

 

Pulling up the Budget vs Actuals report is a breeze. You can use the Budgeting tool in the system to run your desired report.

 

Here's how to do that:

  1. Go to Gear icon at the top.
  2. Select on Budgeting. 
  3. Find your budget on the list.
  4. Select the Action ▼ drop-down and then press on Run Budgets vs. Actuals report.

Know that the Budget Overview report summarizes budgets by account. The Budgets vs. Actuals report summarizes accounts alongside your actual account totals. It also shows how much you're under or over budget. 

 

To give you more tips about managing the budget and its report in QuickBooks Online, please see this reference: Learn how to get your budgets into QuickBooks.

 

On the other hand, you can always customize the report based on the information that you need. I've attached here a guide that you can scan through for more details: Learn how to get the most out of your financial reports.

 

If you have any other questions, please let me know by leaving any comments below. I'll be here to lend a hand.

N
nonprofit23230Author
March 10, 2021

Thank you.  I want to customize the Budget report so it has three columns:

1. budget FY

2. FY to date actuals

3. Last FY to date (same period)

The "compare to same period" option is missing.

Julie

KlentB
KlentB
March 10, 2021

Hi there, nonprofit23230.

 

Thanks for adding additional details about your concern.

 

The Compare to same period option is unavailable in QuickBooks Online's Budget vs. Actuals report. You may need to export this report to an Excel file so you can further customize it. I'll show you how:

 

  1. Select Reports from the sidebar menu.
  2. Under the Business overview section, choose Budget vs. Actuals.
  3. Set the appropriate reporting date and accounting method, then click Run report.
  4. At the top of the report, click the Export icon and then choose Export to Excel.
  5. Save the file on your computer.
  6.  Open the report, then make sure to select Enable Editing so you can manipulate the data.

On the other hand, if you're referring to the Compare another period feature, you'll have to open your Budget vs. Actuals from the Reports menu, not on the Budgeting page. This way, you'll get the option to compare time periods side-by-side. Here's how:

 

  1. Select Reports from the sidebar menu.
  2. Under the Business overview section, choose Budget vs. Actuals.
  3. Set the appropriate reporting date and accounting method.
  4. From the Compare another period drop-down menu, select the appropriate comparison option.
  5. Click Run report.

Additionally, I recommend reading these articles to help streamline the reporting process in QuickBooks:
 

I'll be glad to assist you again if you need more help in managing your budgets and reports. Just post the details below and I'll get back to you as soon as I can.

B
BBNC
December 19, 2022

I have not found any way to do this. I don't think it's possible with one report. The other responses are unhelpful.

 

You can compare previous periods with Statement of Activity, but not Budget vs. Actuals, where the "compare previous period" option is taken up by comparing % or $ difference between budget and actuals. Conversely, you can't compare % or $ difference between periods with the SOA report.

 

My work around is to export reports for each year to Excel then put them side-by-side yourself.

Terms & ConditionsAccessibility statement