Convert DBS statements to QuickBooks.
Checked against the printed balances first.
The digibank download reaches back about six months for current and savings accounts and has no running balance, while eStatements are kept for seven years.
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. The QuickBooks download appears on the results page.
Download the statement from DBS
- Log in to digibank Online. On the Home screen scroll down to eDocuments and click Show All.
- Choose eStatement, then filter by statement type (for example Current & Savings or Credit Card) and by year.
- Click the statement month and it opens as a PDF. Save it from the viewer. eStatements are monthly or quarterly only; ad hoc and weekly statements are still paper.
- In the digibank mobile app: tap More in the bottom bar, then eDocuments under Quick Access or Other Services, then eStatement, then the download icon on the month you want.
- DBS IDEAL (business): main menu, Accounts, select the account, then eStatements and the PDF icon. Or Reports > Account eStatements for the whole list.
Then drop the file above. Several months at once is fine; each statement comes back as its own .qbo file.
Before you upload: is the PDF password-protected?
eStatements downloaded from digibank or IDEAL open without a password. DBS emails a notification that a statement is ready rather than attaching the PDF, so the file you upload will be the one you saved from the portal.
DBS and QuickBooks
The digibank download reaches back about six months for current and savings accounts and has no running balance, while eStatements are kept for seven years. For the older months QuickBooks needs, converting the eStatement PDF produces a .qbo checked against the Balance Brought Forward and Balance Carried Forward rows.
On an account page in digibank you can set a period and click Download to get a file that opens in Excel, with Transaction Date, Reference, Debit Amount, Credit Amount and reference fields under a header showing the ledger and available balance. The window is short: 6 months for current and savings accounts and only the previous two months plus the current one for other account types, and there is no running balance per row. eStatements, by comparison, are kept for 7 years from the month you enrolled in eDocuments, and a printed copy of anything older costs from S$20 to S$50 per month. IDEAL business users can export MT940 and CSV, which is the better feed for ongoing bookkeeping; for history and for the official record, convert the eStatement PDF.
Import into QuickBooks
- Drop the statement on the home page. Fix any flagged row (or swap debit/credit if the bank prints them reversed) until the badge is green.
- Click QuickBooks (.qbo).
- QuickBooks Online: Transactions → Bank transactions → Link account ▾ → Upload from file → choose the .qbo → pick the account → Next.
- QuickBooks Desktop: File → Utilities → Import → Web Connect Files → choose the .qbo → select the account.
- Review the imported transactions in the For Review tab and add them.
What usually goes wrong
- For multi-currency accounts, convert one currency section at a time so each is checked against its own balance.
- Reversed signs: money out imported as deposits. The most common complaint about statement converters. We show you the totals and let you swap before export.
- Duplicate transactions on re-import because the FITID changes each time. Ours is derived from the row content, so the same statement always produces the same IDs.
- "QuickBooks found an error" on upload, usually from a missing INTU.BID, unescaped ampersands or a bad date. Check any .qbo with our free QBO checker.
None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a DBS file.
Already have a .qbo that QuickBooks rejects?
Run it through the free QBO checker. It reads the file in your browser (nothing is uploaded) and lists exactly what QuickBooks will object to: missing INTU.BID, duplicate FITIDs, bad dates, unescaped ampersands, sign mismatches.
DBS and QuickBooks questions
Do DBS and POSB statements convert the same way?
Yes. POSB is a DBS brand and the statements come from the same system with the same columns, so the only difference you will notice is the logo and the account names. Note that POSB Passbook Savings accounts do not get eStatements at all; if a client has one of those, the transactions have to come from an updated passbook or the account has to be moved to POSB Everyday Savings first.
My DBS Multi-Currency Account statement has SGD, USD and other sections. How is that handled?
One currency per upload. Each section has its own brought-forward and carried-forward balance in its own currency, and the converter reads a file as a single statement in a single currency, so save the SGD pages and the USD pages as separate PDFs (Print to PDF with a page range) and convert each. The SGD file is then checked against the SGD balance and the USD file against the USD balance, and each lands in the right ledger account.
Does it work with QuickBooks Online and Desktop?
Yes. The .qbo is OFX 1.02 with the INTU.BID QuickBooks requires, which both accept. Desktop imports via Web Connect.
What if QuickBooks rejects the file?
Run it through the QBO checker at /tools/qbo-checker; it explains what QuickBooks objects to. If the issue is with a file we produced, email support with the conversion ID and we fix the reader.
Can I get DBS transactions into QuickBooks without the bank's own export?
Yes. Download the statement PDF from DBS, drop it on this page and wait for the balance check, which compares the rows with the balances printed on the statement. Then download the QuickBooks file and import it with the steps above. No DBS template is involved; the statement is read the way a person reads it, and the balance check is what tells you the rows are complete.