How-to · Spreadsheet problems
How to filter bank statement transactions in Excel
Narrow statement rows by date, merchant, amount, or category—so you can review, reconcile, or export only what you need without deleting data.
Why filter bank statement transactions?
Full statements are long. Filtering lets you answer “show only this supplier,” “only last week,” or “only large outflows” without building a new sheet.
It works best on structured exports—clear columns and real dates—not on pasted PDF text.
- Find one merchant in seconds
- Isolate a date range for review
- Spot large or unusual amounts
- Prepare a subset to export or print
- Support reconciliation checks
- Work without deleting source rows
Step-by-step: filter bank statement transactions in Excel
Use a clean table
One header row, one transaction per row, no merged cells or mid-table blanks. Export from a bank-statement converter when possible.
Turn on AutoFilter
Select any cell in the table → Data → Filter (or Ctrl+Shift+L). Dropdown arrows appear on each header.
Filter by date
Open the Date column filter and pick a range, month, or specific days. Dates must be true Excel dates to use Date Filters.
Filter by merchant or text
Use Contains or the checkbox list on Description to show one vendor, payment type, or keyword.
Filter by amount
Number Filters → Greater Than / Less Than to isolate large payments or small fees.
Clear or stack filters
Combine columns (e.g. date + merchant). Clear Filter on a column—or Clear All—when you need the full list again.
Tips for reliable filters
Format as a Table
Ctrl+T turns the range into an Excel Table so filters stay attached when you add new months of transactions.
Filter does not delete
Hidden rows are still in the sheet. Clear filters before sharing a “full” statement export.
Watch SUBTOTAL vs SUM
=SUBTOTAL(9, range) sums only visible (filtered) rows; =SUM includes hidden ones too.
Clean before heavy filtering
Inconsistent merchant names and text dates make filters noisy. Standardize first when you can.
Related spreadsheet how-tos
SUM filtered results
Total visible rows with SUBTOTAL or build conditional sums with SUMIF. SUM bank statement transactions →
Prepare for PivotTables
When you need summaries instead of row subsets. Prepare data for PivotTables →
FAQ: filter bank statement transactions in Excel
How do I filter bank statement transactions in Excel?
Put the statement in a table with one header row, turn on AutoFilter (Data → Filter), then use the dropdown on Date, Description, Debit, Credit, or Category to show only matching rows.
Why doesn’t filter work on my bank statement sheet?
Common causes: merged cells, blank rows breaking the range, multiple header rows from a multi-page PDF paste, or no clear header row. Clean to a single contiguous table first.
How do I filter bank transactions by date range?
Ensure dates are real Excel dates, open the Date column filter, choose Date Filters → Between (or After/Before), and set the start and end dates.
How do I filter by merchant or description?
Use the Description (or Merchant) column filter → Text Filters → Contains, and enter part of the name (e.g. AMAZON). Or check specific values in the filter list.
Can I filter only debits or only credits?
Yes. Filter the Debit column for non-blanks (or greater than zero), or the Credit column the same way—depending on how your export is structured.
Should I use Filter or PivotTables?
Filter is best for inspecting or exporting a subset of rows. PivotTables are better when you need summarized totals by category or month without hiding source rows.
Filter from clean statement data
Convert the PDF to structured columns first—then filter by date, merchant, or amount.