First Previous - Page 1 of 1 - Next Last

Shopify E Commerce - Bookkeeping

  • Affiliate
  • 2 posts
  • # 116355

Hi

 

Just wondered if anyone can offer any advice ?

 

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 ?

Thanks

Tracey 

 

  • Fellow PM.Dip
  • Practice Licence
  • 181 posts
  • # 116356

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.

  • Affiliate
  • 2 posts
  • # 116364

Hi Vip

 

Thanks for the information, and yes I have accessed this information.

 

However  I have discovered , included in the gross charges  figure , which I had assumed was the gross sales, is also postage charges ( no vat )

 

There isnt a breakdown on this payout summary for postage, have you come across this isssue  ?

 

also, the client is selling to the EU and there isnt a breakdown of sales to EU in the payout report ?

 

Thanks for the advice , much appreciated.

Tracey

  • Fellow PM.Dip
  • Practice Licence
  • 181 posts
  • # 116524

tdcurtis@hotmail.co.uk said:

Hi Vip

 

Thanks for the information, and yes I have accessed this information.

 

However  I have discovered , included in the gross charges  figure , which I had assumed was the gross sales, is also postage charges ( no vat )

 

There isnt a breakdown on this payout summary for postage, have you come across this isssue  ?

 

also, the client is selling to the EU and there isnt a breakdown of sales to EU in the payout report ?

 

Thanks for the advice , much appreciated.

Tracey


 Hi Tracey

 

Sorry for the delay in getting back to you. Couple of things,  under "Analytics" then click "Report" on the left hand side of Shopify Main login page there are more detailed reports (for the postage bit) check there and download some of these reports you should get more detail, including customer delivery addresses which should give you EU info.



Edited at 27 Mar 2018 05:34 PM GMT

First Previous - Page 1 of 1 - Next Last
loading