PDF Bank Statement to Google Sheets
How to turn bank statement transactions into a spreadsheet you can sort, total and reconcile
Answer in brief
Banks usually provide statements as PDFs, which are easy to read but impossible to sort, filter or total. Converting a PDF bank statement to Google Sheets turns each transaction into a row, with the date, description, debit, credit and balance in their own columns.
The Convert PDF to Google Sheets™ add-on by Easy Image to Text does this inside Google Sheets: upload the statement, pick the pages, and the transactions are written into your sheet.
Why bank statements are tricky to convert
- Every bank uses a different layout. Some show separate debit and credit columns, others use one amount column with minus signs or CR and DR markers.
- Descriptions wrap onto several lines. A long payee name or reference can spill onto a second line and get read as a new transaction.
- Dates are ambiguous. A date like 03/04 can mean 3 April or 4 March, and spreadsheets often guess wrong.
- Statements mix tables with summaries. The first page usually has account details and an opening balance before the transaction list starts.
- They run across several pages. A month of transactions rarely fits on one page.
Copy and paste and generic converters often stumble on these. To see how each option handles them, compare the different ways to convert PDF to Google Sheets.
How to convert a bank statement PDF to Google Sheets
- Install the Convert PDF to Google Sheets™ add-on from the Google Workspace Marketplace.
- Open a Google Sheet and launch the add-on from the Extensions menu.
- Upload the bank statement PDF. If your statement is password-protected, save an unlocked copy first.
- Select the pages that contain transactions, up to 5 at a time.
- Click Extract Data. Each page is written to its own sheet, usually within 10 to 40 seconds.
- Click Download CSV if you want to import the transactions into accounting software.
For statements longer than 5 pages, or to join the pages into one transaction list, see multi-page PDF to Google Sheets. For paper statements you've scanned or photographed, see scanned PDF to Google Sheets.
What you get in the sheet
The add-on reads the statement's layout rather than relying on a template for each bank, so it works with statements from any bank. Each transaction becomes one row, and the columns follow the statement's own headers, such as Date, Description, Debit, Credit and Balance.
Everything is written as plain text, exactly as it appears on the statement. This is deliberate:
- dates aren't silently switched between day-first and month-first formats
- account and reference numbers keep their leading zeros
- minus signs, brackets and CR or DR markers stay as printed
If the first page has an account summary as well as the transaction table, both are extracted, with a blank row between them.
Checking the converted statement
A bank statement has a built-in check, so you can confirm the conversion is complete in a minute:
- Note the opening and closing balances printed on the statement.
- Add up the credits and the debits in your sheet.
- Check that opening balance + credits − debits = closing balance.
If the numbers don't match, look for a missing row at a page break, or a wrapped description that was read as its own transaction.
Because values arrive as text, convert amount columns to numbers before totalling them. A helper column with =VALUE(C2), filled down, does this. Remove any currency symbols first if your statement prints them.
What people use converted statements for
- Bookkeeping: importing transactions into QuickBooks, Xero or other accounting software from the CSV file.
- Reconciliation: matching statement lines against invoices, receipts or your own records. If your invoices are PDFs too, see PDF invoice to Google Sheets.
- Expense tracking: adding a category column and summarising spending with a pivot table.
- Tax preparation: pulling out deductible expenses or income for the year.
- Loan and visa applications: summarising income and balances across several months of statements.
Credit card statements work the same way, since they are also transaction tables. Looking for income statements or balance sheets instead? See PDF financial statement to Google Sheets.
Frequently asked questions
Does it work with statements from any bank?
Yes. The add-on reads the layout of each page instead of using bank-specific templates, so it works with statements from any bank or credit card provider.
Can I convert a password-protected bank statement?
Save an unlocked copy of the statement first, for example by opening it with the password and saving or printing it to a new PDF, then upload that copy.
Will debits and credits stay in the right columns?
Yes. Debits, credits and balances are kept in the columns used by the statement, and minus signs or CR and DR markers are kept as printed.
Can I import the result into QuickBooks or Xero?
Yes. Use Download CSV after extraction, then import the CSV file using your accounting software's bank statement import and map the columns.
How many pages of a statement can I convert at once?
Up to 5 pages per run. For longer statements, extract the next range of pages in another run. Each successfully extracted page uses 1 credit.
Can I convert a scanned or photographed paper statement?
Yes. Scanned PDFs and photos work too. Clear, straight, well-lit pages give the most accurate results.
Stop retyping transactions. Try the Convert PDF to Google Sheets™ add-on by Easy Image to Text: install it free from the Google Workspace Marketplace, or learn more about PDF to Google Sheets conversion.
Last updated: 2026-11-09