Building a Payee Dedup Worksheet for PT Networks

Build one row per PRN therapist, with columns for their legal name, TIN, and then one column per clinic in your network showing what that clinic paid them this year. This isn't a fancy system, it's a spreadsheet, but it's the single artifact that turns scattered per-clinic vendor records into one visible total per person. Populate it from each clinic's payment records at least quarterly, since PRN scheduling changes constantly and a therapist who wasn't picking up shifts in Q1 might be working three clinics by Q3. Keep the worksheet in a shared location every clinic's biller can see, rather than a single person's local file, so the update doesn't bottleneck on one person's schedule during a busy quarter.

Build the worksheet in this order:

1. List every PRN therapist once, with legal name and TIN, so each person has a single row no matter which clinic books them.
2. Add one column per clinic and record what each clinic paid that therapist this year, using the same time period in every column.
3. Sum the whole row before reviewing any single clinic column, since the combined total is what decides whether a 1099 is due.
4. Match records by TIN first and name second, and standardize each name to the version on the therapist's W-9.
5. Keep the rows of therapists who left partway through the year, so their combined total through the last shift stays accurate.

The mistake that causes missed 1099s in a PT network isn't bad math, it's looking at each clinic's column in isolation instead of summing the row. Say a therapist works $250 shifts at two different clinics, six shifts each, over the year: $1,500 per clinic, neither one alone looks unusual, but the combined $3,000 is what determines their reporting status and it was never in question to begin with. Sum every row before filing season starts, not during it.

Rather than waiting for a periodic reconciliation to catch a multi-clinic therapist, build a simple flag into your scheduling or payroll process: the first time a PRN therapist is booked at a clinic that isn't their usual one, someone checks the worksheet to see if they already have a row. This catches the deduplication problem at the source, when it's a single lookup, instead of after months of payments have piled up under two separate identities. This is a scheduling-software habit as much as an accounting one: whoever approves a PRN shift request is well positioned to also check whether that name is new to the network or already has a row on file.

A therapist who signs one clinic's paperwork as 'Jane Smith' and another's as 'Jane R. Smith, DPT' can slip past a name-based match even though the TIN is identical. Match by TIN first, name second, and standardize the legal name on the worksheet to whatever appears on their W-9, since that's the name that has to match what you file. A mismatch here is one of the more common reasons a filed 1099 gets rejected during TIN verification.

National wage data puts the median pay for the accountants and auditors who'd otherwise be untangling this by hand at $83,680 a year¹. A working dedup worksheet, maintained quarterly, turns what would be a scramble through every clinic's books in January into a five-minute sum-and-check exercise, which is a meaningful chunk of that person's time back.

Once your worksheet reflects accurate combined totals by TIN, both Tax1099 and Track1099 can take that consolidated list as their input rather than a per-clinic export. The choice between the two platforms at that point comes down to how many corrections you typically need mid-season and whether your practice management or payroll system has a more direct integration with one over the other, not to which one handles deduplication better, because neither one does that work for you.

A PRN therapist who stopped picking up shifts in July still needs an accurate combined total for whatever they were paid through their last shift, even though they're no longer active. Don't drop their row from the worksheet just because they're inactive, since the payments they received earlier in the year still count toward the reporting threshold and still need a form in January. Keep an inactive flag on the row instead of deleting it, so filing season doesn't require reconstructing a former therapist's history from scratch.