Articles in this section

Create a Billing Report

  • Updated
  • ~ minute read

What's in this Article

Applicable Roles/Permissions/Licenses

  • Roles: Admin
  • Permissions: Reports
  • Licenses: Time & Billing

Billing reports are designed to show you a detailed breakdown of different billing metrics in Canopy. You can access reports related to time on the Time Reports page located under Time on the global navigation bar. The guide for time reports can be found at Create a Time Report.‍ 

Create a Billing Report

1. Click Billing on the global navigation bar and choose Reports from the slide-in menu.

mceclip0.png

2. Select a relevant report. Report options are as follows:

Report type: Column description: Permissions requirements:

Aged Receivables Summary: displays a summary of all aged receivables in Canopy
  • Client: the customer
  • Current: balance owed in the current month
  • Aging Schedule: how many days an invoice is past due
  • Total: all outstanding invoices and credits
 Billing Reports, Contacts Not Assigned (to see all contacts)

Aged Receivables Detail: displays the specific details by contact
  • Invoice #: unique record number
  • Invoice Date: date the invoice was created
  • Due Date: date the invoice is due
  • Terms: date by which the invoice should be paid
  • Current: balance owed in the current month
  • Aging Schedule: how many days an invoice is past due
  • Total: all outstanding invoices and credits
 Billing Reports, Contacts Not Assigned

Profitability: shows the total profit for each task in Canopy using Time, Labor Cost, and Amount Billed
  • Group: by Contact or Service Item
  • Time Tracked By: the team member who tracked hours for the contact
  • Total Hours: total hours tracked
  • Billed Hours: hours that have been added to an invoice
  • Billable Amount: calculated by multiplying the rate by the duration of the time entries
  • Adjusted Amount: calculated by taking the billed amount less the billable amount
  • Billed Amount: the amount that has been billed to the customer (For the most accurate reporting, ensure that time entries are linked to invoices.)
  • Labor Cost: team member's hourly rate multiplied by the hours tracked
  • Balance: amount owed by a customer
 Billing Reports, Contacts Not Assigned, Team Member Salary

Revenue by Contact: shows a revenue breakdown by the assigned client
  • Contact: the customer
  • Date Range: revenue accrued between the chosen dates
  • Total: total revenue from the chosen period
 Billing Reports, Contacts Not Assigned

Revenue by Service Item: shows a revenue breakdown by the assigned service item
  • Service Item: services for which the firm charges customers
  • Date Range: revenue accrued between the chosen dates
  • Total: total revenue from the chosen period
 Billing Reports, Contacts Not Assigned

Revenue by Team Member: shows a revenue breakdown by the assigned team member
  • Team Member: employee tracked 
  • Date Range: revenue accrued between the chosen dates
  • Total: total revenue from the chosen period

*Billed service items associated with billed time entries will be included in this report. Billed service items not associated with billed time entries will not be included.

 Billing Reports, Contacts Not Assigned

Utilization by Team Member: displays billable hours, adjustments, and utilization by team member
  • Team Member: employee tracked
  • Total Hours: total hours tracked by team member
  • Billable Hours: sum of total billable hours tracked by team members for the selected date range
  • Billable Amount: calculated by multiplying the rate by the duration of the time entries
  • Adjusted Hours: calculated by taking the billed hours less the billable hours
  • Adjusted Amount: calculated by taking the billed amount less the billable amount
  • Discounts: calculation of any discounts that can be attributed to a team member
  • Total Adjustments: calculated by adding ‘Adjusted amount’ and ‘Discounts’
  • Billed Amount: the amount that has been billed to the customer (For the most accurate reporting, ensure that time entries are linked to invoices.)
  • Effective Rate: calculated by taking the amount in ‘Billed Amount’ and dividing it by the ‘Billable hours’
  • Percent Invoiced: calculated by taking the ‘Billed Amount’ and dividing by the ‘Billable Amount’
 Billing Reports, Contacts Not Assigned

mceclip1.png

3. Some reports allow you to show the breakdown according to different time periods. To use a preset time breakdown, click on the preset dropdown menu.

Choose to show a breakdown by week, month, quarter, or year.

mceclip2.png

4. Some reports can also be broken down into a custom date range. To select a custom date range, click on the date dropdown menu.

  • Choose one of the quick toggles on the left side of the dropdown menu, or utilize the calendar to select a specific date range.
  • After selecting the necessary custom date range, click Apply.

mceclip3.png

5. Reports can be exported as a CSV file. To export a report, click the options menu on the applicable report's viewing page.

Click Export CSV.

mceclip4.png