• 

  Greg Gaughan

  • 05. september 2025 kl. 18.19

  The new Historical Data Roll Forward feature should help alot with this, at least for XBRL tagged numbers. When you roll your 10Q forward to the next period, the Historical Data Roll Forward feature will go out to prior SEC filings in Edgar and pull in the prior period #'s from prior filings.

  As an example, I used HDRF when I moved from my filed 6/30/25 10Q to start prepping my 9/30/25 10Q files. It brought in my 9/30/24 QTD and YTD XBRL tagged numbers into my SEC single source workbook and then after I reviewed that they populated correctly, I was able to easily publish these numbers to the actual draft 10Q document in the financials and footnotes. 

  Since this feature works off the XBRL tagging in numbers, it probably won't help in updating prior year #'s in your MD&A as they are not XBRL tagged. 

  0
• 

  Pat Flanakin

  • 15. september 2025 kl. 12.47

  "I'd appreciate any insight into how others are populating previously reported figures."

  We have coordinated with our Fin Rept IT systems support within our accounting system department to create a rather dependable trial balance which can be easily run via our consolidation system for both balance sheet and income statement.  We just export this to Excel and copy and paste into WDesk.  Takes less than 5 mins.  This trial balance has a summary at the top, with details below with various level rollups (e.g. total accounts receivable is shown with all accounts composing such total above the total amount) as necessary and identified as needed for disclosure reporting purposes.  Changes to the format are allowed only via discussion with us in financial reporting.  We utilize vlookup Excel formulae within a separate WDesk worksheet, which has the exact layout of our financial statements, to pull the necessary amounts for both current and prior period, then those sheets feed the 10-Q/10-K document.  Using vlookup prevents any issues with new accounts added and associated rollup amounts are updated accordingly as well.

  We believe this is a better method than the Workiva Historical Data Roll Forward feature because of a couple reasons:

  1) The trial balance has significant controls determining its completeness and accuracy and is maintained by us and not a 3rd party

  2) The vlookup formula is easy to monitor, understand, and as long as the trial balance format doesn't change, it works every time.

  3) For prior period, even if we utilized the Historical Data Roll Forward feature, we would have to do the same thing we do now which is check each prior period amount vs the respectively filed documents.

  4) Lastly, the Historical Data Roll Forward feature only addresses XBRL tagged amounts and when you have significant untagged disclosures such as MD&A, etc..., our approach addresses those accordingly.  If we utilized the Historical Data Roll Forward feature, we would have to have two ways of populating the prior period amounts which seems cumbersome when you can have one method to address everything.

  0

Logg på for å legge inn en kommentar.