The Hidden Complexity of Insuring Your Equipment

When I first purchased an inland marine insurance policy for our production company, I had to provide the insurance company with an inventory of our equipment. That seemed straightforward enough. I’d been maintaining an Excel spreadsheet with our cameras, lenses, lighting, audio equipment, and other gear, including what we’d paid for each item. But the insurance company needed more than a list of what we owned. They also needed to understand how much equipment we typically took into the field, which meant I had to go back through the spreadsheet and figure out what traveled with us on production days.

I ended up adding quantities beside the equipment we typically took on location and creating a separate calculation to determine its total value. It worked, but it was another manual process built on top of a spreadsheet that I already struggled to keep current. And as I started thinking about how to manage our equipment more effectively, I realized there were several things a traditional spreadsheet simply wasn’t designed to handle particularly well.

Three Cameras, Three Different Purchases

One of the limitations of managing equipment in Excel is figuring out how to account for multiple copies of the same product. Let’s say you own three identical camera bodies. You might have purchased the first one two years ago, added another six months later, and picked up a third during a sale. They’re all the same model, but each has a different serial number, purchase date, and potentially a different purchase price.

In a spreadsheet, you can create three separate rows or consolidate them into one row with a quantity of three. Neither approach is particularly difficult, but each has limitations. A single row makes it harder to maintain the details of each individual camera, while separate rows create more records to manage. When we built GearDock.io, I wanted to handle that differently, so we created a distinction between products and individual items. A product represents the camera model, while the individual items represent the actual cameras you own. That allows us to manage multiple copies of the same product, each with its own serial number, purchase date, purchase price, and replacement value. When it’s time to review or report on our inventory, those individual items are accounted for without having to maintain separate product listings.

What’s Actually in That Pelican Case?

Another thing we started thinking about was how our equipment is organized in the real world. We have a Pelican case that holds three camera bodies and several lenses. Those items generally stay together, and when we head out for a shoot, the entire case comes with us. We wanted GearDock.io to reflect that relationship, so we introduced the concept of kits, which allow you to group individual pieces of equipment that regularly belong together, including the case itself.

Now, rather than trying to remember everything packed inside that Pelican case, we can open the kit in GearDock.io and see its contents, along with the combined value of everything inside. That’s useful when preparing for a shoot, checking equipment, or understanding how much of our investment is traveling together in a single case. And unlike a simple list of equipment, the kit maintains the relationship between those individual items, which is how we actually think about and use them.

Knowing Who Has What

There’s another consideration when equipment regularly leaves your office: knowing where it is and who’s responsible for it. Our old spreadsheet couldn’t answer that question. It documented what we owned, but if someone on our team took equipment to another location, we had to remember who had it. GearDock.io keeps track of equipment checkouts at the individual-item level, so if Jonathan has ten pieces of equipment checked out, I can see exactly which ten items he has, including their serial numbers and individual values.

This gives us a much clearer picture of how our equipment is being used and where it’s located at any given time. It’s also important to distinguish that visibility from the insurance calculation I originally had to prepare. GearDock.io tracks what is currently checked out and the value of those items, but that isn’t necessarily the same as determining the maximum amount of equipment we might take into the field for insurance purposes. Still, having accurate records of individual items, their values, and their locations gives us a much better foundation for those conversations.

Keeping Better Records Before You Need Them

One of the things I learned from that original insurance experience is that an equipment inventory becomes much more valuable when you need to use it for something beyond simply remembering what you own. Insurance is one example, but the same information becomes useful when you’re preparing financial reports, replacing damaged equipment, or reviewing the investment you’ve made in your business. GearDock.io allows us to maintain purchase prices, replacement values, serial numbers, and other details for each individual item, with reporting that accounts for the equipment in our inventory.

I still think spreadsheets are incredibly useful, and we even built an Excel import and export feature into GearDock.io because that’s where so many people already maintain their equipment lists. But after years of managing our own production equipment, we needed something that reflected how we actually purchase, organize, and use our gear. And we certainly didn’t want to spend another afternoon rebuilding an insurance calculation from a spreadsheet that hadn’t been updated in six months.