Review an inherited reconciliation before carrying it forward

Before replacing the month in an inherited workbook, write down its purpose in one sentence. Does it explain the composition of a balance, match two independent records, calculate an estimate, or track future expense? A file can perform several functions, but each function needs a clear input and conclusion. Repeating last month's steps without that understanding can preserve an unnoticed error.

Ask the outgoing preparer which judgment took the most time, which rows require manual updates, and which apparent exceptions are intentional. Save the answers beside the affected work. If that person is unavailable, record the gaps and reconstruct the logic from contracts, postings, and earlier versions. Do not convert an undocumented assumption into an approved policy merely because it appears in an old file.

Select an item that exercises the calculation, not merely the largest unchanged row. For a prepaid schedule, follow the contract term, purchase amount, approved expense pattern, journal, and remaining balance. For a liability rollforward, inspect the original obligation and one settlement. Note where an amount is entered manually or copied from another workbook.

PCAOB AS 1215 expects audit documentation within its scope to let an experienced auditor understand the work and conclusions. That is a useful reviewability benchmark here, although an internal handoff file is not an auditor's workpaper and does not inherit the standard's retention rules.

Inspect formulas near inserted rows, hidden sheets, external links, manual overrides, and pasted totals. Confirm that the opening balance agrees with the accepted prior close and that the closing amount agrees with the current ledger. Check whether the review evidence refers to the exact file being inherited or to an older version with the same name.

Make changes in a controlled copy. Retain the original file and list the corrections so the reviewer can distinguish inherited problems from changes made during the handoff. A redesigned workbook can be easier to maintain, but changing its layout and accounting logic simultaneously makes comparison harder. First establish what the existing calculation does.

Obtain the unresolved-item list with original dates, amounts, owners, and the last meaningful action. Review items whose descriptions say only carryforward, pending, or per prior year. Determine whether each is a supported timing item, an uninvestigated difference, or an accounting judgment awaiting approval. Preserve those distinctions in the handoff record.

In a hypothetical transfer, a $12,000 balance includes $10,000 supported by a contract and $2,000 with no explanation. Accepting responsibility for future preparation does not make the $2,000 supported. Assign a separate investigation and tell the accounting reviewer which part of the balance remains uncertain. The new preparer can own the next action without certifying a conclusion the evidence does not establish.

At the first review, identify which calculations were independently checked, which sources were recovered, and which limitations remain. Ask the reviewer to approve any changed accounting assumptions separately from spreadsheet repairs. Record who now supplies each input and when it is expected so the file can be prepared without repeating the handoff interview.

Retain a concise instruction sheet covering the source locations, necessary updates, posting references, and final checks. Then have another team member locate one supporting item using that sheet. Any missing access or unexplained step can be repaired while the handoff is still active, before the next close depends on the new preparer's memory.