The Square Mistake That's Costing You Money (And How to Fix It)

We recently helped a customer who was struggling with analyzing staff performance in Square. She owned three coffee shops in Portland, and despite having a loyal customer base and decent foot traffic, her profit margins were way thinner than they should have been.

"I know something's off," she told me during our first call. "The numbers just don't add up. Same menu prices, same suppliers, but one location consistently underperforms."

I've had this conversation at least a dozen times in the past six months. And every single time, the answer is hiding in plain sight—right inside their Square data.

The Challenge: When Your Gut Feeling Meets Reality

Here's the thing about running a retail or restaurant business: you develop instincts about your team. You think you know who your top performers are. You assume you understand which employees drive sales and which ones need help.

But I've learned that our assumptions are wrong more often than we'd like to admit.

This particular customer—let's call her Sarah—was convinced her afternoon shift manager was her star employee. He'd been with her the longest, customers loved him, and he always seemed busy. Meanwhile, she thought her newest hire, working mornings at the underperforming location, wasn't pulling her weight.

The data told a completely different story.

What the Data Revealed

When we pulled Sarah's Square transaction data and ran it through our staff performance analysis tool, the results were eye-opening.

Her "star" afternoon manager? His average transaction value was $8.50. Not terrible, but nothing special.

The morning employee she was worried about? Her average transaction value was $14.20—nearly 70% higher.

But it got more interesting. When we dug into the details, we found:

Meanwhile, the afternoon manager we thought was a superstar had some concerning patterns:

The Surprising Insight

Here's what really blew my mind about Sarah's situation: she was losing approximately $3,200 per month—not from theft or fraud, but from missed opportunities and inconsistent training.

Think about that for a second. That's $38,400 per year just evaporating because she didn't know which behaviors to replicate across her team.

The morning employee wasn't doing anything magical. She was simply following the training she'd received at her previous job: suggest a pastry with every coffee, mention size upgrades naturally, and recommend the seasonal special. Basic stuff. But nobody else on Sarah's team was doing it consistently.

We see this pattern everywhere. I recently worked with a boutique clothing store where one employee's average sale was $127 while another's was $63. Same store, same products, same customers. The difference? One had learned to suggest complete outfits instead of individual items.

At a bike shop we analyzed, the top-performing employee had figured out that asking "What kind of riding are you planning?" led to accessory sales 68% of the time. Nobody had taught him that—he'd just stumbled into it. Meanwhile, his colleagues were missing those opportunities on every single sale.

Taking Action: What We Did Next

Once Sarah saw the data, she couldn't unsee it. We set up a plan:

First, we established baseline metrics for every employee:

Then, we identified the specific behaviors driving results. Sarah actually shadowed her top performer for a few shifts. She recorded the exact phrases and timing that led to upsells. Things like:

Simple stuff. But powerful when done consistently.

Next, we rolled out targeted training. Instead of generic "upsell more" directives, Sarah could now say: "Hey, I noticed your average transaction is $9.20. Let's work on getting that to $11 by suggesting pastries—here's exactly how Maria does it."

Specific. Measurable. Achievable.

Finally, we set up ongoing monitoring. Sarah now checks her staff performance dashboard every Monday morning. It takes her about 10 minutes. She can spot trends immediately and coach in real-time rather than waiting for quarterly reviews.

Results and Lessons Learned

Three months later, Sarah's results were remarkable:

But here's what Sarah told me that really stuck with me: "I feel like I actually know what's happening in my business now. Before, I was just guessing and hoping. Now I can see it."

That's the ROI that doesn't show up on a spreadsheet—confidence in your decisions.

I've seen this transformation dozens of times now. A gym owner discovered that one trainer was selling 10x more personal training packages than others—not because she was pushier, but because she timed the conversation differently. A hardware store found that their weekend staff needed better product knowledge training, costing them thousands in missed cross-sell opportunities.

The pattern is always the same: businesses assume they know what's happening, but the data reveals a different reality.

Your Turn: What's Hiding in Your Data?

If you're using Square POS, you're already collecting this data. Every transaction, every employee, every shift—it's all there, waiting to tell you something important about your business.

The question is: are you listening?

Most businesses we work with are shocked by what they discover. Sometimes it's good news—a hidden superstar who deserves recognition. Sometimes it's concerning—patterns that need immediate attention. But it's always valuable.

I'd encourage you to run this analysis this week. Don't wait. Every day you operate without this insight is a day you're leaving money on the table.

Want to see exactly what we saw in Sarah's data? We built a tool that does this analysis automatically. Just connect your Square account, and within minutes you'll have a complete breakdown of staff performance across every metric that matters.

Try the Staff Performance Analysis tool now →

And if you're interested in other ways to optimize your Square data, check out our guide on understanding Square tax and fee structures—it's another area where small insights can lead to significant savings.

We also offer personalized analytics consulting services if you want help interpreting your data and building a custom action plan. Sometimes it helps to have someone who's seen these patterns before guide you through the process.

The data is there. The tools are ready. The only question is: what are you going to discover about your team?

I'd love to hear what you find. Seriously—email me your results. The patterns we uncover together help us build better tools for everyone.

Here's to finding your hidden superstars (and fixing those expensive blind spots).