Backfill payment allocations — DRY RUN (set COMMIT=1 to write) ============================================================================================================== STEP 1 — allocations from the existing links PAYMENT STMT SUPPLIER PAY AMT ALLOCATE FROM NOTE => 0 allocation(s) from links STEP 2 — proposed matches for unallocated payments (same group, amount = statement balance +/-0.01, paid 0-45 days after the statement) PROPOSED (one statement <-> one payment or pair; these are what COMMIT writes) PAYMENT(S) STATEMENT SUPPLIER STMT DATE AMOUNT PAID (days after) #231 #51 APLUS 2026-07-01 3,461.34 2026-07-24 (23d) AMBIGUOUS (more than one fit; not forced — pick with Allocate on the Payments page) statement #86 PARTSBOX 2026-04-17 $12,643.83 <- #202 + #215 | #202 + #216 statement #87 PARTSBOX 2026-04-17 $10,750.35 <- #205 + #215 | #205 + #216 UNMATCHED payments (no statement fits) PAYMENT SUPPLIER DATE AMOUNT FREE REF / NOTES 40 PAMS 2026-01-28 14,845.00 14,845.00 Historical PAMS payment batch (from B2B portal) 41 PAMS 2026-02-10 6,270.00 6,270.00 Historical PAMS payment batch (from B2B portal) 42 PAMS 2026-02-12 6,412.00 6,412.00 Historical PAMS payment batch (from B2B portal) 43 PAMS 2026-02-20 12,738.00 12,738.00 Historical PAMS payment batch (from B2B portal) 333 PARTSBOX 2026-02-24 2,559.03 2,559.03 [load_plan_2026_11] QuickBooks bank date. Locatio… 44 PAMS 2026-03-05 18,964.00 18,964.00 Historical PAMS payment batch (from B2B portal) 334 PARTSBOX 2026-03-06 9,067.28 9,067.28 [load_plan_2026_11] QuickBooks bank date. Locatio… 45 PAMS 2026-03-18 16,482.00 16,482.00 Historical PAMS payment batch (from B2B portal) 46 PAMS 2026-03-24 19,406.00 19,406.00 Historical PAMS payment batch (from B2B portal) 47 PAMS 2026-04-01 9,150.00 9,150.00 Historical PAMS payment batch (from B2B portal) 198 PARTSBOX 2026-04-07 6,728.07 6,728.07 Historical PartsBox payment batch (Belton) 199 PARTSBOX 2026-04-07 6,750.90 6,750.90 Historical PartsBox payment batch (Anderson) 200 PARTSBOX 2026-04-07 6,412.86 6,412.86 Historical PartsBox payment batch (Venice) 201 PARTSBOX 2026-04-07 8,763.88 8,763.88 Historical PartsBox payment batch (Englewood) 48 PAMS 2026-04-08 22,016.00 22,016.00 Historical PAMS payment batch (from B2B portal) 49 PAMS 2026-04-14 12,779.00 12,779.00 Historical PAMS payment batch (from B2B portal) 203 PARTSBOX 2026-04-17 8,052.74 8,052.74 Historical PartsBox payment batch (Anderson) 204 PARTSBOX 2026-04-17 6,795.84 6,795.84 Historical PartsBox payment batch (Venice) 206 PARTSBOX 2026-04-27 9,622.05 9,622.05 Historical PartsBox payment batch (Belton) 207 PARTSBOX 2026-04-27 9,666.79 9,666.79 Historical PartsBox payment batch (Anderson) 208 PARTSBOX 2026-04-27 3,560.42 3,560.42 Historical PartsBox payment batch (Venice) 209 PARTSBOX 2026-04-27 4,052.97 4,052.97 Historical PartsBox payment batch (Englewood) 210 PARTSBOX 2026-05-18 12,600.00 12,600.00 Historical PartsBox payment batch (Belton) 211 PARTSBOX 2026-05-18 3,000.00 3,000.00 Historical PartsBox payment batch (Anderson) 212 PARTSBOX 2026-05-18 4,000.00 4,000.00 Historical PartsBox payment batch (Venice) 213 PARTSBOX 2026-05-18 3,500.00 3,500.00 Historical PartsBox payment batch (Englewood) 50 PAMS 2026-05-26 17,540.00 17,540.00 Historical PAMS payment batch (from B2B portal) [… 214 PARTSBOX 2026-05-27 11,500.00 11,500.00 Historical PartsBox payment batch (Belton) 217 PARTSBOX 2026-05-27 7,000.00 7,000.00 Historical PartsBox payment batch (Englewood) 218 PARTSBOX 2026-06-09 8,000.00 8,000.00 Historical PartsBox payment batch (Belton) 219 PARTSBOX 2026-06-09 8,500.00 8,500.00 Historical PartsBox payment batch (Anderson) 220 PARTSBOX 2026-06-09 2,000.00 2,000.00 Historical PartsBox payment batch (Venice) 221 PARTSBOX 2026-06-09 4,000.00 4,000.00 Historical PartsBox payment batch (Englewood) 51 PAMS 2026-06-12 8,856.00 8,856.00 Historical PAMS payment batch (from B2B portal) [… 222 PARTSBOX 2026-06-17 6,000.00 6,000.00 Historical PartsBox payment batch (Belton) 223 PARTSBOX 2026-06-17 5,000.00 5,000.00 Historical PartsBox payment batch (Anderson) 224 PARTSBOX 2026-06-17 5,000.00 5,000.00 Historical PartsBox payment batch (Venice) 225 PARTSBOX 2026-06-17 7,000.00 7,000.00 Historical PartsBox payment batch (Englewood) 332 MARTINS 2026-06-23 1,230.00 1,230.00 [load_plan_2026_11] QuickBooks bank date; Martin'… 319 OEMGARAGE 2026-07-01 9,097.97 9,097.97 QB FL# XXXXX002922 [load_missing_payments_2026_10… 249 PARTSBOX 2026-07-07 10,000.00 10,000.00 PARTSBOX BELTON Partsbox Belton - July payment 250 PARTSBOX 2026-07-07 6,500.00 6,500.00 PARTSBOX Anderson 251 PARTSBOX 2026-07-07 6,500.00 6,500.00 PARTSBOX VENICE 252 PARTSBOX 2026-07-07 6,500.00 6,500.00 PARTSBOX ENGLEWOOD 226 PAMS 2026-07-08 24,771.00 24,771.00 Recorded from the PAMS statement PAYMENT row; was… 316 MARTINS 2026-07-09 4,285.00 4,285.00 QB FL# XXXXX001382 [load_missing_payments_2026_10… 317 MARTINS 2026-07-20 1,450.00 1,450.00 QB FL# XXXXX001757 [load_missing_payments_2026_10… 261 PARTSBOX 2026-07-22 8,400.00 8,400.00 784290403 Belton 262 PARTSBOX 2026-07-22 6,000.00 6,000.00 784290416 Anderson 263 PARTSBOX 2026-07-22 7,300.00 7,300.00 784290440 Venice 264 PARTSBOX 2026-07-22 4,500.00 4,500.00 784290450 Englewood 321 PEACHSTATE 2026-07-22 1,685.00 1,685.00 QB FL# XXXXX002091 [load_missing_payments_2026_10… 236 PAMS 2026-08-04 16,334.00 16,334.00 Aug 2026 payment run From AR's August payment sch… 239 PARTSBOX 2026-08-11 12,000.00 12,000.00 Aug 2026 payment run From AR's August payment sch… 240 PARTSBOX 2026-08-11 7,000.00 7,000.00 Aug 2026 payment run From AR's August payment sch… 241 PARTSBOX 2026-08-11 9,000.00 9,000.00 Aug 2026 payment run From AR's August payment sch… 242 PARTSBOX 2026-08-11 3,000.00 3,000.00 Aug 2026 payment run From AR's August payment sch… 247 PEACHSTATE 2026-08-18 2,765.00 2,765.00 Aug 2026 payment run From AR's August payment sch… 322 RSTROUD 2026-08-21 2,000.00 2,000.00 QB FL# XXXXX001400 [load_missing_payments_2026_10… 309 BANDR 2026-08-28 19,439.97 19,439.97 QB FL# XXXXX000566 [load_missing_payments_2026_10… 254 OEMGARAGE 2026-09-10 10,934.00 0.50 828398266 295 PARTSBOX 2026-09-11 13,000.00 13,000.00 BELTON 296 PARTSBOX 2026-09-11 10,000.00 10,000.00 ANDERSON 297 PARTSBOX 2026-09-11 6,000.00 6,000.00 VENICE 298 PARTSBOX 2026-09-11 6,000.00 6,000.00 ENGLEWOOD 259 PAMS 2026-09-14 17,002.00 17,002.00 827919173 273 HOLBROOK 2026-09-18 4,027.50 4,027.50 829869069 August 2026 statement 314 JOHNSTRUCK 2026-09-25 1,003.05 1,003.05 QB FL# XXXXX001942 [load_missing_payments_2026_10… 320 PAMS 2026-09-30 1,295.00 1,295.00 QB FL# XXXXX002861 [load_missing_payments_2026_10… 331 CJAUTO 2026-09-30 3,200.00 3,200.00 [load_plan_2026_11] QuickBooks bank date; CJ prin… 299 PARTSBOX 2026-10-02 8,000.00 8,000.00 BELTON 300 PARTSBOX 2026-10-02 5,000.00 5,000.00 ANDERSON 301 PARTSBOX 2026-10-02 5,000.00 5,000.00 VENICE 302 PARTSBOX 2026-10-02 8,000.00 8,000.00 ENGLEWOOD 303 PARTSBOX 2026-10-09 10,000.00 10,000.00 BELTON 304 PARTSBOX 2026-10-09 6,000.00 6,000.00 ANDERSON 305 PARTSBOX 2026-10-09 6,000.00 6,000.00 VENICE 306 PARTSBOX 2026-10-09 4,000.00 4,000.00 ENGLEWOOD 330 BANDR 2026-10-26 25,050.00 25,043.96 Owner payment list 2026-10-29 From the owner's li… ============================================================================================================== Payments: 173 | with a link or proposal: 1 | ambiguous: 2 statement(s) / 4 payment(s) | unmatched: 79 Allocations to write: 1 totalling $0.03 (0 from links, 1 proposed) Dry run — nothing written. Re-run with COMMIT=1 to apply.