The worst time to find a data error is after your report is in someone else's inbox. A five-minute validation pass catches most problems: missing rows, doubled totals, last month's dates, blanks in key fields. The trick is to run the same checks every time.
Plumb is built on a simple idea: the data your business runs on should be trustworthy before anyone draws conclusions from it. Cleaning, checking and reshaping data should not need macros, scripts or a weekend. Plumb keeps your files private, shows every change it proposes, and lets you approve fixes instead of hunting for problems by hand.
How Plumb helps: Data quality checks
Plumb's data quality checks turn that checklist into a saved, repeatable step. Define rules once (row count in range, no duplicate IDs, totals match source, dates in the current period) and Plumb runs them on every new file, with a clear pass or fail for each.
How It Works
Run these checks in order before you hit send.
- Row count: compare =COUNTA(A:A)-1 with the count in the source system.
- Totals: reconcile key sums (revenue, units) against an independent number.
- Duplicates: =COUNTIF(A:A, A2)>1 on the ID column should return no TRUE values.
- Blanks: =COUNTBLANK() on required columns should be zero.
- Date range: =MIN() and =MAX() on the date column should fall inside the reporting period.
- Spot-check five random rows against the source.
- In Plumb: save these as a check set, run it on each new file and share the pass/fail summary with the report.
Where This Helps
Weekly KPIs
Confirm numbers are complete and current before the Monday meeting.
Client reporting
Avoid sending a client a report with doubled or missing figures.
Board packs
Reconcile every total before it reaches leadership.
Try Plumb in early access
Plumb is in early access. Join the waitlist on tryplumb.pro to get an invite. Early access covers Excel (.xlsx), CSV and JSON files, and we are adding more sources as people ask for them. Your files are processed privately and are never used to train models.
Send reports you can stand behind
Now you have a repeatable way to do it, by hand or with Plumb. Join the waitlist and tell us what your data looks like; we read every reply.
Join the waitlist