GOLDEN POD
Methodology

How the analysis works.

Every check, the exact score formula, and what we deliberately don't do. This page exists so you can audit the auditor.

01 — The principle

Same file in, same findings out.

No LLM, no sampling, no black box. Every number is read off your rows — summed and counted, never estimated. Run the same file twice and the findings are identical, line for line.

STAGE 1
Ingestion
CSV, Excel, JSON, ODS, folders, nested archives.
STAGE 2
Normalization
Dates, currencies, and encodings unified.
STAGE 3
Checks
Duplicates, aliases, gaps, structure.
STAGE 4
Report
Every number traceable to your rows.
02 — The checks

What we look for, and why each match is a match.

Duplicate payments
Same vendor, same amount, within a 7-day window. Months apart is a retainer; five days apart is worth a call before the next run. The 7-day constant is published, not tuned per file.
Silverline Telecom · $4,425 · two invoices, 5 days apart → $4,425 at risk
Vendor aliases
Spellings that collapse to one key after case, whitespace, and Cyrillic/Latin look-alikes are folded. We flag the group — we never merge it. Mixed-script variants are called out explicitly; that pattern shows up in fraud.
'Apex Logistics, LLC' (19×) vs 'Apex Logistics LLC' (18×) → $30,706 combined
Sequence gaps
Missing numbers in an invoice, check, or PO column (INV-2026-1440 → 1440). Runs only when 95%+ of values parse as numbers. A gap is surfaced as worth checking — never a confirmed loss, never a fabricated figure.
gap after INV-2026-1338 → before INV-2026-1341 · 2 missing
Missing values & structure
Missing cells per column, empty columns, and duplicate rows — both byte-identical and near-duplicates that only match after case/whitespace folding (the copy-paste artifacts plain equality misses). These feed the score below.
direct inputs to the Structural Integrity Score
We flag, we never merge — that call belongs to a human.
03 — The score

The Structural Integrity Score, in full.

Every report carries a score out of 100 — and these exact weights, so the document you hand your team carries its own audit trail.

score = 100 − 50 × missing_cells / total_cells
           − 40 × empty_columns / total_columns
           − 30 × duplicate_rows / total_rows
           − 25 per unparseable numeric column
           · floored at 0 · averaged across tables
−50
Missing cells / total
Weighted heaviest — absent data quietly degrades every downstream check.
−40
Empty columns / total
Structure that promises data and delivers none.
−30
Duplicate rows / total
The lightest — duplicates are real, but cheapest to fix.
−25
Per unparseable column
Deducted after the base score, once per column.
Floored at 0, then a plain average across tables — no hidden reweighting.
04 — The boundaries

What it deliberately does not do.

∅
Never guesses silently
Unsure about a column? Dollar findings just don't appear for it. It can't invent a number.
≠
Never merges your vendors
Aliases are flagged with counts and volumes; the "one entity?" call stays with you.
∑
Never estimates
Every figure is a sum of values in your rows. No projection, no sampling.
…
Never skips quietly
If a scan is skipped for scale, the report says so — with the reason.
‖‖
Never accuses
A duplicate suspect is "review with AP before the next run" — not a fraud verdict. The evidence is laid out; the judgment is yours.
05 — The deliverable

Anatomy of the report.

One analysis, two formats — a shareable browser page and a PDF. Both carry the same seven sections.

01
Executive Overview
Headline figure and a one-paragraph verdict, for the signer.
02
Structural Integrity Score
The score with the formula printed alongside it.
03
Critical Findings
Every suspect with amount, row ids, and dates.
04
Business Risks
What the findings mean if left alone.
05
Opportunities
Concentration and consolidation signals.
06
Recommended Actions
A numbered list, ordered by dollar impact.
07
Technical Appendix
Per-table stats so anyone can verify the summary against raw counts.

Run your file.

The method is published. The price is fixed. The findings are in dollars.

Get your report