Has anyone come up with a report or alternative way to reconcile the daily sales to the amount ultimately received from Shopify? Our auditor is concerned that the two numbers never match and there is no way to get from one to the other. We have no idea whether we are collecting all of the funds or if we may be shipping orders to someone who never actually paid us.
How do you calculate your sales tax? Do you back into your gross sales based on the tax collected? There is no report that our state sales tax agency would accept to show the amount of sales in our state vs. out of state.
She has spent a good amount of time with Cust Service but hasn't really received a satisfactory answer.
Steve, What accounting software are you using? You should be able to split and match received payments to specific transactions. I would recommend doing this at a transaction level rather than total daily sales.
As for sales tax, simply export your sales to excel. You can sum total sales tax collected, and it will also show the state where the customer is located. This should match your sales tax liability account in your accounting software.