Reconciliation Tool  

Job Cost Reconciliation
Step Action Note
1. Post

Ensure all entries are posted.

JC Post Entries

Launch the JC Post Entries link and then click on Post Entries on the Task menu.

 

GL Post Entries

Launch the GL Post Entries link and then click on Post Entries on the Task menu.

Note: Review posting journals for rejecting entries that need to be corrected.

2. Data Verification

 

Close Month Validation

A job is in balance if all record types associated with the job contain totals that are consistent with the accumulated totals.  If the accumulated totals do not equal you may have data corruption.  This will need to be corrected before continuing.

3. JC Summary

 

JC Summary

View the summary report  to determine if your JC accounts are in balance between JC and GL.

If the accounts are in balance skip to step 7 to print period end reports,
    otherwise continue with step 4. 
4. Detail

Batch Detail: Identify which batches are out of balance.

JC Totals by Batch

This step will allow you to perform a more detailed analysis of your transactions by reviewing batches in JC as they compare to GL.  This report will show batches that exist in JC that do not exist in GL.  This report also has the capability to drill down into each batch to see transaction detail.

 

JC GL Totals by Batch

This report will allow you to analyze the transactions by reviewing batches in GL as they compare to JC.  This report will show batches that exist in GL but do not exist in JC and has the capability to drill down into each batch to see transaction detail.

5. Common causes if out of balance

Unexplained Entries

Cost Account Entries

The most common cause for JC to be out of balance with GL is when a manual entry is made directly to a JC account in GL.  Run this report to Review all transactions that have been posted to the cost accounts that didn't come from JC and the job is blank.

How to correct:

Reverse the original transaction and enter the correction in JC.

Unposted JC Transactions

Unposted JC Transactions in GL

When JC transactions are unposted or rejected in GL an out of balance situation will result.  This can happen for example when posting to a Closed month.  This report will help determine if these transactions are the cause of an out of balance situation.

Wrong Account Override

Account Entry Review

This report will help you identify transactions that posted to the wrong JC accounts in GL but originated in JC.

6. Repeat

Repeat steps 3, 4, and 5 as needed for each account and/or batch that is out of balance.

 

 

7. Period End Reports

 

GL Reconciliation

Print common period end reports such as the GL reconciliation report.