Record Vehicle Parts Purchases, Identifiers and Installation Evidence

A useful car parts record does two separate jobs. First, it documents what you bought: who sold it, when, the receipt and line-item reference, the description and every identifier exactly as printed, and the quantity. Second, and only when separate evidence exists, it documents what was installed: on which vehicle, when, how many, and which work order, invoice or log shows it. Keeping these two layers apart is the core of a traceable record. A receipt proves a purchase. It does not prove that a part went onto the car, and a part number on its own does not prove that the part fits, is genuine or is suitable for a particular vehicle.

Terms used in this guide

Part number: an identifier assigned by a vehicle manufacturer, parts maker or brand to a specific part. The same physical part can carry several different numbers from different companies.
OE or OEM number: the number used by the vehicle manufacturer or its original-equipment supplier.
Aftermarket or brand number: the number used by a replacement-parts brand for its own product.
SKU or store item number: the seller's internal stock code. It identifies the item in that store's system and is not necessarily a manufacturer part number.
Line item: one row on a receipt or invoice, usually with a description, an identifier, a quantity and a price.
Vehicle reference: the information that ties a record to one vehicle, ideally the VIN (Vehicle Identification Number) together with the document where you read it, such as the registration or the plate on the vehicle.
Core charge: a refundable deposit some sellers add for parts that can be rebuilt, such as certain starters, alternators or batteries, which is returned when the old unit is brought back.

Fields for the purchase record

Create one purchase row per receipt line item. If a single line covers several units, keep them on one row with the quantity recorded rather than splitting them into invented separate entries.

Field	What to enter	Why it matters
Purchase date	The date printed on the receipt	Anchors warranty and return timing
Seller	Store, website or individual as named on the receipt	Identifies who issued the document
Receipt reference	Receipt, order or invoice number	Lets you find the original document
Line-item reference	Line number or position on the receipt	Separates items on long receipts
Description as printed	The exact wording from the receipt	Preserves the source wording
Standardized description	Your own plain label, such as "engine oil filter"	Makes records searchable without altering the transcription
Identifier 1, 2, 3	Each number exactly as printed	Different numbers serve different purposes
Identifier label	The label printed next to each number, such as "Part #", "SKU" or "OEM", or "identifier type unresolved"	Prevents a store code being mistaken for a part number
Quantity and unit	For example 2 each, 1 set, 5 quarts	Purchases and installations are counted against this
Vehicle reference and source	VIN and where you read it, or "not stated"	Shows whether the purchase was tied to a vehicle
Evidence file	Filename of the receipt scan and any packaging photo	Links the row to proof
Unreadable characters	Marked explicitly, for example 15400-?LA-004	Avoids silently guessing
Open verification question	Any unresolved point, such as fitment or identifier meaning	Keeps uncertainty visible
Status	Purchase documented, returned, core returned and similar	Tracks what happened after purchase

Fields for the installation record

Keep installation as a separate record that points back to the purchase row. Fill it in only from a document or log that actually describes the work, such as a shop invoice, a work order or your own dated maintenance log.

Field	What to enter
Purchase row reference	The receipt and line-item reference this installation draws from
Installation date	Date shown on the service document or log entry
Quantity installed	Only the number the document supports
Vehicle reference	VIN and its source
Odometer reading	As recorded on the service document, if present
Installed by	Shop name or "owner" as recorded
Service document reference	Work order, invoice or log entry number
Identifier on service document	Any part number printed on the service document, exactly as shown
Evidence file	Scan or photo of the service document

A copyable template

The template below is a set of column headings you can paste into any spreadsheet program. Use one sheet for purchases and one for installations. To get a printable PDF version, fill in or format the sheet and use the program's print or export-to-PDF option. Nothing has to be downloaded.

PURCHASES
purchase_id,purchase_date,seller,receipt_ref,line_item_ref,description_as_printed,standardized_description,identifier_1,identifier_1_label,identifier_2,identifier_2_label,identifier_3,identifier_3_label,quantity,unit,vin,vin_source,evidence_files,unreadable_characters,verification_question,status

INSTALLATIONS
install_id,purchase_id,install_date,quantity_installed,vin,vin_source,odometer,installed_by,service_doc_ref,identifier_on_service_doc,evidence_files,notes

How to transcribe identifiers accurately

Copy every identifier character for character, including dashes, spaces and letter suffixes. Do not reformat or shorten it.
Record the label printed next to each number. If there is no label, or its meaning is unclear, write "identifier type unresolved" rather than guessing.
When a character cannot be read, mark it with a placeholder such as a question mark and note which image shows it. Do not fill it in from memory or a search result.
Keep the transcribed description and your standardized description in separate fields so the original wording is never overwritten.
If the packaging or the part itself carries a number different from the receipt, record it as an additional identifier with its source, such as "box label", and photograph it.
Write open questions as questions, for example "Does this number match the manufacturer listing for this VIN?" An identifier is a lookup key for answering such a question, not the answer itself.

Example: two purchased, one documented as installed

This is an illustrative, hypothetical case. A receipt lists one line described as filters, quantity two. The purchase row records quantity 2 and status "purchase documented." Later, a shop invoice shows one filter replaced on a specific date at a recorded odometer reading. The installation sheet gets one row: quantity installed 1, linked to that purchase row and that invoice. The record now shows two purchased and one documented as installed. The second filter is left without an assigned outcome. Do not mark it as installed, returned or lost unless another document shows which of those happened.

Keeping the evidence usable

Scan or photograph receipts soon after purchase. Many printed receipts use thermal paper, which can fade.
Photograph packaging labels that carry identifiers before discarding the box.
Name files so they sort and match the sheet, for example 2026-03-14_receipt-48213.jpg or 2026-03-14_receipt-48213_line2_box.jpg.
Store scans in one folder per vehicle, and keep any originals with the vehicle's paper records.
When a part is returned or a core is refunded, attach the return or refund receipt and update the status. Do not delete the original purchase row.
For warranty claims, check the seller's or parts maker's warranty terms for what documentation they require. Linked purchase and installation records make those requirements easier to meet.

What these records can and cannot show

Kept this way, the records show when and where a part was bought, which identifiers it carried, and which purchases are backed by documented installation. They do not establish that a part is compatible with the vehicle, genuine or correct for the job. Those questions depend on the specific model year, market, engine and equipment. Answer them against the vehicle manufacturer's or parts maker's own catalog or documentation for that VIN, and record the answer and its source in the verification field.