Preliminary

1. Post entries in Job Cost. Confirm all entries post.
2. Post entries in General Ledger. Confirm all entries post.
3. Verify if your costs are in balance after posting.
4. Continue with the steps below if you still need to reconcile out of balance entries.

Reconcile Job Cost entries to General Ledger entries

Reconcile the cost transactions in Job Cost to verify entries posted to the correct account and balance to General Ledger.

1. In Job Cost go to Reports, Entries, GL Reconciliation report.
2. Enter the date range you're reconciling, leaving the account and batch prompts blank.
3. This report sorts by Debit account all entries in Job Cost for the date range selected.
4. Confirm that the only debit account listed is the Cost Account you’re attempting to reconcile.
5. Confirm that the Cost Accounts only show in the Credit Account if it's an offsetting negative entry.
6. In General Ledger go to Reports, Year to Date Ledger.
7. Enter in the date range entered in Step 2 above.
8. Range or condition on the same General Ledger accounts showing on the Job Cost GL Reconciliation report.
   • If reviewing only one account, range on that account. If reviewing multiple prefixes or multiple accounts, use Ranges or Conditions
   • Example condition: Base Greater or Equal to 5000 AND Base Less than or Equal to 5999
   • The debit account is typically the comparison total
   • If there are cost entries in the credit column, add them to the debit total to match to Job Cost
   • Subtract/add AR Misc Cash Receipt entries to the appropriate General Ledger account
      NOTE: Misc receipts typically print at the top of the GL Reconciliation report. Misc JC Cash Receipts don't send the job number to the General Ledger Job field. As a workaround: Enter the job number in the Reference field. When running General Ledger reports on job number, add two conditions to isolate these issues: Job EQ xxx OR Ref 1 EQ xxx
9. Compare the total on the GL Reconciliation Report to the cost accounts total debits on the Year-to-Date Ledger. If the two reports match for the debits, Job Cost balances to General Ledger.

Check for General Ledger journal entries

Verify there are no entries in the account in General Ledger that you created using a General Ledger journal entry. These types of entries don't post to Job Cost.

1. Go to General Ledger, Inquiry, Account.
2. Select the Current file when prompted.
3. Double-click the first cost account you need to review.
4. Add a condition of Application of Origin Equals GL.
5. Any transactions that appear won't be in Job Cost.
6. Enter reversing GL Journal Entry.
7. Re-enter as a Direct Cost in job cost.
8. Repeat these steps for each out of balance cost account.

Check for entries without a job number

Review the entries in General Ledger to verify if they're missing a job number.

1. In General Ledger, go to Inquiry, Account, select the Current file.
2. Double-click the first cost account you wish to review.
3. Add a condition of Job EQUAL " " (blank).
4. Add appropriate columns to identify information needed to find the entry in the Application of Origin.
   • Example: Add the columns for Vendor and AP Invoice, if the entry came from Accounts Payable. Determine if the entry required a job number. If it required a job, correct the entry in the appropriate application. Correct Accounts Payable entries in Accounts Payable so that dollar paid entries post correctly to Job Cost. If they don’t require a job, use a journal entry to move the amount to the correct account.
5. Repeat the steps for each cost account that's out of balance.
6. Continue to the batch reconciliation steps if:
   • No entries are missing jobs
   • No transactions originated with General Ledger journal entries
   • The entries don't total the full amount that Job Cost is out of balance by
     

Reconcile the batches

Batch reconcile Job Cost to General Ledger.

1. In JC go to Reports, Reconciliation and run the JC GL Totals by Batch.
2. Select the Date range.
3. Print or preview the report.
4. Compare the batch totals in the JC column and the GL column. Verify the Difference column shows an amount.
5. Identify the batches that are out of balance.