The Payout to Reconciliation for Microsoft Dynamics 365 Business Central template enables you to reconcile transactions from multiple Amazon accounts that are synced with Business Central using the Amazon – Microsoft Dynamics 365 Business Central template. Install a business process template and integrate it with Amazon settlements to reconcile transactions from multiple Amazon accounts.
Note
The Payout to Reconciliation for Microsoft Dynamics 365 Business Central template is available only in the Premium edition.
Payout reconciliations for Amazon settlements
Settlement reports provide a detailed breakdown of a merchant’s account activity for a given settlement period. Settlement reports are generated regularly and can be downloaded from Amazon Seller Central. The Settlement report also provides detailed information about the different types of fees charged by Amazon for providing various marketplace services offered to the seller.
The Payout to Reconciliation for Microsoft Dynamics 365 Business Central template includes flows for all of the following requirements:
-
Get settlement reports for different settlement periods from Amazon Seller Central to Business Central for each Amazon account
-
View the merchant account's payment information
-
View an account summary that includes the opening balance
-
View next scheduled date for the transfer of funds
-
Sync order and refund totals from Amazon Seller Central to Business Central
-
Sync credits, fees, and adjustments for specific orders from Amazon Seller Central to Business Central
-
Update the status of the settlement summary report in Business Central
-
Post journal entries and their corresponding balances to the ledger accounts specified in Business Central
The overview of the reconciliation process for updating the settlement transactions from Amazon Seller Central to Business Central is explained below:
-
Request Amazon settlement report list and import the settlement report from Amazon to Business Central on a scheduled basis using the Request Amazon settlement report list flow. Users can also upload Amazon settlement reports manually via data loader using the Upload Amazon settlement report flow.
Note
Based on the flow selected, the remaining flows are auto-triggered.
Either of the flows will trigger the Amazon settlement report to Business Central custom settlement records real time flow to create custom settlement records in Business Central. The custom settlement record summarizes all the associated deposits of the Amazon settlement report to the summary record.
-
The Business Central settlement transactions (orders) to Business Central journals flow is a batch flow that is auto-triggered after the Amazon settlement report to Business Central custom settlement records real time flow. This flow considers transaction type “Order” in the settlement report and creates cash receipt journal entries for amount-type “ItemPrice”, “Promotion” etc, and creates general journal for amount-type “ItemFees” in business central.
The flow identifies the sales orders (MFN and FBA), searches for the sales invoices, and creates and posts payments(cash receipt journal) in Business Central for amounts sent by Amazon. Track Amazon fees through dedicated Business Central G/L accounts - Map Amazon fee types against Business Central general journal accounts.
Track Amazon order transactions through dedicated Business Central G/L accounts - Business Central payment account.
Important
Limitation: This flow can only be used if there is one Invoice per order, due to limitations in the Amazon API.
-
The Business Central settlement transactions (refunds) to Business Central journals flow is a batch flow that is auto-triggered after the Business Central settlement transactions (orders) to Business Central journals flow. This flow considers transaction type “Refund” in the settlement report and creates a payment journal entry for amount-type “ItemPrice”, “Promotion” etc, and creates general journal entries for amount-type “ItemFees” in Business Central.
The flow searches the existing sales return, creates sales credit memos, creates and posts refunds(payment journal) in Business Central for amounts sent by Amazon.
Track Amazon fees through dedicated Business Central G/L accounts - Map Amazon fee types against Business Central general journal accounts.
Track Amazon Refund transactions through dedicated Microsoft Business Central G/L accounts - Business Central refund account.
Important
Limitations:
-
The amount-type “Points” and “PointsFee” are ignored.
-
Customers should not create manual sales credit memo. In case they are doing any manual posting of sales returns order then they should only use the Receipt option available in Business Central.
-
-
The Business Central settlement transactions (non-transaction) to Business Central journals flow is a batch flow that is auto-triggered after the Business Central settlement transactions (refunds) to Business Central journals flow. This flow considers transaction type “non-transaction” such as “Miscellaneous Charges”, “ServiceFee”, or “Referral Fees” that are not considered “Order” or “Refund” in the settlement report and creates a general journal entry in Business Central.
The flow captures the non-transaction fee from the Amazon settlement report as general journal entries in Business Central.
Track Amazon non-transactions through dedicated Business Central G/L accounts - Map non-transaction types against Business Central general journal accounts.
-
The Business Central settlement summary report (update) flow is a batch flow that is auto-triggered after the Business Central settlement transactions (non-transaction) to Business Central journals flow. This flow runs on a scheduled basis to create journal entries to track the total amount deposited by Amazon for a given settlement summary report. Track different Amazon fees through dedicated Business Central G/L accounts. Reports Variance against G/L accounts.
If you select a bank account where the settlement proceeds need to be credited in the Amazon payment account setting, all the consolidated journal entries are created and posted via the cash receipt journal to the selected Amazon payment account.
If the Amazon payment account is left blank, you need to create manual journal entries in the cash receipt journal to reconcile the journal entries created and posted in previous steps for transaction type “Order”, “Refund” and “Non-Transactions”.
Comments
Please sign in to leave a comment.