DATARITE CashLenssample company
Login

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

DownloadDashboard (HTML)Workbook (Excel)CFO brief

Working capital

Diagnostic for 2026-10-12

Days sales outstanding

65.4days

you collect in

Days payable outstanding

25.4days

you pay in

Days inventory / WIP

NOT AVAILABLE

held as work in progress

Cash conversion cycle

40days

Anchor

Cash today

$150.2k

below your $150.0k floor in week 3

closing bank balance

Total receivables

$726.8k

41.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

minimum $ 150kW1 (2026-10-12): $ 214,106.9 — high confidenceW2 (2026-10-19): $ 267,590.78 — high confidenceW3 (2026-10-26): $ 105,410.49 — high confidenceW4 (2026-11-02): $ 161,041.29 — high confidenceW5 (2026-11-09): $ 177,071.29 — medium confidenceW6 (2026-11-16): $ 181,529.88 — medium confidenceW7 (2026-11-23): $ 254,239.88 — medium confidenceW8 (2026-11-30): $ 244,420.39 — medium confidenceW9 (2026-12-07): $ 235,080.39 — low confidenceW10 (2026-12-14): $ 303,395.1 — low confidenceW11 (2026-12-21): $ 298,318.98 — low confidenceW12 (2026-12-28): $ 197,369.49 — low confidenceW13 (2027-01-04): $ 191,129.49 — low confidenceW1W3W5W7W9W11W13
weeks 1–8, known invoicesweeks 9–13, behavioural projectionfirst breach: week 3
WeekStartingOpeningReceiptsPaymentsClosingConfidence
W12026-10-12$150.2k$134.4k$70.4k$214.1khigh
W22026-10-19$214.1k$77.3k$23.8k$267.6khigh
W32026-10-26$267.6k$30.6k$192.8k$105.4khigh
W42026-11-02$105.4k$98.7k$43.1k$161.0khigh
W52026-11-09$161.0k$16.0k$0$177.1kmedium
W62026-11-16$177.1k$73.6k$69.1k$181.5kmedium
W72026-11-23$181.5k$72.7k$0$254.2kmedium
W82026-11-30$254.2k$91.1k$100.9k$244.4kmedium
W92026-12-07$244.4k$0$9.3k$235.1klow
W102026-12-14$235.1k$132.4k$64.0k$303.4klow
W112026-12-21$303.4k$0$5.1k$298.3klow
W122026-12-28$298.3k$0$100.9k$197.4klow
W132027-01-04$197.4k$0$6.2k$191.1klow

Forecast accuracy

How close the earlier forecasts landed

NOT AVAILABLE

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

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

ScoreCustomerExposure% of AROldestExp. daysRecommended action
82.6Northgate Auto Group$147.9k20.4%61-9061Call the account owner today and agree a dated payment commitment for the overdue balance.
60.5Ridgeway Health Partners$275.9k38.0%Current94Nothing overdue. Worth watching: this account is a large share of the book, so a slip would be felt quickly.
34.8Fieldstone Brewing Co.$33.7k4.6%90+50Call the account owner today: this balance is more than 90 days overdue. Agree a dated payment commitment.
34.0Tidewater Legal LLP$76.0k10.5%1-3044Standard dunning cycle; monitor at the next run.
19.2Orchard Lane Bakery$4.2k0.6%90+38Call the account owner today: this balance is more than 90 days overdue. Agree a dated payment commitment.
19.1Copperleaf Home Goods$80.8k11.1%Current56No action; nothing is overdue.
18.6Lumen Fitness Studios$14.0k1.9%1-3038No action beyond the normal statement cycle.
7.1Harbor Point Dental Group$8.9k1.2%Current38No action; nothing is overdue.
6.5Summit Ridge Credit Union$27.5k3.8%Current32No action; nothing is overdue.
5.7Granite Peak Insurance Agency$22.5k3.1%1-3055No action beyond the normal statement cycle.
5.7Maple & Main Realty$7.3k1.0%Current20No action; nothing is overdue.
4.0Bluewater Logistics Co.$16.9k2.3%Current36No action; nothing is overdue.

