Why a Pivot Table Suits Transaction Lists
A statement with hundreds of rows is hard to read as it stands. A pivot table collapses it into a short summary, for instance one line per spending category. Google describes pivot tables as a way to narrow a large data set and see relationships between data points.
You still need a category column. The statement gives dates, descriptions and amounts; the category label is something you add yourself before building the pivot table.
The Sample Data
The data is in A1:C9 with the headers Date, Category and Amount. Google stresses that each column needs a header in the source data. The amounts and merchants are invented:
Date Category Amount
2026-09-02 Groceries 42.10
2026-09-03 Transport 18.50
2026-09-05 Groceries 27.90
2026-09-07 Entertainment 24.00
2026-09-09 Transport 18.50
2026-09-12 Groceries 63.25
2026-09-15 Entertainment 11.99
2026-09-18 Groceries 15.75Create the Pivot Table
Google gives these steps on a computer: select the cells with your source data, go to Insert > Pivot table, and in the side panel use Add next to Rows to choose the field that categorises your data. Then use Add next to Values to choose the figure to summarise.
For this sample, add Category under Rows and Amount under Values. The summary should show Groceries 149.00 (42.10 + 27.90 + 63.25 + 15.75), Transport 37.00 and Entertainment 35.99, and a grand total of 221.99, which matches the sum of all eight amounts. Check the values field is totalling the amounts rather than counting rows; the help page does not list every summarising option, so confirm on screen.
Google also says the pivot table refreshes any time you change the source data cells it is drawn from, so correcting a mislabelled category in the source updates the summary.
Google may recommend pivot tables based on your data and can insert high-confidence suggestions automatically when you create the table. According to Google, they can be turned off under Tools > Suggestion controls.
Sort, Filter and Group
Google documents several adjustments from the Edit button under the pivot table. Under Rows or Columns you can use the Order or Sort by arrows, and a Show totals checkbox displays row or column totals.
For filtering, click Edit and next to Filters click Add. You can then Filter by condition, such as a Greater Than rule, or Filter by values, unchecking items to hide them. Google adds that if you filter by value and later change the source data, you may need to update the filter to show new data.
If you include the date column, Google documents right-clicking a date-formatted cell and choosing Create pivot date group to group by a period you choose. To rename a header, click Edit and then the name. Grand Total cannot be renamed.
Getting the Data Into the Sheet
A pivot table works on rows and columns, not on a PDF. If your statement is a PDF, PDFtoRow converts bank statement PDFs to Excel or CSV and offers a free preview of the first 10 rows.
Convert Bank Statement PDFs Cleanly with PDFtoRow
Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.
Frequently Asked Questions
Google states that each column needs a header. Select the cells with your source data, then go to Insert > Pivot table.
Google says the pivot table refreshes any time you change the source data cells it is drawn from. If you filtered by value, you may need to update that filter.
Yes. Google documents a Show totals checkbox in the pivot table editor under Rows or Columns.
Primary Evidence & Official References
- Create & use pivot tables - Google Docs Editors Help — support.google.com (Verified 2026-10-29). Official source documentation →
- Customize a pivot table - Google Docs Editors Help — support.google.com (Verified 2026-10-29). Official source documentation →