Don't Miss Payroll: How to Forecast Cash and Buy Yourself Time

The fear of not making payroll is a heavy one. You’ve probably felt it—that knot in your stomach as the end of the month approaches and you’re staring at your bank balance, wondering if all the pieces will fall into place. It’s a common struggle for founders, especially in the early stages, and it's a critical threat to your business.

Missing payroll, even once, can shatter trust with your team, damage morale, and lead to your best people looking for opportunities elsewhere. It signals instability, and it can be incredibly hard to recover from. The good news is that with a simple, consistent habit, you can see these problems coming weeks in advance and take action.

The core idea is to understand your cash flow, not just your profit. Profit tells you if your business can make money, but cash flow tells you if you have money in the bank right now. You can be profitable on paper but still run out of cash if your customers pay slowly or your inventory sits too long. A simple 13-week cash flow forecast is your early warning system. It's a look ahead at every naira coming in and going out, showing you exactly when you might hit a tight spot.

Building Your 13-Week Cash Flow Forecast

This isn't about complex accounting software. All you need is a spreadsheet. This forecast will help you visualise your cash position every week for the next three months, giving you enough time to react.

Here’s how to set it up and use it:

1. Set Up Your Spreadsheet

Start by labeling 13 columns as "Week 1," "Week 2," and so on, beginning with the current week, and add a "Description" column to the far left. For rows, create main sections for "Beginning Cash Balance," "Cash Inflows," "Total Cash Inflows," "Cash Outflows," "Total Cash Outflows," "Net Cash Flow (Weekly)," and "Ending Cash Balance." Within "Cash Inflows," include rows for customer payments (such as sales or project milestones), deposits received, loan disbursements (if any), and other income. Under "Cash Outflows," list payroll (salaries, benefits, employer contributions), rent & utilities (electricity, internet), supplier payments (inventory, raw materials, services), marketing & advertising, software subscriptions, loan repayments, and other operating expenses (like transport or office supplies). The "Beginning Cash Balance" is how much cash you start each week with. "Net Cash Flow (Weekly)" is your total inflows minus total outflows, and "Ending Cash Balance" is your beginning cash balance plus your net cash flow.

2. Populate Your Starting Point

In "Week 1," enter your actual cash balance in your bank account(s) today under "Beginning Cash Balance."

3. Forecast Your Cash Inflows (Be Realistic)

Go through each "Cash Inflows" row for all 13 weeks. For customer payments, project what sales you realistically expect to collect each week. Don't just list what you've invoiced; list what you expect to receive. For example, if customers usually pay 30 days after an invoice, project that payment 4 weeks from the invoice date. If you run an e-commerce store, consider your average weekly sales volume. If you're a service business, think about when your next project milestones are due for payment. For deposits received, if you collect upfront deposits for services or custom orders, note when you expect these to hit your account. Finally, include any other expected money, like grants or asset sales, under "Other Income."

4. Forecast Your Cash Outflows (Be Thorough)

This is where you list every expense you anticipate, broken down by week. Payroll is your most critical item; mark down exactly when salaries and related taxes (like PAYE) are due. For many, this is monthly, so it will show up as a large outflow in specific weeks. For rent & utilities, note when your rent is due and when you typically pay for electricity, internet, and generator fuel. Review your vendor invoices for supplier payments; record the payment due date, not just the invoice date. If you're running paid ads, when are those marketing & advertising bills due? List all recurring monthly or annual software subscriptions that will hit your account. If you have loans, when are the repayments due? Finally, think about weekly transport costs, office supplies, data bundles, and similar items under 'Other Operating Expenses'; even small, recurring expenses add up.

5. Calculate and Track

For each week, calculate your "Total Cash Inflows" and "Total Cash Outflows." Then, determine your "Net Cash Flow (Weekly)" by subtracting total outflows from total inflows. Finally, calculate your "Ending Cash Balance" by adding the net cash flow to your beginning cash balance. This ending balance then becomes the "Beginning Cash Balance" for the next week.

As each week passes, update your "Beginning Cash Balance" with your actual bank balance, and adjust your future inflows and outflows based on what truly happened. This keeps your forecast current.

Spotting the Danger Signs and Pulling the Levers

Once your forecast is built, look at the "Ending Cash Balance" row. Any week where this number looks dangerously low (e.g., below 2 weeks of critical expenses like payroll and rent) or goes negative, that's your warning sign. This is where you need to act.

Here are the levers you can pull to improve your cash position and buy yourself time:

Lever 1: Speed Up Cash Coming In (Accelerate Receivables)

This is often the most impactful lever. Getting paid faster means cash in your bank sooner. First, tighten payment terms for new clients or projects by asking for a higher upfront deposit or shorter payment terms, such as 50% upfront and 50% on delivery, or net 7 days instead of net 30. Review your standard contracts and invoices; can you change "payment within 30 days" to "payment within 14 days"? Second, offer early payment discounts. A small discount, for example 2% for payment within 7 days, can incentivise customers to pay quickly. For large invoices, consider calling the client and offering this if they can pay immediately. Third, follow up aggressively but politely. Don't be shy about chasing overdue invoices; set up reminders. A simple phone call can often resolve a forgotten payment. Implement a reminder system, perhaps an automated email three days before the due date, another on the due date, and then a call three days after. Finally, simplify payment methods. Make it easy for customers to pay you by offering multiple options like bank transfer, online payment links, or POS, and ensure your payment links are reliable. Aim to make checkout seamless and direct. When customers complete an order, ensure the payment goes straight to your bank account. This eliminates typical delays from payment gateways or marketplace aggregators, helping you get your cash as quickly as possible. Consider how a caution fee deposit hold lifecycle could improve immediate cash by securing rentals with an upfront deposit.

