Sales & CRManalysisdashboardShippedVerified by us

Sales by Manager

Payments → table of each manager's contribution

Secure payment tokens pass through attribution rules into anonymous command lines and a read-only report

In short

If a manager is not recorded at the time of payment, the sales report turns into a manual investigation, and disputed or unattributed rows disappear from view.

Outcome

A read-only report calculates sales by transparent rules, separately shows returns, disputed and unattributed payments, and restricts visibility by the requester's role.

How the automation runs

Trigger

Authorized employee requests a report for a specified period

Automation steps

  1. Takes requester's identifier from trusted context, not from command text
  2. Applies role-based visibility and fixed period boundaries
  3. Links payments to managers by versioned attribution rules
  4. Separately accounts for returns, cancellations, disputed, and unattributed rows
  5. Returns aggregates and control sums without changing the payment database

Human check

The supervisor reviews disputed rows and approves rule changes; the report does not automatically make personnel or compensation decisions.

Outcome

A read-only report calculates sales by transparent rules, separately shows returns, disputed and unattributed payments, and restricts visibility by the requester's role.

Automation diagram

The overall logic is public
Input
TriggerAuthorized employee requests a report for a specified period
System
Step 1Takes requester's identifier from trusted context, not from command text
System
Step 2Applies role-based visibility and fixed period boundaries
System
Step 3Links payments to managers by versioned attribution rules
System
Step 4Separately accounts for returns, cancellations, disputed, and unattributed rows
System
Step 5Returns aggregates and control sums without changing the payment database
Human
Human controlThe supervisor reviews disputed rows and approves rule changes; the report does not automatically make personnel or compensation decisions.
Outcome
Observable outcomeA read-only report calculates sales by transparent rules, separately shows returns, disputed and unattributed payments, and restricts visibility by the requester's role.

Using it

When to use it

The payment circuit reliably links to the sales initiator, and the team needs a regular report with access differentiation.

How to verify

Totals match the payment register for the same timezone, returns are excluded by rule, the manager sees only the authorized slice, and an unattributed row is explainable.

Tools

postgrestelegrampythonrole-based access

Recipe details

Time1 eveningDifficulty3 of 5Steps5Prerequisites3
Access to the whole library

Open every recipe through @venturehunter

We ask for no phone number, no password and no Telegram login on the site. @penioza_bot checks your subscription inside Telegram and brings you back here with access to every kit, not just this one recipe.

No emailNo site loginOne check for the whole libraryBuildable starter

Need help putting this in place?

We will walk through your process and build this loop around your data, your limits and your people.

Message me — I will help