Bank statement to Google Sheets.
Reconciled before you import.
Convert a PDF bank statement into a spreadsheet you can open in Google Sheets: real dates, numeric amounts, a running balance, a suggested category on every row and a Summary sheet whose balance check and category totals keep working after the import.
Drop your bank statements here
One file or a whole year. PDF, scanned image, CSV, QIF or OFX. Up to 12 files at a time; long PDFs are split for you.
Not ready to upload your own? See a sample result
5 pages free, no account. The Excel download appears on the results page.
Step by step: PDF statement to Google Sheets
- Drop the statement on the home page and confirm the balance check is green.
- Click Excel. The .xlsx has a Transactions sheet and a Summary sheet with live SUMIF formulas for the totals by category.
- In Google Sheets: File, then Import, then Upload, and choose the .xlsx. Pick Create new spreadsheet or Insert new sheet(s). Alternatively upload the file to Google Drive and open it with Google Sheets.
- Both sheets come across. Dates stay dates, amounts stay numbers and the SUMIF formulas on the Summary sheet recalculate in Sheets.
- If you prefer CSV, click CSV instead and import it the same way; you get the Transactions data without the Summary sheet.
What usually goes wrong, and how this avoids it
- Pasting from a PDF into Sheets gives you text that SUM ignores, and a merged Date and Description column. The .xlsx has one value per cell and numeric cells throughout.
- A CSV with commas inside descriptions breaks into extra columns in a naive import. The CSV written here quotes those fields, and Sheets' importer handles them.
- Dates in DD/MM or MM/DD text form are guessed by Sheets according to your locale. The .xlsx stores real date values, so there is nothing to guess.
Google Sheets questions
Do the formulas on the Summary sheet work in Google Sheets?
Yes. They are plain SUMIF and IF formulas over the Transactions sheet, and Sheets supports both. Change a category label on the Transactions sheet and the totals update; type a new label into a blank row of the totals table and it gets a total.
Can I keep a running yearly sheet and append each month?
Import each month's .xlsx as new sheets in the same spreadsheet, or convert up to 12 statements together and import the merged CSV, which has every transaction in date order with a Statement column. Then build your own totals with SUMIF or a pivot table over the combined range.
Is Google Sheets a good place to do the reconciliation?
For a spreadsheet-kept business, yes. The Summary sheet records the tie-out for each statement, and the running Balance column lets you spot a missing row. If you keep books in accounting software, import there instead and use Sheets for analysis.