How to Build a Year-at-a-Glance Home Expense Sheet in 5 Steps

TL;DR: A year-at-a-glance expense sheet is a single-page spreadsheet that logs every home-related cost by category and month. It helps you spot patterns (like HVAC repairs clustering in summer), catch duplicate vendor charges, and identify tax-deductible maintenance before your CPA needs receipts. Most landlords who track this way report saving 15-20% on annual maintenance spend by eliminating reactive, unplanned work.

_Last reviewed: July 2026 · 6 min read_

Most homeowners and landlords remember the big costs—roof replacement, furnace swap—but lose track of the $75 plumber visit, the $140 landscaping bill, and the $89 filter subscription. Without a single view of the year, you overpay for duplicated services, miss tax deductions, and budget blindly for next season. A year-at-a-glance expense sheet fixes that.

Okoniq Property Hub logs every expense and maintenance event automatically, tagging costs by category and generating a year-at-a-glance view on demand—no spreadsheet setup required.

What columns should a year-at-a-glance expense sheet include?

Start with six columns: Date, Vendor/Payee, Category, Description, Amount, and Tax Deductible? (Yes/No/Maybe). The Date column should be sortable so you can group by month or quarter. Vendor/Payee captures who you paid—useful when a contractor invoices twice for the same job. Category buckets your spending: HVAC, plumbing, electrical, landscaping, pest control, insurance, taxes, utilities, and a catch-all "other" for one-offs. Description is a brief note—"replaced south bathroom faucet" or "annual termite inspection"—that jogs your memory six months later. Amount is the dollar total including tax. The Tax Deductible column flags costs your CPA will care about; mark "Yes" for repairs and maintenance on a rental, "No" for improvements that capitalize (like a kitchen remodel), and "Maybe" when you're unsure—your accountant will sort it out.

If you manage multiple properties, add a seventh column for Property Address or a short code (123 Elm, Cottage B). Color-code rows by property in Excel or Google Sheets so you can filter and subtotal per unit. Landlords with basement waterproofing work on two houses will appreciate a single sheet that separates the $3,200 sump-pump install at one address from the $450 crack seal at another. Keep the layout flat and horizontal—avoid nested subtotals or merged cells that break sorting.

How do you populate the sheet without missing expenses?

Set a weekly 10-minute calendar block to enter receipts. Most people batch-enter on Sunday evening or Monday morning, pulling from email confirmations, credit-card statements, and paper invoices stuffed in a drawer. If you pay contractors by check, photograph the check register or note the check number in the Description field. For recurring charges—homeowners insurance, HOA dues, lawn service—enter them once and mark the recurrence in the Description ("monthly" or "quarterly"). That way you'll notice immediately if a vendor double-bills or skips a month.

Link your checking account to a read-only export or use your bank's CSV download feature monthly. Import the CSV into a second tab, filter for home-related payees, then copy those rows into your main expense sheet. Delete personal spending before you copy. This method catches auto-debits you'd otherwise forget—like the $89/year filter subscription that renews silently every March. Landlords juggling multiple properties often use a dedicated checking account per rental; the year-at-a-glance sheet becomes a direct mirror of that account's activity, minus tenant rent deposits.

What patterns should you look for once the sheet is full?

After three months of data, sort by Category and sum each bucket. You'll see which system consumes the most dollars—often HVAC in hot climates or plumbing in older homes. If "plumbing" totals $1,200 in Q1 alone, that signals a chronic issue (corroded pipes, tree-root intrusion) worth addressing with a single larger fix rather than serial $200 band-aids. Next, sort by Vendor. Two invoices from the same contractor in the same month for similar work might indicate a billing mistake or two separate service calls that could have been bundled into one trip charge.

Filter by the Tax Deductible column and subtotal the "Yes" rows. That's your deductible maintenance total for the year—hand that number and the filtered list to your CPA in January. Many landlords discover an extra $2,000–$5,000 in forgotten deductions this way. Finally, look at monthly spend rhythm. If October and November show zero maintenance, you're likely deferring seasonal tasks—chimney inspection, boiler maintenance, attic insulation checks—that cost more when they fail mid-winter. A spike in summer often means HVAC; a spike in spring usually means landscaping, gutter cleaning, or basement dehumidifier setup.

