Create a Customer List Report (Advanced)

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

  1. From the Trash Flow tilebar, click Reports > Customer Reports > Customer List.
  2. Choose a Report Format and what method the report should Sort by.
  3. Use the data filters to pick whether you want to include all customers or only some. See "Reference: Data Filters" below for more information.
  4. 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.
  5. Use the data display settings to set which details to show. See "Reference: Data Display Settings" below for more information.
  6. Choose whether you want to Preview the report (usually checked) and Show Report Criteria (usually unchecked).
  7. Click OK 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.
  • Started in date range: customers who started service between the Start Date and End Date on the report;
  • Ended in date range: customers who ended service between the Start Date and End Date on the report;
  • Ended: customers who have ended service (i.e., have an end date on their Rates tab before the current business date);
  • Active (Not Ended): current customers (i.e., don't have an end date before the current business date);
  • Expired Credit Cards: customers whose credit card has expired;
  • Not on a Route: customers not assigned to a route;
  • Without Charge Amts.: customers without a recurring rate on their Rates tab or container placements;
  • Suspended: customers whose accounts are suspended as of the current business date;
  • Tax Exempt: customers with anything in the Tax Ex# box on their Rates tab;
  • Email Billing: customers who receive bills via email (whether or not they also get a paper bill);
  • Paper Billing: customers who receive paper bills (whether or not they also get an emailed bill);
  • Email & Paper Billing: customers who receive both paper and emailed bills;
  • Email Billing Only: customers who only receive bills via email;
  • Paper Billing Only: customers who only receive paper bills;
  • Late Fee Exempt: customers who never get a late fee or finance charge when Assessing Finance Charges. This is set by changing the Late Fees dropdown on the Rates tab;
  • Routed only: only customers on at least one route;
  • Invalid Billing Email: customers for whom we received a bounceback message when trying to send emails;
  • Has Pop-Up Notes: only customers who have pop-up notes on their Notes tab; and
  • Active in date range: only customers who were active on at least one date during the report's date range.
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.