What Is the Finance Summary Report?
The Finance Summary Report is a Shopify report that breaks each order down financially, from gross sales at the top through discount, returns, net sales, shipping, tax, and duties, ending at total sales. Each row carries the date, order name, order ID, and product name, so you can see how a single order builds up to its final booked figure.
It helps to keep three numbers separate. Gross sales is product price times quantity, before anything is taken off. Net sales is gross sales minus discount and returns. Total sales sits on top of net sales and adds shipping, tax, and duties, so it is the widest revenue figure Shopify reports, not your profit.
Merchants open this report when a period total looks fine but they need to see which orders, discounts, or refunds actually moved it. Because every line is order-level, this is the report to reach for when a summary number needs explaining rather than just displaying.
Which Fields Are Included in the Finance Summary Report?
These fields let you trace an order from its raw sale value down to what was actually booked.
You can customize the pre-made report by adding, removing, or reordering fields so it matches the way your team reviews numbers.
Important Insights You Can Find in This Report
Which orders are quietly pulling net sales below gross?
Line gross sales up against net sales, order by order. When the gap is wide on specific rows, the cause is sitting in the discount or returns column for those same orders. One heavily discounted order or a cluster of returns can drag a period down while gross sales still looks healthy. Sorting by the size of that gap shows you exactly which orders to look at, rather than guessing from a period total.
Is shipping and tax inflating total sales past what you actually keep?
Total sales adds shipping, tax, and duties on top of net sales, so it is always the biggest number on the page. If someone reads total sales as revenue, the shipping and tax columns show how much of that figure is pass-through money you collect and remit, not income. Reading net sales and total sales side by side keeps that distinction clear before the numbers reach a spreadsheet or your accountant.
Are duties showing up where you expected them?
Total duties should appear on international orders and stay empty on domestic ones. If duties are blank across orders you know shipped abroad, or appear on orders that should be domestic, that points to a duty or destination setting worth checking before the figures feed into any tax or landed-cost review.
The Analyst's Read: The Signal Most Merchants Miss
The relationship worth watching over time is the spread between gross sales and net sales as a share of gross, tracked across periods rather than in a single month. A widening spread means discount and returns are eating more of your top line each period, even when gross sales is flat or rising.
This is easy to miss because gross sales can keep climbing while the money you actually keep does not move. If you group the report by month and compare net sales against gross sales, a steady drift downward could indicate discount habits creeping up, a product with a rising return rate, or promotions moving units without protecting revenue. It is worth checking which orders and products sit behind the drift, since the fix is usually specific to a few products or a few discount codes rather than the whole store.
How Can You Automate the Finance Summary Report?
Once the template is set the way you want it, you do not need to rebuild it. Open Report Pundit, load the pre-made Finance Summary Report, set your date range, and save. From there you can schedule it to run and send on its own, daily, weekly, or monthly, so a month-end version lands without anyone building it by hand.
You can deliver it as Excel, CSV, or PDF, or push it to Google Sheets or Google Drive, and send it to more than one recipient, so the same file reaches your team and your accountant on the same schedule. Grouping by week or month turns the static list into a trend you can watch across periods.
Frequently Asked Questions
What is the difference between net sales and total sales in this report?
Net sales is gross sales minus discount and returns. Total sales adds shipping, tax, and duties on top of net sales. Net sales is the revenue figure after adjustments; total sales is the widest booked figure and includes pass-through amounts you remit.
Why does gross sales look high when net sales is lower?
Gross sales is product price times quantity before anything is deducted. Net sales removes discount and returns. A large gap on an order means a heavy discount, a return, or both are sitting on that row.
What does Total Duties show?
Total duties is the import or customs duties on an order, which mainly appears on international sales. Domestic orders usually show no duties.
What is the difference between Order Name and Order ID?
Order Name is the store-facing label you see in your admin, such as #1024. Order ID is the unique internal identifier Shopify assigns. Both point to the same order.
Can I filter this report to focus on part of the data?
Yes. You can filter by date range and narrow the report to a specific product or order, so you can study one slice on its own instead of the full list.
Can I add or remove fields?
Yes. The pre-made report comes with these fields set, and you can add, remove, or reorder columns so the report matches how your store reviews its finances.
Can I export and schedule this report?
Yes. You can export to Excel, CSV, or PDF, push to Google Sheets or Google Drive, and schedule automatic delivery to yourself and your team daily, weekly, or monthly.