Convert UOB Bank Statements to Xero CSV Format

To convert a United Overseas Bank (UOB) PDF statement into Xero, upload your electronic or scanned PDF to BankStmtConverter. The system automatically reads the transaction dates, transaction descriptions, withdrawals, deposits, and running balances, then produces a Xero-compatible CSV file formatted specifically for Xero's bank import tool. You can upload the resulting file directly into your Xero bank account feed without manual column mapping.

How do I convert a UOB statement to Xero?

Getting historical UOB transactions into Xero takes four straightforward steps:

1. Download your monthly statement PDF from UOB Personal Internet Banking or UOB Infinity (Business).
2. Upload the PDF file to BankStmtConverter.
3. Select Xero CSV as your target export format.
4. Download the converted file and import it directly into Xero under your UOB bank ledger.

If you prefer standard spreadsheets for ad-hoc analysis before importing to your ledger, you can also convert to UOB to Excel or standard UOB to CSV.

Why format UOB statements specifically for Xero?

Xero expects bank statement files to follow a strict structure. When you import a generic spreadsheet into Xero, you must manually map columns, clean up multi-line payment references, and resolve inverted debit/credit signs. If transaction dates are in an unrecognized format, Xero rejects the import or scrambles the calendar order.

UOB business and corporate statements often include complex payment descriptions such as FAST transfers, PayNow references, GIRO payroll batches, and TT references spread over two or three lines. Our Xero export pre-packages this data into the exact columns Xero expects:

• Date: Formatted cleanly as DD/MM/YYYY to match Singapore regional settings in Xero.
• Amount: Single amount column with negative values for debits/withdrawals and positive values for credits/deposits, eliminating dual-column mapping errors.
• Payee / Description: Consolidated multi-line narrations combined into the Description field so you do not lose invoice numbers or recipient identifiers.
• Reference: Extracted transaction reference codes (such as FAST or GIRO trace numbers) placed into Xero's Reference field for automatic bank rule matching.
• Check Number: Extracted cheque serial numbers mapped to help match unpresented cheques.

Importing the converted statement into Xero

Once you download your converted CSV, importing it into your organization takes less than two minutes:

1. Log in to Xero and open your organization dashboard.
2. Go to Accounting > Bank accounts.
3. Find your UOB SGD or foreign currency current account, click Manage Account, and select Import a Statement.
4. Click Browse, select your converted file, and click Import.
5. Because the file is pre-configured for Xero, the fields map automatically. Confirm the preview and complete the import.

Your transactions will appear on the Reconcile tab ready to be matched against outstanding sales invoices, bills, or bank rules. For organizations managing multiple accounts across the region, see our supported institutions on the Singapore bank statement directory.

Extracted data and reconciliation checks

UOB statements present transactions chronologically with opening and closing ledger balances. During conversion, the engine extracts every line item and performs a continuous balance check:

Opening Balance + Total Deposits - Total Withdrawals = Closing Balance

If a single cent is missing due to an obscured print line or folded page on a physical scan, the converter flags the discrepancy before you import the data into your accounting software. This prevents silent balance drift in your Xero balance sheet.

Example: UOB transactions converted for Xero

A typical Singapore business statement from UOB contains local clearing items in SGD. Here is an example of how raw UOB PDF data is structured for the Xero import file:

Handling scanned and password-protected UOB statements

Older archives or client-submitted files are frequently scanned paper copies rather than native digital PDFs. BankStmtConverter incorporates optical character recognition trained on Singapore bank statement typography, accurately recognizing decimal points, commas, and small tabular fonts even on skewed or low-contrast scans.

If your UOB eStatements are protected with an opening password, you can remove or supply the password during processing. The converter processes the data in memory and outputs the unencrypted, standardized CSV ready for Xero.

Data privacy and security

Financial records contain sensitive company and personal information. Files uploaded to BankStmtConverter are encrypted in transit via 256-bit SSL and processed automatically without human intervention. Your uploaded PDFs and converted files are permanently deleted from our servers shortly after processing, and your financial data is never used to train public language models.