How to Convert a Co-operative Bank PDF Statement to CSV or Excel
The Co-op does give you a CSV. The trouble is what else is in the file.
The CSV exists. Importing it is the problem.
The Co-operative Bank does let you download transactions as a CSV, though the option is not where most people look. In Online Banking choose Search Transactions in the left-hand menu, pick one account, set a date range, select Apply Search, then Download at the top right and choose CSV.
The columns come out as date, description, type, money in, money out and balance. So far so good.
Why imports fail: the file carries lines that are not transactions, such as a "List of transactions" title above the column headers and a footer with the date and time it was produced. Accounting software expecting a header row and then data rejects it, and users of more than one package report having to open the file in a text editor and delete those lines first. Business banking adds a second CSV layout, so a fix that works for one account may not work for another.
If you are doing this for one account once, editing the CSV is fine. Across a year of statements, several accounts or several clients, the cleanup becomes the job.
Quick answer: The Co-operative Bank offers a CSV download under Search Transactions, but the file includes header and footer lines that many accounting imports reject, and business banking uses a second layout. Converting the PDF statements gives one clean, consistent CSV that imports first time.
When converting the PDF is quicker
- A year or more of history, where one consistent file beats a stack of downloads each needing the same cleanup.
- Statements a client has sent you as PDFs, which is how most year-end work arrives.
- smile accounts, the Co-op's online-only brand, whose statements convert the same way.
HMRC sets the floor for how long the records have to survive. A sole trader keeps them for at least five years after the 31 January filing deadline for the tax year, so a year's records can need keeping for nearly seven years. A limited company keeps them for six years from the end of the financial year they relate to. When the request comes, the PDF statements are usually what you have to hand.
Where each route stops
| Route | Formats | How far back |
|---|---|---|
| Online Banking: Search Transactions | CSV | One account per download, chosen date range |
| Statements | Each statement period | |
| Business banking | CSV, a different layout | Check before importing |
The Co-op does not document the extra lines in its CSV. They are reported by people importing the file into accounting software, which is the useful test.
Converting the statements (4 steps)
- Download the PDF statements from Co-operative Bank
Sign in to Online Banking and download the PDF statements for the months you need, or gather the PDFs your client has sent. - Open the converter
Register free at reconcileiq.com/bank-statement-converter, then open Bank Reconciler and the PDF converter inside it. - Upload the statements together
Drag in several months at once. Each statement is read on its own and the transactions come back as one continuous set, so there is no stitching files together afterwards. - Check the output, then download
The extracted transactions appear on screen before you download anything. Check the first and last rows against each statement's opening and closing balance, then export as CSV.
Always check the balances: every Co-operative Bank statement prints an opening and a closing balance. If the converted rows carry you from one to the other, nothing was missed. It takes ten seconds and it is the only real proof of completeness, from any tool, including this one.
What comes out
A Co-operative Bank statement converts to plain rows of date, description, one signed amount and the running balance: no title lines, no footer, and the same layout whether the statement came from a personal, business or smile account.
Page furniture is discarded: repeated column headers, page numbers, summary boxes and the small print on the last page. What you get is transactions and nothing else.
Convert Your Co-operative Bank Statement
Upload the PDF, check the numbers on screen, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Yes. In Online Banking choose Search Transactions, select one account and a date range, select Apply Search, then Download and choose CSV.
The file includes lines that are not transactions, such as a title above the column headers and a footer with the date and time it was produced. Many imports expect only a header row and data. Delete those lines, or convert the PDF statement instead.
Yes. smile is the Co-operative Bank's online brand, and its PDF statements convert the same way as Co-op ones.
Yes. Business current accounts convert, and because the converter reads the statement itself, the output has the same columns whichever CSV layout the account would have exported.
Your first statement of up to 10 pages converts free on a new account. Beyond that it runs on credits, and the cost per conversion is shown before anything is processed. Files are processed on our servers rather than in your browser, which is what lets scanned and photographed statements work as well as native PDFs.