Bank Statement to Excel: How to Convert South African Bank Statements

Why businesses convert bank statements

A PDF statement is fine for proof of payment, but useless for analysis. Once transactions are in a spreadsheet you can sort, filter, total and categorise them. That is the starting point for bookkeeping, VAT preparation, management accounts and funding applications.

• Categorise income and expenses for a profit and loss
• Total monthly money in and out for a cash-flow view
• Find duplicate debit orders and forgotten subscriptions
• Give your bookkeeper data they can import, not a stack of PDFs
• Prepare supporting figures for a loan or tender

CSV vs PDF vs Excel

Getting a download from your bank

Most major South African banks, including FNB, Absa, Standard Bank, Nedbank, Capitec and TymeBank, let you download transaction history or statements from internet banking or the app. Export options and the number of months available change over time and differ between personal and business profiles, so check your bank's help pages for current steps. Where a CSV export exists, use it.

Understanding transaction descriptions

Bank descriptions are short and cryptic: card purchase codes, debit order references, "FNB App Payment To", merchant names cut off at 20 characters. Before you can categorise, you need to recognise who each payment was to. Building a small lookup of regular payees (your landlord, fuel stations, suppliers) speeds this up every month.

Categories that make the data useful

• Sales or income from customers
• Cost of sales: stock, raw materials, direct subcontractors
• Rent, utilities, data and phone
• Salaries and wages
• Fuel and vehicle costs
• Bank charges and interest
• SARS payments (VAT, PAYE, provisional tax)
• Loans received and repayments
• Owner drawings and owner deposits
• Transfers between your own accounts

The last four are the most important to separate. Loans, owner money and internal transfers move cash but are not income or expenses. Counting them inflates both sides of your profit and loss.

Common formatting issues

• Dates like 03/04 read as 3 April or 4 March depending on settings
• Amounts with spaces (R 1 250,00) or commas as decimals that Excel reads as text
• Debits and credits in one column with a minus sign, or two separate columns
• Transactions split over two lines in the PDF, creating half-rows
• Page headers and running balances mixed into the table
• Overlapping statements creating duplicate transactions

Scanned PDFs and photos

A scan is an image, so software has to recognise the characters first. Clear, straight, well-lit pages work best. Always compare the converted totals with the statement's opening and closing balance, because a misread digit can change a R1,800 payment into R7,800.

Password-protected statements

Banks often email statements locked with a password, commonly based on your ID number. Open the file with the password and save or print it as a new PDF before uploading. Do not share your banking password with anyone, including a converter tool.

Checking data quality

Why structured data helps your bookkeeping

Clean, categorised transactions are the raw material for everything else: monthly management accounts, a cash flow statement, and the financial section of a funding or tender application. Your accountant spends less time capturing and more time advising.

Security considerations

• Bank statements contain personal information protected by POPIA. Use services that store files privately and explain how long they keep them.
• Never upload statements to random free websites without knowing who runs them.
• Delete local copies you no longer need, especially on shared computers.