Convert Standard Bank PDF bank statement to Sage Pastel

Standard Bank of South Africa provides statements for personal and business accounts in South African rand. The reviewed statements include printed business current account statements, an online banking transaction history and a branch-printed copy, each with its own layout and number format.

Countries: South Africa
Supported statement formats: PDF
Supported destinations: QuickBooks Online, Xero, Sage Pastel, CSV/Excel

Standard Bank PDF statement details

The following details were checked against Standard Bank of South Africa statements from 2019 to 2026: printed business current account statements, a transaction history exported from online banking, and a branch-printed "Computer Generated Copy" that arrived as a photo. Standard Bank uses three different layouts with three different number formats, so identify the layout first and always reconcile the converted transactions to the running balance.

Three layouts, three number formats

• Printed statement (Business Current Account, BizLaunch and similar). Columns are Details, Service Fee, Debits, Credits, Date and Balance. Numbers use a point for thousands and a comma for decimals, with a trailing minus on debits: 2.741,39-. Credits have no sign. Dates are month and day only, 02 22, with the year in the "Statement from 22 February 2019 to 20 March 2019" line.
• Online banking transaction history. Columns are Date, Reference, In (R), Out (R), Bank fees (R) and Balance (R). Numbers use a space for thousands and a comma for decimals, with a leading sign on every amount: -47 899,03, +4 645,00. Dates are full, 11 Mar 2026. Rows run newest first.
• Computer Generated Copy printed at a branch. Columns are Details, Service Fee, Debit, Credit, Date and Balance. Numbers use a comma for thousands and a point for decimals, with a leading minus on debits: -18,000.00. Dates are 20260401, year, month and day with no separators. Every amount column is printed on every row, so a debit row also shows 0.00 under Credit and Service Fee.

A converter that assumes one number format reads the other two as garbage. The safe rule is to detect the decimal mark from the balance column of the same statement, because the balance always has exactly two decimals.

Settings for a Standard Bank PDF statement

• Date: printed statements show MM DD, month first, even though South Africa writes dates day first everywhere else. Take the year from the statement period line. Online history shows full dates. Branch copies show YYYYMMDD. A statement period such as 15 October to 14 November crosses a month boundary on every statement and crosses the year in December.
• Amount: one of the three formats above. Debit and credit sit in separate columns on printed and branch statements, and the sign is repeated as a trailing or leading minus. Online history puts money in and money out in separate columns with an explicit sign on each.
• Balance: a negative balance is printed with the same trailing minus, 5.062,15-. Treat it as a sign, not as a formatting mark.
• Account number: printed statements show it with spaces, 28 072 181 1. Online history shows it with leading zeros, 0000010155497063. Strip the spaces and keep the zeros, or a file for the same account will not match a previous import.
• Account type and currency: "BUSINESS CURRENT ACCOUNT" or "Current Account" is checking. Amounts are rand; the R appears only on summary lines such as Month-end Balance R54.041,96.

The fee column is not part of the transaction

Printed statements carry a Service Fee column next to each transaction: 7,95 beside an internet banking payment, 4,20 beside a card purchase. That fee is not deducted on that row. The balance moves by the debit alone, and the fees are charged later as one line, for example "BUSINESS ELECT BANK CHARGES". A converter that adds the fee to the debit, or writes it as a second transaction, breaks the running balance on every row and doubles the fees at month end.

The same column also shows ## on rows that are themselves fees ("DEBIT CARD PURCHASE FEE", "FEE-UNPAID ITEM"). ## is a footnote marker meaning "These fees include VAT", printed at the bottom of the page. It is not an amount.

Every transaction takes two lines

The first line holds the bank's transaction type and a reference number, CHEQUE CARD PURCHASE 9111, and carries the amounts, the date and the balance. The second line holds the part a bookkeeper actually wants, WIMPY BEACON B4278193441714771 or KTM BAILEY RENT, and carries nothing else. A converter must attach the second line to the row above it, and should prefer it as the payee, because the first line is the same text for hundreds of rows.

The second line often has a card number or terminal reference glued to the merchant name, PNP CRP SAVANN4278193342568656, and a time stamp glued to it as well, ENGEN BEACON H13H52, NANDOS CAVENDI20H05. Those need to be split off before the payee is usable for matching.

On the online banking layout the reference wraps differently: one part is printed above the row that holds the date and amount, one part on that row, and the rest below it. Grouping strictly by vertical position assigns the top part to the previous transaction. The row with the date and amount is the anchor, and the reference lines above and below it belong to it.

Amounts hidden inside descriptions

Descriptions carry amounts that are not transactions. A declined card row reads 032310749 22/10 11H51 695,00, where 695,00 is the amount that was declined. An immediate payment fee reads 032310749 17H34 R 25039.80#122, with the paid amount in yet another format. A foreign transaction reads INTGBP2.05at21.7339, the currency amount and the exchange rate. None of these are in the amount columns, and a converter that scans text for numbers picks them up as transactions.

Rows that are not transactions

