Reports that Reconcile to the Client Ledger
Reports that Reconcile to the Client Ledger
The Client Ledger is a core PCLaw report, and it reconciles to several reports and the G/L. The first column of the following table lists figures on the Client Ledger. The second column provides the report where you can find a number to reconcile to the figure in the first column, and the third column tells you what figure reconciles to the Client Ledger. The last column includes any special conditions that apply to the numbers you reconcile from the first and third columns. Always run both reports with identical dates and parameters.
Figure on the Client Ledger
Report that Reconciles to the Client Ledger
Matching Figure on Report
Conditions Necessary to Reconcile Figures
Unbilled > Che + Recov
Client Accounting Ledger
Disb
reconciles for matter, client, and firm totals
Unbilled > Che + Recov
Unbd Disb
Unbd Disb
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box.
Unbilled > Che + Recov
Work-in-Progress
Unbilled Disb > Total
reconciles for matter, client, and firm totals
Unbilled > Che + Recov
Matter Status
Unbd Disbs
reconciles for matter total only
Unbilled > Fees
Client Summary
Unbd Fees
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box.
Unbilled > Fees
Client Fees Listing
Amount > Unbilled
The report contains no matter or client totals when you run the report for the firm.
Unbilled > Fees
Work-in-Progress
Fees
reconciles for matter, client, and firm totals
Unbilled > Fees
Matter Status
Unbd Fees
reconciles for matter total only
Unbilled > Fees
Client WIP, Billing, & Collection Summary
W.I.P. Time
reconciles for matter, client, and firm totals
Unbilled > Total
Work-in-Progress
Total > Total
reconciles for matter, client, and firm totals
Billed > Disb
Client Summary
Bld Disbs
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box.
Billed > Disb
Billing (Fees) Journal
Billed > Disbs
reconciles for matter, client, and firm totals
Select Include Write-Ups and Write-
Downs on the Billing (Fees) Journal's Other tab.
Billed > Disb
Invoice Journal
Disbs
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box.
Billed > Fees
Client Summary
Bld Fees
reconciles for matter, client, and firm totals You must enter 1/1/1982 in the Start Date box.
Billed > Fees
Client Accounting Ledger
Fees
reconciles for matter, client, and firm totals
Fees that you bill appear as a negative amount on the Client Accounting Ledger.
Billed > Fees
Billing (Fees) Journal
Billed > Fees
reconciles for matter, client, and firm totals
Select Include Write-Ups and Write-
Downs on the Billing (Fees) Journal's Other tab.
Billed > Fees
Invoice Journal
Fees
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
Billed > Tax
Client Summary
Taxes
reconciles for matter totals only
Billed > Tax
Billing (Fees) Journal
Tax
reconciles for matter, client, and firm totals
Select Include Write-Ups and Write-
Downs on the Billing (Fees) Journal's Other tab.
Billed > Tax
Invoice Journal
Taxes
reconciles for matter, client, and firm totals
Run both reports for
all dates.
Billed > Receipts
Billing (Fees) Journal
Paid
reconciles for matter, client, and firm totals
Select Include Write-Ups and Write-
Downs on the Billing (Fees) Journal's Other tab.
Billed > Receipts
Payment Allocation Listing
Total
reconciles for matter, client, and firm totals
Balances > A/R
Client Accounting Ledger
A/R > Totals for Report Period
reconciles for matter, client, and firm totals
Balances > A/R
Client Summary
A/R Bal
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box.
Balances > A/R
Matter Status
A/R
reconciles for matter totals only
Balances > A/R
Billing (Fees) Journal
Outstanding
reconciles for matter, client, and firm totals
Select Include Write-Ups and Write-
Downs on the Billing (Fees) Journal's Other tab.
Balances > A/R
Invoice Journal
Total
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
Balances > A/R
Receivables by Client
Total
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
Balances > A/R
Receivables by Lawyer
Firm Totals > Total
reconciles for firm totals only
Balances > A/R
Accounts Receivable (1200)
Closing Balance
reconciles only for firms that use Accrual Accounting
Balances > Trust
Client Accounting Ledger
Trust > Totals for Report Period
reconciles for matter, client, and firm totals
Balances > Trust
Client Summary
Retainer
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
Balances > Trust
Client Trust Listing
Matter Total
reconciles for matter, client, and firm totals
Balances > Trust
Client Trust Ledger
Matter Total
reconciles for matter, client, and firm totals
Balances > Trust
Matter Status
Trust
reconciles for matter totals only when you run both reports for all trust accounts
General Retainers
Client Accounting Ledger
Retainers
reconciles for matter, client, and firm totals
General Retainers
Client Summary
Retainers
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
General Retainers
Matter Status
Retainer
reconciles for matter totals only
Interest Paid
Client Summary
Interest Paid
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
Interest Due
Client Summary
Interest Due
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box for both reports.
Interest Due
Receivables by Client
Interest Due
reconciles for matter, client, and firm totals
You must enter 1/1/1982 in the Start Date box and 12/31/2199 in the End Date box for both reports.
[Top]
Common reports that do not reconcile to the Client Accounting Ledger
The Client Ledger does not reconcile to the Hard & Soft Cost Analysis report for Che (checks) or Recov (expense recoveries), because the Hard & Soft Cost Analysis report does not separate billed and unbilled costs.
The Client Ledger does not reconcile to the General Bank Journal for Che (checks) when you limit the reports to a specific matter, because the General Bank Journal does not differentiate between billed and unbilled matter allocations.
The Client Ledger does not reconcile to the Interest Calculation report for Interest Due or Interest Paid, because the Interest Calculation report only calculates accrued interest up to the last A/R activity for the matter. The Client Ledger also combines Interest Due and Interest Paid into an aggregate total.
[Top]
