Article ID: 8714

Finding Matters with an Out of Balance Accounts Receivable

An Accounts Receivable imbalance can occur between your Ledgers, Journal, or G/L accounts. The amount of the imbalance appears under the Client/Journal or Journal/G/L column on the G/L Reconciliation Report. Finding the matter causing the imbalance can help you reconcile the G/L balances.

Take the following steps to find the matter causing an Accounts Receivable imbalance between the Client Ledger and Billing (Fees) Journal:

  1. Click Reports, select Client, and Ledger... to open the Client Ledger window.
  2. Click to check the Firm Totals Only box.
  3. Click the Matters tab.
    NOTE: Click Advanced at the bottom of the Client Ledger window if the Matters tab is not available.
  4. Select Range of Clients - By Client Name.
  5. Enter A in the From box and M in the To box.
  6. Leave all other report options at their default values.
  7. Select Output options.
  8. Click OK to run the report.
  9. Click Reports, select Journal, and Billing (Fees) Journal... to open the Billing(Fees) Journal window.
  10. Enter 12/31/2199 in the End Date box.
  11. Click to check the Firm Totals Only box.
  12. Click the Matters tab.
    NOTE: Click Advanced at the bottom of the Client Ledger window if the Matters tab is not available.
  13. Select Range of Clients - By Client Name.
  14. Enter A in the From box and M in the To box.
  15. Leave all other report options at their default values.
  16. Select Output options.
  17. Click OK to run the report.
  18. Compare the A/R Balance on the Billing (Fees) Journal to the Balances > A/R total on the Client Ledger and take one of the following actions:
    • Rerun the reports for the other half of your clients (N through Z) if the A/R Balances match
    • Rerun the reports for clients A though G if the A/R Balances do not match
  19. Continue to rerun the reports for an increasingly smaller range of clients using the method in step 18 until you find the exact client causing the imbalance.