Skip to main content
Academy Community Sign in

Processing Amazon payment reports

  • Updated

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.

Create and maintain your Amazon payment reports business account

App Center > Accounting > Business accounts

To create a new business account for Amazon payment reports:

  1. Click +New and select the Custom tile from the Selection section. The account details form is displayed.

  2. Enter a name for your new business account in the Designation field.

  3. From the Type drop down select the Account: Amazon Payment Reports option.

  4. Select the relevant project in the Project field.

  5. Make sure that the Active check box is selected. If this check box is not selected, you cannot use the account.

  6. Select the Allow changes check box if you want to allow subsequent changes to the postings.

  7. 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.

Maintain your Amazon Payment reports business account

App Center > Accounting > Business accounts > Open the Amazon Payment business account by clicking on PenIcon.png.

To maintain your Amazon payment reports business account:

Note

The section Bank details is not relevant for Amazon payment reports business accounts.

  1. Scroll down to the DATEV section and enter your DATEV account.

  2. 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.

    Examples of possible entries:

    • KONTO_GEBUEHRAUFTRAG => enter your account number here

    • KONTO_VERSANDLABELGEBUEHR => enter your account number here

    • KONTO_WAREHOUSE_LOST_MANUAL => enter your account number here

    • KONTO_ShippingServicesRefund => enter your account number here

    Note

    Amazon currently has around 130 different fee types.

  3. Click Save.

Your Amazon payment reports business account is now ready for use.

Import Amazon payment reports

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.

To import Amazon payment reports automatically:

  1. Go to App Center > Accounting > Business accounts > Open the Amazon payment report business account by clicking on PenIcon.png.

  2. In the Live import section make sure that the Live import active check box is selected.

  3. 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.

  4. Click Save.

To import Amazon payment reports manually:

  1. Go to Accounting > Receipt of payment.

  2. Click PenIcon.png in the Menu column for the bank account, that you have created for the import of Amazon payment reports.

  3. Click Datei auswählen (select file) and select the Amazon payment report CSV file you have downloaded from your Amazon Seller account for import.

  4. 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.

Related articles