opinion

How Automation Eliminates the Month-End Chase for Retail Reports

How Automation Eliminates the Month-End Chase for Retail Reports

On Jan. 3, 2021, I walked into our flagship store in Pleasant Hill to replace the point-of-sale system, the software stores use to ring up sales, track inventory and manage day-to-day transactions. It was my first job at Secrets. The plan was two weeks per store: install the system, enter the inventory, write the training manual, train the manager and staff, then drive to the next one.

The flagship took closer to three weeks, and there were 22 stores. I fit the rest of my job around the road, took Christmas off and rushed back to San Francisco to finish the last store in the final week of December so every location would start 2022 on Lightspeed, our new retail management system.

Repetitive reporting should not require employees to repeatedly assemble information that a system can already gather.

On Oct. 1, 2026, at 7 a.m. Pacific, a scheduler on our server sent 44 reports: a September monthly report and a Q3 quarterly report for each of 21 stores. Each report went to the store manager, with both owners and me copied. Zero failed, zero were skipped, and nobody logged into anything.

The rollout that made that morning possible took about three weeks, and I never left my desk. The distance between those two timelines is what this article is about.

The Chase

Here is what month-end looked like at Secrets on Sept. 1. Each manager logged in to Lightspeed Analytics, the reporting side of our retail software, downloaded three reports, entered figures into a daily spreadsheet comparing this year’s performance with last year’s, wrote a summary, and emailed it to the owners.

That was the version that worked. When it didn't, the owners and I spent the first week of the month chasing managers who hadn't submitted their reports. Some never did, and those who did each formatted theirs differently, so before the owners could compare two stores, they had to interpret two different documents.

That meant 21 managers assembling reports, two owners translating and following up, and me following up. We were all spending time on the part of the job that required no judgment, gathering and organizing information, instead of the part that did: deciding what to do about it.

This problem is not unique to retail. In almost any business, recurring reporting can become a job in its own right. Someone has to pull the numbers, organize them, send them, and remind everyone else to do the same.

If you run one store, you may be the manager, owner and chaser all at once. The month-end report becomes the thing you do at 11 p.m. because everything else came first, largely because nobody ever built you a report that arrives already done.

What Arrives Now

The email that arrives at 7 a.m. is already summarized. At the top are the key metrics our strongest managers already use to understand their store’s performance, including the number of sales, average amount spent per transaction, and this year’s results compared with last year’s. Below that are the details, followed by a link to the dashboard where managers can explore the numbers further.

The owners are copied on every store report, so even if a manager never opens hers, they still have an overview on the first of the month. The first conversation can start with, “Why is this number down?” instead of, “Where is your report?” The chase is gone.

The important change is not simply that a computer sends an email. The system removes the repetitive work that used to be done before anyone could begin analyzing the information.

Three Weeks, No Road Trip

Replacing a point-of-sale system is a physical job. Inventory has to be entered into the new software, and staff has to learn how to process a sale, handle a return, and close out a register at the end of the day. Rolling out an ordering and reporting tool is not the same size of job, but the training challenge is comparable.

In 2021, every store needed a manual, and every manager needed someone standing beside their the first time they performed a task the new way. This time was different.

We decided on scope on Sept. 17. We sent rewritten manuals, a supplement, and a two-week training plan on Sept. 29. Managers stopped using Lightspeed Analytics on Oct. 1, shifting those reporting functions to Retalyz, the internal system we now use for ordering, reporting, and related workflows. An in-person session for all managers was scheduled after Oct. 8 vendor training. The transition took about three weeks, with no store visits.

Three decisions made the difference, and none were particularly technical.

First, the tools were built to fit the workflow managers already had. The monthly email reproduces the information our best managers were already gathering on their own, so it does not require them to learn an entirely new reporting process. It simply delivers the report they were already producing.

Second, we trained only on the tasks Retalyz now handles. Instead of adding a separate chapter on a new piece of software, we rewrote the instructions for the tasks it replaced, including creating orders, receiving merchandise, transferring products between stores, tracking markdowns, counting inventory, and comparing monthly and quarterly performance. Every new step maps to an old one.

Third, we simplified the portal before launch. A larger redesign was shelved in favor of smaller fixes, including a single navigation menu, consistent terminology, and dashboards tailored to each employee type's actual needs.

The test was simple: Could a manager learn it without someone standing beside her?

The most expensive part of a rollout is often changing people’s habits, not installing software. Building a tool around an existing workflow can make the transition significantly easier because employees do not have to relearn the entire job just to use a new system.

That is the build-versus-buy argument this series has been making, restated in cost terms. Software built for the average customer often requires your employees to adapt their workflow to the software. A tool built around your organization can work the other way around.

The Part I Did Not Expect

Managers got their hours back, and owners got their mornings back. However, my workload went up because every repetitive task that disappears reveals another question that previously took too much time or effort to investigate.

