Contractor and 1099 Payment Tracker

Paying subcontractors and dreading 1099 season? This tracker keeps you

organized all year, so January is a review instead of a reconstruction.

Built by a Certified QuickBooks Online ProAdvisor who files 1099s for

contractors every year — every column reflects what you actually need at tax

time.

What's inside:

- Subcontractor Log — name, trade, and last four of each sub's EIN or SSN

- Month-by-month payment entry with year-to-date totals calculating

 automatically

- Automatic 1099 flag — anyone paid at or above the threshold gets flagged

 for you

- W-9 status column — see at a glance which subs still owe you paperwork

 before filing season

- 1099 Summary tab that pulls straight from your log — nothing re-entered

How it works: Blue cells are yours to fill in. Everything else calculates

automatically. The threshold is pre-set to the 2026 IRS limit of $2,000 and

is editable if it changes.

Who it's for: contractors and small business owners who pay subs through the

year and don't want to rebuild twelve months of payments in three weeks.

Works in Excel, and in Google Sheets via File → Import (conditional

formatting sometimes needs a quick look after importing). No macros. Instant

download.

Bookkeeping by Nalini LLC — contractor and small business bookkeeping in

Reno/Sparks, NV. Need full-service bookkeeping? Visit bookkeepingbynalini.com

for a free consultation.

Please note: This is a bookkeeping tool for informational and organizational

purposes only. It is not tax, legal, or accounting advice, and no professional

relationship is created by purchase. IRS filing thresholds and requirements

change — verify the current threshold with your own CPA or tax professional

before filing. Digital download; all sales final.