Cash & Nostro Reconciliation

# Cash & Nostro Reconciliation

**Role relevance:** Reconciliations / middle office take-home
**Estimated time:** 50 minutes
**Difficulty:** Intermediate
**Format:** Excel (.xlsx)

## What you are given
- cash_nostro_reconciliation_starter.xlsx with an internal ledger and a nostro statement that do not tie out
- A stated 2.00 matching tolerance and both opening balances

## What you must deliver
1. A matched item list with a difference per reference
2. A cash-specific classification for every break
3. A control total that ties the net unreconciled figure to the balance difference
4. The item you would chase first, with a reason

## Constraints & assumptions
Match on reference then amount, within tolerance. Use an outer match so one-sided items stay visible. The net unreconciled total must equal the balance difference - do not plug it.

## Submission note
Complete the starter file, then compare your work against the mark scheme.