Cloud Accounting for Malaysian E-Commerce, Retail & Inventory Businesses

Malaysian e-commerce and retail are among the fastest-growing parts of the SME economy — but they generate a specific kind of bookkeeping complexity that a generic monthly close cannot keep up with: hundreds or thousands of orders a month, spread across platforms that each settle on their own schedule, net of their own fees. ZeroPilot AI's accountants configure and run your Xero, Dext, and Syft Analytics setup specifically for this workflow, so your numbers reflect what actually happened — not what your bank balance suggests.

The E-Commerce & Retail Accounting Problem in Malaysia

Online and retail sellers we onboard are almost always dealing with the same set of problems when they come to us:

• Orders across Shopee, Lazada, Shopify, TikTok Shop, and in-store POS, each with a different payout rhythm
• Platform payouts that net off fees, vouchers, shipping rebates, and return deductions — so the deposit in the bank is never the same number as gross sales
• Inventory purchased from suppliers at fluctuating prices, making an accurate cost of goods sold figure genuinely hard to produce by hand
• Multiple payment gateways and channels (iPay88, Billplz, Stripe, PayPal, card, e-wallet) each with a separate settlement cycle to match against the bank
• Returns and refunds that have to unwind both the accounting entry and the inventory movement correctly, or margin reporting silently drifts
• SST on taxable goods and LHDN e-invoice obligations, including the consolidated e-invoice rules for high-volume B2C sales

Treating a bank deposit as revenue — which is what happens when this is done without a proper setup — overstates income and understates the true cost of selling on each platform. This is the single most common bookkeeping mistake we see in Malaysian e-commerce and retail businesses.

Platform & POS Reconciliation — Handled by Our Team

As part of your onboarding, we connect your Xero environment to the platforms and payment systems you actually sell through, and our team reconciles every settlement cycle so you don't have to touch a spreadsheet:

• Shopee & Lazada: We import and parse full settlement reports — commissions, coin/voucher cashback, shipping rebates, and return-handling fees — and map each line to the correct account
• Shopify & WooCommerce: Order sync for direct-to-consumer stores, reconciled against gateway settlements
• TikTok Shop: Order and settlement data reconciled on the same cycle as your other channels
• Payment gateways: iPay88, Billplz, Stripe, and PayPal settlement statements are matched to the bank feed, with gateway fees posted as an expense and net settlement as revenue
• In-store POS: Daily sales by payment method — cash, card, Touch 'n Go, GrabPay, Boost — reconciled against bank deposits

What used to take a business owner an entire afternoon per settlement period becomes a line item our team clears as part of your monthly close.

Inventory Costing and COGS, Managed On Your Behalf

For product businesses, we configure your Xero chart of accounts and inventory tracking using FIFO or weighted-average costing — whichever is appropriate for your stock — so cost of goods sold is calculated correctly with every sale, not estimated at year-end. If you sell across multiple outlets or warehouses, we track stock and margin separately by location while consolidating into one company-level view. Your Syft Analytics dashboard shows gross margin by SKU, category, and channel, so you can see which platform or product line is actually profitable once fees and shipping are accounted for — not just which one moves the most volume.

SST and LHDN e-Invoice for High-Volume B2C Sellers

Issuing an individual LHDN e-invoice for every consumer order isn't practical at retail or e-commerce volume, and LHDN doesn't require it. Our team submits consolidated daily e-invoices covering your B2C sales in compliance with LHDN's rules, via Xero and the MyInvois API, and issues individual e-invoices automatically for the B2B buyers who provide a TIN. SST is calculated correctly across every channel using your configured tax codes, so classification doesn't drift between, say, product sales and shipping fees — a common source of RMCD queries.

Returns, Refunds, and Margin Integrity

A refund that isn't handled correctly in the books quietly corrupts both revenue and inventory. When a platform or customer return comes through, our team reconciles it to reverse the original sale, restore stock where applicable, and adjust the SST liability — so your gross margin figures stay accurate even in a business with a meaningful return rate.

Restaurants & F&B: Food Cost, Delivery Platforms, and the 6% Rate

Restaurants and F&B outlets are a retail variant with their own numbers to watch: food cost percentage (typically 25–35% of food revenue for most Malaysian restaurants), labour cost percentage (often another 25–35%), and a net profit margin that usually lands at 8–15% once rent, utilities, and everything else is accounted for. We track all three in your monthly reporting so operational issues — a supplier price increase, portion drift, overstaffing on slow nights — show up while there's still time to correct them.

We reconcile your POS Z-report against bank and delivery-platform deposits — including GrabFood, Foodpanda, and ShopeeFood settlements — so cash, card, and delivery-platform sales are never mismatched against what actually hits the bank. On tax, F&B services carry their own Service Tax rate of 6%, not the general 8% rate that applies to most other services — we apply the correct rate to your SST-registered sales and monitor your revenue against the RM500,000 registration threshold if you're not yet registered. Where you track ingredient purchases as inventory, we can calculate theoretical food cost per dish against actual spend, which is often the fastest way to spot waste or portion control issues before they erode margin.

Frequently Asked Questions