From Spreadsheet to Stem Software: One Florist's Story

I've been designing flowers for events since 2021. For the first two years, I ran everything on spreadsheets.

Not because I love spreadsheets. Nobody loves spreadsheets. I ran them because that was the tool that existed. It bent to whatever I needed it to do, even if the bending took most of Tuesday morning.

Here was the routine. The wholesale invoice would arrive as a PDF. I'd open it next to a blank spreadsheet and retype every line. Flower name. Color. Supplier. Cost per stem. Stems per bunch. Forty rows on a slow week. Sixty on a busy one.

That was before I'd built a single recipe.

What the retyping was actually costing me

Two hours, twice a week, fifty weeks a year. A hundred hours of data entry. At $30/hr (and that's conservative), that's $3,000 a year doing something a computer should be doing.

It also made errors. A typo in the stem count. A price that didn't get updated because I missed page two of the invoice. A recipe cost that was wrong because it was built from last month's numbers. I caught most of them. Not always before I'd already placed the order.

If you've been in that loop (retype, build, quote, realize the margin is off), you know exactly what it feels like.

The first time the import worked

Matt built the invoice parser as a weekend project. I dropped my first PDF in, and about ten seconds later every line was loaded into my inventory. Names, costs, stems per bunch. All of it.

I said, "It's so beautiful, I'll take a picture."

I did. I sent it to my sister.

What changed

The spreadsheet work went away. Not slowly. That week.

What I did with the time was the part I didn't expect. I built more recipes. I finally looked at my actual cost-to-sell ratio for the first time. I caught a wholesale price jump on dahlias that I would have missed until it showed up in a wedding margin two weeks later.

The tool didn't make me a better designer. That part was already there. It just got out of the way.

What this means for you

If you're running your flower business on spreadsheets right now, the question isn't whether it works. It clearly can. The question is what you're paying in Tuesday mornings to keep them current.

For me it wasn't worth it. A hundred hours a year was the price of not having a better tool. Once I had one, I didn't miss the spreadsheet for a single morning.

Heather

*Petal Studio is built from my actual workflow. Every feature came out of something I needed at the workbench. Start your free trial and use your Tuesday morning for something that matters.*