{"product_id":"equipment-rental-tracker-spreadsheet","title":"Equipment Rental Tracker Spreadsheet","description":"\u003cp\u003eThis equipment rental tracker is for tool hire, plant hire and equipment rental businesses that want to know which items are paying their way. It sets what each piece of kit has earned against what it cost you, and keeps the rest of the books for the year in the same workbook.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eA fleet tracker for every item\u003c\/h2\u003e\u003cp\u003eA rental business has one question: is this thing paying for itself? The answer is what the item earned divided by what it cost, a sum nobody does because the two numbers usually live in different places. The Fleet tab brings them together, so it works as an asset tracker for your rental inventory.\u003c\/p\u003e\u003ch2\u003eLines written for a hire yard\u003c\/h2\u003e\u003cp\u003eThe ledger opens on categories a tool rental business uses, not product sales and service income.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome lines:\u003c\/strong\u003e Hire income, Delivery and collection, Damage and fuel charges, and Consumables sold\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpense lines:\u003c\/strong\u003e Plant purchases, Servicing and repairs, Yard rent and utilities, and Testing and compliance, and more\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMileage reasons:\u003c\/strong\u003e delivery, collection, service call and auction, chosen from a drop-down\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTwelve connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Fleet, Clients, Income, Expenses, Mileage, Monthly, Quarterly, Profit and Loss, Balances and Dashboard.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e500 income rows and 500 expense rows\u003c\/li\u003e\n\u003cli\u003eMileage with your own reasons and the year totaled\u003c\/li\u003e\n\u003cli\u003eMonthly and quarterly totals, which is how tax gets filed\u003c\/li\u003e\n\u003cli\u003eA profit and loss built from the same two lists\u003c\/li\u003e\n\u003cli\u003e10 client records showing what each customer has been worth\u003c\/li\u003e\n\u003cli\u003eAccount balances, so the file knows what the business holds\u003c\/li\u003e\n\u003cli\u003eA dashboard that reads all of it\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA worked year and a blank copy\u003c\/h2\u003e\u003cp\u003eThe filled copy runs a full year with 304 income entries and 440 expense entries at a 17.7% margin. The blank copy is ready for your own fleet, and the Start Here tab walks you through setup in a few minutes.\u003c\/p\u003e\u003cp\u003eThis is a bookkeeping spreadsheet, not an accountant. Tax rates and what you can claim are yours to set and yours to check.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel workbooks: the filled example and a blank one\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready the moment payment clears, for personal and business use on your own devices. Please do not share or resell them. Questions? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbooks run on Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I see whether each item has paid for itself?\u003c\/h3\u003e\u003cp\u003eYes. The Fleet tab sets what each item has earned against what it cost, so you can see which kit is paying its way.\u003c\/p\u003e\u003ch3\u003eCan I charge for damage, fuel and delivery?\u003c\/h3\u003e\u003cp\u003eThose charges have their own income lines: Delivery and collection, and Damage and fuel charges, next to Hire income and Consumables sold.\u003c\/p\u003e\u003ch3\u003eDoes it log delivery and collection trips?\u003c\/h3\u003e\u003cp\u003eYes. The Mileage tab has reasons such as delivery, collection, service call and auction, and totals the year.\u003c\/p\u003e\u003ch3\u003eWill it calculate my tax?\u003c\/h3\u003e\u003cp\u003eNo. It gives monthly and quarterly totals and a profit and loss. Tax rates and what you can claim are yours to set and check.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597869776990,"sku":"OPX-170","price":32.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/equipment-rental-tracker-spreadsheet-01.jpg?v=1790832896","url":"https:\/\/opxviashop.com\/products\/equipment-rental-tracker-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}