How to track which pool customers owe you money

Last updated July 30, 2026

Track it with an aging report: one row per customer showing what they owe and how many days past due it is, split into current, 1-30, 31-60, 61-90, and 90-plus. Sort by the oldest bucket, work that list weekly, and the pattern of who actually pays late becomes obvious fast.

You usually feel this before you can see it. The deposits are lighter than the route should produce, and you have a vague sense that three or four people are behind without knowing which ones. Most operators hit that wall somewhere between 40 and 60 accounts, right about where remembering who paid stops working.

What you need first is not a collections script. It is a list: one row per customer, what they owe, and how long it has been sitting there. Every other decision - send a reminder, make a phone call, hold the next visit, write it off - gets made off that list, and made badly without it.

Key takeaways

  • Pull an accounts receivable aging report before you chase anyone - you cannot collect from a feeling that some people are behind.
  • Read it oldest bucket first: a balance loses collectability every month it ages, so a small old debt outranks a large fresh one.
  • Treat the current bucket as float, not debt. On a healthy route most of your outstanding balance lives there and needs nothing.
  • Give each bucket one fixed move: reminder at 1-30, phone call at 31-60, service-hold conversation at 61-90, write-off or collections decision at 90-plus.
  • Check commercial and HOA rows against their own payment terms - a net-30 account at 35 days is behaving exactly as agreed.
  • Run the pass weekly and log every contact on the customer record, so the same conversation never has to happen twice.
  • Put the route on autopay if you want the list to get shorter rather than better managed.

How do I track which pool customers owe me money?

You track it with an accounts receivable aging report. Strip the accounting language and it is a simple thing: every unpaid invoice, grouped by customer, sorted by how overdue it is. The report answers two questions at once - who owes you, and how worried you should be - because a $400 balance invoiced last week and a $400 balance from March are completely different problems wearing the same number.

The standard split is five buckets: current, 1-30 days past due, 31-60, 61-90, and 90-plus. Current is not a problem at all, it is just float - work you have billed that has not hit its due date yet. On a healthy route, most of your outstanding balance sits there. Everything to the right of current is the actual list.

The report is one screen, not a spreadsheet exercise. Any decent pool service billing and payment tracking will build it for you as of any date you pick; PoolBoss shows those same five bands with a row per customer and a CSV export if your bookkeeper wants a copy. What matters is that you can pull it in ten seconds, because a report you have to assemble by hand is a report you will look at twice a year.

What each aging bucket usually means on a pool route
BucketHow overdueWhat it usually turns out to be
CurrentNot yet dueNormal float - most of a healthy route's balance
1-30 daysUp to a month lateA missed email, or a card that needs re-entering
31-60 daysOne to two months lateA genuine slow payer, or net-30 terms working as written
61-90 daysTwo to three months lateThe account you have quietly stopped thinking about
90+ daysOver three months lateA dead card, a move-out, or someone who is not going to pay

Each bucket should trigger a different move

The value of the buckets is that they turn a pile of money into a set of decisions, and each decision gets one degree firmer than the last. Run it the same way every time and you stop relitigating each account on its own merits.

At 1-30 days, send a reminder with a payment link and nothing else - most of this bucket is an email that got buried, not a customer with a problem. At 31-60, pick up the phone; a two-minute call resolves what four more emails will not. At 61-90, have the service-hold conversation, because you are now carrying two months of unpaid work on an account that has told you something. At 90-plus, it is a decision, not a chase: write it off, or send it to collections. What to do once you know who is behind is its own playbook, with the reminder wording and the day-7 / day-14 / day-30 escalation timeline; the aging report is what tells you which accounts to point it at.

Age matters more than amount, which is the part that feels wrong at first. Collection-industry figures have long put recovery at roughly 90% on balances under 30 days past due and closer to 70% once one passes 90 days. The exact percentages move around by study and by industry, but the direction never does: the same dollar gets harder to collect every month you leave it. Working a $180 balance that is 80 days old beats working a $600 balance that is 10 days old, every time.

Residential and commercial accounts age differently, and treating them the same costs you

A residential customer on a card and an HOA on net-30 terms will sit in the same bucket for completely different reasons, and the same reminder sent to both makes you look like you cannot read your own paperwork. Residential balances go past due because something broke - a card expired, an email bounced, a house sold. Commercial balances go past due because that is what the terms say: a property manager who pays on net-30 after a board meeting is not late at 35 days, they are early.

Here is what that looks like in practice. An operator running 140 pools across North Phoenix and Scottsdale bills about $18,900 a month. The first time she pulls an aging report, $2,300 is outstanding and it lands like bad news. It is not. Only $310 sits in 1-30, which is ordinary float. The rest is four accounts: one HOA at $1,450 in the 31-60 bucket on net-30 terms - slow by design, not late - and three residential accounts totaling $540 in 90-plus, all with cards that died when their bank re-issued in February. The $2,300 problem was one terms mismatch and three dead cards, and it took an afternoon.

The fix is to read commercial rows against their own terms rather than the calendar. Note the terms on the account, and treat the clock as starting when their approval cycle ends. How commercial and HOA terms change the timeline covers the billing setup that keeps those accounts from looking delinquent in a report that does not know any better.

The weekly 15 minutes that keeps receivables from compounding

Receivables compound in one direction only, so the whole discipline is frequency, not effort. Fifteen minutes on the same day every week beats a three-hour reckoning every quarter, because at a weekly cadence nothing has time to reach 90 days without you having already spoken to someone about it.

