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.

Discrepancies between a client's Year-To-Date (YTD) revenue and their invoice totals on Canopy often arise from factors such as calendar year basis, accepted payments-only criteria, and exclusions of specific data like archived invoices or draft invoices.

By understanding the varying inclusion and exclusion rules between different report types, users can address discrepancies and ensure reconciliation across reports. This involves aligning data sets and configuring consistent settings regarding clients, invoices, and service items.

Discrepancies Related to YTD Revenue

Additional detailed factors affecting the Year-To-Date (YTD) Revenue records include:

Specific data linkage, such as time entries or expenses connected to service items or invoices.
Differing transaction types across reports, for example, inclusion of declined payments or credits in some reports but not others.

Adjustments such as write-ups and write-downs made to invoices.
Exclusions like archived or draft invoices impacting revenue calculation accuracy.

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.
The YTD Revenue chart excludes archived, deleted, or draft invoices, as well as inactive or archived clients.

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 and Adjustments

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.
Adjustments such as write-ups and write-downs are accounted for differently in different reports.

Basis of YTD Revenue Charts

The chart operates on a calendar-year basis and includes only accepted payments rather than issued invoices.

Report Comparison Scenarios

Revenue by Client, Service Item, and Team Member

The Revenue by Client report excludes archived, inactive, and deleted clients, as well as archived and deleted invoices.
The Revenue by Service Item report excludes archived and deleted clients and invoices but includes inactive clients and archived or deleted service items.
The Revenue by Team Member report includes archived and deleted time entries and inactive clients but excludes archived and deleted clients and invoices. To reconcile these, adjust statuses to include only active, non-archived, and non-deleted records across all reports.

Payments Collected, Payment Receipts, and Payment Methods Graph

Payments Collected includes only accepted payments applied to invoices or credit and excludes manually created credits.
Payment Receipts can include declined payments, leading to higher totals.
The Payment Methods Graph may include inactive, archived, or deleted clients and team members. Align criteria and date ranges across reports to resolve discrepancies.

YTD Revenue by Service Item vs. Other Revenue Reports

The YTD Revenue by Service Item report excludes archived or deleted service items, inactive clients, and revenue not linked to service items.
Discrepancies may occur if line items are not properly linked to service items. Review linkage and client/service item statuses to ensure accuracy.

Reconciliation Tips and Best Practices

To ensure consistent and accurate reporting, consider the following strategies:

Align inclusion and exclusion settings across reports to ensure uniformity in data sets.
Regularly review filters and date ranges to verify they are accurately applied.
Maintain proper data linkage, ensuring that all relevant records are connected to applicable service items or invoices.
Compare specific criteria between reports to identify and resolve inconsistencies.

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.
Use the Insights feature in Canopy for a comprehensive and accurate view of revenue metrics, as it accounts for all relevant data beyond the limitations of the YTD Revenue chart.

Key Takeaways

Different inclusion and exclusion rules are the primary cause of discrepancies.
Aligning data linkage, settings, and criteria is crucial for achieving consistency in reports.
Utilize specific reconciliation strategies for tailored solutions, particularly when discrepancies arise between related reports.

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

Discrepancies Related to YTD Revenue

Report Comparison Scenarios

Revenue by Client, Service Item, and Team Member

Payments Collected, Payment Receipts, and Payment Methods Graph

YTD Revenue by Service Item vs. Other Revenue Reports

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

Discrepancies Related to YTD Revenue

Report Comparison Scenarios

Revenue by Client, Service Item, and Team Member

Payments Collected, Payment Receipts, and Payment Methods Graph

YTD Revenue by Service Item vs. Other Revenue Reports

Reconciliation Tips and Best Practices

Key Takeaways