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.
Link the original, then check it
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.