Cloud ledger
QuickBooks Online, Xero, Zoho Books
The three standalone cloud ledgers we map most imports into. Familiar chart structures, reliable app marketplaces, and enough audit trail to keep a month end defensible.
Sheet 01
Payout released
Every payout is settled before it is spent.
Straits Ledger connects Singapore e-commerce selling channels to a cloud ledger so gross sales, platform fees, refunds and the payout figure land on the same sheet every month.
4 lines
The four settlement lines every mapped channel has to produce: gross sales, platform fees, refunds, payout.
Sheet 02
Marketplaces and how they connect
Marketplace accounting starts with a settlement report. Amazon and Etsy publish theirs in formats that map reasonably well to ledger imports; regional platforms such as Shopee and Lazada each produce their own settlement structures that we handle with a defined import routine.
The integration does not have to be live for the ledger to work, but the export does have to be available. If you sell on a channel that only ever shows you a bank deposit, it becomes a manual channel — and gets flagged as one.
How we connect the platform families we work with most often
-
01
Amazon settlement reports
Native export format, imported via a defined mapping for fees, refunds and reserves.
4 Released -
02
Etsy Payments export
Payments, refunds and shop fees arrive as one settlement file we map once per month.
3 Released -
03
Shopee settlement structure
Defined import routine for seller fees, shipping subsidies and adjustment lines.
3 Released -
04
Lazada settlement structure
Mapping verified against the exported statement before the first live month end.
3 Released -
05
Bank-deposit-only channels
No export, no mapping. Documented manual routine instead, with the reason recorded.
— Held
Sheet 03
Storefronts and how orders reach the ledger
Shopify and comparable storefronts are commonly integrated with accounting software through apps, pushing orders, inventory and payment data into the ledger. That keeps a sales order flat in one direction when it is posted — which is what prevents duplicate revenue when the payout later arrives.
Where a storefront app is unreliable or missing a field, the fix is usually a defined export mapping rather than a replacement store. We test the flow before trusting it for a month end — and if the test fails, we say so before it costs you a close.
GST treatment
Storefront sales to Singapore buyers are standard-rated. Zero-rated exports depend on how the order ships and what proof of export you keep.
Read the GST guideWhat a Shopify-style connection actually does
An app push runs in one direction: order in, inventory moved, payment cleared to a clearing account. The payout lands later against the same order, and because the sales side is already posted, the import has to be a settlement — not a second sale. Get that wrong and the month shows twice the revenue it earned.
1
Direction of flow for a storefront push: orders enter the ledger once, settlements reconcile against them.
1
Ledger account holds the clearing balance, so no order is counted twice when the money actually arrives.
-
01 — Before you sign
Ask which channel is a mapped import and which is a documented manual routine. If the answer is 'all of them are automated', push back.
-
02 — During migration
Test one settlement cycle end to end before month end. We map, run it, and reconcile the clearing account back to zero on a real payout.
-
03 — Every month after
Fees, refunds and payouts are matched line by line, so the account stays clean and IRAS-ready without a scramble in April.
Sheet 04
Ledgers we work in
Your accounts live in a cloud ledger, and we work across the main ones: QuickBooks Online, Xero, Zoho Books and AutoCount Cloud Accounting. AutoCount Cloud Accounting is a pay-as-you-use cloud product with access from any device and no major hardware investment — which suits sellers who want operational data alongside finance.
Odoo Accounting is different in kind. It is an ERP suite covering accounting plus ecommerce, inventory and other business modules, so it makes sense when a store's operations have outgrown a standalone bookkeeping tool. We will tell you which category your store is actually in.
We will tell you which of these categories your store is actually in, because the honest answer is worth more than a branded recommendation.
Ask about a ledger choice
Cloud ledger with operations data
AutoCount Cloud Accounting
Pay-as-you-use cloud access with no major hardware investment. Suits sellers who want sales and stock data sitting alongside finance, not apart from it.
ERP suite
Odoo Accounting
Accounting plus ecommerce, inventory and other business modules in one system. Worth it once a store's operations have outgrown a standalone bookkeeping tool — not before.
Sheet 05
Payment methods and settlement cycles
Payment gateways and buy-now-pay-later services are treated as their own channels, each with a fee schedule and a payout cycle that can lag the sale by days or weeks. The integration question is whether the gateway's settlement report can be exported — not whether it has a logo on our site. Where one can, it becomes a mapped channel. Where one genuinely cannot, the manual routine is documented so the month end still closes on time.
Reconciled
100%
of mapped payouts cleared to the exact settlement lines we imported, before the ledger is closed.
Sheet 06
When manual handling is the right answer
Some channels are too small, too new, or too irregular to justify an automated mapping. Rather than force it, we define a manual posting routine and record the reason.
Manual is not
A failure mode
A channel that only ever shows a bank deposit is not broken. It just cannot be automated without inventing detail the statement does not contain. Forcing a mapping there creates a suspense problem instead of solving one.
Undocumented manual work is
The real failure mode
An undocumented manual routine leaves a suspense account growing quietly in the corner. We document the posting, name the reason, and hand the routine over so any competent bookkeeper can follow it.
Sheet 07
Checking your own stack
If you want to know whether your channels can be connected before you talk to anyone, export one settlement report from each platform and try to identify the four lines. If they are findable, the channel can almost certainly be mapped.
If the report is missing one of them, that is exactly where the manual routine has to sit. This is also the fastest way to work out which ledger suits the channels you actually sell on.
Two-minute test
Open the settlement report. Look for gross sales, platform fees, refunds and the payout figure. Four lines present, and you have a mapping candidate.
-
Step one
Export one report per channel.
-
Step two
Find the four settlement lines.
-
Step three
Note the missing one, if any.
-
Step four
Bring it in, and we will tell you where it becomes manual.
Bring us a report and we will tell you the truth about it
Send one settlement export and roughly where your books currently live. We will reply with which of your channels we can map, which need a documented manual routine, and which ledger we would start with — before you commit to anything.
- Office
- 71 Robinson Road, #14-01
Singapore 068895 - Hours
- Monday to Friday
9:00 am – 6:00 pm (Singapore time) - Phone
- +65 6821 9482
- [email protected]
We meet in person when the numbers get strange — bring the statement export and we will look at it together.