This is a real, spec-aligned proposal — the kind a traditional software agency would hand a client before work begins. The timeline, team structure, and price reflect what this project would cost through the old model: a fixed upfront quote, a multi-week engagement, no outcome guarantee. VerticalHorizon delivers the same scope on a committed date, spread across a small down payment and low monthly installments — not a six-figure check upfront. The specification this proposal was priced from is available for download here.
Implementation Proposal · Ridgeline Mechanical Services
This proposal presents a comprehensive solution to deliver the Reporting & Close Acceleration Platform as specified in the functional requirements document (v0.2, dated 2026-07-12). The platform will streamline month-end close processes, automate covenant compliance reporting, and provide real-time visibility into financial performance for Ridgeline Mechanical Services.
The proposed solution encompasses:
Delivery Timeline: 22 weeks across 11 two-week sprints
Total Investment: $501,540
The RFP defines a specialized financial reporting platform to address the unique challenges of a $30M commercial mechanical contractor operating under credit facility covenants. The system must:
Accelerate the month-end close cycle through structured workflow management, eliminating the current manual checklist process and capturing variance commentary with proper attribution at the point of investigation.
Construct a management trial balance from QuickBooks GL exports, apply service-line dimensionality, link GL activity to job-level data, and compute portfolio KPIs with full drill-path traceability to source transactions.
Maintain debt schedule data, calculate the three required financial covenants (Funded Debt/EBITDA, Fixed Charge Coverage, Current Ratio), track headroom against thresholds, and generate compliance certificates with controller certification controls.
Render three distinct reporting packs (Board/Sponsor, Lender) from a single source of truth, enforce finalization blockers preventing premature distribution, and maintain immutable versioning of all distributed packs.
Ingest data from four external systems — QuickBooks (GL), proprietary job system (CSV), bank statements (CSV), and manually maintained debt schedules — each with defined cadence requirements and format contracts.
Implement role-based access controls differentiating internal users from sponsor portal users, maintain append-only audit logs of all material actions, enforce authentication through managed identity providers, and protect draft figures from premature sponsor visibility.
Enforce integer-cents monetary representation eliminating floating-point errors, ensure idempotent ingestion preventing duplicate postings, prohibit direct posting of derived values, and maintain immutability of account mappings after first use.
| Epic | Feature | RFP Reference |
|---|---|---|
| Close Orchestration | Close Checklist Workflow | §4 K1, REQ-K1.1 |
| Task State Tracking | §4 K1, REQ-K1.2 | |
| Close Progress Dashboard | §4 K1, REQ-K1.3 | |
| Task Audit Logging | §4 K1, REQ-K1.4 | |
| Checklist Template Management | §4 K1, REQ-K1.5 | |
| Variance Commentary Capture | §4 K2, REQ-K2.1 | |
| Commentary Attribution | §4 K2, REQ-K2.2 | |
| Financial Data Core | Trial Balance Construction | §5 F1, REQ-F1.1 |
| Management Chart Mapping | §5 F1, REQ-F1.2 | |
| Service-Line Dimensionality | §5 F1, REQ-F1.3 | |
| GL-to-Job Linkage | §5 F1, REQ-F1.4 | |
| Portfolio KPI Computation | §5 F2, REQ-F2.1 | |
| KPI Drill-Path Traceability | §5 F2, REQ-F2.2 | |
| Job Margin Watch List | §5 F2, REQ-F2.3 | |
| Job Margin Watch Escalation | §5 F2, REQ-F2.4 | |
| Defined-Term EBITDA Computation | §5 F3, REQ-F3.1 | |
| EBITDA Add-Back Schedule | §5 F3, REQ-F3.2 | |
| Covenant & Debt Management | Debt Schedule Maintenance | §6 V1, REQ-V1.1 |
| Three-Covenant Computation | §6 V2, REQ-V2.1 | |
| Covenant Headroom Tracking | §6 V2, REQ-V2.2 | |
| Versioned Covenant Formulas | §6 V2, REQ-V2.3 | |
| Compliance Certificate Drafting | §6 V3, REQ-V3.1 | |
| Controller Certification Fence | §6 V3, REQ-V3.2 | |
| Pack Generation | Board/Sponsor Pack Rendering | §7, REQ-G1.1 |
| Lender Pack Rendering | §7, REQ-G1.2 | |
| Pack Finalization Blockers | §7, REQ-G1.3 | |
| Immutable Pack Versioning | §7, REQ-G1.4 | |
| Pack Rendering Performance | §7, REQ-G1.5 | |
| QuickBooks Integration | GL Export Ingestion | §8 X1, REQ-X1.1 |
| Ingestion Cadence Support | §8 X1, REQ-X1.2 | |
| Export Format Contract | §8 X1, REQ-X1.3 | |
| Bank Statement Integration | Bank Statement Ingestion | §8 X2, REQ-X2.1 |
| Job System Integration | Job System CSV Ingestion | §8 X3, REQ-X3.1 |
| Job Cadence Enforcement | §8 X3, REQ-X3.2 | |
| Debt Schedule Maintenance | Debt Schedule Manual Entry | §8 X4, REQ-X4.1 |
| Access Control & Sponsor Portal | Role-Based Access Control | §9 P1, REQ-P1.1 |
| Draft Figure Access Control | §9 P1, REQ-P1.2 | |
| Audit & Compliance | Append-Only Audit Log | §9 P2, REQ-P2.1 |
| Authentication & Data Protection | Managed Identity Authentication | §9 P3, REQ-P3.1 |
| Data Encryption | §9 P3, REQ-P3.2 | |
| API Credential Management | §9 P3, REQ-P3.3 | |
| Authentication Event Logging | §9 P3, REQ-P3.4 | |
| Covenant View Access Control | §9 P3, REQ-P3.5 | |
| Data Integrity | Integer-Cents Monetary Representation | §3 Constraint C-1 |
| Idempotent Seam Ingestion | §3 Constraint C-2 | |
| Derived-Never-Posted Enforcement | §3 Constraint C-3 | |
| Mapping Immutability | §3 Constraint C-4 |
The platform will be built as a cloud-native web application with five architectural layers:
Derived, Never Posted: The platform holds no books of record. Every figure it renders traces through a versioned mapping to an ingested, posted source. There is no path to type a number into a pack — commentary is text; numbers are derived.
Controller Certification Fence: Draft compliance certificates carry a DRAFT watermark and require explicit Controller review-and-certify action before an unwatermarked final may be rendered. The system computes; the Controller certifies. No auto-submission path exists.
Defined-Term EBITDA: Consolidated EBITDA is computed per the credit agreement's defined term — including its enumerated add-backs (transaction expenses within the permitted window; sponsor management fees to the permitted cap; non-recurring items subject to the aggregate cap) — as a configured, versioned formula with each add-back itemized and evidenced.
Integer-Cents Enforcement: All monetary amounts are represented, stored, transmitted, and computed as integer cents (i64). Floating-point monetary types are prohibited in schemas, interfaces, and persistence. Every derived total reconciles exactly to the sum of its ingested components.
The implementation will follow an Agile methodology with two-week sprints across 11 iterations, enabling iterative delivery and continuous stakeholder feedback.
The implementation is structured across 9 phases delivered over 22 weeks (11 two-week sprints):
| Phase | Description | Duration | Hours | Cost |
|---|---|---|---|---|
| Phase 1 | Infrastructure & Environment Setup | Sprint 1 | 128.6 | $19,290 |
| Phase 2 | Foundation & Core Platform | Sprints 1–3 | 596.0 | $89,400 |
| Phase 3 | Transaction Processing & Financial Operations | Sprints 3–5 | 697.5 | $104,625 |
| Phase 4 | Reporting & Compliance | Sprints 5–7 | 521.0 | $78,150 |
| Phase 5 | Advanced Analytics & Deal Management | Sprints 7–9 | 439.5 | $65,925 |
| Phase 6 | Optimization & Enhanced Capabilities | Sprints 9–10 | 317.5 | $47,625 |
| Phase 7 | Quality Assurance & Testing | Sprints 10–11 | 514.4 | $77,160 |
| Phase 8 | Training & Documentation | Sprint 11 | 0.5 | $75 |
| Phase 9 | Production Readiness & Deployment | Sprint 11 | 128.6 | $19,290 |
| Total | 3,343.6 | $501,540 | ||
Phase 1: Infrastructure & Environment Setup — Establish cloud infrastructure, development environments, CI/CD pipelines, and foundational security controls.
Phase 2: Foundation & Core Platform — Build core architecture including authentication, authorization, database schema, audit logging, and base UI. Implement RBAC foundation.
Phase 3: Transaction Processing & Financial Operations — Develop data ingestion pipelines for QuickBooks GL, job system, and bank statements. Implement trial balance construction, account mapping, service-line dimensionality, and the financial computation engine.
Phase 4: Reporting & Compliance — Create the close orchestration workflow, task management, variance commentary capture, covenant calculation engine, debt schedule maintenance, and compliance certificate generation.
Phase 5: Advanced Analytics & Deal Management — Implement job margin watch list, KPI drill-path traceability, portfolio performance dashboards, and the sponsor portal.
Phase 6: Optimization & Enhanced Capabilities — Develop the two reporting packs (Board/Sponsor, Lender) with PDF rendering. Implement pack finalization blockers and immutable versioning.
Phase 7: Quality Assurance & Testing — Execute comprehensive testing across all functional areas including integration, performance, security, and user acceptance testing.
Phase 8: Training & Documentation — Deliver user training for accounting team, controller, and sponsor portal users. Provide system administration documentation and operational runbooks.
Phase 9: Production Readiness & Deployment — Production environment setup, data migration from Excel-based processes, production smoke testing, and go-live support.
| Category | Hours | Cost | % of Total |
|---|---|---|---|
| Development | 2,700.1 | $405,015 | 80.8% |
| Quality Assurance | 514.4 | $77,160 | 15.4% |
| Infrastructure | 128.6 | $19,290 | 3.8% |
| Training & Documentation | 0.5 | $75 | 0.0% |
| Total | 3,343.6 | $501,540 | 100% |
Blended rate: $150/hour · Story points: 5,972
| Milestone | Deliverable | Amount | % |
|---|---|---|---|
| Contract signing | Project kickoff | $50,154 | 10% |
| Phase 2 completion | Core platform demonstration | $100,308 | 20% |
| Phase 4 completion | Reporting & compliance demonstration | $125,385 | 25% |
| Phase 6 completion | Complete feature set demonstration | $100,308 | 20% |
| Phase 9 completion | Production deployment and sign-off | $125,385 | 25% |
| Total | $501,540 | 100% |
Unit Testing: All computation logic — particularly financial calculations (trial balance, KPIs, covenant ratios, EBITDA) — will have comprehensive unit test coverage with test cases derived from RFP examples and actual data samples.
Integration Testing: Data ingestion pipelines tested with real QuickBooks exports, job system CSVs, and bank statement files. Format contract validation, idempotent behavior, and cadence enforcement verified.
Performance Testing: GL ingestion processing 12 months of data in under 2 minutes; portal response time under 1.5 seconds for dashboard views; concurrent session support for up to 8 simultaneous users.
Security Testing: Authentication mechanisms, RBAC, draft figure restrictions, encryption, and audit logging validated. Penetration testing against common vulnerabilities.
User Acceptance Testing: Controller and accounting team validate against real-world close scenarios, verifying workflows match operational needs.
The system will be considered complete when: