Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
NoThanks17
March 16, 2021
Question

Budget vs Actual reports

We use the Online Advanced. I am running the budget vs actual report for each of our divisions. It gives me the February amount but the total column just lists the same amount. I want it to have January and February for a total. I have checked all the settings that I know about but cannot get it to work.

29 replies

Giovann_GModerator
Moderator
March 16, 2021

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.

 

 

 

 

 

 

 

 

 

cajz24
March 1, 2022

I want to run the budget vs actual report with just Jan and what the budget is for the year. But Quickbooks is diving it over the year, which I don't want. All I need it to do is have Jan and the budget for the year. How can I do that?

    Giovann_GModerator
    Moderator
    May 20, 2022

    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 the Budget vs. Actuals report 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 to run the Budget vs. Actuals report. 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 the Gear icon.
    2. Select Account and settings.
    3. Click the Billing & subscription.
    4. Below the Company ID field, you should see your current subscription.

     

    If it isn't Plus or Advance, you can click the Upgrade your plan button to have the option to run the Budget vs. Actual report. If you have the correct subscription, ensure the budget we're set up. I'll show you how.

     

    1. Go to Settings.
    2. Click Budgeting under Tools.
    3. Select Add budget, then enter a budget name in the Name field.
    4. Complete the Fiscal Year, Interval, and Pre-fill data fields.
    5. Click Next.
    6. Enter the budget data into the table if you didn't use the Pre-fill data option.
    7. Hit Save.

     

    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 the Reply button below if you need further assistance with the reports. The Community and I will be here to help you.

    RL_Moore
    February 17, 2023

    Can I change the column heading from "Over Budget" to "Variance"?

    DivinaMercy_N
    DivinaMercy_NModerator
    Moderator
    February 17, 2023

    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 the Gear icon.
    2. Next, select the Feedback option.
    3. From there, enter the details of your product comments, suggestions, and requests. 
    4. Then, click Next to submit. 

     

    You can visit our Customer Feedback for QuickBooks Online website 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. 

    MelroseV
    Level 1
    October 19, 2023

    Hi, @Shirley11_2.

     

    I assure you I can help you with your Budget vs. Actual report.

     

    Yes, there's an option to compare the partial year and total annual budget by pulling up the Budget vs. Actual report. Let me show you how.

     

    1. At the left navigation panel, click Reports.
    2. In the search bar, type Budget vs. Actuals.
    3. Under the Report period, you can customize the date you want to see in your report. 
    4. Click Run report.

     

    You can customize your report if you want to filter specific details or format.

     

    If you have any additional concerns besides reports, please let us know. Stay safe!

     

    shirley-soh
    October 19, 2023

    In QBO, I can either run a YTD vs the Whole Annual Budget or for a defined period (both reflected in the actuals and the budget.

     

    For example, I want to run the Actuals for the year to Last Month, comparing to the entire Annual Budget.  I'm not seeing this option in the customizations.

     

    I hope this is clear ... what am I missing?

     

    Thanks,

     

    Shirley

    AldritchM
    AldritchM
    October 19, 2023

    Hi, @shirley-soh.

     

    Currently, the option to compare the actuals for the year up to last month with the entire annual budget is limited to viewing it by period. I recognize your need for the said specific report in QBO.

     

    If you'd like to make the desired comparison, there's a helpful option available to you. You can export the report from QuickBooks Online (QBO) and customize it to suit your specific requirements. This way, you'll have the flexibility to tailor the report according to your needs.

     

    We value your input and want to make QuickBooks Online (QBO) even better for you. If you have a specific feature in mind that you'd like to see added to QBO in the future, we encourage you to share your feedback with our engineers. 

     

    Let me walk you through on sending feedback:

    1. Click the Gear icon.
    2. Then, select Feedback under the Profile section.
    3. Please provide a summary of the feature you would like to request.
    4. Lastly, Click Next once done.

     

    I would like to share this article to learn specific ways to customize your reports to get awesome insights. Here's the topic you can utilize for reference: Common custom reports in QuickBooks Online.

     

    If you have any further questions about QuickBooks or anything else, please don't hesitate to ask. I'm here to assist you.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement