Convert PKO Bank Polski statements to Excel

How to download PKO BP statements in iPKO and IKO

PKO calls statements wyciągi and delivers them as electronic correspondence. In the iPKO web service:

1. Open Moje produkty (my products) and choose the account.
2. Select Szczegóły → Korespondencja z banku (details → correspondence from the bank).
3. Click Pobierz wyciąg (download statement) and choose the document you need.

Still getting paper statements? Switch to electronic delivery in iPKO under Ustawienia → Korespondencja i powiadomienia (settings → correspondence and notifications), or in the IKO app under Ustawienia → Dane i personalizacja → Moje dane → Korespondencja z banku. PKO describes both paths on its statement help page.

Which formats PKO BP offers (and how far back)

The report limits come from PKO's iPKO biznes file specification: standard reports reach back at most one year, and one download covers at most three months. JPK_WB is the standard file for the Polish tax office. PKO generates it only as .xml with a fixed structure, so it isn't a spreadsheet replacement.

Personal iPKO and IKO users can browse the operation history and save a PDF confirmation (potwierdzenie) for a single transaction. PKO's public help pages don't document a bulk history export for personal accounts, so the PDF wyciąg is the dependable source.

When you still need to convert the PDF

• Business history older than 12 months. Standard iPKO biznes reports stop at one year, so earlier months exist only as PDF wyciągi.
• Statements from clients. Accounting offices usually receive PDFs, not report files. Upload a client's whole year at once and export one combined file. See bank statement conversion for accountants.
• Personal accounts. Without a documented bulk export, monthly PDF statements are the practical way to get a year into a spreadsheet.
• Paper statements and closed accounts. Scans and phone photos (JPG, PNG or WebP) are read like PDFs.
• Credit card statements. These list purchases, fees and the repayment separately. See credit card statements to Excel.
• Files we can't read. If someone sends you JPK_WB, Elixir or Kontakt files, ask for the PDF wyciągi or an MT940 or camt.053 report for the same period.

PKO BP statement quirks

Polish statements follow Polish conventions, which trip up generic PDF-to-Excel tools:

• Amounts use a comma for decimals and a space (or nothing) between thousands: 1 234,56. Pasted into an English-language Excel, they often end up as text. Our export writes real numbers.
• Dates appear as DD.MM.YYYY or YYYY-MM-DD, and a transaction can carry both an operation date and a booking date.
• Long transfer titles (tytuł przelewu) and counterparty details run over several lines per transaction. They're joined into one description, and the payee gets a clean name.
• The VAT account. Polish business accounts come with a linked VAT account (rachunek VAT) for split payments, with its own balance. PKO's file specification even shows separate MT940 reports for it. Treat it as its own account: a PDF that holds several accounts is split into one statement per account.
• Currency accounts (rachunki walutowe) have their own statements in EUR, USD and so on. Each one is balance-checked on its own.

Convert PKO BP statements to Excel, CSV or accounting software

Upload the PDFs, or the MT940 and camt.053 files. Every transaction is extracted with a clean payee and a category. Then the statement is checked: opening balance + credits − debits must equal the closing balance, and the running balance is checked on every row where the statement prints one. Rows that don't add up are flagged with their page number, and a statement that doesn't balance uses no pages.

Then export:

• Excel with real dates and numbers, plus a Summary sheet by category and month
• CSV with semicolons and DD.MM.YYYY dates, the regional format Polish Excel opens cleanly
• QuickBooks Online CSV, Xero CSV, a .qbo file, OFX or QIF if you keep your books in one of those

Already have report files? See MT940 to Excel and camt.053 to Excel. Both import without using pages (you still need a plan or page pack). mBank statements work the same way: see mBank statement to Excel.

Questions