[JB] How to Reconcile AR to JB

If JB and AR don’t match on invoiced or retainage amounts, follow these steps:

1. Check Accounts Receivable

• Run AR Customer Accounts By Contract Report

  • Enter the contract

  • Set Transactions to (A) and Detail Level to (D)

• Look for:

  • Payments applied directly to retainage (these can skew AR reports)

  • Adjustments to invoices (ignore adjustments that are part of a JB invoice change)

2. Check Job Billing

• Run JB List of Bills per Contract Report

  • Bills with status Active, Changed, Delete, or Never Interface may not appear in AR.

  • Never Interface bills (e.g., beginning balances) do not need to be interfaced if an AR invoice already exists.

• Ensure JB amounts are in sync by updating previous amounts if needed (see KB article “How to Update Job Billing’s Billed and Contract Amounts”).

3. Compare AR and JB

• Run AR Contract Billings and Receipts Report → List of all AR invoices

• Run JB List of Bills per Contract Report → List of all JB invoices

• Identify discrepancies:

  • Invoice in AR but not in JB → either create a Never Interface bill in JB or delete/recreate in JB

  • Invoice deleted in JB → ignore if AR shows $0

• Check Status 4 Batches in HQ Batch Control (current and previous months). These may affect numbers.

Note: Write-offs do not transfer to JB or JC.

4. Correct the Problem

• JB bills out of sync: Follow KB article instructions

• Payments applied to retainage: Remove payment or do a $0 cash receipt to reassign it

• Adjustments in AR: Delete or create offsetting adjustments; make changes in JB

• JB bills not interfaced: Interface them

• Bills only in AR:

  1. Delete/recreate in JB, or

  2. Create a Never Interface bill in JB

• Status 4 batches: Post them in AR or JB Batch Process