Operations ledger
Admin Login
Sign in to access reconciliation data.
Operations ledger
Reconciliation
Orders, settlements, exceptions
Turn marketplace activity into a clear reconciliation queue.
Import BigSeller orders, add marketplace settlements, then focus on mismatches and overdue payouts without loading unnecessary history.
Signed in as
Step 1
Reconciliation Controls
A direct visit opens the last 7 days to keep the ledger quick. Dates supplied by Overview take precedence over the rolling window.
Reconciliation Results
Matched rows include the Rp100 rounding tolerance. Date filters use order date, or payout date for unmatched payouts. Explicit dates override the rolling window. Unknown-channel payouts appear only under All channels.
| Status | Channel | Order Status | Order ID | Order Date | Scope Date | Age (days) | Due Payment | Expected Source | Customer | Expected Payout | Actual Payout | Difference | Unresolved Value | Payout IDs | Detail |
|---|
Step 2
Import Workspace
Use BigSeller as the order database, then upload settlement files from each marketplace.
Marketplace Settlement Import
Upload settlement file from Shopee, TikTok Shop, or Blibli. By default this imports payouts only.
| Channel | Order ID | Order Date | Payout Date | Gross | Net | Fee | Affiliate |
|---|
BigSeller Orders Import
Upload BigSeller order export (real-time statuses). This powers order-side reconciliation context.
| Order ID | Channel | Order Date | Order Status | Marketplace Status | Due Payment | Age (days) | Overdue >14d | Items | Gross | Fee |
|---|
Manual CSV import tools
Orders CSV
Columns: order_id,order_date,customer_name,amount,platform_fee
Payouts CSV
Columns: payout_id,order_id,payout_date,amount
Import Report
Validation and row-level issues from your latest import.
| Dataset | Row | Field | Message |
|---|
Safe Reset
Reset now requires a time-limited token and exact confirmation phrase.
Audit Log
Recent actions from this app.
| Time (UTC) | Admin | Action | Detail |
|---|