Marketplace Settlement Report
Generate a report manually for the previous period
View Processed Data in Excel (XLS)
Processing the report without creating a document in the accounting system
How It Works: The script automatically gathers sales data from the marketplace for a specified period and generates a ready-to-use Marketplace Settlement Report in your accounting system.
Preparation and Basic Setup:
- Ensure that in your accounting system, a Commission Agreement and a Commission Invoice (with the agreement type set to "Commission") have been created for this marketplace.
- In the application, navigate to the Settings tab of the desired store, click "+ Additional Settings", and select Create Commission Report.
- Fill in the necessary parameters and click Save.
Schedule for Automatic Report Generation:
- For Wildberries (period — week): The report for the previous week is automatically generated on Wednesday of the following week.
- For Ozon and Yandex Market (period — month): The report for the previous month is automatically generated on the 10th of the following month.
Use Case Scenarios for the Script
Generate a report manually for the previous period
If you need the document immediately, without waiting for the automatic run:
- Open the script line and click the «Run» button.
- In the window that appears, select the desired period (week or month) and click «Run Now». The task will be queued for processing.
View Processed Data in Excel (XLS)
You can export a detailed reconciliation report to verify the accuracy of the calculations before sending them to the inventory management system:
- In the script execution window, select the desired period and generate the XLS file.
- Inside the file, you will find: by rows, all sold products with order numbers, sales amounts, as well as precise accruals for services and marketplace commissions for each shipment.
Processing the report without creating a document in the accounting system
This mode is useful if you want to simply upload and record data from the marketplace on the app side, but do not want to create additional documents in the accounting system itself (for example, if you handle accounting in another program):
- Enable the document creation blocking parameter in the script settings. The system will process the marketplace data without creating any documents.