Procurement & Vendor · Excel template
Free Core Return Tracker
A tracker for core deposits and returns on rebuilt parts — alternator, starter, brake caliper — so a refundable deposit doesn't quietly expire in a shop corner.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- A per-part core deposit entry linked to the repair order and the original purchase
- A return deadline field, since core credit is almost always time-limited
- A physical-location field for the old core awaiting return, so it doesn't get lost or scrapped by mistake
- A credit-received confirmation tied to the vendor invoice or statement
- An expired-deposit flag for anything past its return window, so lost credit is visible rather than silently absorbed
How to use it
- 1
Log the core deposit the same day a rebuilt part is purchased, against the repair order it belongs to — a core tracked from day one is far less likely to get lost than one added retroactively.
- 2
Record the return deadline from the vendor's terms; core credit windows are usually measured in weeks, not months, and vary by vendor and part type.
- 3
Note exactly where the old core is sitting while it awaits return — a specific shop location, not just 'in the shop' — since a core with no location is the one that gets scrapped by accident.
- 4
Confirm credit received against the vendor's invoice or account statement, not just against the return being shipped; a core returned but never credited is still a loss until it's confirmed.
- 5
Review for anything approaching its deadline weekly; a core deposit that expires unclaimed is money the shop already paid and will never see back.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Core Return Tracker
Core deposit amounts and return windows are set by each vendor and vary by part type. Confirm the specific terms on the purchase invoice rather than assuming a standard window applies.
| Part | Repair Order # | Vendor | Deposit Amount | Return Deadline | Core Location | Credit Status |
|---|---|---|---|---|---|---|
| Alternator | RO-4471 | NAPA | $45.00 | 2026-04-15 | Shop, core shelf B3 | Awaiting return |
| Starter | RO-4455 | O'Reilly | $35.00 | 2026-03-20 | Returned | Credited 2026-03-22 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
It varies by shop, but core deposits accumulate quickly across alternators, starters, calipers, and other rebuildable parts, and shops without a tracking system routinely lose a meaningful amount to deposits that simply expire unclaimed because nobody knew the old part was still sitting on a shelf. The tracker exists because the failure mode isn't losing the part — it's forgetting it was ever there.
Because 'in the shop' isn't searchable when a deadline is approaching and someone needs to find the part quickly — a specific, consistent location convention is what turns a two-minute retrieval into a scavenger hunt through a full shop. The location field only works if it's kept current the moment a core moves.
Call the vendor before assuming it's a lost cause — some will extend a deadline on request, especially for a good account, even though the terms technically state otherwise. If it's confirmed genuinely lost, flag it in the log as a write-off so the loss is visible and traceable rather than just quietly disappearing from the shop's numbers.
Generally yes — a $15 core deposit lost is still a loss, and small deposits are actually the ones most likely to get forgotten because nobody treats them as worth tracking. The discipline of logging every one, regardless of size, is what prevents the pattern rather than the size of any single deposit.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.