Eshopbox helps you reconcile fees charged and payments received from Amazon against your Amazon orders. Eshopbox helps you in payment reconciliation of multiple business models in Amazon:
In this article, you will learn:
How to configure Amazon fees and payment terms in Eshopbox
How to upload Amazon payment report in Eshopbox
How Eshopbox reconciles Amazon fees
How Eshopbox reconciles Amazon payments
Follow the below steps to start reconciling Amazon fees and payments in Eshopbox:
1. Configure fees
The first step is to configure your Amazon fee in the Eshopbox workspace. Learn how to configure fees in Eshopbox.
2. Configure Amazon payment cycle
You need to configure Amazon’s payment (remittance) cycle in Eshopbox. The frequency at which Amazon makes payments to you would be based on your agreement with Amazon and your seller tier. Learn how to configure payment terms.
3. Book payments
You need to upload Amazon payment reports in Eshopbox to initiate the reconciliation by following the below instructions:
Download Amazon payment report
Follow the below steps to download the Amazon payment report:
Log in to the Amazon seller account.
Navigate to Reports > Payments.
Click on 'All Statements'
Select either ‘Electronics transaction’ or ‘COD transaction and non-transaction fees’.
Click on download flat-file v2 corresponding to the payment that you want to download.
Now, navigate back to the Eshopbox workspace > Payments.
Click on ‘Add payment’ on the top right corner of your screen and upload the payment report.
Amazon has two payment categories based on the customer's mode of payment. You have to download reports for both these categories:
Electronic transactions: These are prepaid orders for which the customer has made an electronic transaction using a credit card, debit card, UPI, and more.
COD Transaction and Non-Transactional Fees: These are postpaid orders for which the customer has paid using cash on delivery or digital wallets while receiving the product.
Eshopbox can only read Amazon payment reports in the flat-file V2 format. Make sure you choose this format while downloading the report. In case Amazon payment reports are unavailable in flat-file V2 format, you need to contact Amazon seller support.
Reading Amazon’s payment report
If you wish to read the Amazon payment report in flat-file v2 format, you need to use Microsoft excel. Each row in the report represents the amount settled corresponding to a particular order. The record will either corresponds to payment against an order ID or expense incurred against an order ID.
In the first line of the report, you can find ‘settlement ID', ‘deposit date’, and ‘total amount’. The corresponding values are required while uploading the payment report in your workspace. These values correspond to ‘bank reference ID’, ‘fund transfer date’, and 'fund transfer amount’. The amount you receive in your bank account is the fund transfer amount. The bank reference ID is the unique identifier and the date of the fund transferred to the seller's bank account is the fund transfer amount.
For Amazon payment reconciliation, Eshopbox considers a combination of customer order ID & ESIN as unique reference ID. All transactions are recorded against this unique reference ID. Eshopbox will create a ‘suspense’ record if there is a difference between the settlement amount and the sum of payment and expenses calculated by Eshopbox from the payment report.
4. Reconcile expenses
Eshopbox will match the provisional fee with the actual fee deducted by Amazon, and assign it one of the following fee statuses:
If the fee deducted by Amazon is the same as the provisional fee. The fee status will be ‘Reconciled’.
If the fee deducted by Amazon is more than the provisional fee, the fee status changes to ‘Disputed’.
If for any reason Eshopbox is not able to calculate the provisional fee and Amazon has deducted this fee, the fee status changes to ‘Failed'.
5. Reconcile payments
Eshopbox will match the expected payment (invoiced amount) with the actual payment received from Amazon, and assign it one of the following payment statuses:
If the payment received is equal to the provisional amount, the payment status will be ‘Paid’.
If payment received is less than the provisional amount, the payment status will be ‘Awaiting payment'. When no payment is received against an order, the payment status will be ‘Awaiting payment’ with a partial tag.
If you receive payment and then the same amount is refunded, the payment status will be ‘Refunded’.