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

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.

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

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:
 

• Customize reports

• Memorize reports

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.

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.

Is the only way to get Annual Budget vs Current Actuals to export and format it in Excel??????

Let me share some information about exporting reports in QuickBooks, @JodyBowe.

In QuickBooks Online, you can export reports to an Excel and PDF format. Currently, the option to generate and export  Annual Budget VS. Current Actuals reports is unavailable. 

At times, we roll out enhancements based on our customer's requests. That being said, I suggest sending a recommendation to our product developers. They'll review this idea and might consider updating it in the future.

Here's how:

1. Go to the Gear located at the top.
2. Under Profile, click Feedback.
3. Enter your recommendation and select Submit.

In the meantime, we can run a Budget VS. Actuals in your QBO account. Then, export them through an Excel file to customize them outside QuickBooks.

Here's how:

1. Go to Business overview and select Reports (Take me there).
2. Search for and select the Budget VS. Actuals reports.
3. At the top of the report, click the Export icon. 
4. Select Export to Excel.
5. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

You can also create custom reports to get the data that focus on the details that matter the most to you. Then, memorize them if you want the same settings of the customized report to be available for future use. This way, you do not have to go through the customization process again. 

Hope that answers your question about exporting Annual Budget VS. Current Actuals reports. I'll be around to help if you have further concerns. Have a good day!

When I run the Budget vs. Actuals Report, One of my accounts will not show an amount in the Actuals column. It gets moved over to the Over Budget column.

I'm here to assist you in resolving your Budget vs Actuals issue to keep your business running, M-P.

An amount will appear in a specific account if there's a transaction created. 

You may have yet recorded one on that account during the period, so nothing shows in the report's Actual column. Consider reviewing it to verify if this is the case.

I'll share this article with you whenever you need to create, edit, or manage a budget in QBO. This offers recommendations to help you keep track of actual earnings and costs regarding your budget.

I've also included some related resources to help you get your way around the Reports feature in QBO:

• Customize reports in QuickBooks Online 
• Run reports in QuickBooks Online

The Community is always here if you need other queries about budget vs actual reports in QuickBooks. 

Annual Budget vs Actuals to Last Month is something that has been requested for a long time and frankly it is frustrating that this is not yet available.  Thanks

Agreed. this is a must have report and your lack of functionality creates more work for us and makes no sense.

We understand that our current report functionality falls short of your expectations, leading to additional work on your end, shaynee.

Your feedback matters to us. With that being said, we want to hear more about the particular challenges you encountered while utilizing the reporting functionality. Please feel free to share your suggestions by following these steps.

1. Go to the Gear icon.
2. Select Feedback under Profile.
   

If you have any additional insights, ideas, or suggestions, please don't hesitate to share them with us. Your firsthand experience will be instrumental in guiding our improvements. 

I used to have the option to run this report in Desktop Pro.  The fact that it it lost after switching to Quickbooks Online is a major problem.  I am absolutely disappointed in Quickbooks that this has been lost.  

How can I change the report that Quickbooks uses to pull in the expense data to my Actuals vs. Budget report?  It is pulling a transaction report that is not filtered correctly.  I have created a transaction report that is filtered correctly, but I do not have the option to direct the actuals vs. budget report to use that report.

Good day, 3100 Grand,

Welcome to your first post in the QuickBooks Community. I am here to help you change the report you want to pull accurately.

Let's first modify the accounts tied to products and services and expense transactions in QuickBooks Online (QBO):

For Product and Services:

1. Go to Sales, then, choose Products and Services.
2. Under the Action column, click Edit next to the desired product.
3. In the edit window, update the Income account using the dropdown.
4. Finally, click Save and close.

For Expense Transaction:

1. Go to Expenses.
2. Open the desired transaction and click View/Edit.
3. Update the Category by selecting the new account from the dropdown list.
4. Click Save and close.

When changing accounts for products/services and expenses in QuickBooks Online, ensure that these accounts match those selected in your budget settings.

When setting up or adjusting budgets to ensure consistency in financial reporting and budget tracking, here's how:

1. In the upper right corner, go to the Gear icon.
2. Under Tools choose Budgeting.
3. For Run Budget vs. Actuals report drop-down menu, click View/Edit.
4. Tick the appropriate boxes when setting up or adjusting budgets to ensure consistency in financial reporting and budget tracking.

Now, we can access specific transactions in the report and select Budget vs. Actuals from the standard options.

You can open this article on how to customize reports in QuickBooks Online.

For your future reference, open this article: Export your QuickBooks Online Data.
 

Before we wrap up, I suggest you explore QuickBooks Live Bookkeeping to streamline your accounting, maintain precise financial records, and access professional support. This could free up valuable time, allowing you to concentrate on expanding your business.

Feel free to reach out anytime if you have any questions or concerns about managing your QBO report account. I am here to assist you further. Have a nice day ahead.