How to Reconcile BCU Statements

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

What you are checking against

A BCU statement typically opens with a per-account summary, then lists each account's transactions in date order with its own balances — members with only a share savings account may be statemented quarterly. BCU (Vernon Hills, Illinois) files its statements in the documents area of online banking, organized by account and closing date.

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.

The BCU 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 BCU statement closely

Before reconciling a BCU statement, read it once as a document rather than a data source. Find the opening balance on the first page and the closing balance where the period ends, then notice how the middle is organized — one chronological run, or sections for deposits, withdrawals and fees. That structure tells you how a difference will behave: in a sectioned statement, compare section totals first; in a chronological one, the running balance walk is your fastest instrument. The statements themselves are filed under Statements in the BCU website and mobile app, so the document you reconcile is always the bank-issued original.

When a BCU 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.
The statement's opening balance belongs to a different period — usually a gap month in the set. Check that consecutive statements chain: each closing balance should equal the next opening balance.
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 conversion was run on a print-view export instead of the issued statement PDF, and the reflowed export quietly dropped the rows that fell across a page break. Re-download the issued PDF and convert that.

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

How often should I reconcile?

Monthly, in step with the statements. Reconciling a year in one sitting is exactly the catch-up scenario the batch converter exists to shorten — and month-by-month chaining is what makes it provable.

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 BCU 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.

The difference is double a transaction's amount. What does that tell me?

A sign error: the transaction was read as money in when it was money out, or the reverse. The totals move by twice the amount because the correction has to both remove the wrong entry and add the right one.

What should I keep as evidence a month was reconciled?

The statement PDF, the converted file, and the reconciliation result for that month, filed together. That trio lets anyone re-perform the month later without asking you anything.