Amazon only shares AWD fees as a lump sum through its API, so they appear unitemized in our reports. That makes it hard to see your true profit per item. Seller Central does offer a detailed breakdown of these fees.
ConnectBooks lets you upload and itemize AWD fees. Here's how.
Download the report from Amazon
Go to the AWD Reports page.
Select the fee type you want to upload. ConnectBooks supports 3 AWD fee types: AWD Transportation, AWD Processing and AWD Storage.
Select the date range you want to itemize and download the Excel file (.xlsx).
Upload to ConnectBooks
Log in to ConnectBooks.
Go to Accounting Export, then select the Amazon store.
In the top right, click Itemize Fees.
In Select Fee Type, choose the AWD fee type.
Upload your downloaded Excel file (.xlsx).
Click Import.
ConnectBooks will process your file. Once it's done, the AWD fees appear itemized per product.
Note: AWD storage fees are charged the following month. So if you upload the July charge (which covers June's storage), the fees are itemized in July, not June, because that's when the charge happened. June stays unitemized, since the charge during June was for May.
If some fees still appear under "unitemized," some settlements in that date range may still be open. Once those settlements close, upload the same report again.
Frequently asked questions
Which AWD fees can I itemize?
AWD Transportation, AWD Processing and AWD Storage.
Which file type do I upload?
An Excel file (.xlsx). CSV files don't work for AWD fees.
Why are my June storage fees itemized in July?
AWD storage fees are charged the following month, so they're itemized in the month Amazon charged them.
Some fees are still unitemized after I uploaded. What now?
Some settlements in that date range may still be open. Once they close, upload the same report again.