Share:

Debt Collections Review

Built 13 Nov 2026. The money figures come from Square (the Recurring locations, by login). Everything else comes from the debt portal (tpsgportal), read only, from go-live on 3 Nov to 12 Nov. The portal's collectors are Charles, Veronica, Emily and Maria.

1. Money: 1st–11th Nov compared with the same days in each of the last 12 months

Square, Recurring locations only. Automatic run = Square's own card-on-file charges, which go out around 9am every day including weekends and are credited to whichever login created the invoice (Natalia Accounting, Elena Medianik, the city logins), plus charges with no login. Collectors by hand = money a named collector actually took, with their automatic charges removed. Shared city logins = the city Collections, Accounting and Inquiries logins taking money by hand. Elena and Nick are not counted as collectors. The 12th is left out because it was still in progress.

$217kTotal, 1st–11th Nov (12-month average $242k, -10%)
$51.2kCollectors by hand (12-month average $42.9k, +19%)
$159kAutomatic run. 38% of its charges went through (892 of 2,361)
$6.6kShared city logins by hand, the lowest of the 13 months
1st–11th ofCollectors by handShared loginsAutomatic runTotalRun success
Nov 2025$10,804$70,124$144,699$225,62742%
Dec 2025$32,224$46,941$158,526$237,69143%
Jan 2026$25,006$43,554$169,224$237,78443%
Feb 2026$50,766$46,095$165,638$262,49941%
Mar 2026$46,276$94,697$123,153$264,12643%
Apr 2026$49,432$154,422$61,067$264,92158%
May 2026$50,263$135,366$70,057$255,68650%
Jun 2026$60,890$107,460$82,219$250,56948%
Jul 2026$52,141$92,573$94,035$238,74946%
Aug 2026$31,877$70,981$103,906$206,76445%
Sep 2026$60,428$60,199$113,789$234,41644%
Oct 2026$45,005$52,208$125,691$222,90444%
Nov 2026$51,226$6,565$159,263$217,05438%

The totals are what Square took. How they split between "shared logins" and "automatic run" before about March is approximate: back then the automatic run was credited to the city logins, and some of it ran outside the 9am window.

Each collector by hand, 1st–11th

CollectorNov 2026OctSepAugJulJunRead
Veronica$16,382$13,852$21,378$7,803$15,957$26,300Highest collector by hand
Charles$15,936$8,964$18,686$10,083$14,398$13,445Nearly double October
Maria$8,973$10,451$7,484$2,659--Started in August
Caet$6,711$6,328$5,404$5,010$6,183$6,502Steady. Not in the portal
Emily$3,084$3,590$4,814$4,855$7,995$6,731Down every month since July

2. What each day should bring, in 5-day blocks

Average per day in each block over August–October, compared with November so far. Square, all Recurring locations.

BlockExpected total per dayNov per dayExpected, collectors by handNov, collectorsExpected, automatic runNov, runShare of the month
1st–5th$22,527$21,234$4,709$4,489$11,794$16,007~14%
6th–10th$18,359$18,235$3,572$4,522$9,332$13,170~11%
11th–15th$29,117$17,718 (2 days so far)$4,667$4,639$17,301$12,664~18%
16th–20th$27,633-$4,903-$15,649-~17%
21st–25th$23,580-$4,589-$13,699-~15%
26th–31st$33,832-$6,187-$20,532-~25%

The money arrives unevenly across the month, so never split what's left of a month evenly across the remaining days. The last block, 26th–31st, is about a quarter of the month.

3. The four portal collectors: week of 9–12 Nov

CollectorAccounts heldAccounts workedCalls through the dialerTalk timeTextsNotesPromisesPayments loggedReplies answeredTypical reply timeNew misses untouched
Maria9021087454 min18511024 ($6,486)3 ($626)39 of 4139 min23
Charles1,6211100-87808 ($1,827)11 ($2,578)24 of 26~15 hrs77
Emily876915570 min679110 ($1,834)3 ($328)13 of 1636 min29
Veronica881871310 min921221 ($3,497)13 ($2,679)14 of 2276 min54
Good Bad Fixes: Charles and Veronica should dial through the portal so their calls are recorded. Charles's book should be split, moving about 500–600 accounts.

