Skip to content

A filing system

How to organize rental receipts in Google Drive and Sheets

A simple way to file each rental expense in your own Google Sheets and Drive, with the receipt linked to the right property.

Source document · R014Sample HardwareReplacement door latch$48.60September 18, 2026
Expense recordPine House
Amount
$48.60
Receipt
R014 · original file
Review
Entered and checked
One purchase, with its property and source document connected.

Start with one Sheet and one receipts folder per property. Each saved expense gets a row with a link to its receipt.

With 2–10 properties, the useful habit is small: file the expense while you remember the purchase. At tax time, you can open the property's Sheet and follow the link instead of searching your phone, email or a drawer.

Let Receipt Janitor do the filing

Add each property once. Receipt Janitor creates its Google Sheet and receipts folder in your Drive. It scans photos and PDFs to fill in the expense details automatically. Review the details, choose the property and save.

The expense becomes a row linked to its receipt. Open the files directly in Google Sheets and Drive, share them with Google's controls, and keep them if you stop using Receipt Janitor.

Your Google files remain under your control. Receipt Janitor also processes receipts and keeps expense and recovery records; the Privacy notice explains those details.

Give every property one consistent name

Choose a short label for each property and use it everywhere. “Pine House” is easier to recognize on a phone than three similar street addresses. If the building has multiple units, add the unit where it matters.

Use the same label in folder names and ledger entries. “Pine,” “Pine rental,” and “Pine upstairs” should not accidentally become three versions of the same place.

Make the expense row useful on its own

Keep enough detail to recognize the purchase and open its evidence. Receipt Janitor offers these expense fields, with a receipt link beside the row:

  • Date
  • Amount
  • Merchant
  • Description
  • Schedule E category
  • Receipt link

Write descriptions that preserve the reason for the purchase. “Replacement door latch for Pine House” is more useful than “supplies.” If you do not know the property or category, flag the uncertainty instead of choosing something just to finish the row.

The IRS describes several kinds of supporting information and notes that more than one document may be needed to substantiate an expense. A ledger row should help you find that evidence, not replace it. IRS guidance

The IRS source here concerns U.S. records. Keeping the document and choosing a category does not establish deductibility or the correct reporting method for your rental. Preserve the purchase facts for your own accounting and tax review.

When you file manually, use a name you will recognize, such as “Pine House door latch September 18.pdf.” Receipt Janitor files and links the receipt when you save, so a naming system is not another setup task.

Open the link from the expense row and check that the complete receipt is readable, including the total. Confirm that it is the right document.

For an emailed invoice, keep the source document you received. A payment confirmation may be another relevant record; do not assume an invoice alone says whether it has been paid.

Test the system with one ordinary question

Pick an expense from last month. Can you identify the property, understand what was bought, and open the receipt without searching your camera roll?

If you can, the system is doing useful work. If you cannot, fix the missing link before adding more folders or formulas.

Keep unresolved records visible. A missing receipt, an unclear property, and a possible duplicate are different problems and deserve different notes.

Optional: a manual inbox for a larger backlog

If you file receipts yourself in Google Drive, an Inbox can separate documents still waiting for review from those already entered. Add a year folder only if it helps you find things.

A photo in an inbox is not yet a recorded expense. For a larger backlog, keep a short list of what needs checking and the next action. Extra status labels are optional.

These are choices for a manual system. Receipt Janitor creates a Sheet and receipts folder for each property; you do not need to build an Inbox/Filed workflow before using it.

Published by Refactor Development LLC. Prepared with AI assistance. For recordkeeping guidance; consult a qualified professional for tax advice.