Property management company

Drumlin Springs Property Management · Property management company · Eau Claire, WI

Ronan Hollingsworth manages repair supplies for a portfolio of rental units in Eau Claire; he keeps every unit's stock counted and reorders in time, and can reload a supplier's price list without losing a count.

Real estateInventoryImports5 tables · 7 views · 1 form · 2 dimension sets · 1 dashboard · 1 document · 1 notification · 1 row action · 1 agent
Use this template

Stock list

Supply stock
Item nameSKUCategoryUnitStored inSupplierOn hand
Cabinet pull, brushed nickelDS-10033HardwareEachMaple Court shedTamarack Hardware Co-op40
Carbon monoxide detector, plug-inDS-10013ElectricalEachCentral warehouseKettleview Electric Supply7
Carpet spot remover, 22 ozDS-10028CleaningEachEsker Ridge utility closetGlacier Janitorial Supply0
Condensate drain tablets, 12-packDS-10017HVAC and filtersBoxCentral warehouseNorthwoods HVAC Distributors8
Deadbolt, single cylinderDS-10030HardwareEachCentral warehouseTamarack Hardware Co-op3
Dishwasher drain pumpDS-10036Appliance partsEachCentral warehouseEsker Appliance Parts2
Door closer, spring hingeDS-10031HardwareEachCentral warehouseTamarack Hardware Co-op9
Door lockset, keyed entry, satin nickelDS-10029HardwareEachCentral warehouseTamarack Hardware Co-op5
Drain snake cartridge, 25 ftDS-10006PlumbingEachMaintenance van 2Harlan Plumbing Wholesale0
Dryer vent hose, 4 in x 8 ftDS-10039Appliance partsEachCentral warehouseEsker Appliance Parts10
Drywall patch kit, 8-inchDS-10023Paint and drywallEachCentral warehouseOstrander Paint and Drywall7
Faucet cartridge, single-handleDS-10003PlumbingEachCentral warehouseHarlan Plumbing Wholesale3

28 more rows

Tables

Supply stock

40 sample rows · 15 columns

Every part and consumable the maintenance team stocks, what is on the shelf and when to reorder.

Item nameSKUCategoryUnitStored inSupplierOn hand
Cabinet pull, brushed nickelDS-10033HardwareEachMaple Court shedTamarack Hardware Co-op40
Carbon monoxide detector, plug-inDS-10013ElectricalEachCentral warehouseKettleview Electric Supply7
Carpet spot remover, 22 ozDS-10028CleaningEachEsker Ridge utility closetGlacier Janitorial Supply0
Condensate drain tablets, 12-packDS-10017HVAC and filtersBoxCentral warehouseNorthwoods HVAC Distributors8
Deadbolt, single cylinderDS-10030HardwareEachCentral warehouseTamarack Hardware Co-op3
Dishwasher drain pumpDS-10036Appliance partsEachCentral warehouseEsker Appliance Parts2
Door closer, spring hingeDS-10031HardwareEachCentral warehouseTamarack Hardware Co-op9
Door lockset, keyed entry, satin nickelDS-10029HardwareEachCentral warehouseTamarack Hardware Co-op5
Drain snake cartridge, 25 ftDS-10006PlumbingEachMaintenance van 2Harlan Plumbing Wholesale0
Dryer vent hose, 4 in x 8 ftDS-10039Appliance partsEachCentral warehouseEsker Appliance Parts10
Drywall patch kit, 8-inchDS-10023Paint and drywallEachCentral warehouseOstrander Paint and Drywall7
Faucet cartridge, single-handleDS-10003PlumbingEachCentral warehouseHarlan Plumbing Wholesale3

28 more rows

Reorders

18 sample rows · 12 columns

Each purchase order line, from the moment someone asks for stock to the day the box arrives.

