Bank to CSV
Bank statements into a clean spreadsheet.
Turn PDF, scanned or photographed bank statements into a clean, reviewable list of transactions in moments, instead of re-keying them line by line.
Where SMITH’s AI helps
SMITH reads the statement whatever its layout, keeps the real transactions and drops the balance and total rows. You stay in control of the result: every row can be checked and edited before you use it.
Inside your firm’s own controlled AI workspace — previewed, approved and logged.
Included in both the Compliance and Practice Suite plans.
How it works
Upload one statement or several, optionally against a client. SMITH pulls out each transaction into date, description, money in, money out and balance, and leaves out balance and total rows so they don’t pollute the figures.
Long PDFs are split into shorter runs behind the scenes. If one file fails, you retry that file alone, and you’re warned if a document only partly came through. Check and edit every row, then download the CSV, save it to the client’s record and, if you like, file it in the Vault.
What’s included
- Reads PDFs, scans and photos of statements
- Separate money-in and money-out columns, with the balance where the statement shows it
- Edit and check every row before you download
- Several statements at once, with retry for each file
- Warnings when a document only partly came through
- Long statements split automatically
- Year-end context helps settle ambiguous dates
- Saved history on the client’s record
What it can replace
Re-keying statements by hand, and one-off PDF converter websites. It’s also a safer home for client bank data than a free online tool.
How it adds value
- Long statements stop meaning hours of typing: the job becomes checking.
- Paper and PDF-only clients stop being the awkward ones.
- Client statements stay in the firm’s own secure workspace.
Built by accountants
Bank to CSV was built inside a working UK accountancy firm and used on live client work every day before it reached anyone else. It shares the same clients and data as every other SMITH tool, so nothing is typed in twice.
Be first to know when SMITH launches
SMITH is launching soon for UK accountancy firms. Join the waitlist and we'll email you the moment it's ready.