Page 49 - Participant Guide - Unanet GovCon Closing a Fiscal Period (2)
P. 49
Activity 6.3 Reconcile Project Subledger to the GL
Login as Glenda Manager (GL Manager) – glmanager / welcome
Run the Project Cost Summary (JSR) for all direct projects and compare to Income Statement
for the year-to-date period. A comparison should then be made to ensure Revenue, Direct
Costs, Direct Margin, and Total Indirect Cost within the JSR tie to the Income Statement
Activity Steps
1. Navigate: Reports > Dashboard > Project Accounting > Project Cost Summary
(JSR)
2. Run the report using the following criteria:
REPORT ON All Projects I can see
BILLING TYPE CP, FP, TM
COST REPORT NAME Margin Summary
INDIRECT COST RATE Actual
DATE RANGE Fiscal Period Date Range
REPORTING OPTIONS • Roll up all selected projects into a single block
• Include posted data only
3. View the JSR FISCAL YTD column on the report to answer the LEFT column:
JSR INCOME STATEMENT
FISCAL YTD
Revenue = 40.01 - Revenue =
•
Direct Labor = TOTAL Direct Labor =
ODCs = 50.20 - Direct - Non-Labor =
Gross Margin = GM - Gross Margin =
Indirect Costs = TOTAL Indirect Costs =
4. Compare the values to the Income Statement. Navigate: Reports > Dashboard
> Financials > General Ledger > Income Statement
5. Run the Income Statement for the Closing Fiscal Period
6. View the report to input the results above on the Right column then compare the
values from the JSR. Do the values match? YES or NO
LESSON 6: RECONCILIATIONS
©2022 Unanet. All rights reserved. 49