Description
This R script automates the creation of monthly financial KPI reports from your general ledger system. It connects to SQL endpoints to fetch P&L, balance sheet, and cash flow data, then applies GL mapping rules to categorize transactions. The script calculates key ratios such as current ratio, debt-to-equity, and return on assets, incorporating rolling averages. Using ggplot2, it produces a branded PDF report complete with trend charts, heat maps, and narrative summaries. An option exports individual KPI tables to Excel for further analysis or board presentations. Cron scheduling support enables unattended execution on Linux servers or containerized environments. Configuration files let you adjust date ranges, currency formats, and threshold alerts, which trigger email notifications. Extensive inline documentation and a quickstart guide facilitate rapid setup in RStudio or headless servers. This solution streamlines financial reporting and delivers consistent KPI reporting each period without manual effort. Recommended for CFOs, finance teams, and accounting firms seeking automated insights.
Instant download
SQL data retrieval, financial ratio calculation, PDF report creation, automated scheduling
Digital product – R script archive with dependency manifest
Finance professionals, accountants, financial analysts
