Day 5: Add reconciliation checks

Lo que podrás hacer

Write controls that say OK or CHECK, compare to the cent, and read the overall result as evidence for a few things and proof of none.

The reconciliation balances today. Will it next month, when somebody pastes in a new export and a category is spelt a new way? A control is a formula that notices for you. It cannot make a number right, but it can make a wrong number loud, which is most of what a month-end close needs. Each control you write today protects something you built this week, and one of them will say CHECK, on purpose.

0 XP

Paso 1 de 8 · 1 punto

In B54, test that the reconciliation has nothing unexplained: OK when B41 rounds to zero, CHECK when it does not.

	A	B	C
1	Larkfield Office Supplies: month-end pack, September 2026
51
52	3. Controls
53	Control	Result	What it protects
54	Reconciliation difference is explained		An unexplained difference is an error nobody has found yet.
55	Category totals equal the cash book total		A category spelt differently drops out of the summary.
56	Weekly totals equal the month		A date that did not convert falls between the weeks.
57	No bank line is waiting for action		A fee, a receipt or a repeated debit that nobody has dealt with yet.
58	Every kept line is matched or named		A line with no match and no reason is the one nobody explains.
59	Every cleaned amount is a number		A text amount is skipped by a total without any warning.
60
61	Overall
62
63	4. Questions from the lessons
64	Stock Purchases paid in the week starting 15 September	-2074.3

Haz clic y arrastra sobre las celdas para ver aquí su Promedio, Recuento y Suma.

Rows 51 to 64 of 65

Name Box (Cuadro de nombres)B54fx