To sort transactions by date in Excel, first make sure every date is a real date, not text, and has the right year. Then add a column that numbers the rows in statement order, and sort by date first and by that number second. Same-day transactions then keep the order the bank printed them in.
Why won't converted transactions sort by date?
Converted transactions refuse to sort by date when some of the date cells hold text. Excel sorts real dates by their value and text by its characters, so text dates line up alphabetically, with 10/03 before 9/03. Dates with a wrong year also sort to the wrong end of the list.
Test the column before you sort. In an empty column next to the dates, enter =ISNUMBER(A2) and fill it down. Real dates return TRUE. Any FALSE is a text date that will sort in the wrong place. Excel also warns you when you sort a column that mixes the two, with a "Sort Warning" offering to sort anything that looks like a number as a number. That option does not help with dates written as 14/03/2026 on a month-first system.
A second sign is the alignment. Real dates sit at the right of the cell by default, and text sits at the left. A column with both is not ready to sort.
The repairs for text dates, swapped day and month, and missing years are in fixing converted dates that are wrong in Excel. Do those first, because no sort setting can put a text date in its right place.
A statement order column before you sort transactions
A statement order column is a helper column that numbers each row in the order it appears on the statement: 1, 2, 3 and so on. It records the bank's own sequence before any sort can change it. Use it as the second sort key, and same-day transactions stay in the order they were posted.
Banks list several transactions on the same day in a set order, and that order often explains the running balance. A sort on date alone treats those rows as ties, and you cannot count on them landing where they started. The order column removes the guesswork.
To add it, insert a column at the left, type 1 in the first data row and 2 below it, select both cells and double-click the fill handle. Then copy the column and paste it as values, so the numbers stay fixed when rows move.
This column is also your undo. Sort by it, smallest to largest, and the sheet returns to the order of the statement. If the converted rows were already out of order before you sorted, because pages or columns were read in the wrong sequence, restoring rows out of order after a PDF conversion covers rebuilding the true sequence.
Sorting transactions by date, then by statement order
The two-level sort puts transactions in date order and breaks every tie with the statement order number. In Excel, it is one dialog: Data, then Sort, with date as the first level and the order column as the second. Both levels sort smallest to largest, or oldest to newest.
Step list
- Click any cell inside the table. Do not select one column, or Excel will offer to sort that column alone and leave the others behind.
- Choose Data, then Sort.
- Tick "My data has headers".
- In the first level, choose the date column, Sort On "Cell Values", Order "Oldest to Newest".
- Choose Add Level. Pick the order column, Order "Smallest to Largest".
- Choose OK, and check the first and last rows against the statement period.
Four example rows
The rows below are examples. The statement listed them newest first, which some banks do.
| Order | Date | Description | Amount |
|---|---|---|---|
| 1 | 2026-03-05 | Card purchase, bakery | -6.40 |
| 2 | 2026-03-04 | Transfer from savings | 300.00 |
| 3 | 2026-03-04 | Rent payment | -950.00 |
| 4 | 2026-03-02 | Payroll deposit | 1,820.00 |
After the sort, the order reads 4, 2, 3, 1. The two rows dated 4 March keep their printed order, 2 then 3. On a newest-first statement, that printed order runs backwards within the day too, so if you want same-day rows oldest first, set the order level to Largest to Smallest, which gives 4, 3, 2, 1.
If you prefer a formula that leaves the original untouched, Excel 365 has SORTBY: =SORTBY(A2:D200, B2:B200, 1, A2:A200, 1) returns the table sorted by date and then by order number on another part of the sheet.
Should a statement with a running balance be sorted at all?
A running balance only makes sense in the order the bank calculated it. If you sort a statement by anything other than its posting order, each balance stays fixed to its row while the rows around it move, so the column stops adding up. Sort a copy, or delete or recalculate the balance column after sorting.
The usual mistake is to sort a newest-first statement into oldest-first order and keep the bank's balance column. Every balance is still the right figure for its own transaction, so nothing looks broken. But the balance on each row is no longer the previous balance plus this amount, and a reconciliation check will fail.
Recalculate the balance after the sort instead. With the opening balance in F1 and amounts in D, enter =F1+D2 in the first balance cell and =E2+D3 in the next, then fill down. One signed amount column makes this simple; if your file has separate debit and credit columns, combining debit and credit columns in Excel turns them into one first.
Sorting transactions from several statements by date
Several statements sort together once they sit in one table with a column that names the source of each row. Add a statement or account column before combining, carry the order number across so it keeps counting, and sort by date, then statement, then order. Every row still shows where it came from.
If a converter gave each page its own sheet, stack the sheets into one table before sorting; putting converted pages onto one sheet covers that with VSTACK. A row that exists in two overlapping statements will sort right next to its twin, which makes it easy to spot.
Keep every column inside the sort range. If you have pulled the link targets out of a PDF into their own column, for example a receipt link per transaction, a sort that leaves that column out attaches each link to the wrong row. Extracting hyperlinks from a PDF to Excel covers getting those links into a column in the first place.
FastBankConvert is being designed so each transaction lands in its own row with a date, description, amount and balance, which is the shape a clean sort needs. It has not opened yet; the FastBankConvert home page explains what is planned.