Two files in
client_report.csv
Northlight Digital · monthly client report · June 2026
billing_export.csv
Billing / CRM export · the source of record
What Trovano found
6
flagged, do not reconcile
$311,761.41
dollars that don't reconcile
Flagged. Click any row for the two sources.
ClientLine
TypeReportBillingSeverity
Rivera Dental
Google Ads
Rounding / typo
$9,115.17
$8,927.69
LOW
Report 9115.17 vs billing 8927.69 (Δ +187.48, 2.1%).
In the report
line L001
$9,115.17
Rivera Dental · Google Ads
vs
In your billing/CRM export
record R001
$8,927.69
Rivera Dental · Google Ads
Trovano flags the mismatch and shows both sources. You decide which is right.
Summit Gear Co
Meta Ads
Amount mismatch
$7,943.63
$5,928.08
HIGH
Report 7943.63 vs billing 5928.08 (Δ +2015.55, 34.0%). fuzzy client match · 85% confidence
In the report
line L008
$7,943.63
Summit Gear Co · Meta Ads
vs
In your billing/CRM export
record R008
$5,928.08
Summit Gear Co · Meta Ads
Trovano flags the mismatch and shows both sources. You decide which is right.
Bloom & Vine
LinkedIn Ads
Amount mismatch
$4,067.95
$6,982.87
HIGH
Report 4067.95 vs billing 6982.87 (Δ -2914.92, 41.7%).
In the report
line L015
$4,067.95
Bloom & Vine · LinkedIn Ads
vs
In your billing/CRM export
record R015
$6,982.87
Bloom & Vine · LinkedIn Ads
Trovano flags the mismatch and shows both sources. You decide which is right.
Bloom & Vine
Management Fee
Currency / unit scale
$307,859.00
$3,078.59
HIGH
Report 307859.0 vs billing 3078.59 (Δ +304780.41, 9900.0%).
In the report
line L016
$307,859.00
Bloom & Vine · Management Fee
vs
In your billing/CRM export
record R016
$3,078.59
Bloom & Vine · Management Fee
Trovano flags the mismatch and shows both sources. You decide which is right.
Harbor Point Realty
Meta Ads
Rounding / typo
$4,992.61
$5,125.88
LOW
Report 4992.61 vs billing 5125.88 (Δ -133.27, 2.6%).
In the report
line L026
$4,992.61
Harbor Point Realty · Meta Ads
vs
In your billing/CRM export
record R026
$5,125.88
Harbor Point Realty · Meta Ads
Trovano flags the mismatch and shows both sources. You decide which is right.
Rivera Dental
SEO Retainer
Missing line item
·
$1,729.78
HIGH
Billing has Rivera Dental SEO Retainer ($1,729.78); the report omits it.
In the report
line ·
·
Rivera Dental · SEO Retainer
vs
In your billing/CRM export
record R005
$1,729.78
Rivera Dental · SEO Retainer
Trovano flags the mismatch and shows both sources. You decide which is right.
The deliverable: an approval-ready corrected report
| Client | Line | Reconciled amount |
|---|
| Rivera Dental | Google Ads |
$8,927.69 was $9,115.17 |
| Rivera Dental | Meta Ads |
$9,127.04 |
| Rivera Dental | LinkedIn Ads |
$5,901.08 |
| Rivera Dental | Management Fee |
$3,160.90 |
| Rivera Dental | Email Marketing |
$1,296.11 |
| Summit Gear Co | Google Ads |
$3,450.80 |
| Summit Gear Co | Meta Ads |
$5,928.08 was $7,943.63 |
| Summit Gear Co | LinkedIn Ads |
$4,067.95 |
| Summit Gear Co | Management Fee |
$2,032.56 |
| Summit Gear Co | SEO Retainer |
$2,073.64 |
| Summit Gear Co | Email Marketing |
$1,420.31 |
| Bloom & Vine | Google Ads |
$4,290.23 |
| Bloom & Vine | Meta Ads |
$8,659.23 |
| Bloom & Vine | LinkedIn Ads |
$6,982.87 was $4,067.95 |
| Bloom & Vine | Management Fee |
$3,078.59 was $307,859.00 |
| Bloom & Vine | SEO Retainer |
$2,619.46 |
| Bloom & Vine | Email Marketing |
$910.35 |
| Kestrel Law | Google Ads |
$3,863.82 |
| Kestrel Law | Meta Ads |
$2,935.31 |
| Kestrel Law | LinkedIn Ads |
$6,495.98 |
| Kestrel Law | Management Fee |
$1,737.62 |
| Kestrel Law | SEO Retainer |
$2,551.63 |
| Kestrel Law | Email Marketing |
$452.51 |
| Harbor Point Realty | Google Ads |
$3,776.90 |
| Harbor Point Realty | Meta Ads |
$5,125.88 was $4,992.61 |
| Harbor Point Realty | LinkedIn Ads |
$9,109.84 |
| Harbor Point Realty | Management Fee |
$1,631.45 |
| Harbor Point Realty | SEO Retainer |
$2,285.45 |
| Harbor Point Realty | Email Marketing |
$489.98 |
| Vantage Fitness | Google Ads |
$5,531.86 |
| Vantage Fitness | Meta Ads |
$7,388.44 |
| Vantage Fitness | LinkedIn Ads |
$8,022.07 |
| Vantage Fitness | Management Fee |
$1,769.71 |
| Vantage Fitness | SEO Retainer |
$1,122.37 |
| Vantage Fitness | Email Marketing |
$672.11 |
| Cedar & Co Interiors | Google Ads |
$4,947.60 |
| Cedar & Co Interiors | Meta Ads |
$6,326.08 |
| Cedar & Co Interiors | LinkedIn Ads |
$2,580.16 |
| Cedar & Co Interiors | Management Fee |
$2,801.93 |
| Cedar & Co Interiors | SEO Retainer |
$915.89 |
| Cedar & Co Interiors | Email Marketing |
$730.25 |
| Northside Pediatrics | Google Ads |
$4,993.41 |
| Northside Pediatrics | Meta Ads |
$4,529.37 |
| Northside Pediatrics | LinkedIn Ads |
$5,933.22 |
| Northside Pediatrics | Management Fee |
$1,723.32 |
| Northside Pediatrics | SEO Retainer |
$932.03 |
| Northside Pediatrics | Email Marketing |
$1,099.14 |
| Rivera Dental | SEO Retainer |
$1,729.78 was (omitted) |
Accuracy on this run. Computed, not claimed.
6 of 6
injected errors caught
0
false flags across 48 lines
Counts, not percentages. At this sample size a percentage would overstate what one run can show.
| Error category | Result |
|---|
| Rounding / typo |
✓ caught |
| Wrong period |
✓ caught |
| Wrong client |
✓ caught |
| Missing line item |
✓ caught |
| Currency / unit scale |
✓ caught |
Where the check sits, and where it goes
READ
Parses your files, shows every number with its source. Touches nothing.
CHECK you are here
Flags what doesn't reconcile. This is what ships today.
DRAFT
Proposes the corrected number for your approval. Gated behind its own bar.
RUN
Applies low-risk fixes, routes the rest to a human. Not shipped, not claimed.
The check is the first workflow, not the ceiling.
Every decision on a flag, accept, reject, or correct, becomes a labeled example of how your deliverables map to your records. That corpus tunes the matching for your firm, and it's the training data for the next rung: checking becomes drafting; drafting, only past its measured bar, becomes doing.
Followed far enough, that's the layer Trovano is built for: an AI that learns how your whole company works and assembles its own skills around it, every output traceable to your own records. That layer is the trajectory; the check is what ships, and how it starts.
Demo on synthetic data. The generator and the pipeline share assumptions, so this
proves the flagging logic, not that real-world messiness is solved. Real
precision/recall comes from a pilot's back-test on a firm's own shipped reports.
Trovano flags mismatches and shows sources; it never decides which number is right.