Budget vs Actual reports (2024)

‎March 16, 202112:39 PM

• QuickBooks Online

Thank you for utilizing the Community,cdbchecks.

I'm here to help you get the report you need.

You'll have the option to filter the reporting period in QuickBooks Online(QBO). The report only includes transactions base on the date range selected. I'll show you how.

1. Go to Reports.

2. Select Budget vs. Actuals.

3. In the Report period, choose Custom.

4. Edit the date range to include the specific month.

5. Click Run report.

I'll share this article in case you want to create, edit, and manage the budget in QBO. This contains some tips to help you track actual revenue and expenses with your budget.

Reply to this post if you have further questions about your report. I'm here to help you.

I know how to pull the report but I am not getting the information I want. I want the monthly figures and I want a YTD total. Right now, the total are the same numbers as the monthly numbers.

1. Sign intoQuickBooks Online.
2. Go toReports.
3. Below theBusiness overview,you can choose a specific report that you wanted to open.
4. Under theReport Period, select those options that you wanted to show.
5. Click onRun report.

Has anyone been able to create the report cdbchecks needs? I need the same report for a client that wants to move to QBO but if I can't get this report they will not switch.

I need Current month Current month budget Variance YTD YTD Budget variance

I understand this wasn't an easy process for you, @Garg1990.

I'd like to ask for additional information to ensure you an accurate resolution on your issue. Please let us know which "Total column" do you want to remove.

Feel free to visit again the Community page.

Keep us updated by replying to the thread below. We're always available to back you and your business. Take care!

I am not able to find this report in my list of reports, even when searchng by name.

I use Quickbooks online, is there another way to locate it?

I've come to share details about the availability of the Budget vs. Accruals report in QuickBooks Online (QBO), @SScalia.

Financial reports give you snapshots of different areas of your business. Most reports are available for all QBO users. However, theBudget vs. Accruals report isavailable for certain subscription levels (i.e., Plus and Advanced plans).

You may have subscribed to either theSimple Start or Essentialsplan. That's why you're unable to locate the report on your list. With this, you can opt to upgrade your QBO subscription to pull up the report you need and enjoy more accounting features. You can refer to this article for the detailed steps: Manage your QuickBooks Online plan(Upgrade your subscription section).

Once upgraded, go to the Business overview section from the Reports menu's Standard tab to pull up theBudget vs. Accruals report.

Also, I'm adding this article to learnwhich reports are available for your version of QBO:Reports included in your QuickBooks Online subscription.

Additionally, you can filter your reports to focus on the details that matter to you the most. Doing so will let you show specific accounts or format the layout to get the data you need. To learn more about this process, you can refer to this article:Customize reports in QuickBooks Online.

Let me know in the comments if you have other reporting concerns in QBO. I'm always around to help. Keep safe always,@SScalia.

Hello,

I have QuickBooks online plus 2019 Im a collage student learning about QuickBooks, one of my assignments is to do this report but,I am not able to find this report in my list of reports, even when searchng by name nothing appears, what should I do?

It's good to hear from you today,Albaoliv5.

If you're using QuickBooks Online Plus, let's perform basic troubleshooting steps to check whether this has something to do with your browser. You can use an Incognito browser to start a new session. Here's how:

• Google Chrome: PressCTRL + Shift + N.
• Safari: Press Command +Shift + N.
• Mozilla Firefox: PressCTRL + Shift + P.

Once signed in, go back to your reports and search theBudget vs Actualfrom there. If it rectifies the issue,go back to your main portal andclear its cachetoremove thebrowser'shistory or you can pressCTRL+Shift and Delete keyon your keyboard altogether. You may also try accessing your account using anothersupported browser.

However, if you're using QuickBooks Desktop Plus, you can follow the steps below to find the report.

1. Click Reports at the top menu bar.
2. From the drop-down list, select Budgets & Forecasts.
3. Choose Budget vs, Actual.

I recommendcustomizingthe report to get the specific details you need. You can alsomemorizeit to save its current customization settings. It serves as your record and helps you quickly access it for future use.

Loop me in if you still need help with QuickBooks. I'll be around to provide additional assistance.

I want to ensure this will be taken care of, @lpccdebra.

When running theBudget vs Actualsreport in QuickBooks Online (QBO), theTotalcolumn will only show the total amount indicated in the selected month. For instance, when you filter the report to show only the budget for January, theTotalcolumn will only display the amounts for that specific month.

The option to show totals for the entire year is unavailable when you select a particular month. As a workaround, you can export the report to Excel and modify the columns from there. I'll guide you how:

1. In your QBO account, go to theReportsmenu.
2. Next, scroll down to theBusiness Overviewsection and chooseBudget vs. Actuals.
3. Once opened, filter theReport periodto show all information for the year. This way, the report will show amounts for your desired month as well as the totals for the whole year.
4. Next, select theExporticon and clickExport to Excel.
5. Once exported, modify the reports column from there.

If you want to have additional customization before exporting the report, simply click theCustomize button.

Meanwhile, you'll want to send product feedback to our developer to request the addition of this feature. Rest assured that they are bound to improve the program's features to suits your needs and preferences. Please refer to the steps below:

