Parts Return and Core Charge Tracker
Turns the owner's messy notes, invoices, and return slips into a clear list of parts and cores that still need to go back to suppliers, what credit is owed, and what is overdue.
Before and after
Summary: 4 open items need action, $182.50 at stake across 2 suppliers. 2 are overdue or past the window you gave, 0 are closing soon.
Rick's Auto Parts (return window for cores: 14 days, per you. Please confirm with Rick's.)
| Invoice | Date | Vehicle / RO | Item | Amount | Status | Days |
|---|---|---|---|---|---|---|
| 44721 | Feb 27 | Calloway 2014 Colorado | Alternator core | $40.00 | Needs to go back (you think it is on the shelf, please check) | Deadline Mar 13, 5 days overdue |
| 44790 | Mar 3 | Bo's Sentra, RO 2218 | 2 front caliper cores, $25 each | $50.00 | Returned Mar 6, credit not seen | Window ended Mar 17, confirm credit with Rick's |
| 44802 | Mar 12 | Jetta, RO 2231 | Power steering pump core | $30.00 | Needs to go back | Deadline Mar 26, 8 days left |
| 44755 | Mar 1 | Customer vehicle not named in notes | Starter core | $35.00 | Keep, customer took old starter home | Not counted in total |
Ashgrove Brake Supply (return window: 30 days, per you. Please confirm with Ashgrove.)
| Invoice | Date | Item | Amount | Status | Days |
|---|---|---|---|---|---|
| V-9034 | Mar 10 | Wrong pad set for the Ford, still in the box | $62.50 | Needs to go back | Deadline Apr 9, 22 days left |
Totals still open:
- Rick's: $40.00 + $50.00 + $30.00 = $120.00
- Ashgrove: $62.50
- Grand total: $182.50
Needs attention first
- Alternator core, invoice 44721. Past the window you gave by 5 days. Find it today and ask Rick's if they will still take it.
- Caliper cores, invoice 44790. Returned Mar 6 but no credit. Ask Rick's to look for the return and send you the credit memo number.
Questions for you
- Is the alternator core really on the shelf by the back door? Is it complete and undamaged? Rick's decides whether to accept it.
- Who was the driver on Mar 6, and did you get a signed slip?
- Is the wrong pad set for the Ford unopened and in its original packaging? Ashgrove decides whether to accept it.
- Starter, invoice 44755: which customer and repair order was it for? Was the core charge taken off that customer's bill, since the old starter went home with them? Check the repair order. Ask Rick's whether they will still bill you for the $35.00 core.
Action list
- Today: find the alternator core and box it with the power steering pump core. Call Rick's about invoice 44790.
- Next Rick's run: send both cores with invoice numbers written on the boxes, and get a signed return slip. The pump core deadline is Mar 26.
- Next Ashgrove run: return the wrong pad set in its box.
- Next week: check both supplier statements for credits.
What it does
Turns the owner's messy notes, invoices, and return slips into a clear list of parts and cores that still need to go back to suppliers, what credit is owed, and what is overdue. Helps the shop stop losing money on forgotten cores and unreturned parts.
Use it when: Use when an auto repair shop needs to track parts returns and core charges, such as "what cores do we owe back," "track my returns," "which parts did we not send back," "core credit missing," or "check my supplier returns."