Budget and Financial Reporting Services

The Vendor is required to provide multiple comprehensive public financial documents each year, including the annual budget, annual comprehensive financial report (ACFR), and other financial reporting publications.
- Requirement:
1. Narrative and data integration:
•    Ability to embed and dynamically link financial tables within narrative text. 
•    Data-driven text updates — e.g., narrative phrases like “sales tax revenues increased by 4%” automatically reflect changes in underlying source data. 
•    Support for conditional narrative logic, such as automatically adjusting words like “increased and decreased” based on data trends. 
•    Configurable number and text formatting options (e.g., $1,000 vs. $1k, or $2,400,393 vs. $2.4m). 
•    Ability to embed signed letters, charts, maps, and external documents within the publication. 
•    Support for document-level linking — one change in a financial dataset updates every occurrence across the publication.
2. Formatting and design:
•    Robust styling controls for fonts, colors, line styles, and themes. 
•    Template-based design system with default styles, reusable components, and format painter tools. 
•    The preferred solution will have full ADA compliance (WCAG 2.1 AA) for all content — no reliance on tables for layout. 
•    Exceptions are possible – will need to understand how the solution addresses this compliance need. 
•    Cross-page data continuity (headers repeat automatically, totals compute correctly across pages). 
•    Professional layout controls for pagination, spacing, and inline integration of graphics, tables, and charts. 
•    Header and footer management (page numbering, dynamic table of contents integration, document metadata). 
•    Support for organizational charts with configurable color coding, line thickness, and formatting reuse. 
•    Control over data source formatting overrides (e.g., replace excel formatting with internal publication standards). 
•    Easily identify and reuse key style elements (fonts, colors, emphasis, borders, etc.).
3. Formulas and data computation:
•    Built-in formula functions: sum, if, and conditional formatting. 
•    Support for VLOOKUP and XLOOKUP-style cross-table referencing. 
•    Pivot table-style aggregation and summarization. 
•    Derived values and transformations directly within tables tied to source data. 
•    The preferred solution will have formulas similar in scope and capabilities as excel
4. Data management and integrations:
•    Import and synchronize from excel, SharePoint, power bi, or other systems. 
•    Support for real-time or scheduled data refreshes that update linked narratives and tables automatically. 
•    Ability to export to pdf (print-ready, ADA-compliant), word, or publish to web. 
•    Potential for API integration with city’s data lake house 
•    Support for integration with standard city single sign on solution, Microsoft entraid. 
•    Maintain source tracking for all imported data and transformation steps.
5. Audit, validation, and quality control:
•    Automated alerts for discrepancies or data validation issues (e.g., missing rows, hidden columns, formula breaks). 
•    Ability to compare totals across tables to original data sets. 
•    Validation dashboards for pre-publishing review. 
•    Complete audit history of every change, including value and formatting edits. 
•    Ability to compare versions (redline and blackline) to show tracked changes and milestones (e.g., “sent to auditors”).
6. Collaboration and workflow:
•    Real-time multi-user editing with commenting and @mentioning. 
•    Assign status indicators or progress “stoplights” by section.
•    Section-based permissions management for internal and external reviewers (e.g., auditors). 
•    Ability to hide or lock sections until ready for release. 
•    Versioning with named milestones (e.g., “draft”, “final”, “auditor copy”). 
•    Task assignment, review tracking, and peer review workflows.