Cash is the only corporate resource that can solve a crisis overnight and yet still wander off unnoticed in the bustle of normal operations. For that reason, best-in-class treasury functions run on checklists as exacting as any airline cockpit: every day, every week, every quarter the same verifications fire, irrespective of volatility or calm. This chapter assembles those checklists. It begins with the heartbeat—a daily liquidity-monitoring sheet—then expands to weekly counterparty reviews, monthly covenant rehearsals, quarterly policy attestations, and annual treasury-risk assessments. Each tool is written so that a new team member can pick it up on Monday and run tomorrow’s funding without guesswork, while an experienced treasurer can scan it for early warning signals before the markets even open.
19.1 Daily liquidity-monitoring sheet
No treasury ritual generates more value per minute than the first liquidity snapshot of the morning. Executed correctly, the sheet meets three simultaneous goals: it confirms yesterday’s cash actually arrived in the accounts, it projects today’s peak funding need before wires cut off, and it anticipates whether tomorrow’s markets will ask awkward questions about covenants or rating headroom.
Core structure
The sheet occupies a single screen—roughly 35 rows by 15 columns—to encourage immediate comprehension over forensic detail. Rows list legal-entity bank accounts rolled up into functional buckets: operating cash, collections, disbursements, payroll, restricted. Columns run chronologically across the next seven business days, with today split into three intra-day columns—opening, mid-morning update, and post-cut-off estimate—to capture intraday sweeps and late wire surprises.
Essential data lines
- Opening ledger balance for each account (system feed from the bank via BAI2 or ISO 20022 CAMT.053)
- Estimated same-day credits and debits, broken into predictable flows—AP runs, payroll, tax remittances—and variable flows such as ad-hoc wires or FX settlements
- Net cash position after sweeps but before credit-facility utilization
- Committed credit lines: limit, amount drawn, and undrawn headroom
- Overnight investment maturities and reinvestment decisions (repo, MMF, term deposit)
- Minimum liquidity covenant and rating-agency “mid-B” stress threshold, recalculated with today’s forecast
Daily rhythm
- 06:30 local headquarters time – Treasury analyst launches the auto-download job; script reconciles prior-day expected balance to actual, flags breaks > $250 k, and emails summary to the cash manager.
- 07:30 – Cash manager adds forecast inflows/outflows pulled from the ERP payment run and from sales-order backlog; sheet estimates peak intraday overdraft or idle cash by 10:00.
- 08:00 – Treasury director reviews the sheet, verifies that projected headroom exceeds covenant buffer by at least 15 %, and approves money-market placements or standby-line drawdowns via electronic signature.
- 11:00 – Mid-morning refresh; unexpected customer receipts or delayed vendor runs are logged, and FX settlement values are updated once rates fix.
- 15:30 – Final check thirty minutes before major clearing cut-offs; any residual surplus is swept to an overnight vehicle or used to pre-pay revolver balances.
- 16:30 – End-of-day reconciliation auto-runs; unreconciled variances route to the exceptions queue for follow-up before next-day opening.
Critical fields that trigger alerts
- Net available cash dips below ten days of average burn
- Aggregate counterparty exposure to any single bank exceeds 20 % of all deposits
- Same-day forecast variance versus prior-day estimate exceeds ± 5 %
- Undrawn revolving credit falls within one tranche of downstream covenant step-up
- Overnight investment maturity ladder shows more than 30 % concentration in a single week
Governance and ownership
A named analyst owns data extraction, a cash manager owns forecast assumptions, the treasury director owns decisions on placement or borrowing, and the assistant treasurer signs off on exceptions by close of business. Names appear in the header, not buried in footnotes, so accountability is obvious in every print-out or PDF snapshot.
Technology hygiene
The sheet lives in the treasury-management system, but a read-only Excel view publishes to a SharePoint folder at each refresh. Power BI surfaces headline metrics—opening cash, projected closing cash, headroom, covenant cushion—on the executive dashboard so the CFO can glance at liquidity between meetings. Manual edits are disabled; overrides require a note field that logs user ID, timestamp, and reason code, preserving SOX compliance.
Daily checklist for the analyst
- Bank feeds loaded and reconciled by 06:45
- Forecast lines updated from ERP extract by 07:15
- Variance explanations entered for any > $250 k difference
- Credit-line utilization recalculated and Color-coded
- Sheet emailed to cash manager and treasury director, link posted to dashboard
When this sheet runs on autopilot, the company wakes each morning with the same confidence an airline crew gains from a pre-flight walk-around: whatever storms gather, the treasury already knows where every dollar will land before the markets take off.
19.2 Global cash-pooling-structure blueprint
A global cash pool pulls liquidity out of scattered bank accounts and parks it where the treasurer can actually wield it—pay down revolver drawings at headquarters, fund a working-capital spike in a growth market, or invest overnight at institutional rates instead of branch rates. The art lies in designing a structure that centralizes cash without breaching local regulations, disrupting operational banking, or triggering tax leakage. What follows is a blueprint that has proved durable across industries and geographies, adaptable enough for a 40-country footprint yet disciplined enough for SOX auditors and rating-agency analysts.
The starting point is a diagnostic. Treasury maps every transactional account by legal entity, currency, and daily average balance, then overlays capital-control risk, time-zone lag, and counterparty exposure. Two ratios tell the story: the percentage of global cash idle outside the group’s top five banks and the percentage of borrowing that co-exists with surplus cash elsewhere. If either ratio tops 25 percent, the business case for pooling writes itself—interest arbitrage alone should exceed implementation cost within six months.
Architecture choices come next. Most multinationals deploy a hybrid model: physical zero-balancing within currency zones and notional aggregation across them. In practice that means each major currency has a header account—USD in New York, EUR in Frankfurt, GBP in London—and day-end sweeps drain subsidiary accounts to zero, booking overnight intercompany loans in the ERP. A multi-currency notional overlay then nets credit and debit positions across headers, allowing positive EUR balances to offset negative USD draws in the bank’s books without moving funds. Hybrid pooling delivers near-total offset while avoiding the complexity of round-the-clock daylight sweeps.
Design principles keep the structure controlled:
- Single overlay bank per currency to minimize fee grids and API pipes, but with a secondary bank ready for contingency sweeps.
- Legal-entity eligibility matrix classed green, amber, red. Green entities enter the pool on day one; amber (capital-control markets like Brazil or Korea) route through buffer accounts and manual sweeps; red (China, India) remain standalone until regulations liberalize or cross-border cash-management licenses are secured.
- Intercompany loan framework with a master agreement approved by tax and legal, interest charged at arm’s-length margin over three-month risk-free, and automatic interest accrual journals posted monthly.
- Treasury-management-system connectivity via host-to-host XML or SWIFT SCORE so sweep confirmations land in the ERP before daily batch close.
- Virtual accounts layered on top of physical cash headers to maintain entity-level visibility without exploding account counts.
Tax, accounting, and regulatory design runs in parallel. Tax ensures notional offsets do not create deemed dividend or CFC exposure and that interest reallocation follows OECD transfer-pricing rules. Accounting confirms that IFRS offsetting criteria are met so the pool nets on the balance sheet, avoiding gross-up that would inflate leverage optics. Regulatory counsel secures central-bank approvals in markets that require prior notification for zero-balance sweeping.
Implementation unfolds in four phases:
- Build-out (60–90 days) – Open header accounts, sign pooling and intercompany agreements, set cut-off times, configure TMS mapping, and run dry-run sweeps in a sandbox.
- Pilot go-live (30 days) – One region and one currency sweep nightly while parallel reporting tracks actual versus expected balances; exception handling scripts iterated daily.
- Global roll-out (90 days) – Additional entities added in fortnightly waves; each wave signs off on accounting tests and bank connectivity before the next begins.
- Stabilization (ongoing) – Daily variance reviews; monthly interest-allocation journal entry; quarterly regulatory attestation and tax-rate sanity check.
Governance relies on a tight operating cadence:
- Daily—confirm sweeps executed, review any stuck transactions, check that header balances match TMS, and approve overnight investment ladder.
- Weekly—stress-test pool headroom under P10 cash-outflow scenario; validate counterparty limits against policy.
- Monthly—allocate pool interest, reconcile intercompany loan balances, report trapped-cash metrics to CFO dashboard.
- Quarterly—run a covenant and rating-agency headroom test assuming the pool collapses for five days; file any required central-bank compliance reports.
Key performance indicators keep stakeholders honest:
- Trapped cash as a percentage of total cash (target < 10 percent)
- Net external borrowing reduced versus pre-pool baseline (target > 20 percent within year one)
- Average daily idle cash yield uplift (target ≥ 50 bps over pre-pool weighted average)
- Number of physical bank accounts closed (target 30 percent reduction year-on-year)
- Sweep failure rate (target < 0.5 percent of transactions)
Common pitfalls derail poorly planned pools. Capital-control markets can freeze repatriations—mitigated by buffer accounts and forecast-based netting. Time-zone misalignment causes daylight overdrafts—fixed by intraday sweeps in Asia before European cut-offs. Notional pools can breach regulatory thin-capitalization rules—solved by explicit loan documentation and interest charges. TMS mapping errors double-count intercompany flows—caught by reconciliation of cumulative intercompany loan ledger to header account history each month.
When these design features, cadences, and safeguards click into place, a global cash pool stops being a technical exercise and becomes a strategic asset: a continual arbitrage engine that finances growth in one time zone with surplus from another, cushions shocks without emergency borrowing, and frees finance teams from manual cash juggling so they can focus on value creation.
19.3 FX-hedging-policy template
An FX policy is the corporate constitution for currency risk. It defines why the company hedges, what it hedges, how much it hedges, and who is accountable when markets move against the plan. Without that document, the treasury desk becomes an ad-hoc trading shop; with it, every trade ladders up to a clear mandate endorsed by the board and transparent to auditors. The template below can be lifted almost verbatim into a board pack, then tailored for local regulations and rating-agency expectations.
Purpose and Policy Statement
The opening paragraph stands on its own page and seldom changes:
“The objective of this policy is to protect forecast cash flows and the balance sheet from material foreign-exchange volatility, enabling management to execute strategy without undue financial distraction while preserving shareholder value.”
Everything that follows elaborates that sentence and defines “material.”
Scope of Exposure
Paragraph form is fine, but a table helps non-treasury readers:
- Transactional exposure
- Example line item: forecast EUR sales into USD parent
- Measurement basis: rolling 18-month cash-flow view
- Hedge horizon: 12-month forecast + 6-month tail
- Balance-sheet exposure
- Example line item: CAD intercompany loan
- Measurement basis: period-end notional amount
- Hedge horizon: until loan maturity
- Translational exposure
- Example line item: net assets of UK subsidiary (GBP)
- Measurement basis: equity value
- Hedge horizon: annual consolidation
Only exposures above a quantitative materiality threshold—often 1 % of annual EBITDA or 2 % of shareholders’ equity—enter the hedge program.
Risk Appetite and Hedge Ratios
The board approves a target coverage band, framed as Cash-flow-at-Risk (CFaR) or Value-at-Risk (VaR):
- “CFaR at 95 % confidence shall not exceed 8 % of annual projected operating cash flow.”
- Coverage ratios by horizon:
- 70–90 % of next three months’ exposures
- 50–70 % of month 4–12
- 0–30 % of month 13–18 (optional rolling layer)
Explicit bands let the treasury exercise judgement while staying inside guard-rails.
Permitted Instruments and Tenors
- FX spot and forward contracts, including non-deliverable forwards (NDFs) where convertibility is restricted
- Plain-vanilla currency swaps up to five-year maturity to hedge balance-sheet funding
- Zero-cost option collars or purchased options for asymmetric risk, subject to cost caps (premium ≤ 2 % of notional)
- Prohibited: exotic derivatives (knock-ins, knock-outs), leveraged forwards, or structures embedding non-linear pay-offs unless CFO signs a written variance waiver
Tenor limits normally match the hedge horizon; anything longer requires CFO and audit-committee sign-off.
Counterparty & Documentation Standards
- Minimum counterparty rating: A- (S&P) / A3 (Moody’s)
- ISDA Master Agreement and Credit Support Annex executed before first trade
- One-way or two-way collateral thresholds aligned to rating category, monitored daily
- Counterparty limit: exposure (MTM plus potential future exposure) ≤ 10 % of group liquidity head-room per bank
Accounting Designation
All transaction hedges aspire to cash-flow hedge treatment under IFRS 9 / ASC 815. The template includes:
- Highly-effective test (prospective and retrospective) documented at trade date and each reporting period
- Hedge documentation pack: risk-management objective, strategy, hedged item, hedging instrument, method for assessing effectiveness
- OCI diary: automatically generated from treasury-management system, then reconciled to GL
Governance Roles
- Board approves risk appetite, policy, and annual review
- Audit committee reviews hedge accounting, policy compliance, and exception logs
- CFO is policy owner; approves exceptions, reports breaches within 24 hours
- Treasury director executes strategy, manages banks, maintains systems
- Risk & compliance perform quarterly independent effectiveness testing and VaR back-testing
Workflow and Controls
Pre-trade
- Exposure captured in TMS via ERP feed
- Hedge request auto-generates pre-deal ticket with exposure ID
- Counterparty limit check passes
Trade
- Two dealers’ quote; best net all-in, documented in system
- Trade booked; STP confirmation to counterparty within 30 minutes
- Hedge designation pack triggered in accounting module
Post-trade
- MTM feeds daily from counterparty portal to TMS
- Collateral calls processed by 14:00 local
- Exception report emailed 17:00 if MTM ± $250 k from prior day or hedge ratio breaches band
Reporting Cadence
Daily: liquidity sheet shows MTM by counterparty and available collateral
Weekly: VaR and CFaR versus board limit, by currency bucket
Monthly: hedge-effectiveness P&L, OCI balances, utilization of coverage bands
Quarterly: back-test actual P&L versus modelled CFaR; audit-committee pack highlights any breaches and remediation steps
Policy Review & Audit
- Annual policy refresh ahead of budget cycle; any change in risk appetite requires full-board approval.
- External auditor reviews hedge documentation and effectiveness each year; deficiencies trigger mandatory refresher training.
- After any single-day currency move exceeding 5 σ (historical), the treasury must table a ‘policy stress test’ at the next board meeting.
Quick compliance checklist for daily close
- Net hedge ratio within approved band for each currency bucket
- No counterparty exposure above limit or rating downgrade unresolved
- All new deals carry time-stamped hedge documentation in the TMS
- Collateral calls met before cut-off; variances logged
- MTM feeds reconciled to bank confirmations; differences < $10 k resolved
19.4 Bank-fee benchmarking guide
Treasury’s largest invisible leak is often the fee grid buried inside monthly bank statements. Wires, lockbox, FX spreads, credit-line commitment fees, merchant card interchange—each one seems small until multiplied across thousands of transactions and dozens of banks. A structured benchmarking program turns those fragments into a clear picture of wallet share and negotiating headroom, freeing three to five basis points of revenue every year without touching operations.
The exercise begins with a complete fee inventory. Pull the last twelve months of account analysis statements (or the local equivalent) and load them into the treasury-management system. Where banks report via AFP Service Codes, use those codes; where descriptions vary, normalize them with a taxonomy that collapses synonyms (“Out‐wire”, “Fedwire”, “USDO – Outgoing USD”). Every line should resolve to three data points: service code, unit price, and volume. For FX, capture both ticket fee and mid-market spread; for credit facilities, separate commitment, utilization, and letter-of-credit charges.
Once the raw data sit in one place, cleansing and normalization follow. Standardize currencies to the reporting currency using value-date spot, and convert unit prices to comparable metrics—per item, per million notional, or basis points on average utilization. Tag each fee with its legal entity and, critically, its service category: payments, collections, risk management, financing, e-banking access, or “other.” The category tag later drives allocation decisions when wallet redistribution becomes a negotiating lever.
Benchmarking requires a market reference. The most reliable sources are:
- Subscription surveys from treasury associations or consulting benchmarks, sliced by revenue band and region.
- RFP responses from recent bank tenders (yours and peers’)—anonymized but revealing.
- Internal best-in-class pricing from your own bank panel; one bank’s lockbox price often beats another’s by 40 %.
Convert each reference into a target range: 25th percentile, median, 75th percentile. Import those ranges into the data model so every line of the fee inventory can be Color-coded: green if at or below median, amber if between median and 75th percentile, red if beyond 75th percentile. A heat-map pivot instantly exposes which banks extract surplus and which services hurt most.
Before engaging banks, conduct a relationship wallet analysis. Total fee revenue plus net interest income gives each bank’s annual wallet share. Plot wallet shares against share of mandated services (lead arranger role, cash-pool overlay, card issuing). A bank that sits in the top-right quadrant—high wallet share, high mandate presence—is a candidate for “give-back” on pricing. A bank in the bottom-left might earn a step-up mandate if its fees are already best-in-class.
Negotiation follows a predictable cadence:
- Pre-brief: treasury director shares the heat-map with internal stakeholders—procurement, regional finance, legal—to align on opening ask and walk-away thresholds.
- Bilateral meeting: present findings to each bank, focusing on three or four fee lines, not a laundry list. Quote benchmark ranges, not competitor names, to preserve confidentiality.
- Package trade: offer compensating balances, card volumes, or ancillary mandates in exchange for fee reductions; banks prefer wallet stability to standalone cuts.
- Term-sheet update: capture concessions in an amended pricing schedule and load unit prices back into the fee system.
- Post-mortem: six weeks after implementation, verify that statements reflect the new rates; mis-keys occur in 10 % of cases.
A dashboard of ongoing KPIs keeps improvements from eroding:
- Weighted-average wire fee in USD (target ≤ $3 domestic, ≤ $12 cross-border).
- FX spread on top-five currency pairs (target ≤ 15 bp for G3, ≤ 30 bp for exotic).
- Commitment fee as basis points of undrawn revolver (target ≤ 25 bp for BBB credits).
- Total bank fee expense as % of revenue (target trend down by ≥ 5 % YoY).
- Exception count of invoice lines above benchmark quartile (target zero after three months).
Treasury reviews the dashboard monthly; any metric that flips red triggers a mini-audit of that bank’s latest statement.
A concise monthly checklist keeps the discipline:
- Import bank statements and reconcile volumes to ERP transaction counts.
- Refresh exchange rates and re-calculate benchmark gaps.
- Update wallet-share chart; flag banks whose fee share rises > 2 pp without mandate change.
- Verify that new rates from recent renegotiations appear on statements.
- Prepare quarterly management reports summarizing savings realized and next targets.
Two common pitfalls derail programs. First, focusing only on unit price and ignoring utilization—low FX spread means little if the bank wins every ticket. Remedy: track effective spread (ticket + basis points) and ensure deal allocation rotates. Second, treating fee renegotiation as a one-off project. Remedy: schedule a rolling RFP cycle—one-third of the bank panel rebid each year, keeping everyone honest without constant upheaval.
When benchmarking becomes part of the treasury operating rhythm, fee reductions compound year after year. More importantly, the company’s bargaining power becomes visible and measured, turning bank relationships into competitive supply chains rather than legacy entitlements.
Request the CFO Handbook
Table of Contents:
Part One — Understanding the CFO Role
- 1. The Evolving CFO
- 2. Strategic Partner to the CEO
- 3. Financial Stewardship & Controllership
- 4. Performance Management & FP&A
- 5. Capital Markets, Treasury & Liquidity
- 6. Investor Relations & External Reporting
- 7. M&A and Corporate Development
- 8. Enterprise Risk & Compliance
- 9. Digital Finance & Technology Enablement
- 10. Talent, Organization & Transformation Leadership
Part Two — Becoming a CFO
- 11. Required Credentials & Continuous Learning
- 12. Career Pathways & Critical Experiences
- 13. Building Strategic Relationships & Networks
- 14. Executive Presence & Communication Skills
- 15. Securing the CFO Seat & First-Year Blueprint
Part Three — The CFO Toolkit
- 16. Annual Finance Calendar
- 17. FP&A Playbook
- 18. Capital Allocation & Portfolio Management Toolkit
- 19. Treasury & Cash-Management Checklist
- 20. Investor Relations Toolkit
- 21. Accounting Close & Controls Guide
- 22. Tax Strategy Playbook
- 23. M&A Execution Toolkit
- 24. Cost & Productivity Improvement Toolkit
- 25. Working-Capital Optimization Guide
- 26. Enterprise Risk Management Framework Toolkit
- 27. ESG & Sustainability Reporting Toolkit
- 28. Digital Finance Implementation Guide
- 29. Talent & Capability Development Toolkit
- 30. Board & Audit-Committee Reporting Pack
- 31. Crisis-Liquidity War-Room Handbook