Protocol_Method — SMB Monthly Reporting

The problem

Small business financial data is often scattered across messy CSV exports with inconsistent date formats, duplicate entries, and missing periods. Analyzing these raw files directly leads to inaccurate reporting and flawed business decisions.

What it does

• Normalizes divergent date formats and column names across multiple billing, cash flow, and expense files.
• Executes data quality checks to detect and correct duplicate entries, outliers, and unexpected negative values.
• Generates a consolidated monthly performance diagnostic including revenue trends, margin analysis, and cost structures.
• Calculates cash flow health and risk metrics like DSO (Days Sales Outstanding) and seasonal liquidity gaps.
• Produces a management report with executive summaries, prioritized findings, and time-bound recommendations.

Why this beats prompting it yourself

Generic prompts often hallucinate missing data or fail to catch subtle export errors like duplicate accounting entries. This skill enforces a strict reconciliation-first workflow, ensuring the final management report is built on verified, cleaned data rather than messy raw inputs.

Use cases

• Preparing monthly or quarterly management reviews for board meetings or partners.
• Consolidating disparate billing and expense exports into a unified financial dashboard.
• Identifying cash flow risks and DSO trends to improve working capital management.
• Auditing financial exports for data anomalies and outliers before tax season.

Known limitations

Cannot calculate DSO or cash trends if treasury data is missing. Cannot perform budget variance analysis without user-provided objectives. Does not extrapolate or invent missing data periods.