Tally

Find sales below cost in Lightspeed Retail

Which lines were rung for less than they cost, or far off the normal price, and who rang them.

In Lightspeed

The Totals and Lines reports, under Reports, sum up cost, profit, and margin for a date range, and the Margins per line report shows the cost, profit, and margin on each sale line. Lightspeed suggests sorting it by cost to find inflated or $0.00 costs, which throw off your margin (Lightspeed’s guide). To find the lines sold at a loss, and who rang them, you read down the margin on every line.

With Tally

Ask “Are we selling anything below cost?” You get the lines sold below cost or more than 30% off the normal price in the last 30 days, biggest loss first, with the store, employee, discount, and cost on each, and totals by employee and category. Ask about this quarter, or a different discount, in your own words. Costs show only for people allowed to see them.

It also lists the lines sold with no cost on file. The merchandise margin leaves those lines out, so it covers less of your sales until their costs are added. It keeps a cost far above the price out of the losses, as a likely data error to fix.

From the demo shop, made up: 5 lines sold below cost in the last 30 days, a $631 loss. The biggest was a mountain bike rung at $1,500 at Hillcrest against a $1,950 cost. Three of the five were rung at Harbor by one salesperson, each 39% to 60% off.

Then follow up: “Just Harbor,” or “How much did that salesperson discount this year?”

Try it

Ask the demo shop on the home page: “Are we selling anything below cost?” The shop and its numbers are made up.

Tally works with Claude or ChatGPT, for $59 a month for the first store and $29 for each one after. Set up your shop

More Lightspeed questions