Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Tieout Sheet

Request Demo
  • Edited

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

Comments

1 comment

Date Votes
  • 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

Please sign in to leave a comment.