Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
jhalfhill-charte
Level 1

Please explain why Quickbooks allows you to create a Balance Sheet Budget, but you are unable to use it anywhere? It does not show up in any drop down box under reports

I am trying to create a budget vs. actuals report using a created Balance Sheet budget. Quickbooks allows me to create the budget (by selecting "Balance Sheet" as opposed to "Profit vs. Loss") however, there seems to be no way to use the created Balance Sheet Budget, anywhere.
5 Comments 5
MJoy_D
Moderator

Please explain why Quickbooks allows you to create a Balance Sheet Budget, but you are unable to use it anywhere? It does not show up in any drop down box under reports

Thank you for reaching out to us regarding the Balance Sheet budget report, @jhalfhill-charte.

 

To help me better assist you, could you please provide more information on where you plan to use this report? This will enable me to provide you with a more accurate solution to your concern. 

 

Please feel free to click on the Reply button below to add more details. 

 

Looking forward to hearing back from you soon. Have a great day ahead and stay safe!

jhalfhill-charte
Level 1

Please explain why Quickbooks allows you to create a Balance Sheet Budget, but you are unable to use it anywhere? It does not show up in any drop down box under reports

Thank you!

 

So, my goal was to create a budget using our balance sheet account lines and be able to run a Budget vs. Actuals report. 

 

When I go to run a report such as "budget vs. actuals" the created balance sheet budget does not show up in the drop down box when selecting a budget. I just am not sure why QB's has an option to create a budget based on balance sheet, but then not have any way to use that budget.

 

 

JaeAnnC
QuickBooks Team

Please explain why Quickbooks allows you to create a Balance Sheet Budget, but you are unable to use it anywhere? It does not show up in any drop down box under reports

Your confusion ends here, Jhalfhill. Allow me to explain why Balance Sheet budgets are not showing in the Budget vs. Actuals report in QuickBooks Online (QBO).

 

When running the Budget vs. Actuals report in QBO, the information displayed is limited to income and expenses. Since the Balance Sheet contains assets, liability, and equity accounts, the program is unable to generate the Balance Sheet budget report. 

 

As a workaround, you can use the Spreadsheet Sync feature in QBO Advanced, so you'll have the freedom to seamlessly create budget reports relevant to your business needs and transfer the data between the program and your Microsoft Office Excel. 

 

Additionally, you can utilize the cash flow planner in QBO to forecast your income and expenses. This way, you can add and adjust future items to see how certain changes affect your finances.

 

Feel free to reach out to us anytime whenever you have further concerns about creating budgets. The Community is always here to help. Stay safe, and have a good one.

jhalfhill-charte
Level 1

Please explain why Quickbooks allows you to create a Balance Sheet Budget, but you are unable to use it anywhere? It does not show up in any drop down box under reports

Thank you for your response. I will look into using Spreadsheet Sync.

 

I am still unsure why QB gives you the option to select creating a Balance Sheet Budget, but then does not offer any place that can be used. I don't see anywhere it shows up to be utilized within QB's. 

CharleneMaeF
QuickBooks Team

Please explain why Quickbooks allows you to create a Balance Sheet Budget, but you are unable to use it anywhere? It does not show up in any drop down box under reports

I understand the importance of running the Balance Sheet Budget report, jhalfhill.

 

In QuickBooks Online, the Balance Sheet Budget report only allows you to review and edit your financial data. As of now, this is unavailable in the Reports section. As a workaround, I recommend running the Budget vs. Actuals instead. It summarizes accounts alongside your actual account totals. It also shows how much you're under or over budget. 

 

Here's how:

 

  1. Go to Reports.
  2. Type in Budget vs. Actuals.
  3. Review the data.

 

I can see how this functionality would be beneficial to your business. I encourage sending a feature request directly to our Product Development team. Doing so helps us improve the features of the program. I'll show you how:

 

  1. Go to the Gear menu and then select Feedback.
  2. Type in your feature request in the description box.
  3. Once done, click on Next.

 

You can get back on this thread to stay informed if there are any updates regarding the availability of the option. If you have any other questions about the program's features, please don't hesitate to keep us posted.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us