Cash coding that shows the account code

Cash coding is the spreadsheet-style way to clear a bank statement. Instead of reconciling one transaction at a time, the statement lines load into a grid you can sort, filter, and code in bulk — pick the account, pick the tax rate, move on. Xero popularised the term and the workflow, and it is the fastest part of most bookkeeping months.

The catch is what the grid shows you. A bookkeeper coding 200 lines is not thinking in account names; they are thinking in codes. The client’s chart of accounts is numbered. The engagement file is organised by number. The reviewer’s query list says “why is this in 5230 and not 5270”. When the grid only shows a name, every one of those lookups becomes a second window.

This matters most for firms that inherited a numbered chart of accounts from a migration — Tally, QuickBooks Desktop, Sage, a legacy ERP — where the numbers are the shared vocabulary between the client, the bookkeeper, and the auditor. Hiding them does not simplify the screen; it just moves the lookup somewhere less convenient.

On Xero’s product-ideas board there is an entry asking for the account code to be shown in the cash coding screen. It was filed by a practice migrating from BankLink, narrowed to cash coding specifically by a Xero community manager in May 2022, and — as of July 2026 — is still open with no implementation status attached to it.

We read that thread while designing this screen, and we agree with the people in it. So HelloBooks shows the account code on every coded line. But we did not simply bolt the number onto the front of the name, because that creates a different problem, and the fix for it is the interesting part.

The obvious way to show both is the way most accounting software does it: code, separator, name. “5230 - Office Supplies”. That reads fine in a wide form field and badly in a grid, because a grid column is narrow and text truncates from the right. At a typical column width you get “5230 - Office Sup…”, and on a laptop you get “5230 - Off…”. The half that survives is the half you can look up later; the half that gets cut is the half that tells you at a glance whether the line is coded correctly.

So HelloBooks reverses it. The account name leads, the code trails in parentheses: “Office Supplies (5230)”. Truncate that and you still read the account. Nothing is hidden — the code is right there — it just is not first in the queue for the pixels.

The parentheses are deliberate too. A hyphen would be ambiguous, because real chart-of-accounts names contain hyphens: an account called “Bank - Operating” would render as “Bank - Operating - 1001”, three hyphen-separated tokens with no way to tell which one is the code. Parentheses never collide, and they clip honestly — a cut-off “(52…” still reads as a truncated code.

Inside the account picker the two parts split into columns: names left-aligned so they scan straight down the list, codes in a dim right-hand column so they line up with each other. And the filter searches both — type “Advance” or type “1610”, either finds the account.

• Coded line reads “Office Supplies (5230)” — account name survives truncation
• Picker lists names on the left, codes aligned dim on the right
• Search matches the account name or the account code, interchangeably
• Parenthesised so hyphenated account names stay unambiguous
• Accounts with no code simply show the name — nothing empty, nothing padded

Showing the code is worth little if the grid still needs a mouse for every cell. The HelloBooks reconcile grid is built to be driven from the keyboard, in the way a bookkeeper who lived in Excel expects.

Column widths are yours: drag any column wider, and on the reconcile tab the widths are remembered per user, with a “Reset widths” control when you want the defaults back. Three density modes — compact, cozy, comfortable — trade rows-per-screen against detail-per-row.

• Arrow keys move the active cell; Home / End jump to the first and last column
• Page Up / Page Down move ten rows at a time
• Tab commits the cell and moves on; Enter or F2 opens the cell’s editor
• Shift + arrow extends a row range
• Ctrl / ⌘ + D fills down from the row above — or across the whole selected range
• Escape clears the active cell and the range
• Select rows and accept every confident AI suggestion in one action

Each line carries an AI-suggested account with a match-strength band rather than a bare percentage, and a staged suggestion stays visually distinct from a confirmed one until a human commits it — nothing posts to the ledger because the model was confident. Corrections feed back into the rules, so the long tail of a client’s vendors gets faster every month.

The account you pick is still the account that posts. The label work on this page is display only: it changes what you read while coding, never what lands in the general ledger.