Florist Business Profit Tracker Excel for your flower shop — arrangement costs, orders, flower inventory, and a monthly P and L dashboard. Know what every arrangement actually costs — and whether the month actually made…
About this template
Florist Business Profit Tracker Excel for your flower shop — arrangement costs, orders, flower inventory, and a monthly P and L dashboard. Know what every arrangement actually costs — and whether the month actually made money. Built for florists and flower shop owners who need to know, arrangement by arrangement and order by order, whether the price covers the flowers, the supplies, the labor, and the rent — without accounting software. If an arrangement is losing money, this workbook shows it before the next wedding season.
$39
Excel & Google Sheets template — instant download on Etsy
Arrangements and Pricing — stems, flower cost and supplies and labor per arrangement, cost per arrangement, price per arrangement, and margin in dollars and percent for every arrangement. Change a flower cost and every order profit updates by formula.
Orders — date, customer, order type, arrangement, quantity, unit price, revenue, cost per arrangement pulled from the arrangement sheet, profit per order, and margin. Log walk-in, online, wedding and event, and subscription orders in one place.
Flowers and Supplies — flower or supply, unit, quantity on hand, reorder point, cost per unit, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you buy it before the next order rush.
Monthly P and L — revenue, flower and labor cost, rent, spoilage and waste, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and flower cost are formulas from the Orders sheet.
Dashboard — total revenue, orders, arrangements sold, average order value, gross and net profit and margin, best arrangement by margin dollars and by margin percent, best-selling arrangement, best order and best order type, costs by category, and low stock count.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Florist Business Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Florist Business Profit Tracker track?
The Florist Business Profit Tracker tracks Arrangements and Pricing; Orders; Flowers and Supplies; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 3,035 from 20 orders and 52 arrangements sold; average order value 151.75.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.