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 jobsOH-2300
OH-2303
OH-2306
OH-2294
OH-2297
OH-2282
OH-2285
OH-2288
OH-2291
OH-2273
OH-2276
OH-2279
OH-2264
OH-2267
OH-2270
OH-2252
OH-2255
OH-2258
OH-2261
OH-2201
OH-2204
OH-2207
OH-2210
OH-2213
Tables
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 | — | — | ||
| OH-2303 | 2018 Mazda CX-9 | Delphine Varga-Holloway | Lakeshore Grange Insurance | CL-4369246 | ||
| OH-2306 | 2022 Honda Pilot | Tobiah Linden-Takahashi | Tamarack Shield Group | CL-4377165 | ||
| OH-2294 | 2016 Ford Fusion | Casper Rasmussen-Okoye | Cobalt Meridian Mutual | CL-4345489 | ||
| OH-2297 | 2023 Kia Sportage | Beatrix Obi-Ravenscroft | Cobalt Meridian Mutual | CL-4353408 | ||
| OH-2291 | 2021 Jeep Wrangler | Ottoline Ekström-Adebayo | Pinnacle Reach Insurance | CL-4337570 | ||
| OH-2282 | 2020 Hyundai Santa Fe | Dariusz Bellamy-Chukwu | Tamarack Shield Group | CL-4313813 | ||
| OH-2285 | 2019 Nissan Frontier | Maribel Moss-Adler | Lakeshore Grange Insurance | CL-4321732 | ||
| OH-2288 | 2022 Chevrolet Traverse | Lucan Szymanski-Boateng | — | — | ||
| OH-2252 | 2018 Buick Enclave | Mateusz Mbeki-Lund | Harborlight Casualty | CL-4234623 | ||
| OH-2264 | 2022 Subaru Crosstrek | Jarek Vandermeer-Osei | Harborlight Casualty | CL-4266299 | ||
| OH-2255 | 2022 Ford Transit van | Isolde Lindqvist-Ferreira | — | — |
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 |
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 | Oct 11, 2026 | |
| Supplement - OH-2288 | OH-2288 | Floor pan creased behind the seat | $700 | Oct 10, 2026 | |
| Supplement - OH-2255 | OH-2255 | Door hinge bent behind the skin | $375 | Oct 7, 2026 | |
| Supplement - OH-2258 | OH-2258 | Wiring harness repair found at the tail light | $225 | Oct 6, 2026 | |
| Supplement - OH-2267 | OH-2267 | Radiator support damage found after teardown | $480 | Oct 5, 2026 | |
| Supplement - OH-2276 | OH-2276 | Hood latch and bracket also bent | $335 | Oct 1, 2026 | |
| Supplement - OH-2249 | OH-2249 | Wheel alignment after suspension check | $190 | Sep 30, 2026 | |
| Supplement - OH-2243 | OH-2243 | Frame rail pull needed a second set-up | $540 | Sep 27, 2026 | |
| Supplement - OH-2234 | OH-2234 | Headlamp assembly cracked behind the bumper | $280 | Sep 20, 2026 | |
| Supplement - OH-2225 | OH-2225 | Quarter panel needed replacement, not repair | $650 | Sep 12, 2026 | |
| Supplement - OH-2216 | OH-2216 | Rear sensor mount cracked | $310 | Sep 4, 2026 | |
| Supplement - OH-2207 | OH-2207 | Hidden bracket damage found after teardown | $420 | Aug 27, 2026 |
Also included
- Week by claim type
- Shop board
- Ready for pickup list
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
- Towing companyWrenfield Crossing Towing3 tables · 5 views · 2 forms · 2 dimension sets · 1 dashboard · 2 drill-downs · 1 digest · 1 notification · 1 stage rule set · 1 agentDrill-down
- 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
- Auto repair shopVelvetmoor Junction Auto Repair4 tables · 6 views · 1 form · 1 dimension set · 1 dashboard · 1 digest · 1 notification · 1 stage rule set · 1 agentGoverned columns