Skip to main content
Glama

expense_budget_vs_actual

Compare actual expenses against budget allocations to identify variances and track financial performance within specified date ranges.

Instructions

Compare actual expenses against budget

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
budgetIdYes
endDateYes
startDateYes

Implementation Reference

  • The async handler function for the 'expense_budget_vs_actual' tool, which delegates to the Python ExpenseTracker.budget_vs_actual function via pythonBridge.
    handler: async (args: any): Promise<ToolResult> => { try { const result = await pythonBridge.callPythonFunction({ module: 'expense_tracking', function: 'ExpenseTracker.budget_vs_actual', args: [args.budgetId, args.startDate, args.endDate] }); return result; } catch (error) { return { success: false, error: error instanceof Error ? error.message : String(error) }; } }
  • Input schema for the 'expense_budget_vs_actual' tool, requiring budgetId, startDate, and endDate.
    inputSchema: { type: "object", properties: { budgetId: { type: "string" }, startDate: { type: "string", format: "date" }, endDate: { type: "string", format: "date" } }, required: ["budgetId", "startDate", "endDate"] },
  • src/index.ts:32-44 (registration)
    Registration of expenseTools (containing 'expense_budget_vs_actual') by spreading into the allTools array, used for MCP ListTools and CallTool request handlers.
    const allTools = [ ...excelTools, ...financialTools, ...rentalTools, ...expenseTools, ...reportingTools, ...cashFlowTools, ...taxTools, ...analyticsTools, ...chartTools, ...complianceTools, ...propertyTools, ];

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/jeremycharlesgillespie/excel-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server