The routine is four steps and it does not change. Pull the report. Read right to left, oldest bucket first, so the money that is hardest to collect gets your attention while you still have any. Take the action the bucket calls for - reminder, call, hold, decision - and stop at the current column, which needs nothing. Then log what you did and what they said, on the customer record, in a sentence. That last step is the one people skip, and it is the reason the same conversation gets had three times.

In PoolBoss the weekly pass has a shortcut: the invoice list has an overdue filter that shows every sent invoice past its due date, so you can work straight down it and send reminders without leaving the screen. Fifteen minutes covers a 140-pool route comfortably. If it is taking an hour, the problem is not the report - it is that too much of the route is paying by check.

Autopay is the only structural fix

Everything above manages receivables. Only one thing shrinks them: getting a card on file so payment happens without anybody deciding to do it. A route billing by check or by invoice-and-wait will always carry a real aging report, because you have made every customer take an action every month, and some percentage of them will not. Move the route onto autopay and most of the list stops existing - what is left is the genuine problem accounts, which is exactly the list you wanted in the first place.

Autopay does not get you to zero, and expecting that is how operators stop trusting the report. Cards expire on a three-to-five-year cycle and banks re-issue in batches after a breach, so a handful of accounts will fail every year no matter how clean your setup is. The difference is scale: an aging report on an autopay route is four rows you can fix in an afternoon, not forty rows you avoid opening. Card processing runs roughly 2.5-3.5% per transaction, which is the honest cost of the trade, and it is a cheaper number than the one sitting in your 90-plus column.

Frequently asked questions

How long should I let a pool customer's balance go before I stop servicing?

Most operators stop at 30 days past due, and put that number in the service agreement before the first visit so it is never a surprise. The logic is simple: at 30 days you are carrying roughly a month of unpaid work, and every additional week you service adds to a balance that is already getting harder to collect. Warn before you stop - a note at two weeks past due saying service pauses on a specific date resolves a large share of them on its own. Whatever number you choose, apply it to everyone. The moment you make exceptions for the customers you like, you are running a credit business you never meant to start. Check your own agreement and state rules before suspending service on a signed contract.

Should I charge a late fee on an overdue pool service invoice?

You can, and a typical late fee runs 1.5% per month or a flat $15-$25, but it only works if it was written into the agreement the customer signed. A fee that appears for the first time on a past-due notice reads as retaliation and tends to cost you the account rather than collect the balance. The practical case for a late fee is not the revenue, which is small - it is that it gives your reminder a deadline with teeth. Many operators write the fee into the agreement, then waive it the first time as a goodwill gesture while making clear it applies from then on. Late-fee limits vary by state and by contract type, so confirm what yours allows before you set the number.

How do I handle a customer who pays some months and not others?

Move them to prepay or autopay and stop carrying them on credit. A partial payer is not a collections problem, it is a cash-flow mismatch, and reminders do not fix it because the customer is not confused - they are prioritizing. The conversation is short and not hostile: you have noticed the account runs behind some months, so going forward the card on file gets charged on the first, or the month gets paid before it is serviced. Most people take the first option. In the aging report a partial payer is easy to spot even before you notice the pattern, because their balance never leaves the 31-60 bucket - it just gets refilled with a different month's invoice every time an older one clears.

What do I do about a balance on a customer who already cancelled?

Send one clear final statement with the total, the visits behind it, and a payment link, then decide within about 30 days whether it is worth pursuing. A cancelled customer has nothing left to lose by ignoring you, so the leverage that works on an active account is gone. For most residential balances - typically one or two months of service - the honest math is that an hour of your time is worth more than the recovery odds, and a write-off is the right business decision rather than a defeat. Larger commercial balances are worth a formal demand letter or a collections referral. Either way, keep the service records and the invoice history: they are what makes the claim provable if you do pursue it.

How much of a pool route's revenue is normally outstanding at any time?

On a route billing monthly, expect roughly one month of revenue to be outstanding at any moment, most of it sitting in the current bucket as ordinary float. What matters is not the total but the shape: on a well-run route the large majority of that balance is current or 1-30, and the 90-plus column is close to empty. If more than about 10% of your outstanding balance has aged past 60 days, the problem is usually structural - too many accounts paying by check, no card on file, or terms nobody enforces - rather than a few bad customers. Compare the shape month to month rather than the dollar figure, which moves with the size of the route.

When is it worth sending a pool service account to collections?

Generally when the balance is over 90 days past due, larger than a few hundred dollars, and you have documented contact attempts. Collection agencies typically keep 25-50% of what they recover, so on a $200 residential balance you are trading most of the money and the relationship for a small net gain. On a $2,000 commercial balance the math changes completely. Before referring anything, gather the signed agreement, the invoices, the service records, and a log of the reminders you sent - agencies collect far more on documented claims, and it is the same evidence a small-claims filing needs. Collections practices are regulated, so use a licensed agency rather than escalating on your own.

Do I still send a service report to a customer who's behind on payment?

Yes. Withholding proof of work you already performed helps nobody and weakens your position if the balance is ever disputed - the service record is the thing that proves the invoice is legitimate. Keep sending the reports and let the past-due reminders run on their own track. There is a practical benefit too: a customer who sees a chemistry log and a completed visit every week is looking at exactly why they owe you money, which does more collecting than a third reminder ever will. The decision that matters is not whether to keep reporting, it is whether to keep servicing - and that one gets made on the aging report, at the threshold you set in advance.

Run your pool routes on PoolBoss

Join the waitlist and start when PoolBoss opens. Flat-rate pricing by pool count, every feature on every plan.