Collision repair
Orchardine Harbor Collision · Collision repair · Duluth, MN
Gideon Balogun writes the estimates at Orchardine Harbor Collision, a Duluth collision repair center, and he reads each week's billing, labor hours and days in the shop by claim type from one screen instead of a spreadsheet.
AutomotiveReportingDashboards5 tables · 6 views · 1 form · 1 dimension set · 1 dashboard · 1 drill-down · 1 digest · 1 stage rule set · 1 agent
Use this templateShop board
Repair jobsEstimate written3
OH-23002020 Ram ProMaster vanAnselm Wexler-Ndiaye
OH-23032018 Mazda CX-9Delphine Varga-Holloway
OH-23062022 Honda PilotTobiah Linden-Takahashi
Approved2
OH-22942016 Ford FusionCasper Rasmussen-Okoye
OH-22972023 Kia SportageBeatrix Obi-Ravenscroft
In the shop4
OH-22822020 Hyundai Santa FeDariusz Bellamy-Chukwu
OH-22852019 Nissan FrontierMaribel Moss-Adler
OH-22882022 Chevrolet TraverseLucan Szymanski-Boateng
OH-22912021 Jeep WranglerOttoline Ekström-Adebayo
Waiting on parts3
OH-22732017 Honda AccordNoor Delgado-Finch
OH-22762023 Ford MaverickCormac Hargrove-Tanaka
OH-22792018 Toyota HighlanderPellam Ridge Plumbing Crew
Paint3
OH-22642022 Subaru CrosstrekJarek Vandermeer-Osei
OH-22672019 Dodge Grand CaravanTemperance Halvorsen-Rao
OH-22702021 Chevrolet ColoradoAnsgar Marchetti-Oyelaran
Ready for pickup4
OH-22522018 Buick EnclaveMateusz Mbeki-Lund
OH-22552022 Ford Transit vanIsolde Lindqvist-Ferreira
OH-22582020 GMC SierraKwabena Kowalczyk-Mensah
OH-22612016 Toyota CamryRosalind Strand-Okafor
Delivered17
OH-22012019 Subaru OutbackZephaniah Fairweather-Diaz
OH-22042021 Ford F-150Thaddeus Castellan-Pryor
OH-22072018 Honda CR-VIngrid Quinlan-Abara
OH-22102022 Toyota TacomaObadiah Petrov-Sutherland
OH-22132020 Chevrolet EquinoxPhilomena Sorensen-Kamara
12 moreTables
Repair jobs
36 sample rows · 19 columnsEvery vehicle in the shop from estimate to delivery, with what was billed and how long it sat.
| Job | Vehicle | Customer | Claim type | Insurer | Claim number | Status |
|---|---|---|---|---|---|---|
| OH-2300 | 2020 Ram ProMaster van | Anselm Wexler-Ndiaye | Out of pocket | — | — | Estimate written |
| OH-2303 | 2018 Mazda CX-9 | Delphine Varga-Holloway | Insurer, customer's shop choice | Lakeshore Grange Insurance | CL-4369246 | Estimate written |
| OH-2306 | 2022 Honda Pilot | Tobiah Linden-Takahashi | Direct repair program | Tamarack Shield Group | CL-4377165 | Estimate written |
| OH-2294 | 2016 Ford Fusion | Casper Rasmussen-Okoye | Insurer, customer's shop choice | Cobalt Meridian Mutual | CL-4345489 | Approved |
| OH-2297 | 2023 Kia Sportage | Beatrix Obi-Ravenscroft | Direct repair program | Cobalt Meridian Mutual | CL-4353408 | Approved |
| OH-2291 | 2021 Jeep Wrangler | Ottoline Ekström-Adebayo | Direct repair program | Pinnacle Reach Insurance | CL-4337570 | In the shop |
| OH-2282 | 2020 Hyundai Santa Fe | Dariusz Bellamy-Chukwu | Direct repair program | Tamarack Shield Group | CL-4313813 | In the shop |
| OH-2285 | 2019 Nissan Frontier | Maribel Moss-Adler | Insurer, customer's shop choice | Lakeshore Grange Insurance | CL-4321732 | In the shop |
| OH-2288 | 2022 Chevrolet Traverse | Lucan Szymanski-Boateng | Out of pocket | — | — | In the shop |
| OH-2252 | 2018 Buick Enclave | Mateusz Mbeki-Lund | Direct repair program | Harborlight Casualty | CL-4234623 | Ready for pickup |
| OH-2264 | 2022 Subaru Crosstrek | Jarek Vandermeer-Osei | Direct repair program | Harborlight Casualty | CL-4266299 | Paint |
| OH-2255 | 2022 Ford Transit van | Isolde Lindqvist-Ferreira | Out of pocket | — | — | Ready for pickup |
24 more rows
Customers
36 sample rows · 6 columnsThe drivers and fleets who bring vehicles in, with how much each has been billed.
| Name | Phone | Town | Jobs | |
|---|---|---|---|---|
| Anneliese Aldridge-Nakata | (218) 555-0120 | anneliese.aldridge@saltmarshpostal.org | Cloquet | OH-2231 |
| Anselm Wexler-Ndiaye | (218) 555-0143 | anselm.wexler@northlakeinboxmail.net | Proctor | OH-2300 |
| Ansgar Marchetti-Oyelaran | (218) 555-0133 | ansgar.marchetti@duluthsidemail.com | Carlton | OH-2270 |
| Bartholomew Okpara-Lindgren | (218) 555-0117 | bartholomew.okpara@saltmarshpostal.org | Superior | OH-2222 |
| Beatrix Obi-Ravenscroft | (218) 555-0142 | beatrix.obi@duluthsidemail.com | Hermantown | OH-2297 |
| Casper Rasmussen-Okoye | (218) 555-0141 | casper.rasmussen@saltmarshpostal.org | Superior | OH-2294 |
| Cordelia Pruitt-Eze | (218) 555-0116 | cordelia.pruitt@northlakeinboxmail.net | Duluth | OH-2219 |
| Cormac Hargrove-Tanaka | (218) 555-0135 | cormac.hargrove@saltmarshpostal.org | Superior | OH-2276 |
| Dariusz Bellamy-Chukwu | (218) 555-0137 | dariusz.bellamy@northlakeinboxmail.net | Proctor | OH-2282 |
| Delphine Varga-Holloway | (218) 555-0144 | delphine.varga@saltmarshpostal.org | Cloquet | OH-2303 |
| Desmond Boyle-Adeyemi | (218) 555-0121 | desmond.boyle@duluthsidemail.com | Carlton | OH-2234 |
| Evander Tolliver-Santos | (218) 555-0119 | evander.tolliver@northlakeinboxmail.net | Proctor | OH-2228 |
24 more rows
Insurers
6 sample rows · 7 columnsThe insurance companies whose claims the shop repairs, the rate each one agreed to and who to call.
| Insurer | Claims desk | Adjuster email | Agreed labor rate | Direct repair partner | Jobs |
|---|---|---|---|---|---|
| Cobalt Meridian Mutual | (218) 555-0171 | drp.desk.cobalt@northlakeinboxmail.net | $72 | Yes | OH-2201, OH-2204, OH-2213, OH-2237, OH-2240, OH-2261, OH-2273, OH-2276, OH-2294, OH-2297 |
| Harborlight Casualty | (218) 555-0172 | drp.desk.harborlight@northlakeinboxmail.net | $68 | Yes | OH-2219, OH-2252, OH-2264 |
| Lakeshore Grange Insurance | (218) 555-0174 | drp.desk.lakeshore@northlakeinboxmail.net | $66 | No | OH-2249, OH-2285, OH-2303 |
| Nordhaven Auto Insurance | (218) 555-0176 | drp.desk.nordhaven@northlakeinboxmail.net | $69 | No | |
| Pinnacle Reach Insurance | (218) 555-0173 | drp.desk.pinnacle@northlakeinboxmail.net | $70 | Yes | OH-2207, OH-2231, OH-2267, OH-2291 |
| Tamarack Shield Group | (218) 555-0175 | drp.desk.tamarack@northlakeinboxmail.net | $74 | Yes | OH-2222, OH-2228, OH-2246, OH-2282, OH-2306 |
Supplements
12 sample rows · 6 columnsExtra damage found after teardown, asked of the insurer or customer and approved or still waiting.
| Supplement | Job | What was found | Amount | Status | Asked on |
|---|---|---|---|---|---|
| Supplement - OH-2285 | OH-2285 | Airbag sensor replacement | $260 | Approved | Sep 28, 2026 |
| Supplement - OH-2288 | OH-2288 | Floor pan creased behind the seat | $700 | Pending | Sep 27, 2026 |
| Supplement - OH-2255 | OH-2255 | Door hinge bent behind the skin | $375 | Approved | Sep 24, 2026 |
| Supplement - OH-2258 | OH-2258 | Wiring harness repair found at the tail light | $225 | Approved | Sep 23, 2026 |
| Supplement - OH-2267 | OH-2267 | Radiator support damage found after teardown | $480 | Pending | Sep 22, 2026 |
| Supplement - OH-2276 | OH-2276 | Hood latch and bracket also bent | $335 | Pending | Sep 18, 2026 |
| Supplement - OH-2249 | OH-2249 | Wheel alignment after suspension check | $190 | Approved | Sep 17, 2026 |
| Supplement - OH-2243 | OH-2243 | Frame rail pull needed a second set-up | $540 | Approved | Sep 14, 2026 |
| Supplement - OH-2234 | OH-2234 | Headlamp assembly cracked behind the bumper | $280 | Approved | Sep 7, 2026 |
| Supplement - OH-2225 | OH-2225 | Quarter panel needed replacement, not repair | $650 | Approved | Aug 30, 2026 |
| Supplement - OH-2216 | OH-2216 | Rear sensor mount cracked | $310 | Approved | Aug 22, 2026 |
| Supplement - OH-2207 | OH-2207 | Hidden bracket damage found after teardown | $420 | Approved | Aug 14, 2026 |
Forms and booking
Write an estimate
FormWrite an estimateThe estimator opens a job the moment a vehicle is photographed at the counter.
What number is on the work order? *Looks like OH-2310.
What year, make and model is it? *
How is the repair being paid for? *Direct repair programInsurer, customer's shop choiceOut of pocketFleet accountWarranty and goodwill
What is the estimate?
How many labor hours does it need?
Open the jobDashboards
Weekly numbers
Repair jobsBilled by claim type
- Direct repair program$34,955
- Insurer, customer's shop choice$15,760
- Out of pocket$8,735
- Fleet account$10,690
- Warranty and goodwill$5,050
Labor hours by claim type
- Direct repair program421.7
- Insurer, customer's shop choice160.4
- Out of pocket86.9
- Fleet account86.4
- Warranty and goodwill27.4
Billed by week finished
- Aug 16, 2026$9,940
- Aug 23, 2026$4,455
- Aug 30, 2026$12,650
- Sep 6, 2026$6,760
- Sep 13, 2026$13,030
- Sep 20, 2026$12,730
- Sep 27, 2026$7,000
- Oct 4, 2026$8,625
Days in shop
- Direct repair program0
- Insurer, customer's shop choice0
- Out of pocket0
- Fleet account0
- Warranty and goodwill0
Vehicles by status
- Delivered17
- Ready for pickup4
- Paint3
- Waiting on parts3
- In the shop4
- Approved2
- Estimate written3
Ready for pickup, billed$15,625
Also included
- Week by claim typeDrill-down
- Shop boardStage rules
- Ready for pickup listDigest
Related templates
- RV service centerKingsweir Hill RV Service4 tables · 5 views · 1 form · 1 dimension set · 1 dashboard · 1 drill-down · 1 digest · 1 stage rule set · 1 agentImports
- Auto repair shopRedbud Hollow Auto Repair4 tables · 5 views · 1 form · 1 dimension set · 1 portal · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 agentBoards
- Auto repair shopBirchcombe Ridge Auto Repair5 tables · 6 views · 2 forms · 1 dashboard · 1 digest · 1 document · 1 notification · 2 stage rule sets · 1 row action · 1 agentForms
- Auto repair shopLarchmont Landing Auto Repair3 tables · 5 views · 2 forms · 1 dimension set · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 agentCalendar
- Car washJessamine Commons Car Wash4 tables · 5 views · 1 form · 1 dimension set · 1 drill-down · 1 digest · 1 notification · 1 agentDrill-down
- Car washThornhollow Creek Car Wash4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 agentImports