top of page
Search

How to Prepare Cash Projections Clearly

  • Writer: Mary Nicks
    Mary Nicks
  • 27 minutes ago
  • 6 min read

The month rarely gets away from a small business owner all at once. It happens invoice by invoice, bill by bill, payroll run by payroll run. On paper, sales may look fine, but if cash is not timed well, pressure builds fast. That is why learning how to prepare cash projections matters so much. It gives you a clearer picture of what is coming in, what is going out, and where you need to make wiser decisions before stress turns into crisis.

For a business with 10 or fewer employees, cash projections are not just a finance exercise. They are part of faithful stewardship. When you know what your cash is likely to do over the next few weeks and months, you can lead with more confidence, protect your team, and make decisions from clarity instead of fear.

What cash projections actually show

A cash projection is a forward-looking estimate of the money that will move through your business over a set period of time. It is different from a profit and loss statement. Profit tells you whether your business is earning more than it spends overall. Cash projections tell you whether cash will be available when you need it.

That distinction matters. You can show a profit and still struggle to pay vendors if customers are slow to pay. You can also have a month with healthy cash because a large receivable came in, even if your true profitability needs work. Good business decisions require seeing both.

For most small businesses, a 13-week cash projection is one of the most practical tools to start with. It is short enough to be realistic and detailed, but long enough to help you spot a problem before it arrives.

How to prepare cash projections step by step

The goal is not to predict the future perfectly. The goal is to create a planning tool you can trust enough to guide decisions.

Start with your beginning cash balance

Begin with the actual amount of cash your business has available today. Use the balance in your business checking account and include savings only if those funds are truly available for operations. If you keep reserve funds set aside for taxes or emergencies, be careful not to treat them like everyday cash.

This first number sets the tone for the entire projection. If it is inaccurate, every week after it will be distorted.

Choose a time frame that matches your reality

Weekly projections usually work better than monthly ones for smaller businesses. Monthly views can hide timing issues that cause very real stress. A weekly format helps you see whether payroll hits before customer payments arrive, whether rent and debt payments stack up in the same week, and whether a sales dip is likely to create a shortfall.

If your business has highly predictable billing, monthly may be enough for long-range planning. But if cash feels tight or inconsistent, weekly is the wiser place to start.

Estimate cash coming in

Next, list expected cash receipts by week. This includes customer payments you expect to collect, not just sales you hope to make. That difference is one of the biggest mistakes business owners make when preparing projections.

Use current accounts receivable, open invoices, recurring client payments, and realistic future sales based on actual trends. If a client usually pays in 30 days, do not place that cash in next week just because you sent the invoice today. If sales vary seasonally, reflect that honestly.

This is where discipline matters. Optimism is valuable in business, but inflated cash assumptions create avoidable pain. A conservative estimate is usually more helpful than an ambitious one.

List the cash going out

Once receipts are mapped out, enter all expected cash outflows. Include fixed expenses such as rent, payroll, software subscriptions, insurance, loan payments, and utilities. Then add variable expenses like materials, shipping, contractor payments, marketing, and owner draws.

Be especially careful with irregular expenses. Annual renewals, quarterly tax payments, equipment repairs, and debt settlements often get forgotten because they do not happen every week. Yet those are the very items that can disrupt cash flow when they land unexpectedly.

It helps to break expenses into categories, but keep the format simple enough that you will actually maintain it. A projection that is used every week is far more valuable than a perfect spreadsheet you abandon after two updates.

How to prepare cash projections that are realistic

Once your inflows and outflows are listed, calculate the net cash change for each period and add it to your beginning balance. That gives you your projected ending cash balance for each week.

At this stage, patterns start to appear. You may notice a dip in week four because payroll, rent, and a supplier payment all hit before receivables clear. You may spot a stronger week after recurring client payments come in. That visibility is where the real value begins.

Still, a projection is only useful if it reflects the way your business actually behaves. That means revisiting your assumptions regularly. If customers are paying more slowly than expected, adjust. If expenses are rising, adjust. If sales are strengthening, reflect that too. Cash projections should be living tools, not static reports.

Use three versions when uncertainty is high

If your revenue changes from month to month, consider building three views: conservative, expected, and strong. This does not need to be complicated. It simply gives you a range so you can prepare for a likely low-cash scenario without losing sight of upside potential.

This is especially helpful for service businesses with uneven project timing, retail businesses with seasonal swings, or any business navigating a growth transition. It can also bring peace, because uncertainty feels less threatening when you have already thought through your options.

Common mistakes small business owners make

Many owners do not struggle because they lack intelligence. They struggle because they are carrying too much, moving too quickly, and making financial decisions without a clear system.

One common mistake is confusing booked revenue with cash received. Another is leaving out owner compensation or tax obligations because those numbers feel flexible or uncomfortable. Some owners underestimate expenses to make the projection feel more hopeful. Others fail to update it often enough, which makes the tool stale before it can help.

There is also a practical trade-off to watch. Too little detail makes projections vague. Too much detail makes them hard to maintain. The right level is the one that helps you make decisions consistently. For many very small businesses, clarity beats complexity every time.

What to do when the projection shows a shortfall

If your cash projection shows that you may run low in a future week, that is not failure. It is a gift of early warning. You still have time to respond.

You may decide to speed up collections by following up on invoices earlier, asking for deposits upfront, or tightening payment terms for new clients. You may delay a nonessential purchase, renegotiate payment timing with a vendor, or reduce a discretionary expense that no longer supports your priorities. In some cases, a shortfall points to a pricing problem or a debt burden that needs deeper attention.

Not every solution is ideal. Delaying payments too often can strain relationships. Cutting too deeply can hurt operations. Offering discounts for fast payment may reduce margin. This is why cash management requires wisdom, not just math. The best response depends on the cause of the shortfall and the broader health of your business.

Turn the projection into a weekly habit

A cash projection works best when it becomes part of your leadership rhythm. Set aside time each week to compare projected numbers to actual results. Update receipts, revise expenses, and look ahead again. This practice does more than improve your spreadsheet. It sharpens your judgment.

Over time, you will start to notice trends earlier. You will make fewer reactive choices. You will also become a better steward of the resources entrusted to your business.

For many owners, this is the point where financial stress begins to ease. Not because every problem disappears, but because uncertainty loses some of its power when you have a clear process. That kind of clarity supports wiser decisions, steadier growth, and greater peace.

If you have never built a cash projection before, start simple. One sheet. Thirteen weeks. Real numbers. Honest assumptions. Then review it every week and let it teach you what your business needs. Faithful stewardship often looks less dramatic than people expect. Sometimes it is simply paying close attention, planning ahead, and leading your business with both courage and care.

 
 
 

Comments


Lighthouse Image
  • Facebook
  • Twitter
  • Instagram

​© 2024 MNConsulting, LLC – Your Partner in Faith-Based Money Coaching, Financial Freedom Planning, and Debt-Free Living.

bottom of page