All Collections
Where do I start
Statements
Generic template - Loading commission data for unsupported file formats
Generic template - Loading commission data for unsupported file formats

The generic statement template can be used when a provider statement file is only available in an unsupported format, e.g. PDF

Elsa Stadler avatar
Written by Elsa Stadler
Updated over a week ago

Start by navigating to Statements, then click on Import button:

Download a copy of our Generic Excel Statement Template by clicking on the link:

Complete the template with the information you want to import.
​NB: Don’t change any of the column header names or remove any columns.
There are additional columns that can optionally be added to the template (please contact us to help you getting started with this), e.g.:

  • Responsible Partner

  • Agreement

  •  Inception Date

  • etc


Once you've completed all the information on the statement, you can import it like any other provider statement 👍 

Important points to remember

The following fields are compulsory for each row:

  • Policy Number

  • Client

  • Commission Type

  • Premium (specify 0 if not applicable)

  • Fees (specify 0 if not applicable)

  • Commission (incl. VAT)

  • VAT (specify zero if there is no VAT in the item)

  • Total Income (incl. VAT)

In addition, the following rules must be applied:

  • Fees + Commission (incl. VAT) must equal Total Income (incl. VAT)

  • Nett Income (excl. VAT) + VAT must equal Total Income (incl. VAT)

Tip: You are welcome to use Excel formulas in the template. 

If you find that you have statements in electronic format, but the columns are constantly not showing correctly (in separate columns) have a look at the Article named "Commission Statements in wrong format".

Did this answer your question?