Convert UOB Bank Statements to OFX

To convert your United Overseas Bank (UOB) statement to OFX, upload your PDF statement to BankStmtConverter. The system parses your transaction dates, descriptions, withdrawal and deposit amounts, and running balances, then structures the data into a standard Open Financial Exchange (.ofx) file. You can download the converted file immediately and import it into financial tools like Moneydance, GnuCash, or your ERP system without manual data entry.

How to convert your UOB statement to OFX

1. Log in to UOB Personal Internet Banking or UOB Infinity (for corporate accounts) and download your periodic bank statements as PDF files.
2. Upload the UOB PDF statement to the converter tool.
3. Review the preview screen to verify extracted columns, opening balances, and closing totals against your original statement.
4. Select OFX as your desired output format and click download to save the .ofx file to your computer.
5. Import the OFX file directly into your target desktop or cloud accounting application.

What data is extracted from UOB statements?

UOB bank statements issued in Singapore follow a clean tabular layout, but their structure varies slightly between current accounts, savings accounts, and corporate business accounts. The extraction engine captures the core fields needed to construct valid OFX financial records:

• Transaction Date and Value Date: Dates formatted in standard Singapore business order (DD/MM/YYYY), mapped to OFX DTPOSTED tags.
• Transaction Description / Details: Full narrative lines, including FAST payment references, PayNow identifiers, GIRO transfers, cheque numbers, and merchant details.
• Withdrawals (Debit) and Deposits (Credit): Parsed as signed numerical values (negative for outflows, positive for inflows) according to OFX TRNAMT standards.
• Transaction Type: Categorized automatically into OFX standard transaction tags (such as DEBIT, CREDIT, PAYMENT, CHECK, or FEE).
• Running Balance and Ledger Balance: Extracted to populate the OFX LEDGERBAL and AVAILBAL blocks, ensuring your software knows the official closing position.
• Unique Transaction Identifier (FITID): A deterministic hash generated for every row to prevent duplicate transaction entries when re-importing statements.

Using UOB OFX files in accounting and personal finance software

OFX (Open Financial Exchange) is an established XML-based financial data standard. Unlike raw spreadsheet exports, an OFX file carries formal metadata about your UOB bank account, currency (SGD, USD, or other multi-currency balances), and transaction types. This prevents common import errors such as flipped signs or misaligned date columns.

Many desktop tools and enterprise accounting systems rely on OFX when a direct API bank feed is unavailable or when importing historical archives. Applications such as Moneydance, GnuCash, Sage, and various ERP platforms accept standard OFX bank feeds. When you import the file, your software matches incoming FITID references against existing records, automatically categorizing recurring GIRO payments or supplier transfers while preventing duplicate entries.

If you prefer working with spreadsheet formulas or require raw text manipulation, you can also convert your statements to UOB Excel or UOB CSV formats.

Worked example: UOB statement to OFX structure

Below is a sample of typical corporate transactions from a UOB SGD current account in Singapore:

When converted into an OFX document, these rows become structured transaction blocks inside the <BANKTRANLIST> element:

<STMTTRN>
  <TRNTYPE>CREDIT</TRNTYPE>
  <DTPOSTED>20241003</DTPOSTED>
  <TRNAMT>4500.00</TRNAMT>
  <FITID>20241003001UOB450000</FITID>
  <NAME>FAST-PAYNOW CR PYMT FROM CLIENT PTE LTD</NAME>
</STMTTRN>
<STMTTRN>
  <TRNTYPE>DEBIT</TRNTYPE>
  <DTPOSTED>20241007</DTPOSTED>
  <TRNAMT>-8200.00</TRNAMT>
  <FITID>20241007001UOB820000</FITID>
  <NAME>GIRO SALARY OCT 2024</NAME>
</STMTTRN>

Conversion method comparison

When dealing with monthly reconciliation, manual entry or generic copy-paste often leads to errors. The table below compares the typical methods for turning UOB PDF statements into structured accounting feeds:

Handling scanned and multi-page UOB statements

Older UOB statements retrieved from archives or printed records often exist only as paper copies or flat scanned images. BankStmtConverter uses an optical character recognition (OCR) pipeline trained on banking table structures. It aligns headers, splits multi-line PayNow or GIRO narratives into single clean records, and handles multi-page statements seamlessly. The engine calculates the mathematical progression from the opening balance across all debits and credits to ensure the parsed closing balance matches the printed total on your PDF.

Data security and confidentiality

Your financial statements contain sensitive business information. Uploaded PDF files are processed over encrypted HTTPS channels, parsed in isolated memory environments, and permanently deleted from our servers shortly after conversion. Your transaction data is never shared, resold, or used to train machine learning models. You can also view our guides for other institutions on the Singapore bank statement converters directory.