Most equipment rental owners start tracking their business in a spreadsheet. It makes sense. Google Sheets is free, familiar, and flexible. You open a blank sheet, start adding columns, and within twenty minutes you have something that looks like a rental tracking system.
The problem is not the spreadsheet itself. The problem is that most people build their spreadsheet wrong. They track gross income instead of net. They forget to account for multi-day discounts. They do not include equipment costs, so they can never calculate return on investment. Six months in, the spreadsheet is either abandoned or giving them inaccurate data.
This guide walks you through building a rental tracking spreadsheet that actually works. Every column you need, the formulas that matter, and the honest limitations that will eventually push you beyond spreadsheets entirely.
The essential columns
A useful rental tracking spreadsheet needs twelve columns. Fewer than this and you are missing data that matters. More than this and you are creating maintenance overhead that will cause you to stop updating it.
Here are the twelve columns, in order.
| Column | Example | Purpose |
|---|---|---|
| Transaction ID | SG-12345 | Unique identifier from Sharegrid or your own numbering |
| Equipment Name | Sony FX6 | The specific item rented |
| Renter Name | Jane Doe | Who rented it |
| Rental Start Date | 2026-03-10 | First day of rental |
| Rental End Date | 2026-03-14 | Last day of rental |
| Calendar Days | 5 | Number of days (end minus start plus one) |
| Daily Rate | $250 | Your listed rate per day |
| Gross Amount | $875 | What the booking was worth before deductions |
| Multi-Day Discount | $125 | Discount from shoot-day conversion or multi-day pricing |
| Platform Fee | $112.50 | Sharegrid's 15% owner service fee |
| Other Discounts | $0 | Promo codes, custom discounts |
| Net Earnings | $637.50 | What actually hit your account |
The most important column is the last one: Net Earnings. This is the number that matters for every calculation you will ever do. If you track nothing else, track net earnings per rental.
Setting up the equipment registry
Before you start logging rentals, create a second tab called "Equipment" with four columns.
| Equipment Name | Purchase Date | Purchase Price | Category |
|---|---|---|---|
| Sony FX6 | 2025-06-15 | $5,998 | Camera Body |
| Canon 24-70mm f/2.8 III | 2025-07-01 | $2,399 | Lens |
| Atomos Ninja V+ | 2025-08-20 | $499 | Monitor |
This registry is the foundation for every return on investment calculation. Without purchase prices, you know what each item has earned but not whether that earning is good or bad relative to what you invested.
Use the Equipment Name column as the link between your two tabs. Keep the names consistent. "Sony FX6" on the rental log should match "Sony FX6" on the equipment registry exactly. Inconsistent naming is the number one source of formula errors in rental tracking spreadsheets.
The formulas that matter
Once your structure is in place, add these calculated columns and summary formulas.
Calendar days
In the rental log, calculate the number of days automatically:
=DAYS(E2, D2) + 1
Where E2 is the end date and D2 is the start date. The plus one accounts for the fact that a rental from Monday to Friday is five calendar days, not four.
Net earnings per day
Add a column for effective daily rate:
=L2 / F2
Where L2 is net earnings and F2 is calendar days. This tells you what each calendar day of rental actually earned after all deductions. This number is often much lower than your listed daily rate. A $250/day camera on a five-day rental might net you $127 per calendar day after shoot-day conversion, discounts, and the platform fee. That gap between $250 and $127 is important to understand.
Total earnings per item
On your Equipment tab, add a column that sums all net earnings for each item:
=SUMIF(Rentals!B:B, A2, Rentals!L:L)
This pulls every rental logged against that equipment name and totals the net earnings. Now you can see at a glance which items are your top earners.
Payback percentage
This is the most useful metric for any rental equipment owner. Add this column to the Equipment tab:
=SUMIF(Rentals!B:B, A2, Rentals!L:L) / C2
Where C2 is the purchase price. This gives you a percentage representing how much of the purchase cost you have recovered through rental income. An item at 65% payback has earned back 65 cents of every dollar you spent on it.
Number of rental days
=SUMIF(Rentals!B:B, A2, Rentals!F:F)
This tells you how many total calendar days each item has been out on rental. Combined with the time since purchase, you can calculate utilization rate, which is another metric that helps identify underperforming gear.
Monthly revenue summary
Create a third tab called "Monthly Summary" and use this formula to total net earnings by month:
=SUMPRODUCT((YEAR(Rentals!D:D)=2026)*(MONTH(Rentals!D:D)=3)*(Rentals!L:L))
Change the year and month values for each row. This gives you a monthly revenue trend line that shows whether your rental business is growing, flat, or declining.
Handling multi-item rentals
This is where spreadsheets start to get painful. On Sharegrid, when a renter books a camera body, lens, and monitor together, the platform generates one transaction for the bundle. The gross amount is the total for all items. But for tracking purposes, you need to know what each individual item earned.
There are two approaches.
Proportional allocation. Divide the net earnings across items based on their listed daily rates. If the camera is listed at $250/day, the lens at $100/day, and the monitor at $50/day, the camera gets 62.5% of the net payout, the lens gets 25%, and the monitor gets 12.5%. This is approximate but consistent.
Email confirmation breakdown. Sharegrid confirmation emails typically list per-item amounts. If you have those emails, you can use the actual per-item figures instead of estimating. This is more accurate but requires looking up the email for every multi-item rental.
In your spreadsheet, log multi-item rentals as separate rows, one per item, with the same Transaction ID. Add a note in a "Notes" column indicating it was part of a multi-item booking. This keeps your per-item earnings calculations accurate.
Tracking Sharegrid fees accurately
Sharegrid charges a 15% owner service fee, but the effective cost is higher than 15% because the fee applies after shoot-day conversion and multi-day discounts. Here is how it works.
A five-calendar-day rental does not bill at five times the daily rate. Sharegrid uses a shoot-day pricing model where longer rentals are converted to fewer billable shoot days. The exact conversion varies, but a five-calendar-day rental might bill at 3.5 shoot days. Then the 15% fee is applied to that reduced amount.
In your spreadsheet, do not try to reverse-engineer the fee from the daily rate and calendar days. Instead, look at the actual payout in your Sharegrid transaction history and record the real numbers. The gross amount, the fee amount, and the net payout are all visible in Sharegrid's transaction details. Use those actual figures.
If you want to understand how Sharegrid's pricing model works in detail, we have a full breakdown of how Sharegrid fees, payouts, and net earnings actually work.
The limitations you will hit
A well-built spreadsheet can serve you for six to twelve months. But there are fundamental limitations that no amount of formula work can fix.
No automatic data import
Every single rental must be entered by hand. At five rentals per month, this is manageable. At fifteen rentals per month, you are spending an hour or more each month just on data entry. The cumulative friction causes most people to fall behind and eventually stop updating.
No depreciation modeling
Equipment loses value over time. Camera bodies depreciate faster than lenses. Depreciation rates vary significantly across equipment categories. Building depreciation curves into a spreadsheet is technically possible but requires ongoing formula maintenance and assumptions about market values that change constantly.
Without depreciation tracking, you cannot calculate total return on investment. An item might have earned $3,000 in rental income, but if it has also lost $4,000 in value, your net position is negative. A spreadsheet that only tracks earnings gives you a misleadingly positive picture.
No multi-source consolidation
The moment you start renting gear off-platform, whether through direct bookings, word of mouth, or other platforms, your spreadsheet becomes incomplete unless you manually add those transactions too. Most people are willing to enter Sharegrid data because they can copy from the platform. Entering off-platform rentals from memory or text messages is another level of friction.
No renter analytics
A spreadsheet can show you a list of renters, but building formulas to rank renters by total revenue, identify repeat bookers, and track renter frequency over time is complex enough that most people never do it. These are the kinds of insights that help you decide when to offer direct booking relationships to your best clients.
No visual analytics
Charts in Google Sheets exist, but they require manual setup and do not update cleanly as your data grows. A revenue trend chart or equipment comparison view that would take seconds to generate in dedicated software takes significant effort to build and maintain in a spreadsheet.
When to graduate from spreadsheets
Here are the signals that it is time to move beyond a spreadsheet.
You have not updated it in over a month. This is the clearest signal. If the friction of manual entry has caused you to fall behind, the spreadsheet is no longer serving its purpose. Data you do not enter is data you do not have.
You rent more than ten items. The per-item formulas, multi-item allocation, and equipment registry become unwieldy past ten to fifteen items. Errors creep in. Maintenance time increases.
You rent on multiple channels. The first off-platform rental you forget to log is the beginning of the end for your spreadsheet's accuracy.
You need return on investment answers, not just revenue totals. If you want to know payback timelines, depreciation-adjusted returns, or which items to sell before they lose more value, you need more analytical depth than a spreadsheet practically offers.
The next step is dedicated rental analytics software. Rental IQ imports your Sharegrid CSV automatically, breaks down multi-item rentals to the individual equipment level, calculates per-item net earnings and payback percentage, and provides a revenue dashboard with the visual analytics that spreadsheets cannot match. It also handles return on investment calculations including depreciation estimates, so you see total return rather than just earnings.
Start with the spreadsheet if that is where you are
A spreadsheet is better than nothing. If you are not currently tracking your rentals at all, building the template described in this guide will give you more financial visibility than most equipment owners have. Use it. Update it. Let it show you things about your rental business that you could not see before.
And when the spreadsheet stops working, because it will, you will have developed the tracking habit and the data awareness that makes the transition to better tools seamless. The columns and metrics in this guide are the same ones that dedicated analytics software tracks. The difference is that the software does the work for you.
