How to Reconcile Banc of California Statements

What you are checking against

Banc of California statements typically organize activity by type on business accounts and chronologically on personal ones, with the period's balances printed on the first page. The institution is based in Irvine, California; its statement archive is organized per account, newest period first.

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 Banc of California month-end reconciliation workflow

Separate the two questions. Is the file a faithful copy of the statement? Is the bookkeeping a faithful copy of the file? Reconciliation answers them in that order — never let a books problem masquerade as a conversion problem, or the reverse.
Convert the month and bank the verdict. A reconciled verdict closes the first question permanently for that month. File the result with the statement so nobody has to re-ask it.
Hunt in the books with the difference as the map. If the file is proven and the books disagree, search by the difference: half of it suggests a sign error, all of it suggests a missing entry, a round number suggests a manual entry typed from memory.
Reconcile the account in the software last. Only import proven data. The software reconciliation then compares books to bank with the file already vouched for, and any residual is a short, named list.
Date and sign the month off. Record the closing balance and the date you proved it. Future-you, an auditor or a successor will ask exactly those two things.

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

Reading one Banc of California statement closely

Start a Banc of California reconciliation by reading the statement's summary block — most layouts print one. It states the opening balance, totals for each activity type, and the closing balance, which gives you four numbers to aim at before any row is touched. If the converted file reproduces the summary totals, remaining differences are categorization questions, not reading errors. The document itself comes from Statements and Documents in Banc of California online banking (website and app); reconcile only against that issued original, never against a re-export or a screenshot.

When a Banc of California statement does not tie out

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.
A transfer between two of the customer's own accounts was imported on one side only. Each account reconciles against its own statement; the pair of differences, equal and opposite, is the fingerprint.
Two accounts' statements were converted into one file — the numbers for the second account read as unexplained differences in the first. Separate the documents and check each against its own balances.
A mobile deposit was recorded in the books on the day it was made and posted by the bank two days later, landing in the next statement period — an honest timing difference that clears next month.

What to hand over at year end

A clean year-end handoff is boring in the best way: the twelve statement PDFs, the twelve converted files with their reconciliation results, and a short list of the items still outstanding at the final closing date. With that package an accountant or a successor bookkeeper can re-perform any month in minutes. The habit that creates it costs nothing — save the conversion result with the statement, every month, while the work is fresh.

Questions and answers

Which balances does a Banc of California statement print?

Deposit statements print an opening and closing balance, and most print a running balance per transaction. Card statements print Previous and New Balances instead. The reconciliation check uses whichever the statement provides; a statement with no balances at all is reported as unverified.

Can I reconcile several Banc of California 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 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.

The difference is a few cents. Is that worth chasing?

Yes. Small differences are usually misread digits or rounding on a split transaction, and they compound silently if waved through. A reconciliation that tolerates cents teaches the whole file to drift.

My Banc of California 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.