Skip to main content

Adjusting Journal Entry

Post adjusting entries once in Workiva—and watch them automatically flow through every affected balance, table, chart, note, and MD&A section, with a full audit trail. No more chasing spot updates across dozens of linked cells.

What you get:

  • Seamless integration with the FHB Public-Sector Data Model: adjusting entries trigger predefined calculations and auto-update financial statements end-to-end.
  • Pre-built FHB templated spreadsheets, scripts, and chains that push, pull, and propagate adjustments across all relevant locations.
  • Built-in validations that instantly flag imbalances between debits and credits, so errors are caught early.

What you do:

  • Enter your adjusting entries into the provided spreadsheets, select line items from your trial balance, and enter debits/credit.
    And/or
  • Automatically calculate entries in supplementary work papers through database queries.

The Result:

  • No more spot adjustments or manual propagation. One entry updates your entire publication—statements, schedules, notes, MD&A, charts, and more—instantly and consistently.
  • A complete, traceable audit trail for every change—giving you and your auditors confidence and saving significant time during close.

Schedule a Call to Discuss Automating your Adjusting Journal Entries

Adjusting Journal Entry 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 Adjusting Journal Entry Extension