Skip to content
English
  • There are no suggestions because the search field is empty.

Consolidated client profitability reporting

This article guides you on how to generate client profitability reporting across offices

Step by Step Guide:

1. Before you get started

  • To access all client profitability reports in Counta, your User Access Group needs to have access to 'GL Client Profitability Reports'.
  • To use Employee Cost Rate or Time Entry Cost Rate for direct labor calculation, your User Access Group needs to have access to 'Employee Cost Rate'.
  • Your Employee record needs to have access to the offices you'd like to include in the consolidated client profitability report.
  • Exclude any non-operating GL accounts that you don't want to include the indirect overhead calculation.

Client profitability report basics

2. Navigate to Accounting > General Ledger > General Ledger Statements & Reports > General Ledger Reports

Select Client Profitability Report and follow the detailed steps here.

3. Cost calculation options

Your selection in the following areas impacts how client profitability is calculated: Direct Labour, Overhead Allocation, and Monthly Hours Cap.

Consolidated view

4. Select the offices or entity to include the report.

5. Uncheck 'Separate Report for Each Office?' to combine the data for all selected offices in one report. When this option is unchecked, the report will combine the revenue and direct costs for all clients across all offices. It will then allocate the indirect costs for all offices to all the clients accordingly.

6. When running a consolidated view of the report, you are required to specify the Report Currency to use.

7. Select the Current Exchange Rate or Consolidated Exchange Rates to convert all foreign currency amounts into the selected report currency.

Multi-office view

8. Select the offices or entity to include the report.

9. Check 'Separate Report for Each Office?'

10. By default, the report will use the office home currencies. You also have the option to convert all amounts to a specific Report Currency.

11. If you chose the option to convert the amounts to a specific report currency, use the Current Exchange Rate or Consolidated Exchange Rates .

12. Click Preview.

Tip: Offices without revenue or direct labor costs

When you check 'Separate Report for Each Office?' and you included an office with no direct labor or revenue, the overhead costs for these offices will be reported against a 'No Client Assigned' line. This ensures that the report always ties back to the financial P&L and these offices are included in your cost accounting.