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.