Filter Office 365 Licenses by Location or Department

Filter license by Office/department/city/state

A unique ability that Sync 365 provides, is to be able to filter your Office 365 licenses to split billing up for your clients.


Use case 1: You have licenses that you add for your MSP to provide services and do not bill the client for. You can exclude these licenses from being billed.


Use case 2: You have a client which has multiple locations. They have a single Office 365 tenant, however they allocate costs to each location for the licenses.

With Sync 365, you have the power to help them automate their billing, but splitting out their Office 365 invoicing based on their staff location.

This allows you to link the relevant office/area to a different agreement in PSA and bill them separately.


If you need to bill them to different PSA companies entirely, you can add the Office 365 tenant multiple times and link to each of the required companies with their relevant filter.



Here is a video on this feature, or you can follow the directions below.



How to filter licenses

To get started, add the clients office 365 tenant and link it to the relevant company in your PSA that you would like to bill for this location.


For this capability, we use fields in the user accounts in Azure AD (Office 365). You can use one or multiple of the following fields in a user account to filter the licenses:

Office, Department, State or City

Names can be case sensitive. For example if you were setting up users for a New York office, you may use “New York” either in City or Office in the Office 365 user settings.


This is the users “Contact information” in the office 365 admin center.

In the agreement sync configure the filtering as follows.


  1. If you would like to exclude any licenses from being filtered, tick them first. (i.e. head office may pay for all advanced threat protection licenses so you could tick for those to be excluded from filtering.)
    Otherwise, do not tick these boxes.
  2. Click the “Filters” button
  3. Enter in text to the attribute you would like to filter. I.e. in Office enter the office name you have set in the user profiles in Office 365
    NOTE: This is an “and” style filter, so if you enter in an office and a country, it will be looking for both of those details in a user account.
  4. If you would like to reverse the filter and exclude these licenses tick the exclude checkbox
  5. Click apply
    We will evaluate the users for that Office 365 Tenant and grab the user accounts that match the filter and you will only see thelicenses applied to those users.


You can now link those licenses to an agreement as normal.

Add another Filter

If you need to filter some more licenses for this tenant to map to a different agreement, you can click on the “Add more filters” button to get an additional set of filters to use.

Add another location

Now that you have set up a license sync for that location, if you need to filter and sync licenses to a *Different* PSA company, you can add the Office 365 tenant and link it to the next location for that company in PSA. You can then repeat the process to invoice that specific PSA company.

    • Related Articles

    • Linking Multiple PSA Companies to a single Microsoft 365 Tenant for Billing

      Sync 365 supports linking multiple PSA companies to a single Microsoft 365 tenant. This is useful when different customer entities or business units are managed separately in your PSA but share a common Microsoft tenant. To map multiple PSA companies ...
    • Custom License Billing

      With Sync 365 you have a range of options to generate the quantity of what you need to bill. Custom License Ideas Bill your managed users by one of the following: Azure AD Licensed users A group in Azure AD Copying a Microsoft 365 License Bill your ...
    • View license sync history

      To view the sync history of a customer tenant. Open the Customers tab Click on the name of the customer you would like to see This will bring up a sync overview and you will see a tab with history so you can see the history of license sync While you ...
    • Microsoft 365 Contacts to PSA Contact Sync

      Our contact sync functionality provides flexible options for syncing the customers Microsoft 365 Contacts to your PSA. With our contact sync filters, you can get the right contacts to the right site/location in your PSA. You can filter by All ...
    • 3 - Configure billing profiles

      Billing profiles are the backbone of Sync 365 (S365). They allow you to specify the product used so we can add/update the correct product on the agreement/contract. Essentially, billing profiles automate the billing of Microsoft 365 license types or ...