Channel settlement report
Shows what the channel settled and the fees it deducted. The format and the settlement timing differ by channel.
Marketplace settlement reconciliation
BATI CIS reconciles marketplace settlements; finance reviews only the mismatches
Settlement reports from marketplaces such as Amazon, Shopee and TikTok Shop are matched against your orders and against actual shipments and returns from your 3PL and fulfillment partners. Cancelled, unshipped, returned and mismatched-amount items are caught before the close, so your finance team only checks those.
Settlements, orders and actual shipments, matched together
Matching settlements to orders alone cannot tell you whether an order actually shipped, so actual shipments and returns from your 3PL and fulfillment partners are the third reference.
Orders
Shows what customers ordered and at what price. Cancelled orders and orders that have not shipped yet are in there too.
Actual 3PL shipments and returns
The record of what actually left the warehouse and what came back as returns. It is the basis for booking sales for what actually shipped.
BATI CISEach channel's order and settlement formats are converted into one, then the three data sets are matched against each other.
Where mismatches come from
When the three data sets are matched, some records do not pair up. These are the common cases.
| Mismatch | What it is | Matched against |
|---|---|---|
| Cancelled orders | Still in the order data, but cancelled and never shipped. | Orders and 3PL shipment records |
| Orders not yet shipped | The order came in, but there is no 3PL shipment record yet. | Orders and 3PL shipment records |
| Returned items | Shipped, then came back as a return. Booking sales from orders leaves them in sales. | 3PL return records and channel settlements |
| Amount and fee differences | The amount or fee on the settlement report does not match the order data. | Channel settlements and orders |
| Different settlement timing | The order came in one month and the channel settled it in another. Settlement cycles also differ by channel. | Channel settlements and orders |
Some, such as unshipped orders or timing differences, line up as time passes. Amount and fee differences need a separate check.
Results fall into three groups
Records that already agree do not need a second look. They are sorted into matched, set aside and to review.
Matched
The settlement, the order and the actual shipment agree. They are organized into fees and net sales by channel and product and go on to journal entries.
Set aside
Orders not yet shipped and items that came back. They are kept apart so sales follow actual shipments and returns rather than orders.
For finance to review
Amount or fee differences, or records that do not pair up across the settlement, the order and the actual shipment. They surface before the close, and your finance team decides how to handle them.
How to handle a mismatch is your finance team's call.
Published customer case
K-Beauty Brand C: finance team month-end close from 3 days to 3 hours
A K-beauty brand selling on global channels such as Amazon, Shopee and TikTok Shop. Results vary by setup.
- Finance team month-end close
- 3 days → 3 hours
Reconciled settlements carry on into month-end close and ERP entries
Month-end close
Reconciling every day means month end starts from the differences that remain.
More on month-end close automationERP entries
Matched settlements are organized into fees and net sales by channel and product and become journal entries in the format your ERP expects. SAP has a public case, and Douzone, Younglimwon, Ecount and Oracle can be connected too.
More on SAP integrationMarketplace settlement reconciliation FAQ
What does settlement reconciliation match against what?
It matches channel settlement reports against the orders and against actual shipment and return records from 3PL and fulfillment partners. BATI CIS checks whether the amounts and fees a channel settled match orders that actually shipped, and whether cancelled, unshipped or returned orders are mixed in, and surfaces mismatches before the close.
Is matching orders against settlements not enough?
Order data also contains cancelled orders, orders not yet shipped and orders that came back as returns. Whether an order actually shipped shows only in 3PL shipment and return records, so BATI CIS matches those too and books sales for what actually shipped.
Does BATI CIS fix mismatches automatically?
No. BATI CIS finds mismatches before the close and keeps them apart from matched records. Your finance team reviews them and decides how to handle each one.
Can it reconcile settlements from overseas marketplaces such as Amazon, Shopee and TikTok Shop, and from Korean open markets?
Settlements from overseas marketplaces such as Amazon, Shopee, TikTok Shop, Rakuten and Qoo10, and from Korean channels such as Naver SmartStore and Kakao, can be connected. Each channel's settlement format is converted into one, then matched against orders and actual shipments and returns on the same basis. Which settlements we connect for each channel is confirmed in the consultation.
Do we have to change our ERP to reconcile settlements?
No. BATI CIS reconciles settlements in the step before the ERP and sends the result as journal entries in the format your ERP expects. SAP has a public case, and Douzone, Younglimwon, Ecount and Oracle can be connected too. For an in-house ERP we design the integration with you.
Related articles
Articles are in Korean.
- Settlement
이커머스 정산 대사, 판매액·정산서·입금액 차이 원인과 확인 순서
판매액과 정산서는 수수료와 반품, 유보 때문에, 정산서와 입금액은 환전과 지급 시점 때문에 달라집니다.
- Channels
아마존 SP-API 정산 리포트 Flat File V2 전환(11월 11일)
2026년 11월 11일부터 SP-API로 받는 아마존 정산 리포트는 Flat File V2 하나입니다.
Start by telling us your channels and 3PLs
Enterprise builds start with the inquiry form. We scope the channels, logistics and ERP integration together, and a dedicated manager supports rollout and operations.
Smaller brands running a Cafe24 store can start right away with the Cafe24 app. About the Cafe24 app