It's January. You pull a QuickBooks vendor report for Ernie Macmillan, one of 5 contract clinicians at an 8-clinician group practice.
It says $9,200.
Then you spot a second vendor, Patronus Counseling LLC. That's Ernie's business. Another $3,600.
Then someone remembers the week in August when bill pay failed, and Ernie got paid from the second checking account.
| QuickBooks record | Paid from | Payments |
|---|---|---|
| Ernie Macmillan | Operating checking | $9,200 |
| Patronus Counseling LLC | Operating checking | $3,600 |
| Ernie Macmillan, LPC | Second business checking | $2,000 |
| Payments found | $14,800 |
And we're still not ready to file anything.
Your books answer one question well: how much did the practice spend on contractors? A 1099 asks a different one. How much did you pay Ernie in 2026, and how?
Clean books get the first answer right. The second one takes digging.
If you read Preparing 1099s for your group therapy practice, you met Hannah Abbott at this same practice, with $900 sitting outside the normal workflow. Last time it was Hannah's $900. This time it's bigger.
Can you prepare 1099s from a QuickBooks vendor report?
Only as a starting point.
A vendor report shows what's recorded under one vendor name. The 1099 needs to include every dollar you paid one person or business that year. When that person lives under 3 names in QuickBooks, the report for any one of them is wrong.
Here's what's at stake with Ernie. For 2026, the 1099-NEC threshold is $2,000, so he gets a form either way. The question is whether it says $9,200 or $14,800.
File $9,200 and you've under-reported him by $5,600. That means a corrected 1099, an awkward email to Ernie (whose tax pro may have already used the wrong number), and possibly a penalty for incorrect information. Why W-9s cause so many 1099 headaches has the 2026 penalty amounts.
One clinician, three vendor records, one Contract Labor account
Nobody created Ernie's 3 records on purpose.
He started at the practice under his own name. In 2025, he formed Patronus Counseling LLC and asked to be paid as the business, and someone added a new vendor instead of editing the old one. (What that change means for his W-9 is its own question. Why W-9s cause so many 1099 headaches covers it.)
Then the August payment got entered by hand. Whoever typed it created "Ernie Macmillan, LPC," because that's how his invoice was signed.
All 3 records are coded to Contract Labor. So your P&L is right. Your contractor expense total is right. Your bank accounts reconcile.
And every one of Ernie's vendor reports is wrong.
Duplicate vendors look cosmetic. At 1099 time, they split one person's year into pieces, and you have to stitch it back together before you can trust the number.
In a group practice with 5 contract clinicians, a supervisor, and a couple of consultants, 2 duplicates are enough to turn a quick review into a research project.
Why reconciled books can still miss a contractor payment
Reconciliation proves every transaction in the bank made it into the books. It says nothing about which vendor each one is attached to.
Ernie's $2,000 cleared the second checking account, got categorized to Contract Labor, and reconciled perfectly. It's in the books. It's just under a name nobody searched.
Here's where contractor payments usually hide in a group practice:
A second business checking or savings account
A manual payment when the usual payout method failed
A bank-feed transaction coded to Contract Labor with no vendor attached
A Zelle payment from before someone was set up in Gusto
A shareholder contribution entry, recorded when an owner paid someone from a personal account
The third one is the sneakiest. It won't appear on any vendor report. You only find it by pulling every Contract Labor transaction for the year and reading the memo lines.
And memory won't save you. A workaround in August feels unforgettable in August. By January, it's one transaction out of hundreds.
Even when someone remembers, the payment can still go missing.
Last year, one of our clients wrote a $400 check to an independent contractor from their personal bank account. They told us about it, and we recorded it in the books with a journal entry.
But the entry used a slightly different vendor name than the one already on file, so the $400 wouldn't have shown up in that contractor's QuickBooks vendor report.
We caught it during our month-end quality check. Part of our bookkeeping process is checking for duplicate vendors.
If you're not sure your books would hold up to that kind of tracing, here's how to tell if something's off in your practice finances.
Where this fits: the Verify and Resolve stages
In the pillar article, I broke 1099 prep into 5 stages: Identify → Collect → Verify → Resolve → File. Everything in this article happens in the middle two.
Verify is pulling Ernie's full year together across every record and every account. Resolve is figuring out why he has 3 records and what each payment was for.
And once you've found every dollar, the payment method still decides what's yours to report (card payments generally go on the processor's 1099-K, and the pillar covers that split).
This is why I call 1099 prep 90% verification and 10% filing. Ernie's $14,800 is the 90%.
What 1099-ready bookkeeping looks like in a group practice
It comes down to a few habits that make one payee's year quick to trace:
One vendor record per payee. When a clinician forms an LLC or changes how they bill, edit the existing record.
Every payment attached to a vendor. That includes bank-feed transactions from a second account.
A note on every exception. When you pay someone outside the usual process, add a memo saying why. You will need it in January.
A quarterly look at the vendor list. Near-duplicates are easy to spot in April and painful to untangle in January.
You'll still review everything before filing. It'll just go faster, because you'll be checking work instead of reconstructing it.
The form took minutes. Finding the $14,800 didn't.
Once Ernie's year was traced, his 1099 took about 5 minutes to file.
Getting from $9,200 to $14,800 took someone who knew the practice had a second checking account and knew Ernie had formed an LLC.
QuickBooks can file the form. Someone who knows the books has to find the money.
Make January 1099 Season Easier
We handle 1099s for our monthly bookkeeping clients because a calm January starts with organized books all year. That’s how the $14,800 gets caught in November instead of April.
