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
What does full-service bookkeeping include for a small business?
Full-service bookkeeping includes transaction categorization, bank and credit card reconciliation, and monthly financial reports. Pricing typically starts at $199 per month and depends on your transaction volume.
Read answerDo Texas LLCs still need to file a franchise tax report if no tax is due?
Yes. Texas LLCs must file a No Tax Due Report by May 15 each year even when they owe nothing. Skipping this filing can result in forfeited good standing and penalties.
Read answerWhen does a Texas business need a sales tax permit?
You need a sales tax permit before making your first taxable sale in Texas. This applies if you sell physical goods or certain taxable services and have a physical presence in Texas, or if you're a remote seller with over $500,000 in Texas revenue.
Read answerWhat happens if my Texas sales tax filings do not match my POS reports?
The Texas Comptroller can flag discrepancies between your sales tax returns and POS data, bank deposits, or marketplace reports. Mismatches may result in notices requesting explanation or audits that lead to penalties and back taxes.
Read answerWhat should a contractor include on invoices for progress billing?
Progress billing invoices should include the original contract amount, approved change orders, completion status, previous billings, deposits applied, and retainage held. This clarity prevents confusion between revenue earned and cash collected while reducing client disputes.
Read answerWhat chart of accounts should I use for a small business in QuickBooks Online?
Your chart of accounts should mirror how your business makes and spends money. Start with QuickBooks Online's default and customize it to track your actual income streams, direct costs, payroll expenses, owner equity, and taxes without creating so many categories that your reports become unusable.
Read answer