How to Track Unpaid Invoices Without Accounting Software (2026)

How to track unpaid invoices without accounting software (2026)

Small teams search for a free tool to track unpaid invoices when QuickBooks feels too heavy but spreadsheets are already lying to them. You need one source of truth: who owes what, due date, last reminder sent, and promise-to-pay notes — without double-entry bookkeeping for a five-invoice month.

The SBA cash flow guidance for small businesses stresses the timing of receivables — collections discipline often does more for a tight cash month than landing a new client (SBA Finance). This guide covers AR hygiene, reminder cadence, escalation steps, partial payment handling, and how LaunchGPT Invoices fits creation and follow-up without a full general ledger setup.

Quick answer: what is the best free way to track unpaid invoices?

For teams sending fewer than 20 invoices a month, a dedicated invoicing tool with an AR dashboard is the most practical option. It eliminates the manual version-control problems of spreadsheets and keeps invoice status, reminders, and payment records in one place. For very small operations (under 5 invoices per month), a disciplined Google Sheet works if the columns are right and it is reviewed every Monday without exception.

The tool matters less than the habit. Unpaid invoices go unaddressed because nobody owns the collections cadence — not because the tracker is wrong.

Minimum viable receivables tracker

Every AR tracking system, whether a tool or a spreadsheet, needs these columns:

Missing any of these creates gaps: you send a reminder to someone who already paid, or you discover an invoice is 60 days past due because nobody noted the last touch date.

Reminder cadence: firm but not spammy

The reminder three days before the due date is the most effective and most underused step. Most freelancers and agencies only send reminders after payment is overdue. A pre-due reminder reduces late payments significantly because it catches simple cases where the invoice was filed and not yet approved.

Keep reminder language professional and short. Attach the PDF every time — AP teams often lose the original email. Include the invoice number, amount, due date, and payment instructions in the body of every reminder.

Spreadsheet vs lightweight invoicing app

How to set up a Google Sheet AR tracker in 15 minutes

If you are starting from scratch with a spreadsheet, here is a workable structure:

1. Open Google Sheets, create a tab called "Open Invoices."
2. Add columns: Invoice #, Client, Amount, Currency, Issue Date, Due Date, Status, Last Reminder, Notes.
3. Add a second tab called "Paid" — move invoices here when cleared.
4. Set conditional formatting: red for due dates more than 7 days past, yellow for 1–7 days past.
5. Add a recurring Monday calendar event: "AR review — 15 minutes."
6. Review every Monday: update statuses, send reminders for anything due in 5 days or overdue.

This setup costs nothing and works until invoice volume or collection complexity outgrows manual tracking. The key is the Monday review — without it, the sheet becomes stale and useless within a month.

Handling disputed invoices

Disputes are the hardest AR situation because collections must pause while the disagreement is resolved. When a client disputes an invoice:

1. Acknowledge in writing the same day.
2. Note the disputed lines separately in your tracker.
3. Freeze reminder automation or manual chasing on those lines.
4. Document the resolution conversation and send a written confirmation of whatever is agreed.
5. Reissue or credit-note as needed and restart the standard payment cycle.

Never send aggressive collection reminders while a genuine dispute is open. It damages the relationship and your position if the dispute goes legal.

Partial payments

Partial payments require careful tracking. When a client pays part of an invoice:

• Record the payment date and amount immediately.
• Note which invoice it applies to — never assume.
• Update the outstanding balance in your tracker.
• Send a receipt for the partial payment.
• Continue reminders on the remaining balance with the updated amount.

A common error is treating a partial payment as a closed invoice and stopping follow-up. Check your bank statement against tracker status weekly.

When to escalate beyond reminders

If an invoice reaches 45–60 days past due without resolution, escalation options include:

• Internal escalation: Ask a senior contact at the client company — not just the AP contact.
• Pause or hold on work: If your contract allows it, pause deliverables for outstanding payment.
• Late fees: If your contract includes late fees, apply them and note in writing.
• Collections agency: Takes a percentage (typically 15–30%) but frees your time.
• Legal demand letter: Often resolves disputes before any legal proceeding.
• Small claims court: Applicable for amounts within your jurisdiction's threshold without needing an attorney.

Get legal advice before escalating to a formal demand or litigation. The cost-benefit depends on the invoice amount, your relationship with the client, and whether you want to continue working with them.

Use LaunchGPT for invoices and follow-through

Create invoices at Invoices and centralize status in your LaunchGPT workspace instead of managing orphan PDFs scattered across email threads. Pair with Free invoice generator online for quick one-off invoice creation and Create invoice with AI for faster recurring drafts. Upgrade paths live on Invoices pricing when volume, automation, or team size grows.

Open Invoices

Reducing late payments before they happen

The best collections process is one you rarely need. These habits reduce late payments at the source:

Require deposits on new clients. A 25–50% upfront payment on new engagements reduces late payment risk and filters out clients who are not serious. Frame it as standard policy, not a trust issue.

Send invoices immediately on project completion. Every day you delay sending is a day added to the payment cycle. Automate or calendar this step.

Confirm AP contact before starting work. Ask the client on day one: "Who receives invoices and what email and format do you need?" This prevents the "wrong email" excuse on day 45.

Include payment terms prominently. Put the due date in the email subject, the first line of the invoice, and the PDF footer. Do not bury it.

Use clean invoice formats. Garbled PDFs, missing information, or unusual file formats create AP friction. Use professional templates every time.

Follow up before the due date. The T-3 reminder is your most effective collections tool because it prevents late payments instead of chasing them.

AR aging buckets: how to prioritize follow-up

Not all overdue invoices deserve the same urgency. Organize your open invoices by aging bucket and prioritize accordingly:

• 0–30 days overdue: Polite reminders, confirm receipt. Most resolve here.
• 31–60 days overdue: Direct contact with AP and client champion. Document every communication.
• 61–90 days overdue: Escalate to senior contact. Reference contract payment terms. Consider pause-of-work clause.
• 90+ days overdue: Legal review, formal demand, or collections decision.

Prioritize your largest open invoices within each aging bucket — a 90-day $10,000 invoice deserves more energy than a 45-day $200 one.

Setting clear payment terms from the start

Most late payment problems start before the invoice is sent — in the contract or agreement that was never clear on terms. Standard payment terms to define upfront:

• Payment due date: Net 15, Net 30, or specific calendar date — avoid ambiguity.
• Accepted payment methods: Bank transfer, ACH, PayPal, credit card, or check.
• Late fee policy: Percentage per month or flat fee — must be in writing before late payment occurs.
• Deposit requirements: Percentage upfront for new clients or large projects.
• Dispute resolution: How disputed invoices are handled before escalation.

Embedding these in every contract and repeating them on every invoice prevents the "I didn't know the terms" conversation at day 45.

Building a cash flow forecast from your AR tracker

Your unpaid invoice tracker is the input for a simple cash flow forecast. Add a column for "expected payment week" based on due date and client payment history. Sum by week and compare against known expenses. This gives you a 4–6 week cash visibility window without a full accounting system.

Update the expected payment column when clients promise a date or pay partially. Over time you build a pattern for which clients reliably pay on time and which consistently pay 15–30 days late — useful context for pricing retainers or requiring upfront deposits.

FAQ

FAQ

Conclusion: visibility beats optimism

The best free tool to track unpaid invoices is the one you actually review every week. Start with LaunchGPT Invoices, keep notes per customer, run the reminder cadence without exception, and review aging every Monday — not only when rent is due.

Create an invoice

Related: Free invoice generator online · Free invoice software for freelancers · Discover