Reconciling shopify sales to shopify advances
Hi Everybody
My client has received an advance on sales from Shopify. Theres a funding cost attributable to this advance. I can set up the liability when the advance hits the bank. I can also a...
Forum Discussion
I am the accountant or bookkeeper
Specifically I have a capital advance I am paying back
It's an advance on sales
Ive recorded the advance as
Dr Bank
Cr Advance liability
When I pay the advance back from the bank account it's
Dr Advance liability
Cr Bank
I know how much Ive paid back because it has come off the gross sales
I only want to record the sales but I can't see the gross sales in Shopify
The capital account and the gross sales reports do not align
Ive reached out the busienss owner and he cant shed any light either.
Ive also asked AI in Shopify
Not helpful
Kevin V Russell
Zappy Business Services
Hi Zappy,
Thanks for laying that all out so clearly. I can see why that's doing your head in a bit. From what you've described, it sounds like the mismatch is coming from the way the gross sales are being reported on the Shopify side rather than anything going wrong with your entries in MYOB. Your journals for the advance and repayments actually look spot on. Since the gross sales figure you need isn't lining up and isn't visible in Shopify, the best next step would be to reach out to Shopify support directly. They'll be able to dig into how the sales are being processed and reported in their system, and why it's not matching.
Regards,
Sai
