What is the best way to track unpaid customer invoices?
The best way to track unpaid customer invoices starts before you even send the invoice. Invoice timing, clear payment terms, and a systematic approach to following up make the difference between healthy cash flow and constantly chasing money.
Invoice promptly. Send invoices as soon as the work is complete or the product ships. Every day you wait is another day before the payment clock starts. If you finish a job on Friday but don’t invoice until the following Wednesday, you’ve already lost five days. Project-based work should be invoiced immediately upon completion. Recurring services can go out on a set schedule, but don’t let invoices pile up.
Set clear payment terms and put them on every invoice. Net 30 is standard, but Net 15 or due upon receipt works for many small businesses. Whatever terms you choose, state them explicitly so there’s no confusion about when payment is expected. Some businesses offer early payment discounts like 2% off if paid within 10 days. That can accelerate collections if cash flow timing matters more than the small discount.
For larger jobs, collect deposits upfront. Requiring 25% to 50% before starting work reduces your exposure if a customer doesn’t pay the final invoice. It also improves your cash position during the project. This is common practice for contractors, consultants, and anyone doing custom work.
Run aging reports weekly. An aging report groups every unpaid invoice by how long it’s been outstanding: current, 1-30 days, 31-60 days, 61-90 days, and over 90 days. This is your primary tool for seeing who owes what and how old the balance is. QuickBooks generates these automatically, but the report only helps if you actually look at it regularly. Weekly review catches problems before invoices slip into the 60 or 90 day buckets where collection gets harder.
Follow up consistently. Send a reminder when an invoice hits 30 days overdue. Call at 45 days. Escalate at 60. Whatever your process is, stick to it every time. Most late payments happen because the invoice got lost, someone forgot, or it’s sitting in an approval queue. A polite reminder usually resolves it. The businesses that struggle with collections are the ones without a system for following up.
Match payments to specific invoices. This is where many business owners go wrong. When a customer payment hits your bank account, don’t just record it as a deposit. Apply it to the invoice it’s paying. Otherwise your books show revenue coming in but your aging report still shows the invoice as unpaid. You end up with inaccurate AR balances and might send collection reminders for invoices that were already paid.
In QuickBooks, this means using the Receive Payment function instead of just recording a bank deposit. The receive payment screen lets you select which outstanding invoices the payment covers. If a customer pays multiple invoices with one check, apply portions to each. If they short-pay, apply a partial payment and leave the remainder open. This keeps your aging report accurate and your records clean.
For businesses dealing with ongoing customer invoices, proper invoicing and payment tracking is worth the investment. Spreadsheets work until you have more than 20 or 30 active invoices. Beyond that, the complexity of tracking who owes what becomes a job in itself.
The businesses that collect fastest invoice promptly, make terms obvious, review aging reports weekly, and follow up consistently. If you need help setting up a system that tracks receivables properly, our small business bookkeeping and tax services in The Woodlands can get your AR organized and keep it that way.
Greater Houston's Small Business Bookkeeping Partner
The Next Step:
A Quick Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How should pest control companies track prepaid service agreements?
Prepaid service agreements create deferred revenue that you recognize as income only when services are performed. Track each contract separately with service dates, and record revenue monthly as technicians complete scheduled visits.
Read answerHow should real estate lessors track rent, deposits, repairs and improvements?
Track everything by individual property so you can see profitability per address. Security deposits are liabilities until forfeited. Repairs are deductible immediately while capital improvements must be depreciated over time.
Read answerHow should a Houston bar separate food, beer, wine and liquor sales in bookkeeping?
Create separate income accounts for each category because Texas taxes them differently. Mixed drinks and wine by the drink face both 8.25% mixed beverage sales tax and 6.7% gross receipts tax, while beer and food follow standard sales tax rules.
Read answerHow should retail shops track inventory and cost of goods sold?
Proper retail inventory tracking starts with recording every purchase at cost, then adjusting for customer returns, vendor credits, and shrinkage. Regular physical counts verify your numbers and catch problems before they compound.
Read answerHow should small manufacturers track deposits, progress billing and inventory purchases?
Record deposits as deferred revenue until the product ships. Match progress billing to work completed, track materials in inventory until delivery, and use purchase orders to see committed costs before invoices arrive.
Read answerWhat bookkeeping setup helps an auto shop see profit by service type?
Auto shop bookkeeping needs to separate labor from parts revenue, categorize by service type, and track parts cost alongside selling price. This setup shows which repairs actually make money versus which ones just keep technicians busy.
Read answer