How to track your fly tying inventory
A seven-step method that survives past week two — built around the two reasons most inventories get abandoned.
To track a fly tying inventory: pick one system, record four fields per item — type, colour, size and storage location — label your boxes before you start, and work through one container at a time. Record quantity as a rough band rather than a count, and check the inventory before you shop rather than after.
Most fly tying inventories fail for the same two reasons: they record too much per item, and they live somewhere you can't reach at a shop counter. Everything below targets those two failure modes.
1. Pick one system and use only that
The commonest failure is keeping half a spreadsheet, half a notebook and half an app. Pick one. Which you choose matters far less than not splitting records across three places.
2. Log the four fields that matter
Type, colour, size and storage location. Everything else is optional. Recording too much is why most inventories get abandoned in week two.
3. Label your storage before you log anything
Number your boxes and drawers first. An inventory that tells you what you own but not where it is only solves half the problem — and the less annoying half.
4. Catalogue in one sitting, by container
Work through one box at a time rather than by material type. It's faster, you miss less, and the storage location is in front of you as you go.
5. Record quantity as a band, not a count
Plenty, running low, or out. Nobody counts hackle fibres, and precise counts go stale within a week.
6. Check it before you shop, not after
The whole point is the thirty seconds before you pick up a packet in a shop.
7. Update as you use things
Mark something low the moment you notice it, while you're holding it. A monthly audit is a chore you'll skip.
Why do most inventories get abandoned?
Two reasons, and neither is laziness. The first is over-recording — if logging one packet of dubbing takes two minutes, you'll stop. The second is that the record lives in the wrong place: a spreadsheet on a desktop is useless at the moment you're deciding whether to buy another spool of olive thread.
The test of an inventory isn't how complete it is. It's whether you check it before you buy.
Track it on your phone
Four fields, storage locations and rough quantities — cross-checked against your pattern recipes.
Frequently asked questions
How do I track my fly tying inventory?
Pick one system, record four fields per item — type, colour, size and storage location — label your boxes before you start, and catalogue container by container in one sitting. Record quantity as a rough band rather than an exact count, and check the inventory before you shop rather than after.
What is the best way to organise fly tying materials?
By container, with every container labelled. Organising by material type sounds tidier but breaks down as the collection grows. What matters is that your record tells you which labelled box a material is in.
Should I use a spreadsheet or an app?
A spreadsheet is free and flexible and works well if you mostly sit at your bench. An app wins on mobile access, which matters because the moment you need the data is usually standing in a fly shop. Look for one that imports CSV so you don't start over.
How much detail should I record per material?
Less than you think. Type, colour, size and location cover almost every real use. Over-detailed records are the main reason fly tying inventories get started and then abandoned.
How do I stop buying duplicate materials?
Make the check take under thirty seconds on your phone, and do it before you buy rather than when you get home. Duplicate purchases aren't a memory problem — they're an access problem.