Convert a Co-operative Bank Statement to Excel

Co-operative Bank statement structure, the charity and community account variations, and verifying your export.

The Co-operative Bank has a large share of UK charity, community group and small society accounts, which shapes what its statements are typically used for.

Charity and community accounts have different reporting needs

A treasurer preparing accounts for a small charity needs something specific: every transaction, categorised by fund or activity, reconciled to the penny, and defensible to an independent examiner.

That last part matters. A charity's accounts may be examined, and "the converter gave me this spreadsheet" is not an adequate answer to a question about a missing transaction.

Reconciling to the penny

Charity reconciliation is unforgiving — the accounts have to balance exactly. That makes the verification step more valuable here than almost anywhere else.

Convert the statement Export to Excel, which includes the Completeness sheet with the checks.
Confirm it reconciles before anything else Opening balance, plus credits, minus debits, equals closing balance, and totals match the printed figures.
Categorise by fund or activity Add a column; a partial-match lookup on the description makes categorisation practical.
Cross-check against the cash book The reference column is what you match on for cheques and standing orders.
File the PDF with the working papers Alongside the export, as the source record.

Multiple signatories

Community accounts often require dual authorisation, and some Co-operative Bank layouts note the authorising parties on transactions. Where present, that is worth preserving — it is exactly the kind of detail an examiner may ask about.

Restricted and unrestricted funds

Charity accounting distinguishes restricted funds — given for a specific purpose — from unrestricted general funds. That distinction does not exist on the bank statement; it is knowledge the treasurer holds.

Adding a fund column to the converted spreadsheet is how that knowledge gets recorded against the transactions. Done at the time, it is straightforward; reconstructed a year later from memory, it is guesswork.

What an examiner will ask about

Whether every bank transaction is accounted for — which is what the reconciliation proves
Whether restricted funds were spent on their stated purpose
Whether large or unusual transactions have supporting documentation
Whether the closing balance agrees with the bank's own statement

The first and last are answered by the verification step. The middle two need the fund column and your records.

Frequently asked questions

Is this suitable for charity accounts?

The conversion and verification are; the accounting judgement is yours. Keep the original PDF as the source record.

Should I record fund allocation in the spreadsheet?

Yes, as its own column, at the time. It cannot be derived from the bank data and is difficult to reconstruct later.

Are Smile accounts supported?

Yes — Smile is part of the Co-operative Bank and uses a related layout.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.