Guide · StatementTidy
How to remove repeated header rows (and blank rows) from a statement
Short answer
Multi-page statements repeat the header on every page and add blank and “Page total” rows. In Excel, filter the Date column for the header text and delete the visible rows; remove blank rows carefully, because Go To Special → Blanks also hits rows with just one empty cell. StatementTidy removes repeated headers and fully empty rows automatically and flags total and balance-forward rows instead of mixing them into your sums.
Last updated · by Mumshad Jawad
Why this happens
When a statement is shown page by page, or you paste several pages one after another, the table picks up rows that are not transactions:
- the header row again at the top of each page,
- blank spacer rows between pages,
- Page total, Subtotal and Total rows, and
- Balance brought forward / carried forward rows.
Repeated headers turn a number column into text. Totals and balances are worse: they are numbers, so they quietly double your sums.
Real example: before and after
The rows below are fictional. The “after” table is not a mock-up: this page ran them through StatementTidy’s cleaning engine (the same clean.js the extension uses, v1.0.1) with its default options, and shows exactly what you would export.
| Date | Description | Withdrawals | Deposits | Balance |
|---|---|---|---|---|
| Balance brought forward | 12,480.00 | |||
| 02/09/2026 | CARREFOUR MOE DUBAI | 412.35 | 12,067.65 | |
| 03/09/2026 | SALIK TOPUP | 100.00 | 11,967.65 | |
| Date | Description | Withdrawals | Deposits | Balance |
| 15/09/2026 | ADNOC 512 AL BARSHA | 210.00 | 11,757.65 | |
| 25/09/2026 | SALARY SEP 2026 WPS | 18,750.00 | 30,507.65 | |
| Date | Description | Withdrawals | Deposits | Balance |
| 28/09/2026 | EJARI RENT CHQ 000231 | 6,250.00 | 24,257.65 | |
| Page total | 6,972.35 | 18,750.00 |
| Date | Description | Amount | Balance | Row flag |
|---|---|---|---|---|
| Balance brought forward | 12480.00 | balance | ||
| 2026-09-02 | CARREFOUR MOE DUBAI | -412.35 | 12067.65 | |
| 2026-09-03 | SALIK TOPUP | -100.00 | 11967.65 | |
| 2026-09-15 | ADNOC 512 AL BARSHA | -210.00 | 11757.65 | |
| 2026-09-25 | SALARY SEP 2026 WPS | 18750.00 | 30507.65 | |
| 2026-09-28 | EJARI RENT CHQ 000231 | -6250.00 | 24257.65 | |
| Page total | 11777.65 | total |
- Debit and Credit merged into one signed Amount
- Date column converted to ISO YYYY-MM-DD (DD/MM detected)
- 4 negative amounts as real negative numbers
- 2 repeated header rows removed
- 2 empty rows removed
- 2 total/balance rows flagged, left out of sums
Open this example in the live demoEdit the rows, paste your own table, toggle options. Nothing is uploaded.
How to fix it by hand in Excel
Repeated headers
Click in the table, Data → Filter. On the Date column’s filter, untick everything except “Date”. Select the visible rows (not the first header), right-click → Delete Row, then clear the filter.
Blank rows, safely
Home → Find & Select → Go To Special → Blanks → Delete → Entire row deletes every row with any blank cell in the selection, including real transactions with an empty Credit. Add a helper column =COUNTA(A2:E2), filter it for 0, and delete only those rows.
Totals and balance rows
Filter the Description (or Date) column for “total”, “brought forward” and “carried forward”, and delete or move them. Check the result against the statement’s closing balance.
How to fix it in one click with StatementTidy
- Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
- Open the statement. Paging through? Show all transactions on one page if your bank allows it.
- Click the StatementTidy icon. Repeated headers and empty rows are removed; chips show how many. Totals and balance rows get a Row flag.
- Optionally remove flagged rows. Tick “Remove subtotal / balance rows” to drop them, then Copy for Excel or download CSV.
Get StatementTidy free for ChromeTry it on a sample statement
Questions
How does it know a row is a repeated header?
A body row whose cells match the table’s header row exactly is a repeated header. Rows where every cell is empty are spacer rows.
Which total and balance rows are flagged?
Rows starting with words such as Total, Subtotal, Page total, Grand total, Opening/Closing balance, Balance brought/carried forward, b/f and c/f, plus German, French, Spanish, Italian, Dutch and Arabic equivalents. A row that also has a real transaction date is not treated as a total.
Why is the Page total amount different from the statement?
Because Debit and Credit were merged on every row, the flagged Page total row shows deposits minus withdrawals. Flagged rows are left out of the summary, and you can remove them with one tick.