Report: Difference between revisions

From ContactsLaw Documentation
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[ContactsLaw]] provides access to '''reports''', which can be generated on-demand or according to a [[Daemon:Job|schedule]]. Reports may be built-in (available to all [[Subscription|subscribers]]) or implemented via plug-ins or extensions.
[[ContactsLaw]] provides access to '''reports''', which can be generated on-demand or according to a [[Daemon:Job|schedule]].


You can view reports within the [[Desktop App|Desktop]] and [[Web App|Web]] applications, or generate a [[document]] for printing, sharing and viewing offline. Most reports can also be exported in Microsoft Excel (.xlsx) or Comma-Separated Values (.csv) formats.
You can view reports within the [[Desktop App]] or generate a [[document]] for printing, sharing and viewing offline. Most reports can also be exported in ''Microsoft Excel'' (<code>.xlsx</code>) or ''Comma-Separated Values'' (<code>.csv</code>) formats.


== Properties ==
== Properties ==
Line 10: Line 10:
* '''Results''', usually consisting of one or more tables. These may include totals and grouping rows.
* '''Results''', usually consisting of one or more tables. These may include totals and grouping rows.


== Accounting ==
== Available Reports==
* '''Chart of Accounts''' - Lists [[Account|accounts]] and their current balances.
* '''Reconciliation Statement''' - Summaries a [[reconciliation]] and lists any unpresented payments or outstanding deposits.


== General ==
===Accounting===
* '''Aged Creditors''' - Lists [[Creditor|creditors]] with unpaid invoices and groups outstanding amounts based on the number of days overdue.
*'''Chart of Accounts''' - Lists [[Account|accounts]] and their current balances.
* '''Balance Sheet¹''' - Lists asset and expense accounts and their balances as at a given date.
*'''Reconciliation Statement''' - Summaries a [[reconciliation]] and lists any unpresented payments or outstanding deposits.
* '''Profit & Loss¹''' - Lists income, expense and owner's equity accounts and their net debit/credit activity over various periods.
*'''Transaction Listing''' - Lists [[Transaction|transactions]] debiting/crediting a particular account or [[ledger]].
* [[Report:Sales Tax|'''Sales Tax''']] (GST) - Lists [[transaction]] line items that fall within various categories designed to assist in the lodgement of a Business Activity Statement (BAS).
 
* '''Trial Balance''' - Lists accounts and their debit/credit activity up to and including a given date.
===General===
*'''[[Report:Aged Creditors|Aged Creditors]]''' - Lists [[Creditor|creditors]] with unpaid invoices and groups outstanding amounts based on the number of days overdue.
*'''Balance Sheet¹''' - Lists asset and expense accounts and their balances as at a given date.
*'''Profit & Loss¹''' - Lists income, expense and owner's equity accounts and their net debit/credit activity over various periods.
*[[Report:Sales Tax|'''Sales Tax''']] (GST) - Lists [[transaction]] line items that fall within various categories designed to assist in the lodgement of a Business Activity Statement (BAS).
*'''Trial Balance''' - Lists accounts and their debit/credit activity up to and including a given date.
¹ These reports are always presented on an accrual basis.
¹ These reports are always presented on an accrual basis.


