Completing the Reconciliation Spreadsheet
- Review the calculations.
If a field is empty but requires a value, it is yellow. If the field needs no value, enter 0.
The variance fields turn red if they are any number but 0. If this occurs, double check your numbers and research what caused the variance.