Building a settlement calendar that analysts can use
The few fields that turn a payment spreadsheet into something a currency desk can prepare against.
The fastest way to waste a briefing is to arrive with a vague sense that “USD invoices go out most Thursdays.” Analysts prepare against dates, amounts, and currencies — not moods.
Minimum useful fields
For each expected flow, list:
- Currency and approximate amount
- Due date or preferred instruction day
- Counterparty type (supplier, customer, intra-group)
- Whether a forward or option already covers part of it
That grid is enough to decide between a single Settlement Window Briefing and a standing Weekly Currency Monitoring retainer.
Common gaps we see
Teams omit intra-group recharges, forget card settlement lags in hospitality, or list invoice dates without noting when the bank must receive instruction. Each gap forces the desk to ask follow-up questions and delays the written note.
Sharing it safely
You do not need to send full bank statements. Rounded amounts and week-level dates are usually fine for trend preparation. If confidentiality is tight, bring a printed one-pager to the Asoke office rather than emailing details.
A clean calendar shortens every later consultation. If you want help turning your current sheet into a watchlist, start with Pair Watchlist Setup.