Model Kit Stash and Build Tracker

Who this is for

Know what is in the stash. List every kit you own by manufacturer, number, scale and subject, mark it as in the stash, started or built, and the tracker counts what is still unbuilt and adds up what the kits and their extras cost.

Scale modellers with a cupboard of unopened boxes, builders who buy aftermarket parts ahead of time, and anyone about to buy a kit they might already own.

What this helps you track

• Every kit by manufacturer, kit number, scale and subject
• Which kits are still in the stash, started or built
• What each kit cost and what went on aftermarket parts for it
• How many kits are built and how many are still waiting
• The total spend, and the spend on the scale you choose to count

How to use it

1. Write your name, where the stash is stored and the date of the count.
2. Put one scale in the scale to total field, written the same way you write it in the table.
3. Work through the boxes adding the manufacturer, kit name, kit number, scale and subject.
4. Enter what you paid for the kit and for any aftermarket parts, decals or paints bought for it.
5. Set each kit's status; the built and unbuilt counts and spend totals are worked out in the browser and the workbook.
6. Check the list before buying at a show, and update the status as builds move on.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What counts as aftermarket?

Anything bought for a particular kit beyond the box: photo-etch, resin parts, decals, masks, metal barrels. General paints and glue are better kept on a hobby budget rather than charged to one kit.

How does the spend by scale work?

Type a scale such as 1/72 into the header field exactly as you write it in the table. The scale column then shows each matching kit's total, and its column total is the spend on that scale.

Does a started kit count as unbuilt?

Yes. Only kits marked built are counted as built; stash and started both count as unbuilt, because both are still waiting for bench time.

Is there anywhere to log the build itself?

This tracker is for the stash as a whole. For a single build's costs and hours, use the hobby project cost and hours tracker alongside it.