Cash flow for freelancers: build a practical weekly forecast

Cash flow is about money and timing

Cash flow is money moving into and out of your business over a period. Net cash flow is cash received minus cash paid. A freelance cash-flow forecast estimates those movements by date so you can see whether money will be available when obligations fall due.

An invoice sent today is not necessarily cash available today. A signed project can be valuable without funding next week’s subcontractor bill. The British Business Bank explains why even profitable businesses can encounter cash shortages while waiting for customers to pay.

A forecast looks forward using assumptions. A cash-flow statement reports what happened over a past period. This guide builds a practical planning worksheet, not a replacement for formal financial statements or your accountant’s advice.

Cash flow and accounting profit answer different questions

Profit measures revenue less expenses under your accounting method. Cash flow measures receipts and payments. Harvard Business School Online explains that businesses can be profitable with negative cash flow, or have positive cash flow without being profitable.

Suppose a fictional freelancer earns and invoices $6,000 for completed work in October and incurs $2,000 in related expenses. In this simplified accrual example, with no other expenses or taxes, October profit is $4,000. If the customer pays in November but the freelancer pays the $2,000 in October, October cash flow from those transactions is negative $2,000.

Borrowing also shows why cash is not profit: loan proceeds increase cash without becoming service revenue. An owner withdrawal reduces business cash without necessarily being a profit-and-loss expense. Include actual cash movements in the forecast and let your accountant determine their reporting classifications.

Set up a rolling weekly forecast

Choose a planning horizon long enough to cover your invoice terms and upcoming commitments; the next 13 weeks is one workable starting point, not a mandatory rule. Use columns for weeks and rows for opening cash, expected receipts, planned payments, net movement and closing cash.

Closing cash equals opening cash plus receipts minus payments. Carry each closing balance into the next week’s opening balance. Forecast the accounts included in your opening total consistently. Transfers between those included accounts are not new business income or spending.

Keep notes beside uncertain dates. A single precise-looking number can conceal a weak assumption, such as treating a proposal as won or assuming a chronically late client will suddenly pay on the due date.

1. Start with the actual cash balance in the accounts covered by the forecast, excluding unused credit limits.
2. List each expected customer receipt by likely collection date, amount and invoice or agreement reference.
3. Add dated commitments: subcontractors, payroll where applicable, rent, software, insurance, taxes, debt payments and planned owner withdrawals.
4. Include one-off purchases and annual renewals rather than spreading their cash cost across imaginary monthly installments.
5. Calculate closing balances, then review the lowest balance and the payment dates within that week.

A four-week freelance cash forecast with real arithmetic

Fictional illustrator Leila starts with $3,000 in her business account. Her base case assumes customer receipts arrive before the payments listed in each week. Week 1 brings $1,200 from an older invoice and $1,700 of payments, closing at $2,500. Week 2 brings no receipts and $1,900 of payments, closing at $600.

In week 3, an expected $3,000 client payment arrives and $1,100 leaves, closing at $2,500. In week 4, receipts of $1,500 and payments of $2,000 leave $2,000. The four closing balances are therefore $2,500, $600, $2,500 and $2,000.

Total receipts are $5,700 and total payments are $6,700, so net cash flow is negative $1,000. Opening cash of $3,000 minus that $1,000 movement gives the same $2,000 final balance. Negative cash flow has reduced her cushion without making the bank balance negative.

The fictional payments include all planned movements for these four weeks; the figures do not prescribe a tax reserve or owner-pay level. Leila checks actual dates inside week 2 because its $600 closing balance leaves little room for an unplanned charge.

Stress-test a late payment instead of hiding it

Move Leila’s $3,000 receipt from week 3 to week 4 while leaving every payment unchanged. Week 3 now closes at negative $500: $600 opening cash minus $1,100 paid. Week 4 still ends at $2,000 after $4,500 of receipts and $2,000 of payments, but that eventual recovery does not fund the earlier shortfall.

The negative $500 is a projected funding gap, not an assumption that the bank will allow an overdraft. If Leila wants a minimum planning buffer of $500, she must improve the week-3 position by $1,000, not merely $500. That buffer is her chosen scenario, not a universal recommendation.

She can discuss an earlier agreed installment, defer a discretionary purchase, or negotiate a supplier date before it falls due. Count a change in the revised forecast only when its assumptions are credible; do not silently move an obligation or assume borrowing will be approved.

Keep reserved cash and uncertain sales visible

A tax reserve is not automatically spendable surplus. If reserved money is included in the opening cash total, show the restriction separately and put the actual tax payment into the relevant period. Do not subtract both an internal reserve transfer and the same eventual payment as external spending.

Separate contracted receipts from speculative sales. Keep a base case and a downside case rather than treating every proposal as certain cash. For foreign-currency receipts, state the conversion assumption and allow for a changed exchange rate instead of adding different currencies directly.

A large customer advance can temporarily improve cash while leaving substantial delivery costs ahead. Forecast those costs too. More cash this week does not necessarily mean more money is available for an owner withdrawal.

Make the forecast part of a weekly decision

At the same time each week, replace estimates with actual receipts and payments, explain significant differences, and add another week to the end. Check the largest upcoming receipt with the client’s billing process, not only with the person approving the creative work.

Finish with one specific decision: confirm a collection date, delay an optional purchase, renegotiate an upcoming commitment or seek qualified help with a shortfall. A forecast is useful because it changes a decision early, not because every estimate turns out perfectly.

Moolamochi distinguishes commercial agreement, delivery acceptance and payment records, which helps keep those concepts separate. New access is waitlist-only; this guide does not imply automated cash forecasting. Maintain the forecast in your chosen planning tool and use an accountant for accounting, tax and financing decisions.