{"product_id":"hvac-service-business-tracker-spreadsheet-maintenance-contract-renewals-visits-owed-jobs-and-revenue-google-sheets","title":"HVAC Service Business Tracker Spreadsheet | Maintenance Contract Renewals, Visits Owed, Jobs and Revenue - Google Sheets","description":"\u003cp\u003e\u003cstrong\u003eINSTANT DOWNLOAD — HOW IT WORKS:\u003c\/strong\u003e This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.\u003c\/p\u003e\u003cp\u003eNever let a maintenance contract lapse in silence.\u003c\/p\u003e\n\u003cp\u003eMaintenance agreements are the steady money in an HVAC business — and the easiest money to lose quietly. A renewal date slides past. A paid-for tune-up never gets scheduled. Nobody notices until the customer signs with someone else. This tracker watches all of it for you: every contract's renewal counts down on its own, and visits owed vs. done stay in front of you, so no paid-for visit is ever silently skipped and no renewal lapses unworked.\u003c\/p\u003e\n\u003cp\u003eLog each contract once, log visits and one-off jobs as they happen, and the Dashboard keeps score: which contracts renew in the next 30 days (sorted soonest first), how many plan visits you still owe across the book, and your revenue by type — contracts, repairs, and installs.\u003c\/p\u003e\n\u003cp\u003eTransparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT'S INSIDE — 6 focused tabs, not a 36-tab kit:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- \u003cstrong\u003eStart Here\u003c\/strong\u003e — a plain-English guide and quick-start steps\u003cbr\u003e- \u003cstrong\u003eDashboard\u003c\/strong\u003e — the renewing-soonest list, key numbers (active contracts, renewing in 30 days, visits still owed, contract value), and revenue by type\u003cbr\u003e- \u003cstrong\u003eService Contracts\u003c\/strong\u003e — every maintenance agreement: plan, start and renewal dates, visits included, contract price — with Visits Done, Visits Owed, Days to Renewal, and a Renewal Status flag that fill in by themselves\u003cbr\u003e- \u003cstrong\u003eVisit Log\u003c\/strong\u003e — one row per plan visit: date, customer, visit number, work done, tech, status. Only Completed visits count as done\u003cbr\u003e- \u003cstrong\u003eJob Log\u003c\/strong\u003e — one-off work outside the plans: repairs and installs with quoted, your parts + labor cost, invoiced, and Paid \/ Partial \/ Unpaid\u003cbr\u003e- \u003cstrong\u003eSettings\u003c\/strong\u003e — the plan list (Silver \/ Gold \/ Platinum \/ Custom) and the exact rules the sheet follows\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHOW IT WORKS\u003c\/strong\u003e\u003cbr\u003e1. After checkout you get a PDF with your private link. Click it and choose \"Make a copy\" — the tracker is yours.\u003cbr\u003e2. Add your contracts, then log visits and jobs as they happen. A minute a day is plenty.\u003cbr\u003e3. Read the Dashboard. Renewals counted down, visits owed, revenue by type — no formulas to build, nothing to maintain.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTHE RULES, IN PLAIN ENGLISH\u003c\/strong\u003e\u003cbr\u003eDays to Renewal is the renewal date minus today — it recalculates every morning. Renew soon means 30 days or less (change the threshold any time; the Settings tab shows where). A visit counts as done only when its status is Completed — scheduled and missed visits never inflate your numbers, and Visits Owed never drops below zero. Month-to-month plan? Set the contract status to Auto-renew and the countdown switches off. Revenue by type counts contract prices plus invoiced job amounts — not quotes — so a half-invoiced install only counts what you've actually billed.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHY THIS ONE\u003c\/strong\u003e\u003cbr\u003eThe big HVAC kits compete on tab count — 17 tabs, 36 tabs — and bury the one workflow that protects your recurring revenue in the middle of them. This one leads with it: contracts, renewals, and owed visits, front and center, in six tabs you'll actually open every week. It comes loaded with five fictional sample contracts (three houses, an HOA, an office) so you can watch every rule work before you replace them with your own customers.\u003c\/p\u003e\n\u003cp\u003eFINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eREQUIREMENTS:\u003c\/strong\u003e a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works at the office, in the truck, and on your phone.\u003c\/p\u003e\n\u003cp\u003eThis is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.\u003c\/p\u003e","brand":"InkSheet Studio","offers":[{"title":"Default Title","offer_id":68083109200157,"sku":null,"price":2.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1015\/0618\/7549\/files\/01-hero_60db382f-d2fe-4437-aa1d-db0379a42cd7.jpg?v=1794696363","url":"https:\/\/inksheetstudio.com\/products\/hvac-service-business-tracker-spreadsheet-maintenance-contract-renewals-visits-owed-jobs-and-revenue-google-sheets","provider":"InkSheet Studio","version":"1.0","type":"link"}