Short-term agreements
Derived from activated plans; listed with type, status, cap and period.
CollMind TPM · Agreements
Agreements and claims: from plan to agreement to transaction
An activated plan becomes a short-term agreement; long-term agreements enter plan calculations through rate tables, sliced by period. On- and off-invoice transactions are uploaded via Excel/CSV and validated row by row; claims can be entered manually and wrong entries are corrected with reversing entries.
The challenge
Agreements in folders, transactions in spreadsheets
Annual discount agreements and periodic support sit in contract files, while realised discounts sit in separate spreadsheets. Nobody can see in one place how an agreement enters the plan calculation, or which transaction belongs to which agreement.
- Short- and long-term agreements are kept in different places.
- Long-term agreement rates are copied into plans by hand.
- Faulty rows are noticed only after upload.
How it works
- Step 1
Activate the plan
When an approved plan is activated, a short-term agreement is created.
- Step 2
Long-term rates apply
Rate-based long-term agreements enter plan calculations by period; if a rate is missing, the calculation stops by name instead of assuming zero.
- Step 3
Upload transactions
On- and off-invoice transactions are uploaded with Excel/CSV templates: upload → validate → confirm.
- Step 4
Correct entries
A row-level error report is shown; single claims are entered manually and wrong entries are closed with reversing entries.
Key capabilities
Long-term agreements
Annual agreements with rate tables; enter plan calculations by period.
On- / off-invoice upload
Excel and CSV templates with upload, validation and confirmation steps.
Row-level error report
Problem rows show up with their reason before posting.
Manual claim entry
Single off-invoice claim records can be entered by hand.
Reversing entries
Nothing is deleted; wrong transactions are corrected with reversing entries.
Screens
Who it is for
Planners
Activate plans and follow their agreements.
Finance
Upload on- and off-invoice transactions and enter claims.
Category managers
See active agreements and caps in their category.
Screenshots use demo data; brand, customer and user names are illustrative. The product UI is shown in Turkish.
Roadmap
Coming next
The items below are not yet available; they are in development or planned.
- In development
Sales actuals upload
Importing sales, on-invoice discount, free-goods and return lines from the ERP.
- In development
Automatic matching
Candidates found by period, customer group, category and channel; a single candidate matches automatically, ambiguous lines go to a queue with a reason code.
- In development
Tolerance and variance line
A two-sided threshold on rate and amount; unexplained variance is not spread over tactics but kept as a separate line.
- In development
Off-invoice claim calculation from actuals and agreement close-out
- Planned
Customer deductions / external claims intake, reconciliation screen, period close
- Planned
Claim document reading with Coll (does not calculate amounts) · e-reconciliation
Let’s model your agreement structure
We will show how your short- and long-term customer agreements are recorded in CollMind TPM.