Your question is Monthly Ledger Reconciliation Process. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are asked to explain how you would perform a monthly ledger reconciliation in SQL and data terms. Focus on how you would tie the month’s ledger activity to a control total, identify mismatches, and handle cutoff dates, NULLs, and duplicate entries.
A month-end reconciliation is a basic finance control used to verify that recorded activity matches the expected balance before reporting is finalized. The goal is to surface exceptions quickly and distinguish true errors from timing differences.