SheetSmart Co Studio

How to Import a PDF Bank Statement into Google Sheets

To import a bank statement into Google Sheets, the easiest route is your bank's CSV download; for a PDF bank statement, you need a converter or an AI reader to pull out the transactions first.

Option 1: CSV (most reliable, free)

  1. In online banking, look for Download or Export on the activity page and choose CSV.
  2. In Google Sheets: File > Import > Upload, choose the CSV, and insert it as a new sheet.
  3. Check that dates and amounts came in as numbers (not text). Set File > Settings > Locale to your country if they didn't.

Option 2: PDF statement

Google Sheets can't read a PDF directly. Copy-pasting from a PDF usually scrambles columns. Your options are a PDF-to-CSV converter or an AI model that reads the statement. Either way, check the totals: the money in, money out and ending balance should match the statement.

Import a PDF bank statement into Google Sheets with an AI import sidebar that checks totals
An import sidebar that reads a PDF and checks the totals against the statement.

Then: categorize the transactions

Raw transactions aren't bookkeeping yet. For a rental, give each line a property and a Schedule E category, and remove transfers, card payments and personal spending. Rules help: "Zelle from [tenant]" is rent; your mortgage servicer is mortgage (interest only, see here); the county treasurer is taxes.

Privacy tips

Statements contain account numbers and balances. Prefer tools that don't need your bank login, read what a tool sends where, and don't paste statements into tools you don't trust.

Want this done for you? Our rental property spreadsheet for Google Sheets imports a bank statement (PDF or CSV), suggests a Schedule E category for each line, flags the ones it isn't sure about, and fills in a per-property Schedule E summary. Up to 50 properties, Excel version included. The statement import needs a computer browser.
See it on Etsy ($14.99, one-time)

FAQ

Can Google Sheets import a PDF?

Not directly. Convert the PDF to CSV first (with a converter or AI), or use your bank's CSV download instead.

How do I import a CSV bank statement into Google Sheets?

Use File > Import > Upload, choose the CSV file and insert a new sheet. Check that dates and amounts were recognized as numbers.

Can AI categorize bank transactions?

Yes, AI can suggest categories, but it makes mistakes. Review low-confidence lines before you rely on the totals.

Is it safe to upload bank statements to AI tools?

It depends on the tool. Check what data is sent, whether it's stored, and whether it's used for training; avoid tools that ask for your bank password.

Last reviewed 2026-11-18. General information for US landlords, not tax, legal or accounting advice. Check your own situation with a tax professional and the IRS sources linked above.