Introduction
Total sales can look healthy while profit slips out the back door. Slow-moving stock ties up cash. Discounts and refunds eat margin. Cash drawers drift. Labor hours pile up on quiet afternoons.
A weekly POS review is a short, focused routine that turns transaction data into decisions about sales, inventory, cash control, staffing, and customer retention. Shopify's profit reporting shows why sales alone mislead: gross profit is net sales less product costs, so discounts and refunds change the result.
This guide covers the reports worth running each week, with examples for garden centers, farm markets, feed and seed stores, and outdoor sporting goods retailers.
Key Takeaways
- Run sales, inventory, cash, exception, employee, and customer reports every week.
- Compare against a relevant period before reacting to a change.
- Give every finding an action, an owner, and a follow-up date.
- Choose a POS that keeps data accurate and easy to export.
Weekly Sales and Profitability Reports
Weekly sales summary report
Start with last week's core figures:
- Gross sales and net sales
- Transaction count and units sold
- Average transaction value
- Taxes, discounts, refunds, and returns
Definitions vary by system. Gross sales is typically price times quantity before returns and discounts. Net sales subtracts returns and discounts. Check how your report treats gift cards and other liability items.
Compare against a similar baseline: the prior week, the same days last year, or a comparable seasonal stretch. A rainy April week versus a sunny Memorial Day week tells you nothing.
Garden Center Group tracks this kind of data on a schedule. Its weekly department review covers more than 25 categories across 120+ centers.
Product and category performance report
Sort by SKU, category, vendor, department, or location. Look for both ends of the list:
- Best sellers: seasonal plants, bagged pet food, popular seed varieties, trending outdoor gear
- Slow movers: items that sat all week despite good placement
These trends guide reorder priority, cross-selling, markdowns, and shelf space. If a seed variety outsells its neighbors three to one, it probably deserves a bigger spot.
Margin and discount analysis
Revenue is not profit. Review product cost, gross margin, discounts, promotions, refunds, and returns when your POS or accounting integration includes them.
A category can lead in revenue and still drag margin down. Picture a patio furniture line that sells well only at 30% off, with a steady stream of returns. Gross margin percentage is ((net sales − cost) / net sales) × 100, so heavy discounting shrinks it quickly.
Products without recorded costs may drop out of profit reports. Fix those records first.
Time, location, and register breakdowns
Sales by day, daypart, store, register, or channel show when demand actually arrives. Use them to set staffing, plan replenishment, and test opening hours.
AMS Retail's POS, for example, supports scheduling employees around hourly sales volume. If Saturday mornings spike and Tuesday afternoons stall, shift hours accordingly.
Turn findings into a weekly decision
Tie each finding to one action:
- Reorder a fast seller
- Reposition a slow mover
- Change a promotion
- Adjust staffing
- Monitor a margin issue for another week
Don't overreact to one odd week. Confirm the pattern persists or has a clear cause, such as weather, a promotion, a delivery delay, or an inventory count.
Inventory and Product Performance Reports
Inventory-on-hand and reorder report
Review current stock, committed stock, open purchase orders, reorder points, low-stock alerts, and recent sales velocity. Together they show what to order now.
A common reorder point formula is daily sales velocity times lead time, plus safety stock. Lead time matters most for short selling windows. Spring bedding plants or hunting-season gear won't wait for a late shipment.
Sell-through, aging, and slow-mover report
Sell-through compares what sold against what you had available. Formulas differ between reports, so confirm your system's denominator before comparing numbers. Aging reports flag stock with no recent sales. Many systems default to 180 days, but that cutoff is a software setting and does not suit seasonal goods.
Match findings to action:
- Aging nursery stock: bundle or mark down before quality drops
- Last year's outdoor goods: clear before the new line arrives
- Excess feed varieties: pause purchasing
- Inconsistent pet products: transfer between stores or order smaller quantities
Inventory adjustment and shrink report
Review manual adjustments, damages, transfers, write-offs, returns, and gaps between recorded and counted stock. Look for patterns by item, location, register, employee, or date.
Shrink isn't only theft. The NRF 2023 survey attributes 27% of loss to process and control failures and errors, versus 36% external theft and 29% internal theft. A repeated discrepancy on one item or shift should trigger a recount, a process review, or, if the pattern holds, a loss-prevention look.
Product-data accuracy check
Spot-check SKUs, categories, vendors, units of measure, costs, prices, and pack sizes each week. A wrong pack size or missing cost quietly distorts sales, margin, and reorder reports. For feed and seed, unit-of-measure errors on fractional or bagged goods are common culprits.
Link inventory findings to purchasing decisions
End with a short purchasing list:
- Reorder items at or below reorder point with steady velocity
- Delay purchases on slow movers or overstocked SKUs
- Transfer stock between locations to balance on-hand inventory
- Mark down or promote aging goods before they lose value
Accurate inventory reporting helps reduce shrink, prevent stockouts, support cash flow, and protect margins.
Cash, Payment, Reconciliation, and Exception Reports
Financial summary report
Review gross sales, net sales, taxes, discounts, refunds, returns, tips, and total tendered. Know which figures are revenue and which are cash collected. Sales tax, for example, is collected but isn't yours.
Read this report beside margin and expense data. Sales totals alone don't measure business health.
Payment and tender report
Check cash, credit, debit, gift cards, mobile payments, and any other tender you accept. Then compare POS totals with processor settlements and bank deposits.
They rarely match on the same day. Global Payments separates settled batches from deposits. Fees, disputes, and batch timing all affect what lands in the bank. Account for unsettled transactions before chasing a phantom shortage.
Cash drawer and reconciliation report
For each register or location, review:
- Expected cash and opening float
- Paid-outs, cash drops, and refunds
- Counted cash
Over/short is actual cash minus expected cash.
Document every variance promptly. Then look for patterns by shift, register, location, or employee. Small differences that repeat are the ones to catch early.
Discounts, refunds, voids, and overrides report
Review each exception by:
- Amount and item
- Employee and approval
- Reason, date, and time
Most are normal customer service. Some point to training gaps.
Unusual increases may signal unclear policies, pricing errors, loose permissions, ring-up mistakes, or shrink. The Association of Certified Fraud Examiners (ACFE) suggests calculating void counts and amounts by clerk to spot outliers.
X and Z reports
An X report is generally a point-in-time snapshot. A Z report is typically the final closeout. Behavior varies by system, so confirm how yours works, including whether it resets totals.
You may run Z reports daily, but review the full week's set for missing closeouts, inconsistent closing times, and unresolved reconciliation items.
Employee, Transaction, Customer, and Promotion Reports
Employee sales and activity report
Where available, review these metrics by employee:
- Sales and transaction counts
- Average transaction value
- Discounts, refunds, and voids
- Hours worked
Use the report for coaching, scheduling, permission reviews, and sharing what works. Don't judge individuals without context. Shift assignments, product mix, and foot traffic all shape the numbers, and sales-per-hour figures depend on accurate time-clock records.
Transaction and audit-detail report
Filter transaction records by date, register, location, employee, payment method, status, refund, or exception. This is your tool for customer disputes and unexplained variances. When a till is short on Thursday evening, the transaction detail shows what happened.
Customer, loyalty, and promotion report
If your POS captures them, review:
- New versus returning customers
- Loyalty activity and coupon use
- Customer spend
AMS Retail's software, for instance, tracks where customers come from and reports on coupon performance.
Compare results to each campaign's goal. Read them alongside discounts, margin, stock availability, and transaction volume. A coupon that moves 200 units but wipes out margin isn't a win.
Mind privacy. The FTC advises keeping sensitive personal information only as long as needed and limiting access. State laws such as California's may apply depending on your size and data volume.
Weekly POS Review Workflow
Prepare and validate the data
Before reviewing, confirm that:
- All registers are closed and transactions synced
- Returns and refunds are posted
- Inventory adjustments are entered
- The date range is consistent
Export the reports, record your comparison period, and note unusual events: promotions, closures, severe weather, deliveries, or counts. If you export to CSV, beware of long SKUs losing leading zeros; XLSX avoids this.
Review reports in decision order
- Review financial and sales summaries for revenue, margin, and period trends
- Check product and inventory performance for top sellers, dead stock, and shrink
- Inspect cash and exceptions for till variance, voids, and refunds
- Scan employee and customer trends for labor cost and loyalty signals
Mark each finding "keep," "fix," or "test." Assign an owner and deadline to every action. Reports without follow-through are just paperwork.
Make the routine repeatable with the right POS
A useful POS keeps reports accessible, customizable, filterable, and exportable across one store or many. It also keeps data dependable when the connection drops.
AMS Retail Solutions is an authorized NCR Voyix Counterpoint provider serving specialty retailers. Counterpoint includes a "Bird's Eye View" dashboard, customizable reporting tools, and offline POS capability, with 24/7 support. Verify any offline card-payment behavior with your processor, since offline selling and offline card processing aren't the same.
Close the loop with a short weekly meeting. The next week, check whether each action moved its target metric: sales, stock, margin, cash control, or customer behavior.
Frequently Asked Questions
What are the main types of POS reports?
Sales, inventory, financial and payment, employee, transaction, and customer or promotion reports. Exact names vary by POS platform.
What does POS stand for and what does it mean?
POS means point of sale. It refers to the software and hardware used to complete purchases while recording sales and operational data.
Which POS reports should a retail owner run every week?
Sales, product and inventory, payment and reconciliation, exception, and employee reports. Add customer or promotion reports if your POS captures that data.
How do POS reports help with inventory management?
They reveal sales velocity, low-stock items, slow movers, adjustments, shrink, and reorder needs. That informs purchasing and merchandising.
What is the difference between an X report and a Z report?
An X report is generally an interim snapshot. A Z report is generally the final daily closeout. Confirm terminology and reset behavior in your own POS.
