Day 5: Add reconciliation checks

What you will be able to do

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

Step 1 of 8 · 1 point

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

Click and drag across cells to see their Average, Count and Sum here.

Rows 51 to 64 of 65

Name BoxB54fx