Free tool

An auto parts invoice: each part with its number and the car it fits.

What comes back most in this trade is the part that does not fit, rarely a faulty one. So this template records the part number and the car the customer told you it was for: model and year. When he returns with a part, you compare what you wrote with what he needs. It has sample rows for common consumable parts with no brands, the numbers are examples, and the prices are blank.

Download

Plain files with no macros; they work in Excel, Google Sheets and LibreOffice.

Common questions

Why note the car the part fits?

Because most returns are about fit. If you wrote the model and year at the sale, then when the part comes back you can see whether the customer described the car wrongly or you picked wrongly, and settle it quickly.

Which part number do I write?

Write the number printed on the part or its box, the one your supplier uses when you order. If you sold an equivalent for an original, write the equivalent's number. The numbers in the sample rows only show the format.

Can one part fit several cars?

Yes. Write the car this customer told you about for this sale only, not everything the part fits. What matters here is what it was sold for; the full compatibility list belongs in the supplier's catalogue.

Dashing does this for every item, automatically, in your shop.