Heads Up! If you see features in this article that aren’t in your account, you may be on the Legacy CRM, and 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.
The profitability report shows the total profit for each task in Canopy using Time, Labor Cost, and Amount Billed.
1. Navigate to Billing from the global navigation bar
2. Click Reports
3. Click on Profitability
Group By:
Client
Client Group
Service Item
Client:
Client Group:
Service item:
Filter By:
This week
This month
Last month
This quarter
Last quarter
Year to date (default)
Last year
Custom
Owner:
Owner of the client.
Time Tracked By:
The team member who tracked hours for the client.
1. Click on the client name
2. Expand the service item
3. Expand Tasks if needed
Total Hours:
Total hours tracked for each client.
Billed Hours:
Hours that have been added to an invoice.
Billable Amount:
Calculated by multiplying the rate by the duration of the time entries. Ensure that Service Items on time entries align with those on invoice lines to prevent $0 billed amounts.
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). For example, unlinked time entries are excluded from reports, causing discrepancies in billed amounts. Ensure that Service Items on time entries match those on invoice lines to avoid $0 billed amounts.
Labor Cost:
Team member's hourly rate multiplied by the hours tracked. Missing costs in reports may occur if the team member's time cost is not added to the invoice.
Balance:
The amount owed by a customer.
Troubleshooting Discrepancies in the Profitability Report
Common Causes
Archived, Deleted, or Inactive Entries: Ensure all relevant entries are active and not archived or deleted, as these are excluded from most reports.
Unlinked Time Entries and Invoices: Link time entries to invoices and ensure Service Items match to avoid discrepancies.
Service Item Mismatches: Verify that Service Items on time entries align with those on invoice lines to prevent $0 billed amounts.
Best Practices
Verify Data Linking: Ensure all time entries are linked to invoices and Service Items match.
Check Entry Status: Confirm that relevant clients, invoices, and time entries are active.
Review Report Filters: Adjust date ranges and filters to include all relevant data.
Troubleshooting Tips
Zero Billed Amounts: Check Service Item alignment between time entries and invoice lines.
Discrepancies in Profitability Reports: Verify linking of time entries and invoices, and ensure no relevant data is archived or deleted.
