Amazon fees

Fees related to sales orders are automatically accounted for when payments are downloaded into Brightpearl. The fees nominal code is selected within the Amazon marketplace set up in Brightpearl. You will see the fees created in a separate accounting journal of type BP.

Set the default account code for order-related fees under Channels > Amazon > Settings in the "Fees, charges and reimbursements" section. All fees within the <Order><Fee> and <Order><ShipmentFee> containers on the settlement report will be accounted for automatically. 

Any fees not related to an individual order can be entered manually as bank payments, or you can use the Amazon settlement report mapping functionality.

Note: Where different types of fee have been charged against a single order, you will see a single fee amount posted in Brightpearl for the total fee amount applicable to the order.

Capturing other Amazon fees

To capture other Amazon fees, go to Channels > Amazon > Settings and check the "Capture Amazon other fees" box in the "Sync orders" section:

Screen_Shot_2020-02-04_at_7.23.32_AM.png

To configure the fees, scroll down to the "Fees, charges and reimbursements" section:

Screen_Shot_2019-09-23_at_2.41.21_PM.png

Here you can set a default account code for other fees found outside of the <Order> container (<OtherTransaction> and <AdvertisingTransactionDetails>) on the settlement report. 

If you want to account for any fees separately, use the transaction type mapping section to map individual fee types to account codes in Brightpearl.

Simply enter the Amazon transaction type name (as shown in the XML report - note that this field is case sensitive), check the "Create accounting" checkbox if you want to create accounting entries for the transaction type, and select an account code. This mapping will override the default fee account codes set above. 

If you do not want the accounting to be created for any particular transaction, you can enter the transaction name, set a default account code against it, and leave the "Create Accounting" checkbox unchecked. Brightpearl will not capture that fee/transaction.

Brightpearl will only look at the following container names:

  • <Order><Fulfillment><ItemFees><Fee><Type>
  • <Order><ShipmentFees><Fee><Type>
  • <OtherTransaction><TransactionType>
  • <AdvertisingTransactionDetail><TransactionType>

Brightpearl will create a BP or a BR journal depending on whether the money is going in or out of the bank account. A Bank Receipt (BR) is for money received into the bank account and a Bank Payment (BP) is for money paid out of the bank account.

Example:

-2.00 represents money paid to Amazon by the merchant (i.e. money coming out of the bank account). It is therefore a BP type journal, where the fee is recorded as a debit and the money leaving the bank as a credit.

Details: DisposalComplete channel xxx, settlement report ID: xxxx, Report ID: xxx

Account code

Debit

Credit

Amazon bank

 

2.00

Default/mapped fee code

2.00

 

Note: You will not be able to re-run the settlement report to create accounting entries after the configuration had been saved or corrected. 

Have more questions? Submit a request