Bank statement converter

Convert a Standard Bank statement to Excel or CSV

Download the statement from Online Banking or the app, open it with your ID number if asked, save an unlocked copy and upload it. The converter reads both the personal layout and the business layout, where debits are printed with a trailing minus.

We are an independent South African site and are not affiliated with, or endorsed by, Standard Bank. The name is used only to say whose statements this page covers.

Standard Bank uses two quite different statement layouts. Personal statements split payments and deposits into separate columns. Business statements stack their column headings over three rows and print debits with the minus sign after the number, as in 18.87-, which a spreadsheet reads as text.

The converter handles both and gives you one row per transaction with a normal signed amount. Below is where to get a statement that converts cleanly, what the converter does with each layout, and how to check the result before you use it.

How to convert a Standard Bank statement

  1. On the Standard Bank app, select the account, scroll to Your documents and tap View & Save, then choose the 6-Month statement or a single month under Previous statements. Online Banking also has statements, going back 24 months.
  2. If the PDF asks for a password, it is your ID number. Open it and save an unlocked copy, because the converter cannot read a locked file.
  3. Sign in to Payslip Generator with a free account and open the bank statement converter.
  4. Upload the PDF. Each page counts once against your free pages for the month.
  5. Check the preview: the number of transactions, the money in and money out totals, and the balance on the last row.
  6. Choose the export you need, such as Excel, CSV, or a file for Xero, QuickBooks or Sage, and download it.

Personal and business layouts

On a personal statement, payments and deposits sit in separate columns. The converter merges them into one amount column: a deposit stays positive and a payment becomes negative.

A business statement is harder to read by machine. Its headings, such as Details, Service Fee, Debits, Credits, Date and Balance, are spread over three stacked rows, and a debit is printed with a trailing minus. The converter reads the stacked headings as one header row and moves the minus to the front, so 18.87- becomes -18.87 and adds up like any other number.

How Standard Bank amounts come out of the converter
On the statementLayoutIn the exported file
Amount in the Deposits columnPersonalPositive amount
Amount in the Payments columnPersonalNegative amount
1,250.00 in the Credits columnBusiness1250.00
18.87-Business-18.87

Add the net figure shown above the preview to the opening balance on the statement. If you arrive at the closing balance, every sign came through correctly.

The ID number password

Standard Bank says its eStatements only ask for your ID number to open. That also gives you a quick safety check: a "statement" that asks for your Internet Banking password, or your email address and password, is a phishing email, and Standard Bank says it will never ask for those.

Opening the PDF with your ID number is not enough for an upload, because the file itself is still locked. Print it to a new PDF, using Save as PDF on a Mac or in a browser, or Microsoft Print to PDF on Windows, and upload the new file.

The 6-month app statement and the 20-page limit

The Banking App generates a 6-month statement by default, with single months listed further down the same screen under Previous statements. For a quiet account, the 6-month PDF converts in one go.

A single upload can be up to 20 pages, and six months of a busy account, especially a business account, can run longer than that. If it does, download the monthly statements instead and convert them one at a time. The exported files can be pasted one under another.

  • Online Banking: statements going back 24 months.
  • Banking App: a 6-month statement plus previous monthly statements.
  • ATM: prints up to six months, but on paper, which cannot be converted. Use a digital channel instead.

Uploading a CSV instead

If you have your Standard Bank transactions as a CSV, upload it directly. The converter recognises Standard Bank's year-first dates, such as 2026/03/31, and turns them into a single date format in the export.

A CSV is read in your browser, does not need an account and counts as one page however long it is. When the figures must match an official statement, convert the PDF.

Before you upload

  • A free account converts 5 pages a month. Each PDF page counts as one, and a CSV counts as one however long it is. After that you can buy credits, and Premium subscribers convert without a monthly page limit.
  • One PDF upload can be up to 20 pages and 8 MB. Split anything longer by month.
  • The PDF must have selectable text. A scanned or photographed statement has none, so download the digital version from online banking instead.
  • Password-protected PDFs have to be unlocked first. Our guide to password-protected bank statements shows how.
  • Where a statement prints dates without the year, the converter takes the year from the statement period. If a statement runs from December into January, check those dates in the preview.
  • A PDF is read in memory over an encrypted connection and is not saved. A CSV never leaves your browser.

Frequently asked questions

What is the password on a Standard Bank statement PDF?

Your ID number. Standard Bank says its eStatements only ask for that, and will never ask for your Internet Banking password to open a statement.

Does the converter read Standard Bank business statements?

Yes. It reads the stacked column headings on business statements and turns trailing-minus debits such as 18.87- into normal negative numbers.

Can I convert a Standard Bank statement to Excel for free?

Yes. A free account converts 5 pages a month. After that you can buy credits, and Premium subscribers convert without a monthly page limit.

My 6-month statement is too long to upload. What now?

Download the previous monthly statements from the same screen in the app and convert them one at a time. A single upload can be up to 20 pages.

Is my Standard Bank statement stored when I convert it?

No. A PDF is sent over an encrypted connection, read in memory, and the transactions are sent back to your browser. The file itself is not saved.

General information, last checked on 2026-10-18. Banks set their own menus, fees and passwords and can change them without notice, so confirm anything that matters with your bank directly.