A cash-flow forecast is a dated plan of money expected to enter and leave your business. It helps you ask whether you can meet upcoming commitments if payments arrive as expected, arrive late, or do not arrive. It is not a promise about the future.
Products marketed as an “AI CFO” may help categorize records, explain changes, or draft scenarios. That label does not make the software a qualified financial professional or give it authority to spend money. For a solo business, a checked spreadsheet and a clear review routine are a useful starting point.
Begin with records, not generated growth
Choose a short planning horizon that fits your business, such as the next several weeks. Use a confirmed opening cash balance and list expected receipts and payments by date. Reconcile the underlying records first; duplicated transactions or an old balance make every later calculation less useful.
Separate an accepted job, an issued invoice, and a cleared payment. Also distinguish sales from loans, transfers, and money you contribute personally. They can all affect cash, but they have different meanings. Ask your accountant how to classify unfamiliar entries.
The SBA’s financial-management guidance distinguishes cash and accrual recording and recommends managing receivables, payables, available cash, and reconciliation. Your forecast should be consistent with the underlying records while making the timing of actual receipts and payments explicit.
Make assumptions visible
For each expected receipt, record the amount, expected date, evidence, and uncertainty. A signed order with payment terms is different from a hopeful sales inquiry. Do not ask AI to turn a pipeline probability into a definite payment date.
List known obligations, planned purchases, recurring subscriptions, payroll where applicable, debt payments, owner withdrawals, and tax amounts advised or established for your circumstances. Include annual bills in the week they fall due. Do not use a chatbot’s generic tax percentage as a personal calculation.
- Opening cash: the checked balance at the start of the period.
- Receipts: money expected to become available during that period.
- Payments: money expected to leave during the period.
- Closing cash: opening cash plus receipts minus payments.
Carry each closing balance into the next period as its opening balance. Avoid counting both a card purchase and its later card repayment as separate cash outflows in the same forecast. The correct treatment depends on the accounts and timing represented; resolve that before relying on the totals.
Use scenarios to expose timing problems
Here is a simplified fictional example. Opening cash is $4,000, expected receipts are $3,000, and scheduled payments are $5,500. The projected closing balance is $1,500. This is arithmetic, not a suggested reserve or a forecast for your business.
Now suppose $2,000 of those receipts arrive one period later. Current-period receipts fall to $1,000, giving a projected closing balance of minus $500. Total sales may be unchanged, but their timing creates a shortfall. Move the delayed receipt to the later period rather than deleting or duplicating it.
Compare a base case with specific alternatives: a customer pays late, a necessary repair occurs, or a supplier requires an earlier payment. Name the assumption behind each change. A negative projected balance is a prompt to investigate and discuss options, not an instruction to borrow, skip an obligation, or transfer personal funds automatically.
Give AI the supporting work
Use fictional or minimized data while building the model. With appropriate authorization and privacy settings, AI can help explain a formula, identify missing dates, or draft questions about unusual changes. Keep bank credentials and payment authority out of the task.
Review this cash-flow table for inconsistent dates, possible duplicate entries, missing assumptions, and arithmetic to verify. Explain the effect of the stated delayed-payment scenario. Do not invent revenue, change the records, recommend borrowing, or treat estimates as confirmed receipts.
Check calculations with spreadsheet formulas or another reliable method. Compare every narrative claim with the table. An explanation such as “sales are falling” may be wrong when receipts merely moved between weeks. Keep the original entries available and record accepted corrections.
Keep pricing analysis separate from prediction
AI can organize the costs of a proposed service, but it cannot establish what customers will pay. For a fictional $500 project with $150 in direct costs, $350 remains before overhead, your time, taxes, and other expenses. If the work takes ten hours, that is $35 per hour before those remaining costs.
Compare alternatives using actual cost records and realistic delivery time. Add revision and support work. Do not treat competitor prices generated by AI as verified quotes, or assume a higher price leaves demand unchanged. A price decision requires commercial judgment as well as arithmetic.
Update the forecast with actual results
At each review, replace past estimates with confirmed receipts and payments, explain differences, and extend the planning horizon. Repeated late payments or underestimated costs deserve investigation. A model that never records its misses cannot tell you whether its assumptions are improving.
Take significant cash concerns, tax questions, borrowing decisions, or uncertain accounting treatment to a qualified professional. Keep the wider weekly business dashboard focused on current work, with this forecast available for a deeper look. Useful AI assistance makes assumptions easier to question; it does not make uncertainty disappear.
Reviewed September 28, 2026. Prepared with AI assistance and checked against the linked sources. This article provides general information, not personal professional advice. See our disclaimer.
Photo: Jakub Żerdzicki on Unsplash. Illustrative stock photograph, not a demonstration or endorsement of AI software.
