01 / The context
The problem behind the project.
A financial report's output can conceal a long chain of staging, adjustments, and accounting assumptions. To reconstruct reporting safely, the firm needed the behavior behind the numbers made explicit—not another independently implemented summary that might disagree.
02 / The contribution
How I approached it.
- Decomposed Aged WIP, WIP Reconciliation, Bills List, Receipts, AR Aging, and AR Reconciliation into the minimum staged sources needed to reproduce their output.
- Followed calculations statement by statement, recording intermediate outputs to locate the exact stage where results diverged.
- Compared behavior across database instances and preserved version-specific observations rather than treating a familiar-looking total as proof.
- Documented the accounting meaning behind the procedures and used the firm's own reports as the reconciliation standard.
03 / The result
What the work made possible.
A clearer, testable model of six financial-report families. This reconstruction work supplied an explicit foundation for reporting changes, reconciliation, and subsequent warehouse design while keeping discrepancies tied to their actual source behavior.
6financial-report families
Stepwiserecorded comparisons
Traceableaccounting behavior
