Finance analyst interview: defend the close
Practise billing, payment status, receivables and concentration questions with the definitions a finance interviewer will probe.
Practise each question under time pressure, then explain your assumptions, data grain and edge cases aloud before comparing solutions.
Start interview practice→ 02
→ 03
Your exercises
01An interviewer asks which customer balances need collection. For accounts with open invoices, return company and the sum of open invoice amount as open_balance, ordered from highest balance to lowest.
The hiring manager wants paid invoice amount by billed month. Return invoice_date and the sum of amount as paid_amount for paid invoices only, ordered by invoice_date ascending.
At 1 October 2026, finance flags open invoices billed before 1 September 2026. Return company, invoice_date and amount for those invoices, sorted by invoice_date oldest first and company alphabetically.
Find the five customers with the most paid invoice amount. Return company and total_paid, rounded to two decimals, highest first. Include only paid invoices.
For each invoice_date, return invoice_date, total non-void billed amount as billed and paid invoice amount as paid_amount, both rounded to two decimals. Sort by invoice_date ascending.