A free practitioner's guide by FusionEta Advisory — Malaysia's Xero implementation specialists for fund managers, family offices, and investment advisors. Track client deposits, multi-currency investments, forex gain/loss, and management fees without expensive fund software.
Most Malaysian asset managers, family offices, and boutique fund operators face the same problem: enterprise fund accounting systems (Geneva, Allvue, Advent) cost RM 50,000–200,000 per year and are designed for large institutions. Excel is free but unauditable, unscalable, and a compliance risk. Xero sits in the sweet spot — affordable, cloud-based, multi-currency, and powerful enough to run as a proper fund accounting backbone when configured correctly.
The "hack" is a chart-of-accounts design that repurposes Xero's invoicing and bill workflow to track client liabilities rather than conventional revenue. Every client deposit is a liability (you owe it back), every investment deployment is a liability reclassification, and every management fee is genuine income. With this framing, Xero handles the full fund accounting lifecycle.
💱
Built-in Multi-Currency
Xero natively supports USD, SGD, EUR and all major currencies alongside MYR. Realised FX is auto-calculated at settlement — no manual spreadsheet conversions.
📊
Real-Time P&L by Client
Filter the 4001/4002 ledger by Xero Contact to see each client's deposit balance, deployed investments, fees charged, and net position in seconds.
⚡
Automated Bank Feeds
Connect your custodian bank directly to Xero for automatic transaction import. Reconcile USD, SGD, and MYR accounts daily in one dashboard.
🔒
Audit Trail & Compliance
Every journal, invoice, and payment is timestamped and locked. Provide auditors with read-only access instantly. LHDN-ready reports at a click.
📱
Mobile-First Cloud Access
Approve invoices, reconcile transactions, and review client positions from your phone. Xero is fully functional on mobile — critical for busy fund managers.
💰
Fraction of Enterprise Cost
Xero starts from RM 79/month — less than 1% of the cost of enterprise fund accounting software. FusionEta handles the full setup for you.
The Core Insight — Xero as a Fund Accounting Backbone
Always enter invoices, bills, and bank transactions in the original transaction currency — never pre-convert to MYR. This single discipline is what allows Xero's FX engine to automatically compute realised forex gain and loss at settlement, eliminating one of the most error-prone manual tasks in fund accounting.
Records all capital received from clients — the fund's obligation to return deposits
4002
Client Investments
Liability
Tracks client money deployed into investment assets at book cost
4003
Realised Forex G/L
Income/Expense
FX gain or loss on settlement of foreign currency transactions (auto + reclassified)
4004
Unrealised Forex G/L
Income/Expense
Period-end revaluation of open FX positions — manual reversing journal
4005
Management Fee Income
Revenue
Fees earned based on AUM percentage or fixed retainer
4006
Performance Fee Income
Revenue
Incentive fees above a hurdle rate or high-water mark
4007
Investment Income
Revenue
Dividends, interest, coupon income received on investments
4008
Realised Inv. Gain/Loss
Income/Expense
Gain or loss on disposal of investment assets vs book cost
1001
Custodian Bank — USD
Asset
Bank account holding USD client funds (set as USD currency in Xero)
1002
Custodian Bank — SGD
Asset
Bank account holding SGD client funds (set as SGD currency in Xero)
1003
Gold Custodian Account
Asset
Holding account for gold position at USD book cost
2.2 Xero Tool → Asset Management Function
Xero Tool
Asset Management Function
Accounts Touched
Invoice (Sales)
Record client capital deposit as liability
AR → 4001
Credit Note
Client withdrawal or partial redemption
4001 Dr, AR Cr
Bill (Purchase)
Deploy capital into investment position
4002 Dr, AP Cr
Spend Money
Pay broker / settle investment Bill
Custodian bank → AP
Receive Money
Investment proceeds, interest, maturity
Bank → 4002 or 4007
Manual Journal
Unrealised FX revaluation (period-end)
4001/4002 ↔ 4004
Manual Journal
Reclassify Xero auto-FX to 4003
System FX → 4003
Repeating Invoice
Automated monthly management fee
AR → 4005
Need Help Setting This Up in Xero?
FusionEta Advisory specialises in Xero implementation for asset managers, fund operators, and family offices across Malaysia. We configure your chart of accounts, set up multi-currency tracking, and train your team — so you can focus on managing money, not accounting software.
Ahmad deposits USD 40,000 on 2 January 2025. The fund deploys USD 20,000 into an SGD fixed deposit and USD 20,000 into physical gold. In February, interest is received and a management fee is charged. At month-end, unrealised FX is revalued via a reversing journal. In March, gold appreciates and Ahmad makes a partial withdrawal of USD 15,000 — triggering both a realised investment gain and a realised forex gain.
4
All 9 Transactions — Full Double Entries
T1
Invoice (Sales)
Client Capital Deposit — USD 40,000
2 Jan 2025 · USD/MYR 4.50 · MYR equivalent: 180,000
Ahmad deposits USD 40,000 into the fund's custodian USD bank account. Raise a USD Invoice in Xero under Ahmad's contact, coding the line item to Account 4001 Client Deposits. Payment received same day — no realised FX arises as invoice and payment date are identical.
Double Entry — Invoice Raised
Account
Debit (Dr)
Credit (Cr)
Accounts Receivable — Ahmad (USD)
USD 40,000
4001 · Client Deposits — Ahmad
USD 40,000
On payment receipt (same day — bank reconciliation)
1001 · Custodian Bank USD
MYR 180,000
Accounts Receivable — Ahmad (USD)
MYR 180,000
Xero Mechanics: Accounts → Sales → New Invoice. Contact: Ahmad. Currency: USD. Line: "Capital deposit Jan 2025", Account: 4001, Qty 1, Price: 40,000. Tax: Exempt. Approve → reconcile incoming USD in the bank feed. 4001 now carries USD 40,000 liability to Ahmad.
USD 20,000 is converted to SGD and placed in a 6-month fixed deposit. Create a Bill from "Custodian Broker" coded to 4002 Client Investments (SGD). Settlement converts USD from 1001 into SGD at 1002. The MYR 115 conversion spread is a realised FX gain posted to 4003.
Double Entry
Account
Debit (Dr)
Credit (Cr)
4002 · Client Investments — SGD FD (Ahmad)
SGD 26,900
Accounts Payable — Custodian Broker (SGD)
SGD 26,900
Settlement — Spend Money from 1001 to settle SGD bill
Accounts Payable — Custodian Broker (SGD)
SGD 26,900 (MYR 90,115)
1001 · Custodian Bank USD
USD 20,000 (MYR 90,000)
4003 · Realised Forex G/L — Gain (conversion spread)
MYR 115
Xero Mechanics: Accounts → Purchases → New Bill. Supplier: Custodian Broker. Currency: SGD. Line: "SGD FD deployment", Account: 4002. Approve. Then Spend Money from 1001 (USD) to settle the bill. Xero auto-posts the MYR 115 rate difference to the system FX account — reclassify to 4003 via manual journal.
T3
Bill + Spend Money
Deploy USD 20,000 into Physical Gold
3 Jan 2025 · USD/MYR 4.50 · No currency conversion — USD position
USD 20,000 deployed into physical gold at a gold custodian. USD-denominated — no FX conversion. Bill to "Gold Custodian" coded to 4002 (USD). Spend Money from 1001 settles. Custodian bank 1001 is now fully deployed.
28 Feb 2025 · SGD/MYR 3.50 · 3% p.a. × 60 days on SGD 26,900 = SGD 133
Interest of SGD 133 credited to the SGD custodian bank 1002. Post via Receive Money coded to 4007 Investment Income. Per the fund agreement, interest can be re-invested into Ahmad's 4001 balance or distributed on withdrawal.
Double Entry
Account
Debit (Dr)
Credit (Cr)
1002 · Custodian Bank SGD
SGD 133 (MYR 465.50)
4007 · Investment Income — Interest
SGD 133 (MYR 465.50)
Xero Mechanics: Bank → Receive Money in the SGD bank account. Code to 4007 Investment Income. Tax: Exempt. If re-investing: post a manual journal Dr 4007 / Cr 4001 to credit Ahmad's deposit balance.
Monthly management fee of USD 50 billed to Ahmad — genuine fund revenue, not a liability. Common practice: deduct directly from 4001 via manual journal to avoid small cash movements.
Double Entry — Option A: Invoice
Account
Debit (Dr)
Credit (Cr)
Accounts Receivable — Ahmad (USD) [Mgmt Fee]
USD 50
4005 · Management Fee Income
USD 50
Option B: Deduct directly from 4001 (Manual Journal — preferred)
4001 · Client Deposits — Ahmad (fee deduction)
USD 50
4005 · Management Fee Income
USD 50
Best practice for Malaysian fund managers: Deduct management fees directly from 4001 via a manual journal. This avoids physical cash transfers for small monthly fees and keeps 4001 as the accurate net balance owed to Ahmad.
T6
Manual Journal — Reversing
Period-End Unrealised FX Revaluation — Feb 2025
28 Feb 2025 · Closing: USD/MYR 4.65 | SGD/MYR 3.50 · Reversal date: 1 Mar 2025
Revalue open foreign currency positions at closing rates. Gold (USD 20,000): (4.65 − 4.50) × 20,000 = MYR 3,000 unrealised FX loss. SGD FD (SGD 26,900): (3.50 − 3.35) × 26,900 = MYR 4,035 unrealised FX loss. Total: MYR 7,035.
Double Entry — Reversing Journal
Account
Debit (Dr)
Credit (Cr)
Gold revaluation — USD 20,000 × (4.65 − 4.50)
4004 · Unrealised Forex G/L — Loss (Gold)
MYR 3,000
4002 · Client Investments — Gold (FX adj)
MYR 3,000
SGD FD revaluation — SGD 26,900 × (3.50 − 3.35)
4004 · Unrealised Forex G/L — Loss (SGD FD)
MYR 4,035
4002 · Client Investments — SGD FD (FX adj)
MYR 4,035
Total Unrealised FX Loss — Feb 2025
MYR 7,035
CRITICAL: Tick "Reversing Journal" in Xero — set reversal date to 1 March 2025. Xero does NOT automatically revalue open liability balances. This entire step is manual. The reversal clears the unrealised entry on 1 March; actual realised FX is captured at true settlement date and rate.
Ahmad requests USD 15,000 back. Gold has appreciated to USD 22,500 market vs USD 20,000 book — a 12.5% gain. Liquidate enough gold to fund the withdrawal: sell USD 16,875 at market (book cost of that tranche = USD 15,000), realising USD 1,875 investment gain.
Realised FX — rate 4.70 vs original 4.50 → MYR 3,000 gain (auto-posted by Xero, then reclassified)
4001 · Client Deposits (FX adj on closure)
MYR 3,000
4003 · Realised Forex G/L — Gain
MYR 3,000
Xero Mechanics: (1) Add Credit Note to Ahmad's original invoice → 4001. (2) Receive Money in 1001 for USD 16,875 → split between 4002 (USD 15,000) and 4008 (USD 1,875). (3) Spend Money from 1001 → match against Credit Note. Xero detects 4.70 vs 4.50 rate difference and auto-posts MYR 3,000 → reclassify to 4003.
Gold return = 12.5% on USD 15,000 deployed. Above 5% hurdle → excess = USD 1,125. Performance fee = 20% × USD 1,125 = USD 225. Ahmad nets USD 16,650 total (USD 15,000 capital + USD 1,650 net gain after fee).
Double Entry
Account
Debit (Dr)
Credit (Cr)
Accounts Receivable — Ahmad (USD) [Perf Fee]
USD 225
4006 · Performance Fee Income
USD 225
Collection — deducted from withdrawal proceeds
1001 · Custodian Bank USD
USD 225
Accounts Receivable — Ahmad (Perf Fee)
USD 225
Net to Ahmad: USD 16,875 proceeds − USD 15,000 capital return − USD 225 performance fee = USD 1,650 net gain distributed.
5
Forex Gain & Loss — How Xero Handles It
5.1 Realised FX — Automatic via Xero
Realised FX arises when a foreign currency transaction is settled at a different rate than the original invoice or bill. Xero computes this automatically at reconciliation — but posts to an internal system account that must be reclassified to 4003.
Trigger
What Xero Does
Your Action
USD invoice paid at different rate
Posts to "Realised Currency Gains" system account
Journal to reclassify to 4003
USD bill settled at different rate
Same — rate difference auto-posted
Journal to reclassify to 4003
Foreign bank reconciliation
Rate difference posted to system FX account
Journal to reclassify to 4003
Credit note matched at different rate
FX delta auto-posted on matching
Journal to reclassify to 4003
5.2 Unrealised FX — Manual Period-End Process
Xero does NOT automatically revalue open foreign currency liability balances at period-end rates. Asset managers must perform this manually every period.
Pull a Trial Balance filtered to 4001 and 4002 — note each currency balance.
Obtain the period-end closing rate (Bank Negara Malaysia, Bloomberg, or your prime broker).
Calculate: (Closing Rate − Original Book Rate) × Outstanding FCY Balance = Unrealised FX in MYR.
Post Manual Journal: Dr/Cr the balance account (4001/4002) vs 4004. Tick "Reversing Journal" — set reversal to first day of next month.
Reversal auto-posts, clearing the unrealised entry. Real FX captured at actual settlement.
Unrealised FX Formula for Liability Accounts
For 4001 and 4002 (liability accounts): if the foreign currency APPRECIATES (rate goes UP in MYR terms), your obligation in MYR increases — that is an UNREALISED LOSS to the fund. Journal: Dr 4004 Loss / Cr 4001 or 4002. Never post unrealised movements to 4003 — that account is for settled/realised events only.
6
Transaction Summary — Ahmad's Closing Position
Tx
Description
4001 Deposits
4002 Investments
4003 Realised FX
4008 Inv. G/L
T1
Client deposit USD 40,000
+USD 40,000
—
—
—
T2
Deploy → SGD FD
—
+SGD 26,900
+MYR 115
—
T3
Deploy → Gold USD
—
+USD 20,000
—
—
T4
SGD interest received
—
—
—
4007: +SGD 133
T5
Management fee Feb
−USD 50
—
—
4005: +USD 50
T6
Unrealised FX revaluation
—
4004: −MYR 7,035
Reversed 1 Mar
—
T7
Partial withdrawal USD 15,000
−USD 15,000
−USD 15,000 book
+MYR 3,000
+USD 1,875
T8
Reclassify system FX
—
—
Confirmed 4003
—
T9
Performance fee
—
—
—
4006: +USD 225
NET
Closing position
USD 24,950
SGD 26,900 + USD 5,000
MYR 3,115
USD 1,875 gain
4001 — Remaining Liability
USD 24,950
Ahmad still invested
4002 — Deployed Assets
SGD + USD
FD + Gold remaining
Realised FX Gain
MYR 3,115
115 + 3,000
Investment Gain
USD 1,875
Gold liquidation
Mgmt Fees Earned
USD 50
Feb 2025
Performance Fees
USD 225
20% above 5% hurdle
7
FusionEta Advisory Services
You now have the framework. But setting up Xero correctly for asset management — especially multi-currency, FX tracking, and per-client reporting — takes 20–40 hours if you do it alone. FusionEta does it in days, correctly from day one, with ongoing support to keep your books audit-ready.
Xero Setup for Asset Managers
Full chart-of-accounts build, multi-currency configuration, bank feeds, client contact structure, and the complete 4001/4002 liability tracking framework — ready to use from day one.
We handle your monthly Xero reconciliation, forex revaluation journals, management fee billing, and client position reporting — so your books are always current and auditable.
Period-end reporting packages, unrealised FX schedules, fund AUM statements, and LHDN-compliant accounts prepared to support your SC, SSM, or external audit requirements.
2–4 hour hands-on training sessions for your finance team — covering the full invoice-to-forex workflow, credit note redemptions, and period-end journal processes specific to asset management.
"We were running our fund on Excel for 3 years. FusionEta moved us to Xero in two weeks — now I can see every client's position, forex exposure, and fee income in one dashboard. It's transformed how we manage the back office."
AR
Fund Manager, Kuala Lumpur
Multi-strategy investment fund · Xero client since 2024
Why FusionEta?
We are one of the few accounting advisory firms in Malaysia that understands both the accounting mechanics (double-entry, forex, fund structures) and the Xero implementation layer. We don't just set up the software — we configure it specifically for how asset managers think about client money, investment positions, and P&L attribution.
8
Frequently Asked Questions
Can Xero really handle asset management accounting in Malaysia? +
Yes — with the right configuration. Xero is not purpose-built for fund accounting, but its multi-currency engine, invoice/bill workflow, and manual journal capability cover the core needs of Malaysian asset managers managing client deposits, multi-currency investments, forex gain/loss, and management fees. FusionEta's chart-of-accounts design (4001–4008 framework) unlocks this capability.
How does Xero calculate realised forex gain and loss? +
Xero automatically calculates realised FX when a foreign-currency invoice or bill is settled at a different rate than the original posting date rate. The difference is posted to Xero's internal "Realised Currency Gains" account. As part of the FusionEta setup, we configure a reclassification workflow so all realised FX flows to your controlled account 4003 for clean reporting.
Does Xero automatically revalue foreign currency balances at month-end? +
No. Xero does not auto-revalue open foreign currency liability balances at period-end. Asset managers must post a manual reversing journal each period-end to account 4004 (Unrealised Forex G/L). FusionEta can handle this monthly as part of our bookkeeping service, ensuring your balance sheet always reflects current FX exposure.
Can I track each client's balance separately in Xero? +
Yes. By assigning each client as a separate Xero Contact, you can filter the 4001 (Client Deposits) ledger by contact to see exactly how much you owe each client. Combined with Xero's Tracking Categories, you can also segregate by fund or strategy for multi-fund operators.
Is Xero suitable for regulated fund managers (SC-licensed) in Malaysia? +
Xero provides a solid bookkeeping and reporting backbone that is LHDN-compliant and audit-ready. However, it is not a licensed fund administration system. For SC-licensed fund managers with strict regulatory reporting requirements, Xero is best used as the accounting layer alongside a compliance platform. FusionEta can advise on the right architecture for your licence class.
How much does Xero cost for asset managers? +
Xero's subscription starts from approximately RM 79–199 per month depending on the plan. Multi-currency is available on the Business plan (RM 179/month at time of writing). FusionEta's one-time setup fee for the full asset management framework starts from RM 3,500, with optional monthly bookkeeping support from RM 1,500/month.
Can FusionEta migrate my existing Excel-based fund records into Xero? +
Yes. FusionEta offers a data migration service that converts your existing Excel fund ledger, client deposit history, and transaction records into Xero's format. We handle opening balances, historical FX rates, and client contact setup as part of the migration engagement.
Ready to Move Your Fund Accounting to Xero?
Join Malaysian asset managers who have replaced Excel with a proper, auditable, multi-currency Xero setup. FusionEta Advisory handles everything — from initial configuration to ongoing monthly support.
.