Home / eCommerce Mall / Financial Accounting
Capabilities

Financial Accounting · Cash Flow & Reconciliation Auto-Aggregated

Finance no longer works overtime reconciling at month-end. Orders, refunds, distribution commissions, withdrawals, stored-value top-ups, points deductions — every transaction has a complete ledger in the system, monthly closing generates statements with one click, and they auto-match against WeChat / Alipay / bank records, with discrepancies flagged in red automatically.

6
Cash Flow Types
T+1
Auto Reconciliation
0
Manual Excel
Capabilities

Every Transaction Has a Traceable Ledger

From order booking to withdrawal clearing, every fund movement across the chain is auto-aggregated — finance no longer pieces together Excel

💵 Cash Flow Ledger

Order booking / refund deductions / stored-value top-ups / withdrawal payouts / points deductions / commission payouts — six ledger types fully auto-recorded

📝 Order Reconciliation

Compare mall orders vs actual WeChat / Alipay settlement records entry by entry, with discrepancy orders auto-flagged in red for manual review

Refund Clearing

Each refund links to its original order and refund channel; once funds return to the original source, clearing completes — books and reality stay aligned

💰 Commission Settlement

Distribution commissions are batch-settled by cycle into WeChat wallets; the commission calculation basis is traceable down to the specific order

Withdrawal Review

Members / distributors initiate withdrawals, with two-tier review by operations + finance; amounts over a threshold require manual confirmation, keeping risk controllable

📄 Monthly Reports

Monthly revenue / refunds / commission payouts / net profit generated with one click, exported to Excel / PDF and handed straight to the boss

mall.shangbangke.com/finance/ledgerLedger
L
Cash Flow Ledger
FilterExport
Time / Type / DocAmountAccount
05-18 Income · SO...8001+$53.00Balance
05-18 Refund · RF...009-$19.00Refund
05-18 Top-up · CZ...021+$172.00Stored
05-17 Exception · Dup charge-$0.01Flagged

Each entry links to its source document; balance/stored/points separate

Every Cent Has an Origin

How much did the user pay, refund, deduct in points and spend on a stored-value card — each has its own ledger entry linked to the original order. For any amount question, finance searches the ledger number and traces it back in a second, never again flipping through order details one by one plus chat histories.

  • Ledger filtered multi-dimensionally by time / type / order number / member
  • Each ledger entry links to the original document (order / refund slip / top-up slip)
  • Balance / stored-value / points changes are recorded separately, never confused
  • Abnormal ledger entries (negative amounts, duplicates) auto-flagged in red
mall.shangbangke.com/finance/reconcile3-way
R
Three-Way Reconciliation
DiscrepanciesPull Statements
2,184Entries
2,181Matched
2Amount Diff
1Missed
Order NoMallThird-partyResult
SO...8001$53.00$53.00Match
SO...7991$19.00$18.00Diff
SO...7944$69.00Missed

Three-Way Reconciliation: Mall vs WeChat / Alipay

The mall shows 1,000 orders sold for $500K in revenue — but how much actually settled? Pull the WeChat Pay merchant reconciliation file + Alipay transaction details, and the system auto-matches entry by entry, ticking matched amounts and flagging mismatches in red. The discrepancy order list goes straight to finance for review, completing full reconciliation at T+1.

  • WeChat Pay reconciliation files / Alipay transaction details auto-pulled
  • Mall orders matched entry by entry against third-party records
  • Amount discrepancies, missed orders and duplicate charges auto-flagged in red
  • Reconciliation history archived and auditable, grounding finance
mall.shangbangke.com/finance/reportMay Report
$
Monthly Financial Report
Excel/PDFGenerate
$268KRevenue
$12KRefunds
$18KCommission
$238KNet Profit

Net profit, last 6 months ($K)

156Dec
190Jan
167Feb
225Mar
265Apr
238May

Month-End Reports Generated with One Click

Finance used to spend 3 days at month-end piecing Excel together: export one from the order system, one from the WeChat merchant account, one from the distribution system, one from the stored-value system, then align fields, merge data and generate reports. Now all data sits in one database — one-click export the monthly overview + details, done in 3 minutes.

  • Monthly overview of revenue / refunds / commission payouts / net profit
  • Revenue breakdown by product / category / member / channel
  • Export in three formats: Excel / PDF / CSV
  • Report templates customizable to match the enterprise's financial standards
Use Cases

How Different Roles Use Financial Accounting

Month-End Reconciliation

On the 1st of each month, finance pulls the reconciliation report with one click; mall orders vs WeChat Pay records are matched entry by entry, and monthly closing succeeds only when discrepancy stays under 0.1%.

Commission Payout

Batch-settle last week's distribution commissions every Monday — one-click transfer to WeChat Change for 2,000 distributors, done in 2 minutes.

Large-Withdrawal Risk Control

A single withdrawal over $10K auto-triggers manual review; finance verifies the real identity and distribution records before approving — averting account risk.

Quarterly Audit

When external auditors arrive needing full Q3 transaction details + refund details + balance-change ledger, all three reports export to PDF with an electronic seal in one click.

Related Features

Financial Accounting Works With These Capabilities

Cash flow originates from orders, threading through distribution / members / marketing across the chain

Try Financial Accounting Now

Sign up to experience the full financial management capabilities for free, or book a consultant demo