Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs there a way to run a report or manipulate a current report to show budget vs. forecast? This seems like a very common comparison that business would want to make.
Hey there, @kyoung24. Happy to provide some insight here.
Budgeting and forecasting are two of the most significant financial tools for a business of any size. Budgeting and forecasting are frequently connected together, as they ought to be, yet they're not the same. While budgeting and forecasting have different uses, they do share some similarities. Truth be told, an acceptable forecast takes care of the advancement of a sound budget. During the year, comparing the latest forecast with the budget for the remainder of the period can enable your business to make required decisions to meet changing business conditions.
At the moment, QuickBooks Desktop doesn't have a combined report to compare the two. For now, you'll need to run a Budget report and compare it with your Forecast report. Since this is a pretty neat idea, I'm going to forward this to our Product Development Team for further review. We take your ideas and feedback serious, as it's what makes us the best, after all!
For more information on budgets and forecasts in QuickBooks Desktop, I recommend checking out this awesome article.
Let me know if you have any other questions. I'm here to ensure your continued success. Have a good one!
I found Clearify QQube and was able to connect the data to Microsoft Power BI for a profit and loss report actual vs forecast vs budget, but our IT people moved our QB file and broke my connection. I haven't been able to get it re-established because Clearify has terrible tech support.
Intuit please create this a profit and loss report actual vs forecast vs budget. I have to create it quarterly.
Hello there, AWooton.
I'll take note of this suggestion and share it with our Developers team. I'd also recommend sending feedback on your end through the Gear icon.
To check the status of this shared product idea, you can visit this page: Customer Feedback.
I've also added this guide if you want to remove or add some data whenever you run a report: Customize reports.
I'll be around if there's anything that I can help with. Keep safe!
Does Statement writer have the ability to compare actual to previous year to budget. I see where I might be able to add that column but it is greyed out
Thank you for joining this thread, webb13.
Let me share what I know about QuickBooks Statement Writer.
The QuickBooks Statement Writer has a Report Designer feature which provides an ability to customize reports footers. How ever, it doesn't have the ability to compare actual to previous year to budget reports.
There are the three main components for QuickBooks Statement Writer:
I'm adding this article to learn more about using QuickBooks Statement Writer: Use and navigate QuickBooks Statement Writer (QSW)
Post a question below if you have other concerns. I'm always here to help. Have a nice day!
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.