Product Details
Downloads/Installations
Using the Program
Technical Support
Related Resources
The Accounts Receivable Balances Do Not Reconcile from the Billing (Fees) Journal to the Client Ledger or G/L 1200 Account
Problem Description:
There is an imbalance between the Accounts Receivable balance on the Client Ledger and the Outstanding balance on the Billing (Fees) Journal or there is an imbalance between the Outstanding balance on the Billing (Fees) Journal and the Accounts Receivable balance for the General Ledger 1200 account. The imbalance can appear on the G/L Reconciliation report under the Accounts Receivable section.
An amount appears in the Client/Journal column of the G/L Reconciliation Report when there is an imbalance between the Client Ledger and the Billing (Fees) Journal. The following issues can cause this imbalance:
- Invoices can partially post to the journals and ledgers when a workstation outage, network issue, or power loss interrupts a billing process
- A payment is missing from the Billing (Fees) Journal resulting in a difference between the total receipts on the Billing (Fees) Journal and Client Ledger
- An entry is missing from the Client Ledger resulting in a difference between the total billed fees or disbursements on the Client Ledger and the total fees or disbursements on the Billing (Fees) Journal
For Accrual Accounting only, an amount appears in the Journal/G/L column of the G/L Reconciliation Report when there is an imbalance between the Billing (Fees) Journal and the G/L. An imbalance can occur when you manually allocate entries to the Accounts Receivable G/L control account (1200). Cash and Modified Cash Accounting do not track the Accounts Receivable with a G/L control account.
Suggested Action:
Always reconcile imbalances that appear in the Client/Journal column before reconciling imbalances that appear in the Journal/G/L column.
Take the steps in either of the following articles that describe your imbalance: