1. ParsePort FAQ
  2. Mapping & Calculations

Why are some cells in my Excel template highlighted green while others are highlighted with orange?

The highlight is added to easily display that something other than specific numbers is going on within the file.

Green cells simply mean that the cell contains a sum formula, because the cell represents a subtotal, and the formula is used to create the XBRL mapping when we convert your files.

The orange cells mean that the sum of the subtotal produces a calculation inconsistency or rounding error and because of this a value (usually + or - 1) has been added to the calculation.