Finance Summary
Report for Shopify

The Finance Summary Report provides an overview of your store’s financial performance by aggregating key revenue, expense, and tax data. This report helps store owners understand their overall profitability, cash flow, and key cost drivers, making it essential for budgeting and financial planning

Star

5 from 1,800+ merchants

2,000+ data fields

Trusted by 40,000+ Shopify stores

Updated June 2026

What this report is
The Finance Summary Report is a Shopify report that reconciles a period’s revenue — gross sales, discounts, returns, net sales, shipping, and tax by region — alongside refunds and year-over-year comparison. Report Pundit provides it as a free pre-built template with scheduling and exports to Google Sheets, Excel, CSV, or PDF for month-end close.
Report type
Financial reconciliation summary
Best for
Finance, bookkeepers, accountants, owners
Refresh
On run or schedule
Setup time
~6 minutes
Tracks
Gross→net revenue, tax by region, shipping, refunds, YoY
Export to
Google Sheets, Excel, CSV, PDF
Scheduling
Yes — monthly close cadence
Shopify plan
All plans, including the free Report Pundit plan
Keep up with Shopify reports
We promise we won’t spam you.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Why this report matters

Month-end close shouldn’t start with five CSV exports. Yet that’s how most stores reconcile: one file for sales, one for taxes, one for refunds, and a manual stitch to get a single defensible revenue figure.

Shopify’s finance reports are useful but partial — tax detail and year-over-year comparison get thin on lower plans, and nothing schedules itself for the close. Your accountant ends up asking for the same breakdown every month.

A single finance summary that walks gross → discounts → returns → net → shipping → tax, split by region and comparable year over year, turns the close from an afternoon into a review. This is reporting, not advice — always confirm figures with your accountant before filing.

What’s included

Never just a list of column names. Every column gets a plain definition, plus a formula, a worked example, or a heads-up wherever it earns one.

Revenue reconciliation

Gross sales

Product revenue before discounts, returns, shipping, and tax.

Formula:  Gross sales = Σ (unit price × quantity)

Discounts

Total discounts applied in the period.

Returns / refunds

Value refunded in the period, reducing revenue.

Heads up:  Refunds are recognized on the refund date, not the original order date — this can shift a figure across a period boundary.

Net sales

Revenue after discounts and returns.

Formula:  Net sales = Gross sales − Discounts − Returns

Total sales

Net sales plus shipping and tax — the top-line booked figure.

Formula:  Total sales = Net sales + Shipping + Tax

Tax & shipping

Tax collected by region

Tax broken out by jurisdiction (country/state), the view filing needs.

Example:  CA $1,240 · NY $980 · TX $610 for the month.

Shipping charged

Shipping revenue collected from customers.

Shipping cost

What fulfillment actually cost, where available.

Heads up:  Shipping cost only appears if you feed it in — via a carrier/3PL integration or a calculated column; Shopify doesn’t store your true cost natively. [verify]

Comparison

Net payments

Amounts settled to you after gateway activity, useful for matching payouts.

Heads up:  Processor fees and payout timing vary by gateway; reconcile against your payout report, not just this summary.

Year-over-year

The same period last year beside this year, with the delta.

Formula:  YoY % = (This year − Last year) ÷ Last year × 100

Common added columns

Who uses this report

01

Bookkeeper

Situation
You close the books on the 3rd of each month.
Look at
The gross→net→total build-up plus tax collected by region.
Decision
Post net sales and tax liability to the ledger and reconcile against payouts.
02

Owner

Situation
You want a quick read on whether margins held.
Look at
Net sales and YoY delta, with shipping charged vs cost.
Decision
Decide whether shipping is leaking margin and whether to revisit your shipping rates.
03

Accountant / advisor

Situation
Quarterly tax prep is due.
Look at
Tax collected by jurisdiction across the three months.
Decision
Prepare filings per region without rebuilding the breakdown from raw orders.
04

Finance analyst

