What's new ·

The companies' commission statements in Horizon CRM

Import your companies' commission statements: Horizon CRM reads them, you check, and your commission follows the money actually paid.

Horizon CRM calculates commission from the rates you enter: it is an estimate, and the amount actually paid by the company may differ. The firm's team head can now choose to work from the companies' commission statements: the amounts, the reports and everyone's share then follow the money actually received.

Choosing the source of commission

In the firm's settings, three choices, never mixed:

  • Horizon calculation: commission calculated from your rates, as before.
  • Statements only: the amounts of the statements you import, without forecasts.
  • Statements + forecasts: the amounts of the statements, and the servicing commission extended according to each company's payment rhythm.

Importing and checking a statement

  • Upload the statement the company sends you: PDF (scans included), photo, Excel or CSV.
  • Horizon CRM reads it line by line and records what is printed: client, policy number, product, amount. It recalculates nothing.
  • You check, with the original statement next to what Horizon CRM understood from it, and the sum of the lines checked against the printed total. Nothing is saved before you approve.
  • Each amount is linked to its contract, first by the policy number, then by the name. An uncertain match is never linked on its own: it is proposed to you.
  • Nothing is counted twice: a line already imported is recognised.

Reports on the money received

With statements, the reports page shows what has been received, what is expected, commission clawbacks and the estimates still waiting for their statement, under the same filters as the list. “Who owes what” gives, for each team member and for the firm, the share of the money received and the clawbacks to repay. The PDF report shows the same figures.

What the feature does not do

  • Fetch the statements from the companies: you are the one who uploads the file.
  • Reconcile the statements with your bank accounts.

Importing statements starts with the Established plan. Without statements, commission is still calculated from your rates: check it against your statements.

← All the news

Try Horizon CRM on your own files.

14 days free: CHF 0 if you cancel before day 15.

Free trial 14 days · CHF 0 if you cancel before day 15