Reconciling PayPal transactions from two Shopify stores - help!

3 0 0

Hi there,

We have 2 Shopify stores running at the moment - one for our retail customers and the other for our wholesale customers. The stores sell the same products at different prices, and both have PayPal Express activated and are linked to one PayPal business account. 

We are struggling when reconciling as there is no easy way of telling the transactions (b2c vs b2b) apart. We cannot set a prefix as Shopify order numbers sadly do not appear in PayPal's reporting - only a Transaction ID and invoice number. 

Any help is much appreciated!

Reply 1 (1)

317 11 21

Hello @pompommag ,

I am John from Report Pundit, a reporting and analytics app with more than 500 five-star reviews.

Report Pundit has a multi-shop integration feature with which you can integrate multiple shops and generate consolidated PayPal and other reports.

Report Pundit can fetch the data from Paypal API for the Shopify orders payout. We have the option to show transaction ID, the transaction fee for each order, Net amount, Invoice number, Shopify order numbers, etc for both the Shopify stores.

Our team can create custom reports unique to your business.

Contact us at or our live chat support team for help.


Report Pundit - Instant reports and custom dashboards