How to Build a Four-Week Cash Flow Plan for Your Business

Build a four-week cash forecast from your bank balance, invoices and bills. Use a worked naira example to see the impact of a late payment.

How to Build a Four-Week Cash Flow Plan for Your Business

A print shop can finish an order this week, pay for paper and labour and wait until next month for the customer to pay. A cash forecast shows whether the shop can cover wages and suppliers during that wait.

1. Reconcile your starting balance

Choose a starting date and match your cash records to your bank accounts. Record usable business cash. Give money reserved for an obligation a separate line so you know when it becomes due. In this example the shop starts November with ₦140,000 available.

2. Record when receipts should clear

List unpaid invoices and expected customer deposits. Enter the week you expect the money to clear. Keep customer receipts separate from owner contributions and loan proceeds. If you add borrowing, also enter its repayment dates and charges.

3. List your payments by date

Include supplier bills, wages, rent, utilities, taxes due, loan payments and planned owner withdrawals. Give each large payment a date and a person responsible for checking it.

4. Carry the closing cash into the next week

Add receipts to opening cash and subtract payments. Use the result as the next week's opening balance. In this hypothetical example, week two includes a ₦120,000 invoice expected to clear on 13 November.

Print shop forecast in naira
Week ending Opening In Out Closing
7 Nov 140,000 80,000 110,000 110,000
14 Nov 110,000 150,000 140,000 120,000
21 Nov 120,000 40,000 90,000 70,000
28 Nov 70,000 100,000 70,000 100,000

Check payment dates within the week. A bill due Monday can create a shortfall before Friday's receipts arrive. FDIC cash flow guide

5. Test a delay and update your figures

Move the ₦120,000 receipt from week two to week four. Week two ends at ₦0 and week three shows a ₦50,000 funding gap. Week four can still end at ₦100,000 before any cost of covering that gap. The shop can confirm the invoice date, delay a discretionary purchase or agree revised supplier terms ahead of time.

At the end of each week, compare the forecast with cleared transactions, update unpaid items and add one more week. If stock and invoice terms regularly tie up cash, calculate the time between paying suppliers and collecting customer payments. AlexJots cash conversion cycle guide

Share

What's Your Reaction?

Like Like 0
Dislike Dislike 0
Love Love 0
Funny Funny 0
Angry Angry 0
Sad Sad 0
Wow Wow 0