Find missing days in a business bank statement archive

A folder containing twelve PDFs can still omit part of the year. One file may be a duplicate, a statement may cover a shortened period, or an account may have changed numbers after a bank conversion. Build a coverage list from the dates printed inside each statement. Filenames and download dates are useful clues, but they do not establish the reporting period.

Record the account identifier, currency, period start, period end, opening balance and closing balance. Sort the statements by their actual periods. Identify uncovered dates and overlaps before comparing the transactions with the ledger. Include inactive accounts that remained open during the period, even when management remembers little activity.

Compare each closing balance with the next opening balance using the same balance definition. A mismatch can reveal a missing statement, an account conversion, a revised statement or a transcription error. Read the bank's labels carefully: available funds and ledger balance can differ. A mismatch between two different measures is not evidence that cash vanished.

For a hypothetical account, a March closing balance of $24,800 followed by an April opening balance of $19,300 leaves $5,500 to explain. That difference is a research lead, not an expense entry. Check whether the April file actually starts several days into the month and whether the bank issued a separate transition statement. Preserve the original files while requesting clarification.

Give the bank the account suffix, exact dates and the type of record required. Ask separately for statements, transaction histories and check images if each is needed. An online transaction export may fill a working-paper gap while a formal statement is being retrieved, but label the substitution and its limitations. Record who supplied it and when.

The IRS explains that supporting business records include deposit information, invoices, account statements and payment evidence. Several documents may be needed to substantiate a transaction. Use that principle when rebuilding an incomplete period: a spreadsheet prepared from memory should not replace documents that establish the actual movement of funds.

Compare recovered transactions with entries already posted from the bank feed, card processor or manual records. Match using amount, date, reference and the underlying document. When statement periods overlap, identify the shared transactions before importing a new file. Keep an import log showing the selected date range and the number of rows reviewed.

If the missing evidence changes an already closed period, ask the accountant to assess the correction and any affected reports. Avoid inserting an unexplained opening-balance adjustment solely to make the next reconciliation agree. The correction record should explain the original gap, the evidence recovered, the entries changed and the reviewer who accepted the result.

Assign one person to collect statements and another to confirm that every account on the bank register has a covered period. Store the coverage list with the reconciliation pack. A newly opened, renamed or closed account should trigger an update to both the register and the collection responsibility.

Where an outsourced accounting team collects records, agree who contacts the bank when access fails. The handoff is complete when the missing dates have been resolved or remain on an explicitly owned exception list. Include the next follow-up date so an unavailable statement does not disappear behind a report marked finished.