How do I keep track of unpaid customer invoices?
The accounts receivable aging report is your main tracking tool. In QuickBooks or any accounting software, this report lists every unpaid invoice and sorts them by how long they’ve been outstanding. You can see at a glance who owes you money and whether that money is getting harder to collect.
The standard aging buckets are current, 1-30 days past due, 31-60 days, 61-90 days, and over 90 days. Current invoices aren’t late yet. Anything past 30 days needs attention. Past 60 days is a problem. Past 90 days means you’re probably not getting paid without serious effort. The buckets help you prioritize. You don’t chase everything at once. You focus on the aging invoices that are sliding toward uncollectable.
Pull this report weekly. Once a week, review who has fallen into older buckets since last time. This takes five minutes if you stay on top of it. Skip it for a month and you’re surprised by $4,000 sitting in the 90+ column that you forgot about.
Build a follow-up routine based on aging. Send a friendly reminder at 7 days past due. Something simple works: “Just a reminder that invoice #123 is due. Let me know if you have questions.” At 30 days, be more direct: “This invoice is now 30 days past due. Please remit payment by [date].” At 60 days, pick up the phone. At 90 days, decide whether to pursue collections or write it off.
Preventing late payments is easier than chasing them. Invoice immediately after completing work while the value is fresh in your client’s mind. Put payment terms on every invoice and state them clearly during onboarding. Offer online payment options because checks in the mail take longer and give customers an excuse.
If tracking and follow-up take more time than you have, consider outsourcing your invoicing to someone who can handle payment tracking consistently. A dedicated AR process means invoices go out promptly, aging reports get reviewed, and follow-ups happen on schedule.
The businesses that struggle with cash flow often aren’t doing bad work. They’re just not watching what’s owed to them. Good small business bookkeeping on Long Island includes keeping AR current so you’re not funding your clients’ operations with unpaid invoices.
Long Island's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you need. We'll ask a few questions and give you a straightforward quote.
More Questions
How do I connect my bank to QuickBooks Online the right way?
Connect your bank through the Banking menu, then create categorization rules for recurring transactions. The real work is reviewing transactions before accepting them and reconciling to your statement monthly.
Read answerAre security or guard services taxable in New York?
Yes. New York State imposes sales tax on protective and detective services, including security guards, alarm monitoring, and private investigations. Security businesses on Long Island must collect sales tax from customers and remit it to the state.
Read answerDo gyms charge sales tax on memberships in New York?
Long Island gyms generally do not charge sales tax on membership dues, classes, or personal training sessions. New York City is the exception where these services are taxable.
Read answerDo graphic designers or marketing agencies charge sales tax in New York?
Most graphic design and advertising services are not subject to sales tax in New York. However, selling tangible items like printed materials or prewritten software is taxable. The key is whether you're delivering a service or a physical product.
Read answerDo I charge different sales tax for customers in different parts of Long Island?
Yes. New York is destination-based, so you charge the rate where your customer is located. Nassau County's rate is 8.625% and Suffolk County's is 8.75%.
Read answerHow do I handle client reimbursements and pass-through expenses in my books?
Record pass-through expenses separately from your operating costs and track reimbursements as offsets rather than income. This keeps your actual revenue and margins accurate instead of inflated by money that just passes through your hands.
Read answer