AI agents for business finance: what they can and can't do
What AI agents can do in bookkeeping, close, collections and compliance today, where a person must stay in charge, and how to judge a product.
The short answer
A 13-week cash flow forecast is a table with one column per week for the next quarter: opening cash, money expected in, money expected out, and closing cash, which becomes the next week's opening cash. Its main job is to show the lowest closing balance and the week it falls in, so you can act before that week arrives.
Why 13 weeks, and why weekly
Thirteen weeks is one quarter. It is long enough to capture the big lumpy payments that sink small businesses, such as annual rent, school-term salary advances, a container deposit or a generator overhaul, and short enough that your estimates are still close to reality. Monthly forecasts hide the problem: a month can end with a healthy balance while one week in the middle goes negative because rent left before customers paid.
For a Nigerian trader, distributor or service business, weekly also matches how money moves. Suppliers often want payment on delivery, market days set the rhythm of sales, and customers on credit tend to pay in irregular bursts. A weekly view catches those rhythms.
The template: rows and columns
Set up a spreadsheet with weeks 1 to 13 across the top and these rows down the side. Keep it on one screen if you can.
| Row | What goes in it |
|---|---|
| Opening cash | Cash in hand plus all business bank balances at the start of the week |
| Cash sales | Sales you expect to be paid for that same week (cash, transfer, POS, checkout) |
| Debtor receipts | Named customers on credit and the week you realistically expect each to pay |
| Other inflows | Loan drawdowns, owner top-ups, asset sales, refunds |
| Stock purchases | What you will pay suppliers, in the week you pay, not the week you order |
| Wages and salaries | In the week they leave the account |
| Rent and service charge | Often one large payment; place it in the exact week |
| Power and fuel | Electricity tokens, diesel or petrol for the generator |
| Transport and logistics | Haulage, dispatch riders, park fees |
| Tax and levies | VAT, PAYE, withholding tax, state and local levies where you pay them |
| Loan repayments | Principal and interest on the due date |
| Owner drawings | What you take out for the household |
| Closing cash | Opening cash plus all inflows minus all outflows |
The closing cash of week 1 is copied into opening cash for week 2, and so on. That single link is what turns a list of guesses into a forecast.
Filling it in without fooling yourself
- Start from your actual bank and cash balances today, not last month's accounts.
- Enter fixed payments first: rent, salaries, loan repayments, subscriptions. These are the least uncertain.
- Enter debtor receipts customer by customer, using when they actually paid last time, not the date on the invoice. Your credit sales book is the best guide.
- Estimate cash sales from the same weeks last year or the last eight weeks, adjusted for known events such as festive periods or school resumption.
- Enter stock purchases in the week cash leaves, matching your supplier terms.
- Add owner drawings. Leaving them out is the most common reason forecasts look better than reality.
Worked example: reading the low point
Example only. A provisions distributor in Lagos starts with ₦1,200,000. It buys about ₦650,000 of stock and spends ₦60,000 on diesel each week, pays ₦400,000 of salaries in week 4, and owes ₦1,500,000 rent in week 6.
| Week | Opening | In | Out | Closing |
|---|---|---|---|---|
| 1 | ₦1,200,000 | ₦900,000 | ₦710,000 | ₦1,390,000 |
| 2 | ₦1,390,000 | ₦850,000 | ₦710,000 | ₦1,530,000 |
| 3 | ₦1,530,000 | ₦800,000 | ₦710,000 | ₦1,620,000 |
| 4 | ₦1,620,000 | ₦900,000 | ₦1,110,000 | ₦1,410,000 |
| 5 | ₦1,410,000 | ₦750,000 | ₦710,000 | ₦1,450,000 |
| 6 | ₦1,450,000 | ₦800,000 | ₦2,210,000 | ₦40,000 |
Weeks 1 to 5 look comfortable, and a monthly view would show nothing alarming. Week 6 closes at ₦40,000. If the owner wants at least ₦300,000 on hand at all times, the forecast shows a ₦260,000 gap six weeks out. That is enough notice to act: ask the landlord to split the rent, collect from one large debtor earlier, buy slightly less stock in weeks 4 and 5, or arrange short-term funding before it is urgent.
What the low point tells you
- How deep: the lowest closing figure against your minimum buffer is the size of the problem.
- When: the week it falls in is your deadline for a fix.
- Why: look at which outflow lands that week. It is usually one large payment, not general overspending.
Keeping it alive each week
A forecast is only useful if it is rolled forward. Every Monday, replace last week's estimate with the actual figures, add a new week 13 at the end, and look again at the low point. After a month you will see where your guesses tend to be wrong, often in debtor timing, and you can correct for it. Reconciling your bank account first makes this much faster; see monthly bank reconciliation steps and, for high transfer volumes, payment reconciliation in Nigeria.
The weekly actuals also double as tax records. Section 31 of the Nigeria Tax Administration Act 2025 requires every person to keep records with enough detail to work out tax liability, for at least six years after the year of assessment, and PwC's tax summary (reviewed May 2026) notes that company returns are due six months after the financial year end. A forecast built from reconciled figures makes that year-end work lighter.
Keep a second, worse version: push the largest three debtor receipts back two weeks and raise stock costs by a margin you think plausible. If the business still stays above zero, you have room. If not, decide now which payment you would delay. For the bigger picture of why profit and cash part ways, see the cash conversion cycle.
Where Pryme fits
A Pryme Business Account lets you keep separate accounts for, say, rent and tax set-asides, so money earmarked for week 6 is not spent in week 2. The Finance agent can prepare the weekly actuals from your transactions for you to check; a person approves anything above the ceiling you set.
Questions people ask
What is a 13-week cash flow forecast in simple terms?
It is a weekly plan of the cash you expect to receive and pay over the next three months, with a running balance, so you can see which week money will be tightest.
Is cash flow forecast the same as profit and loss?
No. A profit and loss account records sales when made and costs when incurred. A cash flow forecast records money only when it actually enters or leaves your account.
How often should I update my cash flow forecast?
Weekly. Replace the past week with actual figures, add a new week at the end, and check the lowest balance again.
Can I do a cash flow forecast in Excel or Google Sheets?
Yes. One row per type of receipt or payment, one column per week, and a formula carrying each week's closing balance into the next week's opening balance is all you need.
Sources
- Nigeria Tax Administration Act 2025 (gazette copy), section 31 on keeping records · accessed Oct 2026
- Nigeria: corporate tax administration (PwC Worldwide Tax Summaries, reviewed 29 May 2026) · accessed Oct 2026
This article is general information, not financial, legal or tax advice. Products described are provided under the terms on this site and are subject to regulation and eligibility.