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!
-
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댓글을 남기려면 로그인하세요.
댓글
댓글 1개