Is anyone else experiencing accounting difficulties based on the fact that Shopify reports show sales based on the date according to your time zone, but Shopify Pay determines payouts based on UTC time zone? I'm not talking about the days in between sales and deposit. I'm talking about the actual cutoff times.
For example, let's say that Shopify sales for a business day shows that $2000 total was sold on Day X.
Let's say $1500 was sold through Shopify Pay, and $500 was sold through Paypal.
My client's accountant wants to use the sales report to reconcile and match with actual deposits. However, Shopify Pay payouts are calculated based on UTC time and will not match the $1500 since that was based on EST time. The Shopify Pay deposit will capture orders from 7pm EST on Day X - 6:50pm EST on Day Y. Paypal on the other hand, allows you to set the payout times so they do match the sales report.
I've called Shopify and they say that the Shopify Pay times can not be changed from midnight to midnight UTC time.
How are others handling the accounting piece of this??
Thanks in advance.
I see how this would be a big problem.
Our app Better Reports may be able to help.
The payout data is not exposed to apps (there is no API), but we could generate a report that shows your sales based on UTC time so that it matches your payouts.
Feel free to reach out to me directly at firstname.lastname@example.org to discuss further.
Shopify does not provide payout details because it involves sensitive information. You have couple of options:
1) Have you tried this option to download transaction detail behind each deposit - https://help.shopify.com/manual/payments/shopify-payments/getting-paid-with-shopify-payments#view-yo...
2) At Data Export, we try to reconcile the deposits to sales but it still a workaround. There are a couple of reasons why we are not able to reconcile to the Bank deposits:
a) The timing of the orders that make up the daily deposit is determined by Shopify.
b) There are also adjustments. For example, any refund claim reversal, refund adjustment will be considered as adjustments. Shopify deposits are net of these adjustments.
Let me know if you have any quetions.
I'm also struggling with this problem as relates to keeping my sales tax accounts payable updated. The sales tax report in Shopify is based on the local date (California, for me) while Shopify payments is based on what looks like UTC, so there's no way to see what amount of the payout should actually go to accounts payable for sales tax.
While normalizing all time zone usage to local time would be ideal, I think an easier solution would be for Shopify payments to provide more detail than it currently does. If it could separate between sales / shipping paid / tax paid per tax authority — I'd be set.
Data Export can provide the report that shows the tax collected for each Shopify Payout deposit. You can see the taxes by state, county and also product or shipping related taxes.
If you have any questions, you can contact me at email@example.com
I have also been frustrated with the UTC payout time. I'm also in California, so it cuts off our credit card payments at 4pm, while our business is open until 6pm most days. Our daily sales reports don't match up with the daily deposits. We've been seriously considering moving to a different merchant payment processor, despite the higher cost. Has anyone been able to get Shopify to process your merchant account settlements at something other than midnight UTC?
Many of Data Export users and their accountants are using our "Payout Bank reconciliation" report to match each Bank deposit to the order, transaction, products and fees. You can get any detail behind each Bank deposit.
Also, the Payout detail will capture all the orders in that deposit. You do not have to manually match the daily sales report with the time zones.
There is no need for manual reconciliation. We have worked hard to automate the Bank deposit reconciliation because this can be a nightmare, especially for larger stores or Shopify Plus stores.
We have a 15-day trial to test the reports. Our prices are merchant friendly and lowest among all reporting apps. Our support team can setup any type of custom reconciliation report unique to your store. Report setup is always free. You can reach me at firstname.lastname@example.org
The problem I am having is that Shopify cuts off the sales on a given day according to UTC time zone rather than letting us customize it according to the time zone where we are selling, THEN, the financial report shows the actual sales for our day according to our time zone rather than with the cut off UTC time - this makes a hairy discrepancy in numbers and takes hours to figure out.
It would be helpful if Shopify would either let us choose the time zone according to store location OR make it so we can see both financials, the actual one for our time zone with all of the sales for the day (as is currently showing) AND the one for the cut off time that shows up in our bank accounts so we can actually reconcile. It makes absolutely no sense the way that it is now and is useless for the shop owners. PLEASE, Shopify, align this one way or the other so we can get our information.