The project is for a company, which deals with insurance. (I’m doing a training there).
Basically, the info on the database have to be send to a “bordereaux” (sheet). There is a bordereaux for each insurer.
First, with the info of the DB, I produce an invoice and then I ‘update’ the insurers bordereaux. The calculations are a bit complicated (see below)
Imagine an invoice with a premium and a tax e.g. Pr £150 tax 5% £7.5
Given that the cie got brokerage on every order, let’s say they’ve got % on this one.
So, one the insurers bordereaux, I would have to show :
Pr – broke +tax = £150 -
└>only taken
from the premium
before tax.
£150 – (10% +£7.5) = £142.50
└> total due to the insurer.
On top of this, two things :
1) Sometimes there’s no tax
2) Sometimes they give some money back to the client. In that case, I have to update the ins bordereaux as follows :
Pr – NCB = A
└>money given
back to the client ===>it’s a % of the
premium always taken away net of tax&brk
A – brk = B
B + Tax = C
C = total due to the ins.
150 – 20% = 120 (A)
120 – 10% = 108 (B)
108 + tax = £115.5
Another thing, the insurer do not have the same proportion but the % of the ins on the database should always 100 !
Can you help ?
I really want to pass my training & I’m already running very late on this project !