Report this item to Etsy

Price:$17.00

1099-NEC Contractor Tracker — Airbnb STR Host Tax Template — 600 Threshold Auto-Flag — Excel Spreadsheet

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

  • Designed by TheSTRLedger
  • Party decor for gatherings and celebrations
  • Digital download
  • Digital file type(s): 1 File

Close your year before April does. 1099-NEC tracker for Airbnb and STR hosts. Auto-flags the $600 IRS threshold per contractor. Editable Excel.

Pay your cleaner $600 or more in a year? She needs a 1099-NEC from you by January 31.
Pay your handyman across 6 visits — did you hit $600 total? Your landscaper? Your
emergency plumber? Most hosts have no idea who crossed the threshold until their CPA
asks in January — and then spend days piecing it together from Venmo screenshots.

This tracker catches every payment, every contractor, all year — so January is
15 minutes instead of 15 hours.

═══════════════════════════════════════════
WHAT'S INCLUDED
═══════════════════════════════════════════

📋 Contractor Directory (50-capacity)
· Name, business name, EIN/SSN, full address
· Email, phone, services provided
· W-9 on File? (Yes/No dropdown) + W-9 received date

📋 Payment Log (2000-capacity)
· Date, contractor (dropdown), amount, payment method
· 7 methods: Venmo, Zelle, Check, Cash, ACH, Credit Card, Other
· Property tag + description + notes

📋 1099 Prep Dashboard (auto-calculated)
· YTD paid per contractor — updates as you log payments
· Auto-flags anyone at or above $600 with YES in red
· W-9 status per contractor pulled live from Contractor tab
· Status column: ✓ Ready (green) or ⚠ Need W-9 (yellow)
· Summary: count of 1099s required, ready, pending W-9, total $ volume

📋 Settings Tab
· Editable IRS threshold (default $600 — IRS may adjust)
· Auto tax year
· IRS Pub 1220 penalty schedule for reference ($60–$660 per form)

═══════════════════════════════════════════
WHY STR HOSTS NEED THIS
═══════════════════════════════════════════

The IRS requires a 1099-NEC for every contractor paid $600+ in a calendar year.
Deadline: January 31. Penalties for missing forms range from $60 to $660 per form
(IRS Publication 1220). You also risk losing the deduction on those payments entirely.

This template auto-flags who crosses $600 in real time — no manual tallying,
no Venmo scroll, no January scramble.

═══════════════════════════════════════════
WHO THIS IS FOR
═══════════════════════════════════════════

· Airbnb and VRBO hosts with cleaning, handyman, or landscaping contractors
· Multi-property STR hosts tracking payments across properties
· Anyone whose CPA asked for their 1099 list last January and they had nothing
· Hosts who pay via Venmo or Zelle and want a clean paper trail

═══════════════════════════════════════════
HOW IT WORKS
═══════════════════════════════════════════

1. Setup (10 min): add your contractors to the Contractors tab
2. Every payment: log one row in the Payment Log (30 seconds)
3. Monthly: open the Dashboard — see who's crossed $600 and whether their W-9 is on file
4. December: chase any missing W-9s before year-end
5. January: hand the Dashboard to your CPA or upload to Track1099 / QuickBooks

═══════════════════════════════════════════
FILE COMPATIBILITY
═══════════════════════════════════════════

✅ Microsoft Excel 2016+ (Windows and Mac)
✅ Microsoft Excel 365
✅ Google Sheets

═══════════════════════════════════════════
REFUNDS + SUPPORT
═══════════════════════════════════════════

14-day refund, no questions asked. Email hello [!at] thestrledger.com — real humans,
fast replies. If the file doesn't work on your setup, we'll make it right.

═══════════════════════════════════════════
ABOUT THE STR LEDGER
═══════════════════════════════════════════

Business-grade Excel systems for serious short-term rental hosts.
Full template library at thestrledger.com.

═══════════════════════════════════════════

⚠ Digital product. Not tax advice. Consult your CPA for specific situations.

Learn more about this item

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

View shop registration details
TheSTRLedger
Dan
TheSTRLedger ·

Utah, United States

No reviews yet
·
1 sale
·
1 month on Etsy
Charya
1 shop member
Message seller

Be the first to leave a review

Support this new shop by ordering and sharing your feedback. Plus, shop confidently with Etsy Purchase Protection.
Learn more

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Moving Company Crm

Trust Spreadsheet

Listed on May 20, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates