Sample company
A finished analysis for Kestrel & Vine Digital, LLC, an invented business. Nothing here is mocked up: every figure is real output from the same pipeline your own files would run through — including the fields that correctly report NOT AVAILABLE because the data needed to compute them was not in the files.
All figures are in US dollars (USD), read from this company's own files.
Run selected
Client: Kestrel & Vine Digital, LLC
1 run retained · newest first
Working capital
Diagnostic for 2026-10-12
Days sales outstanding
you collect in
Days payable outstanding
you pay in
Days inventory / WIP
held as work in progress
Cash conversion cycle
Anchor
Cash today
$150.2kbelow your $150.0k floor in week 3
closing bank balance
Total receivables
$726.8k41.0% past due
open, after credit notes
Receivables distribution
Share of open AR by ageing band(click a bar to filter the risk table)
total = $726.8k
Current
$429k
1-30
$112k
61-90
$148k
90+
$38k
Days past due
13-week direct forecast
Closing balance per week
floor = $150.0k
| Week | Starting | Opening | Receipts | Payments | Closing | Confidence |
|---|---|---|---|---|---|---|
| W1 | 2026-10-12 | $150.2k | $134.4k | $70.4k | $214.1k | high |
| W2 | 2026-10-19 | $214.1k | $77.3k | $23.8k | $267.6k | high |
| W3 | 2026-10-26 | $267.6k | $30.6k | $192.8k | $105.4k | high |
| W4 | 2026-11-02 | $105.4k | $98.7k | $43.1k | $161.0k | high |
| W5 | 2026-11-09 | $161.0k | $16.0k | $0 | $177.1k | medium |
| W6 | 2026-11-16 | $177.1k | $73.6k | $69.1k | $181.5k | medium |
| W7 | 2026-11-23 | $181.5k | $72.7k | $0 | $254.2k | medium |
| W8 | 2026-11-30 | $254.2k | $91.1k | $100.9k | $244.4k | medium |
| W9 | 2026-12-07 | $244.4k | $0 | $9.3k | $235.1k | low |
| W10 | 2026-12-14 | $235.1k | $132.4k | $64.0k | $303.4k | low |
| W11 | 2026-12-21 | $303.4k | $0 | $5.1k | $298.3k | low |
| W12 | 2026-12-28 | $298.3k | $0 | $100.9k | $197.4k | low |
| W13 | 2027-01-04 | $197.4k | $0 | $6.2k | $191.1k | low |
Forecast accuracy
How close the earlier forecasts landed
NOT AVAILABLEno earlier forecast has a week that has both closed and is covered by this statement; accuracy needs a forecast made before a period this statement now covers
Upload again once a few forecast weeks have passed and this fills in: what was predicted for each week, what the bank actually closed at, and the gap between them.
Collection risk
Ranked by exposure, deterioration, concentration and broken pattern
| Score | Customer | Exposure | % of AR | Oldest | Exp. days | Recommended action |
|---|---|---|---|---|---|---|
| 82.6 | Northgate Auto Group | $147.9k | 20.4% | 61-90 | 61 | Call the account owner today and agree a dated payment commitment for the overdue balance. |
| 60.5 | Ridgeway Health Partners | $275.9k | 38.0% | Current | 94 | Nothing overdue. Worth watching: this account is a large share of the book, so a slip would be felt quickly. |
| 34.8 | Fieldstone Brewing Co. | $33.7k | 4.6% | 90+ | 50 | Call the account owner today: this balance is more than 90 days overdue. Agree a dated payment commitment. |
| 34.0 | Tidewater Legal LLP | $76.0k | 10.5% | 1-30 | 44 | Standard dunning cycle; monitor at the next run. |
| 19.2 | Orchard Lane Bakery | $4.2k | 0.6% | 90+ | 38 | Call the account owner today: this balance is more than 90 days overdue. Agree a dated payment commitment. |
| 19.1 | Copperleaf Home Goods | $80.8k | 11.1% | Current | 56 | No action; nothing is overdue. |
| 18.6 | Lumen Fitness Studios | $14.0k | 1.9% | 1-30 | 38 | No action beyond the normal statement cycle. |
| 7.1 | Harbor Point Dental Group | $8.9k | 1.2% | Current | 38 | No action; nothing is overdue. |
| 6.5 | Summit Ridge Credit Union | $27.5k | 3.8% | Current | 32 | No action; nothing is overdue. |
| 5.7 | Granite Peak Insurance Agency | $22.5k | 3.1% | 1-30 | 55 | No action beyond the normal statement cycle. |
| 5.7 | Maple & Main Realty | $7.3k | 1.0% | Current | 20 | No action; nothing is overdue. |
| 4.0 | Bluewater Logistics Co. | $16.9k | 2.3% | Current | 36 | No action; nothing is overdue. |
Top exposures
Who owe you the most, and how old it is
| # | Customer | Balance | % of total | Ageing | Oldest | Items |
|---|---|---|---|---|---|---|
| 1 | Ridgeway Health Partners incl. credit note | $275.9k | 38.0% | Current | 5 | |
| 2 | Northgate Auto Group | $147.9k | 20.3% | 61-90 | 4 | |
| 3 | Copperleaf Home Goods | $80.8k | 11.1% | Current | 2 | |
| 4 | Tidewater Legal LLP | $76.0k | 10.5% | 1-30 | 2 | |
| 5 | Fieldstone Brewing Co. | $33.7k | 4.6% | 90+ | 4 | |
| 6 | Summit Ridge Credit Union | $27.5k | 3.8% | Current | 1 | |
| 7 | Granite Peak Insurance Agency | $22.5k | 3.1% | 1-30 | 2 | |
| 8 | Bluewater Logistics Co. | $16.9k | 2.3% | Current | 1 | |
| 9 | Lumen Fitness Studios | $14.0k | 1.9% | 1-30 | 2 | |
| 10 | Sable Creek Outdoor | $11.2k | 1.5% | Current | 1 |
These 10 customers = $706.3k · 97.2% of $726.8k across 13 customers
Current1-3031-6061-9090+
Ageing derived from Due Date against 2026-10-09. Balances are after part payments and credit notes.
Expected credit loss
IFRS 9 provision on receivables, simplified approach
$29.2k
4.02% of $726.8k · as at 2026-10-09
Stage 1not past due
$4.4k on $538.0k0.8%
Stage 2past due, up to 90 days
$11.0k on $150.9k7.3%
Stage 3past due over 90 days (presumed default)
$13.7k on $37.9k36.2%
Bar length is exposure; the solid head is the allowance. Stage 3 is past due over 90 days, IFRS 9’s presumed default.
| Ageing band | Exposure | Loss rate | Rate from | Allowance |
|---|---|---|---|---|
| Current | $538.0k | 0.82% | your historylow | $4.4k |
| 1-30 | $88.9k | 0.85% | your historylow | $759 |
| 31-60 | $41.3k | 6.76% | your historylow | $2.8k |
| 61-90 | $20.7k | 36.19% | your historylow | $7.5k |
| 90+ | $37.9k | 36.19% | your historylow | $13.7k |
| Total | $726.8k | 4.02% | $29.2k |
How the derived rates were measured
From 221 invoices in your receivables file, observed as at 2026-10-09. For each band, the share of value that entered it and was still unpaid 90 days past due (the probability of default), multiplied by the share of defaulted value still unpaid 180 days past due (the loss on a default). Loss on a default: 36.19% across 8 invoice(s) that reached default — $29,410.00 of $81,270.00 still unpaid.
| Band | Invoices entered | Value entered | Reached default | P(default) | Loss rate | Confidence |
|---|---|---|---|---|---|---|
| Current | 178 | $4.0m | $89.8k | 2.27% | 0.82% | low |
| 1-30 | 172 | $3.8m | $89.8k | 2.36% | 0.85% | low |
| 31-60 | 19 | $480.6k | $89.8k | 18.68% | 6.76% | low |
| 61-90 | 9 | $89.8k | $89.8k | 100.00% | 36.19% | low |
| 90+ | 9 | $89.8k | $89.8k | 100.00% | 36.19% | low |
Largest allowances by customer
| Customer | Balance | Allowance | Coverage |
|---|---|---|---|
| Fieldstone Brewing Co. | $33.7k | $12.2k | 36.2% |
| Northgate Auto Group | $147.9k | $11.0k | 7.4% |
| Ridgeway Health Partners | $275.9k | $2.3k | 0.8% |
| Orchard Lane Bakery | $4.2k | $1.5k | 36.2% |
| Copperleaf Home Goods | $80.8k | $662 | 0.8% |
| Tidewater Legal LLP | $76.0k | $631 | 0.8% |
| Summit Ridge Credit Union | $27.5k | $225 | 0.8% |
| Granite Peak Insurance Agency | $22.5k | $188 | 0.8% |
| Bluewater Logistics Co. | $16.9k | $138 | 0.8% |
| Lumen Fitness Studios | $14.0k | $117 | 0.8% |
- The loss given default behind every non-zero rate below rests on 8 defaulted invoice(s) (36.2% of their value never recovered), which is too few to be stable - every bucket rate is therefore reported at LOW confidence however many invoices entered the bucket itself. Treat the allowance as an order of magnitude, and supply your own rates on the upload page to replace it.
- Loss rates derived from history use 90 days past due as the default point (IFRS 9 B5.5.37) and treat an invoice still unpaid 180 days past due as not recovered, because the ledger records no write-offs. Change either by supplying your own rates.
- Historical rates look backward. IFRS 9 also requires forward-looking adjustment for conditions expected over the life of the receivables; apply that overlay through the rates you supply.
- Balances are net of credit notes and part payments. Amounts already provided for in your ledger are not deducted here.
- Supply your own rates on the next upload to override any band; the derived figure stays visible beside it.
Ask about this run
A question about these numbers, answered from these numbers
Analyst and Controller plans
CFO brief
What the numbers say, and what to do this week
Kestrel & Vine Digital, LLC
13-week low $105,410.49 in week 3, ending $191,129.49 in week 13: chasing Northgate Auto Group is worth $85,719.00, the floor is breached in week 3.
Cash position and 13-week outlook · 19 October 2026 · USD
Statement 1 April 2025 to 9 October 2026 (18 months of history) · Forecast 12 October 2026 to 10 January 2027 (13 weeks)
1. Where the cash stands
Closing bank balance is $150,167.19.
Over the statement period the business was cash consuming, at an average of $11,324.32 per month.
Cash runway: 58 weeks at the current burn.
Runway divides today's balance by the statement's average burn, so it does not see timing. The 13-week forecast places each receipt and payment in the week it is expected, and on that basis cash falls below your floor in week 3. Plan around the week, not the average.
Working capital
| Metric | Value | Formula and inputs |
|---|---|---|
| DSO | 65.4 days | (average AR / credit sales) * days — average_AR 525,467.5, credit_sales 4,475,330.0, days 557, balance_basis average of opening and closing |
| DPO | 25.4 days | (average AP / COGS) * days — average_AP 112,930.0, COGS 2,472,367.64, days 557 |
| DIO | NOT AVAILABLE | this business reported no inventory in either period, so days inventory outstanding does not apply - it is not zero days |
| CCC | 40.0 days | DSO - DPO (no inventory held) — DSO 65.4, DPO 25.44 |
CCC basis: no inventory held, so CCC is DSO - DPO.
2. The 13-week picture
Opening $150,167.19 → closing $191,129.49.
The low point is week 3 at $105,410.49.
Cash falls below the $150,000.00 floor in week 3. That is the week to plan around.
Each week's closing balance is the next week's opening balance, and the chain reconciles across all 13 weeks.
Confidence: weeks 1–4 rest on invoices already issued; weeks 9–13 on behavioural projection. 86% of projected receipts come from customers whose own payment history is HIGH confidence.
3. The actions that matter this week
Open receivables are $726,795.00 across 13 customers: 59% current, 16% at 1-30 days, 20% at 61-90 days, 5% at 90+ days; nothing at 31-60 days.
Expected credit loss allowance (IFRS 9, simplified approach): $29,185.19, 4.02% of open receivables, on rates derived from your own payment history. The matrix and the evidence behind each rate are in the workbook.
1. Chase Northgate Auto Group ($147,895.00, 61-90 bucket). Risk score 82.6, 20.4% of the receivables book. Call the account owner today and agree a dated payment commitment for the overdue balance. Paid on its due date, this lifts the lowest week by $85,719.00.
2. Call Orchard Lane Bakery about KV-1113 ($4,160.00). It fell due on 2025-07-31 and has now passed that customer's own median payment lag — it was expected on 2025-08-08. Late even by their standards, which is what makes it worth a call rather than a statement.
3. Call Fieldstone Brewing Co. about KV-1168 ($8,410.00). It fell due on 2026-01-31 and has now passed that customer's own median payment lag — it was expected on 2026-02-20. Late even by their standards, which is what makes it worth a call rather than a statement.
Together the two largest exposures account for $423,785.00 — 58.3% of the receivables book.
4. Notes and limits
- DIO — this business reported no inventory in either period, so days inventory outstanding does not apply - it is not zero days
- forecast accuracy — no earlier forecast has a week that has both closed and is covered by this statement; accuracy needs a forecast made before a period this statement now covers.
- 2 repeating payment(s) were identified but not projected into the forecast: Brightdesk Software (1x, about 21,600) - only 1 occurrence(s); fewer than 3, so not projected forward; Keystone Mutual Insurance (1x, about 17,900) - only 1 occurrence(s); fewer than 3, so not projected forward. The forecast does not carry them.
- 2 credit note(s) present as negative invoices, reducing AR by 4,810.00.
- 9 invoice(s) are past due_date + their customer's own median lag: they have broken their own payment pattern.
- The receivables file carries no ageing bucket columns, so buckets were derived from each invoice's due date against 2026-10-09.
Watch list
Who has changed how they pay
2 slowing · 2 improving · 5 broken their own pattern
Northgate Auto Group
broke its patternslowingTrend: used to pay 6 days late, now pays 31 days late — 25 days slower than before.
This week: one open invoice has passed even that usual delay, so it is late by their own standard, not just yours.
Outstanding $147.9k.
The slide costs roughly $10.1k of extra financing on the current balance.
Fieldstone Brewing Co.
broke its patternTrend: used to pay 18 days late, now pays 20 days late — 2 days slower than before.
This week: one open invoice has passed even that usual delay, so it is late by their own standard, not just yours.
Outstanding $33.7k.
The slide costs roughly $185 of extra financing on the current balance.
Orchard Lane Bakery
broke its patternTrend: used to pay 6 days late, now pays 8 days late — 2 days slower than before.
This week: one open invoice has passed even that usual delay, so it is late by their own standard, not just yours.
Outstanding $4.2k.
The slide costs roughly $23 of extra financing on the current balance.
Lumen Fitness Studios
broke its patternThis week: one open invoice has passed even that usual delay, so it is late by their own standard, not just yours.
Outstanding $14.0k.
Based on 1 settled invoices — a thin history, so treat the trend as indicative.
Tidewater Legal LLP
broke its patternimprovingTrend: used to pay 67 days late, now pays 14 days late — 53 days faster than before.
This week: one open invoice has passed even that usual delay, so it is late by their own standard, not just yours.
Outstanding $76.0k.
Based on 5 settled invoices — a thin history, so treat the trend as indicative.
Harbor Point Dental Group
slowingTrend: used to pay 3 days late, now pays 8 days late — 5 days slower than before.
Outstanding $8.9k.
The slide costs roughly $122 of extra financing on the current balance.
Copperleaf Home Goods
improvingTrend: used to pay 16 days late, now pays 11 days late — 5 days faster than before.
Outstanding $80.8k.
Trend compares two medians the customer has already demonstrated — the later half of their settled invoices against the earlier half. This week is about one specific invoice. A customer can be improving overall and still be late on something right now, which is why both are shown rather than combined into a single verdict. Nothing here is predicted.
Where to start
What each call is worth
Your lowest week is week 3 at $105.4k. Each figure below is how much that improves if the customer pays on their due date instead of when they usually do.
1Northgate Auto Group
+$85.7k
Moves $85.9k from week 4 into week 1. They usually pay 31 days after the due date. After this call your lowest week is week 13 at $191.1k, so the gain is measured to there, not to the full amount moved.
2Summit Ridge Credit Union
+$27.5k
Moves $27.5k from week 4 into week 3. They usually pay 2 days after the due date.
3Bluewater Logistics Co.
+$16.9k
Moves $16.9k from week 4 into week 3. They usually pay 6 days after the due date.
4Granite Peak Insurance Agency
+$11.2k
Moves $22.5k from week 3 into week 1. They usually pay 25 days after the due date.
5Sable Creek Outdoor
+$11.2k
Moves $11.2k from week 4 into week 2. They usually pay 12 days after the due date.
6Harbor Point Dental Group
+$8.9k
Moves $8.9k from week 5 into week 3. They usually pay 8 days after the due date.
The ceiling: if every customer paid exactly on terms, $520.2k would move forward and your lowest week would be $191.1k (week 13) — an improvement of $85.7k. That is the most collections can achieve this quarter. Northgate Auto Group alone gets you there: once that call clears week 3, week 13 is the lowest, and chasing anyone else does not move it.
These are counterfactuals, not forecasts: the arithmetic of what happens if a customer pays on their due date. It is not a prediction that they will. Payments out are held constant, so every figure reflects collections alone.
Not available
What this run could not tell you, and why
- Days inventory / work in progress
This needs opening and closing stock, plus cost of sales.
To get it: Add a financial summary with inventory figures. If you hold no stock, say so and we will report the cash cycle without it.
- Change since last run
This is your first analysis, so there is nothing to compare against.
To get it: Your next upload will show what moved, week by week.
- Forecast Accuracy
no earlier forecast has a week that has both closed and is covered by this statement; accuracy needs a forecast made before a period this statement now covers
These are absences, not zeroes. CashLens never substitutes a plausible figure for one it cannot derive from your files — a number you cannot trace back to a document you supplied is worth less than an honest gap.
What this costs you
Nothing, and no account is needed to read this page. Your own first analysis is also free, with none of this withheld — three files, about a minute. Create an account or see how it works first.