Logbook For Custom Keycaps Monthly

The Spreadsheet Nobody Asked For but Everyone Needs

Most people who get into custom keycaps start buying things without tracking anything. Then six months later they have a box of stabilizers they can't identify, three copies of the same legend kit, and no idea what they actually paid for that PVD set from 2023. A Logbook For Custom Keycaps Monthly fixes that mess, or at least makes it manageable. It's not some special software. It's a spreadsheet layout — typically Google Sheets or Excel — organized by month with columns for date, vendor, set name, profile, quantity, price paid, shipping cost, tax, total, and notes. The monthly grouping matters because that's how you actually review spending at the end of the period. Without it, everything blends together and you can't tell if Q4 was worse than Q1. I built my first one in 2019 because a friend sent me a screenshot of their tracking sheet and I realized I had no idea how much I'd spent on keycaps in the prior year. What I thought was about eight hundred dollars turned out to be closer to two thousand three hundred. That number changed how I approached every order after that.

Here's how the actual structure works. You create a master sheet with all historical entries, then a separate tab for each month. The master sheet pulls from the monthly tabs using a simple QUERY formula in Google Sheets, so you're not entering data twice. Columns on the master should include everything from the monthly sheet plus an aggregated price column that calculates total cost per set including shipping and tax. One thing people get wrong is the price column. You need to record the actual amount charged to your card, not the listed price. Vendor discounts, bundle deals, and pre-order pricing mean the listed price is often wrong. I learned this when I bought a set listed at 120 dollars that came with free shipping, but the vendor split the order into two shipments three weeks apart and the second shipment had a 15 dollar handling fee. My logbook caught it. My brain would have forgotten it entirely. There's also a field for arrival status — ordered, producing, shipped, delivered, unboxing, mounted — that matters more than you'd think. Groups stretch for months sometimes. Keeping track of where each order sits prevents you from double-ordering something because you assumed it arrived when it was actually still in the producing phase.

I ran into a specific problem with resin keycaps about a year ago. I ordered a set from a small artisan group, paid 89 dollars, and the vendor listed it as "PBT doubleshot." When the caps arrived, the legends were clearly FKB-style filled nylon inserts, not actual doubleshot construction. The price difference between those two manufacturing methods is significant for resales. My logbook entry already had the vendor name and listing description recorded, so when I needed to dispute the classification for a future return or resale documentation, I had the paper trail. Without it, I would've just accepted the misrepresentation and moved on. Another column you should add is the resin type or material category if you're collecting artisan keycaps. Epoxy, urethane, and cold cure resin age differently and have different failure modes. Urethane yellows faster. Epoxy gets brittle. If you're tracking a collection long-term, that distinction matters more than the aesthetic description anyone gives you at purchase time. The downside of this system is that it requires actual discipline. Most people set up a nicely formatted sheet and stop entering data after three weeks because life happens and the habit never sticks. The alternative — doing nothing and accepting that you'll never know your total collection value — is honestly fine too. The logbook only helps if you use it consistently for at least six months straight.

Another bottleneck: spreadsheets don't handle image storage well. You'll want screenshots of product pages saved separately anyway because vendor sites disappear. I keep a folder on Google Drive organized by vendor and date, then paste the folder link in the notes column. This takes about forty seconds per entry and prevents the "I need to check what that set looked like" panic that happens when a vendor goes offline. If you want a starting template, the structure I described is simple enough to build in under twenty minutes. Google Sheets has free templates for inventory tracking that you can adapt by renaming the standard fields to match the keycap-specific columns I mentioned. Don't overcomplicate it with pivot tables or conditional formatting in the beginning. Those add complexity without adding value until your collection exceeds roughly forty entries, at which point a pivot table showing average price per profile becomes useful for spotting when you're overpaying for certain types. The real insight most beginners miss is that the logbook isn't primarily for tracking spending. It's for tracking patterns. After six months of entries you'll notice whether you buy more during group announcements, whether certain vendors consistently have longer wait times, whether you tend to repeat purchases of the same profile. Those patterns are what actually change your behavior, not the raw dollar total.

I've seen people try to use dedicated apps for this instead of spreadsheets. They exist. They're usually worse because they force a data structure you didn't choose, and when the app shuts down — which they do, frequently — you lose everything. A spreadsheet file exported to CSV is portable and readable twenty years from now. Apps are not. The system breaks down if you're buying from group buys that span multiple months. You'll have an order in January that doesn't arrive until April. The monthly tabs handle this fine as long as you enter the order in the month you paid, mark the arrival date in the notes column, and reference that same entry when you actually unbox it. Don't create two separate rows for the same purchase just because the timeline is spread out. One row, complete notes, correct. If you collect enough to care about this level of tracking, the initial time investment pays for itself the first time you need to prove a purchase date for a warranty claim or calculate total collection value for a sale. Those moments arrive whether you're prepared or not.