Nightly Profit

For Canadian & US short-term rental hosts

Hand your accountant organized numbers, not a shoebox.

Tax season usually means a pile of receipts, payout reports that don't match the 1099-K, and an accountant asking for "a summary by category". The Year-End STR Tax Pack gets you to that summary, laid out the way the forms are. It organizes your records; it doesn't give tax advice or file anything.

Get it for US$7 See what's inside

Year-End STR Tax Pack (Canada & US) · One-time purchase · Instant download · 14-day refund · Also on Etsy

Category summary with totals by property and by T776, Schedule E and Schedule C line, shown with sample data

What's inside

Category summary with totals by property and by form line, shown with sample data

Totals by category, property and form line

  • Income by property, quarter and month: gross rent, platform fees, taxes collected and net payouts.
  • One expense list mapped to CRA Form T776, IRS Schedule E and Schedule C lines, with business-use %, GST/HST ITCs and capital items kept separate.
  • The mapping is editable, and your preparer makes the final call.
Form 1099-K reconciliation tab comparing Box 1a with recorded payouts, shown with sample data

Reconcile the 1099-K (US)

  • Compares the gross amount in Box 1a with your records and lists the gap line by line: fees, refunds, cleaning fees, off-platform bookings.
  • Checks it month by month for up to four payers.
GST/HST quarterly summary and mileage log, shown with sample data

GST/HST and mileage

  • Canada: GST/HST collected vs input tax credits by quarter, plus a rolling four-quarter monitor against CRA's $30,000 small-supplier threshold.
  • A trip log in km or miles that gives your business-use %, and for US properties applies the IRS standard mileage rate by trip date (rates are editable on the Lists tab).
Accountant handoff summary page and pages from the 6-page guide

Accountant handoff + a plain-English guide

  • An asset log with dates, business-use %, CRA CCA class and US asset type, so your accountant can work out CCA or depreciation. The pack deliberately doesn't calculate them.
  • A one-page summary per property, a documents checklist and questions to ask.
  • A 6-page guide with a table of official CRA and IRS sources.

The full file list

Year-End workbook (.xlsx)

Income, Expenses, Category Summary, 1099-K Reconciliation, GST/HST, Mileage, Asset Log, Accountant Handoff and Lists. Sample-data and blank versions.

Year-End STR Tax Guide: Canada & US

.docx + 6-page PDF, with official sources.

  • Excel 2019 / 2021 / 365 & Google Sheets
  • 1,000 income, expense and trip rows
  • No macros or add-ons

Year-End STR Tax Pack (Canada & US)

US$7 one-time
Buy on Gumroad

Or buy on Etsy

Secure checkout by Gumroad or Etsy. The price may show in your local currency, with sales tax or VAT added where required. See our refund policy.

Frequently asked questions

Is this tax advice? Will it file my return?

No. It's an organizer and general information, not tax advice. It puts your records into the totals an accountant or tax software asks for; it doesn't prepare or file anything. Confirm your situation with a qualified professional.

Schedule E or Schedule C?

It depends on whether you provide substantial services (see IRS Publication 527). The workbook shows both line mappings, and your preparer decides which applies.

Does it calculate CCA or depreciation?

No, on purpose. Those depend on choices your accountant should make, such as class, timing and recapture. The Asset Log gathers what they need.

Can I use it for properties in both Canada and the US?

Yes. Each property has a country, and each tab picks up only the properties it applies to. Use one currency per workbook, or keep a copy per currency.

Is the sample data real?

No. The properties and all figures are made up for demonstration.

What if it isn't right for me?

Email [email protected] within 14 days of purchase for a full refund. See the refund policy.

Related

Organizers and templates, not tax, legal or financial advice. Sample data is made up. Nightly Profit is not affiliated with Airbnb, Vrbo or Booking.com.