Who Paid, What It Cost, What You Keep
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.
Small-landlord rent rolls and online-seller books — live Excel and Google Sheets templates. Prices are the live listing prices; they are not all the same.
What this page is
If you are building a digital-product shop, this is what a working ops-template line looks like from the buyer’s side: rent collected is not deposits held, and gross sales are not profit after fees. Pair it with our digital products guide. Landlords: first half. Sellers: second half. You do not have to buy every file. Sibling guides: church finance templates · home maintenance templates.
Quick Navigation:
Who paid, what it cost, what you keep
You said yes to a duplex, or yes to an Etsy shop, and you are now the back office. The landlord knows who is late, what the plumber charged, and whether the deposit still covers the carpet. The seller discovers in April that gross sales are not profit — fees and supplies ate the margin.
You do not need property-management software or a full accounting suite. You need workbooks that match the job, open in Excel or Google Sheets, and do 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 updated (28 August 2026). Prices are the live listing prices — they are not all the same. Instant download — nothing ships. Templates, not tax, legal, or investment advice.
For the small landlord: rent, repairs, empty days
Four piles people mash into one notebook: who paid; what you still hold; empty days and make-ready; the other lease (nightly stays, or a deal you have not bought). Start with the pile eating Sunday night.
1. The hub: rent collected, late flags, expenses
Landlord Rent Roll Spreadsheet | Rental Property Tracker Tenant Payment Income Expense Excel
Listing 4483585796 · $6.99
This is 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 the small landlord who needs who paid — not a deposit ledger, not a vacancy file, not property-management software.
2. Collections, owner costs, and deposits in one file
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.
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. Not a rent roll; it does not look up deposit-return law — return-by dates are reminders you type.
4. Turnover week: vacant days and make-ready
Landlord Vacancy Tracker Spreadsheet | Tenant Turnover Make Ready Log Excel Sheets
Listing 4563056483 · $6.99
Notice to new lease: turnover ledger, vacant / notice / occupied counts, a 30-day vacancy-loss estimate (days vacant × monthly rent ÷ 30 — planning only, not a proration or Schedule E line), printable make-ready, work orders. Not a rent roll or deposit ledger.
5. Nightly stays are not a 12-month rent roll
Vacation Rental Bookkeeping Spreadsheet | Host Income Occupancy Tax Excel Sheets
Listing 4528642066 · $7.99
Thirteen tabs for nightly stays: bookings (Airbnb, VRBO, Booking.com, 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.
6. Before you own it: go / caution / no-go
Real Estate Deal Analyzer Spreadsheet | BRRRR Rental Cash Flow ROI Cap Rate Excel Google Sheets
Listing 4528634147 · $7.99
Purchase, rehab, rent, and financing go in; cash-on-cash, cap rate, a go / caution / no-go dashboard, BRRRR refinance, flip profit, and a 10-year cash-flow view come out. One deal before you bid — not a rent roll, not investment advice.
7. The landlord set, if you want all four jobs
Landlord Rent Roll Bundle Spreadsheet | Tenant Payment Deal Analyzer Excel Sheets
Listing 4533445912 · $19.99
Four browser dashboards in one download: property manager, deal analyzer, STR tracker, rehab budget, plus a start-here PDF. Buy this for the set; buy a single listing above if you only need one job.
For the online seller: fees, COGS, and tax-time totals
Three piles that are not the same spreadsheet: the order (fees and what you kept); the shop (income, expenses, a P&L); the other hustles (resale plus a gig, and which one paid for the hours).
1. The hub: Etsy fees, COGS, net per order
Etsy Seller Bookkeeping Spreadsheet | Fee Calculator Profit COGS Tax Tracker Excel Google Sheets
Listing 4533025325 · $6.99
This is the shop’s main seller workbook: a 12-tab order log where listing, transaction, and processing fees and net calculate per sale, plus expenses, P&L, a fee/price solver, sales-tax collected, mileage, and inventory. Fee rates in the file are a starting model — verify current Etsy rates; not tax software.
2. If Etsy is not the whole 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. Shop-wide books for product sellers — not marketplace fee math.
3. Adjacent, honestly: resale as one of several hustles
1099 Income Tracker Spreadsheet | Side Hustle Profit Expense Tax Excel Google Sheets
Listing 4483585834 · $6.99
If resale is one stream among others (the listing names freelance, resale, and rideshare), this file logs income, expenses, and hours per hustle so profit and an effective hourly rate calculate. Not an Etsy fee calculator — skip it if you only need order-level fees.
4. The seller set, if you want the three workbooks
Small Business Bookkeeping Bundle Spreadsheet | Freelancer Invoice Seller Tax Excel Google Sheets
Listing 4535716354 · $12.99
Three workbooks: the Etsy seller file, the small-business tracker, and a freelancer invoice / aging manager (that third file is billed clients, not COGS). Buy the set, or the Etsy listing alone if fees are the only job.
How to choose
Landlords
| If your actual problem is… | Start here |
|---|---|
| Who paid, who is late, what repairs cost | Landlord Rent Roll |
| Rent + owner expenses + deposits in one file | Expense & Deposit Tracker |
| Move-out: held, deducted, refunded, remaining | Security Deposit Tracker |
| Empty days, make-ready, work orders | Vacancy Tracker |
| Airbnb / VRBO / direct stays, occupancy, host net | Vacation Rental Bookkeeping |
| Underwriting a purchase before you bid | Deal Analyzer |
| All four investor jobs in one download | Landlord Rent Roll Bundle |
Practical stack: rent roll plus the security-deposit file. Use the combined expense-and-deposit workbook instead if you want those jobs in one place. Add vacancy, STR, or the deal analyzer only when that pile exists.
Sellers
| If your actual problem is… | Start here |
|---|---|
| Etsy fees, COGS, net per order | Etsy Seller Bookkeeping |
| Shop-wide income, expenses, light inventory, P&L | Small Business Bookkeeping |
| Resale plus other hustles, hours vs. profit | 1099 Income Tracker |
| Etsy + shop books + freelancer invoices together | Small Business Bookkeeping Bundle |
Practical stack: the Etsy seller file if that is the only channel. Add the small-business workbook for off-platform sales. Skip the 1099 file unless you are comparing hustles.
Files open in Microsoft Excel and Google Sheets. Several listings also note they are not tested in Apple Numbers. Some listings include a browser dashboard as a companion.
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 three doors on the rent roll” or “add a second marketplace fee column.” 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, 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: Landlord and Seller Templates
Do I need every file on this page?
No. Landlords: rent roll plus the security-deposit file, or the combined expense-and-deposit workbook if you want those jobs in one place. Sellers: the Etsy seller file if that is the only channel. Skip the 1099 file unless you are comparing hustles.
Does the Schedule E helper file a return?
No. It maps totals to common Form 1040 Schedule E Part I labels as a convenience. It does not calculate depreciation or statutory deadlines. Vacancy-loss dollars are a 30-day planning estimate (days vacant × monthly rent ÷ 30), not a Schedule E line.
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.
Can you put my three doors on the rent roll?
Yes. That is a typical request the shop takes. Free small customizations cover labels and extra categories. Larger work is a paid custom, quoted before any extra charge. For paid customs, timeline is usually 1–3 business days after we lock the brief.
Building the shop, not just buying the file?
See how digital products actually get sold — then look at the live church, home, and landlord listings as a working catalog.
Read the Digital Products Guide