How to download payment reports for my accounting software without duplicating between "deferred" and "Released" on different dates?

Countries

Read only
Australia
Belgium
Brazil
Canada
Egypt
France
Germany
India
Italy
Japan
Mexico
Netherlands
Poland
Saudi Arabia
Singapore
Spain
Sweden
Turkey
United Arab Emirates
United Kingdom
United States
United Kingdom
imgSign in
user profile
Seller_64ANFRIFr4ruq

How to download payment reports for my accounting software without duplicating between "deferred" and "Released" on different dates?

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?

70 views
1 reply
Tags:Payments
10
Reply
1 reply
user profile
Seller_ExO2KKCwIDvij

I would say you're overthinking this.

Your business's income is the total disbursement figure for each month; that's it. It's very difficult to correlate this back to individual sales because of non-transactional fees such as storage as well as refunds etc.

The only time you need to analyse actual sales data is for VAT reporting, which has a long enough reporting delay to allow deferred transactions to flow through.

10
Follow this discussion to be notified of new activity

Similar Discussions

user profile
Seller_bIVNWAWuPbk3l
user profile
News_Amazon
user profile
Seller_Huz6FT08OxHAR