How do I track tenant payments and late fees?
The simplest approach is treating each property or unit as a separate customer in your accounting software. QuickBooks and similar programs let you create invoices for recurring rent charges. When rent is due on the first, the invoice goes out or gets generated automatically. When the tenant pays, you apply the payment against that invoice. At any moment you can pull up a customer balance and see exactly what each tenant owes.
Late fees require a consistent policy and consistent tracking. Define your grace period and late fee amount in your lease, then apply it the same way every time. After the grace period ends, add the late fee as a separate line item or charge to that tenant’s account. This keeps your records showing exactly what’s owed rather than relying on memory or spreadsheet notes.
Record late fees as income when you charge them, not when you collect them if you use accrual accounting. For cash basis, you would record the income when received. Either way, late fees should go to a separate income account so you can see how much you collect in penalties versus actual rent. This also matters for tax purposes since late fees are taxable income.
Partial payments create confusion without a system. When a tenant pays $800 on a $1,200 balance that includes late fees, you need a clear allocation method. Most landlords apply payments to the oldest charges first. Your accounting software should let you apply payments to specific invoices or charges. Document your allocation method and stick with it.
Bank reconciliation catches errors you would otherwise miss. When you reconcile your property bank account, every deposit should match a recorded payment in your books. Unmatched deposits mean money came in that you have not tracked to a tenant. This happens more often than expected when tenants pay through Venmo or Zelle and the payment never gets recorded properly.
Security deposits are not income. They sit as a liability on your books until you return them or apply them to damages. Keep a separate liability account for deposits held and do not mix this tracking with rent payment tracking.
Property management accounting requires attention to these details because messy records make it hard to know your true cash flow and create problems when tax season arrives. For landlords managing multiple properties, the setup work matters. A clean chart of accounts with each property as a class or location lets you run reports showing income and expenses by property. You will quickly see which properties collect rent on time and which have chronic late payers.
Property management software like Buildium or AppFolio handles tenant payment tracking automatically and often includes tenant portals for online payments. But if you only have a few units, QuickBooks works fine with proper setup from bookkeeping services in Santa Fe NM. The key is recording transactions as they happen rather than trying to reconstruct everything at year end.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I track rental income and expenses by property?
Use classes or locations in QuickBooks to assign every transaction to a specific property. This gives you profit and loss statements by property so you can see which rentals actually make money and have clean records for Schedule E at tax time.
Read answerDo I need a bookkeeper who understands construction accounting?
If you're running multiple projects, using subcontractors, or billing based on milestones, then yes. A general bookkeeper will produce books that are technically accurate but won't show you which jobs actually make money.
Read answerHow do I handle payroll taxes in New Mexico?
Register with the IRS for an EIN and with New Mexico agencies for withholding and unemployment. You'll withhold federal and state income taxes plus FICA, then file and deposit on schedule.
Read answerCan a bookkeeper fix years of disorganized records?
Yes, a skilled bookkeeper can reconstruct and organize financial records going back several years. Bank statements provide the foundation, and missing documentation can usually be worked around. The longer you wait, the harder it becomes.
Read answerHow do I track maintenance and repair costs by truck?
Use classes, tags, or locations in your accounting software to assign each maintenance expense to a specific truck. Capture the truck number, mileage, and repair type for every expense so you can run reports showing total costs per vehicle.
Read answerHow do I categorize rental property expenses for taxes?
Rental property expenses fall into specific categories on Schedule E. The main ones are mortgage interest, property taxes, insurance, repairs, and professional services. Getting the repair versus improvement distinction right matters most.
Read answer
