|
自 2021 年 1 月起，傳統文件類型將不再可用。您可以轉換傳統檔案或下載 PDF。進一步瞭解

Tieout Sheet

要求演示
  • 編輯於

Hello!

 

I am wanting to build out a tieout sheet for all related numbers in the audit. Specifically, I am wanting to have a single sheet dedicated to showing that all numbers that are used in multiple areas match. An example of this would be the following, I would want to be able to make sure that my OCI related to pension in my Statements of Comprehensive Income matched the sum of the various benefit components (e.g. prior service credit) in the Employee Benefit Plan footnote. I am just wanting to see if anyone had any tidbits they wanted to share before I built this from scratch.

 

Thanks! 

0

評論

1 條評論

日期 投票數
  • Stephanie Hout

    We call ours validations. They are at the bottom of each section of our workbook where relevant. Then there is a summary "if" formula for that section of the workbook- which is pulled into a summary sheet for the entire project. The summary sheet allows us to know if we need to investigate. I think otherwise the list of all the cross ties would be a bit cumbersome to maintain outside of the related areas.

    1

請登入寫評論。