How do I reconcile Job Cost to General Ledger for Revenue? (Using Job Cost for Receivables)
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]

1. Verify that all entries are posted in General Ledger:

  1. In General Ledger go to Inquiry, Entries by Batch and select the New file.
  2. Any batches displayed are unposted.
  3. Double click the batch to review the contents.
  4. If there are unposted entries that affect your cost accounts go to Tasks, Post Entries
  5. Review your posting journal to verify that all entries posted.
  6. If there are rejections, correct appropriately and re-run the post.
  7. Review journal to verify that the entries are now posted.

2. Verify that all entries are posted in Job Cost:

  1. In Job Cost go to Inquiry, Entries, Entries by Batch and select the New file.
  2. Any batches displayed are unposted.
  3. Double click the batch to review the contents.
  4. If there are unposted entries that affect your cost accounts go to Tasks, Post Entries
  5. Review your posting journal to verify that all entries posted.
  6. If there are rejections, correct appropriately and re-run the post.
  7. Review journal to verify that the entries are now posted.

3. Reconcile the receivable draws in Job Cost to verify that revenue entries posted to the correct account and balance to GL:

  1. In Job Cost go to Reports, Billing, Receivables Aging (spec. date), select the Current file and click OK.
  2. Enter the Cut-off date for the end date of the reconciliation period.
  3. Click Conditions and add the conditions:
    • Accounting Date Greater or Equal to the begin date of the reconciliation period.
    • Transaction Type Not Equal To Cash Receipt.
  4. Combine the Balance and Retainage totals to compare to the General Ledger revenue account.

4. Verify that there are no entries in the account in General Ledger with an application of origin other than Job Cost. These types of entries will not be reflected in Job Cost:

  1. In General Ledger go to Inquiry, Account.
  2. Select the Current file when prompted.
  3. Double click the first cost account you wish to review
  4. Add a condition of Application of Origin Not Equal to JC
  5. Any transactions that appear will not be in Job Cost
  6. Enter reversing GL Journal Entry

DocLink: How do I work with Billings and Deposits in JC?

[BCB:156:Chat 300 CRE US:ECB]
Steps to duplicate
Related Solutions