# Retail KPIs for hardware, paint, and farm stores > https://rundoo.ai/resources/guides/retail-kpis-for-supply-stores/ [Guides](/resources/guides/index.md) /Product Product # Retail KPIs for hardware, paint, and farm stores The retail KPIs that matter for an independent supply store are gross margin, average ticket, ticket count, units per transaction, sales per square foot, inventory turns and GMROI, and receivables aging, and each one is a simple formula you can pull from the POS every week. [![Titus Capilnean](https://pub-5247264bd04e4ebeaecbbedb3bebb9f8.r2.dev/static/images/articles/titus-capilnean.jpeg)](https://www.linkedin.com/in/tituscapilnean/) [Titus Capilnean](https://www.linkedin.com/in/tituscapilnean/), Head of Marketing October 27, 2026 Last updated October 27, 2026 ## The short answer The retail KPIs that matter most for an independent supply store are gross margin, average transaction value, ticket count, units per transaction, sales per square foot, inventory turns and GMROI, and accounts receivable aging. Each one is a simple formula you can pull from your POS once a week, and together they tell you whether a soft month is a traffic problem, a pricing problem, or a stock problem. You already measure twice and cut once on everything else in the store, so your numbers deserve the same courtesy, and here's what to measure, how to calculate it, and what to do when a number moves. ## The counter numbers: average ticket, units per transaction, and ticket count ### Average transaction value (average ticket) Average transaction value is net sales divided by the number of transactions. If your store did $6,240 in net sales across 160 tickets last week, your average ticket is $39.00. That number has company. The NHPA's [2025 Cost of Doing Business Study](https://hardwareretailing.com/staying-on-par-highlights-from-the-2025-cost-of-doing-business-study/), which surveyed 1,082 independent home improvement stores for fiscal 2024, put hardware stores' sales per customer at $39, an all-time high for the study. The figures are mostly medians and the sample shifts a bit year to year, but it's a useful gut check: if your average ticket is drifting down while the trade's is climbing, something on your floor is worth a look. ### Units per transaction Units per transaction is units sold divided by the number of transactions. Sell 512 units over those same 160 tickets and you're at 3.2 units per ticket. One caution before you compare this number to anyone else's: units of measure will distort it. A contractor who buys 100 feet of rope counts as 100 units or as 1 unit depending on how that item is set up in your system, and board feet versus pieces does the same trick in the lumber aisle. Compare like with like inside your own store, department to department and week to week, and don't sweat the store down the road. ### Ticket count, your practical conversion number Retail textbooks love conversion rate, but conversion needs door counts, and most supply stores don't count traffic. Ticket count is the practical proxy, and your POS already has it. Ticket count and average ticket also explain every sales change you'll ever see. If sales are down because fewer tickets came through, that's a traffic problem, and the fix is advertising, events, or giving contractors a reason to stop in. If sales are down because tickets got smaller, that's an attachment and merchandising problem: the contractor checked out with the saw but nobody mentioned blades, the homeowner bought the gallon but not the roller kit. Same symptom, two completely different fixes. ## Gross margin: the number that pays the bills Gross margin percentage is net sales minus cost of goods sold, divided by net sales. Take that $6,240 week with $3,620 in cost of goods, and you're at a 42.0% margin. The NHPA study put hardware store gross margin after rebate at 42.6% for fiscal 2024, the highest it's recorded since 2016. If your margin is meaningfully below that, the usual suspects are landed cost creep from vendors, too much custom pricing handed out at the counter, or a markup habit that quietly cuts into your margin. If you've ever confused the two, our guide to [margin vs. markup pricing for hardware stores](/resources/guides/margin-vs-markup-pricing-hardware-store/index.md) untangles them with real shelf prices. Keep one thing straight, though: margin is not profit. The same study put hardware store profit before taxes at 4.7%. Margin is what pays for payroll, rent, insurance, and the truck, and what survives that gauntlet is profit. Watching margin weekly is how you catch a cost increase in the week it happens instead of at year end, when your accountant hands you the news. ## Sales per square foot Sales per square foot is annual net sales divided by your selling square feet. A store doing $1.8 million in net sales out of 9,000 square feet of selling space is producing $200 per square foot. The tricky part in our trade is what counts as selling space. A lumber yard, a shed lot, and outdoor nursery space don't behave like indoor floor space, so give them a separate number or adopt a stated rule (indoor selling space only, yard tracked on its own) and stick to it. The rule matters less than applying it the same way every year. There's no clean industry benchmark worth quoting here, so your best comparison is your own store, same period last year. When the number slides, it usually means a department is holding floor space it hasn't earned, which is a merchandising conversation waiting to happen. ## Inventory turns and GMROI Inventory turns is annual cost of goods sold divided by average inventory at cost, and it tells you how fast stock sells through and gets replaced. GMROI, gross margin return on investment, divides your gross margin dollars by that same average inventory at cost, and it tells you whether the inventory you're carrying is earning its keep. Both deserve their own walkthrough, which is why we wrote a full guide to [inventory turnover ratio and GMROI for hardware stores](/resources/guides/inventory-turnover-ratio-and-gmroi-for-hardware-stores/index.md). The benchmark worth knowing: the NHPA study recorded home center inventory turnover at 2.0, the lowest it's ever measured. Carrying more stock than you can turn ties up cash that could be working somewhere else. For seasonal goods, garden center stock in spring or feed through the winter, turns matter less than a simpler question: of what you received for the season, how much sold? Units sold divided by units received over the season tells you whether next year's buy should shrink. And when the season ends with pallets of something still sitting there, our guide to [finding and clearing dead stock](/resources/guides/dead-stock-how-to-find-and-clear-it/index.md) covers what to do with it. ## The back office numbers ### Accounts receivable aging Charge accounts are how contractors buy, and the aging report is how you keep that courtesy from costing you. Two numbers do the work. Days sales outstanding is accounts receivable divided by credit sales, multiplied by the number of days in the period, and it tells you how long your money sits in someone else's hands. The second is simpler: what percent of your receivables are more than 60 days old. When that share creeps up month after month, your margin is quietly doing charity work. Our guide to [house accounts, statements, aging, and finance charges](/resources/guides/house-accounts-statements-aging-finance-charges/index.md) walks through setting terms and working the report. ### Sales per labor hour Net sales divided by paid hours. This one earns its keep at scheduling time: if Saturday from 8 to noon produces double the sales per labor hour of Tuesday afternoon, you know where the staffing goes, and you know truck day needs extra hands because receiving and stocking eat hours without producing a dollar at the counter. ### Discount and override rate Dollars of price overrides and discounts divided by gross sales. Contractor pricing and price tiers are part of the trade, and nobody is suggesting you stop taking care of your pros. But if override dollars climb while gross margin slides, the counter is giving away margin one keystroke at a time, and it's worth finding out whether the pricing in the system is the problem or the habits at the register are. ### Shrink Shrink percentage is shrink at cost divided by sales, and you only get it by counting, whether that's a full inventory count or cycle counts on a cadence. It covers everything from receiving errors to a pallet counted wrong, and it rarely announces itself any other way. Our guide to [retail shrink in hardware and feed stores](/resources/guides/retail-shrink-hardware-and-feed-stores/index.md) goes deep on finding it. ## A weekly rhythm that sticks The stores that get value from KPIs don't track thirty of them. They review a short list every week, and they compare it to the same week last year rather than to last week, because this trade runs on seasons: spring for garden centers and feed, paint season when the weather turns, and comparing a May Saturday to an April Saturday will only confuse you. Look at the same numbers by department, because a healthy store average can hide a sick paint department, and pick one number to move each quarter rather than trying to move all of them at once. Here's the short list on one card: | KPI | Formula | What it tells you | | --- | --- | --- | | Average transaction value | Net sales / transactions | Attachment and merchandising strength | | Units per transaction | Units sold / transactions | Basket depth (watch units of measure) | | Ticket count | Count of transactions | Traffic, your conversion proxy | | Gross margin % | (Net sales minus COGS) / net sales | Pricing and cost health | | Sales per square foot | Annual net sales / selling sq ft | Space productivity | | Inventory turns | Annual COGS / average inventory at cost | How fast stock moves | | GMROI | Gross margin dollars / average inventory at cost | Whether inventory earns its keep | | AR aging | DSO and % over 60 days | Charge account health | ## Letting the software do the pulling Every formula above is simple. The hard part is pulling the numbers out of your system every week without turning Sunday night into a spreadsheet session, which is where Rundoo comes in for the stores we work with. Dooey, Rundoo's AI, answers plain-English requests like "Pull yesterday's sales," and a last-30-days sales report shows net revenue, units sold, gross profit and margin, and the daily sales pattern. It handles the charge account side too: ask "Which charge accounts are more than 60 days past due?" and you get the list. The Dooey Daily AI Summary arrives as a text message flagging below-cost sales, zero-profit lines, and low-margin items, with a link to the full report, so the margin problems find you before you find them. One paint store owner told us, "Tony and I have been using Rundoo extensively for our weekly sales meetings, and the AI-generated reports have become one of the most valuable tools in helping us manage the business." Whether you pull the numbers from Rundoo or from what you're using today, the rhythm is the same: a short list, every week, against the same week last year. The stores that know their numbers are the ones still here to count them. Share Topics [Product](/resources/guides/index.md#running-the-store) [← All guides](/resources/guides/index.md) ## Frequently asked questions What are the most important retail KPIs? For an independent supply store, the short list is gross margin percentage, average transaction value, ticket count, units per transaction, sales per square foot, inventory turns and GMROI, and accounts receivable aging. Review them weekly by department and compare each week to the same week last year, because the trade is seasonal. How do you calculate average transaction value? Divide net sales by the number of transactions. A store with $6,240 in net sales across 160 tickets has an average transaction value of $39.00. For reference, the NHPA's 2025 Cost of Doing Business Study put hardware stores' sales per customer at $39 for fiscal 2024. How do you calculate units per transaction? Divide the units sold by the number of transactions, so 512 units over 160 tickets is 3.2 units per transaction. Watch how items are set up, because selling rope or chain by the foot can count 100 feet as 100 units or as one, so compare the number within your own store over time rather than against other stores. How do you calculate sales per square foot? Divide annual net sales by selling square feet. A store with $1.8 million in net sales and 9,000 square feet of selling space produces $200 per square foot. Decide how you treat lumber yards, sheds, and outdoor nursery space, either tracking them separately or excluding them, and apply that rule the same way every year. ## Find out what Rundoo can do for your business Learn how Rundoo can help you save time, money and hassle running your business. [Book a demo](/signup/index.md) ! ## See Rundoo in action [Product ### Tour the platform POS, inventory, payments, and AI for independent supply stores, in one system.](/product/index.md) [Customers ### Read customer stories See how real paint, hardware, farm, garden, and lumber stores run on Rundoo.](/clients/index.md) ## Keep reading [![Compare sales last year to this year, with AI reporting](https://pub-5247264bd04e4ebeaecbbedb3bebb9f8.r2.dev/static/images/articles/ai-reporting-last-year-vs-this-year-photo.jpg) Product ### Compare sales last year to this year, with AI reporting To compare sales last year to this year, line up the same weeks and compare net sales, margin, and units by department, and an AI assistant in your POS lets you ask for that comparison, or a vendor or customer report, in a plain sentence instead of a report writer.](/resources/guides/ai-reporting-last-year-vs-this-year/index.md) [![Accrual vs cash accounting for a store with inventory](https://pub-5247264bd04e4ebeaecbbedb3bebb9f8.r2.dev/static/images/articles/cash-vs-accrual-accounting-for-retailers-photo.jpg) Product ### Accrual vs cash accounting for a store with inventory Cash accounting records money when it moves and accrual records it when it is earned or owed, and for a store with inventory and charge accounts the difference decides whether your monthly numbers mean anything, so here are the IRS rules, a worked example, and why most stores keep accrual books.](/resources/guides/cash-vs-accrual-accounting-for-retailers/index.md) [![End-of-day cash drawer closeout: till count and Z report](https://pub-5247264bd04e4ebeaecbbedb3bebb9f8.r2.dev/static/images/articles/end-of-day-cash-drawer-closeout-photo.jpg) Product ### End-of-day cash drawer closeout: till count and Z report Closing out a cash drawer means counting the till, pulling the Z report, comparing counted cash to expected cash, logging the over or short, and sealing the deposit, and this guide walks through each step with a sample cash count sheet.](/resources/guides/end-of-day-cash-drawer-closeout/index.md)