Excel Finance MCP Server

How to use

You run a local MCP server to enable connected clients (like Excel). From your Excel client, you connect to the MCP server so Excel can create smart charts, run Monte Carlo simulations, generate rolling cash flow forecasts, perform DCF analyses, and produce executive dashboards. Your client configuration points to the server endpoint, and the MCP tools execute calculations using Excel-compatible formulas for full transparency. Use the server to automate ASC 606 and SOX-compliant processes, then export audit-ready packages for external reviews. In practice, you will: connect the client to the server, trigger analytics or compliance modules from your spreadsheets, and generate professional reports and dashboards with AI-powered recommendations.

Key workflows you can enable include: creating AI-assisted charts that select the right visualizations, running Monte Carlo cash flow simulations, generating 13/52-week rolling cash flow forecasts, building DCF models with sensitivity analysis, automating ASC 606 revenue recognition, performing SOX controls testing, and producing executive dashboards with actionable insights. All calculations are formula-based and traceable within Excel so you can audit every step.

How to install

Prerequisites: make sure you have Node.js and Python installed on your machine, plus access to a terminal or command prompt. You will also need npm to install dependencies and run scripts, and pip to install Python requirements.

npm install
pip install -r requirements.txt
npm run build
npm start

Additional configuration and usage notes

You can also enable remote access via an MCP Bridge to connect a client running on a different machine. The bridge serves as a conduit between your client and the MCP server, allowing you to deploy the server in one environment and connect from another.

# Server machine
npm install && npm run build
cd bridge && npm install && npm run build
npm start  # Starts at http://localhost:3001

# Client machine - Add to Claude Desktop config:
{
  "mcpServers": {
    "excel-finance-enterprise": {
      "command": "npx",
      "args": ["@modelcontextprotocol/server-fetch", "http://your-server:3001/mcp/call"]
    }
  }
}

Examples and tools you can use

The server exposes a suite of tools that you call from your Excel environment. Examples include creating professional workbooks, AI-assisted charting, Monte Carlo simulations, rolling forecasts, DCF valuation, executive dashboards, ASC 606 automation, SOX testing, and audit preparation. You will see names like excel_create_workbook, excel_create_smart_chart, analytics_monte_carlo_simulation, analytics_dcf_valuation, compliance_asc606_revenue_recognition, and compliance_sox_controls_test.

excel_create_workbook

Create a professional Excel workbook suitable for financial modeling and reporting.

excel_create_smart_chart

AI-powered chart selection to choose the most informative visualizations based on data context.

excel_write_calculation

Write transparent, formula-based calculations that are auditable within Excel.

excel_validate_formulas

Check formulas for compliance and correctness across the model.

analytics_monte_carlo_simulation

Run Monte Carlo simulations with configurable distributions and iterations to model risk.

analytics_13_week_forecast

Generate rolling 13-week cash flow forecasts with driver-based inputs.

analytics_52_week_forecast

Produce 52-week projections with seasonal adjustments for strategic planning.

analytics_dcf_valuation

Build professional DCF models with sensitivity analysis and WACC integration.

analytics_executive_dashboard

Create AI-powered executive dashboards with insights and recommendations.

compliance_asc606_revenue_recognition

Automate ASC 606 revenue recognition including contracts, performance obligations, and disclosures.

compliance_sox_controls_test

Perform SOX Section 404 testing with statistical sampling and audit-ready evidence.

compliance_audit_preparation

Assemble complete audit readiness packages and documentation.

calculate_npv

Compute Net Present Value for investment decisions.

calculate_irr

Compute Internal Rate of Return for projects.

loan_amortization

Generate loan payment schedules and amortization plans.

calculate_financial_ratios

Analyze key financial ratios for performance assessment.

depreciation_*

Apply various depreciation methods to asset models.