• BALANCE BROUGHT FORWARD opens every page with a balance and, on the first page, a date. It is the opening balance, not a transaction.
• Month-end Balance on the first page is a summary figure and does not match the balance brought forward.
• OUTSTANDING CARD AUTHORISATION rows on the online history are pending card holds. They are included in the available balance shown there but have not posted. Including them means the file will not reconcile to the next month's opening balance.
• RTD-NOT PROVIDED FOR rows are returned debit orders that reverse an earlier row. Both rows are real and must both be kept.
• The page header repeats the branch address block twice, the customer address, the statement period and "Page 1 of 10" on every page, and the footer repeats the bank's registration text. Detect them by position, not by content.

Order and reconciliation

Printed and branch statements run oldest first. The online history runs newest first, so the balance column reads backwards down the page and a converter must reverse the rows before writing a file that other software expects in date order.

The running balance is on every row in all three layouts. Check that each debit or credit moves the previous balance to the printed one. That check catches a missed trailing minus, a fee wrongly added to a debit, and every OCR error on a scanned or photographed copy.

Scanned and photographed copies

Branch copies and older statements often arrive as photos. OCR splits a balance such as 571,999.44 into two elements, 571 and ,999.44, reads the Debit header as noise, and shifts columns on a skewed page. The explicit 0.00 in unused amount columns on branch copies helps here: a row with three amount cells is complete, a row with two has lost one. Reconcile every row against the balance before trusting a scan.

PDF input challenges

A bank PDF can contain searchable text, scanned page images, or a mixture of both. Searchable text still needs layout analysis because transaction descriptions wrap, columns move, and headers or balances repeat at page breaks. A scanned statement adds OCR uncertainty.

Page breaks

A transaction may begin at the bottom of one page and continue on the next. Continuation pages can omit column headings, repeat an opening balance, or insert footer text and legal pages between transaction pages. A conversion should join split rows and exclude repeated page furniture before it writes the output.

OCR

On scanned pages, OCR can turn 0 into O, 1 into l, or 5 into S. It can also lose a minus sign or decimal mark, read two columns in the wrong order, or struggle with skewed and faint pages. The running balance is the best check: a damaged amount or missing row breaks the balance sequence.

PDF questions

Can I convert a scanned bank statement?

Yes. Review the OCR result and reconcile every balance movement. Scans with faint printing, rotation, or handwritten marks need more checking than searchable PDFs.

Why does copying and pasting a PDF into Excel fail?

PDF text stores page positions rather than a spreadsheet table. Wrapped descriptions, repeated headers, and visually aligned columns can paste in the wrong order or into the wrong cells.

How do I know whether the PDF contains searchable text?

Try selecting a transaction description in a PDF reader. If individual words can be selected, the page probably contains text. If the whole page behaves like one picture, it requires OCR.

Sage Pastel import settings

Sage Pastel, the desktop accounting software common in South Africa (Pastel Partner, Pastel Xpress and Sage 50cloud Pastel), imports bank statements through the Bank Manager module. Bank Manager reads a statement file, matches each line to a ledger account by keywords in the description, and creates cashbook entries. The file formats it reads are OFX and CSV; check the exact list for the installed Pastel version, because Bank Manager is an add-on and its import options have changed between releases.

• OFX is the safer choice. It carries the date, the amount, a description, a reference and a unique transaction ID, and South African banks that offer a Pastel or Bank Manager download usually produce this structure.
• CSV works when the columns match what Bank Manager expects for the chosen bank layout, usually date, description and amount. A file from a different bank layout or with extra columns is refused or misread.

Settings that matter:

• Dates: DD/MM/YYYY, four-digit years. South African statements print day and month only, so the year must be set from the statement period.
• Amounts: signed, money out negative, no currency symbol, comma as thousands separator removed. Statements from FNB and other banks mark credits with Cr and leave debits unsigned; the converter must turn that into a sign before Bank Manager sees it.
• Currency: ZAR.
• Account: the cashbook or bank account in Pastel is selected in Bank Manager during import; the file's account number is for reference.
• Descriptions: Bank Manager's matching runs on keywords in the description. Keep the payee reference, such as Rent - Unit 13, in the description field, because that is what the mapping rules will key on next month.
• Transaction IDs: unique per row, so a re-import of the same period does not create the same cashbook entries twice.

Sage Business Cloud Accounting, the online product, imports OFX and CSV through Banking with a three-column CSV of date, description and amount, and asks for the date order during upload. The same file settings apply.

Sage Pastel questions

My bank does not offer a Pastel download. What now?

Convert the PDF or CSV statement to OFX and import that through Bank Manager. The result is the same as a bank download.

Why does Bank Manager show every line as unmatched?

Matching runs on keywords in the description. A converted file whose descriptions are truncated or replaced by the bank's transaction code gives the rules nothing to match. Keep the full description and the customer reference in the file.

Why are all amounts reversed?

The statement marks credits with Cr and prints debits without a sign. If the converter did not turn that into a minus on debits, money out appears as money in. Reconcile the first import to the statement closing balance before mapping anything.

Can I import an older period?

Yes. Bank Manager accepts any date range in the file. Import periods in order and do not overlap them, because it does not check for duplicates across files.

Does this apply to Sage Business Cloud Accounting?

Mostly. The online product imports OFX and a three-column CSV through Banking rather than through Bank Manager, and asks for the date order during upload. The file settings above are the same.