Shopify E Commerce - Bookkeeping

I am currently working for a client who use Shopify to sell goods. The sales are all made through the internet and paid via stripe or paypal.

The problems are the payments received into the bank, never reconcile with sales report in Shopify ?

Has anyone had similar issues / experiences or used this software ?

I am using Xero cloud accounting which is great and we did set up automation of the 2 systems, but this didnt work , as there are too may sales per day on Shopify that were sending every invoice into Xero automatically.

Any tips or advice on the best way to reconcile bank payments with Shopify sales, would be greatly appreciated ?

If you have access to their Shopify Account, then when you login on the bottom right there should be "View All Payouts", if you click this, it will take you to the list of payouts, you can extract this as a Excel/CSV file.

So now each line in this file will show you, sales, returns, sales fees, returns fees and the amount paid into the bank.

That should give you enough info to reconcile the incoming receipt from Shopify.