Cross Check formulas

Cross check formulas let you verify that, after data entry, all previously established relationships among schedule line values are correct. Cross check formulas are verified during the Validate Data and Consolidate tasks.

Cross check formulas must be added through the structure data. The Import Wizard derives the sign for the referenced cross-checked line automatically based on a comparison of the natural signs between the schedule line that has the XCheck formula and the referenced schedule line. If the natural signs are the same, then it is plus (+), otherwise it is minus (-). The syntax is:

XCheck(<reference line_name>)

You can have a cross check formula and another type of formula on the same schedule line. To do this, you need two lines in the import file. For example:

Net Income before Minority Interest,~BeginFormula~(downfoot([Income Before Taxes],[Income Tax]))~EndFormula~

Net Income before Minority Interest,~BeginFormula~(XCheck([Income Before Taxes]))~EndFormula~

Any formulas already assigned to the line are preserved. For example, if the schedule line already has a downfoot formula defined, you can add the cross check formula by including this line in the import file:

Net Income before Minority Interest,~BeginFormula~(XCheck([Income Before Taxes]))~EndFormula~

Cross check formulas cannot be added through the Formula Builder.