
Daily Liquidity Position Analyzer
Transform raw cash data into actionable liquidity forecasts and deployment strategies
What You Can Do
This skill converts unstructured cash position data—bank balances, payables, receivables, and scheduled transactions—into structured liquidity analysis with clear decision frameworks. You'll identify liquidity gaps before they create operational friction, distinguish between structural and transactional funding needs, and receive specific recommendations for cash movements, investment opportunities, and contingency planning across multiple currencies and operational time zones.
Features
consolidates multi-currency bank balances, payables, receivables, and scheduled transactions into a unified cash position view
identifies timing mismatches between cash inflows and outflows to highlight funding shortfalls or excess positions
evaluates investment opportunities for excess cash based on maturity, returns, and operational reserve requirements
assesses credit facility drawdown needs and provides alternatives ranked by cost, timing, and operational impact
accounts for intraday payment flows and settlement windows across global operations
generates stress cases for seasonal crunches, market disruptions, or transaction impacts (M&A, debt refinancing, capex)
tests forecasted liquidity needs against existing credit lines, covenants, and facility terms
normalizes positions in different currencies and identifies concentration risks or hedging needs
Example Output
Example 1: Daily Liquidity Report
- Current Position: $47.2M (USD $32M, EUR €12M, GBP £3.5M)
- 5-Day Forecast Gap: $8.5M shortfall on Day 3 (payroll + vendor payments)
- Recommendation: Deploy $5M from money market fund, drawdown $3.5M from revolving credit facility
- Contingency: If receivables delay >2 days, activate backup facility line
Example 2: Fund Deployment Strategy
- Identified Excess: $15.3M available for 30+ days
- Options Ranked: (1) 90-day T-bills at 5.2% = $191K income; (2) Prime money market fund at 4.8% = $181K; (3) Hold in sweep account at 4.1%
- Recommendation: Deploy $10M to T-bills, keep $5.3M liquid for operational buffer
Example 3: Borrowing Impact Analysis
- Q4 Seasonal Trough: Forecast $22M gap in Nov-Dec
- Current Facility Capacity: $30M available at SOFR+150bps
- Recommendation: Drawdown $20M in November (cost ~$205K/quarter), repay in February when receivables normalize
What's Included
- SKILL.md instruction file with detailed liquidity analysis framework:
- Daily Liquidity Template: structured format for cash position data input
- Gap Analysis Worksheet: forecasting model for 5-10 day rolling positions
- Deployment Decision Matrix: ranked options for excess cash with cost/benefit comparison
- Contingency Scenario Builder: stress case templates for seasonal, market, or transaction shocks
- Banking Covenant Checklist: validation framework against credit facility terms
Who It's For
- Treasury analysts managing daily cash positions and liquidity forecasts
- Corporate controllers responsible for working capital optimization and cash management reporting
- Finance managers evaluating fund deployment and borrowing decisions across multiple currencies
- CFO/Finance leadership needing structured liquidity risk assessment and contingency planning
- FP&A professionals modeling liquidity impact of major corporate transactions or strategic initiatives
Best For
- Daily or weekly liquidity position reporting and executive cash management reviews
- Identifying and forecasting short-term liquidity gaps before they create operational friction
- Evaluating whether to deploy excess cash, draw credit facilities, or optimize cash concentration
- Analyzing intraday payment flows and settlement timing across multiple time zones and currencies
- Building contingency scenarios for seasonal cash crunches, market disruptions, or major transaction impacts
- Validating existing banking arrangements and credit facilities against forecasted liquidity needs







