If you rent out camera equipment, you are running a small business whether you think of it that way or not. And like any business, the financial picture only becomes clear when you track the numbers. The problem is that most gear owners never set up a real tracking system. They check Sharegrid payouts occasionally, glance at their bank deposits, and have a general sense that they are making money. But they could not tell you which piece of equipment has earned the most, which is losing them money through depreciation, or whether their rental income has gone up or down compared to last quarter.
Tracking rentals is not about being obsessive with data. It is about having the information you need to make good decisions: what gear to buy next, what to sell before it loses more value, and what to price differently. This guide covers every method for tracking equipment rentals, from the simplest to the most comprehensive, so you can pick the approach that matches where you are right now.
What you actually need to track
Before picking a method, it helps to know what data matters. There are six categories of information that give you a complete picture of your rental business.
Transaction details
For every rental, you need: the equipment that went out, the rental start and end dates, the daily rate, any discounts applied (multi-day, promotional, or custom), the platform fee, and the net amount you actually received. The gap between your listed daily rate and what you net after fees and discounts is often 30% to 50%, so tracking gross bookings without tracking net payouts gives you a dangerously optimistic picture of your earnings.
Equipment registry
A list of everything you own, what you paid for it, and when you bought it. This is the foundation for every return on investment calculation. Without purchase costs, you cannot calculate payback percentage, and payback percentage is the single most important metric for a rental equipment owner.
Renter information
Who rented your gear, how many times they have booked, and how much total revenue each renter has generated. This data tells you which relationships to invest in and when it might make sense to offer direct bookings to your most frequent renters.
Fee breakdowns
Platform fees, multi-day discounts, promotional discounts, and any other deductions from your gross rental amount. These are not just line items on an invoice. They are costs that accumulate significantly over time and affect the true profitability of each piece of equipment.
Maintenance and condition notes
Tracking the condition of your gear over time helps you anticipate repair costs, justify damage claims, and decide when to sell before an item's value drops further. Even simple notes like "scuff on bottom plate, appeared after rental #14" are valuable.
Off-platform rentals
If you rent gear directly to repeat clients, through word of mouth, or on other platforms, those transactions need to live in the same tracking system as your Sharegrid rentals. Otherwise you are only seeing part of your business.
Method 1: Pen and paper
This sounds outdated, but some owners do start here. A notebook with rental dates, amounts, and equipment names. It has one advantage: zero setup time. You write down the details after each rental and move on.
The problems surface quickly. You cannot sort or filter entries. You cannot calculate totals without manually adding numbers. You cannot see trends over time. And if you lose the notebook, you lose everything. Pen and paper works for your first five rentals. After that, you need something with at least basic calculation ability.
Method 2: Spreadsheets
This is where the vast majority of equipment rental owners land, at least initially. Google Sheets or Excel. A row per rental, columns for equipment name, dates, daily rate, total earned, fees, net payout, and renter name. It is flexible, free, and you can add formulas to calculate things like total earnings per item and monthly revenue.
Spreadsheets work well for the first three to six months. The problems emerge as your inventory and rental volume grow.
Manual data entry is tedious and error-prone. Every rental requires you to open Sharegrid, find the transaction details, and type them into your sheet. For multi-item rentals, you need to figure out how to allocate revenue across individual pieces of equipment, because Sharegrid's export lumps them together.
Formulas break silently. As you add rows, delete items, or restructure your sheet, cell references shift. A formula that was calculating your Canon C70's total earnings might now be pulling from the wrong range. The number still looks plausible, so you do not catch the error until months later.
No automatic fee calculation. Sharegrid's shoot-day pricing model and multi-day discounts make net earnings calculations more complex than a simple percentage deduction. Building formulas that accurately replicate Sharegrid's fee structure requires understanding the platform's pricing tiers and discount rules.
No depreciation tracking. Knowing what each item has earned is only half the picture. You also need to know what each item is worth today, accounting for depreciation. Spreadsheets can theoretically model depreciation curves, but building and maintaining those formulas is a project in itself.
If you want to start with a spreadsheet and see how far it takes you, we have a detailed breakdown of what columns to include and what formulas to use. Most owners use spreadsheets for six to twelve months before either abandoning tracking entirely or moving to dedicated software.
Method 3: Platform dashboards
Sharegrid has its own earnings dashboard that shows your rental history, payouts, and basic transaction details. The advantage is that the data is already there. No manual entry required for on-platform rentals.
The limitations are significant, though. The dashboard shows you what happened on Sharegrid and nothing else. It does not track your equipment purchase costs, so it cannot calculate return on investment. It does not break down multi-item rentals to the individual equipment level. It does not track off-platform rentals. And the analytics are limited to basic payout summaries. We have done a full comparison of Sharegrid's dashboard versus dedicated analytics tools if you want the details.
A platform dashboard is a good data source but not a complete tracking solution.
Method 4: Dedicated rental analytics software
This is the category that has emerged specifically for equipment rental owners who need more than a spreadsheet but less than enterprise rental management software designed for large rental houses.
The defining feature of dedicated analytics software is automated data ingestion. Instead of manually entering each rental, you import your data (typically via CSV export from Sharegrid) and the software handles the parsing, fee calculation, and per-item allocation.
Rental IQ is one example. You import your Sharegrid CSV and it automatically calculates net earnings per item, tracks payback percentage against your purchase costs, estimates current equipment value based on depreciation curves, and provides a revenue dashboard that shows your complete rental business at a glance. For rentals that happen outside of Sharegrid, a manual transaction entry feature lets you log off-platform bookings so everything lives in one place.
The tradeoff with dedicated software is that it costs money (though some tools, including Rental IQ, offer free tiers during beta). Whether the cost is justified depends on the size of your rental operation. If you have five items and get two to three rentals a month, a spreadsheet might be fine. If you have fifteen or more items generating eight or more rentals a month, the time savings and analytical depth of dedicated software will pay for itself.
How to choose the right method
The right tracking method depends on where you are in your rental business.
Just getting started (one to five items, under five rentals per month). A simple spreadsheet is sufficient. Track the basics: equipment, dates, net earnings, renter. Do not over-engineer it. The goal at this stage is to build the habit of tracking, not to build a perfect system.
Growing actively (five to fifteen items, five to fifteen rentals per month). This is the point where spreadsheets start to buckle. Manual entry takes real time, and the analytics you need (per-item return on investment, payback progress, renter analysis) are cumbersome to build in a spreadsheet. Consider moving to dedicated software. The time you save on data entry can be spent on growing your business.
Established operation (fifteen or more items, fifteen or more rentals per month). At this volume, you need automated data ingestion, per-item resolution for multi-item bookings, and ongoing analytics that update without manual intervention. A spreadsheet is a liability at this scale because the cost of errors and missed insights exceeds the cost of proper tooling.
Multiple rental channels (Sharegrid plus direct bookings). The moment you start renting off-platform, your tracking system must handle multiple data sources. This is where most spreadsheets are abandoned, because consolidating data from Sharegrid exports, Venmo receipts, and text message agreements into a single sheet is tedious enough that most people stop doing it. A tool that handles both automated imports and manual entries is the only realistic solution.
The real cost of not tracking
Owners who do not track their rentals make three predictable mistakes.
They keep unprofitable gear too long. Without per-item earnings data, you cannot identify which items are underperforming. A lens that has earned $200 in twelve months on a $2,000 purchase is a bad investment, but you will not know that without tracking. By the time you realize it, the lens has depreciated further and your selling window has narrowed.
They buy the wrong gear. Purchase decisions should be informed by rental demand data. If your 24-70mm lens rents four times as often as your 70-200mm, that information should influence your next purchase. Without tracking, you are buying based on assumptions instead of evidence.
They undercharge. Without data on your effective daily rate after all fees and discounts, you might be listing gear at prices that leave you with razor-thin margins or negative returns after accounting for depreciation. Tracking your actual net-per-day earnings shows you which items need price adjustments.
Getting started today
If you are not currently tracking your rentals, here is the fastest path to getting started.
First, export your Sharegrid rental history as a CSV. This gives you every transaction with dates, amounts, and equipment details.
Second, create a list of every piece of rental equipment you own, along with the purchase price and purchase date. Pull these from email receipts or credit card statements.
Third, decide on your method. If you want to start with a spreadsheet, do it. If you want to skip the spreadsheet phase and go directly to dedicated software, import your CSV into Rental IQ and enter your purchase costs. Either way, you will have more financial clarity about your rental business within an hour than most owners have after years of renting.
The tracking method matters less than the decision to track at all. Once you start measuring, you start making better decisions. And in a business built on expensive depreciating assets, better decisions are worth real money.
