This article explains how to generate the Ledger Balances report in Unity® Practice Management.

The Ledger Balances report shows the Ledger Balances associated with a client’s ledger, including the client’s balance, Office, and WIP balances, among others.

How to Access the Ledger Balances Report

Follow the steps below to access Ledger Balances Report:

Go to your Reports page.
Type ‘Ledger’ in the Filter & Options search bar and select Money and Finance as your Report Category.
Select the Ledger report, and a report generation page will open.

If the report is required often, click on the star next to it to make it a favourite, and it will show in the Favourite Reports section.

Generating the Ledger Balances Report

Select the Balance Mode. There are a number of Balance Modes types:

All ledgers excluding zero balances	Selecting this option will generate a report of ledgers that have a balance, a balance will include an office balance, client balance, deposit balance or WIP balance. Any ledgers with a zero balance will not be included on this report.
All ledgers including zero balances	Selecting this option will generate a report of all ledgers which have balances and zero balances.
Ledgers with zero balance only	Selecting this option will generate a report showing ledgers with zero balances only, this can be helpful when checking which cases need to be archived.
Ledgers with a client balance	Selecting this option will generate a report showing any ledgers that have a client account balance, it will not include any ledgers that do not have a client balance. This can help when checking for residue balances that may need to be returned to the client.
Ledgers with a client balance in CR	Selecting this option will generate a report showing any ledgers that have a client account credit balance, this will not include any ledgers that do not have a client balance or that have a client debit balance.
Ledgers with client balance in DR	Selecting this option will generate a report showing any ledgers that have a client account debit balance, this is to help with the compliance of the SRA accounts rules. Client account debit balances are a breach of the SRA account rules and must be rectified as soon as they are identified.
Ledgers with a deposit balance	Selecting this option will generate a report showing the ledgers that have a deposit account balance, this is help manage any deposit account and ensure that they are check regularly and interest applied when necessary.
Ledgers with an office & client balance	Selecting this option will generate a report showing ledgers with balances in clients account and in office account, this will help manage cashflow and ensure compliance with the SRA accounts rules. Any monies that held in clients account for profit costs must be transferred to office account within 14days from the date the bill is raised, this report can help identify possible transfers.
Ledgers with an office balance	Selecting this option will general a report showing ledgers with balances in office account.
Ledger with an office balance in CR	Selecting this option will generate a report showing the ledgers with an office credit balance, this it to help with the compliance of the SRA account rules. Office account credit balances can be a breach of the SRA account rules and this will help identify them.
Ledgers with an office balance in DR	Selecting this option will generate a report showing the ledgers with an office account debit balance, this report can help identify disbursements that need to be billed and reclaimed from the client.

Select an Activity Mode, and enter the required Date, this will then generate a report showing the ledgers with the required criteria.
Enter the Client Name or Code. The report will be filtered to only show those clients.
Enter the Matter Description required. There are three options:
- Match
- Containing
- Starting with
The default order of the report is by Matter, this can be changed by using the Primary & Secondary Ordering, for example if the Primary Order was changed to F/E the order that the information is presented would change to show the F/E followed by their Matters.
The report will automatically default the Sub Totals None. To add Sub Totals to the Primary & Secondary Ordering fields select the Sub Totals that are required from the dropdown list.
Tick the Split each FE per page checkbox to split the report by fee earn per page.
Select the required filter Options. The filter Options are:
- Branch
- Case Type
- Fee Earner
- Legal Aid Code
- Partner
- Source
Case Types or Fee Earners on the right will appear in the report; those on the left will not. Use the centre arrows to move items between sides. By default, All is selected, showing both Active and Inactive Case Types. To filter, choose Active or Inactive from the dropdown at the bottom of the screen.

All the Interactive Cloud reports use default settings, but the Customise Columns option lets you tailor them to your needs. Fields on the right appear in the report. To remove one (e.g., Fee Earner), highlight it and click the left arrow. To add a field (e.g., Date Closed), highlight it on the left and click the right arrow. All arrow controls are in the centre panel. The additional options to add to this report are:

Field	Description
Billed	The profit costs billed on the case
Branch Description	Full Branch Name, IE: Manchester, Liverpool
CT Description	Full Case Type Description, IE: Divorce
Date Closed	The date the case was closed
Dept	Department Code
Dept Description	Full Department Description, IE: Family, Probate
FE Name	Full Fee Earner name
Franchise	Legal Aid Franchise code, IE: CR
Franchise Description	Legal Aid Franchise description IE: Crime
LA	L/A code, Private matter will be shown as PRIV
LA Description	Full L/A description, IE: Legal Help
Last Accounts Date	The date the last financial transaction was posted to the ledger
Last Bill Date	The date of the last bill that was posted to the ledger
Last Document Movement	The date the last document was saved to the case
Last Time Movement	The date the last time entry was posted to the time ledger
Legal Aid Certificate	The Legal Aid Certificate number
Legal Aid Certificate Charge Limit	The Legal Aid Certificate financial limit
Legal Aid Certificate Date Issued	The date the Legal aid Certificate limit was issued.
Matter Credit Limit	The credit limit allocated to the matter
Notes	Any notes that are recorded in case notes
Partner	Partner supervising the matter
Time	The value of all the time recorded on the case
Time Billed	The value of the time billed on the case
Time Costed this Month	The value of time recorded in the current month
Time WO	Value of time written off on the case
UFN	Legal Aid Cases only – Unique File Number
Userdef 1	Case user defined field, these are defined by each practice
Userdef 2	Case user defined field, these are defined by each practice
Userdef 3	Case user defined field, these are defined by each practice
Userdef 4	Case user defined field, these are defined by each practice

Once all the data is included and in the required order, Click the Preview dropdown arrow to select the format for the report.
Click Report, and a new window will open with your report.

Templates

If the data selected for the report is required regularly, you can set up a template to make the information easily accessible.

Once the required information is selected and columns are customised, select Templates from the Options dropdown menu.

Enter a Name for the template. There is also an option to add Notes. Click Submit and the template will be stored under Templates and can be accessed when required.