Convert a bank statement photo to Excel
You can convert a photo of a bank statement to Excel by uploading the image to statement.work, which reads the transactions from the picture and returns them as rows with date, description, amount and running balance. A flat, well-lit, straight-on photo gives the best result.
When a photo is all you have
Photos are how a lot of statements arrive in practice: a client snaps the paper statement on the kitchen table, or a small business owner photographs last year’s statements from a folder. There’s no text in a photo to copy, so the usual answer is to retype it. statement.work reads the image instead, using the same statement-aware extraction it uses for scans and PDFs.
How to take a photo that converts well
The quality of the photo decides the quality of the result. Five habits make the biggest difference:
- Lay the page flat on a dark, plain surface. Curled pages bend the rows.
- Shoot straight down, with the phone parallel to the paper. Angled shots squeeze one side of the page.
- Use even light. Daylight from a window works well. Avoid the flash, which causes glare on glossy paper, and keep your shadow off the page.
- Fill the frame with one page, edge to edge, including the header with the statement period and the balances.
- Hold steady and check focus before moving on. Zoom in on the photo and make sure small digits are sharp.
If your phone’s camera or notes app has a document-scanning mode, it will usually straighten and crop the page for you, which helps.
Converting the photos
- Upload the photos to statement.work, one image per page, in order.
- statement.work extracts each transaction: date, description, amount, running balance and a category.
- Review the result and export to Excel or CSV.
Checking a photo conversion
Photos vary more than PDFs, so a quick check is worth it:
- Balances: opening balance plus money in minus money out should equal the closing balance.
- Row count: the number of transactions should match the statement.
- Running balance chain: each balance should follow from the previous one. A break points straight at the row to look at.
If a page converts poorly, the fastest fix is usually a better photo of that page rather than manual correction.
Photo, scan or PDF?
If the bank offers PDF statements in online banking, download those: they contain real text and convert most reliably. If you only have paper, a flatbed scan is more consistent than a photo. A photo is the right choice when it’s what you’ve got, and statement.work treats all three the same way and produces the same columns from each.
Who uses photo conversion
Small businesses catching up on paper records, and bookkeepers whose clients send pictures instead of files. Once converted, the data can go to Excel, CSV or JSON like any other statement.
Questions
Can I take a picture of a bank statement and turn it into a spreadsheet?
Yes. statement.work reads phone photos of bank statements and returns the transactions as a spreadsheet you can export to Excel or CSV.
Is a photo as good as a PDF?
A digital PDF from online banking is the most reliable input because the text is already in the file. A clear photo works, but glare, shadows, blur and angled shots make characters harder to read, so check the totals.
Should I send one photo per page?
Yes. Photograph each page separately so it fills the frame, and keep the pages in order so the running balance carries across correctly.