Daily Cash Position Analyzer
Consolidate multi-entity cash positions and surface liquidity risks daily
What You Can Do
You consolidate end-of-day cash positions from multiple bank accounts, entities, and currencies into a single analytical view. The skill automatically identifies concentration risks, flags liquidity gaps, highlights timing mismatches, and surfaces rebalancing opportunities—turning hours of manual compilation into minutes of actionable intelligence. You get daily cash management reports ready for CFO or Treasury Committee review, plus specific optimization recommendations for notional pooling, sweep decisions, and excess cash deployment.
Features
aggregates positions from 5+ accounts across legal entities with automatic FX conversion and rounding tolerance management
flags excess exposure by account, entity, or currency against regulatory minimums and internal policy thresholds
identifies timing mismatches between inflows, outflows, and minimum balance requirements to prevent overdrafts
consolidates net positions by currency with spot rates and highlights rebalancing triggers across jurisdictions
generates formatted summaries with key metrics, variance analysis, and action items for treasury decision-making
compares bank statement positions against GL records to surface discrepancies and timing differences
suggests sweep triggers, repatriation targets, and deployment opportunities based on consolidated view
validates minimum balance requirements, reserve ratios, and restricted fund constraints by entity and account
Example Output
Daily Cash Position Summary (2024-01-15)
Consolidated Position: $247.3M USD equivalent
| Entity | Account | Currency | Balance | Concentration | Risk Flag |
|---|---|---|---|---|---|
| OpCo US | Operating | USD | $89.2M | 36% | ⚠️ Above 30% threshold |
| OpCo EU | Settlement | EUR | €42.1M | 18% | ✓ Compliant |
| Treasury | Liquidity | USD | $64.5M | 26% | ✓ Compliant |
Key Findings:
- US operating account exceeds concentration limit; recommend sweep $15M to liquidity pool
- EUR position strength creates 2.3% favorable variance vs. prior day; consider repatriation opportunity
- Timing gap: €8.2M receivable expected tomorrow; current liquidity adequate
Actions for Today:
- Initiate $15M sweep to bring OpCo US to 26% concentration
- Evaluate €15M repatriation given favorable rates
What's Included
- SKILL.md: Complete skill definition with overview and usage triggers
- Cash Position Template: Standardized data intake sheet for multi-entity account balances, currencies, and GL coding
- Consolidation Framework: Step-by-step process for FX conversion, rounding tolerance, and intercompany eliminations
- Risk Thresholds Checklist: Regulatory and policy minimums, concentration caps, and compliance validators by entity type
- Daily Report Template: Formatted summary structure with variance analysis, action items, and CFO-ready visualization
Who It's For
- Treasury Analysts — automating daily position compilation and freeing time for strategic analysis and forecasting
- Cash Managers — identifying optimization opportunities and rebalancing triggers across accounts and entities in real-time
- CFO/Treasury Committee — receiving consolidated, risk-flagged summaries to steer intraday and strategic cash decisions
- Controllers & Financial Operations — reconciling bank positions against GL records and resolving timing differences daily
- Multi-entity Finance Teams — ensuring visibility across legal entities in different regions and currencies
Best For
- End-of-day cash position consolidation from 5+ bank accounts across multiple entities
- Identifying concentration risks against regulatory or policy thresholds
- Flagging liquidity gaps and timing mismatches between expected flows and minimum balance requirements
- Generating daily management reports for CFO or Treasury Committee decision-making
- Analyzing sweep triggers, repatriation opportunities, and excess cash deployment scenarios
You might also like
You'll design robust SCADA system architectures, configure industrial protocols (Modbus, Profibus, OPC-UA, DNP3), and diagnose connectivity and performance issues across distributed control networks. Get step-by-step configuration guidance, integration workflows, and troubleshooting decision trees tailored to your specific hardware and protocol stack.
by skillslib
You can establish systematic color grading workflows that accelerate project delivery, ensure visual consistency across episodes and projects, and maintain broadcast-quality standards. Claude generates reusable templates, quality control checklists, and grading decision frameworks tailored to your project's color science and deliverable requirements.
by skillslib
You'll build complete activation funnels by analyzing user behavior, identifying conversion bottlenecks, and designing targeted onboarding campaigns. Claude creates customer journey maps, funnel stage definitions, engagement messaging frameworks, and A/B testing strategies tailored to your product and audience.
by skillslib
Use Claude to automate your entire collection workflow, from first touch to recovery, with legally sound escalation protocols. You'll recover more money in less time, reduce bad debt write-offs by 25-40%, and build defensible collection records that withstand legal scrutiny. Claude handles customized demand letters, compliance validation, debtor profiling, and escalation strategies tailored to account age, debtor behavior, and jurisdiction.
by skillslib
You can conduct comprehensive active transportation network audits that identify missing links, connectivity gaps, and underserved communities. Claude helps you prioritize infrastructure investments against limited budgets using equity screening, mode-share modeling, and cost-benefit analysis—producing client-ready documentation and stakeholder presentations that justify infrastructure decisions with quantitative evidence rather than assumptions.
by skillslib
Turn project descriptions, timelines, and structured data into professional draw.io diagrams instantly. You can generate flowcharts, org charts, Gantt charts, swimlane diagrams, and process flows by describing what you need. Claude creates draw.io XML that you can open directly in the editor or modify further.
by skillslib
Generate customized legal documents and client communications automatically from your MyCase case data. This skill extracts case details, client information, and matter status to populate document templates, send email updates, and create batch processing workflows. Reduce manual data entry and standardize your document generation process while maintaining client communication consistency.
by skillslib
This skill helps you troubleshoot Wwise integration issues, diagnose audio performance bottlenecks, and generate comprehensive documentation for interactive audio specifications. You'll get step-by-step fixes for common implementation problems, performance optimization strategies, and best practices for audio systems across different game engines and platforms.
by skillslib