Bought Pro? Your keys are in your account. Sign in

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.

Before As copied from the web page
DateDescriptionWithdrawalsDepositsBalance
 Balance brought forward  12,480.00
02/09/2026CARREFOUR MOE DUBAI412.35 12,067.65
03/09/2026SALIK TOPUP100.00 11,967.65
     
DateDescriptionWithdrawalsDepositsBalance
15/09/2026ADNOC 512 AL BARSHA210.00 11,757.65
25/09/2026SALARY SEP 2026 WPS 18,750.0030,507.65
     
DateDescriptionWithdrawalsDepositsBalance
28/09/2026EJARI RENT CHQ 0002316,250.00 24,257.65
Page total 6,972.3518,750.00 
After Cleaned by StatementTidy
DateDescriptionAmountBalanceRow flag
Balance brought forward12480.00balance
2026-09-02CARREFOUR MOE DUBAI-412.3512067.65
2026-09-03SALIK TOPUP-100.0011967.65
2026-09-15ADNOC 512 AL BARSHA-210.0011757.65
2026-09-25SALARY SEP 2026 WPS18750.0030507.65
2026-09-28EJARI RENT CHQ 000231-6250.0024257.65
Page total11777.65total
  • 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

  1. Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
  2. Open the statement. Paging through? Show all transactions on one page if your bank allows it.
  3. Click the StatementTidy icon. Repeated headers and empty rows are removed; chips show how many. Totals and balance rows get a Row flag.
  4. 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.