DBS/POSB Statements to Excel: Document Types, Currencies and CSV Checks

Use the issued account/currency cycle, create a checked CSV from a suitable PDF and import it into Excel; keep advice and letter records separate. This guide covers the Singapore product and the task described below.

Separate eStatements, eAdvices and eLetters

DBS's eDocuments guide identifies all three document classes as PDF. Its live FAQ qualifies the storage windows by enrollment or October2026, whichever is earlier: eStatements seven years; eAdvices/eLetters one year. This is not proof of a particular older file or pre-enrollment backfill. A payment advice or letter is not the statement's full movement list.

The viewing help excludes POSB Passbook Savings account statements. The eDocuments guide separately makes debit-card eStatements eligible when the primary linked account is POSB Passbook Savings. Those are different document/product conditions, so do not extend either rule to every document linked to the account.

Make one source decision for each account and currency

Choose the actual eStatement rather than copying a letter or individual transaction-detail download. DBS's transaction-detail help describes six-month activity and individual details; it does not establish a personal CSV export. Business IDEAL export instructions are outside this guide.

In a deliberately invented two-currency worksheet, an SGD balance and a USD movement cannot be added as though they share one unit. If your actual document has separate accounts or currencies, retain their source headings and build separate tables with matching endpoints. The exported amount field alone cannot carry account/currency metadata; keep those facts in the private register. Do not infer an exchange rate or manufacture a converted balance from a document that does not provide one.

A suitable native personal table was not established by the reviewed sources; this is an unknown, not a claim that none exists. If your legitimate bank service offers one, inspect its actual fields and coverage before choosing the PDF workflow.

Create a CSV from a PDF you have actually obtained

This step starts with a suitable original already in your possession. It does not establish an unverified bank download control. Keep that file unchanged and make a separate working table. A native export that already supplies the required account, dates and detail can bypass PDF conversion.

Manual route: build and check the table

1. Open the original in a trusted local viewer. Record the account alias, currency, printed start/end and any page references in a private source register. Read the complete transaction section, including continuation pages.
2. Decide what the source calls each date. Use the posted date when that is the chosen task; if another relevant date is present, retain it in an additional private worksheet column. Do not use the file's download date as a transaction date.
3. Create a working sheet with date, description, amount. Transcribe each included posted movement once. Join a description continuing onto another line only when it belongs to that same movement. Do not insert section headers, carried balances or summary totals as transactions.
4. For this deposit cash table, use positive inflows and negative outflows. Read the actual source's debit/credit or sign convention before mapping it. Do not assume a borrowing or card balance uses the same convention. Keep different accounts and currencies separate.
5. Compare the worksheet with the original page by page. Mark each source movement checked once; inspect dates, description text, decimal points and signs. If text selection loses columns or joins unrelated lines, transcribe from the visible original instead. If a scanned or unclear page cannot be read reliably, obtain a clearer copy or leave the affected rows unresolved.
6. Save a separate CSV working copy using your editor's CSV format. Inspect the actual delimiter and encoding; changing a file extension does not create a CSV. The small comma-delimited example below shows the chosen fields, not bank-export headers. Preserve any richer private worksheet columns separately if the three-field copy omits information you need.

Optional LocalExtract route: inspect output before importing

Open LocalExtract and select one PDF for the operation. Let the local parser/OCR process it, inspect the resulting transaction table against every relevant page, and export CSV. The current export contains date,description,amount; it does not supply a complete replica of every field in the original. Compare dates, signs, missing or duplicate movements and continued descriptions before relying on it. The original remains the authority for this check. No actual bank PDF or output was tested for this guide, so neither the public help route nor the invented exercise establishes extraction compatibility.

Keep any unresolved row out of a claimed complete reconciliation. A visually plausible table and an equal closing total can still hide offsetting errors. After the checks, import the actual CSV in Excel as described below, inspect the preview and save XLSX from Excel if a workbook is needed. LocalExtract does not export XLSX directly.

Choose dates and amounts, then inspect the Excel import

For a deposit cash account, use positive inflows and negative outflows after reading the original's actual convention. Keep another needed date, currency and source reference in additional private worksheet columns; the three-field CSV does not encode them automatically. One entirely invented comma-delimited example is:

date,description,amount
2026-09-01,Example receipt,250.00
2026-09-02,"Example purchase, supplies",-100.00
2026-09-03,Example fee,-10.00

These are chosen learning fields, not the bank's native headers or a tested statement layout. The comma in a description is protected by quotes, consistent with RFC4180. In Excel use Data → From Text/CSV, inspect delimiter, date types, decimal amounts and signs, then load. Microsoft's import help explains the preview. Save XLSX in Excel after checking.

When the source supplies comparable endpoints for the same complete account/currency/interval, compare opening plus signed movements with closing. A filtered subset, loaded fragment or different interval cannot be reconciled as that complete cycle. Without comparable balances, record that limit and check every row; an equal net total cannot prove each date or description.

Check the method with invented records

We recomputed three deliberately constructed cases on October 11, 2026 using decimal arithmetic: complete rows, an omitted fee and a duplicated movement. The reference total and every number are invented. This checks the reconciliation method only: no bank account, real PDF, OCR result or LocalExtract output was tested. The same learning aid is used across these guides.

Illustrative units, not a real account balance.

Download the blank document checklist or synthetic check data. CSV · JSON.

Frequently Asked Questions

Can I add SGD and USD amounts directly?

No. Keep account and currency context separate; do not invent an exchange rate.

Is an eAdvice the whole cycle?

No. Use its actual purpose and preserve the issued statement when that is the required source.

Is personal CSV availability disproved?

No. It was not established by these sources; inspect a suitable file if your service offers it.

Was this bank format tested with LocalExtract?

No. The invented exercise and public help are not a compatibility test.

If PDF is the relevant source

LocalExtract processes one PDF at a time on the device and exports CSV with date,description,amount. Parsing and OCR do not require uploading the statement. This is a working table that needs comparison with the original; no bank compatibility was validated here. There is no direct XLSX, QBO or OFX export, bulk queue or automatic accounting sync. To obtain XLSX, import the checked CSV and save from Excel.

The free evaluation covers ten pages in total. Pro is USD 10/month or USD 60/year. Account, subscription, update and periodic Pro checks need network access. See downloads and product scope.

Sources and verification scope

Public official guidance checked October 11, 2026. Account controls, document availability and bank layouts were not authenticated-tested. The method exercises use invented records, not actual bank samples or measured extraction results.

• Bank guidance 1
• Bank guidance 2

Updated October 11, 2026: Added task-specific source decisions, date/amount examples and CSV import checks. No bank format or app output was validated.

Keep the source task and product conditions explicit, preserve the original and leave missing records or rows unresolved. Check the actual file before using it.

For the next task, see the same bank’s document collection guide.