I am developing a cash flow forecast within Quickbooks for a client - I am trying to avoid the need for excel. The forecast must bring in P&L and BS items any ideas?

Thank you for reaching out, Richard. Cash flow forecasting in QuickBooks is designed to estimate the movement of money into and out of your business over a specified period.

This process primarily utilizes your Profit and Loss (P&L) report, capturing operational revenue and expenses directly influencing cash levels. However, please know that Balance Sheet items aren't included in this forecast, as they reflect the company's assets and liabilities rather than actual cash movements.

That said, you need to generate these two different reports and save their to ensure you can easily access the data the next time you need it.

1. Pull up the Balance Sheet or Profit and Loss report.
2. Ensure to set the appropriate filters.
3. Once done, click Save As and make sure to add a unique Report name.
4. Then, click Save.

Afterward, you can navigate to the Custom Reports tab to view your saved report.

I'll also share this article if you want guidance in creating financial budget for a specific year: Create budgets.

Feel free to use the Reply button if you have other questions about this.