Skip to main content

Automated Rounding & Validation

Ensuring notes tie perfectly to statements, statements align with schedules, and everything reconciles to your MD&A is a relentless, time-consuming battle—often consuming dozens, hundreds, or thousands of hours chasing rounding differences and agreement issues.

Our Automated Rounding and Validation Extension automates the heavy lifting:

What you get:

  • A series of scripts and chains that calculate and apply rounding adjustments to your accounts.
  • Automatic detection and resolution of inter-statement/schedule agreement discrepancies.
  • A central dashboard highlighting any configuration errors, calculation issues, or remaining rounding disagreements.
  • Email notifications alerting you and your team to agreement issues requiring review. 

What you do:

  • Ensure your imported trial balance foots to zero.
  • Integrate our pre-built FHB data model groupings designed for use with the automated rounding and validation extension.
  • Run the chains/scripts, then review dashboards, outputs, and any notifications.

The Result:

  • Statements, notes, schedules, and MD&A that tie seamlessly—with zero (or minimal) manual intervention.  
  • A detailed supporting report showing line-by-line rounding adjustments—perfect for your internal analysis and auditor review. 
  • A significant contraction in the number and the scope of your rounding problems. 

Schedule a Call to Discuss Automating Rounding & Validation

Rounding & Validation Extension Version 2025. Q4 Now Available 

Upgrade for faster, smarter, more efficient tools.

What's New

  • Multi-Year Adjustments
    • Apply adjustments to multiple years efficiently.

  • Rounding Automation
    • New and improved rounding functionality.

  • Connections - Automatically refresh all connections on demand or on a schedule.
    • Automated Updates: Refreshes spreadsheet connections via the master runner script. 
    • Flexible Execution: Run on a schedule or on demand. 
    • Time-Saving: Eliminates manual refresh steps. 
    • Toggle Control: Easily enabled or disabled as needed. 
    • Scalable: Supports broader use of data connections. 
    • Data Accuracy: Helps to ensure the most up-to-date data is used.

  • Publish Links - Automatically publish all links on demand or on a schedule.
    • Efficiency: Saves time by eliminating manual publishing steps. 
    • Scheduled or On-Demand: Can run automatically or be triggered as needed. 
    • Scalable: Supports increased volume and frequency of link publishing. 
    • Control & Flexibility: Can be turned on or off based on workflow needs. 
    • Data Freshness: Helps ensure users access the most current published data. 
     
  • Grouping Rollup
    • Quick Mapping: Easily see where each FHBID fits in financial statement groups. 
    • Detailed Breakdown: View unadjusted trial balance, adjustments, and adjusted amounts by FHBID. 
    • Improved Transparency: Clear audit trail from raw data to final financials. 
    • Efficient Review: Simplifies analysis and decision-making with organized financial data. 

  • Automatic Validation
    • Proactive Issue Detection: Flags variances early based on predefined rules. 
    • Automated Notifications: Assigns reconciliation tasks to users when issues are found. 
    • Improved Accuracy: Helps ensure reconciliation issues aren’t missed. 
    • Flexible Execution: Can run on a schedule or on demand. 
    • Toggle Control: Easily enabled or disabled as needed. 
    • Exception Handling: Includes an exception list to exclude known variances from alerts. 

  • API Upgrade
    • To ensure uninterrupted service, continued support, and access to enhanced capabilities, we are proactively upgrading our system to use the newer API versions in alignment with Workiva. For full details, see our Knowledge Base Article.

  • Updated Scripts (Built with Python 3.13)
    • Faster, Smoother Processing: Existing scripts will run faster. 
    • Improved Error Handling: Clearer error messages and improved error handling make it easier to spot and fix issues. 
    • More Reliable and Secure Performance: Automations will run more consistently, reducing interruptions and improving overall efficiency. 
    • Scripts will continue to run beyond Workiva's end-of-life deadline for Python 3.9 on October 31, 2026. For more on this, see our Knowledge Base article.

Schedule a Call to Discuss Upgrading your Rounding & Validation Extension