Page 50 - Participant Guide - Unanet GovCon Closing a Fiscal Period (2)
P. 50

Troubleshooting Variances

               If variances are found, then a more detailed reconciliation should be performed by
               project. Run the Project Summary by Cost Element report which will show the data by
               project. Use the same criteria described above for running this report. Compare this
               report to the GL Summary (Trial Balance) report by Project, by selecting this option.
               Possible Causes of Variances
                   •  An INDIRECT GL account is mapped on a DIRECT Project Type (or vice versa).
                   •  There are unmapped Expense Types to Cost Elements.
                   •  Projects are missing a Cost Structure.
                   •  The Cost Pool Calculation does not match Cost Structure indirect rate
                       formula/application.
                   •  The calculated actual rates are not current/correct.
               Revenue
               In rare instances, journal entries to revenue may be made. As a best practice, revenue
               GL accounts should be marked to require projects. If there are any Journal Entries
               made to revenue, this is a potential opportunity for a reconciliation issue.

               Direct Costs
               Any journal entries or AP vouchers posted with no project associated will lead to a
               reconciling item between the Project Ledger and the Income Statement.

               Unallowable Direct Costs
               Best practice is to create a Direct Unallowable Cost Element to map these expense
               types into. This Cost Element should be presented separately on the JSR for ease of
               reconciliation. In the Income Statement, these costs would be presented in an
               "Unallowable Direct Cost" heading above gross margin as well.

               Indirect Costs
               Indirect costs, such as Fringe, Overhead and G&A are reconciled generally in total and
               on a year-to-date basis each month. Make sure to run the JSR on actual rates.























               LESSON 6: RECONCILIATIONS
                                                                                  ©2022 Unanet. All rights reserved.   50
   45   46   47   48   49   50   51   52   53   54   55