Job Cost Reconciliation |
|
|
|
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.
|
|
|
|
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.
|
|
|
|
JC Summary
|
View the summary report to determine if your JC accounts are in balance between JC and GL. |
|
|
|
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.
|
|
|
Repeat steps 3, 4, and 5 as needed for each account and/or batch that is out of balance.
|
|
|
|
|
|
GL Reconciliation
| Print common period end reports such as the GL reconciliation report. |
|