Comic Book Collection Inventory

Who this is for

Your comics, one issue per line. Each entry records the series, issue and variant, the grade you gave it, whether it is bagged and boarded, what you paid and what you reckon it is worth now. The sheet works out the gain or loss on each issue and the totals for the collection and for each long box.

Comic collectors with more issues than they can keep in their head, from someone filling gaps in one run to a reader with a wall of long boxes.

What this helps you track

• Which issues of each series you own, and which variant
• The grade and storage state of each copy
• What each issue cost and what you think it is worth
• The gain or loss issue by issue and across the collection
• What each long box holds and what its contents add up to

How to use it

1. Write your name, how many storage boxes the collection uses and the date of the count at the top.
2. Give each issue a line: series, publisher, issue number with any variant, cover year, your grade and the box it lives in.
3. Tick bagged and boarded where it applies, then enter what you paid and your own current estimate of its value.
4. The gain or loss, the totals and the summary are worked out in the browser and the workbook; on paper, subtract across and add down.
5. Fill the long box table from the issue list so each box has its own count, cost and value.
6. Update the value column when you check recent sales, and date the sheet each time you do.

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

Where do the estimated values come from?

From you. Recent sold listings, a dealer's offer or a price guide you trust are the usual sources. The sheet supplies no values or grades; it only adds up the figures you enter, so note in the notes area where they came from.

How do I record a variant cover?

Put it in the issue column after the number, such as 12 var B or 1 foil. Keeping it on the same line as the issue means each physical copy has one row, which is what the issue count and totals rely on.

What grading should I use?

Whatever scale you already use, whether a numeric grade, a word such as fine or near mint, or a professional slab grade. Keep to one scale across the sheet so copies can be compared.

How do the long box totals work?

The box table has a line per box. Add up the issues, cost and value for that box from the list; the gain column is worked out for you. It shows at a glance which boxes hold the copies that matter most.