Marketplaces pay out collective amounts that include fees, commissions, shipping labels and, if applicable, sales tax. For accounting purposes, these components must be available separately. How to export Amazon Seller and Etsy Payouts cleanly.
- Commissions reduce revenue, but are not sales
- Shipping labels are continuous items
- Net payout ≠ taxable sales
Amazon Seller Central Export
- Seller Central → Reports → Payouts.
- select billing period, Generate report.
- CSV Download or save PDF statement.
- Check columns: Sales, Fees, Shipping, Returns, Tax.
Etsy Payout Export
- Shop Manager → Finance → Payouts.
- set a period, Export click.
- Download CSV; alternatively save monthly PDF.
- Check columns: Sales, Fees, Advertising, Shipping Labels, Taxes.
PDF statements with KontoCSV
Do you only have PDF statements? With KontoCSV you convert this into a structured CSV/DATEV file.
1. Upload PDF
Select Amazon or Etsy PDF billing.
2. Select profile
Use DATEV, Lexware or Excel profile.
3. Check fees
Fees, shipping and advertising shown separately.
Fees, taxes & shipping folders
SKR03: 4400/8336 revenues, 4970 commissions, 3400 cost of goods sold, 3125 shipping
SKR04: 8400/8336 revenues, 6825 commissions, 5400 cost of goods sold, 6025 shipping
Sales, tax, commission, shipping, advertising, net payout
Returns as a negative item
Maintain EU country & currency
Import into DATEV/LEXWARE/Excel
- Select semicolon as separator, UTF-8 as encoding.
- Set date format DD.MM.YYYY.
- Maintain currency column if foreign currency is used.
- Keep the receipt link/order ID as a reference column for queries.
Common problems
FAQ
Conclusion
Export Amazon/Etsy Payouts as CSV or convert PDF payouts with KontoCSV. What is crucial is the clear separation of sales, commission, shipping, advertising and taxes so that EÜR, DATEV import and OSS/Intrastat function without rework.