ReorderItemQuantityLine totalStatusRequestedOrdered
PO 2212: Smoke alarm × 24Smoke alarm, 10-year sealed battery24$525.60RequestedOct 4, 2026—
PO 2216: Oven cleaner × 12Oven cleaner, 19 oz12$68.40RequestedOct 4, 2026—
PO 2211: Toilet flapper × 24Toilet flapper, 2-inch24$100.80RequestedOct 3, 2026—
PO 2215: Thermostat × 5Thermostat, programmable 7-day5$205RequestedOct 3, 2026—
PO 2213: Drain snake cartridge × 4Drain snake cartridge, 25 ft4$116RequestedOct 2, 2026—
PO 2220: Dishwasher drain pump × 2Dishwasher drain pump2$108OrderedOct 1, 2026Oct 2, 2026
PO 2214: Carpet spot remover × 8Carpet spot remover, 22 oz8$59.20RequestedSep 30, 2026—
PO 2219: Run capacitor × 4Run capacitor, 45/5 MFD 370V4$65.60OrderedSep 29, 2026Sep 30, 2026
PO 2218: Furnace filter × 4Furnace filter, 16x20x1, case of 124$140OrderedSep 27, 2026Sep 28, 2026
PO 2217: Faucet cartridge × 8Faucet cartridge, single-handle8$147.20OrderedSep 26, 2026Sep 27, 2026
PO 2228: Range burner element × 3Range burner element, 8-inch3$53.70CancelledSep 20, 2026Sep 21, 2026
PO 2227: Painter's tape × 12Painter's tape, 1.88 in x 60 yd12$76.80ReceivedSep 14, 2026Sep 15, 2026

6 more rows

Suppliers

7 sample rows · 7 columns

The wholesalers Drumlin Springs buys from, with our account and the rep who answers.

SupplierRepRep phoneRep emailAccount numberTermsLead time (days)
Esker Appliance PartsCasimir Lindholm(715) 555-0114casimir.lindholm@eskerapplianceparts.comA-72284Net 306
Glacier Janitorial SupplyAmbrose Tolliver(715) 555-0112ambrose.tolliver@glacierjanitorialsupply.comA-27755Net 153
Harlan Plumbing WholesaleDagny Frobisher(715) 555-0108dagny.frobisher@harlanplumbwholesale.netA-48210Net 303
Kettleview Electric SupplyMarcus Okonkwo-Reyes(715) 555-0109marcus.okonkworeyes@kettleviewelectricsupply.comA-51377Net 302
Northwoods HVAC DistributorsIngeborg Sallow(715) 555-0110ingeborg.sallow@northwoodshvacdist.comA-39902Net 154
Ostrander Paint and DrywallPilar Ventresca(715) 555-0111pilar.ventresca@ostranderpaintdrywall.comA-60418Net 302
Tamarack Hardware Co-opYetunde Falk(715) 555-0113yetunde.falk@tamarackhardwarecoop.comA-33061Prepaid5

Storerooms

6 sample rows · 5 columns

Every place stock is kept, from the central warehouse to the vans, and who keeps the key.

StoreroomKindWhereKept byDoor code
Central warehouseWarehouseBay 2, Moraine Kettle Rd yardIlse Brandvold4172
Maple Court shedProperty shedBehind building CBeatrix Oyelowo2260
Kettle Pond garageProperty shedUnit 14 garageCormac Deveraux7391
Esker Ridge utility closetUtility closetLower level, east hallAdaeze Nwosu5028
Maintenance van 1Maintenance vanCormac's routeCormac Deveraux3845
Maintenance van 2Maintenance vanAdaeze and Tibor's routeAdaeze Nwosu6619

Forms and booking

Restock request

Form
Restock requestWhat a technician sends from the van when a bin is nearly empty.
What do you need, and how many? *
Which item is running low? *
How many should we order? *
Who is asking?
Send request

Dashboards

Stock health

Supply stock
Items by status
  • In stock29
  • Low5
  • On order4
  • Out of stock2
Items by category
  • Plumbing7
  • Electrical6
  • HVAC and filters5
  • Paint and drywall5
  • Cleaning5
  • Hardware6
  • Appliance parts6
Spend by reorder status
  • In stock0
  • Low0
  • On order0
  • Out of stock0

Also included

  • Purchase orderDocumentThe order sent to a supplier for one reorder line.
  • Late deliveryNotificationTells Ronan when a supplier misses the date promised on an order.
  • Mark receivedRow action