4. When the calls are made (Eastern time)

Calls logged per working day, by hour, 3–12 Nov. Charles worked 8 days, Maria 4, Veronica 4 and Emily 3.

CharlesMariaVeronicaEmily

Charles stops at 1pm (0.4 calls). Veronica makes no calls at 3pm and almost none at 9am. Emily barely calls at 9am or 2pm. Maria is busiest from 9 to 11am. Nobody calls before 9am or after 5pm, which is when people with day jobs can pick up.

5. People we rang or texted who had already paid

28 accounts were ticked "already paid" in the portal ($5,849), each checked against Square. Charles ticked 13, Veronica 9, Emily 3 and Maria 3.

What Square showsPeople$Detail
Genuinely paid before we contacted them7$1,582They paid 4 to 26 days earlier, typically about 9 days, and were still rung or texted 1 to 5 times after paying. 4 paid by card on file through the automatic run, 2 had a card keyed in by staff, and 1 paid by bank transfer. These accounts came into the portal on 3 Nov already marked as missed, so the payments were never linked.
The collector took the payment themselves, then ticked "already paid"13-Charles 7, Veronica 4, Maria 1, Emily 1. They charged the card in Square the same day, then logged it as "already paid" in the portal instead of as their own payment.
No matching payment in Square7$1,838Checked 35 days back for the same amount from the same person. Charles 4, Maria 2, Veronica 1. They either paid some other way, paid a different amount, or haven't paid.
Unclear1$60The only match is 9 Oct, which is probably last month's instalment.

6. People texted each day, by sequence step

DayAutomatic texts (people)Typed by a collector
2026-11-03Pre-due 5 days 632 · pre-due 1 day 351 · day-0 no card 87 · day-0 dead card 43 · missed 8 (go-live)24
2026-11-04Day-1 reminder 428 · missed 240
2026-11-05Day-2 reminder 412 · missed 15 · day-0 no card 323
2026-11-06Missed 19 · day-0 no card 13 · day-0 dead card 3 · day-1 325
2026-11-07Day-1 8 · day-0 no card 6 · day-2 21
2026-11-08One-off custom text 271 · day-2 7 · day-1 50
2026-11-09Missed 26 · day-2 5 · day-0 no card 325
2026-11-10Missed 33 · day-0 no card 4 · day-1 372
2026-11-11Day-0 no card 11 · day-0 dead card 5 · day-1 3 · day-2 2 · missed 090
2026-11-12Day-1 11 · day-0 no card 10 · day-0 dead card 4 · day-2 3 · missed 091

The "missed" text stopped after 10 Nov, even though 110 and 69 new first misses landed on the 11th and 12th. The pre-due reminders only ever ran on go-live day, and that's the batch that quoted past due dates. These counts only cover accounts the portal currently lists.

7. What made people reply

171 people replied, and each is counted once, by the text sent just before their first reply. Where a collector's typed text had a sequence text before it, the reply is credited to the sequence text (10 moved). Replies to old GHL messages copied into the portal are shown separately.

Text before the first replyPeople who repliedSent toReply rate
Day-2 reminder324317.4%
Day-0 no card on file91376.6%
Pre-due 5 days316324.9%
Pre-due 1 day133513.7%
One-off custom text, Sun 8 Nov92713.3%
Day-1 reminder124612.6%
Missed21031.9%
Day-0 dead card0590%
Typed by Maria / Veronica / Emily (no sequence text before)6 / 6 / 3--
Old GHL automation text (before the portal)41--
Old GHL message from a person (before the portal)7--

People reply fast: half within 19 minutes, and 112 of 171 within an hour.

