How to Set Up a QuickBooks Cash Flow Projection

A useful QuickBooks cash flow projection starts with reconciled cash, converts expected business activity into dated receipts and payments, and shows when the available balance may cross a decision threshold. QuickBooks can supply historical data, open transactions, reports, and product-specific forecasting tools. Management still has to validate assumptions and update the forecast with facts that are not yet in the books.

Do not confuse a projection with the Statement of Cash Flows. The statement explains historical changes in cash from operating, investing, and financing activity. A forecast estimates future timing and is a planning model, not a completed financial statement.

Choose the right forecast horizon

Use a rolling 13-week forecast when weekly liquidity matters. It is detailed enough to expose payroll, tax, rent, debt, large vendor payments, and customer-collection timing. Use a 12-month monthly forecast for hiring, equipment, financing, distributions, and longer operating decisions. Some businesses maintain both and reconcile their overlapping periods.

Define the cash threshold before building the model. It may be a minimum bank balance, weeks of fixed costs, debt-covenant buffer, or owner-approved reserve. The forecast should answer when the threshold is approached and which decisions can change the result.

Confirm which QuickBooks forecast tool exists

QuickBooks capabilities differ by current product. Intuit’s July 2026 documentation says Intuit Intelligence can create a 12-month forecast and scenarios from historical QuickBooks Online or Intuit Enterprise Suite data, subject to stated data and product requirements. Enterprise Suite also has more detailed cash flow and three-way forecasting features.

Intuit separately states that the old Cash Flow Projector was discontinued in QuickBooks Desktop 2022, although it may remain in earlier currently supported versions. Do not follow an old menu path without confirming the exact product and version. A spreadsheet connected to controlled QuickBooks exports remains a valid approach when the in-product tool does not match the required horizon or detail.

Reconcile starting cash

1. List every bank and cash account that belongs in the projection.
2. Reconcile each through the latest available statement date.
3. Identify outstanding checks, deposits in transit, transfers, restricted cash, and unavailable funds.
4. Separate credit-card availability from cash. An unused credit line is financing capacity, not a bank balance.
5. Record the forecast opening date and approved starting cash.

QuickBooks Online’s cash-flow chart may use connected bank and debit-card history and has documented exclusions. Intuit notes that its chart can exclude manually entered transactions, credit-card transactions, journal entries, multicurrency transactions, and data from disconnected accounts. Understand the tool’s data set before relying on the number.

Build the cash-in schedule

Start with customer-level or channel-level receipts rather than revenue alone. An invoice recorded this month may be collected next month, while a loan draw or owner contribution creates cash without revenue.

• Open receivables, adjusted for customer-specific payment behavior and disputed amounts.
• Expected cash sales and card settlements, shown net or gross with a consistent fee treatment.
• Recurring customer payments and deposits.
• Tax refunds, insurance proceeds, grants, asset sales, and other non-operating receipts.
• Approved financing, owner contributions, and transfers from accounts outside the model.

Assign an owner and confidence level to large receipts. A signed contract is not cash; connect it to delivery, invoicing, approval, and expected collection dates.

Build the cash-out schedule

Use accounts payable, contracts, payroll calendars, tax schedules, debt documents, and operating plans. Profit-and-loss expense history does not capture every future cash payment and can include noncash items.

• Vendor bills by expected payment date, including critical suppliers and disputed invoices.
• Payroll, benefits, reimbursements, payroll taxes, and contractor payments.
• Sales tax, income-tax estimates, property tax, licenses, and other government payments.
• Rent, insurance, subscriptions, utilities, and recurring operating costs.
• Inventory purchases, equipment, deposits, and capital expenditures.
• Loan principal, interest, leases, distributions, and owner draws.

Separate payments that can move from those that cannot. This makes the forecast actionable when a low balance appears.

Calculate the weekly projection

For each period, use:

Beginning available cash + expected receipts − expected payments = ending available cash.

The ending balance becomes the next period’s beginning balance. Keep operating, investing, and financing categories visible so a positive balance funded by new debt is not mistaken for operating improvement.

Use one row or connected schedule for each material assumption. Store the source, owner, last update, confidence, and notes. Do not type an unexplained plug into “other cash” to make the model balance.

Create scenarios

Maintain a base case, a downside case, and a defined action case. Change the underlying driver rather than applying a general percentage to everything. Examples include:

• A major customer pays two weeks late.
• Sales volume falls while payroll remains fixed.
• Inventory must be purchased earlier than expected.
• A hiring date moves by one month.
• A credit line is drawn only after a specified trigger.
• Discretionary spending is deferred without interrupting customer delivery.

AI-assisted or statistical forecasts can identify patterns, but Intuit itself advises reviewing forecasts and scenarios before making decisions. Unusual contracts, expansion, customer concentration, tax payments, and financing terms require management input.

Worked example

A consulting company begins Week 1 with $86,000 of reconciled available cash. It expects $54,000 of customer receipts and $72,000 of payroll, rent, vendors, and tax payments. Projected Week 1 ending cash is $68,000.

Week 2 includes a $60,000 customer receipt, but the controller marks it as medium confidence because the customer’s approval is incomplete. Without that receipt, ending cash falls below the company’s $45,000 reserve in Week 3. Management assigns the account manager to resolve approval, postpones a discretionary equipment purchase, and confirms the credit-line notice period.

The next week, only $40,000 of the invoice is expected on time. The controller updates the receipt rather than preserving the favorable assumption. The forecast becomes a decision system, not a static presentation.

Compare forecast to actual

Every week, freeze the prior forecast and compare actual beginning cash, receipts, payments, and ending cash. Classify differences as timing, amount, missing item, duplicate, classification, or forecast-model error. Update future periods and assign corrective work.

Also compare the projection to the QuickBooks balance sheet, receivable aging, payable aging, bank reconciliations, payroll liabilities, sales-tax liabilities, debt schedules, and Statement of Cash Flows. A forecast cannot compensate for unreconciled books.

Common forecasting failures

• Starting from the bank website without accounting for outstanding items and restricted cash.
• Using revenue and expenses as if their dates equal cash receipts and payments.
• Omitting payroll taxes, loan principal, owner activity, capital purchases, and annual payments.
• Assuming every open invoice will be collected on its due date.
• Relying on a QuickBooks chart without understanding included and excluded data.
• Overwriting the prior forecast, which hides forecast accuracy.
• Reporting a low-balance week without assigning an action, owner, and deadline.

Decision rule

Use a QuickBooks cash flow forecast for decisions only when starting cash is reconciled, receipts and payments have dated sources and owners, product-specific data limitations are documented, material scenarios are tested, and forecast-to-actual differences are reviewed on a fixed schedule. Rebuild the model when unexplained differences recur or the business model changes.

Continue with the Accounting Software and Tools hub, review the balance sheet, understand the cash flow statement, or strengthen corporate cash flow management.

Educational information only. Tax, payroll, and compliance rules change and may vary by jurisdiction. Confirm the current requirements for your facts with the appropriate agency or a qualified professional.

For help building and maintaining a decision-ready forecast, review Steady’s cash flow and budgeting services.