An explanation of the Excel Payment file
In the worksheet called Rows you will find all the information you need for your bookkeeping.
Column J – Invoiced amount is the amount the customer will have to pay for the order. Invoiced amount could be different from the sales amount if the customer used a voucher code in their order.
CDON will take this cost, and how much the invoiced amount differs compared to the sales amount is specified in Column K, Marketplace discount.
If you have a campaign offer set up with CDON Marketplace this will instead be specified in Column Q, Campaign discount.
Column L – Sales amount is the price for the item without any deductions. This is the amount CDON will pay to the merchant, and if you sum the column this will be the proceeds CDON will pay to the merchant for this period. Note that some rows might be negative because of returns the customers have made. This amount includes VAT and the VAT percentage is stated in column N.
Column M – Commission is the fee CDON charge for your transactions.
Column N – The VAT percentage for the transaction is specified in this column.
Column P – If you sell in more than one currency you can filter column P in the currency you would like to look closer at.
In the third sheet you can see a specification the service fees that CDON charge you and for which order the fee is attached to.