← Back to Blog PDF STATEMENT CONVERTER Try Converter

· By PDF Statement Converter Team

How to Convert Standard Bank Statements to CSV

Convert Standard Bank PDF statements into import-ready CSV for Sage, Xero, QuickBooks and Pastel — with the Standard Bank quirks (two date columns, long references) that break imports.

Standard Bank carries some of the highest business banking volumes in South Africa, so if you do bookkeeping for SMEs you're handling Standard Bank statements constantly — often multiple accounts for the same client. And of all the major banks, Standard Bank statements have a few layout quirks that make a clean import into Sage, Xero, QuickBooks, or Pastel harder than it should be.

Here's how to convert a Standard Bank PDF statement into a properly formatted CSV, and what to watch for along the way.

Why Standard Bank statements are tricky to import

Standard Bank statements carry more structural complexity than most:

  • Two date columns. Standard Bank often shows both a transaction date and a separate posted/value date. Accounting software wants one date, so the wrong column being used (or both being imported) causes mismatches.

  • Long reference numbers. Standard Bank reference fields can be longer than some accounting packages accept, which leads to truncated or rejected entries on import.

  • Description formatting. Transaction descriptions can wrap or break across the PDF, so a naive extraction splits a single transaction into fragments.

  • Multiple accounts. Business clients frequently have several Standard Bank accounts, and statements need to be kept cleanly separated per account during conversion.

  • Balance and date-format issues. As with every SA bank, the running balance usually has to be removed and the date format adjusted to match your accounting software.

    • Manually, that means copying transactions into Excel, deciding which date column to keep, trimming references, repairing split descriptions, and reformatting dates — easily a couple of hours per statement, with plenty of room for error.

    Step 1: Download your Standard Bank statement as a PDF

  • Log in to Standard Bank internet banking or the banking app.

  • Select the relevant account (a business client may have several — do these one at a time).

  • Open Statements or Documents.

  • Choose the date range required for the bookkeeping period.

  • Save the complete statement as a PDF.

    • Download the full statement for the period, not a filtered view — you need every transaction, including bank charges, to reconcile to the closing balance.

    Step 2: Convert the PDF to CSV

    Upload the PDF to PDF Statement Converter instead of rebuilding it by hand. It detects the Standard Bank layout and handles the quirks above automatically:

  • Upload your Standard Bank PDF.

  • The converter extracts each transaction, selecting the correct date and keeping descriptions intact.

  • It outputs a CSV with a single signed amount column, references handled cleanly, and no stray balance column.

  • Download the CSV, ready to import.

    • Your first conversion is free, so you can confirm the dates and references came across correctly before you rely on it.

    Step 3: Import into your accounting software

  • Sage / Sage Pastel: Use the import or bank-feed function, map the columns, and confirm the date format matches your company settings (this matters most with Standard Bank's dual dates).

  • Xero: Use "Import a Statement" on the bank account and map date, description, and amount.

  • QuickBooks: Upload via the import bank transactions flow.

    • Then verify:

  • Opening and closing balances match the statement.

  • The transaction count is correct.

  • No entries were rejected for over-long references.

    • Standard Bank-specific things to watch

  • Pick the right date. Decide whether you want the transaction date or the posted date and be consistent — mixing them across months makes reconciliation drift.

  • Keep accounts separate. For multi-account business clients, convert and import each account individually so transfers between them are obvious.

  • Check references after import. If your software truncates long references, you may need to rely on descriptions instead for matching — confirm this on the first import.

    • The bottom line

    Standard Bank's dual date columns, long references, and multi-account business setups make manual conversion especially error-prone. An automated converter resolves those quirks in seconds and gives you a CSV that imports cleanly into Sage, Xero, QuickBooks, or Pastel — freeing the hours you'd otherwise lose to reformatting.

    Ready to convert your Standard Bank statements? Try PDF Statement Converter and convert your first statement free.

    ---

    Related Articles

  • How to Import FNB Statements into Sage One

  • Sage Import Troubleshooting Guide

  • Why Converting SA Bank Statements to Excel Doesn't Work for Sage