{"product_id":"auto-repair-shop-crm-live-dashboard","title":"Auto Repair Shop CRM + Live Dashboard (Digital Download)","description":"\u003cp\u003e\u003cstrong\u003eNot just a spreadsheet CRM. A live dashboard your whole team shares.\u003c\/strong\u003e Your CRM workbook comes with a live web dashboard: KPI tiles, goal gauges, charts and alerts that update with your numbers, built for your phone, with light and dark mode. Plus 3 team seats and the full Excel + Google Sheets workbook. One-time price, no monthly subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCar count, ARO, labor rate, declined work and tech productivity in one place, with the shop's goals you can see at a glance.\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eMade for auto repair shop owners and service managers. Log repair orders with advisor, tech, pay type, hours sold and actual hours, and see the numbers a service manager watches every day: sales, car count, ARO, effective labor rate, gross profit, comebacks and tech productivity. Declined work turns into a follow-up list, and vehicles due for service show up before they slip away.\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eAuto Repair Shop CRM + Live Dashboard - BLANK.xlsx (ready for your data)\u003c\/li\u003e\n\u003cli\u003eAuto Repair Shop CRM + Live Dashboard - SAMPLE.xlsx (filled with example data to explore)\u003c\/li\u003e\n\u003cli\u003eAccess card (PDF) with setup steps and a QR code to your live dashboard\u003c\/li\u003e\n\u003cli\u003eLive online dashboard for phone, tablet or computer\u003c\/li\u003e\n\u003cli\u003e3 team seats: you plus 2 teammates\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWhat it does\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eRepair orders with advisor, tech, pay type, hours sold and actual, labor, parts and sublet sales and costs, and comebacks\u003c\/li\u003e\n\u003cli\u003eCar count, ARO, effective labor rate, hours per RO, gross profit % and comeback rate\u003c\/li\u003e\n\u003cli\u003eTech productivity, proficiency and bay utilization, by tech\u003c\/li\u003e\n\u003cli\u003eDeclined work follow-up list, with recovered dollars when the work sells later\u003c\/li\u003e\n\u003cli\u003eCustomers, vehicles and retention, with vehicles due for service and not booked\u003c\/li\u003e\n\u003cli\u003eAppointments for the next 14 days, show rate and how they were booked\u003c\/li\u003e\n\u003cli\u003eGoal gauges for sales, car count, hours sold and labor rate, prorated by selling day\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eThe live dashboard\u003c\/h3\u003e\u003cp\u003eYour workbook's numbers as a live web dashboard: KPI tiles, goal gauges, charts and a needs-attention list across Overview, Repair Orders, Techs \u0026amp; Productivity, Declined Work, Customers \u0026amp; Retention, Appointments and Settings. Pick a date range, compare to the prior period, search, export to CSV or print. It works on phone, tablet and computer, in light or dark mode. Load your workbook and every page redraws with your data. If something in the workbook needs fixing, like an RO with hours sold but no tech, the dashboard tells you.\u003c\/p\u003e\u003ch3\u003eTeam seats\u003c\/h3\u003e\u003cp\u003eYour order includes 3 team seats: you (the account owner) plus 2 teammates. Add teammates by email from the Team panel; they sign in with that email and see the same dashboard. Whoever loads an updated workbook updates it for everyone, and the dashboard shows who updated it and when (\"updated by ... 5 min ago\"). If two people update at once, the second person is asked before replacing. Need more? \u003ca href=\"\/products\/crm-extra-team-seats\"\u003eExtra Team Seats\u003c\/a\u003e add 5 at a time, up to 25 in total.\u003c\/p\u003e\u003ch3\u003eHow it works\u003c\/h3\u003e\u003col\u003e\n\u003cli\u003eDownload your files right after checkout. Open the BLANK workbook in Excel, or upload it to Google Drive and open it with Google Sheets. The Start Here tab walks you through setup. Enter your business name and goals on the Settings tab.\u003c\/li\u003e\n\u003cli\u003eGo to \u003ca href=\"https:\/\/buckeye-planners.web.app\/pro-crm-auto-repair\"\u003ebuckeye-planners.web.app\/pro-crm-auto-repair\u003c\/a\u003e and sign in with an email link or Google, using the email you bought with. Your dashboard unlocks automatically. If it ever asks, enter your order number on the unlock screen.\u003c\/li\u003e\n\u003cli\u003eTap \u003cstrong\u003eLoad your workbook\u003c\/strong\u003e and pick your .xlsx file. The dashboard saves it to your team account, so it's there on any device.\u003c\/li\u003e\n\u003cli\u003eTap \u003cstrong\u003eTeam\u003c\/strong\u003e to add teammates by email. They sign in with that email and see the same dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003ch3\u003eGood to know\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eRoom for 2,000 rows per tab.\u003c\/li\u003e\n\u003cli\u003eWorks in Microsoft Excel (Mac or Windows) and Google Sheets. No macros, no add-ins.\u003c\/li\u003e\n\u003cli\u003eUsing Google Sheets? Download it as .xlsx (File \u0026gt; Download \u0026gt; Microsoft Excel) before loading it into the dashboard.\u003c\/li\u003e\n\u003cli\u003eOne-time price, no monthly subscription.\u003c\/li\u003e\n\u003cli\u003eWant it set up for you? The \u003ca href=\"\/products\/auto-repair-shop-crm-done-for-you-setup\"\u003eDone-For-You Setup\u003c\/a\u003e imports your customer list, sets your stages, team and goals, and includes 10 team seats.\u003c\/li\u003e\n\u003cli\u003eNeed custom fields or something built from scratch? Ask about a \u003ca href=\"\/pages\/business-crm-software#pricing\"\u003efully custom CRM\u003c\/a\u003e (from $3,500).\u003c\/li\u003e\n\u003cli\u003eDigital download only. No physical item is shipped.\u003c\/li\u003e\n\u003cli\u003eSample names and numbers are made up.\u003c\/li\u003e\n\u003cli\u003eFigures are estimates from your own data, not financial, legal or tax advice.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eQuestions? Email sales@buckeyebrandingcompany.com. Made by The Buckeye Branding Company, a family business in Copley, Ohio.\u003c\/p\u003e","brand":"The Buckeye Branding Company","offers":[{"title":"Default Title","offer_id":51916173672695,"sku":null,"price":297.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0860\/8602\/5463\/files\/01-hero_fb934bce-c5ac-4835-aa2a-1ad2f5b896de.jpg?v=1793608440","url":"https:\/\/buckeyebrandingcompany.com\/products\/auto-repair-shop-crm-live-dashboard","provider":"The Buckeye Branding Company","version":"1.0","type":"link"}