Every channel has its own settlement format
Settlement reports from Amazon, Shopee, TikTok Shop and Naver SmartStore all look different. Every close starts with lining up columns and cleaning the data again.
Month-end close automation
E-commerce month-end close, automated: built up from daily closes
Orders and settlements from marketplaces such as Amazon, Shopee and TikTok Shop, plus actual shipments and returns from your 3PLs, are closed every day. Mismatches are caught as they appear, so at month end you review what is left and send the journal entries to your ERP.
Why a spreadsheet close takes days
With one sales channel, you match one settlement report against your orders. Each new channel adds another set of files to match and another set of rules for matching them.
Settlement timing does not follow order timing
The day an order comes in and the day the channel settles it are different, and the settlement cycle differs by channel. So a month of settlements never lines up neatly with a month of orders.
Order data mixes in cancellations, returns and unshipped orders
Booking sales from order data counts cancelled orders, returned items and orders that have not shipped yet. So someone pulls the 3PL shipment and return records and checks them line by line.
Fees and net sales have to be split by channel and product
Journal entries need fees and net sales totaled separately by channel and by product. More channels and products mean more sheets and more formulas.
Daily closes add up to the month-end close
The close is not saved for the end of the month; it runs a little every day. Month end starts from results already matched.
Curious what settlements are matched against and which mismatches show up? More on settlement reconciliation
Daily close
Channel orders and sales are combined with actual 3PL shipments and returns, and sales are totaled by channel and product every day.
Settlement reconciliation
Channel settlements are matched against orders and actual shipments and returns, with unshipped orders and returned items kept apart.
Review differences
Settlements that do not match orders or actual shipments surface before the close, and your finance team reviews them.
Journal entries
Fees and net sales are organized by channel and product and turned into journal entries in the format your ERP expects.
Post to the ERP
Entries go out in the format your ERP expects. SAP has a public case, and Douzone, Younglimwon, Ecount, Oracle and in-house ERPs can be connected too.
Repetitive work runs automatically; decisions stay with finance
The column matching and line-by-line checks done in spreadsheets move to BATI CIS, and your finance team looks at the items that need a decision.
What BATI CIS does
- Collects channel order and settlement data and 3PL shipment and return data
- Converts each channel's order and settlement formats into one schema
- Reconciles settlements and separates unshipped orders and returns
- Totals sales, fees and net sales by channel and product
- Builds journal entries and posts them to the ERP
What the finance team does
- Reviews the mismatches found before the close
- Decides how each mismatch is handled
- Scopes which channels, logistics and ERP to connect during rollout
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
Keep your ERP; the entries are built in front of it
If you run SAP, raw data is processed in BATI CIS and SAP receives only the entries it needs. More on SAP integration
SAP has a public case, and Douzone, Younglimwon, Ecount and Oracle can also be connected with journal entries in the format each ERP expects. For an in-house ERP we design the integration with you.
- SAP (public case)
- Douzone
- Younglimwon
- Ecount
- Oracle
- In-house ERP
Month-end close automation questions
Settlement cycles differ by channel. How do they get matched?
Each channel sends settlement reports at its own time and on its own cycle. BATI CIS collects each channel's settlement reports and matches them against orders and actual shipments and returns. Orders that came in but have not shipped and items that came back are kept apart.
How is this different from closing the month in accounting software or an ERP?
Accounting software and ERPs work after a journal entry exists. BATI CIS does the step before: it collects raw data from many sales channels, standardizes it, reconciles settlements and sends the result to your ERP as entries.
How are returns handled by our 3PL reflected in sales?
Shipment and return data from 3PL and fulfillment partners is matched with channel orders and settlements. Sales and settlements follow actual shipment and return data rather than orders, so returned items are kept apart and the ERP receives sales for what actually shipped.
How much shorter does month-end close get?
In our published case, K-Beauty Brand C's finance team went from 3 days to 3 hours. Results can vary with the number of channels and the volume of data.
Which channels' settlements can be reconciled?
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. Collection is set per channel, automatic or by receiving files, and which settlements we connect for each channel is confirmed in the consultation.
Can we use it if we only run a Cafe24 store?
Install the Cafe24 app and open it with [관리하기] (Manage) in the Cafe24 admin to see your store sales and Naver SmartStore sales by date in one table, with Excel download. If you need settlement reconciliation across several channels and ERP journal entries, start an enterprise build through the inquiry form.
Related articles
Articles are in Korean.
- Market trends
10월 화장품 수출 14.4억 달러와 마켓 수수료·규제 변경(2026년)
10월 화장품 수출은 14.4억 달러로 1년 전보다 57.5% 늘어 역대 10월 가운데 가장 많았습니다(산업통상부 잠정).
Start by telling us your channels and how long your close takes today
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