Why don't the totals in Stripe reports match Metorik reports?
Store admin? Check out the report settings here and the date settings here. As you change them, Metorik will show you what last month's sales would be so you can compare that to Stripe.
If you're a WooCommerce store, you may find that the totals in Stripe reports don't match the totals in Metorik reports. This can be due to a few reasons.
Primarily, it's because Stripe's reports would be based on when the payment/transaction was made, while by default Metorik's reports use the order created date. While we recommend using the order created date so you can get a holistic view, you may want to align Metorik with Stripe and report based on the order paid date.
To change it, visit the date settings here and change the setting to paid date to use that instead:
Learn more about the various date types here.
There can be other reasons for the difference, including:
- Multiple currencies - the rates we're using may not match the rates your store is using. Both amounts will be inaccurate, so it's recommended you filter your data by currency to get the raw, more accurate amounts.
- Timezones.
- Excluded order statuses - Metorik allows you to customise the order statuses excluded from reports, so if you're excluding statuses besides failed, cancelled and pending, it's likely that the report totals won't match up as Stripe is including statuses that you've excluded.
- Net sales - Metorik allows you to customise what should be deducted from gross sales to determine net sales, unlike Stripe. Additionally, Metorik offers 2 reports related to net sales - the revenue report and the orders report. Both have differences so it's worth reading this help doc to understand them.
Narrow down the discrepancy
It's always best to break it down into as smaller time frame as possible (i.e 1 or 2 days) so that we can look at the exact orders that make up a total and explain any discrepancies.
The first thing to do would be to find a particular day within a period that you can see a difference, we can then look at each order that makes up the number from the Revenue report page and see why there is a difference
You can click through to see all the Orders that are used to make up the numbers, and you can also Export these Orders.
It's also worth noting here how Metorik handles refunds.... we do it in two ways which you can read about here Revenue and Order reports and there is full explanation of the Refunds and the Refunds report here.