Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThank 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!
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.
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.
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.
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:
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here