GeminiPOS
How Online Sales Reach Your Books Automatically
Web Store, Shopee, Lazada and TikTok Shop sales are booked automatically to the right account (Bank, Cash or 1025 Marketplace Receivable), reconciled on the Settlement tab, and marketplace fees are deducted in the P&L.
How Online Sales Reach Your Books Automatically
Every online sale — your own Web Store, Shopee, Lazada or TikTok Shop — is written to the GeminiPOS accounting Journal automatically, to the right account, with no manual entry from staff. This guide is for merchants and bookkeepers who want to know where the money from every online sale goes in the books, when it gets written, and how Shopee/Lazada/TikTok payout statements get reconciled back to the ledger.
Overview
- Your own Web Store is booked like a POS counter sale — gateway payments go to 1010 Bank, cash/COD goes to 1000 Cash.
- Shopee, Lazada, TikTok Shop are booked to 1025 Marketplace Receivable (Clearing) first — the money has not reached your bank yet.
- Once a marketplace pays out, the Settlement tab generates a journal that clears 1025 against Bank plus fee expense accounts.
- Refunds are reversed back to the same money account as the original sale.
- Orders with no branch are counted under the tenant's first branch; P&L now deducts marketplace fees automatically.
Step 1: When the Online Sale Journal Is Written
A journal entry is only written once an order is delivered/fulfilled — never while it is still pending or already cancelled. Open Online Orders and look at each order's status badge: Open Accounting → Journal to see the list of posted journal entries:
- The SHOPFRONT (Web Store) order is badged Delivered — this is the one that reaches the journal, with its profit shown right on the card (Profit: +RM 5.40 (32%)).
- The TikTok Shop orders badged Cancelled on the same day never reach the journal — no accounting entry is generated for them.
Step 2: Your Own Web Store — Booked Like a Counter Sale
Your own Web Store sales follow the same payment mapping as a POS counter sale: Click any sale entry to expand it and see the full debit/credit lines. Here is the real test order E2E-SF-20261111 (RM16.80, paid online):
- Online payment gateway (card, e-wallet, FPX, DuitNow QR) — 1010 Cash in Bank
- Cash on Delivery (COD) / cash — 1000 Cash on Hand
- Dr 1010 Cash in Bank RM16.80 — "Online store sale: online"
- Dr 5000 Cost of Goods Sold RM11.40
- Cr 4000 Sales Revenue RM16.80
- Cr 1030 Inventory RM11.40
- Total debit = total credit = RM28.20 (the amount shown on the journal list).
Step 3: Shopee, Lazada, TikTok Shop — Goes to 1025 First
Third-party marketplaces hold the buyer's money first and pay you out periodically, so their sales are booked as receivable, not straight to your bank: Account 1025 is only used for Shopee, Lazada and TikTok Shop — never for your own Web Store. Open Accounting → Accounts to see the e-commerce-related accounts in the Chart of Accounts: 1026 Payment Gateway Clearing and 1027 Marketplace Seller Wallet are additional clearing accounts: card/e-wallet gateway payments and the Shopee/Lazada seller wallet balance pass through there before they fully land in 1010.
- Dr 1025 Marketplace Receivable (Clearing) / Cr 4000 Sales Revenue — the full sale amount.
- Dr 5000 Cost of Goods Sold / Cr 1030 Inventory — the cost of the goods sold, the same as a counter or Web Store sale.
Step 4: When a Marketplace Pays Out — the Settlement Tab
When Shopee/Lazada/TikTok pays you out (after deducting commission and fees), you reconcile that payout statement against the ledger at Accounting → Settlement: The resulting settlement journal debits 1010 Bank (the net amount received) and the marketplace fee expense accounts (commission, transaction fee, service fee), then credits 1025 to clear the outstanding receivable. The demo account has no real settlement statements yet, so here is an illustrative example with made-up numbers to show the journal's shape: For Shopee and Lazada, the net payout first lands in 1027 Marketplace Seller Wallet, then moves to 1010 once withdrawn to your bank. The numbers on the card above are an example only — do not treat them as your account's real data.
- SYNC API STATEMENTS — Pulls payout statements directly from the connected marketplace/gateway API.
- UPLOAD STATEMENT (CSV) — Imports a payout statement CSV file manually.
- GENERATE SETTLEMENT JOURNAL — Generates the accounting journal from the statements that were synced or uploaded.
Step 5: Refunds Reverse to the Same Money Account
When an order is returned/refunded, the reversing journal credits the same account that was debited on the original sale:
- A Web Store sale paid to 1010 → the refund is credited back to 1010.
- A cash counter sale → the refund is credited back to 1000.
- A marketplace sale (receivable at 1025) → the refund is credited back to 1025.
Step 6: Orders with No Branch & the P&L Report
Some marketplace orders — especially ones arranged directly in the seller center — have no branch set. Those orders are counted under the tenant's first branch (by that branch's creation date) — in the journal, and in both P&L reports (the regular view and the AI one). The P&L report now also deducts marketplace fees (commission, transaction/service fees from settlement journals) as a separate line before reaching Net Profit: The Marketplace Fees card only appears once there is a marketplace settlement fee journal inside the selected date range. The demo account currently has no marketplace settlements, so this card does not appear in the screenshot above — that is expected behaviour, not a missing feature.
Where to Find This
- Accounting → Journal — every journal entry (sales, refunds, settlements, expenses).
- Accounting → Accounts — the full Chart of Accounts (1000–1030 and beyond).
- Accounting → Settlement — sync/upload payout statements and generate the settlement journal.
- Reports → P&L — Profit & Loss, including the marketplace fee deduction.
Why doesn't my Cancelled TikTok order show up in the Journal?
That's intentional. A journal entry is only written once an order reaches delivered/fulfilled status. Orders that are still pending, or that get cancelled, never generate a journal entry — so your books never count a sale that didn't happen.
Why does my Shopee sale go to 1025 instead of straight to my bank?
Shopee (and Lazada, TikTok Shop) hold the buyer's money and pay you out periodically after deducting fees. 1025 Marketplace Receivable (Clearing) represents the balance the marketplace still owes you until that payout is confirmed on the Settlement tab.
My Web Store uses COD — why does it go to Cash instead of Bank?
The account mapping follows how the customer actually paid: online gateway payments (card/e-wallet/FPX/QR) go to Bank (1010); Cash on Delivery and cash go to Cash (1000) — the same as a cash sale at the POS counter.
My marketplace order has no branch. Where is it counted in the P&L?
It is counted automatically under your tenant's first branch (by that branch's creation date), whether you're viewing the "All Branches" P&L or that specific branch alone.