Skip to main content

Get 50% OFF QuickBooks for 3 months*

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?
S
steve-fitzgerald
September 7, 2020
Question

Roll-up Budgets

  • September 7, 2020
  • 2 replies
  • 0 views

There's still no budget roll-up from sub-budgets, right? Seems like an obvious feature to create and something that would be very useful and save a lot of time and decrease the likelihood  of data entry errors.

    2 replies

    C
    Catherine_B
    Level 9
    September 7, 2020

    You can run a budget report and customize it, steve-fitzgerald.

     

    While the option to view each budget displaying the amount and amount summed up is unavailable, you can run budget reports and export them to Excel. From there, you can merge and modify it further. 

     

    Here's how to run the report:

     

    1. Log in to QuickBooks Online.
    2. From the left menu, click Reports. 
    3. In the search field, enter Budget and select the report you'd like to run.
    4. Set the Report period, Compare another period, and the Accounting method.
    5. Click the Run Report button.

    From the upper-right of the report, click the Export icon and select Export to Excel. 

     

    You can also look into our third-party apps that will help you integrate the budget preference you'd like to the data within QuickBooks. Just click here and search for something like Budget. 

     

    Always know that the Community is available 24/7 to help with your questions. Take care and have a great day!

    M
    Marc_H
    January 8, 2021

    Hi, I'm wondering if there is any update on this topic? It would seem obvious that one should be able to create a number of class budgets that then roll up to an overall organizational budget. Any new ideas?

      MJoy_D
      MJoy_DQuickBooks Team
      QuickBooks Team
      January 9, 2021

      I can share some insights on how to create a budget by class, @Marc_H. 

       

      You can create a budget by class based on profit and loss from last fiscal year.  You can check your profitability by class from your last fiscal year by running a Profit and Loss by Class report. 

       

      Here's how:

      1. Go to the Reports menu and search for and run the report Profit and Loss by Class.
      2. In the top of your report choose the Report period ▼ drop-down. Then select Last year if your fiscal year starts in January. If not, select Last fiscal year.
      3. Click to Run report.

      To create a a budget for each class:

      1. Go to the Gear icon ⚙️ and select Budgeting.                                                                               
      2. Click on Add budget and set a Name. 
      3. Add all the necessary information.
      4. From the Subdivide by dropdown, organize the budget by Class. 
      5. Select Next.
      6. Enter your budget data into the table.
      7. If you don't see all your accounts and subaccounts, proceed to the Settings ⚙ icon above the Total column. Select the Hide blank rows checkbox.
      8. When you're done click on Save or Save and close.

      You can check this article for more information: Create and import budgets into QuickBooks Online.

       

      See this article for more information on how to track your transactions by class. 

       

      Let me know if there's anything that you need with creating a budget report. Take care and have a great weekend.

      R
      Ramona Steed
      November 17, 2022

      I'm wondering the same thing.  It looks like you need to enter two budgets the master and then split out by classes as well?   Did you find a work around? 

        LieraMarie_A
        LieraMarie_A
        Level 8
        November 17, 2022

        Thanks for joining this thread. , @Ramona11.

         

        I can see how it would be helpful to have a budget roll-up from sub-budgets. For now, QuickBooks Online displays the figures for each class by column and shows you the total in the last group column. I encourage you to add your vote for this one by sending a feature request in the Feedback section within QuickBooks. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers.

         

        Here's how:
         

        1. Select the Gear icon at the top, then Feedback.
        2. Enter your comments or product suggestions then select Next.
        3. You'll be provided a list of suggested Help articles related to your comment. You can read through them or select Skip and send message.
        4. From the drop-down, choose the appropriate category, then select Send message.

         

        For your reference, check out this link: How to Submit Feedback.

         

        In the meantime, you may create a budget subdivided by class. Then, run a report and export it to Excel. This way, you have more flexibility to manage your data.

         

        Don't hesitate to ask more questions if you have them. I'm here to help. Take care always, @Ramona11!

        K
        KM111
        February 1, 2023

        Hi,

        Just to confirm - if we want a consolidated budget we need to enter it separately from the class budgets, correct.  Is there a timeframe on a 'roll-up' capability?  

        Thank you,

        Kristin

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