The Rental Property Doesn't Know You Work Days. The 1099 Income Doesn't Either.
Shop disclosure: Smart Files Shop (Etsy: SmartFilesShopUS) is operated by Jaceal, LLC, which also publishes this site. Links below go to live Etsy listings we sell. We earn the listing price on those sales. This page is a buyer's guide, not a ranking. Not tax, legal, accounting, or investment advice. AI-assisted draft; reviewed against the shop's live Etsy catalog on 7 September 2026.
A physician with a W-2 job, a rental property, and a few 1099 shifts a month has three separate bookkeeping jobs and no time for any of them. Here is what a working setup looks like — live Excel and Google Sheets templates, not property-management software. Prices are the live listing prices; they are not all the same.
What this page is
Most physician-landlord content stops at "should you buy the rental." This page is the operations layer after you already own it, plus the 1099 side income a lot of physicians run next to it — locum shifts, moonlighting, expert-witness work. Closest DNA siblings: landlord and seller bookkeeping templates · how to track rental income and expenses for taxes · how to keep a rent roll and track leases. Physician-specific reading: 1099 moonlighting taxes for physicians · locum tenens for physicians · medical expert witness income · real-estate professional status for physicians.
Quick Navigation:
- Two jobs, one Sunday night
- The rental: who paid, what it cost
- Owner costs and the Schedule E helper
- Move-out: held, deducted, refunded
- If the property is a short-term rental
- If the 1099 work is its own small business
- Locum, moonlighting, and expert-witness income
- How to choose
- Love Guarantee and custom work
- FAQ
Two jobs, one Sunday night
The rental doesn't care that you were on service all week. Rent still needs a paid/late flag, the deposit still needs a ledger, and a repair bill still needs a category before it turns into a shoebox. The 1099 side income has the same problem in miniature: a handful of locum shifts or a couple of expert-witness reports a quarter don't feel like "a business" until March, when the 1099-NEC forms show up and the self-employment tax math does too.
Property-management software is built for people who manage units full time. A physician with one duplex and three locum shifts a month needs something smaller: a workbook that matches the job, opens in Excel or Google Sheets, and does not pretend to file a return.
Smart Files Shop (Etsy: SmartFilesShopUS) sells those downloads. Everything linked below was live and active on Etsy when this page was last checked (7 September 2026). Prices are the live listing prices — they are not all the same. Instant download — nothing ships. Templates, not tax, legal, or investment advice.
1. The rental: who paid, what it cost
Landlord Rent Roll Spreadsheet | Rental Property Tracker Tenant Payment Income Expense Excel
Listing 4483585796 · $6.99
The shop's main landlord workbook: units, leases, a payment log with paid / partial / late flags, expenses, and a dashboard of rent collected vs. costs. For a physician who owns one or two doors and needs "who paid" without paying for property-management software you'll use for ten minutes a month.
2. Owner costs, deposits, and the Schedule E helper
Landlord Expense Deposit Tracker Excel | Rental Security Deposit Schedule E Spreadsheet
Listing 4562934360 · $7.99
Seven tabs: rent roll with late fees and balance due, owner costs with a deductible Yes/No flag you set, itemized deposits with remaining held, an annual summary, and a Schedule E Helper mapping totals to common Form 1040 Schedule E Part I labels as a convenience — not a tax form, and not depreciation or statutory deadline math. A rental on top of practice income is still a Schedule E activity; this file organizes the inputs your CPA asks for. It does not test for real-estate professional status — see real-estate professional status for physicians for that separate question.
3. Move-out: held, deducted, refunded, remaining
Security Deposit Tracker Spreadsheet | Landlord Refund Deduction Log Excel Sheets
Listing 4562846904 · $6.99
Six tabs for what you still hold: ledger, itemized deductions, refunds actually paid, remaining $ as formulas. Useful on its own if the rent roll above already covers collections and the only gap is what happens at move-out. Not a rent roll; it does not look up deposit-return law — return-by dates are reminders you type.
4. If the property is a short-term rental
Vacation Rental Bookkeeping Spreadsheet | Host Income Occupancy Tax Excel Sheets
Listing 4528642066 · $7.99
Some physicians run the rental as a nightly-stay property instead of a 12-month lease — a lake house or a second home listed part of the year. Thirteen tabs for that: bookings across Airbnb, VRBO, Booking.com, and direct; fees; cleaning; occupancy / ADR / RevPAR; ROI. A browser companion adds lodging-tax and bank-recon panels. Not a long-term rent roll; not affiliated with those platforms.
5. If the 1099 work is run as its own small business
Small Business Bookkeeping Spreadsheet | Self Employed P&L Tax Tracker Excel Sheets
Listing 4483358189 · $6.99
Income, expenses, a simple product catalog, invoices, light inventory, P&L, a tax-summary tab of totals you entered, and mileage. Fits a physician who bills consulting, medical-legal review, or telehealth work through their own entity rather than as one-off 1099-NEC shifts — see 1099 moonlighting taxes for physicians for the SE-tax and QBI mechanics that make the entity question matter.
6. Locum, moonlighting, and expert-witness income
1099 Income Tracker Spreadsheet | Side Hustle Profit Expense Tax Excel Google Sheets
Listing 4483585834 · $6.99
For a physician running more than one 1099 stream at once — a locum shift here, a moonlighting block there, an occasional expert-witness report — this file logs income, expenses, and hours per hustle so profit and an effective hourly rate calculate. That last number matters: a well-paid locum shift with a bad commute and a slow deposition fee can pencil out worse than it looks on the 1099. See locum tenens for physicians and medical expert witness income for the specialty-specific pay context. Not an Etsy fee calculator — skip it if you're only tracking marketplace sales.
How to choose
| If your actual problem is… | Start here |
|---|---|
| Who paid rent, who is late, what repairs cost | Landlord Rent Roll |
| Rent + owner costs + deposits + a Schedule E map, one file | Expense & Deposit Tracker |
| Move-out only: held, deducted, refunded, remaining | Security Deposit Tracker |
| The property is a nightly-stay rental, not a 12-month lease | Vacation Rental Bookkeeping |
| 1099 work billed through your own entity, invoices and P&L | Small Business Bookkeeping |
| Multiple 1099 streams (locum, moonlighting, expert witness), hours vs. profit | 1099 Income Tracker |
Practical stack for most physician landlords: the rent roll plus the security-deposit file, or the combined expense-and-deposit workbook if you want those two jobs in one place. Add the 1099 Income Tracker once locum, moonlighting, or expert-witness income exists alongside the rental — that's the file that turns "I picked up some shifts" into an actual number for your accountant.
Love Guarantee and custom work
Every listing on this page carries the same 14-day Love Guarantee.
Love Guarantee (14 days): Message Smart Files Shop if the file is not right — free fix, free small customization, or refund.
Free small customizations (typical examples): rename a column, add a header, change a property or shop label, add an expense category.
Paid customs — shop-wide / typical menu; message for a quote before any extra charge. Individual listings may quote lower for tweaks already in scope for that file — always by quote, never a surprise invoice. For paid customs, timeline is usually 1–3 business days after we lock the brief.
- Light custom $15–$29 — property names or shop name / header on every tab; extra categories
- Standard custom $39–$79 — extra units or marketplaces, a board-report tab, a branded refund-letter data export
- Deep custom $89–$149 by scope — branding, data import, multi-entity or multi-shop
The shop says yes to "put my rental and my locum income on one dashboard" or "add a second property." It does not take bookkeeping outsourcing, tax filing, or CPA work. One free polish pass is included on paid customs after first delivery.
What these files will not do
They will not connect to your bank, property-management app, or Etsy payout report. They will not file a Schedule E or Schedule C, calculate depreciation, test for real-estate professional status, look up deposit-return law, or replace a CPA. Vacancy-loss dollars and fee calculators are planning worksheets — not a filing.
If you want the files, buy them through the live links above. This page is a guide, not a checkout.
FAQ: Physician Landlord and 1099 Bookkeeping
I'm a W-2 physician with one rental property. Do I need all six of these files?
No. Start with the Landlord Rent Roll for who paid, or the combined Expense & Deposit Tracker if you also want owner costs and the security deposit in the same file. Add the 1099 Income Tracker only once locum, moonlighting, or expert-witness income exists alongside the rental.
Does the Schedule E helper tab file my return?
No. It maps totals to common Form 1040 Schedule E Part I labels as a convenience. It does not calculate depreciation, does not test for real-estate professional status, and is not a filed return.
I do locum tenens or moonlighting and have a rental. Which file tracks the 1099 side income?
The 1099 Income Tracker logs income, expenses, and hours per hustle so profit and an effective hourly rate calculate across locum shifts, moonlighting, or expert-witness work. If the side work runs through your own entity rather than shift-by-shift 1099 income, the Small Business Bookkeeping file is the better fit.
What is the Love Guarantee?
Every listing on this page carries the same 14-day Love Guarantee: message Smart Files Shop if the file is not right — free fix, free small customization, or refund. Customs pricing is not uniform across listings; individual listings may quote lower. Always by quote.
Want the broader landlord and seller catalog?
This page covers the physician-landlord-and-1099 slice. See the full set of live landlord, vacancy, deal-analyzer, and seller listings on the sibling page.
Read the Landlord & Seller Books Guide