Florist Bookkeeping: Find Missing Stems After a Holiday Rush

Reconcile delivered, sold and damaged flowers to a physical count. Use a free stem inventory tool to separate documented waste from unexplained shrink.

LiveFixPro Bookkeeping Editorial Team

11/15/20265 min read

The morning after Valentine’s Day, a florist finds 74 usable red roses in the cooler. The purchase sheet suggests there should be 80. Six missing roses could mean an incorrect delivery count, an undocumented substitution, a bucket moved between workstations or a genuine loss. Charging the entire gap to spoilage may hide a supplier error or make the next order too large. Florist bookkeeping is more useful when a count explains what happened between the receiving door and the finished bouquet.

Florist stem inventory checker

What the stem inventory checker measures

Use one variety, grade and unit of measure for one location and cutoff. Enter the usable stems on hand at the opening, stems received, stems sold or used in work, and documented waste. The tool computes expected usable stems and compares them with a physical count. Add a unit cost from the relevant purchase or an approved costing basis to estimate the value of the difference. Keep unlike varieties and lots separate when their costs differ materially. The result is an operating estimate for review.

For example, 40 opening stems plus 300 received gives 340 available. If 242 were used in arrangements and 18 were documented as waste, the expected count is 80. The cooler count of 74 is six short. At an illustrative $1.50 per stem, the unexplained shortage is $9. The 18 stems already recorded as waste represent a separate $27 on those assumptions. Recording all 24 as new waste would count an existing loss twice. A counted surplus also deserves investigation because it can mean unrecorded receipts, an inaccurate recipe or a count from the wrong bucket.

Make buying and receiving use the same unit

A supplier invoice may say “12 bunches” while a designer’s sheet records individual stems. Confirm how many usable stems were actually received per bunch. Keep any short delivery or quality claim with the supplier invoice and receiving note. If the vendor bills 300 and the team counts 290 good stems plus ten visibly damaged ones, decide how your receiving and waste records capture that difference. Recording 290 received and ten more as waste would remove the same damaged stems twice. Document the method and do it the same way across shifts.

Mark what happened to sample arrangements, promotional displays, donations, substitutions and stock moved between locations. They all remove stems from a bucket, but they need different explanations for the manager. If six roses moved from the retail cooler to a wedding workroom, the store-wide count may agree even though the cooler is short. An internal transfer should reduce one location and increase the other when the scope requires it. In a simple single-location tool, reconcile after adjusting the source schedule to the chosen location and disclose the transfer.

Count in a way another person could repeat

Name a count cutoff and pause movements for the chosen variety, or write down every movement during the count. Label buckets, check the design bench and include reserved stems only if the opening balance and usage records treat reservations the same way. A rose earmarked for delivery tomorrow is still physically present if it has not been consumed. Do not quietly mix a count of all flowers on premises with an opening balance that covered only available-for-sale flowers.

Use a second count for expensive varieties or unexpectedly large differences. A large Valentine rush is a good reason to choose the busiest variety first, then extend the routine. NRF’s 2026 Valentine survey provides context for the event’s importance to gift buying. Your own preorders, supplier lead times, weather and contracts determine which stems deserve the closest attention for the coming season. NRF’s Valentine’s Day research.

Explain the gap before assigning a loss

Look at recipe changes first if units sold are estimated from standard bouquets. A dozen advertised red roses might have been substituted with pink roses by agreement, leaving more reds than the recipe calculation predicts. A premium arrangement might have used extra reds after damage to another flower. Save the order reference and the actual number used. Over time, a pattern of recipe variations can tell the buying team more than any adjustment entry in the general ledger.

Then check receiving differences, documented culls and supplier credits. A credit reduces the amount payable to a vendor under its terms. It does not automatically put physical stems back into inventory. Conversely, a replacement delivery changes physical stock even if no new invoice is issued. Pair credit and replacement documents with the original delivery and look for any double counting. If you still cannot explain a discrepancy, retain the count evidence and route it to the person who approves inventory adjustments.

For U.S. reporting, inventory valuation and tax treatment depend on your facts and accounting method. The IRS discusses book and physical inventory in its guidance on accounting methods. Keep the operating count and cost assumptions available to the adviser handling the formal treatment. IRS Publication 538.

Use an AI assistant at the receiving desk

A practical setup can read a supplier invoice into a draft receiving list, suggest the matching purchase order and flag a line whose unit changed from bunches to stems. Ask the receiving employee to confirm delivered quantities, inspect quality and approve exceptions. The AI cannot establish what is in an unopened box or whether a bloom is fit for a premium order. A phone photograph can support a claim, but the physical count and vendor response still belong in the record.

Pilot one variety during a short peak. Compare the time staff spend reconstructing usage, the value of unexplained differences and supplier claims with complete support. At the end, review the rows that initially matched as well as the exceptions. A repeated conversion error can make a whole series of rows appear internally consistent. LiveFixPro can help connect the reviewed receiving and order data to your existing bookkeeping workflow, leaving count approvals, formal adjustments and purchasing decisions with your team.

Turn a count result into a better purchasing decision

Take the six-stem shortage from the example. If a designer confirms six roses were added to a premium arrangement, update the usage support and review whether the selling price covered the extra materials. If the supplier documents a short delivery, keep the claim with the original receipt. If the stems were truly spoiled, consider when the stock was ordered and how it was stored. An identical physical gap can lead to three different improvements, only one of which concerns spoilage.

Repeat the check after the next rush using the same variety, unit and cutoff. Compare unexplained differences separately from documented waste. A decline in unexplained shrink accompanied by a rise in recorded culls can indicate that staff are documenting losses more accurately. Ask for the receiving and design evidence before assuming flower quality deteriorated. Better information can change the story the owner tells about the very same week.

Explore the bookkeeping guides and free tools

Start with the complete small business bookkeeping guide

Catering event deposit tracker · Event deposits and final invoices

Retail refund reconciliation tool · Returns, store credits and cash refunds

Prepaid class-pack checker · Prepaid sessions and class redemptions

Vacation rental payout matcher · Multi-listing settlements and bank deposits

Browse all bookkeeping resources · Explore LiveFixPro bookkeeping services

Book a free bookkeeping and automation consultation · How an AI workforce handles everyday business tasks

Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States

Contacts

+1 914-639-6759

support@livefixpro.com

Privacy · Terms · Refund Policy

Free Tools· Bookkeeping directory

Get in touch

LiveFixPro Bookkeeping & Accounting Services LLC is an independent firm. Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.