The customer list is one of the most commonly run reports in Trash Flow. It's a way to get a list of all customers or a given subset of customers. This guide explains how to create the report, including all available options. You must have Edit Financials in Intro: Access Control to run a Customer List. A sample report appears at the bottom of this topic.
Context
Customer lists are run for many reasons. Some examples:
- see how many active customers you have;
- look for customers who aren't on a route;
- see if any customers don't have a rate on their account and are getting free service;
- compare how many customers are in different regions;
- figure out how many new customers started in the past year;
- find accounts set up for automatic payment where the credit card has expired.
Create the Report
- From the Trash Flow tilebar, click .
- Choose a Report Format and what method the report should Sort by.
- Use the data filters to pick whether you want to include all customers or only some. See "Reference: Data Filters" below for more information.
- You may need to set a Start Date and End Date, if you're looking for customers with a specific activity during a given time period.
- Use the data display settings to set which details to show. See "Reference: Data Display Settings" below for more information.
- Choose whether you want to Preview the report (usually checked) and Show Report Criteria (usually unchecked).
- Click to review and print.
Reference: Data Filters
The customer list is a highly customizable report that lists details about your customers. Some of the options here set which accounts will be included in the report.
| Option | Description |
|---|---|
| Account Type | Choose whether to include residential, commercial, contract, or all customers. |
| Billing Group | Choose whether to include customers in a specific billing group, or in all billing groups. |
| Sales Tax District | Choose whether to include customers from a specific sales tax district or from all districts. |
| Bill Codes | Choose whether to include customers with all bill codes, with one specific bill code, or no assigned bill codes. |
| Geographic Region | Choose whether to include customers in a specific geographic region, all geographic regions, or no geographic region. |
| Select Customers 1 and 2 | These two fields can be used to set additional options for the report.
|
| Starting Account # | Choose to start the report at the specified account number and include all higher account numbers. If this box is left blank, the report will include all relevant customer accounts. |
| Source Co. | Choose whether to include customers from a specific source company or from all companies. |
| Salesperson | Choose whether to include customers from a specific salesperson, from all salespeople, or from no salesperson |
| Business | Choose whether to include customers of one of your businesses or customers of all your businesses. |
| EFT Customers Only? | Choose whether to only include customers who are billed by electronic funds transfer (EFT). |
Reference: Data Display Settings
These options set which details will be included in the report.
| Option | Description |
|---|---|
| Show Rates | Choose whether to include the rates each customer pays. |
| Show Addresses | Choose whether to include the customer’s address. |
| Show Phone # | Choose whether to include the customer’s phone number. |
| Show Routes | Choose whether to print the routes each customer is on. If you choose to export the customer list rather than create a PDF then the resulting file will include a separate line for each route a customer is on. |
| Show Active Placements Only |
When including container placements on the report, restricts the list to only placements that are currently active. |
| Print Bill checked only | Includes only autopay customers with Include in Printed Bills checked on the Misc. tab. |
| Bill-to format | A specialized format that lists each bill-to master account along with all its sub accounts. |
| Show Details | Choose whether to list all customers who meet the criteria. If unchecked the report will only list the total number of customers that fit the categories chosen above—no account details or customer names will be printed. |
| Show Email Addresses | Choose whether to display email addresses, whether or not the customer receives email bills. |
| Show Notes | Choose whether to print notes from the customer’s account. |
| Show Pop-Up Notes | Choose whether to print any pop-up notes on the customer’s account. |
| Show Placements | Choose whether to list the customer’s container placements. |
| Payment Method on file Only | List only customers with a payment method saved on their E.F.T. tab, but are not set for autopay. |
| AutoPay Customers Only | List only customers with a saved payment method who are included in autopay. |
When You're Done
The finished report includes a list of all customers that meet the criteria (if Details was checked) and a final line with the total number of customers listed.
Sample Report
For Trash Flow Mobile users: Report options on Trash Flow Mobile will work just as described in this article and appear in the same order. The user interface is slightly different to accommodate how we use tablets and phones. For more details, or to learn more about accessing your data from a phone or tablet, see Using Trash Flow Mobile.
