How to Reconcile Bank of Hawaii Statements

What you are checking against

A Bank of Hawaii statement typically runs as one dated history — deposits, withdrawals and fees in posting order — with the balance shown per transaction on most layouts. Bank of Hawaii (Honolulu, Hawaii) files its statements in the documents area of online banking, organized by account and closing date.

Reconciliation fails in instructive ways, which is why it is worth doing before import rather than after. A difference the size of one transaction means a row is missing or doubled; twice a transaction means a sign flipped; a few cents means a digit was misread somewhere. The check on this page reports which pattern a statement fell into by naming the rows where the running balance breaks, so the hunt starts at the right row instead of the first page. The methodology page explains the arithmetic in full.

The Bank of Hawaii month-end reconciliation workflow

Check the chain link before the month. This month's opening balance must equal last month's closing balance as proven, not as remembered. A mismatch here means the problem is older than this month.
Convert, then trust the verdict's direction. Reconciled means import with confidence. Flagged means the marked rows are the workload. Unverified means the statement printed no balances, so add a manual total before importing.
Resolve every flag against the document. The statement PDF is the only authority. Correct the file to match it, never the other way round, and never adjust the books to an unproven file.
Close in the software to the same closing figure. Reconcile the account to the statement's closing balance and date, with outstanding deposits and cheques listed by name.
Carry the exceptions forward in writing. Anything outstanding at this closing date becomes next month's opening checklist. Written down, it is a five-second check; remembered, it is next quarter's mystery.

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

Reading one Bank of Hawaii statement closely

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

When a Bank of Hawaii 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.
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.
An interest credit or cashback posting lands on the closing date, after the last transaction row in some layouts — present on the statement, easy to miss in a manual total.

Teaching the routine to a successor

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.

Questions and answers

Can I reconcile several Bank of Hawaii 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.

The difference is exactly one transaction's amount. Where is it?

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.

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.

My Bank of Hawaii statement shows a running balance but my software disagrees mid-month while agreeing at the end. Problem?

Usually not an error: running balances depend on the order transactions are walked, and the software may order same-day items differently from the bank. Agreement at the closing balance with every transaction present is the substance; mid-month ordering differences on the same posting date are cosmetic.