Export or back up the relevant data first. Do not delete, void, unreconcile, or adjust historical transactions unless you understand the accounting impact.
Menu names can change. We link current first-party instructions so you can confirm product behavior before acting.
Start with reconciled available cash, not the balance-sheet total. Build a weekly 13-week view of collectible receipts, approved payments, payroll, tax, debt, owner activity, and one-time events; separate committed items from assumptions; run downside cases; and replace forecast values with actual bank activity every week. QuickBooks planning features can help, but the forecast is reliable only when timing and completeness are reviewed.
Best for: owners, controllers, and advisers managing short-term liquidity with QuickBooks data
What this guide covers—and what it does not
The page owns one search intent: building and maintaining a short-term cash-flow forecast using QuickBooks data. Related jobs have their own canonical guides so you can move between them without mixing product selection, setup, troubleshooting, and migration advice.
- This page owns short-term liquidity timing and forecast-to-actual control.
- The budgeting guide owns account-level budgets and budget-versus-actual performance.
- The Capital guide owns evaluation of a QuickBooks financing offer, not the decision model for all liquidity problems.
Evidence-first workflow
Maintain a rolling 13-week liquidity forecast
A useful forecast is a dated control model with owners and evidence, not a static annual total divided by twelve.
- 1
Reconcile
Reconcile bank, credit-card, and cash accounts and identify restricted or unavailable balances.
Evidence: Opening available cash agrees with evidence.
- 2
Schedule
Place known receipts and payments in the week cash is realistically expected to move.
Evidence: Committed items trace to invoices, bills, payroll, tax, debt, or contracts.
- 3
Assume
Add probability-weighted collections, variable spend, seasonality, and one-time events with named owners.
Evidence: Every forecast-only item has a documented basis.
- 4
Stress
Model delayed receipts, lost sales, margin pressure, urgent purchases, and minimum cash thresholds.
Evidence: Management knows the first breached week and response trigger.
- 5
Roll
Replace the completed week with actuals, explain variance, and add a new final week.
Evidence: The forecast remains 13 weeks and assumptions stay current.
Decision control
Choose from evidence, not a feature list
Use the same four gates for building and maintaining a short-term cash-flow forecast using QuickBooks data: define the job, surface constraints, choose the smallest workable option, then verify the records.
Choose the forecast horizon and evidence
Use different planning views for different decisions; do not force one model to answer every question.
| Your situation | Direction | Why |
|---|---|---|
| Can payroll and essential payments clear? | Use a weekly 13-week cash forecast | Short intervals expose timing gaps hidden by monthly totals. |
| Set annual revenue and spending targets | Use the budget owner | A budget measures operating performance and does not prove bank liquidity. |
| Evaluate a financing offer | Overlay debt terms on downside cases | Repayment timing must be tested against minimum cash, not against revenue alone. |
| Complex treasury across entities or currencies | Use a governed external treasury model | QuickBooks data may feed the model without being the complete cash-management system. |
Define available opening cash correctly
Tie each bank balance to the latest reconciliation and subsequent activity. Remove restricted cash, uncleared receipts that are not available, disputed deposits, and balances held for tax, payroll, trust, or another legal entity. Include undrawn borrowing only as a separately authorized scenario, not as cash.
Choose the cutoff time and time zone. Record outstanding checks, scheduled transfers, processor reserves, deposit delays, and minimum operating balances so the first forecast week starts from money the business can actually use.
Forecast receipts and payments by evidence and timing
Separate contracted, invoiced, probable, and speculative receipts. Use customer-specific collection behavior for material balances rather than applying one average to everything. For payments, include approved bills, payroll, payroll tax, sales tax, debt, rent, card settlements, inventory, insurance, owner activity, and recurring or annual items.
Do not double-count an expense once as an accounts-payable payment and again as a card or bank transaction. State gross-versus-net behavior for payment processors, financing deductions, and interaccount transfers.
Use scenarios and control the model
Maintain a base case and a small set of decision-relevant downside cases. Each assumption needs a source, owner, date, and expiry. Protect formulas and opening balances, restrict edits, and retain versions used for decisions.
Set action thresholds before the forecast reaches them: collection escalation, discretionary-spend hold, inventory reduction, owner approval, credit draw, or professional restructuring advice. The forecast should trigger decisions early rather than merely describe a missed payment afterward.
A cash forecast is planning information, not assurance that customers will pay or funding will remain available. Verify lending, tax, payroll, and legal obligations independently.
Reconcile actual cash and learn from variance
At the same time each week, import or record actual activity, reconcile the bank, and compare forecast with actual by timing, amount, omission, and classification. Preserve the prior version before rolling forward.
Distinguish a timing variance from a permanent economic change. Update assumptions only when evidence changes; do not silently rewrite the old forecast to match actuals. Report ending cash, headroom over the minimum, largest uncertainties, and decisions required.
Completion checklist
Do not call the decision or setup complete until someone independent of the initial change can verify these items.
Frequently asked questions
Is the QuickBooks cash-flow planner the same as a budget?
No. A cash-flow view focuses on when money enters and leaves accounts. A budget normally measures planned income and expense by accounting period. Use both when both decisions matter.
Why does profitable business still run out of cash?
Profit can include unpaid sales, noncash entries, and timing different from inventory purchases, debt, tax, payroll, and capital spending. Forecast the actual cash dates.
Should I include a credit line as cash?
Show available borrowing separately with its authorization, conditions, cost, and downside effect. It is not the same as an unrestricted bank balance.
Still comparing adjacent tasks? Use the complete guide library to find the one page that owns your intent.
Sources checked
First-party product documentation used to verify the workflow and risk notes in this guide.