Your question is Investigate Report Reconciliation Breaks. 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 comparing two Frontier financial reports that should tie out, but the totals differ. Explain how you would investigate the mismatch in a structured way, identify the most likely SQL/data causes, and confirm the root cause before proposing a fix.
In financial reporting, small logic differences can create large reconciliation breaks. Your answer should show how you would isolate whether the issue comes from filters, joins, duplicates, missing records, or timing differences.