Home › Countries › Switzerland › UBS statement converter

UBS statement converter

Based in Zurich, Switzerland, UBS provides statements to its customers as PDF documents in online banking. Convert UBS statement PDFs to Excel, CSV or an accounting format — with a reconciliation check on every conversion.

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

Convert a UBS statement to…

UBS statement to Excel

For building schedules and workings that cite the statement line by line.

UBS statement to CSV

For moving figures between systems that do not share a native format.

UBS statement to OFX

For moving an account between finance applications without retyping.

Every conversion is checked against the statement itself: where the statement prints opening and closing (or running) balances, the extracted transactions must add up to them, or the conversion is flagged and the mismatched rows are marked. A statement whose layout the reader cannot parse is reported honestly — never passed off as converted.

Every UBS conversion is audited by the document it came from. The extracted transactions are totalled against the printed opening and closing balances and checked row by row against the running balance column where one is printed. A dropped row, a duplicated row or a misread digit breaks the chain and is flagged at the row where it breaks, with the expected and printed balances shown side by side.

Before converting, spend thirty seconds on the UBS document itself: confirm the period matches the month you are closing, note the opening and closing balances, and scan for the period's largest transactions. Second, glance at the statement's own subtotals before converting: section totals for deposits, withdrawals and fees are free checkpoints that tell you where a flagged difference is likely to live.

In Switzerland, bookkeepers commonly work in bexio and Banana Accounting; the Excel and CSV exports from this converter are the files those tools import, and the CSV export is laid out for direct import where the tool accepts it.

Month-end with UBS statements

A workable rhythm: download the month's PDF the day the period closes, convert it, read the reconciliation verdict, then import. Months proven in order chain together — each closing balance becomes the next month's opening — so a difference is always owned by exactly one month.

Which UBS export should you download?

Start from where the numbers go next. Into a spreadsheet for your own work: Excel. Into accounting software: that tool's format — QuickBooks or Xero where offered — because its columns are already in the order the importer wants. Into older desktop software or a personal-finance app: OFX. Into anything else, or into cold storage: CSV, the format least likely to be refused. The transactions are identical in every file; only the packaging differs.

How to download a statement PDF from UBS

  1. Sign in to UBS online banking. Use the bank's website or mobile app and sign in with your usual credentials.
  2. Open the account and find Statements or Documents. Most banks file statements under the account's Documents, Statements or eStatements tab rather than on the summary screen.
  3. Set the period you are converting. Recent periods are usually listed first; older ones may sit behind a date-range search or an archive request.
  4. Download or print to PDF. A downloaded PDF carries the text layer the converter reads. If the portal only offers a print view, print to PDF instead of taking a picture.
  5. Upload and verify. Drop the file into the converter above. Batch mode accepts the whole set of periods in one upload.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Tip: if the bank offers both a statement PDF and a transaction-list PDF, take the statement — it is the one carrying the balances the reconciliation check needs.

Questions and answers

How do I convert a UBS statement to Excel?

Get the PDF from UBS's statements area, upload it here, and download the converted an Excel (.xlsx) workbook. The converter reads the transactions, standardizes the columns and verifies the totals against the statement before the file is ready.

What date and number formats do UBS statements use?

UBS statements generally print dates as the order printed on the statement itself and amounts with the grouping printed on the statement itself. The converter reads the figures as printed and normalizes the output columns the same way for every bank.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

Do I need an account to convert a UBS statement?

No. There is no sign-up: upload the PDF, check the reconciliation result, download the file. Uploaded files and exports are deleted automatically within 15 minutes.

Which file should I upload — the PDF or a portal CSV export?

The statement PDF. It is the issued document and it carries the opening and closing balances the reconciliation check verifies against; a portal CSV has the transactions but nothing to prove them against.

Are amounts converted into another currency?

No. The converter changes layout, not currency: figures stay in CHF exactly as UBS printed them.

Can I convert statements for several UBS accounts?

Yes — convert each account's statements separately so each one reconciles against its own balances, then combine the exports in your software if you need a single view.

What if UBS only offers paper statements?

Scan the statement as flat and straight as you can and upload the scan. OCR reads it, and the reconciliation check verifies the read against the printed balances; rows it cannot verify are flagged for a manual look.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Bank statements in. Clean books out.

Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.

Convert a statement — free