How to Manage Cash Flow in a Small Business (Weekly Cash Check)

A small cleaning company can have a full schedule, send its invoices on time, and still struggle to cover payroll. Customers may pay thirty days after a job. Wages, rent, and supplier bills come due on fixed dates. The owner needs to see those dates together before the bank balance gets uncomfortably low.

Cash flow management starts with a simple question: how much money will actually be available on each upcoming payment date? Check your opening bank balance, expected receipts, dated payments, and the lowest projected balance. If the lowest point falls below the amount your business needs to operate safely, decide what can change before the bill comes due.

Open the editable Google Sheet: Free 13-week cash-flow forecast (Google Sheets), including a first-four-week check, reserve assumptions and an editable delayed-payment scenario. Its sample amounts are fictional. Replace them with verified receipts and payments before making decisions.

Start with a 20-minute Monday cash check

This is the owner’s weekly decision routine. If you need the worksheet setup and roll-forward procedure, use how to build a 13-week cash-flow forecast. For receivables that may delay the incoming cash, see how to track unpaid invoices.

The free 13-week Google Sheets forecast lets you do this with linked weekly calculations and a four-week summary. You can also start with your own simple spreadsheet. Set aside twenty uninterrupted minutes once a week with your current business bank balance, unpaid customer invoices, bills due, payroll calendar, and any scheduled tax or loan payments. A part-time bookkeeper may supply those records, but the owner still needs to decide what to do when the numbers show a gap.

1. Confirm the cash available today. Use the bank’s current available balance, adjusted for outstanding checks, deposits in transit, restricted funds, and payments the bank hasn’t posted yet. Don’t treat an approved loan you haven’t drawn or a customer invoice you haven’t collected as cash on hand.

2. List realistic cash receipts by expected payment week. For each invoice, consider the customer’s payment history, whether it is disputed, and when the funds will actually clear. Separate confirmed receipts from hopeful sales. A new quote isn’t cash you can count on.

3. List all cash payments by due date. Include payroll and employer-related payments, rent, suppliers, loan repayments, insurance, taxes, and equipment purchases. Split bills into amounts that must be paid as scheduled and discretionary spending that can be reviewed. Use the real legal or contractual deadline for required payments, not a convenient estimate.

4. Calculate the balance after each week’s receipts and payments, then find the lowest point. Choose a business-specific minimum cash buffer by looking at upcoming essential obligations and the risks of delayed customer payments. A reserve of $8,000 might be an appropriate planning trigger in the example below, but it isn’t a universal recommendation.

The arithmetic is straightforward: closing cash = opening cash + expected cleared receipts − payments due. Next week’s opening cash is the previous week’s closing cash. A four-week check helps spot near-term problems; use a longer rolling forecast if customer payment cycles or seasonal costs require more lead time.

A four-week example that changes the owner’s decision

Imagine Northgate Property Services, a fictional eight-person commercial cleaning business. It starts with $18,000 in available cash. Payroll is paid every other week. One large client is expected to pay $9,000 during week three, but a billing dispute means the money is now more likely to arrive in week four. The owner updates the forecast rather than showing the money in the earlier week.

All figures are hypothetical, and each week’s opening cash equals the previous week’s closing cash. Week four’s $15,000 includes the delayed $9,000 plus another $6,000 of expected collections. Before the customer delay, the week-three forecast would have shown $11,000 in receipts and $9,500 in closing cash. With the revised collection date, it falls to $500.

If Northgate uses $8,000 as its chosen operating floor, the updated week-three forecast shows a $7,500 shortfall against that floor. It may still be able to pay the listed bills, but the tiny remaining balance leaves little room for another late receipt or urgent repair. The warning arrives before week three, which gives the owner time to speak to the customer, verify other receivables, and examine payments that can legitimately be moved.

Notice that the month ends with $8,500 in cash. Looking only at the start and end of the month would hide the week-three squeeze. The lowest intermediate balance is often the number that changes the owner’s decision.

Choose a cash reserve using your own obligations

A useful reserve target starts with what the business must actually pay, how unpredictable collections are, and the amount of time it would need to respond to a downturn. There is no universally safe number of weeks. The workbook’s Reserve Target tab asks for essential weekly outflows, the coverage window you choose, and a one-off risk allowance.

For example, if essential spending averages $8,500 a week and the owner wants enough cash for two weeks of those obligations plus $5,000 for plausible one-off costs, the target is $22,000. That is an illustrative planning assumption, not a rule. The owner should compare it with real payroll dates, tax deposits, seasonality and collection risk. A target above current cash describes a gap to plan for; it does not mean the business should borrow immediately.

How to respond when the forecast dips below your minimum

First, check whether the gap is real. Confirm the dates on the largest expected receipts and essential bills. A receipt recorded on Friday may not be available until a later banking day. A tax deposit or a payroll run may have an earlier processing cutoff than the date shown on the invoice calendar.