Situation
Board pack needs a YoY revenue slide.
Look at
This period vs the same period last year, net and total sales.
Decision
Drop the comparison straight into the deck instead of recomputing it.

How to read the report

  • Walk the build-up top to bottom. Gross, then discounts, then returns, then net. If net looks off, the leak is almost always in discounts or refunds.
  • Separate shipping revenue from shipping cost. Charging $6 and paying $9 to ship is a quiet margin drain that only shows when you put the two side by side.
  • Read tax by region, never in aggregate. Filing is per jurisdiction; an aggregate tax number is useless at close.
  • Trust payouts over gross for cash. Net payments after fees is what actually lands in the bank — reconcile to it.

How to build the report in Report Pundit

Under 5 minutes from install to insight. No code, no SQL.
  1. Open Report Pundit in your Shopify admin and choose Create Report (or the pre-built “Finance Summary” template).
  2. Set the data source to Sales / Finance.
  3. Add the revenue build-up columns: Gross sales, Discounts, Returns, Net sales, Shipping, Tax, Total sales.
  4. Add a Tax-by-region grouping (country/state) so jurisdictions break out.
  5. Add Refunds and, if you have it, a Shipping-cost column (from a 3PL/carrier integration or a calculated field).
  6. Set the date range to the calendar month (or quarter) you’re closing.
  7. Add a prior-year comparison for the same range to populate the YoY column.
  8. Run, reconcile net sales and tax against a known figure, and Save.
  9. Schedule it to send on your close date to finance and your accountant via email or a shared Google Sheet.

Sample report

What you'll see when you run the report. Fully interactive in your store — click any channel to drill into orders, customers,or products.

Customization & filters

The pre-built version covers 90% of merchant needs. For the remaining 10%, common customizations:
  • Switch between monthly, quarterly, and annual close periods.
  • Group tax by country, state/province, or both.
  • Add a calculated gross-margin line if product cost is set in Shopify.
  • Filter to a single channel or location for entity-level reporting.
  • Convert multi-currency stores to a single reporting currency.

Automate & export

Once the report is set up the way you want it, automation does the rest:
  • Schedules — hourly, daily, weekly, monthly, or custom cron
  • Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
  • Group by month or week — trends instead of a static snapshot
  • Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
  • Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week

Report Pundit vs Shopify's native Sales by Channel report

Shopify ships a basic version. Here's where it stops — and what Report Pundit adds.
Capability Shopify built-in Report Pundit
Tax broken out by region Limited by plan ✓ Country / state
Year-over-year comparison Advanced / Plus only ✓ Any plan
Shipping charged vs cost side by side × ✓ (with cost feed)
Multi-currency consolidation ×
Available on every Shopify plan Shopify / Grow plan & up — not on Basic ✓ All plans, incl. free
Scheduled email / Slack delivery × ✓ Daily, weekly, multiple/day
Export to Google Sheets in real time × (manual CSV only) ✓ Live sync
Add custom / calculated columns × (saved custom reports: Advanced/Plus only) ✓ 2,000+ fields
Combine with app data (PayPal, ShipStation...) × ✓ 30+ integrations
Multi-store reporting (Plus) ×

Frequently Asked Questions

How is net sales different from total sales?

Net sales is gross minus discounts and returns. Total sales adds shipping and tax on top. Net sales is the revenue figure; total sales is what was booked including pass-through amounts.

Can I see tax collected by state or country?

Yes. Group tax by jurisdiction to get the per-region breakdown filing requires, instead of a single aggregate number.

Does it show my shipping cost, not just what I charged?

It shows shipping charged natively. True shipping cost only appears if you feed it in through a carrier/3PL integration or a calculated column, since Shopify doesn’t store your real cost.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Benefits

Net Profit

Net Profit

Understanding the net profit after all expenses.
Sales Performance

Sales Performance

Tracking sales performance over time.
Areas of Cost

Areas of Cost

Identifying key areas of cost, such as transaction fees and COGS

Sales Over Time

