QuickBooks Online offers a lot of various reports. However, Budget Balance Sheet isn't included. I'm taking note of it and I'll personally send this suggestion to our product developers.
For now, available reports are for budgeting are Budget Overview and Budget vs. Actual.
If you need more help with QuickBooks, please let us know. Thanks!
We are using the present Budgeted PNL and Sales Budget by Class, to load and report on our budget, and find these features very useful.
Adding a Budgeted Balance Sheet input feature, is obviously much more challenging, but would be a HUGE help to any business preparing a budget, and is essential if ever you aspire to producing a Budgeted CASH FLOW - a really useful future requirement for most businesses.
Looking forward to an update on IF AND WHEN, otherwise I will continue top develop our EXCEL version.
I am assuming from your reply that you cannot pull the budgeted balance sheet data (through QuickBooks Budgeting & Forecasting) into a Statement Writer report? Or Excel? Correct. I've been trying to find someone who is struggling with Budgeted P&L and Budgeted Balance Sheet and Budgeted Cash Flow reports also. Thanks for your help.
A budget to achieve target account balances at year end would be helpful for non-profits that do a lot of fund accounting and track progress, not just on the P&L but also on the Balance Sheet. Thank you.
I appreciate your suggestion, @rdavis7.
Currently, the ability to create a budgeted balance sheet is not available. What you can do for now is to generate the Budget overview or the Budget vs. Actual report. From here you can customize the report to specific target accounts.
Alternately, a budgeted balance sheet is available in the QuickBooks Desktop version.To learn more about how you can create a budgeted balance sheet in QuickBooks Desktop, you can read through this article: Create a budget or forecast in QuickBooks Desktop.
Feel free to drop your comments below if you have other questions. I'm always here to help.
To begin, go to Company > Planning & Budgeting > Set Up Budgets.
Step 1: Select Budget Year
Use the arrows to select the year for which you want to create this budget.
Step 2: Choose Budget Type
Choose the budget type. You can create a Profit and Loss budget or a Balance Sheet budget.
The Profit and Loss budget offers a more complete view of your yearly activity, whereas the Balance Sheet budget deals predominantly with your ending balances.
I hope this helps.
Sr. QuickBooks accounting Consultant