Bank Statement PDF to Google Sheets: Automate Your Tracking

Why Google Sheets for Bank Statement Analysis

Google Sheets is the most accessible spreadsheet tool available. It is free, runs in any browser, syncs across devices, and supports real-time collaboration. For tracking personal finances, managing business expenses, or preparing data for your accountant, Google Sheets is hard to beat — especially when you do not want to pay for Excel or dedicated accounting software.

The challenge is getting your bank statement data into Google Sheets in the first place. Banks deliver statements as PDFs, and Google Sheets cannot read PDFs directly. You need to convert the PDF into a structured format — CSV or Excel — and then import it. Once the data is in Google Sheets, you can build formulas, charts, pivot tables, and automated dashboards that update every time you add a new month of transactions.

Step 1: Convert Your Bank Statement PDF to CSV

Before you can do anything in Google Sheets, you need your transaction data in a format it can read. CSV is the cleanest option because Google Sheets imports it natively without any formatting artifacts.

1. Upload your bank statement PDF to StatementVision. It works with Chase, Wells Fargo, and statements from virtually any other bank.
2. Review the extracted transactions to confirm accuracy. The AI parses dates, descriptions, amounts, and transaction types automatically.
3. Download the CSV export. The file will contain clean columns for Date, Description, Amount, Type, and Category.

Step 2: Import the CSV into Google Sheets

There are two ways to get CSV data into Google Sheets, depending on whether you want a new spreadsheet or want to add data to an existing one.

Option A: Open the CSV Directly

Go to Google Drive, click New > File Upload, and select your CSV file. Once uploaded, right-click the file and choose Open with > Google Sheets. Google will convert the CSV into a new spreadsheet with all your transaction data intact. This is the fastest approach for a single statement.

Option B: Import into an Existing Sheet

If you already have a master tracking spreadsheet and want to append new transaction data, open your existing Google Sheet and go to File > Import. Select your CSV file, choose "Append to current sheet" as the import location, and click Import data. This adds the new transactions below your existing rows without overwriting anything.

Step 3: Build an Automated Analysis Dashboard

With your transaction data in Google Sheets, you can build a dashboard that summarizes your spending patterns. Here are the most useful formulas and techniques.

Essential Formulas for Transaction Analysis

Total Spending (debits only):
=SUMIFS(C:C, C:C, "<0")

Total Income (credits only):
=SUMIFS(C:C, C:C, ">0")

Spending by Category:
=SUMIFS(C:C, E:E, "Groceries", C:C, "<0")

Transaction Count by Month:
=COUNTIFS(A:A, ">="&DATE(2025,3,1), A:A, "<"&DATE(2025,4,1))

Average Transaction Amount:
=AVERAGEIF(C:C, "<0")

These formulas assume column A is Date, column C is Amount, and column E is Category. Adjust the column references to match your actual data layout. The SUMIFS and COUNTIFS functions are the workhorses of financial analysis in Google Sheets — they let you slice your data by any combination of criteria.

Create a Pivot Table for Category Breakdown

1. Select your entire data range including headers.
2. Go to Insert > Pivot table and place it on a new sheet.
3. Add Category to the Rows section.
4. Add Amount to the Values section and set it to SUM.
5. Optionally, add Date to the Columns section grouped by Month to see spending trends over time.

A pivot table gives you an instant category-by-category spending breakdown without writing a single formula. Every time you add new transaction data to the source sheet, the pivot table updates automatically. This is the fastest way to answer questions like "How much did I spend on dining last month?" or "Are my utility costs increasing?"

Advanced: Automate Monthly Imports with Apps Script

If you want to take your Google Sheets tracking to the next level, Google Apps Script lets you automate repetitive tasks. Here is a simple script that formats newly imported transactions and updates a running balance column.

function formatTransactions() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const lastRow = sheet.getLastRow();
  const dateRange = sheet.getRange(2, 1, lastRow - 1, 1);
  
  // Format dates consistently
  dateRange.setNumberFormat("MM/dd/yyyy");
  
  // Format amount column as currency
  const amountRange = sheet.getRange(2, 3, lastRow - 1, 1);
  amountRange.setNumberFormat("$#,##0.00");
  
  // Add running balance in column F
  for (let i = 2; i <= lastRow; i++) {
    const formula = i === 2
      ? "=C2"
      : `=F${i - 1}+C${i}`;
    sheet.getRange(i, 6).setFormula(formula);
  }
  
  // Sort by date ascending
  sheet.getRange(2, 1, lastRow - 1, 6)
    .sort({ column: 1, ascending: true });
}

To use this script, open your Google Sheet and go to Extensions > Apps Script. Paste the code, save it, and run it after each new import. You can also attach it to a button in your spreadsheet or set it to run automatically via a trigger. The script formats dates, applies currency formatting, adds a running balance column, and sorts everything chronologically.

Building a Reusable Monthly Template

Rather than building your analysis from scratch each month, create a template sheet that you clone and populate with each new statement. A good template includes:

• A Transactions tab with pre-formatted headers and conditional formatting rules (e.g., red for debits, green for credits).
• A Summary tab with SUMIFS formulas referencing the Transactions tab, broken down by category.
• A Charts tab with pre-built pie charts for category breakdown and line charts for daily spending trends.
• A Reconciliation tab where you enter the opening and closing balance from your statement and a formula that compares them to the sum of transactions.

Each month, duplicate the template, paste in your new CSV data, and the entire dashboard updates instantly. Over time, you can also maintain a master sheet that aggregates data across months for year-to-date analysis.

The best financial tracking system is the one you actually use. Google Sheets wins because it is free, familiar, and available on every device you own.

Start Tracking Your Finances in Google Sheets

The hardest part of tracking your finances is not the spreadsheet — it is getting the data out of your bank statement PDFs in a format you can actually use. Once you have clean CSV data, Google Sheets does the rest. Convert your first statement and build a tracking system that works for you.