Import downfoot formulas

~BeginFormula~(Downfoot(Sched_Line A, Sched_Line B, Sched_Line C, ...))~EndFormula~

During import processing, this syntax becomes an equation, complete with equal (=), plus (+), and minus (-) signs. Effectively using downfoot formulas requires an understanding of the factors that contribute to the end results.

Using a downfoot formula in CTrain as an example, this diagram illustrates how the formula used to define the Net Income before Minority Interest schedule line as a downfoot line is transformed into the format that is used by your application. Supplemental information about the schedule lines used in this example includes these:

• Downfoot Line

  Schedule Line Name = Net Income before Minority Interest

  Natural Sign = C

• Contributing Line #1

  Schedule Line Name = Income Before Taxes

  Natural Sign = C

• Contributing Line #2

  Schedule Line Name = Income Tax

  Natural Sign = D

downfoot([Income Before Taxes],[Income Tax])

Net Income Before Minority Interest=[Income Before Taxes],[Income Tax}

Downfoot is replaced by the name of the downfoot schedule line. The parentheses become the equal sign. The natural sign of each contributing schedule line is compared in relation to the natural sign of the downfoot line.

This table shows what equation operator is used when constructing the downfoot formula:

If the natural sign is not provided as part of the import information, then the Import Wizard assigns a default value to the natural sign based on the schedule line's account type according to this table before constructing the formula equation:

If both the account type and natural sign are not provided as part of the import information, then the schedule line's account type defaults to BA and the natural sign defaults to D.