Showing results for 
Search instead for 
Did you mean: 
Level 1

Budget and forecast reporting

Is 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.

5 Comments 5
Michael K

Budget and forecast reporting

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!

Level 1

Budget and forecast reporting

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.


Budget and forecast reporting

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!

Level 1

Budget and forecast reporting

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

QuickBooks Team

Budget and forecast reporting

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:


  • A QuickBooks file that contains your data.
  • The Report Designer window for customizing.
  • Microsoft Excel for reviewing your document and making additional changes.


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!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up