Template
Equipment Tracking Spreadsheet:Register Columns, Check-Out Log, EDATE Service-Due Formulas, OSHA Test Intervals, Florida Property Return Totals and a Filled Tampa Drain Shop Register
Equipment tracking spreadsheet: register and check-out columns, EDATE service-due formulas, OSHA test intervals and a filled Tampa plumbing shop register.
An equipment tracking spreadsheet is a register of the tools and machines a business owns, one row per item: its serial number, location, holder, last service and next service due, with a second tab that logs each check-out and return. The filled register belongs to a plumbing and drain shop in Tampa, Florida.
The layout is one of the free field service templates kept by FieldRanger, field service software that runs inside HubSpot. The page offers the column and formula tables as a free .xlsx download with no sign-up: the Register columns on a Template sheet from row 4, with Log, Return, Productivity and Sample tabs. Service intervals come from OSHA's rules where a rule sets one, and the cost and year columns feed Florida's tangible personal property return.
Equipment and inventory: returned assets and consumed stock
Equipment comes back. A sewer camera leaves on a truck in the morning and returns in the evening, and its row records who held it and in what condition. Inventory does not come back: a P-trap or a tube of sealant is consumed on the job, and its record is a count that falls. The register below tracks the first kind only.
The two records answer different questions. The equipment register asks where an item is and whether it is fit to use. A warehouse inventory tracking spreadsheet asks how many of an item remain and when to reorder. Mixing them in one sheet produces a row for each fitting, with a serial number cell left blank on every one.
Equipment tracking spreadsheet columns and formulas
The Register tab holds one row per item, headers in row 3 and the first item in row 4. The formulas are shown for row 4 and copy down. The Log tab, described in the next section, supplies the check-out columns.
| Column | Header | Contents | Formula |
|---|---|---|---|
| A | Asset ID | A permanent number, painted or labeled on the item | Typed |
| B | Category | Drain, inspection, power tool, electrical, safety, access | Typed |
| C | Description | What the item is, in plain words | Typed |
| D | Make and model | From the data plate | Typed |
| E | Serial number | From the data plate | Typed |
| F | Year acquired | Four-digit year | Typed |
| G | Original cost | Price paid, including installation or setup | Typed |
| H | Home location | Yard, Truck 1, Truck 2 or Truck 3 | Typed |
| I | Status | In, Out or Retired | =IF(T4<>"","Retired",IF(COUNTIFS(Log!$B:$B,A4,Log!$F:$F,"")>0,"Out","In")) |
| J | Held by | The technician with the item, or its home location | =IF(I4="Out",XLOOKUP(1,(Log!$B$2:$B$999=A4)*(Log!$F$2:$F$999=""),Log!$C$2:$C$999,"",0,-1),H4) |
| K | Due back | The return date on the open check-out | =IF(I4="Out",XLOOKUP(1,(Log!$B$2:$B$999=A4)*(Log!$F$2:$F$999=""),Log!$E$2:$E$999,"",0,-1),"") |
| L | Return flag | Late when the due-back date has passed | =IF(AND(I4="Out",K4<TODAY()),"Late","") |
| M | Last service | Date of the last inspection, test or service | Typed |
| N | Interval, months | From the rule or the manufacturer's manual | Typed |
| O | Next service due | Last service plus the interval | =IF(M4="","",EDATE(M4,N4)) |
| P | Days to due | Negative once overdue | =IF(O4="","",O4-TODAY()) |
| Q | Service flag | Overdue, due within 14 days, or OK | =IF(O4="","",IF(O4<TODAY(),"Overdue",IF(P4<=14,"Due in 14 days","OK"))) |
| R | Interval source | The rule or manual section that sets column N | Typed |
| S | Condition | Good, avg or poor | Typed |
| T | Disposed | Date, and to whom it was sold, traded or scrapped | Typed |
EDATE "returns the serial number that represents the date that is the indicated number of months before or after a specified date" (Microsoft Support, EDATE function, checked November 12, 2026). A service on August 15 with a 3-month interval falls due on November 15. Column O is formatted as a date, or it shows the serial number.
XLOOKUP's last argument, -1, searches from the bottom of the log, so column J returns the latest open check-out for the item. Column R exists so that an interval can be defended: "29 CFR 1926.404(b)(1)(iii)(E)" or "manual, section 6" explains a 3-month entry where a bare number does not.
Tool movement log: check-outs and returns
The Log tab keeps one row per movement, with headers in row 1. A row opens when an item leaves and closes when the date in is entered. Rows are never deleted; a returned item gains a date, not a new row.
| Column | Header | Contents | Formula |
|---|---|---|---|
| A | Date out | Date the item left its home location | Typed |
| B | Asset ID | Matches column A of the Register | Typed |
| C | Technician | Name of the person who took it | Typed |
| D | Job number | The job the item went to | Typed |
| E | Due back | Agreed return date | Typed |
| F | Date in | Blank while the item is out | Typed |
| G | Condition in | Good, avg or poor, with a note on damage | Typed |
| H | Days out | Running count while out, final count once back | =IF(F2="",TODAY()-A2,F2-A2) |
The job number column ties the item to the work. When a drain machine comes back with a kinked cable, the log names the job, the date and the technician who had it.
Service intervals set by OSHA rules
Two federal rules give intervals that a plumbing shop's register can carry exactly. Other intervals come from the manufacturer's manual, and column R says which.
Cord sets on construction work follow 29 CFR 1926.404. The employer uses either ground-fault circuit interrupters or "an assured equipment grounding conductor program" (OSHA, 29 CFR 1926.404, checked November 12, 2026). Under the program, each cord set is tested before first use, after any repair, after an incident that may have damaged it, and "at intervals not to exceed 3 months"; fixed cord sets not exposed to damage are tested at intervals not exceeding 6 months. Tests "shall be recorded", and the record is kept "until replaced by a more current record". The sample shop runs the program, so each cord set has its own row with a 3-month interval.
Portable fire extinguishers provided for employees follow 29 CFR 1910.157. They are visually inspected monthly and "subjected to an annual maintenance check", and the employer records the annual maintenance date and keeps the record for one year after the last entry or the life of the shell, whichever is less (OSHA, 29 CFR 1910.157, checked November 12, 2026). Table L-1 of the same section sets a 12-year hydrostatic test interval for stored-pressure dry chemical extinguishers with mild steel shells. The register's interval is the annual check; the monthly visual inspection is a tick on the truck checklist.
Filled equipment register: plumbing and drain shop in Tampa, Florida
The shop has three technicians and a yard. The register is read on November 12, 2026, so TODAY() returns that date. The business, items, costs, technicians and the manufacturer intervals are samples; the OSHA intervals come from the rules cited above.
| Asset ID | Description | Year | Cost | Status, held by | Last service | Interval | Next due | Days | Flag |
|---|---|---|---|---|---|---|---|---|---|
| EQ-101 | Sewer inspection camera, 200 ft reel | 2023 | $9,850 | Out, M. Lee, J-8841 | May 4, 2026 | 12 (manual) | May 4, 2027 | 173 | OK |
| EQ-102 | Water jetter, cart-mounted, 4,000 psi | 2022 | $7,480 | In, Yard | Aug 15, 2026 | 3 (manual) | Nov 15, 2026 | 3 | Due in 14 days |
| EQ-103 | Sectional drain machine | 2021 | $3,480 | Out, D. Ortiz, J-8850 | Feb 10, 2026 | 6 (manual) | Aug 10, 2026 | -94 | Overdue |
| EQ-104 | Drum drain machine | 2024 | $2,150 | Out, S. Patel, J-8853 | Jul 1, 2026 | 6 (manual) | Jan 1, 2027 | 50 | OK |
| EQ-105 | Power drive pipe threader | 2019 | $2,900 | In, Yard | Dec 3, 2025 | 12 (manual) | Dec 3, 2026 | 21 | OK |
| EQ-106 | Press tool kit | 2025 | $3,650 | Out, M. Lee, J-8841 | Mar 20, 2026 | 12 (manual) | Mar 20, 2027 | 128 | OK |
| EQ-107 | Portable generator, 7,500 W | 2020 | $1,890 | In, Yard | Jun 30, 2026 | 6 (manual) | Dec 30, 2026 | 48 | OK |
| EQ-108 | Extension cord set, 50 ft, 12/3 | 2025 | $96 | Out, D. Ortiz, J-8850 | Aug 4, 2026 | 3 (1926.404) | Nov 4, 2026 | -8 | Overdue |
| EQ-109 | Fire extinguisher, 10 lb dry chemical | 2022 | $85 | In, Truck 1 | Dec 9, 2025 | 12 (1910.157) | Dec 9, 2026 | 27 | OK |
| EQ-110 | Extension ladder, 28 ft fiberglass | 2023 | $520 | Out, S. Patel, J-8853 | Oct 1, 2026 | 3 (shop policy) | Jan 1, 2027 | 50 | OK |
| EQ-111 | Pipe locator and sonde | 2024 | $4,200 | Out, M. Lee, J-8841 | Apr 14, 2026 | 12 (manual) | Apr 14, 2027 | 153 | OK |
| EQ-095 | Sectional drain machine, replaced by EQ-103 | 2016 | $2,600 | Retired | Traded to dealer, Apr 18, 2026 |
Two rows need action. EQ-103 is 94 days past its service date and is out on job J-8850; the dispatcher swaps it for EQ-104 at the next stop rather than recalling the technician. EQ-108 is 8 days past its 3-month test, so under the shop's grounding program it may not be used until tested. The same technician holds both, which the filter on column J shows in one step.
| Date out | Asset ID | Technician | Job | Due back | Date in | Days out |
|---|---|---|---|---|---|---|
| Nov 12, 2026 | EQ-101 | M. Lee | J-8841 | Nov 12, 2026 | 0 | |
| Nov 12, 2026 | EQ-106 | M. Lee | J-8841 | Nov 12, 2026 | 0 | |
| Nov 12, 2026 | EQ-111 | M. Lee | J-8841 | Nov 12, 2026 | 0 | |
| Nov 10, 2026 | EQ-103 | D. Ortiz | J-8850 | Nov 13, 2026 | 2 | |
| Nov 10, 2026 | EQ-108 | D. Ortiz | J-8850 | Nov 13, 2026 | 2 | |
| Nov 11, 2026 | EQ-104 | S. Patel | J-8853 | Nov 12, 2026 | 1 | |
| Nov 11, 2026 | EQ-110 | S. Patel | J-8853 | Nov 12, 2026 | 1 |
Florida tangible personal property return from the register
Florida taxes business equipment, and the register's cost and year columns are the return's raw material. The Department of Revenue states that anyone who owns tangible personal property on January 1 and has a proprietorship, partnership or corporation files Form DR-405 "to the property appraiser by April 1 each year" (Florida Department of Revenue, Tangible Personal Property, checked November 12, 2026). A timely return makes the owner eligible for an exemption of up to $25,000 of assessed value. Failure to file carries a penalty of 25 percent of the tax; late filing costs 5 percent a month, up to 25 percent; and unlisted property draws 15 percent of the tax on what was omitted.
The form sets the register's rules. DR-405 asks for all property owned, "including fully depreciated items still in use", with "an attached, itemized list with original cost and date acquired for each item", and its instructions name "tools" and "machines" among the property to report (Form DR-405, R. 01/18, Rule 12D-16.002, F.A.C.). Page 2 of the form also lists assets removed during the year, by description, year acquired, original cost and to whom they went: the register's column T. Its condition codes, good, avg and poor, are the codes in column S. The Department's definition of tangible personal property excludes "some vehicular items", and the shop's trucks stay in its fleet records rather than the register.
A Return tab totals cost by year acquired with =SUMIFS(Register!$G:$G,Register!$F:$F,A2,Register!$T:$T,""), with the year in column A.
| Year acquired | Items | Original cost |
|---|---|---|
| 2019 | EQ-105 | $2,900 |
| 2020 | EQ-107 | $1,890 |
| 2021 | EQ-103 | $3,480 |
| 2022 | EQ-102, EQ-109 | $7,565 |
| 2023 | EQ-101, EQ-110 | $10,370 |
| 2024 | EQ-104, EQ-111 | $6,350 |
| 2025 | EQ-106, EQ-108 | $3,746 |
| Total | 11 items | $36,301 |
| Removed during 2026 | EQ-095, traded to dealer | $2,600 |
The return for January 1, 2027 goes to the Hillsborough County Property Appraiser by April 1, 2027. Whether tax is due depends on the appraiser's assessed value against the $25,000 exemption, not on the $36,301 of cost; filing on time is what preserves the exemption.
Disposal rows and the IRS retention rule
A retired item keeps its row. The IRS advises keeping records relating to property until the period of limitations expires for the year in which the property is disposed of (IRS, How long should I keep records, reviewed June 30, 2026). EQ-095 was traded in April 2026, so its purchase cost, year and disposal entry stay in the register until that period runs out for the 2026 return. Deleting the row would also remove it from the DR-405 list of assets removed during the year.
Technician productivity spreadsheet tab
A technician productivity spreadsheet sits beside the register because the same jobs drive both. One row per technician per week compares hours on jobs with hours paid, and revenue with both.
| Column | Header | Contents | Formula |
|---|---|---|---|
| A | Week starting | Sunday of the workweek | Typed |
| B | Technician | Name | Typed |
| C | Jobs completed | Count from the job records | Typed |
| D | Hours on jobs | Clock time logged against jobs | Typed |
| E | Hours paid | From the timesheet | Typed |
| F | Utilization | Share of paid hours spent on jobs | =IF(E2=0,"",D2/E2) |
| G | Revenue | Invoiced on the week's jobs | Typed |
| H | Revenue per job hour | =IF(D2=0,"",G2/D2) | |
| I | Revenue per job | =IF(C2=0,"",G2/C2) | |
| J | Items checked out | Count of Log rows for the week | =COUNTIFS(Log!$C:$C,B2,Log!$A:$A,">="&A2,Log!$A:$A,"<"&A2+7) |
| Technician | Jobs | Hours on jobs | Hours paid | Utilization | Revenue | Per job hour | Per job |
|---|---|---|---|---|---|---|---|
| D. Ortiz | 14 | 31.5 | 42.0 | 75.0% | $5,880 | $186.67 | $420.00 |
| M. Lee | 11 | 33.0 | 40.0 | 82.5% | $6,270 | $190.00 | $570.00 |
| S. Patel | 16 | 29.0 | 41.5 | 69.9% | $4,930 | $170.00 | $308.13 |
The three ratios separate three different explanations. S. Patel completes 16 jobs, the highest count, at the lowest revenue per job, which points at small drain calls rather than at idle time. M. Lee logs 33.0 hours on jobs, the highest of the three, and carries the camera and locator, the two items that turn a drain call into an inspection. Paid hours for column E come from the timesheet; the tracking overtime spreadsheet builds them from clock-in and clock-out times.
Equipment tracking software and the register
The spreadsheet depends on someone typing every movement. A check-out that is not logged leaves column J naming the yard while the camera sits on a truck.
In FieldRanger, equipment is checked in and out by scanning its QR code on a phone, and each item is assigned to jobs and technicians. An availability calendar shows when equipment is free and prevents double-booking, maintenance is scheduled and tracked for each item, and the usage history is an audit trail of who used which equipment and when. Items are organized by type, location and department, depreciation tracking follows asset value for replacement planning, and any report downloads as CSV or Excel. Technician performance reports show completion rates, on-time arrivals and productivity by technician. The equipment tracking software page describes the equipment record.
FieldRanger keeps consumed stock separately: technicians check parts and materials out of a specific warehouse, and materials used are logged against each job. Each technician's truck can also be its own stock location. An item's location comes from its last scan or assignment, and the exported register is the source for the itemized list on Florida's DR-405.
Frequently asked questions
How to track equipment in an Excel spreadsheet?
Keep one row per item with an asset ID, description, serial number, year acquired, cost, home location, last service date and service interval, and compute the next due date with =EDATE(last service, months). A separate log tab records each check-out with the date, technician, job and return date, and COUNTIFS on that log sets each item's status to In or Out.
Is there a free equipment tracking spreadsheet template for Excel?
Yes. The page offers a free .xlsx download with no sign-up: the Register columns and formulas on a Template sheet from row 4, the Log, Return and Productivity tabs, and a Sample sheet with the Tampa register.
What is the difference between equipment tracking and inventory tracking?
Equipment tracking follows items that return after use, such as a drain machine or a ladder, by location, holder and service date. Inventory tracking counts items consumed on jobs, such as fittings and sealant, by quantity on hand and reorder point.
What is the OSHA test interval for extension cords?
Where an employer uses an assured equipment grounding conductor program on construction work instead of GFCIs, 29 CFR 1926.404 requires tests before first use, after repairs, after suspected damage and at intervals not exceeding 3 months, or 6 months for fixed cord sets not exposed to damage, with each test recorded.
Does a Florida business have to report its equipment for property tax?
An owner of tangible personal property on January 1 files Form DR-405 with the county property appraiser by April 1, listing equipment with its original cost and year acquired. Filing on time preserves an exemption of up to $25,000 of assessed value.
What goes in a technician productivity spreadsheet?
One row per technician per week with jobs completed, hours on jobs, hours paid, utilization as hours on jobs divided by hours paid, revenue, revenue per job hour and revenue per job.
EQ-108 and the April 1 return
Two dates on this register outrank the rest. EQ-108, a $96 cord set, cannot go back on a job until its overdue test is recorded in column M. April 1, 2027 is the DR-405 deadline for the $36,301 of equipment in the Return tab and the trade-in of EQ-095. A shop that would rather scan than type can compare plans on pricing and use Start free trial, 14 days without a card; the other spreadsheets in this set are listed in the free field service templates.
FieldRanger runs field service inside HubSpot
Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.
Book a demo