Which vendors got coded two different ways

Drop a coded transaction export. This groups every vendor by the accounts their transactions were posted to, and puts the odd one out first — because a vendor coded the same way forty times and differently once is almost never a deliberate choice.

Doing this manually every month? I build done-for-you invoice intake automation for accounting teams — $2,500 to implement, then $500–900/month; email dan@danieljamesfrancis.com.

No server, no account, no network calls once this page has loaded.

Two different findings, and only one of them is a problem

A vendor appearing under several accounts is not automatically wrong. A hardware store legitimately sells you shop supplies one week and a tool the next. So the results are split in two, and the order matters more than the count:

The threshold is deliberately blunt: an account holding at most a quarter of a vendor's rows, where some other account holds most of them, is the odd one out. Anything less clear-cut is called a split rather than guessed at.

Why it also totals the money

Each account line carries its share of the vendor's spend, because the count and the amount tell different stories. One miscoded transaction out of forty barely matters if it is $18 and matters a great deal if it is $18,000 — and the count alone cannot tell you which you are looking at.

What it does not do

It reads and reports; nothing is written. It cannot know which account is the correct one — only that the same vendor was treated two ways. Account names are compared as written, so 6120 and 6120 Office Supplies count as two different accounts, which is itself worth seeing if your chart is entered inconsistently.


Checking a vendor's GL coding after the fact means reading back through an export and correcting whatever was keyed to the wrong account, and I can automate the workflow that creates that work: supplier invoice PDFs come in, each one is coded from the vendor's own history and posted to QuickBooks or whatever ledger you use, and only the ones that do not match reach a person. Fixed fee of $2,500 to set it up; $500–900/month to run it after that, depending on volume. Email me at dan@danieljamesfrancis.com — tell me your monthly invoice count and the ledger you use, and I will tell you in writing whether it fits your setup, including when it does not. No call needed.

Need GL coding decisions running automatically against your chart of accounts?

I map your supplier invoices to your chart of accounts and push them directly into QuickBooks — $2,500 fixed-price setup, $500–900/month after that. No hourly billing, no scope creep. Email dan@danieljamesfrancis.com and I will send back a one-page scope within 24 hours.