These are the fields that turn a pile of receipts into a margin you can read at a glance. Capture acquisition once, add restoration lines over time, and close with the sale.
- Item name & description
- A specific, findable label — "Edwardian mahogany washstand" or "Seth Thomas mantel clock, c.1890" — not a generic category. This is your one-off identifier in place of a SKU.
- Acquisition source & date
- Where and when you bought it: estate sale, auction lot #, picker, flea market, private seller — plus the date, so the buy ties to the right receipt.
- Acquisition cost
- The all-in purchase price you paid, including buyer's premium or lot fees if the auction charged them, with the buy receipt attached.
- Restoration line items
- Each spend on the piece as its own line — re-upholstery, re-caning, re-wiring, refinishing, replacement hardware, parts, courier — with the supplier and the receipt attached to each.
- Total restoration spend
- The running sum of all restoration lines, so you always see how much you've put into the piece before it sells.
- Sale price & date
- What it finally sold for and when, with the sales receipt or marketplace payout statement attached. For unsold pieces, leave it open.
- Per-item margin
- Sale price minus acquisition cost minus total restoration — the true result for that single piece, recorded for review.
- Expense category
- Tag each cost line to a product-defined category (acquisitions, restoration-labor, restoration-materials, shipping) so your accountant sees consistent buckets at year end.