Bank Reconciliation Open Item Log Workflow

A bank reconciliation can balance while questions remain about the timing, source, or treatment of individual transactions. Those questions need somewhere to live after the reconciliation worksheet is prepared. A bank reconciliation open item log keeps each unresolved difference attached to its evidence, owner, next action, and final disposition.

Administrative support can maintain that log, retrieve records, and prepare questions under a written procedure. The accounting owner still decides adjustments, classifications, suspected fraud matters, and any exception that requires professional judgment.

bank reconciliation open item log

Create one row for each difference that cannot be cleared from the records available to the preparer. The row should name the bank account and statement period, identify the transaction, preserve both the bank and book amounts, and show the difference between them. It should also point to the source documents already checked.

Do not combine unrelated differences into a single line called "reconciliation issue." An outstanding check, deposit in transit, bank fee, duplicate book entry, and unfamiliar withdrawal lead to different evidence and decisions. Separate rows let the reviewer see which items are timing differences, which need a book correction, and which must stop for investigation.

The log is not the reconciliation itself and does not authorize an entry. It is the working record for items that remain open after the bank activity and books have been compared.

Open an item from the reconciliation evidence

Begin with the approved bank statement or bank data and the accounting record for the same account and period. Record the statement ending date and the date the comparison was performed. If the organization uses a reconciliation ID, include it so a reviewer can return to the exact workpaper.

Name the transaction with a stable reference such as check number, deposit batch, bank transaction ID, journal entry ID, or payment reference. A description copied from the bank feed may help with searching, but it should not replace the source reference. If the source is missing, say which source is missing instead of guessing what the transaction represents.

Record the observed bank amount and book amount in separate fields. A blank value is different from zero, so the procedure should say how to represent an absent entry. Calculate the difference consistently and retain the sign convention used by the reconciliation workpaper.

Use fields that answer the next review question

A useful log gives the accounting owner enough context to act without reopening every email thread. It stays concise because detailed statements, checks, invoices, deposit records, and journal support remain in their approved systems.

Log field	What to record	Why the reviewer needs it
Account and period	Approved account reference and statement ending date	Connects the item to the correct reconciliation
Transaction reference	Check, deposit, bank transaction, payment, or journal ID	Locates the event in the source records
Bank amount	Amount and date shown by the bank source	Preserves one side of the comparison
Book amount	Amount and date shown in the ledger or subledger	Preserves the other side of the comparison
Difference	Reproducible calculation using the written sign rule	Shows what remains unexplained
Item type	Controlled category allowed by the procedure	Routes the item without deciding its treatment
Evidence checked	Safe links or IDs for the records reviewed	Prevents repeated searching and supports review
Owner and next action	Named role, requested decision, and follow-up date	Makes responsibility observable
Resolution evidence	Approved disposition and final system reference	Proves why the row was closed

Use controlled item types only when the facts fit; for example, "check not on statement" describes an observation. "Valid outstanding check" may imply a conclusion that the designated accounting owner has not yet made. Keep the first description factual and record the owner's later disposition separately.

Separate timing items from errors and unknown activity

A transaction present in the books but absent from the current statement may be a timing item. The log should show its transaction date, reference, amount, and the later evidence expected to clear it. Do not close it merely because someone labels it outstanding; close it when the written rule is met and the required evidence is available.

A transaction present on the bank statement but absent from the books needs a different route. It could be a bank charge, interest, a deposit, an automatic payment, or activity that the preparer cannot identify. The coordinator may gather statement detail and related records, but the accounting owner decides whether an entry is needed and which accounts or period apply.

When the bank and books contain the same transaction with different amounts, preserve both values. Do not overwrite one side to make the row look reconciled. Record the exact discrepancy, source IDs, and any calculation that can be reproduced under the written procedure.

Unknown withdrawals, altered payee information, unexpected transfers, and possible duplicate payments should enter the organization's security or fraud escalation route immediately. The log may retain a safe reference and status, but routine follow-up should not delay the designated response.

Record status as an observable condition

Statuses should tell the next person what is true now. Useful states include missing source, ready for owner review, waiting for bank evidence, waiting for internal evidence, correction authorized, correction posted, expected to clear next statement, and closed with evidence. Define the entry and exit rule for every state.

Avoid a general "pending" status. It hides whether the team is waiting for a bank record, an invoice, an accounting decision, or a posted correction. Keep the owner and next permitted action beside the status, and retain the original open date when the item changes hands.

