Home › Northern Trust › Reconcile statements
Every Northern Trust statement can prove itself — opening balance, transactions, closing balance. Reconciliation is simply running that proof before the numbers are used. This page shows how, month by month.
Deposit statements at Northern Trust typically run in date order with the balance carried on each row; its card statements follow the Previous Balance / New Balance structure instead. Northern Trust is headquartered in Chicago, Illinois, and its statements are issued centrally — the same document family serves every branch and channel.
Whatever the layout, the arithmetic underneath a statement is always the same shape: an opening figure, the period's transactions, and a closing figure the transactions must reproduce exactly. Reconciliation is the discipline of insisting on that proof for every month, in order. The converter runs the check at conversion time — totals first, then the running balance row by row — so a bad file is caught before it reaches the books, and the methodology page explains both checks in full.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
One habit separates fast reconciliations from slow ones: read a Northern Trust statement in the order the bank printed it before sorting it any other way. Running balances only make sense in print order, pending items cluster at period boundaries in print order, and the bank's own section subtotals — free checkpoints — exist only in print order. Convert the PDF from eStatements in Northern Trust online banking (website and app), walk it as printed, and let the accounting software do the reordering afterwards.
Reconciliation knowledge tends to live in one person's head, which makes it fragile. The defence is a written routine — this page is a template — plus the filed evidence trio for each month: statement, converted file, result. A successor who inherits both can reproduce any month without interviewing anyone, and the standard survives staff changes, vacations and growth.
Convert and check each account's statements separately — balances are per account — then reconcile each account in your software. Combined Excel exports keep one sheet per statement so accounts never blur.
A cheque written but not yet cleared, or a deposit recorded but not yet at the bank, makes honest books differ from the statement by exactly those items. They are listed, carried forward, and expected to clear next month — they are not errors.
Either that transaction is missing from the file or it is in twice. Search the converted file for the amount: zero hits means a dropped row, two hits where the statement shows one means a duplicate.
Banks post corrections as their own dated lines — a reversal and a corrected entry, or a single adjustment line. Enter them exactly as printed, in the period they appear, even if the original transaction sits in an earlier month. The statement is the record; reconciling means matching it, and the pair nets to the truth.
When an account changes product, banks sometimes issue a short final statement for the old product and a first statement for the new one. Convert and prove both; the old one's closing balance should equal the new one's opening balance, and that handover is the seam to verify before anything else.
Northern Trust statement converter hub · How to download Northern Trust statements · Northern Trust statement to QuickBooks · Northern Trust statement to Excel
Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.