On this page
Lesson details
- Estimated study time
- 1 hr 30 min
Learning objectives (2)
A spreadsheet can produce thousands of ratios from a bad join. This lesson puts the join under control before the first formula.
What you will be able to do
You will build a three-period comparison contract, distinguish date-specific positions from period flows, verify statement equations, tie each opening position to the prior ending position, and stop when a material difference has no evidence-supported bridge.
Label every column
For each source column, record:
| Control | Question |
|---|---|
| Entity | Which legal or reporting group does this amount describe? |
| Date or period | Is this a December 31 stock or a full-year flow? |
| Currency and units | USD, EUR, whole units, thousands, or millions? |
| Definition | What exact line, scope, and sign convention is used? |
| Basis | Which accounting policies and classifications matter? |
| Version | Original, amended, restated, or reclassified? |
Accounting students should trace these controls to statement headings and notes. Finance students should treat them as the data contract for every later comparison.
Test articulation and continuity
Rebuild assets and liabilities plus equity from supplied components at every date. Then compare Year 2 opening values with Year 1 ending values line by line. Repeat for Year 3. Equal totals are insufficient: a $1,000 receivable error and a $1,000 cash error can offset.
Open the packet audit and reproduce its Aster controls. The typed calculation rejects an unbalanced position and any unexplained break between adjacent periods.
Decide whether a difference is analytical or contaminating
A larger Inventory balance can be a real fact to analyze. A line moved from Inventory to another asset only in one column is a classification difference to bridge first. A major acquisition can be both a real event and a reason that a simple average poorly represents the year.
Use one of three dispositions:
- Proceed: inputs are aligned for the stated question.
- Repair and disclose: a supported conversion, reclassification, or restatement bridge makes the line comparable.
- Stop or narrow: missing evidence prevents the intended comparison.
Practice and exit check
Complete the alignment diagnostic. Then write one sentence explaining why a balanced equation does not prove that the classifications or period join are correct.
Graduate discussion prompt: identify how an acquisition completed late in Year 3 could leave the equation and continuity checks intact while weakening average-balance turnover measures. This prompt has no single numeric answer. One defensible path observes that an acquired balance enters the ending stock even though the acquired operation contributed only part of the year's flow; the simple two-point average can therefore misrepresent time-weighted resources.