Building a settlement calendar that analysts can use

The few fields that turn a payment spreadsheet into something a currency desk can prepare against.

Building a settlement calendar that analysts can use

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.