cancel
Showing results for 
Search instead for 
Did you mean: 
steve-fitzgerald
Level 2

Roll-up Budgets

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.

6 Comments 6
Catherine_B
QuickBooks Team

Roll-up Budgets

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!

Marc_H
Level 1

Roll-up Budgets

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
Moderator

Roll-up Budgets

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.

Ramona Steed
Level 1

Roll-up Budgets

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
QuickBooks Team

Roll-up Budgets

Thanks for joining this thread. , @Ramona.

 

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.
    Capture.JPG
  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, @Ramona!

KM111
Level 1

Roll-up Budgets

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 to get in touch?

Contact us