1. Navigate to theGearicon.
2. Next, chooseFeedback.
3. Then, enter your comments or product suggestions. Example: Want to run the Budget vs. Actual report in the QBO and have a filter to show the amounts ​​for a particular month as well as the total for the whole year.
4. SelectNextto submit feedback.

Once submitted, please visit ourQuickBooks Online Feature Requestswebsite to track your suggestion. From there, you can also add votes to other product requests that you think might help optimize your QBO navigation.

Also, saving your report modification in QBO is a breeze. To do this, you simply need to click theSave customization button. This feature will allow you to apply the same customization in the future.

I'm just around the corner to help you if you have any other concerns about running your budget report. Don't hesitate to post again here. Have a great day ahead.

Hi,

The budget vs. actual report isn't even available for me. My company setup a new QBO when we incorporated and I'm setting our new account up and it's gone. We have the same level as we did before but it's gone. Is there a way to have it added?

Thanks for joining the thread, AdminAQR.

I see the value of running theBudget vs. Actualsreport to compare your business's actual revenues and expenses to the budgeted amount.

Your current subscription could be one of the reasons you're unable torun theBudget vs. Actualsreport. Let's check the new QuickBooks Online account that your company has set up since this report is only available for QuickBooks Online Plus and Advanced.

Here's how:

1. Go to theGearicon.
2. SelectAccount and settings.
3. Click theBilling & subscription.
4. Below theCompany IDfield, you should see your current subscription.

If it isn't Plus or Advance, you can click theUpgrade your planbutton to have the option to run theBudget vs. Actualreport. Ifyou have the correct subscription, ensurethe budget we're set up. I'll show you how.

1. Go toSettings.
2. ClickBudgetingunderTools.
3. SelectAdd budget, thenenter a budget name in theNamefield.
4. Complete theFiscal Year,Interval, andPre-fill datafields.
5. ClickNext.
6. Enter the budget data into the table if you didn't use thePre-filldata option.
7. HitSave.

I'm also adding this article if you want to run reports that only display the information you need:Customize reports in QuickBooks Online.

Just click theReplybutton below if you need further assistance with the reports. The Community and I will be here to help you.

Hello there, @asellers03.

I see the value of running theBudget vs. Actualsreport to compare your business's actual revenues and expenses to the budgeted amount.

In the meantime, you canexport your file to exceland customize it to show the information you need. To start, follow the steps above provided by my colleague to create the report. After that, refer to the steps below to export it:

1. Select the Excel drop-down arrow.
2. Click Create New Worksheet.
3. Hit Export.

Once done, hide the columns that you don’t need. This won’t affect your data.

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

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

Stay in touch if there's anything else you need about running abudget vs actual reports. Just click the Reply button and enter your questions. I'm always right here to help.

The report "purchases by products and services detail" is close to what I am looking for. It just needs to be "Summary" instead of "detail"

I need a report to be just the summary of each product and service by job. The Desktop version had this report. I don't understand why the online version doesn't.

Attached is a pic of an example Budget vs. Actuals report. This is exactly what I need.

Thanks for joining and for sharing your screenshot, @asellers03. I know how a summary of the Budget vs. Actual report would be useful to your business needs.

QuickBooks Desktop uses different platforms with QBO. Hence, some of the reports may not be available. In the meantime, you can follow my peer @LollyNino_C recommendation toexport your file to Exceland customize it to generate the information you need.

We have already shared this idea to our engineers, and I'd recommend you do the same so they'll put your idea into consideration for future updates. Here's how:

1. Click theHelpmenu at the top and selectSend Feedback Online.
2. ChooseProduct Suggestionand enter the details.
3. ClickSend Feedback.

You can also add your comments and suggestions directly to ourQuickBooks Feedback formlink. Please know that all our suggested plans are subject to further study.

We're always here to answer all your follow-up questions about managing your reports if there's any. Take care!

Hello there, @RL_Moore. I'm here to help you change the column heading or the budget report.

Currently, the option to change the column heading of the Budget vs Actuals report is unavailable. Thus, editing Over Budget to Variance is not possible in QuickBooks Online (QBO).

As a workaround, you can export the report to Excel and edit the column headings there. Here's how:

1. Go to the Reports menu.
2. Next, scroll down to the Business Overview section.
3. Click the Budget vs Actuals report.
4. From there, select the Export icon and choose Export to Excel.

We'd love to hear more of your insights regarding this feature so I recommend sending feedback to our product developers. This way, they can further review which parts of the program need enhancements and consider adding them to future updates. Please refer to the steps below:

1. In your QuickBooks Online (QBO) account, navigate to theGearicon.
2. Next, select theFeedbackoption.
3. From there, enter the details of your product comments, suggestions, and requests.
4. Then, clickNextto submit.

You can visit ourCustomer Feedback for QuickBooks Onlinewebsite to track the feature request you've submitted.

I've added this helpful resource that you can use as a guide in customizing reports in QBO: Customize reports in QuickBooks Online.

I'm always here ready to lend a hand if you have any other concerns about running budget reports in QBO. Have a good day ahead and stay safe.

We are trying to show the "$ over budget" it shows when we don't have any filters, but when we filter by name that section is blank, the budget section is blank, etc. (desktop version)

I've included photos to show both.