I joined Amazon in July, and have been manually accounting for my sales through my accounting software with no issues.

Towards the back end of September, I was introduced to the new DD+7 system and deferred payments, and since then I've found it near impossible to keep my accounting software in sync with my Amazon account.

Problem I have is lets say I downloaded the CSV from October 1st to October 27th. I make a sale on October 20th. This sale counts towards my balance on my transactions list as "Deferred" on October 20th. Payment is then released on October 27th, and therefore shows on my transaction list as being "released" on the 27th.

If I was to upload the CSV for October 27th to my accounting software, that payment has now duplicated. It's counted it as a transaction on the 20th, and now the 27th.

The issue I have with that is it's difficult to then manually go back and remove transactions and figure out where discrepancies lie. In theory this wouldn't be an issue for the one transaction, but I'm making between 10-20 sales a day at the minute, and wouldn't be able to keep up to it on a daily basis. My overall method would be to upload the CSV, manually go into each transaction, my product price being my earnings and underneath a deduction of Amazon fees.

It's becoming incredibly frustrating as I simply can't keep the balances synced like this. I've tried third-party software to try and sync data but I haven't got on with any of them, nor can I justify their prices.

The only way I can think to do this would be to upload a monthly CSV for October for example, on November 8th when all payments are released. But another problem my business has to report monthly earnings on the 29th of every month to a financial institution without delay. So realistically I can only report until about the 21st and even then it's not accurate.

Any help/advice on this one?