Capital FieldbookCompare providersCompare
← Field guides

Build a 13-week cash flow forecast before borrowing

Find the week cash goes short and test whether a loan actually fixes the problem.

Jump to the guide ↓

Compare providers

A short list of providers to explore alongside this guide.

See all options ↗
3 providers
ProviderWhat to verifyExplore
LendioMarketplace
Compare multiple funding categories through a marketplace. Confirm which provider would fund the transaction and receive your data.
BluevineCredit line platform
Compare draw and repayment options. Confirm the issuing lender, draw rules and payment frequency.
OnDeckOnline financing provider
Consider term and line options for an operating business. Ask for the fee schedule and credit inquiry process.

Capital Fieldbook does not lend or accept applications. Check current terms and eligibility directly with the provider.

Start with cleared cash

Use the current bank balance adjusted for outstanding payments and separate cash that is reserved for taxes or legally restricted. Put thirteen week-ending dates across a sheet. Make rows for opening cash, customer receipts, other cash inflows, payroll, taxes, suppliers, rent, debt service, one-time expenses and closing cash. Each closing balance becomes the next week's opening cash. Reconcile week one to the bank before building scenarios around numbers you have not verified.

Schedule receipts by expected payment

Use the accounts receivable aging report, customer correspondence and prior payment behavior. A $40,000 invoice sent today does not put $40,000 into this week's cash if the customer pays next month. Break large receipts into named, dated entries internally so they can be moved independently. Keep committed payments on their actual due dates. Flag the ones you can renegotiate rather than assuming that every vendor can be stretched without losing supply.

Locate the low point

Suppose cash opens at $30,000, week-one receipts are $12,000 and outflows are $27,000. Closing cash is $15,000. If week two brings $5,000 and requires $18,000, the balance falls to $2,000. With an operating floor of $10,000, the shortfall is $8,000 before funding costs. Calculate the lowest gap across all thirteen weeks. A quote for just $8,000 could still be inadequate if a fee is withheld or loan payments arrive before collections recover.

Stress the assumptions

Move the two largest receipts out by a week or two and increase one controllable expense, such as shipping or rework. Compare that scenario with your base case. Then test a smaller customer deposit, staged inventory order or vendor extension as alternatives to borrowing. Add each loan as a real deposit and a dated repayment series. If the forecast only improves in week one and drops below the floor later, the funding has shifted the problem rather than resolved it.

Use the forecast every week

Replace the first projected column with bank-cleared actuals, document material variances, and extend the horizon by one week. Ask whoever owns collections to confirm the next two weeks of receipts, and whoever owns payroll or purchasing to validate those debits. Keep the old forecast so you learn which dates are consistently unreliable. In a lender conversation, explain the source of repayment, the week the facility can be reduced, and how another delay would be handled. That makes the funding request specific without mistaking a forecast for a guarantee.

Handle gaps inside a week

A positive Friday balance can hide a Tuesday payroll shortfall. In any week close to your reserve, split the forecast into business days and check when deposits actually clear.

Record a trigger and owner for each scenario

Turn the cash forecast into a calendar of decisions. If a large deposit has not cleared by Wednesday, for instance, the owner may need to call the customer and postpone a purchase before it ships. Pick the cash floor in advance, and define which decisions require a discussion with a lender or supplier. By assigning actions to dates, the sheet becomes a way to prevent the shortfall rather than an explanation after the business has missed a payment.

Facts & sources

  • SBA emphasizes tracking cash flow, receivables and other core financial records. The numerical forecast in this guide is an editorial illustration.

    SBA · Manage your finances

Frequently asked questions

Is profit the same as closing cash?

No. A profitable sale on credit can be recorded before payment arrives; debt principal can reduce cash without being an operating expense.

Should I use thirteen weeks for long-term decisions?

Use it for near-term liquidity. Add a longer monthly forecast for asset purchases, hiring and recurring debt capacity.