For example, should inventory targets limit how much each store orders? That feature is live at four of 21 stores and is still being adjusted. Which sales were started but not completed? Were returned products properly returned to inventory? What does performance look like when the company is viewed across different corporate entities?

None of those questions were on my list on Sept. 1. They are now because the routine work that used to sit in front of them is gone. That is one of the less obvious effects of automation. Saving time does not always mean there is less work. Sometimes it enables higher-value work.

What’s Next

In 2021, I was on the road for a year. In 2026, a similar training challenge took three weeks away from my desk because I had spent the year building toward it.

The work is not finished. The manager narrative page and a button to let managers easily forward their comments to the owners are next. Inventory targets remain under review, and an off-platform database backup is planned but not yet implemented.

Retalyz now runs the reporting and ordering workflows for all 21 of our stores using Lightspeed Retail, as well as for a second retail chain using Lightspeed X-Series, formerly known as Vend. The specific software matters less than the broader lesson: repetitive reporting should not require employees to repeatedly assemble information that a system can already gather.

Zondre Watson is the general manager of technology and analytics for adult retail chain Ero-Tech. With a background in finance, chocolate and controlled chaos, he blends retail know-how with AI tools to keep 17,000 products moving smoothly.

Copyright © 2026 Adnet Media. All Rights Reserved. XBIZ is a trademark of Adnet Media.
Reproduction in whole or in part in any form or medium without express written permission is prohibited.

More Articles

opinion

Why Better Sizing Can Help Pleasure Brands Reach More Customers

In the sexual health industry, we must be ready to problem-solve around every corner, especially in retail. You never know who will walk through your doors or what they might need or want that day, not to mention curveballs such as disabilities, neurodivergence, trauma responses, and, of course, body image sensitivities.

Mersy Love ·
profile

WIA: Barnaby's Amy Carnegie Draws on Retail Roots to Shape Product Development

In 2012, Amy Carnegie was pursuing a master’s degree in forensic psychology and looking for a part-time job close to home when she discovered Good Vibrations’ newly opened Oakland location. The store was on the same bus route she took to school, making it a convenient option. She didn't anticipate the position would lead to a nearly 15-year career, during which she would rise through the ranks to become head of buying and product development for Good Vibrations, Babeland and Camouflage.

Ariana Rodriguez ·
opinion

What Retailers Should Know About Pheromones and Attraction

A woman stands at your counter. She dabs a drop of something clear and nearly odorless on her wrist, brings it to her nose and something in her posture changes before she even leaves the store. A few feet away, a man turns a small bottle over in his hand, reading the label twice and wondering whether it might help him feel noticed again by a longtime partner.

Susan Bratton ·
opinion

How Retailers Can Turn AI-Assisted Reporting Into a Scheduled Workflow

If you have been following this series, you know I have been climbing a ladder. First, I asked an AI model to do a task. Then I got tired of explaining the task every time, so I wrote a skill, a reusable set of instructions, and put it in a project folder with everything the task needed.

Zondre Watson ·
opinion

Retailer Tips for Making Trade Show Travel Pay Off

When sales slow, retailers understandably start looking for ways to tighten the budget. Every expense gets another look, and travel and trade show attendance can quickly end up on the list of things to cut.

Rin Musick ·
opinion

Why Adaptive Pleasure Belongs Across Every Adult Retail Category

For too long, accessibility in adult retail has been treated as a side conversation. When it appears at all, it is often tucked away in a hard-to-find website category, framed as a special accommodation or treated as a medical add-on rather than a legitimate pleasure category. That approach misses the point.

Hail Groo ·
opinion

Why Retailers Need a Clearer Conversation About Margins

With rising manufacturing costs and living expenses, manufacturers’ suggested retail price (MSRP) no longer aligns with the actual costs of operating a business. This situation calls for a discussion about the current industry pricing landscape, potential adjustments, and how companies can make an impact.

Mersy Love ·
profile

WIA: Perfect Fit Brand's Cee Cee Peters on Building a Lasting Career

For much of her decades-long career in the adult products industry, Cee Cee Peters let her work speak louder than her name. While she built relationships with retailers, became a top salesperson, and watched the business evolve from a movie-dominated marketplace into today’s sexual wellness industry, Peters deliberately kept a relatively low public profile. Raising children during the rise of the internet made that decision especially important to her.

Ariana Rodriguez ·
profile

A Look Inside CC Wellness' Production Process

Stepping through the front doors of CC Wellness’ 215,000-square-foot headquarters, you first encounter the lubricant manufacturer’s comprehensive process in the company’s wall of plaques, which celebrate more than 25 formulas that have received FDA 510(k) clearances for medical devices.

Ariana Rodriguez ·
trends

A Look at the Growing Market for Pleasure-Enhancing Consumables

For decades, the sexual enhancement aisle consisted mainly of pills promising stamina, with bottles and blister packs leaning heavily into themes of masculinity, urgency and performance. The sales pitch was rarely subtle: Take this, and something bigger, harder, longer or more intense would follow.

Ariana Rodriguez ·
Show More