Document cross-check/tie
Hi! Is there a template that is basically a big check page that will show if a number in your document doesn't tie if it is referenced multiple places in the document? An example would be Net Income and it would check and show the error if it doesn't tie to all the places it is referenced throughout the document.
-
Hi there, my initial thought is that anywhere net income is used in the document, it should be linked to the same source.
0
Ideally, you might want to consider a single source for an amount in your workbook/document for an amount and ensure that page is considered a "source" worksheet. We have such a thing for our trial balance which is just a copy and paste from an exported Excel document from our consolidation reporting system. We have all workbook references for such an amount linked to that amount, then in the document, linking to those amounts. We have also built a validation system within each sheet testing for math where details total to a source amount and then have a validation sheet that totals all errors (where the details aren't totalling to an amount that should tie to a source amount) so we can quickly see what sheets still need attention. When all validation errors are clear in our workbook, we know that in the document, the same amount that appears in multiple areas of the document match. Let me know if you would like more details.
Also, XBRL does have some checks and balances for this. We ensure that an amount appearing in multiple areas has the exact same XBRL concept so that if the amount differs between occurrences, a validation warning appears. I suggest you are very diligent when tagging XBRL that this is the case. This is especially helpful when adding new amounts, disclosures, etc...0Iniciar sesión para dejar un comentario.
Comentarios
2 comentarios