Top exposures

Who owe you the most, and how old it is

#CustomerBalance% of totalAgeingOldestItems
1Ridgeway Health Partners incl. credit note$275.9k38.0%
Current5
2Northgate Auto Group$147.9k20.3%
61-904
3Copperleaf Home Goods$80.8k11.1%
Current2
4Tidewater Legal LLP$76.0k10.5%
1-302
5Fieldstone Brewing Co.$33.7k4.6%
90+4
6Summit Ridge Credit Union$27.5k3.8%
Current1
7Granite Peak Insurance Agency$22.5k3.1%
1-302
8Bluewater Logistics Co.$16.9k2.3%
Current1
9Lumen Fitness Studios$14.0k1.9%
1-302
10Sable Creek Outdoor$11.2k1.5%
Current1

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 bandExposureLoss rateRate fromAllowance
Current$538.0k0.82%your historylow$4.4k
1-30$88.9k0.85%your historylow$759
31-60$41.3k6.76%your historylow$2.8k
61-90$20.7k36.19%your historylow$7.5k
90+$37.9k36.19%your historylow$13.7k
Total$726.8k4.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.

BandInvoices enteredValue enteredReached defaultP(default)Loss rateConfidence
Current178$4.0m$89.8k2.27%0.82%low
1-30172$3.8m$89.8k2.36%0.85%low
31-6019$480.6k$89.8k18.68%6.76%low
61-909$89.8k$89.8k100.00%36.19%low
90+9$89.8k$89.8k100.00%36.19%low
Largest allowances by customer
CustomerBalanceAllowanceCoverage
Fieldstone Brewing Co.$33.7k$12.2k36.2%
Northgate Auto Group$147.9k$11.0k7.4%
Ridgeway Health Partners$275.9k$2.3k0.8%
Orchard Lane Bakery$4.2k$1.5k36.2%
Copperleaf Home Goods$80.8k$6620.8%
Tidewater Legal LLP$76.0k$6310.8%
Summit Ridge Credit Union$27.5k$2250.8%
Granite Peak Insurance Agency$22.5k$1880.8%
Bluewater Logistics Co.$16.9k$1380.8%
Lumen Fitness Studios$14.0k$1170.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
MetricValueFormula and inputs
DSO65.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
DPO25.4 days(average AP / COGS) * days — average_AP 112,930.0, COGS 2,472,367.64, days 557
DIONOT AVAILABLEthis business reported no inventory in either period, so days inventory outstanding does not apply - it is not zero days
CCC40.0 daysDSO - 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 patternslowing

    Trend: 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 pattern

    Trend: 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 pattern

    Trend: 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 pattern

    This 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 patternimproving

    Trend: 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

    slowing

    Trend: 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

    improving

    Trend: 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.

$17k$162k$307k$105kLow pointnow+$86kNorthgate…+$27kSummit Rid…+$17kBluewater…+$11kGranite Pe…+$11kSable Cree…+$9kHarbor Poi…$76kOverlapbetween calls$191kIf all payon terms
Each bar is how much that one call lifts the worst week. They do not add up — every call moves cash into the same week, so the amber bar removes the double-count. The last bar is the ceiling: the most collections alone can achieve. The vertical axis does not start at zero, so the steps stay readable.
  1. 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.

  2. 2Summit Ridge Credit Union

    +$27.5k

    Moves $27.5k from week 4 into week 3. They usually pay 2 days after the due date.

  3. 3Bluewater Logistics Co.

    +$16.9k

    Moves $16.9k from week 4 into week 3. They usually pay 6 days after the due date.

  4. 4Granite Peak Insurance Agency

    +$11.2k

    Moves $22.5k from week 3 into week 1. They usually pay 25 days after the due date.

  5. 5Sable Creek Outdoor

    +$11.2k

    Moves $11.2k from week 4 into week 2. They usually pay 12 days after the due date.

  6. 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.