I will convert bank statement PDF to excel, CSV, quickbooks or xero import file
Shopify Payouts and Bank Reconciliation
About this Gig
A converter read 6 months of bank statements and found 421 lines. There were 420.
The bank had printed one page twice. Another page was a crooked scan with no text on it. The file looked fine, but in the books it would have doubled $11,819.63 of deposits and lost $12,687.53. That was a sample project with made-up data, and these are exactly the problems I look for.
Send me your statements as PDF, scans or phone photos. You get one clean file with every transaction on its own row: date, description, amount and balance.
Before I deliver, every line is checked against the running balance, and each month has to tie out to the cent. If a month doesn't add up, I find out why. If a line is unreadable, I mark it and ask you. I don't guess.
What you can get:
- Excel, Google Sheets or CSV
- Categories for your bookkeeping (Standard and Premium)
- QuickBooks Online and Xero import files (Premium)
- A checks sheet with opening, money in, money out and closing for each month
Any bank layout, business or personal. One month or a full year of catch-up. No bank login needed, only the files.
My Portfolio
FAQ
Which banks do you work with?
Any bank. The layout doesn't matter. If the PDF has selectable text, I read it directly. Scans and photos go through OCR, and then every line is checked.
My statement is a scan or a phone photo. Is that OK?
Yes, as long as you can read the numbers yourself. Each line from a scan is checked against the balance printed next to it. Anything unclear is highlighted, and I ask you about it.
How do I know nothing is missing or counted twice?
Every month has to tie out: opening balance plus all transactions equals the closing balance, to the cent. A skipped line or a repeated page breaks that, so I catch it before you see the file.
What counts as a page?
One page of the statement as your bank prints it. Not sure which package you need? Send me a message with the files first and I'll tell you.
Can you import the file into QuickBooks or Xero for me?
I don't need your login. I send a file in the exact import format, and importing it takes you a few minutes. I can send short steps if you need them.

