How a 20-minute Monday report replaced my 3-hour spreadsheet ritual

The problem

Every Monday morning, I did the same thing. I exported orders from WooCommerce, opened a spreadsheet, fixed the date columns, built a revenue chart, copied the numbers into a document, exported it as a PDF and emailed it to my business partner. Then I did a second version for our accountant.

It took about three hours. It was also the only time we looked at the numbers together. The ritual was not just reporting. It was how we ran the business.

The old way

Export, clean, pivot, format, PDF, email. Multiply by four Mondays and add a monthly version. I once spent an entire day rebuilding the file after a WooCommerce update changed the export columns.

The reports were always out of date by the time they arrived. If I saw something odd on Wednesday, I had to remember to check it the following Monday.

The new Monday routine

Now I open one dashboard. It has the six reports we actually use: revenue by week, orders by status, top products by revenue, new vs returning customers, coupon usage and low stock. They are built-in reports, so they do not use AI and they do not depend on your API key.

For anything custom, I ask:

“Compare last month’s revenue with the same month last year. Break it down by category and show me the change in percentage.”

Then I ask a follow-up:

“Which categories drove the difference?”

Once a month I turn the conversation into a summary, pick the email template with our logo and send it to my partner and accountant as a PDF. The template is editable, so I do not rebuild the layout every time.

The catch

On the third Monday, the coupon usage report showed something I had not noticed: a 20% code was being used far more than usual. I asked:

“Which coupon codes were used most in the last 30 days, and what was the total discount given?”

One code had been used 84 times for $3,120 in discounts. It was a code we had created for a local event and never set a usage limit on. It had been shared on a deal forum. We paused it that afternoon.

What I did

1. 1. Built a dashboard with the six reports we review every Monday.
2. 2. Saved two email templates: one for the weekly internal update, one for the monthly accountant pack.
3. 3. Set a 20-minute calendar block on Monday. If the dashboard is green, we are done.
4. 4. Added a coupon usage check to the weekly review.
5. 5. Kept the spreadsheet for one thing only: the annual tax pack.

The result

The weekly routine went from three hours to twenty minutes. The bigger change was that the numbers were the same every week, so we could compare them without wondering which file was the latest one.

What I’d do differently

I’d start with fewer reports. My first dashboard had fourteen tiles and I stopped looking at half of them. Six is enough for a weekly rhythm.

I’d also set coupon usage limits at creation, not after a code shows up on a deal site. And I’d keep the AI questions for things the built-in reports do not cover. Using it for everything made the routine slower, not faster.