8. What the 171 people said

One group per person, based on the most telling thing they said across all their messages. Grouped by matching words in the replies, so treat the small groups as rough.

What they saidPeopleSince paid
Will pay later and gave a date or time283
Card or bank problem208
Want out / no jobs or help193
Can't afford it right now182
Already paid146
"Ok" / "yes"111
Just "hi" or one word60
Stop texting51
Asking the balance51
Wrong number30
Angry / dispute30
Want a pay link32
"What's this payment for?"20
Busy / "call me"20
Didn't fit a group326
Total17133

9. People who replied and still got an automatic text

A reply doesn't stop the automatic texts. The portal has no record of pausing a sequence when someone replies.

10. The 15 whose first reply came after a collector's text, with no automatic text before it

All 15 got onto the list from a card payment that failed this month. There are two reasons none of them had an automatic text first.

RefCollectorMissedReasonWhy no automatic textCollector textedStatus
N4001325Emily2026-11-08card limitAgent not live102 hrs after the missopen
F4000010Maria2026-11-03card limitAgent not live9 days afteropen
F3750533Maria2026-11-03declinedAgent not live7 days afteropen
C4065880Emily2026-11-07card limit (2nd miss)Card-limit sequence101 hrs afteropen
F3988961Maria2026-11-11declinedCard-limit sequence6 hrs afteropen
M3988190Veronica2026-11-11card limit (2nd miss)Card-limit sequence5 hrs afteropen
M4042102Veronica2026-11-11card restriction (2nd miss)Card-limit sequence5 hrs afteropen
D3871127Veronica2026-11-11card limitCard-limit sequence8 hrs afteropen
H3903840Maria2026-11-11card limitCard-limit sequence5 hrs afteropen
D2923591Veronica2026-11-11insufficient fundsCard-limit sequence29 hrs afteropen
M3990130Maria2026-11-11card limitCard-limit sequence4 hrs afteropen
M3837047Maria2026-11-11declinedCard-limit sequence5 hrs afterpaid
P3846248Emily2026-11-10card limitCard-limit sequence8 hrs afterpaid
H2901724Veronica2026-11-10card limitCard-limit sequence7 hrs afterpaid
P4000243Veronica2026-11-10declinedCard-limit sequence7 hrs afterpaid

Across the whole book (4,159 open accounts)

11. Accounts now paid: which bucket they were in, and their card

123 accounts are paid. The portal doesn't record which queue an account was in before it paid, so the bucket is worked out from what happened on the account before the payment. Card type comes from the card's bank code (BIN) in Square: Chime is The Bancorp Bank or Stride Bank, and Cash App is Sutton Bank.

Bucket before payingPaid$Chime / Cash App
Handed over from GHL48$11,4396 of 47 (13%)
New miss (0–3 days)31$8,1173 of 22 (14%)
Ring now16$2,9342 of 15 (13%)
Other / imported11$2,3642 of 11 (18%)
Replied9$1,5870 of 9
Sequence running5$1,2730 of 5
Promised to pay3$6310 of 3

Card known for 112: Chime 8 + Cash App 5 = 11.6%, against 18% of financed sales, so app-bank cards pay well below their share. Bank debit 80 (71%), credit card 19 (17%).
How they paid: 80 paid themselves in Square, 31 were ticked "already paid" by an agent, 7 were GHL handoffs where Square shows the payment, and 5 were taken by an agent (keyed card, card on file or pay link).

How this was built

Portal data was read through its own API (book, account, events and messages), read only, with nothing sent or changed. Its message history includes old GHL messages copied in when accounts moved over, so anything before 3 Nov is GHL, not the portal. Square data comes from scripts/reports/collections_first_days.js (with --full for whole months), and its output was summarised by collections_blocks.js and collections_first_days_summary.js. The "already paid" checks used _oneoff_portal_vs_square.js. Card types come from lib/card_issuer.js.