An automated tool for transforming project expense Excel files into structured cost analysis reports categorized by client and expense type.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install cost-report-generator
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install cost-report-generator using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Cost Report Generator?
The Cost Report Generator is a specialized addition to the Openclaw Skills ecosystem designed to streamline financial reporting. It automatically processes complex project expense files (such as EVP Project Expenses.xlsx) and generates multi-year cost analysis reports. The skill is specifically tuned to recognize key customer segments like BAT, MT, and ITMS while providing deep dives into labor, manufacturing, and testing costs.
By leveraging this skill, teams can eliminate manual data entry and formatting. It calculates annual summaries, monthly averages, and detailed breakdowns for 2025 and 2026, ensuring that financial data is not just organized but also visually optimized for executive review with professional Excel styling.
Cost Report Generator Use Cases
- Uploading project expense files to generate instant cost analysis reports.
- Extracting and refining costs based on specific customer classifications.
- Organizing messy project expense spreadsheets into structured financial summaries.
- Calculating monthly averages and year-to-date totals for budget tracking.
How Cost Report Generator Works
- The skill identifies a trigger, such as an uploaded Excel file or a request to organize project costs.
- It scans the source Excel file, specifically looking for the header on the 4th row (index 3) and valid customer categories.
- Data is parsed and categorized into groups like HR Expenses, Trial Production, Testing, and Development Investments.
- It performs logical calculations for monthly averages based on the available data points for the specific year.
- A formatted Excel report is generated with themed headers, color-coded summaries, and currency formatting.
- The final report is saved to the specified output directory or the source file location.
Cost Report Generator Setup
To use this skill within your environment, ensure you have the script in your workspace. You can run it directly via the CLI:
# Direct script execution
python3 ~/.openclaw/workspace/skills/cost-report-generator/scripts/generate_cost_report.py <source_file_path> [output_directory]
# Example
python3 ~/.openclaw/workspace/skills/cost-report-generator/scripts/generate_cost_report.py ~/Desktop/EVP_Project_Expenses.xlsx
Alternatively, install it via ClawHub:
clawhub install cost-report-generator
Cost Report Generator Data Schema & Taxonomy
The skill expects a source Excel file with specific columns and follows a strict output structure:
Required Input Columns
- Customer Category: (e.g., BAT, MT, ITMS)
- Project Category: Project name or type
- Internal Order Number: Unique order ID
- Expense Columns: Formatted as
{Year} Year {Month} Month {Type}(e.g., 25 Year 1 Month Labor Cost)
Output Report Structure
| Sheet Name | Content Description |
|---|---|
| 2025 Cost Analysis | 12-month data breakdown by customer |
| 2026 Cost Analysis | Q1-Q2 data (Jan-Feb) breakdown by customer |
Calculation Logic
- 2025 Average: Annual Total / 12
- 2026 Average: Annual Total / 2 (based on current 2-month data availability)
Cost Report Generator Advanced Features
- Custom header indexing for non-standard Excel templates.
- Automated CSS-like styling for Excel (Deep Blue headers, Yellow highlights for totals, and Green for monthly sums).
- Multi-user sharing via ClawHub publishing or shared team workspaces.
- Dynamic divisor logic for monthly averages that adjusts based on actual data presence.
- Integration support for Python scripts to programmatically generate reports within larger Openclaw Skills workflows.
SKILL.md
Loading
Related Openclaw Skills
BI2 Business Operating Analysis Report Generator
An automated tool that transforms PPTX screenshots into comprehensive, 10-dimension HTML business operating analysis reports.
Dreaming Optimizer
A sophisticated memory consolidation engine that uses an REM-inspired six-step process to refine and persist AI agent knowledge.
System Design Architect
A professional-grade system design architect skill offering 20+ classic architecture patterns with detailed diagrams, technology selection, and capacity planning guides.
Memory Health Check
A comprehensive diagnostic and optimization suite for maintaining the integrity, performance, and freshness of AI agent memory databases.
YouTube Title Optimizer
A high-performance title generation engine designed to increase video click-through rates and search visibility through algorithmic optimization.
Code to Music
An innovative tool that analyzes code structure and maps its characteristics to musical parameters to generate a unique code symphony.
Featured*
