How I Track My Comic Collection Without Losing My Mind

I bought a duplicate volume of Berserk last month. Volume 14, the Deluxe Edition. I already owned it. I knew this the moment I got home and saw it sitting on my shelf in the exact spot it had been for six months. This was the third time I'd bought a duplicate – same series, same edition, different occasions. That's when I decided I needed a system.

Not a mental note. Not a photo of my shelf. An actual list of what I own.

The collector vs reader problem

Comics sit in a weird space. Some series I buy to collect – I want every volume on the shelf even if I haven't read them all yet. Other series I read digitally and never plan to own physically. And some I'm doing both: collecting the physical editions while also reading ahead online.

Without tracking, these categories blur together. I lose sight of which volumes I actually own, which I've read and which are sitting in a stack untouched. The physical shelf gives you a rough sense, but it doesn't tell you what's missing from a series or which volumes you bought but never opened.

And the shelf is useless when you're browsing a convention floor from memory, trying to remember whether you own volumes 5 through 8 of something.

What I track

Each row in my spreadsheet is one series. I log:

• Title and series name – the actual series, not individual issues
• Publisher – Viz, Image, Dark Horse, DC, Marvel, etc.
• Format – manga, graphic novel, trade paperback, single issue collection
• Volumes owned – updated whenever I buy the next one
• Genre – action, horror, slice of life, sci-fi, whatever fits
• Status – wishlist, collecting, complete, on hold or dropped
• Price paid – total spent on the series so far
• Rating – 1 to 5, updated as I read more

When I buy a new volume, I update the count and the total price. Takes about 30 seconds. The whole collection lives in one sheet, sorted however I want.

Manga is its own beast

If you only collect graphic novels and trade paperbacks, tracking is manageable. A series might be 4 to 10 volumes. You can keep that in your head.

Manga is different. Long-running series with 20, 30, sometimes 50+ volumes. One Piece alone has over 100 volumes. Naruto has 72. Tracking which volume you're on, what you've spent in total across a series and whether you're still actively collecting – that's where a spreadsheet earns its keep.

I have 8 manga series where I own more than 15 volumes each. Without tracking, I'd have no idea how much money is sitting on those shelves. Turns out it's a lot more than I expected.

The spending wake-up

I thought my comic spending was "maybe $20 a month." Reasonable. Under control. The kind of number you tell yourself without checking.

Actual monthly average after three months of tracking: $47. Mostly convention impulse buys and online pre-orders I forgot about. A single convention weekend could easily hit $150 if I wasn't paying attention. I wasn't paying attention.

The pre-orders were the sneaky part. I'd order something months in advance, forget about it and then get charged when it shipped. It felt like free money at the time of purchase. It was not free money.

Knowing exactly what I own means I stop buying duplicates. Knowing exactly what I've spent means I buy intentionally instead of impulsively.

I haven't bought a duplicate since I started tracking. That alone has probably saved me $40 to $60, depending on how generous I'm being with my past self's judgment.

Publishers tell you something about yourself

I didn't realize 70% of my collection was from one publisher until the chart showed it. Viz Media, which makes sense because most of what I read is manga. But I had no idea the concentration was that high.

It's not a problem. It just tells you where your taste actually sits when you look at the data instead of guessing. I thought I had a diverse collection. I have a manga collection with a few Image comics mixed in.

The genre breakdown was similar. I assumed I read broadly. The chart said 60% of my collection is action and horror. The "variety" I thought I had was about 6 series across everything else.

The wishlist is the real power

This is the part that actually changed my spending habits. Instead of impulse-buying at every comic shop visit or convention booth, I add the series to my wishlist first. I log it, note the price and move on.

The cooling-off period is real. Half the stuff I add to the wishlist I never actually buy. A series that seemed essential in the moment stops being interesting two weeks later. That means I would've regretted those purchases – or at least felt nothing about them, which is worse.

By my estimate, the wishlist buffer has saved me about $200 this year. That's $200 I would have spent on series that are still sitting on my wishlist, unbought and un-missed.

Complete vs collecting vs dropped

Tracking status honestly is the hardest part of maintaining a collection spreadsheet. You have to be real with yourself about what you're actually doing.

A series you haven't bought a new volume of in 8 months isn't "collecting." It's "on hold" at best, "dropped" at worst. That omnibus edition of a series you bought volume 1 of and never continued? That's not "collecting." You tried it and moved on.

Being honest about status keeps the data useful. When I filter to "collecting" I want to see the series I'm actively buying, not a list that includes 12 series I quietly abandoned. The whole point is that the spreadsheet reflects reality, not aspirations.

Tips for getting started

Track series, not individual issues

Unless you're deep into single-issue collecting with variant covers and first printings, one row per series with a volume count is way easier to maintain. You don't need a row for every issue of every series. Update the count when you buy the next volume. That's it.

If you do collect single issues for specific series, add a notes column for issue numbers. But keep the row at the series level – your analytics will be more useful that way.

Log the price you actually paid

Not the cover price. Sales, used copies and convention deals mean the real number is different – usually lower. That's the number that matters for your spending data. A volume with a $15 cover price that you bought used for $6 should show $6.

This also means your total spending number is accurate, not inflated. When you look at your monthly average, you're seeing what actually left your wallet.

Use notes for convention hauls

After a convention, sit down and log everything in one session while you still remember what you bought and where. The notes column is good for marking which booth or vendor you bought from – it helps you remember which ones to revisit next year and which ones had the best prices.

I spent 20 minutes after my last convention logging 9 new entries. It felt tedious in the moment. Three months later, when I was planning for the next con, that data was the most useful prep I had.