dr-departments

Analyze departmental P&L statements and generate Excel and PowerPoint reports.

3|3|Updated Feb 1, 2026
One-click install
npx skills add https://github.com/Datarails/dr-claude-code-plugins-re --skill dr-departments
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dr-departments
Source: https://github.com/Datarails/dr-claude-code-plugins-re/tree/main/skills/departments
Command: npx skills add https://github.com/Datarails/dr-claude-code-plugins-re --skill dr-departments

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the analysis of Profit & Loss statements and performance metrics for individual departments, streamlining reporting and comparative analysis.

Core Features & Use Cases

  • Departmental P&L Analysis: Generates detailed reports on revenue, expenses, and net contribution for each department.
  • Comparative Reporting: Facilitates year-over-year comparisons and variance analysis against budgets.
  • Output Generation: Creates professional Excel spreadsheets and PowerPoint presentations for management reviews.
  • Use Case: Generate a comprehensive departmental performance review for the fiscal year 2025, highlighting key financial and operational metrics for each team.

Quick Start

Analyze departmental performance for the year 2025.

Frequently Asked Questions about dr-departments

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze P&L by department for fiscal year 2025?

To analyze P&L by department for fiscal year 2025, this Skill automates revenue, expense, and net contribution reporting, generating detailed performance metrics for each team. It requires Datarails Finance OS tools to aggregate data and format the final outputs.

Can I generate Excel and PowerPoint outputs for departmental financial reporting?

Yes, you can generate Excel and PowerPoint outputs for departmental financial reporting. The Skill creates professional spreadsheets and presentations directly from your P&L data, specifically formatted for management reviews and variance analysis.

How does variance analysis work for budget vs actual departmental performance?

Variance analysis for budget vs actual performance compares planned budgets against real departmental revenue and expenses. The Skill calculates these financial discrepancies and highlights key operational metrics, allowing you to identify significant deviations for individual departments.

Do I need Datarails Finance OS to run year-over-year P&L comparisons?

Yes, you need Datarails Finance OS to run year-over-year P&L comparisons. The Skill depends on these specific tools to perform the underlying data aggregation and output formatting required to generate your comparative departmental financial reports.

What is the best way to automate departmental comparative reporting?

The best way to automate departmental comparative reporting is using a Skill that processes P&L statements directly to calculate net contributions and variances. This approach streamlines year-over-year comparisons and budget analysis without manual spreadsheet manipulation.

What specific metrics are included in a departmental P&L analysis?

A departmental P&L analysis includes specific metrics for revenue, expenses, and net contribution. The Skill also calculates budget vs actual variance and year-over-year financial comparisons, providing a comprehensive performance review for each department.