Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
Profitability by Client report
Profitability by Client report
Profitability by Client report

  1. To view this report, navigate to Reports and search for the Profitability by Client report.
  2. Select the report and apply filters

    Report columns explained:


    Column nameExplanation
    1ClientName of Client
    2BilledSum of Invoices plus Credit notes to Client
    3Est Cost BilledCost portion on Tax Invoice to Client
    4Est MarginBilled minus Estimated Cost Billed (column 2 - column 3)
    5%Estimated Margin represented as a %
    6Act Cost - Est Cost Billed

    Actual cost (Sum of Supplier invoices plus Supplier Credit notes) minus Estimated Cost Billed (Column 3)

    Actual Cost - Column 3. Where Actual cost = Sum of Supplier invoices plus Supplier Credit notes

    7Gross Margin Estimated margin minus Actual Cost - Est Cost Billed. (column 4 - column 6)
    8%Gross Margin represented as a %
    9Job HoursTimesheet Hours logged
    10Hours ValueActual hours value from User Financials
    11Nett MarginGross margin minus Hours value. (column 7 - column 11)



...