Report on payment method used during a month

Report on payment method used during a month

Agolab
Explorer
54 0 17

So, on our store we have 4 different payment methods: Shopify Payments, Paypal, Klarna and Cash on Delivery.

I would like shopify to tell me how many times each payment methos has been used in a single months. 

For example, if in december we got 100 orders, where I can find something like this: 
Paypal: 20 orders
Klarna: 20 orders

Shopify Payments: 30 orders
Cash on delivery: 50 orders

I'm getting crazy about it as we need to check how many cash on delivery we get each month for tax purposes, but it looks like I cannot find this anywhere. Is not even in report - payment per type as that only tells you each order one by one what was the payment system, it doesn't sum it up. 

Thanks

Replies 3 (3)

CloudlabSam
Shopify Partner
599 49 105

Unfortunately, the Payment by Type report in Shopify is pretty limited. It doesn't allow you to customize to what you are trying to do.

 

Our Report Toaster app can help. We have a Transactions by Gateway report that can get you started and then be customized as needed. If you need some help, just reach out to us and we can assist.

Report-Pundit
Shopify Partner
357 12 26

Hi @Agolab,
 

Shopify doesn’t let you customize reports directly, but you can use third-party apps to do it. With Report Pundit, we offer a report called "Total Transaction Value by Gateway." This report gives you a clear summary of transactions for each payment gateway and allows you to calculate the totals.

Some of the key details you’ll find in this report include:
  • Gateway Name
  • Order Amount
  • Total Discount
  • Net Order Amount
  • Transaction Amount
  • Payment Gateway Fee
  • Total Tax
Our team can help you to customize this report for you in just a few minutes. Plus, you can try it out with our 14-day free trial.
On top of that, we also support 30+ integrations to make your reporting even more powerful!

Thanks,
Report Pundit
Report Pundit - Instant reports and custom dashboards

BetterReports-C
Shopify Partner
97 0 7

Hi @Agolab 

Claudia here from Better Reports.

Have you been able to find a solution for this with Shopify? If not, I would recommend our app Better Reports.

We have a built-in Transactions report Volume per payment gateway which shows the all time transaction volume by gateways. The report can be filtered for different date ranges.

Beyond this, Better Reports includes 60+ built-in reports that address common use cases for merchants. You can schedule reports to run at set intervals and deliver them directly to your email or Google Drive. Reports can also be exported in CSV, Excel, or PDF formats.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to customize this report for you.

What do you think?