A production-grade Excel add-in that normalizes exported reports from Frontline CA ERP systems into clean, analysis-ready datasets.
Many of Frontline CA ERP's reports do not export in a structured, Excel-friendly format. ReportTools converts those raw exports into normalized, tabular datasets suitable for pivot analysis, reconciliation, audit workflows, and downstream data validation — without modifying the source worksheet.
- ReportTools for Frontline CA ERP
Each module targets a specific ERP export format and normalizes it into a flat, tabular dataset. Modules are written to tolerate header variations, footer noise, multi-line record blocks, and common ERP formatting inconsistencies.
| Module | Report | Output Description |
|---|---|---|
Pay03 |
Payroll Summary | Normalized payroll summary rows |
Pay13 |
Payroll Adjustments by Employee | One row per code entry per employee, with optional budget code and retirement system fields |
Pay14 |
Net Pay / Deductions | One row per employee per deduction/contribution item |
Ben02 |
Benefits | One row per employee per benefit provider and level |
Pos04 |
Position Control | One row per employee per budget code allocation |
Fiscal05 |
Fiscal Conversion | Normalized fiscal conversion report rows |
Each module is accessible from the ReportTools ribbon tab via a workbook and sheet picker — no manual sheet wiring required.
ReportTools is structured as a two-part system:
Contains all report transformation logic and the RibbonX UI.
- Picker architecture: each report entry point prompts for a source workbook and sheet, then passes a
Worksheetreference to a private worker procedure - Never operates on
ThisWorkbook: all logic is scoped towsSrc.Parentto avoid side effects - Performance-first design: array reads, bulk writes, calculation guards, and
ScreenUpdatingguards throughout - No external service calls, no dynamic code execution, no obfuscation
Responsible for update management, Core validation, and versioning. Designed for enterprise deployment scenarios where IT manages distribution centrally.
This project is built for use in audited financial environments where behavior must be predictable and traceable.
- Deterministic transformations — the same input always produces the same output
- No silent failures — anomalies are flagged in output, not quietly discarded or corrected
- No hidden behavior — no external calls, no dynamic execution, no obfuscation
- Reproducible builds — the distributed
.xlamis always generated from source via a documented build script
The goal is to make this tool acceptable in managed IT environments, county offices of education, public school districts, and audited financial operations.
The add-in is built from source using a PowerShell script and Excel COM automation. The distributed .xlam is never hand-edited.
build/build_core.ps1
Steps:
- Copies
CoreTemplate.xlamtodist/ - Clears existing VBA components from the copy
- Imports all modules from
src/vba/ - Injects RibbonX from
src/ribbon/CustomUI14.xml - Saves the production-ready
.xlam
Development requirement: Excel's Trust Center must have "Trust access to the VBA project object model" enabled.
See docs/DEVELOPMENT.md for the full development and release workflow.
- Download
ReportTools_Core.xlamfrom the latest release - Open Excel → File → Options → Add-ins
- At the bottom, select Manage: Excel Add-ins → Go
- Click Browse, locate the downloaded
.xlam, and click OK - Ensure ReportTools appears checked in the list
- Macros must be enabled
The ReportTools tab will appear in the Excel ribbon.
The add-in can be deployed via Group Policy or SCCM by placing the .xlam in a shared network location and configuring the OPEN registry key under the Excel startup path. See Microsoft's documentation on deploying Excel add-ins.
ReportTools is under active development. The following milestones define the path to a stable v1.0.0 release.
- Additional HR/Payroll report modules (in progress)
- Additional Finance/Fiscal report modules (in progress)
- Full module test coverage with known-good reference exports
-
ReportTools_Launcher.xlam— update management and Core validation - Version check on startup
- Graceful handling of Core load failures
- Self-signed code certificate applied to release artifacts
- SHA-256 checksums published with each release
- Build script extended to generate checksum automatically
- End-user guide per report module
- Managed IT deployment guide
- Contributor guide
v1.0.0 will be the first release recommended for production deployment in managed environments.
Production-signed releases with SHA-256 checksums are planned for v1.0.0. Pre-release builds are unsigned and intended for evaluation and testing only.
Organizations evaluating deployment in managed environments should wait for v1.0.0 or test pre-release artifacts in a non-production context.
- Microsoft Excel for Windows (desktop)
- Macros enabled
- Microsoft Excel for Windows
- PowerShell
- Excel Trust Center: "Trust access to the VBA project object model" enabled
- Office RibbonX Editor (for ribbon changes only)
This project follows Semantic Versioning: MAJOR.MINOR.PATCH
| Increment | When |
|---|---|
MAJOR |
Breaking architectural changes |
MINOR |
New report modules or significant enhancements |
PATCH |
Bug fixes or minor improvements |
See CHANGELOG.md for the full project history.
This project is an independent reporting utility. It is not affiliated with, endorsed by, or supported by any ERP vendor or educational organization.