Article ID: 8717

Reconciling an Accounts Receivable Imbalance Between the Client Ledger and the Billing (Fees) Journal

An Accounts Receivable imbalance between the Client Ledger and the Billing (Fees) Journal also appears in the Client/Journal column under the Accounts Receivable section of the G/L Reconciliation Report.

Take the following steps to reconcile differences that appear under the Client/Journal column:

  1. Make a backup of the program.
  2. Run a Verify Data Integrity (VDI) to refresh and update your index files.
  3. Find the first date of the imbalance on the G/L Reconciliation Report.
  4. Find the matter with an Out of Balance A/R.
  5. Run a detailed Client Ledger and Billing (Fees) Journal for the matter with the imbalance up to and including the date that the imbalance first occurs.
    NOTE: Select Include Write-Ups and Write-Downs on the Other tab of the Billing (Fees) Journal window.
  6. Make a note of any invoice numbers that appear in the Bld Inv# column on the Client Ledger that do not appear in the Invoice column on the Billing (Fees) Journal.
  7. Follow the steps for removing a partially posted invoice for invoices that only appear on the Client Ledger.
    NOTE: Continue to the next step if you do not find any invoices that only appear on the Client Ledger.
  8. Compare the Receipts total on the Client Ledger to the Receipts total on the Billing (Fees) Journal.
  9. Remove and re-enter any receipts for the amount of the imbalance if the Receipt totals on both reports do not match.
    NOTE: Contact Customer Support if the receipt is in a closed month. Continue to the next step if the Receipts totals match on both reports.
  10. Compare the Billed Fees total and the Billed Disbursement total on the Client Ledger to the Fees total and Disb total on the Billing (Fees) Journal.
  11. Identify the invoice number on the Billing (Fees) Journal that contains Fees or Disbursements in the amount of the difference between the two reports.
  12. Remove the invoice containing the mismatched fees or disbursement if the invoice is in an open month.
    NOTE: Contact Customer Support if the invoice is in a closed month.
  13. Re-enter the fees and disbursements that are missing from the Client Ledger if needed.
  14. Re-bill the matter with the imbalance and re-enter any payments that you had to remove in order to undo the invoice.