Step 1: Convert the statement to CSV
Upload your statement PDF to a converter and export to CSV. Before you export, review the transactions and confirm the running balance reconciles — fixing a misread row now is far easier than hunting it down in a spreadsheet later.
A clean CSV has one row per transaction and clear columns: Date, Description, Amount (or separate Credit and Debit). That's exactly what Sheets wants.
Step 2: Import the CSV into Google Sheets
In Google Sheets, open File → Import → Upload and choose your CSV. Pick "Insert new sheet" (or replace the current one), leave the separator on Detect automatically, and import.
Your transactions appear as rows. From here, freeze the header row, then sort or filter by date or amount, and use SUM to total a column.
Keep dates and amounts from breaking
Dates showing as text or shifting by a month is the most common issue — it's a format mismatch. Set the column to Format → Number → Date, and make sure your CSV's date order (MM/DD vs DD/MM) matches your sheet's locale under File → Settings.
Amounts importing as text won't sum. Select the column and apply Format → Number, and remove any stray currency symbols or thousands separators the CSV carried over.