DRY RUN (set COMMIT=1 to write) ============================================================================================ AESOPMA 25 claims, $3,140.01 cancelled_billed 5 $535.00 draft (check amount) 4 $446.32 draft (ready to send) 21 $2,693.69 duplicate_billed 2 $286.32 overpayment 18 $2,318.69 AESOPMW 1 claims, $10.00 draft (ready to send) 1 $10.00 overpayment 1 $10.00 AESOPSE 40 claims, $7,106.94 cancelled_billed 3 $325.00 draft (check amount) 2 $200.00 draft (ready to send) 38 $6,906.94 duplicate_billed 1 $65.00 overpayment 36 $6,716.94 AESOPSW 4 claims, $280.00 cancelled_billed 2 $220.00 draft (ready to send) 4 $280.00 overpayment 2 $60.00 APLUS 10 claims, $761.49 cancelled_billed 2 $214.05 draft (check amount) 9 $612.12 draft (ready to send) 1 $149.37 return 8 $547.44 APS 1 claims, $500.00 draft (ready to send) 1 $500.00 overpayment 1 $500.00 BANDR 57 claims, $3,756.75 cancelled_billed 1 $75.00 draft (check amount) 23 $1,435.18 draft (ready to send) 34 $2,321.57 duplicate_billed 1 $60.00 overpayment 34 $2,247.40 return 21 $1,374.35 BMA 4 claims, $1,048.46 draft (check amount) 1 $134.99 draft (ready to send) 3 $913.47 return 4 $1,048.46 CJAUTO 6 claims, $494.58 draft (check amount) 6 $494.58 duplicate_billed 1 $159.59 return 5 $334.99 COMPLETETRUCK 2 claims, $342.00 cancelled_billed 2 $342.00 draft (ready to send) 2 $342.00 COUNSELMAN 13 claims, $311.03 cancelled_billed 3 $152.32 draft (check amount) 4 $195.67 draft (ready to send) 9 $115.36 duplicate_billed 2 $101.32 overpayment 8 $57.39 COUNTYLINE 11 claims, $253.75 cancelled_billed 4 $193.50 draft (ready to send) 11 $253.75 overpayment 7 $60.25 DINGS 6 claims, $76.65 draft (ready to send) 6 $76.65 overpayment 6 $76.65 DIXIE 14 claims, $168.50 cancelled_billed 1 $67.50 draft (check amount) 2 $23.00 draft (ready to send) 12 $145.50 overpayment 13 $101.00 ERIEVOVO 4 claims, $236.45 draft (check amount) 3 $191.25 draft (ready to send) 1 $45.20 duplicate_billed 3 $191.25 overpayment 1 $45.20 HANSER 5 claims, $474.18 draft (check amount) 2 $84.60 draft (ready to send) 3 $389.58 duplicate_billed 1 $49.50 overpayment 4 $424.68 HOLBROOK 3 claims, $202.50 draft (check amount) 3 $202.50 return 3 $202.50 JOHNSTRUCK 8 claims, $616.95 cancelled_billed 6 $543.00 draft (check amount) 1 $50.00 draft (ready to send) 7 $566.95 overpayment 1 $23.95 return 1 $50.00 KOSISKI 5 claims, $679.58 draft (check amount) 4 $614.13 draft (ready to send) 1 $65.45 duplicate_billed 1 $170.00 return 4 $509.58 MARTINS 12 claims, $171.90 draft (check amount) 1 $10.00 draft (ready to send) 11 $161.90 duplicate_billed 1 $48.00 overpayment 11 $123.90 MORLAKO 21 claims, $1,538.00 draft (check amount) 7 $674.70 draft (ready to send) 14 $863.30 duplicate_billed 6 $629.70 overpayment 14 $863.30 return 1 $45.00 MORRISONS 17 claims, $457.30 cancelled_billed 1 $47.50 draft (check amount) 4 $274.50 draft (ready to send) 13 $182.80 duplicate_billed 1 $80.75 overpayment 15 $329.05 OEMGARAGE 24 claims, $1,743.38 cancelled_billed 14 $1,090.61 draft (check amount) 8 $637.82 draft (ready to send) 16 $1,105.56 duplicate_billed 2 $150.00 return 8 $502.77 PAMS 6 claims, $547.00 cancelled_billed 6 $547.00 draft (check amount) 4 $257.00 draft (ready to send) 2 $290.00 PARTSBOX 201 claims, $35,805.92 cancelled_billed 83 $13,848.88 draft (check amount) 142 $25,181.92 draft (ready to send) 59 $10,624.00 overpayment 30 $5,165.51 return 88 $16,791.53 PEACHSTATE 10 claims, $646.00 draft (check amount) 7 $515.00 draft (ready to send) 3 $131.00 duplicate_billed 1 $115.00 overpayment 1 $2.00 return 8 $529.00 ROADTESTED 631 claims, $55,524.80 cancelled_billed 8 $879.00 draft (check amount) 52 $5,147.85 draft (ready to send) 579 $50,376.95 duplicate_billed 4 $327.95 overpayment 570 $49,430.55 return 49 $4,887.30 RSTROUD 7 claims, $242.50 draft (check amount) 4 $231.00 draft (ready to send) 3 $11.50 overpayment 3 $11.50 return 4 $231.00 SANDHILL 7 claims, $488.50 draft (check amount) 1 $100.00 draft (ready to send) 6 $388.50 duplicate_billed 1 $100.00 overpayment 3 $213.50 return 3 $175.00 SCHRAM 4 claims, $475.58 draft (check amount) 3 $245.00 draft (ready to send) 1 $230.58 overpayment 1 $230.58 return 3 $245.00 SEMINOLE 3 claims, $395.20 cancelled_billed 1 $142.20 draft (check amount) 1 $247.50 draft (ready to send) 2 $147.70 overpayment 1 $5.50 return 1 $247.50 SPALDING 12 claims, $1,480.70 cancelled_billed 3 $258.70 draft (check amount) 7 $646.70 draft (ready to send) 5 $834.00 duplicate_billed 4 $388.00 overpayment 5 $834.00 SPILMAN 5 claims, $289.45 cancelled_billed 1 $90.00 draft (check amount) 2 $172.45 draft (ready to send) 3 $117.00 duplicate_billed 1 $170.00 overpayment 3 $29.45 STOYSTOWN 18 claims, $1,405.00 cancelled_billed 5 $345.00 draft (check amount) 9 $835.00 draft (ready to send) 9 $570.00 duplicate_billed 1 $75.00 return 12 $985.00 WATERLOO 1 claims, $22.50 cancelled_billed 1 $22.50 draft (ready to send) 1 $22.50 WHEELSAMERICA 2 claims, $307.54 cancelled_billed 1 $135.55 draft (ready to send) 2 $307.54 overpayment 1 $171.99 YERTY 1 claims, $67.50 cancelled_billed 1 $67.50 draft (check amount) 1 $67.50 TOTAL cancelled_billed 154 $20,141.81 draft (check amount) 317 $39,928.28 draft (ready to send) 884 $82,140.31 duplicate_billed 34 $3,167.38 overpayment 790 $70,052.98 return 223 $28,706.42 HELD BACK (not claims). $ = the claim it would have been, else what was billed on those POs AESOPMA 16 $2,220.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse AESOPMA 11 $1,470.00 overpayment: not in Ship AESOPMA 1 $10.00 overpayment: item is credited on the credit chase: the whole bill is expected to reverse AESOPMW 77 $6,360.00 overpayment: not in Ship AESOPMW 6 $875.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse AESOPSE 11 $1,718.09 overpayment: item is review on the credit chase: the whole bill is expected to reverse AESOPSE 8 $1,013.03 overpayment: not in Ship AESOPSE 2 $172.98 overpayment: item is credited on the credit chase: the whole bill is expected to reverse AESOPSW 54 $5,332.59 overpayment: not in Ship AESOPSW 4 $400.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse APLUS 4 $277.95 overpayment: item is review on the credit chase: the whole bill is expected to reverse APLUS 3 $308.38 overpayment: not in Ship APS 15 $1,425.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse APS 5 $755.00 overpayment: not in Ship BANDR 5 $613.00 overpayment: not in Ship BANDR 27 $3,094.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse BANDR 3 $499.76 overpayment: item is credited on the credit chase: the whole bill is expected to reverse BMA 2 $499.48 overpayment: item is review on the credit chase: the whole bill is expected to reverse CJAUTO 1 $50.00 overpayment: not in Ship COMPLETETRUCK 2 $342.00 overpayment: not in Ship COUNSELMAN 1310 $96,732.21 overpayment: statement #N is already claimed by credit note #N COUNSELMAN 719 $57,616.89 overpayment: not in Ship COUNSELMAN 115 $9,747.11 overpayment: item is review on the credit chase: the whole bill is expected to reverse COUNSELMAN 6 $608.77 overpayment: item is credited on the credit chase: the whole bill is expected to reverse COUNSELMAN 774 $57,725.74 overpayment: no Ship buy price: unverifiable COUNTYLINE 37 $4,214.40 overpayment: not in Ship COUNTYLINE 13 $1,038.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse DINGS 1 $160.50 overpayment: not in Ship DINGS 1 $85.50 overpayment: item is credited on the credit chase: the whole bill is expected to reverse DINGS 1 $112.50 overpayment: item is review on the credit chase: the whole bill is expected to reverse DIXIE 9 $1,173.50 overpayment: item is review on the credit chase: the whole bill is expected to reverse DIXIE 1 $90.00 overpayment: not in Ship ERIEVOVO 1 $80.75 overpayment: item is review on the credit chase: the whole bill is expected to reverse ERIEVOVO 1 $55.25 overpayment: no Ship buy price: unverifiable HANSER 2 $76.50 overpayment: not in Ship HANSER 6 $423.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse HOLBROOK 1 $45.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse JOHNSTRUCK 6 $543.00 overpayment: not in Ship KOSISKI 5 $448.80 overpayment: item is review on the credit chase: the whole bill is expected to reverse KOSISKI 6 $940.86 overpayment: not in Ship MARTINS 36 $3,250.00 overpayment: statement #N is already claimed by credit note #N MARTINS 9 $718.00 overpayment: not in Ship MARTINS 1 $55.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse MORLAKO 2 $134.95 overpayment: item is review on the credit chase: the whole bill is expected to reverse MORRISONS 16 $2,497.00 overpayment: not in Ship MORRISONS 6 $678.25 overpayment: item is review on the credit chase: the whole bill is expected to reverse OEMGARAGE 16 $2,084.77 overpayment: not in Ship OEMGARAGE 1 $24.80 overpayment: item is credited on the credit chase: the whole bill is expected to reverse OEMGARAGE 5 $319.37 overpayment: item is review on the credit chase: the whole bill is expected to reverse OEMGARAGE 1 $257.37 duplicate_billed: compiled statement: a repeated line is our own import, not the yard billing twice PAMS 1 $45.00 return: the yard has not confirmed the return PAMS 394 $31,980.00 overpayment: no Ship buy price: unverifiable PAMS 27 $5,877.50 overpayment: item is review on the credit chase: the whole bill is expected to reverse PAMS 45 $6,630.00 overpayment: not in Ship PAMS 2 $374.00 overpayment: item is credited on the credit chase: the whole bill is expected to reverse PARTSBOX 252 $35,396.48 overpayment: not in Ship PARTSBOX 83 $19,646.77 overpayment: item is review on the credit chase: the whole bill is expected to reverse PARTSBOX 348 $53,553.70 overpayment: no Ship buy price: unverifiable PARTSBOX 2 $305.16 overpayment: item is credited on the credit chase: the whole bill is expected to reverse PEACHSTATE 2 $143.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse PEACHSTATE 1 $50.00 overpayment: item is credited on the credit chase: the whole bill is expected to reverse PEACHSTATE 1 $65.00 overpayment: not in Ship ROADTESTED 2 $201.95 overpayment: item is credited on the credit chase: the whole bill is expected to reverse ROADTESTED 32 $4,163.70 overpayment: item is review on the credit chase: the whole bill is expected to reverse ROADTESTED 14 $1,792.60 overpayment: not in Ship ROADTESTED 1 $65.00 overpayment: no Ship buy price: unverifiable RSTROUD 8 $673.58 overpayment: item is review on the credit chase: the whole bill is expected to reverse RSTROUD 1 $75.00 overpayment: item is credited on the credit chase: the whole bill is expected to reverse SANDHILL 4 $500.00 overpayment: not in Ship SANDHILL 1 $75.00 overpayment: item is credited on the credit chase: the whole bill is expected to reverse SANDHILL 6 $475.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse SCHRAM 2 $175.00 overpayment: not in Ship SCHRAM 4 $410.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse SEMINOLE 5 $445.50 overpayment: item is review on the credit chase: the whole bill is expected to reverse SEMINOLE 1 $142.20 overpayment: not in Ship SPALDING 309 $27,082.00 overpayment: statement #N is already claimed by credit note #N SPALDING 2 $136.00 overpayment: item is credited on the credit chase: the whole bill is expected to reverse SPALDING 2 $192.00 overpayment: no Ship buy price: unverifiable SPALDING 33 $3,885.00 overpayment: not in Ship SPALDING 10 $1,198.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse SPILMAN 30 $1,768.00 overpayment: statement #N is already claimed by credit note #N SPILMAN 11 $1,443.00 overpayment: not in Ship SPILMAN 12 $1,037.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse STOYSTOWN 21 $2,385.00 overpayment: not in Ship STOYSTOWN 14 $1,100.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse WATERLOO 10 $414.00 overpayment: item is review on the credit chase: the whole bill is expected to reverse WATERLOO 9 $863.00 overpayment: not in Ship WHEELSAMERICA 1 $135.55 overpayment: not in Ship note: Return and cancelled claims come from the v2 dry run (refunds_v2_dryrun_20261111_201549_1197581.csv); v2 is not applied to expected_refunds. 4 clean draft(s) in the ledger are no longer produced and would be flagged. Dry run: nothing written. Add --commit to write the new claims as drafts.