Can I use the square payment Id to determine the credit card number used for past transactions?

[Iron_mike_1406]

I have a member who has stated he has duplicate transactions from my fitness studio. I only have one transaction for each charge. I have the transaction square payment ID numbers. Can the square payment ID be used to search for the credit card number used for past transactions?

Thanks in advance, 

Mike

[Donnie-M]

@Iron_mike_1406 I don't think you can use it the way you are wanting but there are a couple other options.

If you have the customer in your directory, generally his or her profile will have all of the transactions and that is the fastest way to verify.  

Second you can search by the last four of the credit card # in transactions, but I don't always have good luck with that.

The other thing may be the authorization of a charge hasn't fallen off.  Occasionally a customer will run the card and it gets a pending transaction posted and then for whatever reason another one will post.  The duplicate "pending" transaction will fall off usually in a couple days.

[ryanwanner]

Hi @Iron_mike_1406 !

I’ve seen times where credit card processors ping the banks multiple times for verification. This is not specific to Square and is usually a holdover from the way tipped transactions were handled back in the day. It doesn’t need to be a tipped transaction though. If the customer has recently visited, chances are one of those transactions is in a Pending state with the bank and will fall off within 1-3 business days. If you’re only showing one transaction on your side then your customer will ultimately be charged only once. 
Now, if the customers transaction happened quite a few days ago, I’d definitely recommend calling into support so they can track the ghost transaction. 

Hope this helps!

[Candlestore]

@Iron_mike_1406 ;

If you have your Transacation ID's you can look the transactions up in your Transactions CSV.

You search for the Transaction ID, then scroll accross and you can see the PAN Suffex, which I believe is the last 4 of the Credit card used.  The other alternative would be to filter by customer Name in the Transacations List showing only that persons Transactions.

The easiest way to get this is download your Transacations CSV file, click on any cell, then on the top ribbon bar select Insert Pivot Table.  Filter by customer Name and have the Rows by Pan Suffex, and then also put Pan Suffex in the Value box and set this to show as Count not sum(default).  I just did this with Excel and a Transactions CSV file to test, but my Name fields are Blank since we do not required customers names when making in store purchases.

Here is a quick sample which shows 3 different customers and their  Pan Suffix, 2 Customers used their card once and the other used their card 2 times.  I did edit the numbers of the Pan shown in the image below.  You may need to select Multiple Names if the Customer used multiple cards.

[Iron_mike_1406 · Accepted solution]

Hi all,

I figured it out using the transaction page and searching the first four of the square payment ID under the receipt#. It gave me the card# and the name on the card. I have asked the member for proof of these duplicate charges to investigate them. When these duplicate charges were made, I suspect they were like what @Donnie-M  and @ryanwanner  explained and finally dropped off.

Thank you,

Mike