Then contact customers whose payments are overdue or disputed. Send an accurate invoice or corrected supporting document promptly. Ask for a realistic payment date and record what was actually agreed. Count a promised payment as a forecast assumption, and revisit it if the customer doesn’t confirm or meet the date.

Next, inspect discretionary spending and suppliers whose terms permit a different payment schedule. If a supplier agrees to move a $4,000 equipment payment from week three to week four, Northgate’s projected week-three balance would rise from $500 to $4,500. That still falls $3,500 short of its $8,000 planning floor. Moving one bill has eased the immediate squeeze without solving it fully, and the extra week-four payment also has to be included in the revised forecast.

Do not simply postpone payroll, required tax deposits, or other legally protected obligations. If meeting those payments is at risk, speak to your accountant, payroll provider, or qualified adviser promptly about the applicable rules and options. The IRS describes employment-tax deposit obligations in Publication 15; the dates depend on the employer’s circumstances, so a general cash-flow article cannot assign your filing or deposit schedule. Source: https://www.irs.gov/publications/p15

If timing changes and collections cannot close the gap, compare any financing option by how quickly funds are available, the full repayment obligation, fees, collateral requirements, and whether the business can repay it after the delayed cash arrives. A loan used to cover a repeating operating loss may increase the pressure. Work out the underlying cash problem before accepting a financing offer.

Fix the habits that create avoidable cash delays

Billing is one place to start. A field technician may finish the job on Thursday, while the office doesn’t invoice until Tuesday because completion paperwork is missing. Record what evidence billing needs, who supplies it, and when the invoice is due. A billing-ready handoff can shorten avoidable administrative delay without changing the customer’s contracted terms.

For customer deposits or milestone payments, agree on the terms before starting work and make sure the business can deliver what it promises. Deposits are not automatically free money; the business may still owe labor, materials, and the service itself. If you collect earlier, keep the future cost of delivery in the forecast.

Large supplier purchases deserve the same check. A lower unit price on bulk supplies can cost more cash this week than a smaller order at ordinary pricing. Compare what is needed for confirmed upcoming jobs against storage, spoilage, and available cash. A manager may decide to buy less now even when the discount is tempting.

Review recurring payments. A software subscription nobody uses, an old equipment rental, or a service renewal at a higher rate may be easy to overlook when each payment is relatively small. Cancel only when doing so won’t create a more expensive disruption or breach a contract.

Add a monthly review without turning it into a finance project

Once a month, compare the prior forecast with what actually happened. Which customer payments were late? Which supplier or payroll amounts surprised you? Did the lowest balance dip below the threshold you had chosen? Record the difference and one change to make the next forecast more realistic.

Northgate discovers that the same large customer regularly disputes invoices missing an approved change record. The owner assigns the office coordinator to check those records before an invoice is sent, then examines the next month’s invoices for delays. That is a more useful action than simply entering “collect faster” into the monthly meeting notes.

Keep your forecast separate from accounting profit. Profit reflects revenue and expenses under the accounting method being used, while the cash check tracks actual money arriving and leaving. A profitable company can face a short-term cash squeeze, and a cash deposit can temporarily increase the bank balance even though the business still owes work or repayment. Your accountant can help reconcile the forecast with the books. For broader background, see Bank of America’s explanation of cash-flow management: https://business.bankofamerica.com/en/resources/cash-flow-management-basics-for-small-businesses

Use the four-week cash check in the Google Sheets forecast

The editable 13-week Google Sheets forecast places each week in a separate column. Rows hold available opening cash, expected receipts, dated payroll and other payments, net cash movement, closing cash, the chosen cash floor, and the gap below that floor. Its Weekly Cash Check tab automatically summarizes the first four weeks. This differs from a simple one-row-per-week manual tracker.

Enter incoming cash and outgoing payments as positive numbers in the relevant category and week. The spreadsheet calculates cash in, cash out, net movement, and closing cash, then carries closing cash to the next week’s opening balance. The sample Northgate forecast closes its first four weeks at $13,000, $16,000, $500, and $8,500; the $500 third-week low is $7,500 below its illustrative $8,000 floor.

The forecast separates payment-date verification (row 30) from cash-input verification (row 31). Each starts at ACTION REQUIRED. The status remains VERIFY INPUTS until both are REVIEWED. A zero in a later week may just be an unfilled assumption, so the owner must confirm real obligations and receipts before trusting the projected closing balance. The Delay Scenario tab tests a customer receipt moving to a later week, while Reserve Target uses assumptions you choose for your own business. This article focuses on decisions the owner makes from those results; the forecast workbook contains the formulas and weekly closeout record.

Make a copy, replace the fictional amounts, reconcile the forecast to actual bank movements each week, and assign a next action when the projected balance falls below your chosen floor. For the build and weekly rollover procedure, use the Start Here and Weekly Closeout tabs. The workbook also shows how actual bank movements compare with what was forecast.