You bought a replacement door latch for Pine House. The receipt is on your phone. The amount is in your spreadsheet. Two months later, neither tells you enough to answer a simple question: which purchase was this?
A useful receipt system keeps the details together. Start with a folder for the source documents and a ledger that points to them. You can do this with Google Drive and Sheets you already use.
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.
Keep incoming receipts separate from reviewed ones
Inside the property's folder, create a folder for the year. Within that, use an Inbox for documents you still need to review and a Filed folder for documents entered in the ledger.
For example: Pine House → 2026 → Inbox or Filed.
A photo in Inbox means you have captured something. It does not mean you have checked the amount or recorded the expense. That distinction helps when you are interrupted halfway through a batch.
If you already have a folder structure that works, keep it. Add a clear way to tell what is still waiting.
Use four review states if a simple inbox is no longer enough: Captured, Needs information, Ready to enter, and Entered and checked. Only the last means you have opened the saved row and verified its evidence. These are labels for your manual system, not Receipt Janitor app statuses.
Make the expense row useful on its own
A practical starting set of columns is:
- Transaction date
- Property or unit
- Vendor
- Amount and currency
- Description
- Category to review
- Receipt link
- Status or open question
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
A file name such as “2026-09-18_Pine_SampleHardware_48.60_R014.pdf” gives you several ways to recognize a receipt. The final reference helps distinguish two purchases from the same store on the same day.
Add the file link to the expense row. Open it once and check that the complete receipt is readable, including the total. Confirm that it is the right document before moving it into Filed.
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.
Where Receipt Janitor fits
Receipt Janitor is designed to shorten the capture-and-entry part: add a photo, PDF, or note; review the details; then explicitly save to a property-specific Google Sheet and Drive folder. It currently creates managed property Sheets, rather than connecting to any existing workbook layout.
If your manual process is quick and reliable, you may not need an app. The same test still applies: start with a row and make sure you can get back to its evidence.
Published by Refactor Development LLC. Prepared with AI assistance. Examples are fictional; this guide is not professional accounting or tax advice.