What Is the Last 30 Days Sales Summary Report?
This report pulls your store's most recent 30 days of trading into a single dated view. Rather than exporting orders and rebuilding a monthly total by hand, you open one preset report that already covers the trailing 30 days: order count, gross sales, discounts, returns, net sales, tax, duties, shipping, fees, and total sales, laid out by date.
Two distinctions are worth knowing before you read it. Net sales is gross sales after discounts and returns, so it reflects the merchandise revenue you actually kept. Total sales sits above that, adding tax, shipping, duties, and fees, so it describes what the orders were worth rather than what the store earned. The gap between the two is money you collect and pass on.
The window is preset to the last 30 days, so you are not picking dates every time you want a current read. That makes this the report to reach for when you want a fast, standing answer to "how did the last month go," rather than a full financial reconciliation or a custom date range.
Which Fields Are Included in the Last 30 Days Sales Summary Report?
The fields move from raw order volume through to the widest revenue figure, so one read tells you both how much sold and how the money broke down.
You can customize the pre-made report at any time by adding, removing, or rearranging fields to match the way you review your store.
Important Insights You Can Find in This Report
Did the last 30 days grow because of more orders or more spend per order?
Read Order Count next to Net Sales rather than looking at either alone. If net sales climbed while order count stayed flat, customers spent more per order, which usually points to bundling, upsells, or a price change working. If order count rose but net sales barely moved, you pulled in more buyers at smaller baskets, and it is worth checking whether discounting is doing the lifting.
Are returns quietly pulling down an otherwise strong month?
Gross Sales can look healthy while Returns erode the real number underneath. Track the returns line against gross and net sales across the dated rows. A returns figure that climbs in the back half of the window while gross sales hold steady tends to signal a product or sizing problem rather than ordinary buyer's remorse, and catching it early keeps it from compounding into the next month.
How much of your total sales is actually merchandise revenue?
Compare Net Sales against Total Sales. A wide gap between them is driven by Shipping, Tax, Duties, and Fee, all money you collect and pass on rather than keep. If Total Sales looks strong but the gap is large, the headline overstates what the store earned, which matters most if you ship heavy items, charge for delivery, or sell internationally where duties come into play.
THE ANALYST'S READ: The Signal Most Merchants Miss
Because this report is dated day by day, its most useful signal is not the 30-day total, it is where inside the window that total came from. Two stores can post the same net sales for the month while one built it steadily and the other earned most of it in the first ten days and then went quiet.
Read the Date rows for shape, not just sum. A total that is front-loaded and then tapers may suggest a promotion or launch that has run its course, so the number to watch next is whether the closing days of the window are trending below the opening ones. A total that builds toward the end could indicate momentum worth protecting with stock and ad budget. This is the read that separates the Last 30 Days Sales Summary from a financial reconciliation: it is less about balancing the components and more about whether recent performance is accelerating or fading. Compare the same 30-day summary week over week to see the pattern hold or break.
How Can You Automate the Last 30 Days Sales Summary Report?
You do not have to rebuild this every month. Open the pre-made Last 30 Days Sales Summary in Report Pundit, keep or adjust the columns, and press Save. Because the window is preset to the last 30 days, each time you run it you get the current month with no date changes.
From there you can export it as Excel, CSV, or PDF, or send it on a schedule. Report Pundit can deliver it by email or push it to Google Sheets or Google Drive daily, weekly, or monthly, so a current summary reaches you or your team without anyone opening the report.
Frequently Asked Questions
What time period does the Last 30 Days Sales Summary cover?
It covers the most recent 30 days. The window is preset, so you do not set a start and end date each time you open it.
What is the difference between net sales and total sales in this report?
Net sales is gross sales after discounts and returns, so it reflects merchandise revenue you kept. Total sales adds tax, shipping, duties, and fees on top, so it reflects the full value of the orders. The difference between the two columns is money you collect and pass on.
Why does the report include duties and fees?
Duties and fees only apply to some stores. Duties appear when you ship across borders and collect customs charges, and fees cover additional charges added to orders. If you do not collect them, those columns simply show zero and do not affect your net sales.
How is this different from the Finance Summary report?
The Last 30 Days Sales Summary is a quick snapshot of recent performance over a preset window. The Finance Summary report is a fuller reconciliation, with regional and year-over-year detail built for month-end close. Reach for this report to check how the last month went, and Finance Summary when you are balancing the books.
Can I change which columns appear?
Yes. Add, remove, or rearrange any of the fields so the report matches how you review sales.
Can I export or schedule this report?
Yes. Export it as Excel, CSV, or PDF, or schedule it to send by email, Google Sheets, or Google Drive on a daily, weekly, or monthly basis.
