Filters in Analytics: the example of using filters for analysing each employee’s salary

Finmap

Reading time of the article – 7 minutes
▶️ Watch video – 45 seconds

ㅤㅤ

ㅤLet’s take a look at how the service can track the amount of income for each individual sales manager and calculate the bonus that will go to the managers’ salaries.

ㅤIf you enter a client as a specific counterparty when entering transactions. As a rule, each of these clients is entered by name and surname:

ㅤㅤㅤ

Step 1

ㅤWe can tag such transactions with the name of the manager who sold goods or services to this customer.


ㅤYou can tag a transaction immediately in the operation as follows:

1. we mark the necessary operations with a tick:

2. Click on “Change data”

ㅤIn the list, select Change tag, select a tag from the ones created in the list, or you can also create a new tag immediately in this field

ㅤㅤ

3. Save by clicking “Add”

ㅤDone! The tag has been added to all the operations we have selected

Step 2


ㅤAfter we have set the tags that specify the manager, we go to Analytics. Let’s take the example of the Profit report


ㅤGo to the table format of the report display 👉

ㅤOpen the advanced filter and search only for the manager Alexey tag, click Done 👉

ㅤThe service will provide us with the amount of profit that Alexey has brought to our company over the entire period of time

Step 3

ㅤNow let’s see, using filters, how much we pay this manager in salary for the entire time.

ㅤSpecify the Salary expense category in the filter and get the amount of the manager’s salary per month, as well as the total amount for the entire time:



ㅤCompany data may look different. Managers can be entered as counterpartiesSearching by filters will follow the same logic

ㅤYou can view reports by counterparty or, if necessary, select a specific counterparty in the advanced filter:


ㅤ📌 By the way, you can save filters and apply them later in just a couple of clicks: