How to Keep a Home Repair Spending Log (4 Simple Methods)
TL;DR: Track every home repair with the date, cost, vendor, and scope of work. Use a spreadsheet, property app, receipt scanner, or paper ledger—whichever you'll actually maintain. A complete log cuts your tax prep time in half and can increase your home's resale value by documenting major upgrades.
_Last reviewed: July 2026 · 7 min read_
Most homeowners discover the importance of a repair log when they need it most: during a tax audit, when a buyer's inspector questions a claim, or when an insurance adjuster asks for proof. By then, receipts are lost, vendor names forgotten, and the exact date of a $4,000 furnace replacement is a guess. A simple spending log solves all three problems.
Okoniq Property Hub lets you log repairs, attach receipts, and track spending by property—all timestamped and exportable when your CPA or inspector needs the data.
What information should a repair log include?
Every entry needs five data points: date of service, vendor name and contact, total cost, payment method, and scope of work. The date establishes timeline for depreciation and warranty coverage. Vendor contact lets you call them back for warranty claims or follow-up. Cost is your tax deduction. Payment method ties the log to bank statements. Scope of work—"replaced kitchen faucet cartridge" not just "plumbing"—proves the repair to an auditor or buyer.
Add a sixth field for category: HVAC, plumbing, electrical, roofing, landscaping. Categories let you spot spending patterns. If you've logged $1,200 in plumbing calls over six months, you know it's time to replace that cast iron drain pipe before the next emergency. Attach photos of the completed work and the itemized receipt as PDFs or JPGs—cloud storage is cheap, and a picture of a new water heater beats a handwritten note every time.
For major projects—roof replacement, HVAC install—note the warranty term and expiration date. Write "10-year labor, 25-year shingle" so you don't dig through the installer's fine print three years later.
Should I use a spreadsheet, an app, or paper?
A spreadsheet works if you're comfortable with columns and filters. Create one tab per year or one per property. Columns: Date | Vendor | Category | Description | Cost | Payment | Receipt Link. Sort by date or category. Export to CSV for your accountant. The downside: spreadsheets don't nag you to log an expense, and you'll forget unless you set a weekly reminder.
A dedicated property app like Okoniq auto-timestamps entries, stores receipt images inline, and groups expenses by property or unit. You can email a PDF export to your CPA without reformatting. Apps sync across devices, so you can log a repair from the driveway after a contractor leaves. The trade-off: one more login to remember, though most integrate with your phone's camera for instant receipt capture.
Paper ledgers—a spiral notebook or bound logbook—still work. Write the date, vendor, and amount on the left; tape the receipt on the facing page. Pros: no tech, no subscription, and a physical book survives a hard drive crash. Cons: no search function, no auto-sum, and you'll need to scan pages for tax season. If you choose paper, use a pen (pencil fades) and store the book in a fireproof safe or safety deposit box.
Receipt scanner apps (Shoeboxed, Expensify, Genius Scan) bridge the gap: snap a photo, let OCR pull the date and total, tag it "home repair," done. Most export to QuickBooks or Excel. Pair a scanner app with a simple spreadsheet and you've built a hybrid system that takes 30 seconds per entry.
How does a repair log help at tax time?
The IRS lets homeowners deduct qualifying repairs on rental properties and sometimes on primary residences after a casualty loss or home office use. A complete log turns "I think I spent $8,000" into "I spent $8,247.13 across 19 line items, here's the export." Your CPA bills by the hour—organized records cut their time by half.
For rentals, you deduct ordinary repairs (fixing a leaky faucet, regrouting bathroom tile) in the year you pay. Major improvements (new roof, HVAC replacement) get capitalized and depreciated over 27.5 years. A log with clear descriptions—"replaced compressor" vs. "installed new 3-ton AC unit"—lets your CPA classify each expense correctly. Misclassify a $6,000 improvement as a repair and you'll face penalties if audited.
If you sell your primary residence, capital improvements (not routine repairs) increase your cost basis and reduce taxable gain. A $15,000 kitchen remodel you logged three years ago could save you $3,000 in capital gains tax. The IRS wants proof: receipts, contractor invoices, permits. A log with attached PDFs is proof.
Home office deductions require meticulous records. If you claim 10% of your home's square footage as an office, you can deduct 10% of qualifying repairs that benefit the whole house—furnace maintenance, roof patches, basement waterproofing. The log shows the expense was paid and the work was done during the tax year.
What's the best way to organize receipts alongside dollar amounts?
Digitize every receipt within a week of the repair. Use your phone's camera or a flatbed scanner. Save files as YYYY-MM-DD_Vendor_Amount.pdf—for example, 2024-11-08_AcePlumbing_342.pdf. Store them in a cloud folder (Google Drive, Dropbox, iCloud) organized by year and category: /2024/Plumbing/, /2024/HVAC/. Cloud storage survives a house fire; a shoebox in the garage does not.
Link each receipt file in your spreadsheet or app entry. In Excel, use the HYPERLINK function: =HYPERLINK("path/to/receipt.pdf", "View"). In Okoniq, tap the camera icon to attach the image directly to the log entry. Six months later, when you're reconciling bank statements, you'll click the link and confirm the charge in seconds.
For paper receipts, thermal paper (gas station and hardware store receipts) fades in 2-3 years. Photocopy or scan them immediately. Store originals in a manila envelope labeled by year; store scans in the cloud. If an auditor asks for proof, hand them the digital file first—it's clearer than a faded original.
Tag expenses by property if you own more than one. Use a prefix: Rental_A_, Rental_B_, Primary_. When you sell Rental A, you'll filter the log, export those rows, and hand your CPA a complete repair history for depreciation recapture calculations.
How long should I keep home repair records?
Keep records for rental properties seven years after you file the return that included the expense. The IRS has a three-year statute for routine audits but six years if they suspect underreporting by 25% or more. Seven years covers the longest window. For capital improvements—anything depreciated—keep records until seven years after you sell the property, because the improvement's basis affects your taxable gain.
For your primary residence, keep records of capital improvements (new roof, kitchen remodel, attic insulation upgrade) until you sell the home plus seven years. If you bought in 2015, remodeled in 2020, and sell in 2030, keep the 2020 records until 2037. Routine repairs on a primary residence (unless you have a home office) can be shredded after three years—they're not deductible and won't affect a sale.
Warranties complicate the timeline. If you replace a water heater with a 10-year warranty in 2024, keep that invoice until 2034 even if you sell the house in 2028. The new owner will want proof of the warranty, and the manufacturer won't replace a failing unit without the original purchase receipt. Tape a copy of major warranties to the appliance itself—a piece of painter's tape on the furnace cabinet with "Warranty expires 2032" saves a future headache.
FAQ
What counts as a repair versus an improvement for tax purposes?
A repair restores something to working condition without adding value: patching a leak, replacing a broken window, fixing a cracked outlet. An improvement adds value, extends useful life, or adapts the property to a new use: replacing an entire roof, installing central air, finishing a basement. Repairs are deductible in the year paid; improvements must be depreciated. When in doubt, describe the work specifically in your log and let your CPA decide.
Can I reconstruct a repair log after the fact if I never kept one?
Yes, but it's painful. Pull credit card and bank statements for the past three years. Search for home improvement stores, contractor names, and plumber charges. Match amounts to calendar entries or emails. Call your bank for older statements if needed. Cross-reference permit records from your city—if you pulled a permit for electrical work, the date and contractor are public. You'll miss cash payments and forgotten vendors, but you'll recover 70-80% of your spending. Start a proper log today so you never do this again.
Should I log DIY repairs where I only bought materials?
Yes. Track the material cost, store name, and project description. If you spent $180 at Home Depot on grout and supplies to regrout a shower, log it. The IRS doesn't let you deduct your own labor, but materials are deductible if the property is a rental or home office. For capital improvements, material costs add to your basis. Even on a primary residence, a log of DIY projects shows a buyer you've maintained the home—worth mentioning in listing copy.
Do I need to track emergency repairs differently than scheduled maintenance?
Track them the same way—date, vendor, cost, scope—but add a note: "Emergency call" or "After-hours service." Emergency repairs often cost 50-100% more, and the note explains the higher bill to your accountant or a future buyer. If the same system fails twice in a year (two emergency AC calls in July), the pattern in your log makes the case for replacing the unit instead of patching it again.
How do I prove a repair happened if I paid cash and lost the receipt?
You can't prove it to the IRS without a receipt, but you can document it for your own records. Write a detailed note: date, vendor name and phone, work performed, amount paid. Take a photo of the completed work. If you remember the contractor's truck, search online for their business name and note it. This won't satisfy an auditor, but it's better than nothing and may jog your memory if you need to contact the vendor again. Going forward, always ask for a receipt—even handwritten on a scrap of paper—and snap a photo before you leave.
This is educational information, not tax or financial advice. Consult a CPA about deductibility, depreciation, and record retention requirements for your specific situation.
Keep reading
Get seasonal maintenance tips by email
Gutter-cleaning, filter-changing, before-it's-a-$3,000-problem guides. No schedule, no spam — unsubscribe anytime.
Prefer to dive in? Get started free →