AI Matrx Logo

Bike shop

Ironbridge Bend Cycles · Bike shop · Madison, WI

Thiago Larkspur is the service manager at Ironbridge Bend Cycles, a Madison bike shop with a busy repair bench, and he uses this to bill every repair, see the week's money at a glance and chase what is still unpaid.

RetailBillingDashboards4 tables · 5 views · 1 form · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 1 agent
Use this template

Promised dates

Repair tickets
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1IB-2311
2IB-2309IB-2314
3IB-2310IB-2312
4IB-2308
5IB-2305IB-2306
6IB-2304
7IB-2307
8IB-2303
9IB-2301IB-2302
10IB-2300
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Tables

Repair tickets

32 sample rows · 17 columns

Every bike on the bench: what was done, what it costs, and whether the customer has paid.

TicketCustomerBikeServiceBench statusDropped offPromised for
IB-2300Marisela AshbourneCommuter, blue 54 cmBasic tune-upIn queueOct 5, 2026Oct 10, 2026
IB-2301Perpetua HollingerCargo bike, blackBrake serviceIn queueOct 4, 2026Oct 9, 2026
IB-2302Clementine Rask-IbarraE-bike, step-throughFlat repairIn queueOct 4, 2026Oct 9, 2026
IB-2303Tatiana Holloway-BrandvikFixed gear, red 55 cmE-bike diagnosticsIn queueOct 3, 2026Oct 8, 2026
IB-2307Lorraine FeldstromTouring bike, tan 60 cmWheel trueOn the benchOct 3, 2026Oct 7, 2026
IB-2304Rhiannon Ledgerwood-BoydRoad bike, silver 56 cmFull overhaulOn the benchOct 2, 2026Oct 6, 2026
IB-2305Eastgate Middle SchoolHybrid, white 52 cmBasic tune-upOn the benchOct 1, 2026Oct 5, 2026
IB-2306Madison Pedal CouriersKid's bike, 20 inDrivetrain replacementOn the benchOct 1, 2026Oct 5, 2026
IB-2308Bellwether Property GroupMountain bike, greenBrake serviceOn the benchSep 30, 2026Oct 4, 2026
IB-2310Capitol Square RentalsFolding bike, greyFlat repairReady for pickupSep 30, 2026Oct 3, 2026
IB-2312Godfrey AldwynCargo bike, blackWheel trueReady for pickupSep 30, 2026Oct 3, 2026
IB-2309Lakeshore Meals DeliveryGravel bike, orange 58 cmBasic tune-upReady for pickupSep 29, 2026Oct 2, 2026

20 more rows

Customers

22 sample rows · 8 columns

The riders and the fleet accounts who bring bikes in, and what each still owes.

CustomerContactPhoneEmailCustomer sinceAccountRepair tickets
Alistair Yoshida-PryceAlistair Yoshida-Pryce(608) 555-0167alistair.yoshidapryce@opalcreekpost.netFeb 25, 2025Walk-inIB-2317
Bellwether Property GroupAmadeus Lindgren-Fox(608) 555-0182amadeus.lindgrenfox@bellwetherpropertygroupmgmt.netAug 16, 2024Fleet accountIB-2308, IB-2329
Capitol Square RentalsCaspian Wolfe-Adeyemi(608) 555-0184caspian.wolfeadeyemi@capitolsquarerentalsbikes.netFeb 18, 2024Fleet accountIB-2310, IB-2331
Clementine Rask-IbarraClementine Rask-Ibarra(608) 555-0170clementine.raskibarra@opalcreekpost.netOct 25, 2024Walk-inIB-2302
Eastgate Middle SchoolBernadette Haverkamp-Doyle(608) 555-0181bernadette.haverkampdoyle@eastgatemiddleschoolpta.netNov 14, 2024Fleet accountIB-2305, IB-2314
Emrys Sandoval-ThorneEmrys Sandoval-Thorne(608) 555-0175emrys.sandovalthorne@marshwrenmail.netApr 3, 2024Walk-inIB-2322
Ferdinand AspinwallFerdinand Aspinwall(608) 555-0169ferdinand.aspinwall@marshwrenmail.netDec 5, 2024Walk-inIB-2319
Godfrey AldwynGodfrey Aldwyn(608) 555-0161godfrey.aldwyn@opalcreekpost.netOct 29, 2025Walk-inIB-2312
Kasimir Ndlovu-BrandtKasimir Ndlovu-Brandt(608) 555-0165kasimir.ndlovubrandt@kestrelbayinbox.comMay 18, 2025Club memberIB-2316
Lakeshore Meals DeliveryZuleika Pettigrew-Nash(608) 555-0183zuleika.pettigrewnash@lakeshoremealsdeliveryco.netMay 18, 2024Fleet accountIB-2309, IB-2330
Lazlo VerhoevenLazlo Verhoeven(608) 555-0171lazlo.verhoeven@kestrelbayinbox.comSep 14, 2024Club memberIB-2320
Lorraine FeldstromLorraine Feldstrom(608) 555-0164lorraine.feldstrom@opalcreekpost.netJun 28, 2025Walk-inIB-2307

10 more rows

Service menu

8 sample rows · 5 columns

What the bench offers, the labor price on the board and how long it takes.

ServiceCategoryLabor priceBench hoursWorkmanship cover
Basic tune-upTune-ups$851.530
Bike fit and setupQuick fixes$11020
Brake serviceBrakes and wheels$60160
Drivetrain replacementDrivetrain$1202.590
E-bike diagnosticsElectric$901.530
Flat repairQuick fixes$180.514
Full overhaulTune-ups$220490
Wheel trueBrakes and wheels$350.530

Forms and booking

Drop off a bike

Form
Drop off a bikeThe counter fills this in when a rider hands over a bike for repair.
What number is on the repair tag? *Looks like IB-2318.
Whose bike is it? *
How would you describe the bike?
What work should the bench do? *
What day will it be ready?
Tag the bike

Dashboards

Bench numbers

Repair tickets
Tickets by payment
  • Not billed7
  • Part paid3
  • Billed8
  • Paid14
Labor billed by service$2,615
Labor billed by week dropped off
  • Aug 30, 2026$460
  • Sep 6, 2026$138
  • Sep 13, 2026$295
  • Sep 20, 2026$528
  • Sep 27, 2026$1,031
  • Oct 4, 2026$163

Also included

  • Friday open invoicesDigest
  • Bike readyNotificationTells the front counter the moment a bike finishes on the bench so the rider can be called.

Related templates