Singapore · Free chart of accounts template

Singapore Ecommerce Chart of Accounts for Xero: Import GST and Fees

A free Singapore ecommerce chart of accounts for Xero: import GST on stock, the reverse charge on platform fees, and cost of goods kept apart from opex.

By ExpenseFlow team
· 25 June 2026

Free download · no email required

CSV with import and platform-fee accounts and a Xero GST code per line. Import file and tax-rate list below.

Download chart of accounts (CSV)

A Singapore online seller imports stock and pays fees to platforms billed from overseas, so the heart of the books is the GST treatment of imports and imported services. This is a Singapore ecommerce chart of accounts built for Xero, with import GST, the reverse charge, and a clean cost-of-goods-versus-opex split coded in. It ships as a readable reference (CSV) and a Xero import CSV.

Import GST hangs off the permit, not the invoice

Most commercial consignments exceed the S$400 low-value threshold, so import GST at 9% is paid to Singapore Customs at the point of import. The crucial accounting point is the document: that import GST is claimed on the Customs IN-PERMIT, filed through TradeNet by your forwarder, not on the overseas supplier’s invoice. So the chart keeps the supplier invoice on Cost of goods sold (recording the stock cost) and lists Imports: taxable supplies as the code for the import-GST line that the permit supports. A separate inbound freight and import duties account holds the shipping and duty, with Out Of Scope Purchases listed for overseas legs.

Platform fees and the reverse charge

Marketplace and processor fees billed from overseas are imported services. If the platform is GST-registered in Singapore, its fees carry GST you claim normally. If billed from abroad and you are partially exempt, the reverse charge applies and you self-account. So marketplace and platform fees and payment processing fees default to Standard-Rated Purchases but list Reverse charge: Taxable supply at 9% as the alternative. Payment processing also lists Exempt Purchases, because some merchant acquiring is an exempt financial service.

Cost of goods versus operating expenses

The chart deliberately separates the two. Cost of goods sold and inbound freight and import duties sit in the 5000s and capture the landed cost of stock. Marketplace fees, payment processing, shipping and fulfilment, packaging materials, and advertising sit in the 6000s as operating expenses. The split blurs when stock and fees both arrive as foreign-currency charges, but it is what dependable gross-margin reporting rests on, so it is worth holding the line at the point each invoice is coded.

Currency and the importer of record

Two practical points. GST is accounted for in Singapore dollars, so foreign-currency invoices convert to SGD at an approved rate, and the converted figure is the one in the F5; recording both the original and the SGD value preserves the trail. And import GST is claimable only by the importer of record on the permit, so if a forwarder or marketplace clears the goods in its own name, confirm whose name is on the IN-PERMIT before treating the GST as recoverable.

How to use it

  1. Open the CSV: each account carries its class, a default Xero GST code, the other valid codes, and a note. The import, fee, and shipping accounts are the ecommerce additions.
  2. In Xero, go to Accounting, then Chart of accounts, then Import, and upload the CSV, into a demo org first.
  3. Confirm the Singapore tax rates, including Imports: taxable supplies, exist in your org.
  4. When import GST is paid, post it against the import-permit document, not the supplier invoice.

The recurring work is the cross-border ledger:

  • A2X splits marketplace settlements into sales, fees, and refunds.
  • ExpenseFlow reads each receipt and supplier invoice, extracts the currency and line detail, flags a foreign-supplier purchase that carries no Singapore GST so the import-GST claim is pointed at the permit, and posts the transaction into Xero against the right account.
  • Dext pulls recurring supplier and courier bills into the file.

On QuickBooks instead? See the Singapore ecommerce chart of accounts for QuickBooks. For the full GST picture, see the Singapore ecommerce expenses guide.

Questions, answered

Common questions

How do I code import GST on stock?

The Cost of goods sold account lists Imports: taxable supplies as an alternative to the default Standard-Rated Purchases. Import GST above S$400 is paid to Singapore Customs and claimed on the import permit (the IN-PERMIT), not the overseas supplier's invoice, so the supplier invoice records the cost and the import permit supports the input tax.

Do overseas platform fees attract Singapore GST?

If the platform is GST-registered in Singapore, its fees include GST you claim on Standard-Rated Purchases. If billed from overseas and you are partially exempt, the reverse charge applies, which is why the marketplace and platform fees account lists Reverse charge: Taxable supply at 9% as an alternative.

Should selling fees go in cost of goods sold?

No. Marketplace selling fees, payment processing, and advertising are operating expenses, kept in the 6000s. Cost of goods sold is the purchase cost of stock plus directly attributable inbound costs. Mixing them distorts gross margin, which is why this chart separates them.

How is international shipping coded?

The Shipping and fulfilment account defaults to Standard-Rated Purchases for domestic delivery, with Zero-Rated Purchases and Out Of Scope Purchases listed for international freight and overseas legs. Match the code to where the service is performed.

Keep exploring

Stop filling in spreadsheets by hand

A template is a starting point. ExpenseFlow captures receipts, reads the tax automatically, and posts the cleaned record to Xero or QuickBooks Online, so the log keeps itself.

Start free trial