When you sell via Amazon, Amazon will charge you for using its services including service fees, storage fees (for FBA), etc.
With the Amazon payment reports business account you can import Amazon transactions as well as associated charges and post them to the relevant accounts.
Settings > Accounting > Payments & Business accounts > Bank & payment accounts
To create a new business account for Amazon payment reports:
-
Click Add payment account and select the Custom tile from the Selection section. The account details form is displayed.
-
Enter a name for your new business account in the Designation field.
-
From the Type drop-down menu, select the option Amazon Payment Reports.
Note
In the overview table of business accounts, this type is listed as amazonkonto.
-
Optional: Restrict the account to a single relevant project in the Project field, e.g., your project for Amazon FBA.
-
Make sure that the Active check box is selected. If this check box is not selected, you cannot use the account.
Note
You can ignore the No email checkbox when using Amazon payment reports.
-
Optional: Select the Allow changes check box if you want to allow subsequent changes to the postings. This is only possible if you enter your bank statements by hand and is not recommended.
-
Scroll down to the bottom of the form and click Save.
You have now defined the basic settings for your new Amazon payment reports business account.
Settings > Accounting > Payments & Business accounts > Bank & payment accounts > Open the Amazon Payment reports business account by clicking on the pen icon
To configure your Amazon payment reports business account:
Note
The section Bank details is not relevant for Amazon payment reports business accounts.
-
Scroll down to the DATEV section and enter your DATEV chart of accounts.
-
Scroll down to the Live import section. You do not need to enter any credentials here. You can however enter accounts for posting the various Amazon fees in the Access data field.
The entries need to be entered in the following format:
Format: {Type of fee}=>{Number of your account};
Example: KONTO_GEBUEHRAUFTRAG=>3123;
The arrow consists of an equal sign (=) and a greater than sign (>). You can post multiple fees to the same account.
After entering your entries under Access data, they will also be displayed in the Account specific settings section and can be edited there as well. Any changes will immediately be applied to the respective fields.
Examples of important fees
-
KONTO_GEBUEHRAUFTRAG
-
KONTO_SERVICEGEBUEHR
-
KONTO_VERSANDLABELGEBUEHR
-
KONTO_VERSANDGEBUEHR
-
KONTO_SHIPPINGHB
-
KONTO_REFUNDCOMMISSION
More possible entries are listed at the end of this article: List of fee accounts.
Important
The types of fees can vary depending on your business, e.g., whether you use Fulfillment by Amazon (FBA) or Fulfillment by Merchant (FBM), if you ship only domestically or also internationally, and so on. You can find the types of fees Amazon is charging to your account in your Amazon V2 reports. If you find a type of fee that is not listed here, you can enter it by typing KONTO_{Copy the type of fee from the V2 report here}.
-
-
Click Save.
Your Amazon payment reports business account is now ready for use.
Note
In order to be able to import and process Amazon payment reports, you need the V2 report, which you can download from Amazon.
You can either import the Amazon payment report automatically using the live importer or manually.
Important
Once an entry has been imported, it can't be changed retroactively!
To import Amazon payment reports automatically:
-
Go to Settings > Accounting > Payments & Business accounts > Bank & payment accounts > Open the Amazon payment report business account by clicking on the pen icon .
-
In the Live import section make sure that the Live import active check box is selected.
-
In the Process starter section select the Automatically collect incoming payments check box to retrieve and import the Amazon payment reports and the Book incoming payments automatically check box, to post them automatically.
Note
In order to post the transactions automatically, you have to define the relevant accounts in the Access data field.
-
Click Save.
To import Amazon payment reports manually:
-
Go to Accounting > Receipt of payment.
-
Click the pen icon in the Menu column for the bank account, that you have created for the import of Amazon payment reports.
-
Click Datei auswählen (select file) and select the Amazon payment report CSV file you have downloaded from your Amazon Seller account for import.
-
Click Import.
Your Amazon payment report is imported and the transactions are displayed in the Kontoauszüge (bank statements) tab. You can now process your statements further as required.
Amazon currently has around 130 different fee types that you can post to different business accounts in Xentral by replacing XXXX with your account number. In the following list you can find many useful fee accounts. Please be aware that this list is not complete!
-
KONTO_GEBUEHRAUFTRAG=>XXXX
-
KONTO_SERVICEGEBUEHR=>XXXX
-
KONTO_VERSANDLABELGEBUEHR=>XXXX
-
KONTO_VERSANDGEBUEHR=>XXXX
-
KONTO_SHIPPINGHB=>XXXX
-
KONTO_REFUNDCOMMISSION=>XXXX
-
KONTO_VERSAND=>XXXX
-
KONTO_Shippinglabelpurchaseforreturn=>XXXX
-
KONTO_ShippingLabelpurchase=>XXXX
-
KONTO_ErstattungShippingTax=>XXXX
-
KONTO_WAREHOUSE_LOST_MANUAL=>XXXX
-
KONTO_WAREHOUSE_DAMAGE=>XXXX
-
KONTO_ShippingServicesRefund=>XXXX
-
KONTO_UEBERTRAG=>XXXX
-
KONTO_WERBEKOSTEN=>XXXX
-
KONTO_REVERSAL_REIMBURSEMENT=>XXXX
-
KONTO_TransactionTotalAmount=>XXXX
-
KONTO_RE_EVALUATION=>XXXX
-
KONTO_total-amount=>XXXX
-
KONTO_CurrentReserveAmount=>XXXX
-
KONTO_COMMISSION=>XXXX