Rental Property Bookkeeping Spreadsheet 2026
Rent, expenses and mileage for up to 10 properties, with Schedule E-style totals for every one.
Sample data shown · click to enlarge
1099 Summary: who likely needs a form, the amounts and missing W-9s.
For landlords who pay contractors
See who likely needs a 1099-NEC before January.
Log each payment to a contractor as you make it. The tracker totals the year, applies the 2026 reporting threshold and lists who likely needs a Form 1099-NEC, with their W-9 status.
$15one-time · 2026 edition · instant download
1099-NEC forms are due in 84 days: know exactly who needs a form before the rush.
Buy now: instant access
Excel + Google SheetsNo subscriptionSecure checkout
Best value: get this plus 4 more templates in the Landlord Toolkit for $59 (save $42) →
- Up to 50 contractors and 1,000 payments
- 2026 reporting threshold of $2,000 built in (editable)
- Card and app payments set aside, since those are generally reported on 1099-K
- A ready list of names, addresses and amounts, plus the filing deadline
What's inside
A tour, tab by tab
Screenshots show the included sample data. Click any screenshot to enlarge it.
Tab · Contractors
Contractors
Nickname, legal name, service, entity type, W-9 received and mailing address. Paid this year, the amount that counts toward a 1099-NEC and a status are calculated.
Tab · Payments Log
Payments Log
Date, contractor, property, description, amount, payment method and check number. Each row shows whether it counts toward a 1099-NEC.
Tab · 1099 Summary
1099 Summary
Totals, an ordered list of contractors who likely need a form (with legal name, address, amount and W-9 status), the filing deadline and data checks.
Start Here
Settings for tax year, payer name and the 1099-NEC threshold ($2,000 for payments made in 2026, raised from $600 by the 2025 tax law; confirm at irs.gov).
In your download
Everything arrives in under a minute
Contractor Payments & 1099 Tracker 2026 (Excel, with sample data)
A blank Excel copy, ready for your records
A one-click Google Sheets copy link
A Start Here tab with setup steps
Is it right for you?
Who it's for
A great fit for
- Landlords who pay plumbers, cleaners, handymen or attorneys
- Anyone who wants W-9s and contractor totals sorted before January
Not built for
- Filing 1099 forms (use the IRS or your tax preparer's system)
- Payroll for employees
Why it's the smart buy
More built in than a free template. A fraction of a subscription.
Everything a small landlord needs for the 2026 tax year, without another monthly bill or a bank login.
| Our templatesRent & Tally | Subscription landlord apps | Free templates online | Shoebox + bank statements | |
|---|---|---|---|---|
| One-time price, no monthly fee | Yes | Monthly or yearly fee | Free | Free |
| Ready for tax year 2026 (mileage rates, $2,000 1099-NEC threshold) | Built in | Varies | Rarely updated | No |
| Schedule E-style expense categories | 13 categories | Varies | Sometimes | No |
| Contractor totals and likely 1099-NECs | Yes | Varies | Rarely | No |
| Works in Excel and Google Sheets | Both | App only | Usually one | No |
| No bank login needed | Never asked | Often asks to link | Yes | Yes |
| Built-in checks catch missing data | Yes | Varies | Rarely | No |
| You keep your file forever | Yes | Tied to your plan | Yes | Paper only |
| Sample data and a setup guide | Yes | Usually | Sometimes | No |
A general comparison of common alternatives, not of any specific product. Features of individual apps and templates vary.
Questions
Contractor 1099 Tracker 2026 FAQ
Does it file 1099s for me?
No. It tells you who likely needs a Form 1099-NEC and gives you the names, addresses and amounts. File through the IRS system or your tax preparer.
Why is the threshold $2,000?
For payments made after December 31, 2025, the 1099-NEC reporting threshold rose from $600 to $2,000 under the 2025 tax law. It's an editable setting, so check irs.gov each year.
Why don't card or app payments count?
Payments by card or through payment apps are generally reported by the payment company on Form 1099-K. The method table is editable if your situation differs.
Are corporations included?
Corporations are generally exempt, except for payments to attorneys. The tracker marks them 'Likely exempt' unless the service type is Legal. Confirm with a professional.
Do they work in Google Sheets as well as Excel?
Yes. Every template comes as Excel files (sample and blank) plus a link that puts your own copy in Google Drive in one click. Excel 2010 or later on Windows or Mac, and Excel for the web, all work. No macros or add-ins.
Is there a subscription?
No. Each template is a one-time purchase. The file is yours to keep and use.
How do I get my files?
Right after checkout you'll see your download and Google Sheets links, and we email them to you as well.
Pairs well with
Complete your setup
Move-In/Move-Out Inspection & Maintenance Log
A room-by-room inspection, a deposit-return worksheet, a repair log and a preventive maintenance schedule.
Best value · save $42
The Landlord Toolkit
Five spreadsheets that run the whole landlord year: the books, the leases and rent, the contractors, the turnovers and your next purchase. One download, one price, yours to keep.
- Rental Bookkeeping 2026$27
- Lease & Tenant Tracker$17
- Contractor 1099 Tracker 2026$15
- Inspection & Maintenance Log$15
- Rental Property Deal Analyzer$27
Best value
Bought separately: $101
$59
You save $42
That's $11.80 per template, paid once.
The Toolkit price goes up to $79 on Jan 1, 2027.
Get all 5 now
Instant download · Excel + Google Sheets · One-time price
Tax year 2026 closes · Dec 31, 2026
52days
10hrs
13min
55sec
Contractor 1099 Tracker 2026, ready in minutes
Every payment to your plumber, cleaner and handyman, W-9 status, and who likely needs a Form 1099-NEC.
- Instant download
- Excel + Google Sheets
- One-time price
- No subscription