Client Payments Cash Book Report

24/08/2025
Knowledge

How To

Location: LEAP Menu > Reports > Client Funds > Client Payments Cash Book

Purpose: Lists Client Account payments within a specified period for a selected bank account, tracking outgoing Client funds to support reconciliation and compliance. It also provides a Cash Book Summary including opening and closing balances for the period.

The report is generated to reflect transactions and balances specific to the selected Client Funds bank account and is marked as ‘Interim’ to differentiate it from the ‘Client Payments Cash Book’ generated during the Client Accounts End of Month (EOM) procedure.

- The latter can be accessed via LEAP Menu > Reports > Client Funds > Client Accounts End of Month > View Previous EOM. It represents the finalised account activity for that period. For instructions on how to run the Client Accounts EOM, please refer to this article.

Click to edit heading

Important Notes:

The report organises results based on the Transaction Date of a Client payment. Therefore, a Client payment will be captured in the cash book—and thus affect the closing balance—only if its Transaction Date is within the specified date range.

- In instances where the Transaction Date differs from the Entry Date, both dates will be listed and the Entry Date will be marked by an asterisk (*).

Report Filters:

Start Date Range	Displays only Client payments that are dated within the specified period, based on the Transaction Date.
Bank Account Name	Provides a list of Client Funds Bank Accounts to choose from. The report will display transactions and balances for the selected Bank Account only.

Report Fields:

Date	Transaction Date: Date of the transaction. Entry Date: Displayed underneath, marked by an asterisk (*).
Pay No.	The Client payment number.
Payment Method	The Client payment's payment type.
Paid To	The transaction's Paid to.
Matter No, Client Name; Matter Description	Displays the following: Matter Number – The relevant matter number. Client Name – The matter's client. Matter Description – The matter description, set in the 'Matter Type' window.
Reason	The 'Reason' entered for the payment, based on the payment's Client Payment window.
Multi Amount	The line's amount for a multi-line payment. NOTE: It is utilised when a Client payment is apportioned to multiple matters, displaying the specific amount allocated to each respective matter.
Payment Amount	The total amount of the payment or the reversal.
Cash Book Summary	A summary of Client Cash Book, including: Opening Balance: The calculated opening system balance at the end of the previous period, based on the defined 'Start Date'. This amount should match the System Cashbook balance on the Client Accounts Bank Reconciliation Report at the end of the previous period (i.e., when the Statement Date falls on the end of the previous period). *Example: If the Start Date is 01/05/2024, the opening balance would be the balance as of 30/04/2024. Add Receipts: The total sum of all receipts entered for the Client Account within the specified period. The figure aligns with the amount reported in the Client Receipts Cash Book Report* for the same period. Less Payments: The total sum of all payments entered for the Client Account within the specified period. This amount should match the ‘Payment Amount’ total. Closing Cash Book Balance: The calculated closing system balance on the 'End Date'. This amount should match the System Cashbook balance on the Client Accounts Bank Reconciliation Report for the same date.

Last Modified Date

24/08/2025 10:02 pm

Title

Client Payments Cash Book Report

URL Name

Client-Payments-Cash-Book-Report-UK

Resolution