Skip to content
  • There are no suggestions because the search field is empty.

Amazon Setup - Financial Management

Retrieve Amazon settlement reports, map financial events to your chart of accounts, and post Amazon fees to the general ledger through the Fee Posting Worksheet.

 

Overview

CSM's Financial Management module retrieves Amazon settlement reports, processes them into financial event group records in Business Central, and posts Amazon fees to the general ledger through the Fee Posting Worksheet.

 

CSM Amazon Reports

Amazon generates settlement reports at the end of each period containing account activity and fund dispersal details. CSM retrieves these reports and processes them into financial event group records.

  • Search for CSM Amazon Reports and select the related link
    • Select Get Available Reports from the Report Processing ribbon.
    • Choose your desired report and select Process Settlement Report.
    • CSM updates the report status to Processed and creates a new financial event group record with Settlement Complete status.

 

CSM Automation List

Three automation entries manage Amazon financial data:

  • MWSFINEVENTGROUP
  • MWSFINEVENTGROUPTRAN — FBA
  • MWSFINEVENTGROUPTRAN — FBM. Scheduled by default; unmark the Schedule column if you do not want it to run automatically.

 

CSM Amazon Financial Event Types

This setup table maps Amazon financial event codes to the accounts CSM posts them to. Each row is identified by Financial Event Code, Sub Financial Event, and Financial Event Type.

Field Purpose
Post to GL If unmarked, transactions of this type never generate worksheet lines.
Debit Account Type Account type for the debit side. Defaults to G/L Account.
GL Debit Account The debit account number.
Credit Account Type Account type for the credit side. Defaults to G/L Account.
GL Credit Account The credit account number.
Use For Unknown Type Marks the fallback row used when an event type from Amazon is not found.
Has Marketplace Overrides Indicates that one or more marketplaces post this type to different accounts.

Warning: Fee posting is a G/L-to-G/L (or G/L-to-Bank) transaction. Leave Debit Account Type and Credit Account Type set to G/L Account or Bank Account.

Setting either to Customer, Vendor, or Employee creates journal lines that Business Central will reject at posting, because posting groups are copied from the master record and base BC requires them to be blank for those account types. Fee posting never posts to a customer account — customer activity is recorded through sales invoice posting.

Changing an Account Type clears the corresponding account number. Re-enter it.

Charges are recorded through sales invoice posting. Amazon fees appear separately and typically use your Due to Amazon account for tracking.

Financial event groups gather transactions over a settlement period. Depending on the balance, Amazon either disperses funds to your bank account or charges outstanding amounts.

 

Marketplace Overrides

If the same event type should post to different accounts depending on the Amazon marketplace, use Marketplace Overrides, an action on the CSM Amazon Fin Event Types page.

An override is keyed to Marketplace ID plus the parent row's Financial Event Code, Sub Financial Event, and Financial Event Type. When a settlement's marketplace matches, the override replaces both the account types and the account numbers from the parent row.

  • New override rows prefill from the parent event type. Edit before saving.
  • The Has Marketplace Overrides column on the Fin Event Types page shows which rows are overridden.
  • If CSM cannot identify a settlement's marketplace, no override is applied and the worksheet displays a warning when it opens. Correct the marketplace, then close and rebuild the worksheet before posting.

 

Creating GL Journal Entries for Amazon Fees

  • Search CSM Amazon Financial Management Setup.
  • Configure the Fee Transactions Journal Template and Fee Transactions Journal Batch Name.
  • Open the desired Fin. Event Group card and select Fee Posting Worksheet.
  • Review and edit the suggested entries. Use Edit in Excel for bulk review or editing.
  • Select Post Worksheet (F9) to transfer the lines to the general journal and post them. Clear Worksheet discards the lines without posting.
  • Verify the results in General Ledger Entries.

After a successful post, the Fin. Event Group's GL Posting Status is set to Final and its Status to Closed.

 

If Posting Fails

Worksheet lines are removed as they transfer to the general journal. If the post fails, the whole transaction rolls back and the worksheet is left empty. A retry from the empty worksheet produces a secondary error such as The Gen. Journal Template does not exist. Name=''.

Return to the Fin. Event Group card and select Fee Posting Worksheet again to rebuild the lines. Do not retry from the empty worksheet.

Transactions That Do Not Appear on the Worksheet

A settlement transaction is skipped — no worksheet line, no error — when:

  • It does not match any CSM Amazon Fin Event Type row.
  • Its matched row has Post to GL unmarked.
  • Its matched row, or the applicable marketplace override, has a blank debit or credit account.
  • Its amount is zero.

 

Best Practices

Each skip writes a Warning to the CSM Processing Log. Review the log after every worksheet build to confirm nothing was dropped unintentionally.

  • Currency Handling

    • Worksheet lines resolve currency from the transaction, falling back to the Financial Event Group's Converted Total Currency Code. A currency matching your LCY Code posts as local currency.

    • A currency that is neither a Currency record nor a valid CURRENCY cross reference stops the worksheet build with an explicit error naming the transaction and currency code. Add the cross reference, then rebuild.

  • Tax Authority Reporting

    • Export data to Excel and create pivot tables filtered by GL tax-related accounts to obtain totals for tax presentations.