The Sales Report provides a consolidated view of your sales across all entities. It offers a single location to review key metrics, track performance, identify trends, and support data-driven decisions. Instead of switching between different views, you can now access all your key sales metrics in a single place. This makes it easier to track performance, spot trends, and make informed decisions.
Table of Contents
How to Export or Send the Sales Report
Before You Start
Here are a few things to know before you continue:
- By default, Admins and Office Staff have access to Reports (Beta). Admins can also choose to grant access to other roles.
- If you don't see the Reports (Beta) option in your menu, you may not have the necessary permissions. Reach out to your Admin for access.
- If you are an Admin and would like to grant additional employees access to reports, please check out this article.
Key Features
- Sales Summary: Displays a summary of the totals of clients, invoices, and different important balances.
- Sales, Client & Rep Filtering: Allows users to filter results by client name, client type, or sales representative.
- Detailed Breakdown: Lists important segmented information regarding each sale.
- Pivot Table View: Presents the data in a table format organized based on your ‘Sales By’ filter.
Using the Sales Report
- Click ‘Reports (Beta)’ in the left-hand menu under ‘Administration.’
- Scroll down to find ‘Sales [Beta]’ listed under ‘Financial Reports.’
- Click ‘Open Inline’ to run the report in Docket.
Please Note: For more information on other ways to run a report, please check out this article.
Sales Report Summary
When the report loads, you'll see a summary at the top that breaks down your sales into key categories, giving you a quick and easy snapshot of your overall performance.
The different categories in this summary of sales:
- Number of Clients
- Number of Invoices
- Total Profit
- Average Invoice Amount
- Subtotal
- Total Invoiced
- Total Balance
Please Note: The summary will automatically update after each filter option is selected or changed.
Sales Report Filters & Table
Report Filters
Below the sales report summary, you can refine your results using filter options.
The Sales Report offers a range of filters to help you narrow down and view specific data:
-
Sales By: Select how you want to display sales data. Available options include:
- Invoice: Dive into invoice level data.
- Sales Rep: Breakdown into sales rep level data and expand the table to show invoice level data per sales rep.
- Line Item: Examine line item level data. The line item table shows the frequency and dollar amounts associated with line items according to selected filters.
- Timezone: Choose the timezone the report should reference.
- Date Range: Pick date or date range for the report data.
- Sales Rep: Filter results by specific sales representatives.
- Client: View results for a specific client.
Expanding Sales Data in Table
When using the ‘Sales By’ options of ‘Sales Rep’ or ‘Client’, you will have an additional option in the table to expand the summary information. To view more details, for an individual sales rep or client, click the ‘+’ icon next to their name. This will expand the table to the right where you can scroll to see all relevant information. To expand all details, click the ‘+’ at the top-left of the table, appearing next to ‘Sales Rep’ in the example below.
Please Note: Before exporting or sending a table, be sure to use the ‘+’ icon at the top of the table to expand all rows if you would like the additional details included. Only fully expanded rows will appear in the exported or shared file; partially expanded rows will not be included.
How to Export or Send the Sales Report
Export Report
Once you have your report displaying the information you want, you can download it for your records.
- Hover over the table so a menu appears in the top right corner of the table.
- Click the three vertical dots.
- In the menu that appears, hover over ‘Export.’
- Select your file preference in the list of options that appear in the dropdown and the report will download in the file format you selected.
- When exporting as a PDF, you can choose Portrait or Landscape layout.
Please Note: You can export up to 1 million rows at a time. If your table contains more than 1 million rows, we recommend using filters to break the data into smaller, exportable chunks.
Send Report
In addition to downloading the report to your computer, you can also email the report.
- Hover over the table so a menu appears in the top right corner of the table.
- Click the three vertical dots.
- In the menu that appears, hover over ‘Export.’
- Click ‘Export…’ at the bottom of the list under the ‘Send’ section.
- In the pop-up that appears, click the mail icon.
- Enter the email address of the recipient.
- Click ‘Export’ to send an email with the report attached.
Please Note: On the final screen, you can also customize the email subject, select specific attachments and file types, or send the report as a .zip file.
If you have any questions, please reach out to our Support team through the chat widget on the bottom right of this page or by sending an email to support@yourdocket.com!