← 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.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 28 | ||||
| 29 | ||||
| 30 | ||||
| 31 | ||||
| 32 | ||||
| 33 | ||||
| 34 | ||||
| 35 | ||||
| 36 | ||||
| 37 | ||||
| 38 | ||||
| 39 | ||||
| 40 | ||||
| 41 |
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