Industry Use Cases

How to Track Missing Auto Parts Core Credits in Excel

The replacement alternator is on the repair order and the vendor acknowledged the old core’s return nine days ago. The Friday review still shows no posted credit against the $65 charge. That’s the sort of item a parts manager can lose track of between the counter and accounting.

Match the original core charge, the completed return, and the vendor credit. Send follow-ups for overdue returned cores with no matching posted credit. Keep cores still on the shelf in a separate pickup queue.

Three cores, three different next steps

This shop uses seven days from acknowledged return as its review cutoff. Its Friday worksheet contains these three lines.

Repair orderCore chargeReturn recordCredit postedNext action
RO-1182$65RT-301 · 9 days ago$0Ask vendor for credit
RO-1189$95Still at shop$0Put on next pickup
RO-1191$80RT-309 · 4 days ago$80Close the item

Only $65 belongs on the missing-credit list. Another $95 requires a physical return. Keeping both in one overdue balance would send the vendor an item the shop still has.

Use a line reference that survives the return

Start with the parts purchase or RO export, then add the return log and vendor statement. Keep vendor, original invoice line, core amount, return ticket, return date and credit memo reference. A part number can occur on multiple jobs. Use the linked reference or confirm a composite match before assigning a credit.

Reconcile what was actually credited

Sum credit lines tied to the same return after verifying sign conventions. Flag partial credits, split credits and deferred-core arrangements. Use a dated snapshot so a statement issued before a return doesn’t make the return look overdue.

Turn Friday’s review into a vendor call list

Keep the return ticket and original invoice on each exception so the vendor can find it while you’re on the phone.

Which acknowledged core returns are older than seven days and lack a full posted credit? Show the RO, return ticket, remaining credit, vendor and supporting rows.

Keep a separate line for unresolved matches. A matching dollar amount alone is weak evidence that a particular core was credited.

Tekmetric’s core tracking and returns guide · Tekmetric’s deferred core guide

The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.

Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.

For more checked examples, see Jolene.pro Workbook Studies.

Leave a comment