Wow - this platform is a total nightmare. Started selling a few items and we got single payments a week or so later appearing into our bank account but no references to what orders. Now we are getting regular payments for multiple orders but the issue is there seems to be amounts held in unavailable balance. To complicate this our receipts are in $AUD but sales in $US so there is always an exchange rate variation.
How the hell does a business ever hope to reconcile these receipts when the volume increases?
We have to raise an invoice in our accounting system to reflect the sale. When money comes in we have to receipt the payment against the sale. It looks like there will be multiple ‘part’ payments against open invoices but I can’t find a report in Amazon seller central that summarises these.
With Paypal payments we can choose when to initiate a transfer to our account - so we leave until month end then sweep the account back to our $AUD account - easy. We’d be happy to leave an amount in escrow to satisfy the unavailable balance but this doesn’t seem to be an option.
Has anyone got a simple way to account for Amazon receipts so they can reconcile against open invoices?
Any help would be appreciated