How to Build a 90-Day Cash Flow Forecast as a Freelancer

How to Build a 90-Day Cash Flow Forecast as a Freelancer
You know that feeling when a client pays late and rent suddenly becomes a problem? Not because you are not earning enough, but because the timing is wrong. That is the core freelance money problem: a strong quarter on paper can still leave you scrambling in week six.
A cash flow forecast fixes visibility, not revenue. It shows what is coming and when. You can build a working version in under an hour. Millions of people work as independent contractors in the US, and for many of them timing risk matters as much as total billings.
Why is revenue the wrong number for bills?
Revenue does not pay bills. Cash in your account pays bills, and those two numbers rarely match.
Revenue counts when you invoice. Cash flow counts when money lands. Example: say you bill $8,000 on June 1 with net-30 terms. That cash does not exist until July. June expenses are still due in June.
A cash flow forecast closes the gap. It maps arrivals and exits week by week so you can see problems 30, 60, or 90 days before they become emergencies.
What do you gather before you start?
Gather three inputs:
Expected income for the next 90 days. Confirmed contracts, recurring retainers, and invoices already sent but unpaid. Skip prospects and "probably" work. Only count money you have a strong reason to expect.
Fixed expenses. Rent, insurance, subscriptions, loan payments. Anything on a predictable schedule.
Variable expenses. Tools you might add or drop, contractor payments, marketing spend. Estimate conservatively and round up when unsure.
Also mark tax outflows. IRS estimated tax due dates do not wait for late clients, and self-employment tax still applies on net earnings under IRS SE tax rules.
How do you build the week-by-week forecast?
Open a spreadsheet or notebook. Create columns for the next 13 weeks. Fill three rows.
Row 1: Cash in. For each week, enter amounts you expect to receive on the date money arrives, not the date you earned it. Example: a $3,000 invoice on net-15 terms sent last Tuesday belongs in the week that payment should land.
Row 2: Cash out. Enter expected expenses by week. Fixed costs go in their usual weeks. Variable costs get your best estimate. Optimistic expense guesses are how freelancers get surprised.
Row 3: Running balance. Start with your current bank balance. Each week, add cash in and subtract cash out. That running number is your forecast balance if expectations hold.
How do you read the running balance?
Scan the running balance left to right for three patterns.
Dips. Any week below your comfort threshold is a warning with time to act: invoice earlier, follow up on open invoices, or delay a discretionary purchase.
Gaps. A negative balance is a real problem ahead, found early. Options can include faster payment terms, a short fill-in project, or moving money from savings.
Surges. Weeks where cash piles up are for funding tax savings, rebuilding a buffer, or investing in the business. Without a forecast, surplus cash feels like spending money. With one, you can see next month's rent or next quarter's tax payment inside the pile.
How do you keep the forecast alive?
Update every Monday for about 10 minutes. Move the window forward one week. Add new invoices or contracts. Adjust timing if a client will be late. Update expenses when something changes.
After a few months, patterns show up. Maybe Q1 is always slow. Maybe one industry always pays late. Those patterns turn the forecast from a guess into a planning tool.
See Pyne pricing if you want cash-flow tracking beside your invoices. Rowan, Pyne's AI financial copilot, is built to help you see timing, not to replace your judgment.
What mistakes break a freelance forecast?
Counting prospects as income. A pipeline is not cash in until there is a signed contract or confirmed project.
Ignoring taxes. Put estimated tax payments in the weeks they are due. Leave them out and the forecast pretends you have money you do not.
Being too granular. You do not need to forecast every coffee. Round personal spending to a weekly number and save precision for client payments, rent, taxes, and contractors.
Ignoring processing delays. Card and wallet payouts often take a few business days to hit your bank. Factor that lag into "cash in" weeks.
A solid 90-day forecast gives confidence, lead time, and leverage. Most freelancers run money by checking a bank balance and hoping. A forecast replaces hope with a calendar you can act on.
Sources
See what's coming with your money →
Related
Pyne provides estimates and general financial insights for informational purposes only. This is not tax, legal, or financial advice.