Sort a general ledger in Excel: by account, then by date

A general ledger export rarely arrives in a useful order. Lines from five accounts sit side by side, April entries follow May entries, and a large bill hides between two small bank fees. Sorting puts the lines in an order you can actually read. This page covers why accountants sort a ledger, single-level and multi-level sorts, sort directions, keeping each entry in one piece, and when a filter is the better tool.

Why sort a ledger export?

Each ledger line has a date, an account, a description, a reference such as a journal entry number, and an amount. Sorting changes only the order of the lines, and the right order depends on the question you are asking.

• Date order, to read the activity. Sorting from the oldest entry to the newest lets you read the period like a story: what happened first, what came next, and whether anything is missing from a given week.
• By account, to review each account. Grouping the lines by account puts all the Cash entries together, then all the Rent Expense entries, and so on. That is how you check an account before its balance goes onto a trial balance.
• Largest entries first, to focus a review. A reviewer with limited time looks at the biggest amounts first, because a mistake there matters most. Sorting amounts from largest to smallest brings those lines to the top.

Sorting calculates nothing; for a total per account, see the page on SUMIFS totals by account.

How a sort works

A sort compares the values in one column, called the sort key, and rearranges the rows so those values run in order. Every other cell in the row travels with it. If row 9 holds an entry dated 4/20/2026 for Cash, the whole row moves together to wherever 4/20/2026 belongs.

That is the key idea on this page: a sort moves whole rows. The five cells of a ledger line describe one entry and must stay on the same row. If they come apart, the ledger is wrong, even though every value is still there.

Single-level sort

A single-level sort uses one key, such as Date, oldest first. It answers one question: in what order did things happen?

Multi-level sort ("then by")

A multi-level sort uses two or more keys in a fixed order of priority. The first level makes the groups. Each later level orders the rows inside those groups, and only breaks ties left by the levels above it.

Sort by Account A to Z, then by Date oldest first, and you get every Accounts Payable line together, in date order, followed by every Accounts Receivable line in date order, and so on. The second level never pulls a line out of its account group.

The order of the levels matters. Date first and Account second gives a very different result: the ledger is in date order, and Account only matters for two lines that share the same date.

Choosing a direction

Each level has a direction. The labels change with the type of data in the column, but there are always two choices.

Dates are stored as numbers, with later dates holding larger numbers, so "smallest to largest" on a date column means oldest first, the usual order for a ledger.

Text sorts alphabetically and ignores case. Watch for a leading space in a name: it can make an account sort out of place.

Blank cells go last

Empty cells in the sort column go to the bottom, whichever direction you choose. If a few lines are missing a date, they end up after the last dated entry. The incomplete lines collect in one place where you can fix them.

Headers stay at the top

A ledger export has a header row with labels such as Date, Account and Amount. The header is not data, and it must not be sorted in with the entries. The sort dialog has a setting called "My data has headers". When it is on, the first row of the range is treated as labels: it stays where it is, and its labels appear in the "Sort by" list so you can pick a column by name.

The spreadsheet usually detects the header row for you, but check the setting. If it is off, the column choices show as "Column A", "Column B", and the header row is sorted into the middle of the ledger.

Step by step: sort by account, then by date

1. Click any cell inside the ledger table; the sort picks up the whole block around it.
2. Open Sort from the Data menu or toolbar.
3. Check that "My data has headers" is on, so the header row stays put.
4. Sort by: Account, A to Z.
5. Add level. Then by: Date, smallest to largest (oldest first).
6. Confirm, then check that each account forms one block with its dates running forward.

For a largest-first review, keep Account as the first level and use Amount, largest to smallest, as the second.

Worked example: a two-level sort on a real export

Here are the first six lines of a ledger export, as they arrived. The full export has 20 lines across five accounts, in A5:E24, with headers in row 4.

Accounts and months are mixed together. After a sort by Account A to Z, then by Date oldest first, the first eight rows of the result look like this:

The rest of the ledger follows the same pattern: four Cash lines from 4/1/2026 to 5/19/2026, four Rent Expense lines from 4/26/2026 to 5/20/2026, and four Utilities Expense lines from 4/8/2026 to 5/22/2026. Three things to notice:

• The groups come from the first level. Accounts Payable comes before Accounts Receivable because "Payable" sorts before "Receivable" letter by letter.
• The dates restart in each group. Accounts Payable ends on 5/21/2026 and Accounts Receivable starts again on 4/24/2026. That is correct: the date level only orders lines inside each account.
• Each entry is intact. JE-117 was the second line of the export. It is now the fourth line of the result, and it still reads 5/21/2026, Accounts Payable, Supplier bill, $8,333.24.

A quick check for any sort: note the full line of two or three references before you start and find them again afterwards. If one now sits next to a different date or amount, the rows came apart.

Filter vs sort

Sorting and filtering are often used together, but they do different things.

• A sort moves rows. Every line is still visible, in a new order.
• A filter hides rows. Lines that don't match the condition are hidden, not deleted and not moved. The lines that remain visible keep their original order.

To review one account, a filter is often quicker: turn on the filter and show only that account in the Account column. Clearing the filter brings every line back, exactly where it was. Because filtered rows still exist, a total over the whole column still includes them.

The tools combine well: sort by date first, then filter to one account, and you see that account's lines in date order. If you would rather pull matching lines into a separate area with a formula, the FILTER function does that, and the page on filtering transactions in Excel covers it.

Common mistakes and how to fix them

These are the mistakes our exercises check for.

Sorting only one column

Selecting just the Date column and sorting it puts the dates in order, but the other columns stay where they were. Each date now sits next to another entry's account and amount, and the ledger is scrambled. Undo straight away, select the whole table (or click one cell inside it) and sort it as one block.

Newest first

Largest to smallest on the date column puts the most recent entry on top. Choose smallest to largest.

Levels in the wrong order

With Date as the first level and Account as the second, the lines come out in date order with the accounts mixed together. The level that makes the groups goes first: Account, then Date.

Wrong direction inside each group

The accounts are grouped correctly, but inside each account the newest date or the smallest amount comes first. Check the direction on the second level: smallest to largest for oldest-first dates, largest to smallest for biggest-first amounts.

Sorting by amount only

For a "biggest entries in each account" review, a single sort on Amount ranks the whole ledger at once and mixes the accounts. Add Account as the first level and keep Amount as the second.

Filtering the wrong way round

When you filter to review one account, make sure the filter shows rows where the account equals the name you want. A condition of "does not equal" hides exactly the lines you meant to look at. Also check that you picked the right account name.

Where this fits in MO-220 practice

Organizing transactions with sort and filter is part of preparing data for a trial balance. Our MO-220 practice tasks describe the order you need rather than the clicks, so you learn to turn a review question into sort levels. Accounting Exercises is not affiliated with Microsoft or Certiport.