Leverage historical data with the Sales Over Time Report. This report covers costs, order details, sales channels, and payment methods, helping you track trends, manage sales tax returns, and assess the effectiveness of each sales channel.

Sales by Checkout Currency

This report displays the breakdown of your sales by customer currency used at the checkout with the total sales value also being displayed in your local currency.

Sales by Product

The Sales by Product report offers details about each product’s sales performance over a given time frame. It provides valuable insights into which of your products are and aren’t selling well. These insights will enable you to make informed decisions about inventory management and marketing and improve your business.

Sales by Channel

The Sales by Channel report displays sales data based on the source of each sale. It's a valuable report offering insights into multichannel Shopify selling.

Sales by Discount Code

Sales by Discount Code report in Report Pundit provides a detailed analysis of sales generated through specific discount codes over a defined period.

Refund

Report Pundit’s Refund Report records the details of money returned by a Shopify merchant to unsatisfied customers when they return the product/service. These reports help the merchant keep track of the refunds issued, monitor customer satisfaction and have a proper record of financial transactions for filing taxes.

Order Tags and Line Item Properties

A detailed report built to include order tags and line items added to each placed order, along with essential sales and product details for thorough analysis and processing.

Sales by POS

The report provides detailed sales figures and net product counts, accounting for refunds, at each POS location, offering a clear view of actual sales performance and inventory movement.

Last 24 Hours Orders

Use the Last 24 Hours Orders report to stay updated on all orders placed within the past day. It provides critical insights into sales trends, customer transactions, and order statuses, allowing you to monitor your store's recent activity and make informed business decisions.

Order vs Return (Monthly)

A report interpreting monthly returns by comparing the total sales value with the sales value of returned orders, including percentage calculations for both return orders and return value.

Sales by Staff

A report designed for quick analysis of sales attributed to each staff member across all POS locations, with details from gross sales to net sales calculations.

Detailed Sales

The full-detail sales export — every line with channel, payment, tax, cost, and margin — built for deep analysis and your data warehouse.

Sales by Customer

The Sales by Customer Report provides Shopify merchants with valuable insights into customer purchasing behavior. This report breaks down sales by individual customers, highlighting the most valuable and active customers.

Weekly Sales Pattern

Your true day-of-week rhythm — which days and hours actually sell — so you staff, schedule ads, and send emails when buyers are buying.

Sales by Variant

Gain detailed insights into each product variant's performance with the Sales by Variant Report. Beyond basic sales data, it shows how each variant impacts your store's success. Use it to fine-tune inventory management and identify popular options, helping you make strategic decisions to boost your bottom line.

Sales by Vendor

The Sales by Vendor report analyzes how each vendor's products contribute to your store's success. By examining sales, purchase costs, and profitability, this report provides insights to make strategic decisions, maximize profits, and optimize inventory management based on vendor performance.

Completed Draft Order

This report provides insights into finalized draft orders, displaying detailed information on converted orders, including product details, pricing, and customer data for analysis.

Last 30 days Sales Summary

A report that provides a comprehensive overview of sales performance over the past 30 days, including total revenue, order count, average order value, and product-specific sales trends for detailed analysis.

Sales by Device ID

The report displays sales data segmented by device type, such as mobile, desktop, or tablet, allowing merchants to analyze performance based on customer device usage.

Sales by Collections

The Sales by Collections report provides a detailed view of your product sales, inventory costs, and profitability by collection, helping you see which collections drive revenue and how they resonate with your audience, allowing you to tailor your product strategies accordingly.

Commission

The Commission Report is the key to rewarding store staff and affiliates for sales they generate. It provides an overview of their sales performance along with calculated commissions share.

Sales by Fulfillment Location

Data reported to analyze sales based on order fulfillment locations for any specified date range, including product quantity sold and corresponding sales value.

Sales by Billing Location

The Sales by Billing Location report in Shopify provides a detailed breakdown of sales based on the billing addresses of your customers. This report categorizes sales data of your customer base by country, region, or city.

Build and automate your Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.