How to Get a Bank Statement into Google Sheets
Getting bank statement PDFs into Google Sheets, the import settings that preserve your data, and formulas for analysis.
Google Sheets cannot read PDFs. The route is to convert the statement to CSV and import that — and the import settings matter more than you might expect.
Import settings that matter
When you import a CSV, Sheets offers a "Convert text to numbers, dates, and formulas" toggle. It is on by default, and on a bank statement it causes two specific problems.
- Reference numbers become scientific notation — a 12-digit reference displays as 5.12E+11 and the original digits are lost
- Account numbers lose leading zeros — 00123456 becomes 123456
- Dates may be re-interpreted — a DD/MM date can be flipped to MM/DD depending on your locale
The safe import
- Set your locale first File → Settings → Locale, matched to your statement's date convention.
- File → Import → Upload Select your CSV.
- Turn OFF text-to-number conversion Then convert only the columns you want as numbers, deliberately.
- Convert amount columns manually Select the column, Format → Number.
- Leave reference and account columns as text They are identifiers, not quantities.
Useful formulas once it is in
| Goal | Formula |
|---|---|
| Monthly totals | =SUMIFS(debit_range, date_range, ">="&start, date_range, "<="&end) |
| Category from a lookup table | =IFERROR(INDEX(cat_col, MATCH(TRUE, ISNUMBER(SEARCH(key_col, desc)), 0)), "Uncategorised") |
| Verify the balance chain | =prev_balance - debit + credit compared against the balance column |
| Running total | =SUM($D$2:D2) |
A verification formula for Sheets
Once the data is in, you can rebuild the balance-chain check yourself in one column. If your balance is in column F, debit in D and credit in E, then in a helper column:
=ROUND(F1 - D2 + E2, 2) = ROUND(F2, 2)
Fill it down. Every row should read TRUE. The first FALSE is where the extraction went wrong, and everything below it is downstream of that one error.
Sharing and permissions
One practical caution: a Sheet containing bank data is as sensitive as the statement it came from. Check the sharing settings before sending a link, and prefer sharing with named accounts over link-sharing.
Frequently asked questions
Can Google Sheets open a PDF directly?
No. Convert to CSV first — Sheets has no PDF import.
Can I check the balance chain in Sheets myself?
Yes — one helper column comparing previous balance minus debit plus credit against the current balance. The first FALSE is where the problem is.
Why did my reference numbers turn into 5.12E+11?
Text-to-number conversion was left on during import. Turn it off and the column stays as text.
Related posts
- How to Import a Bank Statement into MYOB
- How to Import a Bank Statement into Wave Accounting
- How to Import a Bank Statement into FreshBooks
Convert a statement now
Bank Statement PDF to CSV, or see every format. More in the guides.