Convert Singapore bank statements.
Checked to the cent, in SGD.
Singapore statements are among the easiest to convert well: the banks print a running balance on most rows and describe transfers with the counterparty name and a PayNow or FAST reference. The difficulty is volume and shape: sole proprietors and small companies keep five years of records for IRAS, a consolidated eStatement can carry several accounts and a card in one PDF, and a multi-currency account lists each currency as its own section. This page covers what is particular to statements here and links the bank pages we have; the Worldwide providers below (PayPal, Stripe, Wise) are used by most online businesses in Singapore too.
Drop your bank statements here
One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.
Not ready to upload your own? See a sample result
5 pages free, no account. Dates, number format and currency are read from the statement; there is no country setting.
Singapore banks with their own page
Any other Singapore bank or card issuer works the same way; these are the ones people ask about. Each page covers how to download the PDF, what the statement looks like and where the bank's own export falls short.
How Singapore statements are laid out
Dates are day first, printed as DD MMM YYYY (03 Mar 2026) or DD/MM/YYYY, with the year on every row, so there is no month-order ambiguity. Amounts use a comma for thousands and a point for decimals, in separate withdrawal and deposit columns with a balance column beside them. Multi-currency accounts print one section per currency, each with its own opening and closing balance in that currency; the SGD section is not a total of the others. Descriptions carry the transfer type (FAST, PayNow, GIRO, NETS) and the counterparty name, often across two lines, and card statements show a foreign-currency amount beside the SGD charge for overseas spend. Interest and fees post on the last day of the month as their own rows.
What to know before converting
- A consolidated statement is read as several accounts: each section is checked against its own balances and gets its own sheet, and the card section is read with card sign conventions.
- Each currency section of a multi-currency account is a separate statement with its own currency code; do not expect the sections to add up to one total.
- Bank exports from internet banking usually cover the last few months and stop short of the opening balance; the eStatement archive goes back years and carries the balances the check needs.
- PayNow and FAST references can wrap to a second line; a wrapped line read as a row breaks the running balance at that point and is flagged there.
- Corporate customers with MT940 or CSV feeds already have structured data; the converter is for the PDF statements and the history the feed does not reach.
Who asks for statements, and in what form
IRAS expects businesses and the self-employed to keep records, bank statements included, for five years, and asks for them when a return is queried; GST-registered businesses reconcile deposits to invoices for the quarterly return. Banks ask for three to six months of statements for loans and credit cards, landlords for tenancy applications, and employment and residence applications sometimes ask for statements as proof of means. The request is always for the bank's own PDF; the spreadsheet is for your books.
Importing into Xero, QuickBooks Online, MYOB and others
Accounting software commonly used here: Xero, QuickBooks Online, MYOB, AutoCount, Excel. Each destination below has its own import steps.
- Bank statement to Excel.xlsx · step-by-step import
- Bank statement to CSV.csv · step-by-step import
- Bank statement to QuickBooks (QBO).qbo · step-by-step import
- Bank statement to Xero.csv · step-by-step import
- Bank statement to Tally XML.xml · step-by-step import
- Bank statement to Sage.csv · step-by-step import
- Bank statement to Wave.qbo · step-by-step import
- Bank statement to FreshBooks.csv · step-by-step import
- Bank statement to Google Sheets.xlsx · step-by-step import
Singapore questions
My DBS eStatement has three accounts and a card in one PDF. Do I have to split it?
No. Each account section has its own opening and closing balance, so the PDF is read as separate accounts, each checked against its own figures, with one sheet per account in the workbook and separate QuickBooks and Xero files. The card section is read with card conventions, payments in and purchases out.
How are the USD and SGD sections of a multi-currency account handled?
As two statements. Each section has its own currency, opening balance and closing balance and is reconciled on its own; the Excel workbook shows them on separate sheets and the QuickBooks file for each carries its currency code. Nothing is converted between currencies, because the statement does not do that either.
Which export works best for Xero in Singapore?
The Xero CSV. It has the Date, Amount, Payee, Description and Reference columns in the order Xero's bank import expects, with day-first dates written as ISO dates so Xero cannot misread them. Import it into the matching bank account under Accounting, Bank accounts, Import a statement; Xero then matches the lines to invoices and bills as usual.