Convert a bank statement to Excel

Turn PDF bank statements into a usable spreadsheet

Bank statements arrive as PDFs built for printing, not for analysis. Copy-pasting them into Excel breaks the columns and merges the amounts into the descriptions. Sehnna reads the statement, recognises each transaction line, and rebuilds it as a proper table with one row per transaction.

Columns you get back

• Transaction date, normalised to a real Excel date value.
• Description and counterparty, cleaned of reference noise.
• Debit and credit in separate columns, or a single signed amount.
• Running balance, so you can reconcile against the statement.
• Currency and account reference carried through as metadata.
• Optional category column for bookkeeping and expense reports.

How the conversion works

Upload the statement, tell Sehnna how you want the transactions laid out, and the AI extracts every line into a structured sheet. Because the amounts come back as numbers and the dates as dates, SUMIFS, pivot tables and monthly charts work straight away.

Step by step

• Upload the PDF statement (or a photo or screenshot of it).
• Describe the columns you need — for example separate debit and credit.
• Preview the extracted transactions in the browser.
• Refine with prompts like 'add a category column' or 'group by month'.
• Download as .xlsx or .csv for your accounting software.

What people use it for

• Bookkeeping and monthly expense categorisation.
• Preparing figures for a tax return or an accountant.
• Cash-flow analysis across several months of statements.
• Reconciling invoices against incoming payments.
• Loan or mortgage applications that require an income summary.

Tips for a clean extraction

• Upload the original PDF rather than a printed-and-rescanned copy where possible.
• Convert one account per file so balances stay consistent.
• Say which date format the statement uses if it is ambiguous.
• Ask for a monthly summary tab if you want totals without touching the raw rows.