If your operating cash or client funds sit at UBS and you run your books in Xero, there is one monthly workflow worth getting exactly right: learning to import UBS bank statement PDF to Xero cleanly without retyping a single line. UBS Digital Banking produces clean monthly statements, but a PDF cannot go straight into Xero — and hand-keying dozens of transactions, advisory fees, and inter-account transfers is slow, tedious, and exactly where costly typos creep in. The reliable path is simple: download the statement PDF, convert it to a Xero-ready CSV, import it through Xero's bank account import, and set up bank rules so recurring items categorize themselves from then on. This guide walks US-based financial advisors, family offices, and small businesses through every step.
Why UBS accounts deserve a deliberate Xero workflow
UBS is best known as a global wealth-management bank, and its US clients rarely hold just one plain checking account. A typical setup mixes an operating account with savings, and sometimes a business account under the same login — and the monthly statements reflect that mix: everyday card and ACH activity next to advisory or management fees, periodic transfers between your own accounts, and the occasional wire. That blend is what makes manual entry so painful: the same statement demands three different kinds of judgment, line by line.
Xero does offer direct bank feeds for many institutions, but feed coverage is never guaranteed for every account type at every bank — and feeds can lag or drop transactions. A monthly CSV import is the dependable fallback: it is deterministic, it is auditable, and it gives you the exact statement period you are reconciling against. Build the habit once, and month-end stops depending on your bank's feed status.
Step 1: Download your UBS statement as a PDF
Start in UBS Digital Banking. Sign in, open your account, and look for the statements or documents section — UBS archives several years of statements, so you can pull back months if you need to catch up.
- Select the account you reconcile in Xero. If you hold both personal and business accounts at UBS, be careful to download the right one — mixing them is a classic month-end mistake.
- Choose the statement period that matches the month you are closing. UBS statements can straddle calendar months, so check the period dates before you download.
- Download as PDF and save it with a clear name, for example UBS-operating-2026-09.pdf. Keep one folder per tax year.
If the PDF is password-protected, note the password — a good converter accepts it at upload time and unlocks the file in memory purely to read the transaction tables. The password is never stored. For UBS-specific conversion notes, see our UBS bank page.
Step 2: Convert the PDF into a Xero-ready CSV
Xero's statement import reads CSV, OFX, and QIF — not PDF. This is the conversion step: upload your UBS PDF to Convert Statement in your browser (nothing to install) and choose CSV as the output. The tool reads the statement's table structure — dates, descriptions, debits, credits, running balances — and reproduces it as clean spreadsheet rows. Your first 8 pages are free, which covers a typical monthly UBS statement.
Before you import, spend sixty seconds verifying the output. Compare the opening and closing balances in the CSV against the PDF — if they match, every row between them converted correctly. Also scan for multi-line descriptions: UBS statements sometimes wrap long payee names across two lines, and while a good converter stitches them back together, a quick glance at the first and last few rows catches anything odd. Our guide to converting bank statements to CSV explains the format details if you want the full picture.
Step 3: Import the statement into Xero
With the CSV in hand, open Xero and go to Accounting > Bank accounts. Find the account that matches your UBS statement — if you have not created it yet, add it now with the account name and number from the statement. Then click Manage account > Import a statement and upload your CSV.
Xero asks you to map the columns: Date, Description (or Details), and Amount. The converted CSV already uses these conventions, so mapping takes seconds. Double-check the date format Xero detected — US statements use month/day/year, and a mismatch here scrambles every date in the import. Xero shows a preview before committing; review the first few rows, confirm the totals look right, then import. The same import flow applies across banks — we have covered it for NatWest and Standard Chartered if you juggle multiple institutions.
Step 4: Teach Xero your recurring activity with bank rules
Freshly imported transactions land in Xero's bank account tab marked "For review." This is where bank rules turn a monthly chore into a one-time setup. A bank rule tells Xero: whenever a transaction matches these conditions, categorize it automatically.
UBS statements are ideal candidates because so much of the activity repeats:
- Advisory and management fees: create a rule matching the fee description keywords and posting to your professional-fees or investment-expenses account. One rule, and every month's fee categorizes itself.
- Transfers between your own UBS accounts: this is the critical one. Create these as Transfer rules pointing at the destination bank account in Xero — not as spend or receive money. Recording a transfer as an expense double-counts it and wrecks your P&L.
- Recurring operating items: software subscriptions, office rent, payroll transfers — match on payee keywords and post to the right accounts.
Test each rule against the current import first: Xero shows how many transactions it would match before you save it. Once saved, future imports categorize themselves, and reconciliation becomes a matching exercise instead of a data-entry one.
Run a clean month-end reconciliation
With categorized transactions in Xero, reconciliation is a comparison against the statement — the source of truth. Work through the imported lines, matching each to its bank line; fees and transfers your rules already handled should match instantly. Investigate anything left over: an uncleared check, a deposit in transit, or a transaction dated in the wrong month accounts for most differences. For service businesses and advisory practices, a monthly rhythm matters more than speed — clean, reconciled books keep fee income and deductible expenses audit-ready and make quarterly estimated-tax calculations straightforward. Our bank statement reconciliation walkthrough covers the full checklist, and accountants handling multiple clients can standardize on the accountant's reconciliation guide.
Frequently asked questions
Can I import a UBS statement PDF into Xero directly?
No — Xero's statement import accepts CSV, OFX, and QIF, not PDF. Convert the PDF to CSV first (free for your first 8 pages), then use Manage account > Import a statement. The whole round trip takes a few minutes.
My UBS statement has hundreds of small transactions. Will Xero cope?
Easily. Xero imports large CSVs without complaint, and bank rules do the heavy lifting on categorization. Convert the statement in one go, import it, then let rules match the recurring items — you only touch the exceptions.
How do I stop transfers between my UBS accounts from double-counting?
In Xero, record them as transfers, not as spend or receive transactions. A bank rule with the "Transfer money" type pointed at the destination account handles this automatically on every import.
Is it safe to upload my UBS statement to an online converter?
Conversion happens in your browser: the file is read in memory and deleted immediately after, with nothing stored on a server. Still, practice good hygiene — work on a private device and treat the CSV with the same care as the original PDF.
Stop retyping UBS statements. Convert your UBS statement PDF to a Xero-ready CSV — free for your first 8 pages — import it into Xero in minutes, set your bank rules once, and close every month with clean, reconciled books.