Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Treasury & Cash Management

New in v0.7.0

DataSynth generates comprehensive treasury operations data covering cash positioning, forecasting, hedging, debt management, and intercompany netting.

Overview

The treasury module simulates corporate treasury operations:

  1. Cash Positioning — Daily cash balance aggregation by entity, account, and currency
  2. Cash Forecasting — Probability-weighted forward-looking cash projections
  3. Cash Pooling — Physical, notional, and zero-balance pooling structures with sweep transactions
  4. Hedging — FX forwards, interest rate swaps, and options with ASC 815 / IFRS 9 hedge designations and effectiveness testing
  5. Debt Management — Loans, bonds, and credit facilities with covenants and amortization schedules
  6. Netting — Intercompany multilateral netting runs with per-entity settlement positions

Data Models

ModelDescription
CashPositionDaily cash balance by entity/account/currency
CashForecast / CashForecastItemProbability-weighted forward-looking projections
CashPool / CashPoolSweepPooling structures (physical/notional/zero-balance)
HedgingInstrumentDerivatives (FX forwards, IR swaps, options)
HedgeRelationshipASC 815 / IFRS 9 hedge designations with effectiveness testing
DebtInstrumentLoans, bonds, credit facilities
AmortizationPaymentIndividual payments in amortization schedule
DebtCovenantFinancial covenants (Debt/Equity, Interest Coverage, etc.)
BankGuaranteeLetters of credit and bank guarantees
NettingRun / NettingPositionIntercompany multilateral netting

Configuration

treasury:
  enabled: true
  cash_positioning:
    enabled: true
    frequency: daily
  cash_forecasting:
    enabled: true
    horizon_months: 6
    confidence_levels: [0.50, 0.75, 0.90]
  cash_pooling:
    enabled: true
    pool_type: physical          # physical, notional, zero_balance
  hedging:
    enabled: true
    fx_forwards: true
    ir_swaps: true
    options: true
    effectiveness_method: dollar_offset  # dollar_offset, regression, hypothetical_derivative
  debt:
    enabled: true
    term_loans: true
    bonds: true
    revolving_facilities: true
  netting:
    enabled: true
    frequency: monthly
  bank_guarantees:
    enabled: true
  anomaly_rate: 0.02

Output Files

FileDescription
cash_positions.csvDaily cash balances
cash_forecasts.csvForecast headers
cash_forecast_items.csvForecast line items (probability-weighted)
cash_pool_sweeps.csvPhysical sweep transactions
hedging_instruments.csvDerivative contracts
hedge_relationships.csvHedge designations & effectiveness
debt_instruments.csvLoans & bonds
debt_covenants.csvFinancial covenants
amortization_schedules.csvPrincipal & interest payments
bank_guarantees.csvLC & guarantees
netting_runs.csvIntercompany netting runs
netting_positions.csvPer-entity settlement positions
treasury_anomaly_labels.csvData quality labels

Process Mining (OCPM)

The treasury module contributes 4 object types and 4 activities:

  • Object Types: cash_position, cash_forecast, hedge_instrument, debt_instrument
  • Activities: Cash position calculation, forecast generation, hedge designation, debt issuance
  • Lifecycle: Instruments follow creation → active → matured/terminated paths