x

Is there a report that breaks out card type of card (debit/credit) used, not how used?

I am being asked to show a report of how many debits vs credit cards were used, as well as the amount charged.  I know debit cards can be used as charge cards....but they want to know specifically the KIND of card, not how they were used.  Thanks in advance!

Tags (1)
Message 1 of 9
1,840 Views
1 Best Answer
Super Seller

Best Answer

All Debit cards run as credit thru square.

 

https://squareup.com/dashboard/sales/transactions  here you can select the time frame you want and the select Export transactions .csv

 

that file will open in excel or numbers and then you can sort the 24th column (column x) to see the card (visa, mastercard, discover, amex)

View Best Answer >

Message 2 of 9
2,418 Views
8 REPLIES 8
Super Seller

Best Answer

All Debit cards run as credit thru square.

 

https://squareup.com/dashboard/sales/transactions  here you can select the time frame you want and the select Export transactions .csv

 

that file will open in excel or numbers and then you can sort the 24th column (column x) to see the card (visa, mastercard, discover, amex)

View Best Answer >

Message 2 of 9
2,419 Views

No, in Canada, debit (interac) aren't run through as credit as the interac network is completely different. They should not show up the same because even Square's fees on interac (C$0.10/transaction) is different. 

Message 3 of 9
136 Views

This reply was created from merging an existing thread: Custom Reports 

 

Hi, is it possible to create a custom report that categorizes specific items via payment type? 

Message 4 of 9
1,266 Views
Admin

@JessicaAnne I'm adding your post to this thread where @VanKalkerFarms answered a similar question. When you export the Transactions CSV you'll see it include the card brand in column Y and name of the item sold in column AE (it's a big file!).

Helen
Seller Community Manager, Square
Find step-by-step help in our Support Center
Message 5 of 9
1,244 Views

Is there a built-in report in Square that allows you to see the breakdown of transactions so that you can see the number of transactions and amount charged by payment type? I don't want a breakdown by card (contactless), card (chip). I want to be able to see breakdown by type of card (e.g. debit vs credit), type of credit card (i.e. Mastercard vs Visa vs Amex). Is that possible?

Message 6 of 9
201 Views

@VanKalkerFarms provided a great response to this question here in this thread!

 

I hope this is helpful, @PlantSellerYEG 

Valentina
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
Message 7 of 9
182 Views

No, that does not help because debit transactions in Canada are not the same as they are in the US. 

Message 8 of 9
136 Views

Ah, got it!

In that case, you can refer to the payment method report, which will show if the card is dipped or tapped, but it will not display the card number. You could also export the transaction CSV to view the fee percentage there, @PlantSellerYEG.

Valentina
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
Message 9 of 9
49 Views