All guides

    Freelance Cash Flow Forecasting: How to See Trouble Before It Hits

    Why "how much did I make this month" is the wrong question

    Freelance income is lumpy by nature — a big invoice clears in March, nothing lands in April, two mid-size ones clear in May. Looking at monthly totals in hindsight tells you whether you're profitable; it does nothing to warn you that the third week of next month has three fixed expenses due and zero invoices scheduled to clear before then. Forecasting means projecting forward, not reporting backward.

    The three inputs that actually matter

    1. Invoiced-but-unpaid income, by expected payment date — not by invoice date. An invoice sent today on Net 30 terms is cash you'll likely have in 30 days, not cash you have now.
    2. Recurring fixed costs — subscriptions, contractor payments, rent if you have a studio or office — on the actual day they debit, not "sometime this month."
    3. Tax set-asides on their real schedule — quarterly estimated payments hit like a fixed expense on specific dates (see the 1099 tax prep guide for the actual dates), and forecasting without them is the single most common reason a freelancer gets blindsided in April, June, September, and January.

    A minimal forecasting method you can run in a spreadsheet today

    Download the Notwen 12-week cash-flow template (CSV) and fill it once. Columns match this method: week start, expected income in, fixed expenses out, tax set-aside, running balance, notes.

    1. Open the CSV in Google Sheets or Excel.
    2. Put today's bank balance in the first running_balance cell (the example row shows the formula: previous balance + income − expenses − tax set-aside).
    3. Enter invoices by the week you actually expect them to clear — your clients' historical lag, not the contract terms.

    Build four columns: week, expected income in, fixed expenses out, and running balance. Start the running balance at your current actual bank balance and carry it forward week by week. The first week the running balance goes negative is the week you need to act on — ideally 3-4 weeks before it arrives, not the week it does.

    What to do when the forecast shows a gap

    • Move up a milestone invoice if a project has a natural billing checkpoint you haven't invoiced yet.
    • Follow up on the oldest outstanding invoice first — it's both the most overdue and the one most likely to have simply been forgotten.
    • Delay a discretionary expense, not a client-facing one — a software renewal can usually wait two weeks; a subcontractor payment usually can't without damaging that relationship.
    • Draw down a buffer intentionally, if you have one, rather than reacting the week the balance actually goes negative.

    Forecasting only works if it's current

    A forecast built once and never updated is just a guess with a spreadsheet around it. The reason most freelancers don't keep one running is that updating it means re-checking which invoices actually got paid, by hand, every week. That's the exact gap Notwen closes — invoice status, expected payment timing, and your tax set-aside all live in one place and update as the underlying data changes, so the forecast is current without you re-building it. Join early access if you want to try it on your own numbers.

    Notwen's tax reserve is the operational version of the tax set-aside column — a percentage on the ledger, not a second bank account. See quarterly estimated tax payments and the 1099 tax prep guide for the dates that column is paying toward. This is educational, not tax advice.