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.
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.
| 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
0
Dislike
0
Love
0
Funny
0
Angry
0
Sad
0
Wow
0
