← 5 días para mejores hojas de cálculo contables

Lección 4 de 5

Day 4: Reconcile two lists and explain the difference

Lo que podrás hacer

Compare the bank balance with the cash book balance, put every item that explains the gap on its own line, and finish with nothing unexplained.

The bank statement ends at $31,333.55 and the cash book at $30,821.40. Both are honest, and they are $512.15 apart. A reconciliation is not a hunt for the one error: it is a short list of reasons, each with an amount, that together account for the whole gap. You are finished when the unexplained line reads 0.00. The labels you built on Day 2 do most of the work.

0 XP

Paso 1 de 8 · 1 punto

The opening balance is in B30. In B31, return the bank's closing balance: the opening balance plus every amount on the statement.

ABCD
1Larkfield Office Supplies: month-end pack, September 2026
28
292. Bank reconciliation at 30 September 2026
30Opening balance, 1 September (both records)18,250.00
31Balance per bank statement
32Balance per cash book
33Difference to explain (bank minus cash book)
34
35What explains it (the effect of each on bank minus cash book)
36In the books, not yet on the bank (timing)
37On the bank, not in the books
38Debited twice by the bank
39Amount keyed wrongly in the books
40Total explained=SUM(B36:B39)
41Unexplained difference=ROUND(B33-B40,2)
Haz clic y arrastra sobre las celdas para ver aquí su Promedio, Recuento y Suma.
Rows 28 to 41 of 65
Name Box (Cuadro de nombres)B31fx