Revenue vs fees - which reports to use?

[rcl2018]

Hello!

for accounting purposes, can any one share which report to download showing actual revenue and also shopify fee for the same month, i.e 1st of Jan. to 31st of Jan.

With eBay and amazon, we are able to download 2 separate reports - one for revenue, and one for fees. Which makes it easy to work out the gross profit. But with Shopify, I can't seems to replicate the same principle so it's causing confusion when it comes to accounting.

many thanks

[100x-elevate · Accepted solution]

@rcl2018 

Reports to Download in Shopify:
Actual Revenue Report: Use the "Sales by Month" report or "Financial Summary" report.
This shows gross sales, refunds, discounts, and net sales.

Steps to Download:

• Go to your Shopify Admin > Analytics > Reports.
• Select Finances Summary or Sales by Month.
• Set the date range to 1st of Jan to 31st of Jan.
• Export the report to a CSV file.
  Shopify Fees Report: Fees are usually broken down in the Payouts Report for payments processed through Shopify Payments.

  Steps to Download:

  • Go to Settings > Payments > View Payouts.
  • Click Transactions for detailed fee breakdown (credit card fees, transaction fees, etc.).
  • Export the Payouts CSV file for the same date range (Jan 1 to Jan 31).

Matching Revenue with Fees:

To calculate gross profit, you’ll need to combine data from the two reports:

• Revenue Report: Use net sales data from the Financial Summary or Sales report.
• Fees Report: Use Shopify's Payouts CSV to track Shopify fees for the same period.

[CloudlabSam]

This is definitely the best way to do it from within Shopify.

@rcl2018 There are also a number of reporting apps you could use to do this with one report. Just search for "reports" in the App Store.

[rcl2018]

Perfect, this is exactly what I was looking for. Thanks very much!