The same vendor got entered three times across the year — one row has the EIN, another the address, another the phone — and now it's January and you can't file because the numbers are scattered. DataTools consolidates each vendor to one row and backfills the gaps from the duplicates: in our sample, 24 messy records become 8 complete vendors with 7 missing EINs recovered from duplicate rows. Your data never leaves your computer.
Different staff entered "Acme LLC", "Acme, L.L.C.", and "ACME Llc" across the year. Each is a separate row in the vendor master, and each only holds part of the story — so your 1099 totals split across three near-duplicate spellings.
What it costs: hours of manual matching, plus the risk of filing the wrong total.
One record captured the EIN at onboarding; the row you actually paid against doesn't have it. At 1099 time the field is blank even though you collected it months ago — it's just sitting on a duplicate.
What it costs: chasing W-9s you already have on file.
Remittance phone as (212) 555-0147 on one row and 212.555.0147 on another. Amounts with stray $ and commas. The export won't reconcile and the 1099-NEC box totals don't tie out.
What it costs: a half-day reconciling before you can even start filing.
Some EINs are recoverable from a duplicate row. Some you never collected. Until the list is consolidated you can't tell the two apart — so you either over-chase vendors or under-file.
What it costs: late filings and TIN-mismatch penalties.
The vendor master in QuickBooks, the payments spreadsheet, and the W-9 tracker each use different column names for "vendor name" / "Tax ID" / "amount paid." Merging them is an afternoon of manual rename before any analysis begins.
What it costs: 4–8 hours per filing season manually merging exports.
Your vendor master holds EINs, remittance addresses, and payment history — exactly the data you should not be uploading to a SaaS to clean. DataTools is desktop-only — your vendor list never leaves your computer.
What it costs: nothing — and that's the point.
The demo below loads a sample 24-row vendor file with the pollution
we've seen in real AP systems: the same vendor entered two or three
times under slightly different spellings, EINs that live on one
duplicate row but not the one you paid against, phones and amounts
formatted five ways, and the usual mess of
N/A / (blank) / ? sentinels.
Click Run pipeline and watch the 24 records collapse
to 8 complete vendors with 7 EINs recovered in under
a second.
Catches the same vendor that shows up as Acme LLC, Acme, L.L.C., and ACME Llc. Fuzzy match merges the spellings; the dedup merge collapses them to one row and backfills the gaps from each duplicate.
Pulls the EIN off whichever duplicate row captured it and fills it into the survivor. The EINs that are genuinely missing get flagged so you know exactly which W-9s to chase.
Before filing: standardize amounts, drop sentinels-as-missing, and merge so each vendor's total paid lands on one row and ties to your AP ledger.
Whitespace in Tax IDs, near-identical vendor names, copy-paste smart quotes in remittance addresses — gone. Audit log shows every change for your reviewer.
The vendor master, the payments spreadsheet, and the W-9 tracker each name "Tax ID" differently. Map Columns aligns them; the dedup merge consolidates across all three sources.
Save the cleanup as a JSON file. Drop next year's vendor export on it. Same consolidation, zero re-configuration. Automatable via the CLI.
DataTools is a desktop app. There's no upload step, no SaaS account, no subscription, no "trust our security policy." The first thing you can do after install is open your browser's network tab, run the cleaner on your real vendor file, and verify zero outbound requests.
Every modification is recorded with the original value, the new value, and which rule fired. Hand the audit CSV to your controller, your reviewer, or the IRS-ready workpaper file along with the cleaned vendor list. No "I trust the AI" hand-waving — they see exactly which EIN came from which duplicate row.
One row has the EIN as 12-3456789, another as
123456789. The remittance phone is (212)
555-0147 on one and 212.555.0147 on the next.
An amount reads $12,410.75 with a stray space. Excel
treats half of these as text errors. DataTools normalizes every one —
EINs to a single format, phones to E.164, amounts to clean numerics —
so the file reconciles and the 1099 box totals tie out.
NN-NNNNNNN shape, with genuinely-missing ones flagged.$ / commas / stray spaces — including amounts Excel mis-types as text.Fuzzy match (Jaro-Winkler), 5 normalizers, survivor rules, gap-backfill merge, interactive review.
Whitespace, smart chars, NBSP, BOM, line endings, case ops.
EINs, amounts, dates, phones, emails, addresses, names, booleans.
Disguised-null detection, profile, flag genuinely-missing fields, drop strategies.
Fuzzy auto-rename, target schema, type coercion, required-field defaults.
Chain tools in recommended order, save/load JSON, automate next year's vendor cleanup.
Available when 3+ bundles ship. Includes everything in the 1099-prep pack plus the Bookkeeper and Accounts-Receivable bundles. Save $48.
Coming when readyYes — the input is just CSV / Excel from any source. Your QuickBooks vendor export works the same as a Xero export, a Bill.com download, or a vendor spreadsheet you maintain by hand. The cleaner doesn't care where the file came from.
Excel does exact deduplication and only deletes — it never backfills. Acme LLC and Acme, L.L.C. are different vendors to Excel, and even when it does catch a duplicate it throws the extra row away, taking the EIN with it. DataTools fuzzy-matches across spelling drift, merges the group to one survivor, and pulls the missing EIN, phone, and address off the rows it merges in.
When it merges a group of duplicate vendor rows, it keeps the survivor and backfills any empty field — including the EIN — from whichever duplicate row had it. In the sample file, 7 of the 8 vendors had their EIN recovered this way; the 1 that's truly missing gets flagged so you know to chase the W-9.
No. The GUI is a browser interface that opens automatically when you double-click the app. It loads your vendor file, you click Run, you download the cleaned list. The CLI is there for power users who want to script next year's cleanup.
Your vendor master — EINs, remittance addresses, payment history — never leaves your computer. There is no cloud component, no telemetry, no "anonymous usage stats." When the app is running you can confirm zero outbound network requests in your browser's developer tools.
Try the live demo above on the sample vendor dataset before you buy. If you still find DataTools doesn't fit your workflow within 14 days, email for a refund — no questions asked.
Yes. The v1.x line is included free for everyone who buys DataTools today. We ship a patch every 30 days adding format support, edge-case fixes, and small features.
One $49 download. Mac, Windows, or Linux. Runs offline. Consolidates 24 messy records into 8 complete vendors, recovers the 7 EINs hiding on duplicate rows, flags the ones genuinely missing, and saves a pipeline you can re-run on next year's vendor export.
Get DataTools for Accounting — $49 →