Why Mox Bank CSVs Fail in Xero
Mox Bank splits debit and credit into separate columns with mashed FPS descriptions that Xero cannot interpret. This causes Xero to either reject the import entirely or misinterpret your financial data, leading to incorrect balances and reconciliation headaches.
Manual CSV editing is time-consuming and error-prone. Even experienced bookkeepers struggle with Mox Bank’s non-standard format, often spending hours fixing data that should import in seconds.
Our Solution:
Our intelligent converter automatically detects and fixes Mox Bank’s formatting issues, transforming messy bank exports into clean, Xero-ready CSV files in seconds. No manual editing, no data errors, no frustration.
Mox CSV structure
Mox exports typically use 交易日期, 交易描述, 支出, 存入, 餘額. Debit and credit sit in two columns, so Xero cannot treat them as one signed amount. We collapse 支出/存入 into Amount (+ inflows, − outflows) and drop the running balance so it is not imported as a transaction.
FPS and mashed descriptions
Mox FPS lines look like “FPS / TRANSFER OUT / TO CHAN TAI MAN / REF 12345”. We pull the payee and reference out so Xero bank rec shows a person or merchant, not a slash-separated string. AlipayHK and WeChat Pay lines inside the Mox file are split the same way.
Virtual-bank feed gap
Mox’s Xero connection, when available, still misses transactions dated before the feed started. Export the history from the Mox app or web, clean it here, and import the backfill. Then reconcile so you do not duplicate anything the live feed already posted.
See a Mox Bank export cleaned
This is the same sample used in the live tool — no upload required.
Raw export
交易日期,交易描述,支出,存入,餘額 01/02/2024,FPS / TRANSFER OUT / TO DEMO PAYEE / REF DEMO-12345,500.00,,15000.00
Accounting-ready
Date,Amount,Payee,Reference 01/02/2024,-500.00,DEMO PAYEE,DEMO-12345
100% Browser-Based
Your Mox Bank data never leaves your computer. Zero uploads, zero risk.
Zero Data Retention
Process your CSV locally. Your file never leaves your device.
Instant Results
Convert Mox Bank CSVs to Xero format in under 30 seconds.
Simple Subscription Pricing
Convert unlimited Mox Bank CSVs
Monthly
Flexible. Cancel anytime.
- Unlimited conversions
- Supports common CSV and Excel bank exports
- Clean Excel exports with original columns preserved
- Advanced date detection
- Cancel anytime (access until billing period ends)
Annual
Save 42%. Best for regular users.
- Everything in Monthly
- Save 42% vs monthly
- All current BankCSVPro features included
Frequently Asked Questions
How do you clean Mox FPS descriptions?
We split “FPS / TRANSFER OUT / TO …” into payee and reference. Auto-pay lines such as 自動轉賬 - 中華煤氣 keep the merchant name instead of the whole raw string.
Mox already has a bank feed. Why export a CSV?
Feeds start from the connection date. Client onboarding, year-end, and audit work usually need months or years before that. The CSV is the historical file; the feed covers what happens next.
Do you support Mox personal and business accounts?
Yes. Any Mox CSV/Excel with a date, description, and debit/credit (or amount) column can be cleaned for Xero, QuickBooks, or Excel.
Is the Mox file processed on your servers?
No. The sample and your own export both run in the browser only.