Church

Fernhollow Terrace Church · Church · Greenville, SC

Petra Cavanagh is the church administrator at Fernhollow Terrace Church in Greenville, and she uses this to keep every supply closet counted, reordered on time and never empty on a Sunday, with each month's stock count loaded from a spreadsheet that updates items in place.

NonprofitInventoryImports4 tables · 7 views · 2 forms · 2 dimension sets · 1 dashboard · 1 digest · 1 notification · 2 stage rule sets · 1 row action · 1 agent
Use this template

Stock board

Supplies
In stock20
Coffee, whole bean 2 lb bagFTC-101Kitchen
Napkins, 500 per packFTC-103Kitchen
Dish soap, 1 gallonFTC-105Kitchen
Trash bags, 33 gallon, 100 countFTC-107Kitchen
Stir sticks, 1000 countFTC-109Kitchen
15 more
Low5
Paper cups, 12 oz, 50 per sleeveFTC-102Kitchen
Disinfecting wipes, 6 canistersFTC-203Cleaning
Mop heads, loop styleFTC-206Cleaning
Glue sticks, 30 countFTC-502Youth
Ice melt, 50 pound bagFTC-604Building
Out of stock4
Dinner plates, 9 inch, 125 per packFTC-104Kitchen
Hand soap refill, 1 gallonFTC-202Cleaning
Taper candles, 12 inch, 50 countFTC-304Worship
Snack crackers, 150 pouchesFTC-505Youth
On order6
Paper towels, case of 12FTC-106Kitchen
Aluminum foil, 500 foot rollFTC-108Kitchen
Grape juice, 12 bottlesFTC-303Worship
Bulletin paper, 8.5 x 11, 2500 sheetsFTC-307Worship
Printer toner, blackFTC-402Office
1 more

Tables

Supplies

35 sample rows · 15 columns

Every closet's stock: what is on hand, what the shelf should hold and when to reorder.

SupplyItem codeKind of supplyKept inSold asCost eachPar level
AA batteries, 48 countFTC-602BuildingSound boothpack$174
Aluminum foil, 500 foot rollFTC-108KitchenFellowship hallroll$194
Ballpoint pens, box of 60FTC-404OfficeChurch officebox$10.504
Bulletin paper, 8.5 x 11, 2500 sheetsFTC-307WorshipChurch officecase$525
Candle lighter refillsFTC-305WorshipSanctuary sacristypack$7.506
Coffee, whole bean 2 lb bagFTC-101KitchenFellowship hallbag$14.5012
Communion cups, 500 countFTC-301WorshipSanctuary sacristybox$326
Communion wafers, 500 countFTC-302WorshipSanctuary sacristybox$27.504
Copy paper, case of 10 reamsFTC-401OfficeChurch officecase$466
Craft paper roll, 36 inchFTC-501YouthYouth roomroll$174
Crayons, 24 count box, 12 boxesFTC-503YouthYouth roomcase$13.505
Dinner plates, 9 inch, 125 per packFTC-104KitchenFellowship hallpack$9.508

23 more rows

Orders

16 sample rows · 10 columns

Each restock request or order placed with a vendor, and when it should arrive.

OrderOrder numberSupply itemVendorQuantityOrder totalStatus
Paper towels x4PO-26-601Paper towels, case of 12Brightwater Janitorial Products4$94Ordered
Aluminum foil x3PO-26-602Aluminum foil, 500 foot rollQuillon Restaurant Supply3$56.25Ordered
Printer toner x1PO-26-606Printer toner, blackWickersham Office Products1$89Ordered
Bulletin paper x3PO-26-604Bulletin paper, 8.5 x 11, 2500 sheetsWickersham Office Products3$150Ordered
Grape juice x2PO-26-603Grape juice, 12 bottlesSaltmarsh Church Goods2$59Ordered
Nursery wipes x4PO-26-605Nursery wipes, 800 countDovecote Children's Curriculum4$78Ordered

Vendors

6 sample rows · 8 columns

The companies the church buys from, with the account and delivery time.

VendorAccount numberContactOrders emailPhoneDays to deliverSupplies
Brightwater Janitorial ProductsBJP-7719Hamid Zakaria-Loweorders@brightwaterjanitorial.net(864) 555-01624Dish soap, 1 gallon, Paper towels, case of 12, Trash bags, 33 gallon, 100 count, Toilet paper, case of 48, Hand soap refill, 1 gallon, Disinfecting wipes, 6 canisters, Floor cleaner concentrate, 1 gallon, Glass cleaner, 32 oz, Mop heads, loop style
Dovecote Children's CurriculumDCC-1182Lionel Abrams-Teagueorders@dovecotecurriculum.org(864) 555-01669Craft paper roll, 36 inch, Glue sticks, 30 count, Crayons, 24 count box, 12 boxes, Nursery wipes, 800 count
Fennimore Building SupplyFBS-3310Wilhelmina Strauchonorders@fennimorebuildingsupply.com(864) 555-01653LED bulbs, A19, 12 pack, AA batteries, 48 count, Furnace filters, 20 x 25, 6 pack, Ice melt, 50 pound bag
Quillon Restaurant SupplyQRS-2041Leopold Pennywhistle-Amesorders@quillonrestaurantsupply.com(864) 555-01613Coffee, whole bean 2 lb bag, Paper cups, 12 oz, 50 per sleeve, Napkins, 500 per pack, Dinner plates, 9 inch, 125 per pack, Aluminum foil, 500 foot roll, Stir sticks, 1000 count, Snack crackers, 150 pouches
Saltmarsh Church GoodsSCG-0386Ruth Ellingboeorders@saltmarshchurchgoods.com(864) 555-01637Communion cups, 500 count, Communion wafers, 500 count, Grape juice, 12 bottles, Taper candles, 12 inch, 50 count, Candle lighter refills
Wickersham Office ProductsWOP-5524Cyrus Landgrebeorders@wickershamofficeproducts.com(864) 555-01642Offering envelopes, 1000 count, Bulletin paper, 8.5 x 11, 2500 sheets, Copy paper, case of 10 reams, Printer toner, black, Name tags, adhesive, 100 count, Ballpoint pens, box of 60

Also included

  • Stock boardStage rules
  • Order boardStage rules
  • Shelf ran outNotificationTells the church administrator when an item hits zero so it can be ordered before Sunday.
  • Monday low listDigest
  • Shelf is emptyRow action