In less than 5 mins we can login to Stripe and output a report that includes the pi_ reference that you see held against your EvoX orders. Then we can export the "Credit card payment reconciliation" report from EvoX to match it up.
Get the pi_ report form Stripe
Step 1:
Step 2:
Step 3:
Step 4
Now you have the pi_ reference and all the payment details.
Now let's get the Order Export from EvoX
Now all we have to do is a simple vlookup formula to match the details between the two reports.
Nice job! Now go get a well deserved coffee ☕️