Age the item from the date it first became unresolved, not the latest reminder. If a timing item survives into another statement period, link the new evidence to the original row or follow the organization's documented rollover rule. Recreating it as a new item can hide how long it has remained open.

Close the row with evidence, not activity

Each item type needs a written closure rule: a timing item may close when it appears on a later bank statement and matches the recorded transaction. A book error may close after an authorized correction is posted and the accounting record is checked. An unfamiliar transaction may require a documented owner disposition through a separate investigation process.

A reminder sent, an email answered, or a status changed does not prove resolution. Record the final source reference, the disposition authorized by the owner, the person who verified the result, and the verification date. Preserve the earlier observation and any correction history.

Reperform the difference calculation before closure. If the correction creates a new variance or the final amount differs from the instruction, keep the item open and route the new discrepancy. The log should show what happened, not force every case into a clean ending.

Apply the IRS recordkeeping guidance carefully

IRS Publication 583 explains that a business may use a recordkeeping system suited to the business if it clearly shows income and expenses. Its computerized-record guidance says records must provide enough detail to identify underlying source documents and must reconcile with the books and return. The publication's bank reconciliation example compares deposits and canceled checks, accounts for outstanding items, identifies a recording error and bank service charge, and reaches equal adjusted balances.

That IRS example illustrates recordkeeping and reconciliation. It does not prescribe this open item log, define approval roles, or decide the accounting or tax treatment of a particular difference. The business should set its close timetable, retention rules, evidence standards, and decision authority with qualified accounting and tax advice where needed.

Keep statements and detailed bank records in approved systems. The log can use safe account labels, transaction references, amounts, dates, owners, and source links without becoming a broadly accessible copy of sensitive banking information. Before assigning access, document it with the virtual assistant access checklist.

Review the log as part of month end close

The reconciliation owner should review all open rows before the period is signed off. Check that every difference traces to the current reconciliation, the calculation can be reproduced, the item type describes observed facts, and the next action belongs to the named owner. Confirm that no preparer has recorded an accounting conclusion beyond the written procedure.

Review older items separately. Ask why they have not cleared, whether the expected evidence still makes sense, and whether the escalation date has passed. Repeated old checks, deposits, bank charges, or unexplained differences may point to a weak source process, but the log alone does not establish the cause.

Sample closed rows against the bank evidence, books, authorization, and final reference. Keep any review correction with the row. The month end close document checklist can place this review beside the other records needed for close.

Define the recurring support boundary

A trained coordinator can create rows from a completed comparison, enter observed values, calculate differences under a fixed rule, retrieve named documents, send approved follow-ups, prepare owner questions, and record authorized outcomes. The work fits recurring virtual support when account access, item types, evidence requirements, closure rules, escalation owners, review samples, and backup coverage are documented.

Accounting staff retain reconciliation approval, journal approval, account classification, cutoff decisions, write-offs, fraud response, and any judgment about whether an item is valid. Teams evaluating recurring preparation can review the scope of HireBackOffice bookkeeping assistants while keeping those decisions with authorized owners.

Test the procedure with a deposit in transit, an outstanding check, a bank charge absent from the books, a mismatched amount, and an unfamiliar withdrawal. A backup coordinator should be able to identify the last verified event, current owner, next permitted action, missing evidence, and closure rule from the log and procedure alone.

Frequently asked questions

What belongs in a bank reconciliation open item log?

Include the account and statement period, transaction reference, bank amount, book amount, calculated difference, factual item type, source records checked, current owner, next action, and resolution evidence. Keep detailed bank documents in the approved source system and use controlled references in the log.

Who owns unresolved reconciliation differences?

The procedure should name an accounting owner for each exception route. Administrative support may prepare the evidence and record the owner's instruction, but it should not select accounting treatment, approve an adjustment, or decide whether unfamiliar activity is legitimate.

When can an open item be closed?

Close it only when the written rule for that item type is satisfied and the result points to final evidence. A later statement may clear a timing item, while an error may require an authorized and verified book correction. A reminder or status update is not enough.

Can a virtual assistant maintain the log?

Yes, when the role has limited access, written field rules, clear stopping conditions, named decision owners, and sampled review. Consequential accounting and security decisions remain with authorized staff.

This article provides general operational information. It is not legal, tax, accounting, employment, insurance, privacy, or security advice.