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 the Amazon Seller Central. Settlement Report also provides very detailed information about the different types of fees charged by Amazon for providing various marketplace services offered to the seller.
Settlement reports can be generated weekly and bi-weekly. After a settlement report is generated by Amazon, the seller receives payment for all the goods sold in their Amazon account. Each report has a breakdown of Item Price, Amazon commission fees, shipping fees, and the total amount earned by the seller.
Payments (Settlement) report displays your account's payment information. With this report, you can:
-
View an account summary that includes the beginning balance
-
View next scheduled date for the transfer of funds
-
View order and refund totals.
-
View credits, fees, and adjustments for specific orders.
A sample of the Payments (Settlement) report:
Advantages of integrating Amazon Settlement Reports with Microsoft Dynamics 365 Business Central
-
Streamline and speed up account receivables by automatically posting Amazon reported payments into Cash Receipt and General Journals of Business Central.
-
Analyze most profitable vs least profitable items on Amazon directly from Business Central.
-
Provides a holistic view to your accounting teams for all sales through Amazon.
-
Provides visibility into key metrics like total fee charged per SKU or per order, and total deposits for a given settlement period.
-
Automate syncing refunds from Amazon and create credit memos from Business Central.
Download an Amazon settlement report
Use the following steps to download a settlement report from your Amazon seller central account:
-
Log in to your Amazon Seller Central Account.
-
Go to Payments > Payments > All Statements.
-
Click Download Flat File V2 for the relevant Settlement Period.
Note
You need to click Request Report for a Settlement Period before you can download the report.
-
Save the file on your hard drive.
To see prior settlements, select a date range for the settlement period you are interested in and click Search.
Note
-
To open the settlement report, Amazon recommends using a spreadsheet or database program, such as Microsoft Excel or Microsoft Access.
-
Settlement reports are available only for the past 90 days. We recommend that you download and save these settlement reports for your own records.
-
If you do not have a positive or zero account balance with Amazon at the end of your settlement period, then no settlement takes place and no report is generated.
Settlement Report Integration Flows
The Payout to Reconciliation for Microsoft Dynamics 365 Business Central template helps you import settlement reports from Amazon into Business Central and automatically generate reports that help you analyze most profitable items, Amazon fees, net profit, and so on.
Note
The template only supports the .txt and tab-separated CSV file format of the settlement report.
The template eliminates the need to manually reconcile the Amazon settlement reports and provides an automated way to generate settlement reports, drill down up to an Item level.
The following flows can be used to process different information in Business Central using the settlement report:
-
Imports the settlement report from Amazon Seller Central to Business Central.
-
You can use one of the following two options to sync your settlement report and process the settlement reconciliations:
-
Automatically pull the settlement report.
-
Upload the settlement report manually.
-
-
The Request Amazon settlement report list, Upload Amazon settlement report, and Amazon settlement report to Business Central custom settlement records (add) flows can import settlement reports.
-
When you run the Request Amazon settlement report list, Upload Amazon settlement report, and Amazon settlement report to Business Central custom settlement records (add) flows, the template performs the following action in Business Central:
-
Creates a settlement summary report.
-
Creates settlement transactions for orders, refunds, and non-transactions.
-
Settlement transactions (orders) flow
The settlement transactions (orders) flow identifies the sales orders (MFN), searches for the invoices, and creates customer payments for amounts that Amazon sends. For FBA, orders are directly imported as invoices, so payments are directly created.
Settlement transactions (refunds) flow
Creates sales credit memo and refunds (for Invoices) or customer refunds for the refunds generated in the report.
Settlement transactions (non-transactions) flow
Posts the settlement records not related to orders or refunds such as miscellaneous charges or referral fees to the selected account in the general journals.
Settlement summary update flow
Updates the settlement transactions status to the settlement summary report and creates the deposit and withdrawal entries to the account selected in the Amazon payment account setting.
Note
You can only leverage these flows with the premium edition of the Payout to Reconciliation for Microsoft Dynamics 365 Business Central template.
Comments
Please sign in to leave a comment.