Heads Up! If you see features in this article that aren’t in your account, this article may be what you're looking for instead.

Billing reports are designed to show you a detailed breakdown of different billing metrics in Canopy. You can access them 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.‍

Please note that differences in calculation methodologies across various report types may result in discrepancies.

Create a Billing Report

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, Assigned Clients
Aged Receivables Detail: displays the specific details by client	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, Assigned Clients
Profitability: shows the total profit for each task in Canopy using Time, Labor Cost, and Amount Billed	Group: by Client or Service Item Time Tracked By: the team member who tracked hours for the client 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, Access To All Clients, Team Member Salary
Revenue by Client: shows a revenue breakdown by the assigned client	Client: the customer Date Range: revenue accrued between the chosen dates Total: total revenue from the chosen period	Billing Reports, Access To All Clients
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, Access To All Clients
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, Access To All Clients
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, Access To All Clients

Additional Notes:

Archived and deleted data (time entries, expenses, and invoices) are generally excluded from reports, though inactive clients might appear in some cases.
Certain reports may exclude tax or have report-specific filters (e.g., "Revenue by Client" excludes inactive and archived clients).

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

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.

Click Export CSV.

Understanding Report Discrepancies

Financial reports in Canopy can sometimes display discrepancies due to variations in inclusion criteria, data linking, and account settings.

Common Sources of Financial Report Discrepancies

Archived, Deleted, or Inactive Data
- Financial reports may exclude archived and deleted data but include inactive entries in certain cases.
- Example: Ensure relevant records are neither archived nor deleted for accurate Profitability Reports.
Unlinked Time Entries and Expenses
- Revenue-related reports depend on properly linked time entries and expenses.
- Example: "Revenue by Team Member" requires billable activities linked to invoices.
Report-Specific Criteria
- Reports like "Revenue by Service Item" and "Revenue by Team Member" have unique methodologies, which might include or exclude specific data, such as archived/deleted time entries, invoices, or service items.

Reconciliation Tips and Best Practices

Verify that data like time entries or costs are linked to invoices.
Understand specific report criteria for inclusion/exclusion of data.
Review statuses of clients and ensure correct categorization as active/inactive.
Utilize Canopy's tooltip documentation to clarify report metrics.

Key Takeaways

Discrepancies arise from varying methodologies, unlinked records, and archived data.
Align data linkage and understand report logic for accurate summaries.
Leverage Canopy's resources and support tools to ensure reports meet organizational needs.

Create a Billing Report

Create a Billing Report

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

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

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

Understanding Report Discrepancies

Common Sources of Financial Report Discrepancies

Reconciliation Tips and Best Practices

Key Takeaways

Create a Billing Report

Create a Billing Report

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

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

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

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.

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

Understanding Report Discrepancies

Common Sources of Financial Report Discrepancies

Reconciliation Tips and Best Practices

Key Takeaways