UBS Switzerland Statement to Excel Converter

ClearlyLedger converts UBS Switzerland PDF statements into structured Excel and CSV for Swiss Treuhänder, bookkeepers and SMEs. UBS was itself formed in a 1998 merger of Union Bank of Switzerland and Swiss Bank Corporation, and its 2023 emergency acquisition of Credit Suisse — formerly Switzerland's other globally significant bank — made UBS by far the largest bank in the country.

Last updated 2026-09-03

Why do UBS statements use apostrophes in CHF amounts, and what is a value date?

UBS statements use apostrophe thousands separators for CHF amounts (e.g. 1'234.56) rather than a comma or period, which a generic parser can misread as a decimal point, and value-date fields need preserving alongside the booking date for review.

ClearlyLedger parses the apostrophe separator correctly and keeps both booking and value dates in the export.

Why do UBS statements use German, French or Italian labels?

Column labels can appear in German, French, Italian or English depending on the customer's language setting, so a parser tuned only for English column headers will misread a German- or French-language UBS statement entirely.

The UBS profile detects header language automatically rather than assuming a fixed language across all statements.

Which export should I use for Swiss bookkeeping and MWST review?

Use Excel when reviewing figures for a Treuhänder, annual accounts, or preparing MWST (Swiss VAT) returns. Use CSV for import into Swiss accounting software such as Bexio.

ClearlyLedger's balance verification checks extracted rows against the printed balance before export, helping catch a missing row before bookkeeping starts.

UBS Switzerland source profile used by this guide

Printed statement structure: PDF with Booking date, Value date, Description, Debit, Credit, Balance

Source conventions: DD.MM.YYYY dates, CHF CHF amounts, and 2-20 pages.

UBS observations to sample during review

  • UBS's 2023 emergency acquisition of Credit Suisse, formerly Switzerland's other globally significant bank, made UBS by far the largest bank in the country
  • UBS itself was formed in a 1998 merger of Union Bank of Switzerland and Swiss Bank Corporation — the country's two largest banks combining decades before the 2023 Credit Suisse deal repeated the same pattern of Swiss banking consolidation
  • CHF amounts may use apostrophe thousands separators
  • Multilingual labels appear in German, French, Italian or English
  • Value-date fields and forex rows need preservation for review

These UBS details identify the rows most likely to need inspection after extraction. Review the first and final transaction, each PDF page boundary, and any row affected by the observations above before using the spreadsheet in an accounting import.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

Frequently asked questions

How do I convert a UBS statement to Excel?

Upload the UBS PDF to ClearlyLedger. CHF apostrophe-separated amounts are parsed correctly, the balance is verified, and the statement is exported to Excel.

Can I convert UBS statements to CSV?

Yes. ClearlyLedger exports UBS transactions to CSV with date, description, debit, credit and balance columns for accounting imports.

Does it handle German or French-language statements?

Yes. UBS statements in German, French, Italian or English are all detected automatically rather than requiring a fixed language.

Does it work for legacy Credit Suisse account statements?

Legacy Credit Suisse statement layouts, which can still appear in historical PDF packs following the 2023 acquisition, are also supported.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free