Finance dashboard
—
The month in brief
September sales were —, — on last year, and — for the year so far. Trading profit for the year so far is —, — on last year. On the store's own forecast, cash is at its lowest in the week ending —, at —.
On track, watch or act, against the thresholds under the notes
Sales, September
——
— on September last year
Trading profit, year to date
——
— on the same months last year
Gross margin, year to date
——
— on last year
Lowest cash, forecast to December
——
Week ending —, on the store's forecast
Bank covenant, first test
——
Minimum —. Headroom — for the year
Dead stock
——
— of the stock measured. Nothing sold in five months
ActualForecastBelow zero
This yearLast year
Sales and trading profit: on track at — on last year or better, watch down to —, act beyond that (trading profit uses — and —). Gross margin: on track at — on last year or better, watch down to —, act beyond that. Lowest cash: on track above —, watch down to —, act below that. Bank covenant: on track at — or more above the minimum, watch down to — above it, act below that. Dead stock: on track under — of the stock measured, watch to —, act above that. These are set under Settings. The small charts show the last twelve months, the forecast weeks, or the years of the facility.
September sales were —, — against September 2025. Year to date the change is —. Restarted from the actual bank balance at 31 October, the store's cash forecast reaches its lowest point of — in the week ending —. With November and December receipts scaled to the sales in the Nedbank model, the lowest point is —.
Sales, September
—
— on September 2025
Sales, March to September
—
— on the same months last year
Trading profit, September
—
— on September 2025. Margin estimated.
Profit before tax per the ledger, September
—
Overstated: see the first point under data to fix.
Cash and near cash, 30 September
—
Includes — in the PSG account
Debtors, 30 September
—
— days of September credit sales
Suppliers, 30 September
—
— days of September purchases
Stock per Intouch, 31 July
—
Ledger: —
This yearLast year
Actual to 31 OctoberForecastBelow zero
| Month | Sales | Last year | Change | Margin % | Last year % |
|---|
Sales exclude VAT unless a tab says otherwise. Month figures from the ledger are the movement between two trial balances, so an entry posted to an earlier month after that month was reported lands in the later month. Trading profit is profit before tax, interest received and dividends received, with cost of sales restated to the Intouch trading account margin. For August and September that margin is last year's less 0.70 points, pending the Intouch reports. Cash and near cash is the current account, the salaries account, the PSG rand account, the notice deposit and the floats. Debtor days are debtors divided by the month's credit sales including VAT, times 30. Supplier days are the supplier and creditor control accounts divided by the month's purchases including VAT, times 30.
Daily sales, margin by department and stock by line will update themselves once the Intouch feed is running. Until then each tab is refreshed from the monthly documents.
Actual per the bankForecast, restarted from the bankBelow zero
The first column is the store's file as typed. The second restarts it from the bank balance at 31 October, trading and call accounts together. The third also scales card, cash and account receipts to the sales in the Nedbank model, using September's receipts as a share of sales, and leaves payments as typed. It is a test of the receipts, not a forecast: lower sales would also bring lower supplier payments.
| Week ending | Store file | Restarted from the bank | Receipts on model sales |
|---|
From 31 August to 31 October the trading account received — in card settlements. The 13-week file records —, a difference of —. Cash deposits reaching the account were — against — in the file, a difference of —. Both differences need explaining before the forecast is relied on.
| Week ending | Cards per bank | Cards per file | Difference | Cash per bank | Cash per file | Difference |
|---|
End-of-day balance per the FNB statement. The month-end peaks are transfers in from the call account ahead of the creditors run.
Every transaction on the trading account, grouped into the lines of the 13-week cash flow. Receipts are positive and payments negative. Transfers to and from the call, salaries and PSG accounts move cash between the store's own accounts.
Trading profit for March to September is —, — on the same months last year. The gross margin is — against — last year, and expenses have changed by —.
Trading profit, September
—
September 2025: —
Trading profit, year to date
—
Last year: —
Trading profit, last 12 months
—
Year to February 2026: —
Gross margin, year to date
—
Last year: —
Expenses, year to date
—
Last year: —
Payroll as a share of sales
—
Last year: —
This yearLast year
Year to February 2027Year to February 2026
| Month | Sales | Gross profit | Margin % | Rebates and discounts | Expenses | Trading profit | Last year | Margin basis |
|---|
| Line | This year | Last year | Change | Change % |
|---|
Over the — months reported, March to July 2026, the listed departments sold — including VAT, — on last year. The largest fall is — at — and the largest gain is — at —.
March to July 2026 against March to July 2025, in rand including VAT.
From the store's Business Section Analysis, including VAT. The listed departments do not add up to the whole store, and gross profit by department is not in any report on file: it comes with the Intouch feed.
| Department | Sales | Last year | Change | Change % | Against budget |
|---|
From the ledger, excluding VAT. The monthly average is the starting point for agreeing purchasing limits with each department: a limit is still to be set against it.
| Department | Purchases | Last year | Change % | Monthly average |
|---|
Of the — of stock measured in both February and July, — (—) did not reduce at all in five months, and — shows the same unit count in all three reports.
Stock per Intouch, 31 July
—
Ledger: —
Two years of cover or worse
—
— of the stock measured
Dead stock
—
— lines, the clearance list
February 2026 count, net variance
—
Across — product groups
Lines with data errors
—
— at negative cost
Cost value at 31 July 2026, by months of cover at the February to July rate of sale.
Intouch basis. August and September 2026 are estimates from purchases and sales.
| Category | Lines | Cost value | Two years cover or worse | Share | Dead | Share |
|---|
Lines with an identical unit count in the February, June and July reports, largest first. The full list is in the stock analysis workbook.
| Line | Category | Code | Units | Cost value |
|---|
| Product group | Variance | Counted by |
|---|
Nedbank tests one ratio each February: EBITDA divided by debt service must be at least —. In the first test year, to February 2028, debt service is —, so the store must earn EBITDA of at least —, which is — a month. The bank model has it earning —, leaving headroom of — for the year. Trading profit over the last twelve months was —.
An incentive is an expense, so every rand paid comes off EBITDA. The rule that keeps staff and the bank on the same side: pay a share of trading profit above a threshold, and set the threshold no lower than the EBITDA the covenant requires. A pool is then only ever paid out of profit the bank does not need.
At this threshold a pool is paid only in a year when cover is already above the minimum, so the pool itself cannot cause a breach on the bank model's debt service.
This threshold is below the EBITDA the covenant requires, so a pool could be paid in a year the covenant fails. Raise it to at least —.
| Trading profit for the year | Against the bank model | Pool | Per person | Profit kept | Cover after the pool | Covenant |
|---|
The threshold opens at the bank model's figure for the year to February 2028. Trading profit here means the store's EBITDA before the group services charge, the same measure the covenant uses. Staff sharing in the pool opens at the 25 people on the April 2026 salary review. Nothing here has been announced or agreed.
On the bank model, cover in the first test year to February 2028 is — against a minimum of —. That is headroom of — of EBITDA for the whole year.
Term facility
—
— months at —
Monthly instalment
—
Capital and interest, from January 2027
EBITDA the covenant requires, FY2028
—
Model: —, consolidated
Overdraft requested
—
Working capital
Bank model, consolidatedRate up 3 points and expenses up 10%Store alone after the group services charge
| Year to February | EBITDA | Debt service | Cover | EBITDA required | Headroom | Stressed cover | Loan at year end |
|---|
From the Nedbank model, version 8. FY2027 is not tested. The covenant in the expression of interest is EBITDA to debt service on the consolidated group. The store alone, after the group services charge, does not clear the minimum in any year, which is why the facility agreement must define the test on the consolidated basis.
Open any line to see it month by month, and an expense month to see the ledger entries behind it. Ask for commentary on any line once it is open.
Every month in the period. Months after the last ledger month are the model's forecast and are marked.
The standard format for any capital proposal: the Paint relocation, equipment, a new hire. Enter the proposal's own figures. Results appear once there is a cost and a return.
The required return opens at the facility's interest rate. Payback is the capital cost and extra stock divided by the yearly cash return. Net present value discounts the yearly cash return over the useful life, releases the extra stock at the end, and ignores tax. The covenant line shows first-year cover if the return is earned in full: EBITDA rises by the yearly return, and capital cost does not reduce EBITDA.
For the DIY problem-solving kits: what a kit costs to put together and what it must sell for.
The target margin opens at the store's gross margin for the year to date. Margin is gross profit divided by the selling price excluding VAT.
Everything the dashboard and the reports run on, in one place. A change here shows on the dashboard as soon as it is saved, and the reports use it from their next run. Everyone who can open the dashboard can read these settings, and only its editors can save them.
Summary is the short version for owners. Full detail adds every figure and the checks behind them. A reviewer gets a report even when its checks fail, marked HELD, so it can be put right before anyone else sees it.
| Name | Version | Daily | Weekly | Monthly | Reviewer |
|---|
Nobody is set up yet. Add the first person below.
Where each number comes from. Passwords and keys are typed in here once the dashboard runs on its own address: the server encrypts them, uses them, and never shows them again, not even to editors. This preview has no server of its own, so it holds the rest of each connection and leaves those fields locked. Until a connection runs, its status reads Not connected yet.
FNB and Nedbank can run side by side. Give each account the dates it is in use, so the cash position counts it only while it is open, and the two banks overlap cleanly during the move.
| Bank | Account | Ending | Type | How it comes in | In use | In cash |
|---|
No accounts yet. Add the first one below.
Only the people listed here can sign in, with an emailed one-time link or with Google. For each person you choose which pages they see and which parts of Settings they can change. The server enforces it: a page someone cannot see, they cannot read the figures for either.
| Name | Role | Pages | Settings |
|---|