← 5 Tage zu besseren Buchhaltungstabellen
Lektion 4 von 5
Day 4: Reconcile two lists and explain the difference
Was du danach kannst
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
Schritt 1 von 8 · 1 Punkt
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 |
Klicken und ziehen Sie über Zellen, um hier Mittelwert, Anzahl und Summe zu sehen.
Rows 28 to 41 of 65
Name Box (Namenfeld)B31fx