Capstone · Finance at a small online shop

Close the month for an online shop

Finance closes the month from three exports: order lines, customer master data and payments. Last month's report double-counted refunds and dropped orders from customers who signed up late.

Your job is to produce clean order lines and payments, an exception report finance can act on, and a short note on what the source systems should fix.

Checkpoints

1. Clean order lines with exceptions by reason.
Clean an order-line export
2. Payments matched to accounts; orphans reported.
Referential integrity with explicit exceptions
3. Large transactions flagged for review, refunds kept.
Flag large transactions, keep refunds
4. Totals per currency, never mixed.
Sum amounts by currency, without converting

Final quality report

Write it in your private notes below (saved to your account) or in your own document. It isn't auto-graded; use it to practise the handoff interviewers ask about.

Reconciliation for each export (input = clean + exceptions).
Exception counts by reason and who should fix each.
Assumptions, such as how naive timestamps were handled.
Two source-system changes that would remove most exceptions.