Lever 2: Slow Down Cash Going Out (Manage Payables)

While you want to get paid fast, you can often negotiate to pay your suppliers a little later. Start by negotiating longer payment terms with your suppliers; can you extend payment from 15 days to 30 or even 45 days? This frees up cash for longer. Prioritise key suppliers and explain your situation calmly and professionally; they often prefer a slightly later payment to no payment at all. Next, pay on the due date, not before. Unless there's an early payment discount, don't pay invoices the moment they arrive. Schedule payments for their actual due date and set calendar reminders for all bill due dates. Lastly, if cash is truly tight, prioritise payments by distinguishing between critical payments, such as raw materials that stop production, and non-critical ones.

Lever 3: Reduce Non-Essential Spending

This is about cutting fat, even temporarily. Consider pausing discretionary marketing; can you temporarily scale back paid ad campaigns or defer a branding project? Review your marketing budget to identify what can be paused for a few weeks without long-term damage. Next, defer non-critical purchases. Do you really need that new laptop this month, or can it wait? Make a list of all planned purchases and mark them 'essential' or 'deferrable.' Finally, review your subscriptions. Are you using all your SaaS tools? Cancel or downgrade any that aren't critical by auditing all recurring monthly charges on your bank statement.

Lever 4: Optimise Inventory (If Applicable)

Cash tied up in inventory is cash you can't use for payroll. First, order smaller, more frequent batches. Instead of a huge order every quarter, can you order smaller amounts every month or two? This reduces the amount of cash sitting on shelves. Second, clear slow-moving stock by offering discounts or bundles to move old inventory and convert it back into cash. Identify your oldest or slowest-selling items and plan a promotional sale. Implement inventory tracking to understand sales trends precisely. Knowing which items move quickly and which don't is key to making smart ordering decisions and avoiding overstocking, which directly impacts cash flow.

Lever 5: Short-Term Financing (Use with Caution)

Sometimes, despite your best efforts, you might need a short-term bridge. An overdraft facility, if you have a good relationship with your bank, can be a lifesaver for small, temporary gaps, but understand the fees and interest. A small, short-term loan might also be an option, but only if you have a clear plan to repay it quickly and the cost of borrowing doesn't outweigh the benefit. This should be a last resort.

Common Mistakes Founders Make (and How to Avoid Them)

Here are some common mistakes founders make and how to avoid them. First, confusing profit with cash. Your P&L (Profit and Loss statement) shows if you're making a profit, but it doesn't show when cash actually hits or leaves your bank. You can have high sales but still be broke if customers pay late. To avoid this, always keep your cash flow forecast separate from your profit reports and focus on when money moves. Second, not forecasting at all. Many founders operate week-to-week, only checking their bank balance when a big bill is due, which is like driving blind. Avoid this by committing to building and updating your 13-week forecast weekly; it takes less time than the panic of a payroll crunch. Third, over-optimism on inflows. You might project sales based on your best-case scenario, but when reality hits, those payments might be delayed or smaller. To avoid this, be conservative with income projections; underestimate inflows and overestimate outflows. It's better to be pleasantly surprised than caught short. Fourth, ignoring small leaks. Those small monthly subscriptions, little transport costs, or daily petty cash expenses add up. Avoid this by treating every outflow, no matter how small, with scrutiny and reviewing all recurring expenses regularly. Finally, waiting until the last minute. If your forecast shows a cash crunch in Week 8, waiting until Week 7 to act is often too late, as negotiating payment terms or speeding up collections takes time. As soon as you spot a potential gap, start pulling the levers; the earlier you act, the more options you have.

Your Cash Flow Checklist

• Set up your 13-week cash flow spreadsheet.
• Input your current bank balance as Week 1's starting cash.
• Forecast all expected cash inflows, being realistic about payment dates.
• Forecast all expected cash outflows, especially payroll and rent, by their due date.
• Calculate weekly net cash flow and ending cash balance.
• Identify any weeks where your ending cash balance is critically low.
• If a cash gap appears, immediately explore levers:
  • Speed up customer payments (deposits, early payment discounts, follow-ups).
  • Negotiate longer payment terms with suppliers.
  • Reduce non-essential spending.
  • Optimise inventory levels.
• Update your forecast weekly with actual figures.

What I'd do this week

1. Build that spreadsheet: Spend an hour setting up your 13-week cash flow forecast. Don't worry about perfection; just get the framework in place with your current cash, upcoming payroll, and biggest known inflows/outflows.
2. Identify your riskiest week: Look at the forecast. Which week shows the lowest ending cash balance? That's your immediate focus.
3. Pick one lever to pull: For that risky week, decide on one concrete action you can take. Maybe it's calling your largest outstanding customer to confirm payment, or negotiating a 15-day extension on a non-critical supplier invoice.

Managing cash flow isn't glamorous, but it's the heartbeat of your business. By consistently looking ahead with a simple forecast and being proactive with the levers you have, you build resilience and ensure you can always stand by your commitment to your team.

— Samuel