How do you turn the sheet into a forward-looking budget?

Copy your completed year-at-a-glance sheet to a new tab and label it "Next Year Budget." Delete the Date and Description columns; keep Category, Vendor (if you plan to use the same pro), and Amount. Add 10% to each amount to account for inflation and parts price increases. Sum the total—that's your baseline maintenance budget for the coming 12 months. If last year's HVAC spend was $800 and you know the furnace is 18 years old, add a $4,000 line for replacement; mark it "planned capital" so it doesn't inflate your recurring maintenance number.

Break the annual budget into monthly allocations. Divide the total by 12 and transfer that amount into a dedicated savings account or sinking fund every month. When a $600 plumbing repair hits in July, you've already set aside $50/month × 7 = $350 toward it—less sticker shock. Landlords who track this way report sleeping better because large bills no longer ambush them. Update the budget mid-year if you complete a big project early (roof replacement in June instead of September) or if a new pattern emerges (pest control needed quarterly instead of annually). The sheet becomes a living forecast, not a static record.

Should you track labor and materials separately?

For most homeowners, a single Amount column suffices. Landlords who do partial DIY or want to compare contractor pricing should split Amount into two columns: Labor and Materials. When a plumber charges $450 to replace a water heater, ask for an itemized invoice showing $200 labor and $250 for the tank. Enter those separately. Over time you'll see which contractors mark up materials heavily and which charge fair rates. If you bought the part yourself and hired labor only, enter $0 in Materials and the pro's fee in Labor.

This split also helps when you're deciding whether to DIY bathroom tile regrouting or hire out. Your sheet will show that last year's pro regrout cost $180 labor + $35 materials; if you buy the $35 in grout and caulk yourself, you're saving $180 but spending three hours. That's a $60/hour value-of-time calculation you can make with real numbers. Landlords who track labor vs. materials also spot when a vendor's labor rate creeps up year-over-year—helpful for renegotiating or finding a new contractor before renewal.

FAQ

What's the easiest way to store receipts alongside the expense sheet?

Snap a photo of every receipt with your phone and save it to a cloud folder (Google Drive, Dropbox, iCloud) named by year and month—"2024-12 Receipts." In your expense sheet, add a column called Receipt Link and paste the file URL or note the filename. When your CPA asks for proof of a $340 HVAC repair, you'll find the photo in seconds instead of digging through a shoebox.

Do I need a separate sheet for each property if I own multiple rentals?

Not necessarily—a single sheet with a Property column works well up to about three units. Beyond that, create one tab per property and a summary tab that pulls totals from each. Use Excel's SUMIF or Google Sheets' QUERY function to roll up Category totals across all properties. This structure lets you see per-unit performance and combined portfolio spend in one workbook.

How far back should I go when I'm starting from scratch?

Start with January 1 of the current year and work forward. Don't attempt to reconstruct five years of history—it's time-consuming and older data matters less for forward budgeting. If you're midyear (say, July), enter July forward and note "partial year" at the top. Next January you'll have a clean 12-month baseline to build your budget from.

Can I use accounting software instead of a spreadsheet?

Yes—QuickBooks, Wave, and FreshBooks all generate year-at-a-glance reports by category. The trade-off: monthly subscription cost, learning curve, and overkill features if you're a single-property owner. A spreadsheet is free, portable, and you control the layout. Landlords with four or more units often graduate to accounting software; owner-occupants and one- or two-unit landlords rarely need it.

What if I share the home with a co-owner or spouse?

Add an Entered By column and agree on a weekly hand-off: one person enters Monday–Wednesday expenses, the other Thursday–Sunday. Alternatively, use Google Sheets with edit access for both parties and a comment thread to resolve duplicate entries. Mark personal vs. shared expenses clearly—"personal" might mean one owner's home-office renovation that won't be split, while "shared" covers joint costs like property tax and insurance.

This is educational information, not tax or financial advice. Talk to a CPA about which home expenses are deductible for your situation, especially if you rent part of your property or claim a home-office deduction.