How to Reconcile Associated Bank Statements

What you are checking against

Associated Bank statements typically list transactions chronologically with a running balance on deposit accounts, and print opening and closing balances for the period. Associated Bank is headquartered in Green Bay, Wisconsin, and its statements are issued centrally — the same document family serves every branch and channel.

Think of the statement as self-auditing. It opens at one balance, lists everything that moved, and closes at another — and if the list is complete and correctly read, the numbers cannot help but agree. Reconciliation is checking that they do, before the data is trusted downstream. Done at conversion time, the check has a practical shape: the file either reproduces the statement's balances or it is flagged with the exact rows where the walk breaks. The methodology page documents the method.

The Associated Bank month-end reconciliation workflow

Begin with the statement, not the software. Open the month's PDF and read its summary numbers first: opening, totals, closing. The software gets opened second, with the target already known.
Convert and compare totals before rows. Match the converted file's totals to the statement's summary. Totals that agree leave only classification questions; totals that disagree send you to the flagged rows, in order.
Resolve flags while both documents are open. Statement on one side, file on the other, fix each marked row at its source. Flags resolved later are resolved from memory, and memory is how errors get in.
Import and reconcile to the identical closing figure. The software's reconciliation target is the statement's closing balance and closing date — typed from the statement, never from the imported file, so the check stays independent.
Leave the month better documented than you found it. Save the trio — statement, file, result — plus one line noting anything outstanding. The next person to touch this month may be you in a year.

These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.

Reading one Associated Bank statement closely

One habit separates fast reconciliations from slow ones: read a Associated Bank 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 Associated Bank online banking (website and app), walk it as printed, and let the accounting software do the reordering afterwards.

When a Associated Bank statement does not tie out

A page-header or section-total line was read as a transaction — the converter guards against this, and any survivor shows up as a row whose own balance breaks the walk.
A correction or reversal line nets against an earlier transaction. It looks like a duplicate when scanning quickly, but both lines are real and both belong in the file.
The account had a mid-period product change or merger conversion, and the statement covers two layout eras. Convert it in two parts if the columns visibly change mid-document.
The statement period straddles a bank holiday weekend and the bank grouped several days of card activity under one posting date — the rows are all present, but their order differs from the software's expectation.

Reconciling when the books were kept by someone else

Inherited books deserve a colder eye: trust nothing that is not tied to a statement. Start at the most recent statement and work backwards only as far as the engagement requires, proving each month against its own document before accepting its closing balance as the next month's ground. Where a predecessor forced a reconciliation to agree, the plug usually sits in an adjustments or suspense entry — find those first, because every honest month built on a plugged balance inherits the error.

Questions and answers

Does reconciling in QuickBooks or Xero replace the conversion check?

They check different things. The conversion check proves the file matches the statement; the software reconciliation proves the books match the file. Doing both, in that order, is what makes a month solid.

Can I reconcile several Associated Bank accounts together?

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.

What does an outstanding item mean for reconciliation?

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.

Can I reconcile from a scan?

Yes — scanned statements convert through OCR and go through the identical checks. Because OCR can misread digits, treat flagged rows on scans with extra care and always resolve them against the image.

Should I reconcile savings and CDs the same way?

Yes, with lower stakes and the same shape: opening balance, interest and any transfers, closing balance. Savings accounts statement monthly at most banks; CDs often statement quarterly or at term events. Prove each document that exists, and let the chain check span the quiet periods.