== Trust ==
===Trust===
* '''Debit Balances''' - Lists transactions that result in a debit balance on a trust or controlled money ledger.
{{Hatnote|text=Important: Refer to [[Report#Compliance|compliance information]] below}}
* '''Deposit Slips''' - Lists trust deposit slips ([[Transaction Group|transaction groups]]) for audit purposes.
*'''Debit Balances''' - Lists transactions that result in a debit balance on a trust or controlled money ledger.
* '''Journal Transfers''' - Lists trust journal transfers for audit purposes.
*'''Journal Transfers''' - Lists trust journal transfers for audit purposes.
* '''Ledger Balances''' - Lists the balance on each trust ledger ([[matter]]).
*'''Ledger Balances''' - Lists the balance on each trust ledger ([[matter]]).
* '''Ledger Titles''' - Lists changes to the title of trust ledgers (in accordance with Legal Profession Regulations).
* '''Ledger Titles''' - Lists changes to the title of trust ledgers (in accordance with Legal Profession Regulations).
* '''Payments Cash Book''' - Trust payments cash book (for audit purposes).
*'''Payments Cash Book''' - Trust payments cash book (for audit purposes).
* '''Receipts Cash Book''' - Trust receipts cash book (for audit purposes).
* '''Receipts Cash Book''' - Trust receipts cash book (for audit purposes).
* '''Register of Controlled Money''' - Lists controlled money accounts and their current balances, along with the matters to which they relate.
*'''Register of Controlled Money''' - Lists controlled money accounts and their current balances, along with the matters to which they relate.
* '''Register of Powers & Estates''' - Lists [[Trust:Power|powers and estates]] for audit purposes.
*'''Register of Powers & Estates''' - Lists [[Trust:Power|powers and estates]] for audit purposes.
* '''Transit Money''' - Lists [[Transit Money|transit money]] for audit purposes.
*'''Transit Money''' - Lists [[Transit Money|transit money]] for audit purposes.
* '''Trust/CMA Statement''' - Lists transactions affecting a particular trust ledger for a given period (in accordance with Legal Profession Regulations).
*'''Trust/CMA Statement''' - Lists transactions affecting a particular trust ledger for a given period (in accordance with Legal Profession Regulations).


== Billing ==
===Billing===  
* '''Aged Debtors''' - Lists debtors with unpaid invoices and groups outstanding amounts based on the number of days since the invoice was issued.
*[[Report:Aged Debtors|'''Aged Debtors''']] - Lists debtors with unpaid invoices and groups outstanding amounts based on the number of days since the invoice was issued.
* '''Bad Debts''' - Plots invoices written off versus the months in a given financial year.
* '''Bad Debts''' - Plots invoices written off versus the months in a given financial year.
* '''Sales''' - Plots amounts billed for [[invoice]] items (excluding disbursements and interest) versus the months in a given financial year.
*[[Report:Sales|'''Sales''']] - Plots amounts billed for [[invoice]] items (excluding disbursements and interest) versus the months in a given financial year.
** '''Sales by Member''' - Shows the distribution of the sales figure for a given period over the [[Member|members]] responsible.
**'''Sales by Member''' - Shows the distribution of the sales figure for a given period over the [[Member|members]] responsible.
** '''Sales by Matter''' - Shows the distribution of the sales figure for a given period over the [[Matter|matters]] involved.
**'''Sales by Matter''' - Shows the distribution of the sales figure for a given period over the [[Matter|matters]] involved.
* '''Time''' - Plots billable [[Time Record|time]] versus the months in a given financial year.
*'''Time''' - Plots billable [[Time Record|time]] versus the months in a given financial year.
** '''Time by Member''' - Shows the distribution of the time figure for a given period over the members responsible.
**'''Time by Member''' - Shows the distribution of the time figure for a given period over the members responsible.
** '''Time by Matter''' - Shows the distribution of the time figure for a given period over the matters involved.
**'''Time by Matter''' - Shows the distribution of the time figure for a given period over the matters involved.
* '''Recovery''' - Plots invoice payments received versus the months in a given financial year.
*'''Recovery''' - Plots invoice payments received versus the months in a given financial year.
** '''Recovery by Member''' - Shows the distribution of the recovery figure for a given period over the members responsible.
**'''Recovery by Member''' - Shows the distribution of the recovery figure for a given period over the members responsible.
** '''Recovery by Matter''' - Shows the distribution of the recovery figure for a given period over the matters involved.
**'''Recovery by Matter''' - Shows the distribution of the recovery figure for a given period over the matters involved.
 
===CRM===
*'''Demographics''' - Groups [[Contact|contacts]] into categories based on demographics such as age, gender or industry. [[Custom Field|Custom fields]] can also be used.
 
===Matters===
*'''New Matters''' - Plots the number of new matters created versus the months in a given financial year.
*'''Overview''' - Lists matters and current balances for WIP, unbilled disbursements, debtors and trust.
 
==Compliance==
Since [[Subscription|subscribers]] have the ability to customise the [[Document Template|templates]] used for reports, care must be taken to comply with Legal Profession Regulations in the relevant jurisdiction.
 
Common requirements include:


== CRM ==
* Page numbers (always starting from 1)
* '''Demographics''' - Groups [[Contact|contacts]] into categories based on demographics such as age, gender or industry. [[Custom Field|Custom fields]] can also be used.
* Name and signature of the authorising [[member]]
* Date that the report was generated


== Matters ==
[[CPMS]] is <u>not</u> responsible for non-compliance arising from customised report templates.
* '''New Matters''' - Plots the number of new matters created versus the months in a given financial year.
* '''Overview''' - Lists matters and current balances for WIP, unbilled disbursements, debtors and trust.
[[Category:Reports]]
[[Category:Reports]]

Latest revision as of 10:40, 21 May 2025

ContactsLaw provides access to reports, which can be generated on-demand or according to a schedule.

You can view reports within the Desktop App or generate a document for printing, sharing and viewing offline. Most reports can also be exported in Microsoft Excel (.xlsx) or Comma-Separated Values (.csv) formats.

Properties

All reports have the same basic structure:

  • Title which includes contextual information (e.g. the period)
  • Options governing the generation of the report, as well as their default values
  • Results, usually consisting of one or more tables. These may include totals and grouping rows.

Available Reports

Accounting

  • Chart of Accounts - Lists accounts and their current balances.
  • Reconciliation Statement - Summaries a reconciliation and lists any unpresented payments or outstanding deposits.
  • Transaction Listing - Lists transactions debiting/crediting a particular account or ledger.

General

  • Aged Creditors - Lists creditors with unpaid invoices and groups outstanding amounts based on the number of days overdue.
  • Balance Sheet¹ - Lists asset and expense accounts and their balances as at a given date.
  • Profit & Loss¹ - Lists income, expense and owner's equity accounts and their net debit/credit activity over various periods.
  • Sales Tax (GST) - Lists transaction line items that fall within various categories designed to assist in the lodgement of a Business Activity Statement (BAS).
  • Trial Balance - Lists accounts and their debit/credit activity up to and including a given date.

¹ These reports are always presented on an accrual basis.

Trust

Important: Refer to compliance information below
  • Debit Balances - Lists transactions that result in a debit balance on a trust or controlled money ledger.
  • Journal Transfers - Lists trust journal transfers for audit purposes.
  • Ledger Balances - Lists the balance on each trust ledger (matter).
  • Ledger Titles - Lists changes to the title of trust ledgers (in accordance with Legal Profession Regulations).
  • Payments Cash Book - Trust payments cash book (for audit purposes).
  • Receipts Cash Book - Trust receipts cash book (for audit purposes).
  • Register of Controlled Money - Lists controlled money accounts and their current balances, along with the matters to which they relate.
  • Register of Powers & Estates - Lists powers and estates for audit purposes.
  • Transit Money - Lists transit money for audit purposes.
  • Trust/CMA Statement - Lists transactions affecting a particular trust ledger for a given period (in accordance with Legal Profession Regulations).

Billing

  • Aged Debtors - Lists debtors with unpaid invoices and groups outstanding amounts based on the number of days since the invoice was issued.
  • Bad Debts - Plots invoices written off versus the months in a given financial year.
  • Sales - Plots amounts billed for invoice items (excluding disbursements and interest) versus the months in a given financial year.
    • Sales by Member - Shows the distribution of the sales figure for a given period over the members responsible.
    • Sales by Matter - Shows the distribution of the sales figure for a given period over the matters involved.
  • Time - Plots billable time versus the months in a given financial year.
    • Time by Member - Shows the distribution of the time figure for a given period over the members responsible.
    • Time by Matter - Shows the distribution of the time figure for a given period over the matters involved.
  • Recovery - Plots invoice payments received versus the months in a given financial year.
    • Recovery by Member - Shows the distribution of the recovery figure for a given period over the members responsible.
    • Recovery by Matter - Shows the distribution of the recovery figure for a given period over the matters involved.

CRM

  • Demographics - Groups contacts into categories based on demographics such as age, gender or industry. Custom fields can also be used.

Matters

  • New Matters - Plots the number of new matters created versus the months in a given financial year.
  • Overview - Lists matters and current balances for WIP, unbilled disbursements, debtors and trust.

Compliance

Since subscribers have the ability to customise the templates used for reports, care must be taken to comply with Legal Profession Regulations in the relevant jurisdiction.

Common requirements include:

  • Page numbers (always starting from 1)
  • Name and signature of the authorising member
  • Date that the report was generated

CPMS is not responsible for non-compliance arising from customised report templates.