TrashCanBossPro Blog — Trash Can Cleaning Software

Clients, Addresses and Tags: Organizing a Bin Cleaning Customer List

A customer list is only as useful as it is organized. Three hundred rows in a spreadsheet tell you who your customers are. A well-organized list in your software tells you who is due, who is weekly, who belongs to which HOA, and who to text when a city changes its trash day.

After the Sign-Up

In Sign-Ups and Estimates in Trash Can Cleaning Software, new customers came in through forms and estimates and were converted into clients. This article is about what happens to them next: how they are stored and sorted so the list stays useful as it grows.

Clients and Addresses Are Different Things

The most important idea in organizing a bin cleaning list is that a client and an address are not the same thing. In TrashCanBossPro:

• The client is the person or company you deal with and bill.
• The address is where the cans are.

Most residential customers have one address. But one client can have many: a family with a home and a rental, a property manager with twenty houses, an HOA with a clubhouse and dumpster pads.

Keeping them separate means each address holds its own bin cleaning details while the client holds the contact information and billing.

What Lives on the Address

Each address carries:

• Trash, recycling and yard waste can counts
• The city trash pickup day
• Can location notes and gate codes
• The plan and when it is next due

That is what shows under the address on the lists and on the tech's phone: "2 trash · 1 recycling · Trash day Tue." For more on why that matters, see Cans per Address: How Trash Can Cleaning Software Keeps Track of Every Bin.

Tags

Tags are labels you put on clients so you can sort and filter them. Common bin cleaning tags in TrashCanBossPro include:

• Monthly
• Every-Other-Week
• HOA
• Commercial

Filter by a tag and you get exactly that group. All your HOA accounts. All your every-other-week customers heading into summer. All your commercial stops. That is useful for planning, for texting a group of customers about a change, and for seeing how your business is split.

You can add your own tags as well. Some companies tag by neighborhood, by service area, or by how the customer found them.

Custom Fields

Some information doesn't fit a tag. An HOA board contact, a contract renewal month, a preferred contact time. Custom fields let you add your own fields to client records, so that information lives in the system instead of in someone's head.

A good rule: if you find yourself writing the same kind of note on many clients, it probably belongs in a custom field.

Keeping the List Clean

A list gets messy one small shortcut at a time. A few habits keep it clean:

• Search before you add. A returning customer should get their old record back, not a duplicate. Duplicates split history and billing between two records.
• Add new properties as addresses, not new clients. When an existing client buys a rental, add an address under them.
• Update cans and trash day the day you hear about a change.
• Tag at the moment of sign-up. It takes seconds then and an afternoon later.

Bringing an Existing List In

If your list lives in a spreadsheet today, you don't have to retype it. TrashCanBossPro supports CSV import of an existing customer list. Clean the spreadsheet first, import it, then add cans, trash day, plans and tags. That process has its own guide later in this series.

Putting the List to Work

An organized list pays off in small moments all week. A city announces a new trash day for one neighborhood, and a neighborhood tag pulls up every address that needs updating. You raise the price of every-other-week plans for summer, and the Every-Other-Week tag gives you the list of customers to text. An HOA board asks how many of its homes you serve, and the client record shows every address under it. None of these take more than a minute when the list is clean. With a messy list, each one becomes an afternoon of searching and guessing.

The Takeaway

Keep clients and addresses separate, put the can details on the address, tag clients so you can filter them, and use custom fields for everything else. A list organized this way stays useful at three hundred customers and at three thousand. For how the customer list fits into the full system, visit the trash can cleaning software page.