Community Meeting Rooms - Insuranceaccounts

Help document for Amortization Calculator

i) New Client Form Once the extension is installed, the user will click on New Client to bring up a Form. A Form is to be completed for every transaction. The form, in its upper part, has fields for contact information to be completed. After finishing with this section of the form, the following fields are completed:
Security A drop-down is provided which when clicked on will show the Security types. The intended security is selected which now shows in the security field.
StartDate This is the date the transaction starts to run. The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the start date.
Year/PrdEnd This is the accounting year or period to which the amortization is calculated from the StartDate.The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the year/prdend date.
EndDate This is the date the transaction comes to an end.The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the end date.
Cash Book The Cash Book has the Receipts and Payments. A drop-down is provided which when clicked on will show Receipt with the minus sign and Payment with no sign. If it is a receipt (eg. Rent received in advance) the figure is entered as a negative amount in the Amount field and a payment (eg. Rent paid in advance) is entered as a positive amount, with no sign before it, in the Amount field.
Amount This is the amount for the transaction. A negative (-) figure is shown as Amount if an income and a positive figure (that is, not showing any sign at all) if an expense. It is mandatory.
Amortised This is the portion of the Amount amortised from the StartDate to the Year/Prd.End. The calculation is done by the App. on submission of the Form and shown in the Report. The Data Entry officer is NOT TO ENTER anything in this field at all.
Balance This is the balance of the Amount from the Year/Prd.End to the EndDate. The calculation is done by the App. on submission of the Form and shown in the Report. The Data Entry officer is NOT TO ENTER anything in this field at all.
email address This is the email address of the data entry officer. It is mandatory and therefore to be completed.
Other Details
Client Status The applicable status is ticked, Active or Inactive.
Type Of Business The applicable type of business of the insured is ticked.
Preferred Contact Method The insured may have indicated the deferred contact method. This is ticked, Email or Phone.
Additional Information Any additional information on the policy is stated here.
Submit or Reset After the completion of the Form, the ‘Submit’ button is clicked on. If there is the need to cancel the form, the ‘Reset’ button is clicked on. NB. Every field, except the ‘Additional Information’ field which may or may not have any entry, must be completed before the New Client form can be submitted.
ii) All Clients
The data entered in New Client Form are all transmitted to the All Clients . The fields in the Form are represented in the Statement.
The following can be done in the All Clients statement.
Sorting
Each of the fields can be sorted by entry and by group. By the side of each field is a diamond/triangle icon which when clicked on will give the following drop-down options, Search, Sort by Asc, Sort by Desc, Group by Asc, Group by Desc, and Hide Column.
A sorting can be saved or removed by moving the cursor to the top of the page next to “Sheet Report” when the two options show up and the appropriate one clicked on.
Sorting using MS Excel Further sorting can be done by exporting the All Clients Report to MS Excel. This is achieved by clicking on the three small horizontal lines (next to the + sign) at the top of the Sheet 1 Report. This gives a drop-down which has ‘Export’ as one of the options. Once Export is clicked on there is another drop-down of a set of options. One of them is ‘.csv’. When .csv is clicked on it brings up the Sheet 1 Report in the .csv MS Excel format. In order to avoid the possibility of losing some features in the .csv format, it is advisable to save in the MS Excel (*xls) format. This is done, in the .csv format, by clicking on the ‘Save As…’ button which brings up a page. A file name is indicated on the page and ‘Save’ is clickedon.
Printing The Report can be printed from the CSV and MS Excel (*xls) formats. In each case, ‘File’ is selected in the Toolbar and in the drop-down ‘Print’ is clicked on.

Auto number – Each record is assigned an automatic number which helps in tracking the records. There must be a satisfactory explanation for any missing number.

Help document for Insurance PremComm (Premium and Commission) Analysis

i) New Client Form
Once the extension is installed, the user will click on New Client to bring up a Form. A Form is to be completed for every transaction.
The first two fields to be completed are, namely:
Client ID Identification number of the Client is entered here.
Client Type Individual and Corporate clients are the two client types for which provision is made. The appropriate one is ticked for each transaction.

After completing the above fields, if the client is a company the following fields will be completed:

Company Name The name of the company (the insured) is entered here.
Company Website The web address of the company is entered here.

For the two types of client, the following contact information fields are completed:

Client The name of the contact person in the client’s office or place is entered here.
Department The department of the contact person is entered here.
Email address The email address of the contact person is entered here. If the client is a company, it could be the email address of the company.
Contact address The contact address of the individual or the company is provided in the fields.
Phone number The phone number of the individual or company insured is entered here. The phone number entered ends the provision of the contact information. Other fields are now filled, namely: Class of Business A drop-down is provided that will list, when clicked on, the two classes of business, namely General and Life. The appropriate class is selected which goes into the field.
Line of Business A drop-down is provided which when clicked on will list the lines of business. The appropriate one for the transaction is selected which goes into the field.
Policy Number The policy number of the insurance is entered here
PolInceptDate This is the date the insurance policy starts to run. The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the policy inception date.
PolExpiryDate This is the date the policy stops to run. The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the policy expiry date.
RiskReserveDate This is the accounting year end or the period end date to which the premium or commission is accrued from the policy inception date. The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the risk reserved date.
Voucher Type A drop-down is provided which when clicked on will list the different voucher types. Each voucher type is preceded by either a plus or a minus sign. The sign indicates the type of figure (positive or negative) to be entered in the PremiumOrCommission field.
Voucher Date The date on the voucher is entered in this field. The calendar icon provided is clicked on and scrolled right or left to get the required year and month and the date selected. A shortcut can be used where a calendar is selected and a date entered in the field. The date can now be amended to the required date with the cursor. It is mandatory for the data entry officer to enter the voucher date.
Income Statement 2 A drop-down is provided which when clicked on will list the types of premium and commission. The appropriate one is selected which gets entered in the field.
PremiumOrCommissionThe premium or commission amount is entered in this field. The sign for the amount is determined by the sign preceding the voucher type.
Transaction Type
A drop-down is provided which when clicked on will list the transaction types. The appropriate one is selected which gets entered in the field.
Income Statement 3 A drop-down is provided which when clicked on will list the two options of EarnedPrem and CommPaid. The applicable one is selected which gets entered in the field.
EarnedPremOrCommPaid The Extension will automatically calculate the figure for this field and enter it. The data entry officer is NOT TO ENTER ANYTHING HERE.
Statement of Affairs A drop-down is provided which when clicked on will list the two options of UPR and DAC. The applicable one is selected which gets entered in the field.
UPRorDAC The Extension will automatically calculate the figure for this field and enter it. The data entry officer is NOT TO ENTER ANYTHING HERE.
Email The data entry officer enters his or her email address here.

“Other Details”, namely:

Client Status The applicable status is ticked, Active or Inactive.
Type Of Business The applicable type of business of the insured is ticked.
Preferred Contact Method The insured may have indicated the deferred contact method. This is ticked, Email or Phone.
Additional Information Any additional information on the policy is stated here. If there is no additional information, the ‘Submit’ button is clicked on for submission to the system. If there is the need to cancel the form, the ‘Reset’ button is entered.
NB. Every field, except the ‘Additional Information’ field, must be completed before the New Client form can be submitted.
ii) All Clients The data entered in New Client Form are all transmitted to the All Clients. The fields in the Form are represented in the Report.
The following can be done in the All Clients section of the extension.
Sorting
Each of the fields can be sorted by entry and by group. By the side of each field is a diamond/triangle icon which when clicked on will give the following drop-down options, Search, Sort by Asc, Sort by Desc, Group by Asc, Group by Desc, and Hide Column.
A sorting can be saved or removed by moving the cursor to the top of the page next to “Sheet Report” when the two options show up and the appropriate one clicked on.
Sorting using MS Excel
Further sorting can be done by exporting the Sheet 1 Report to MS Excel.
This is achieved by clicking on the three small horizontal lines (next to the + sign) at the top of the Sheet 1 Report. This gives a drop-down which has ‘Export’ as one of the options. Once Export is clicked on there is another drop-down of a set of options. One of them is ‘.csv’. When .csv is clicked on it brings up the Sheet 1 Report in the .csv MS Excel format. In order to avoid the possibility of losing some features in the .csv format, it is advisable to save in the MS Excel (*xls) format. This is done, in the .csv format, by clicking on the ‘Save As…’ button which brings up a page. A file name is indicated on the page and ‘Save’ is clickedon.
Printing
The Report can be printed from the CSV and MS Excel (*xls) formats. In each case, ‘File’ is selected in the Toolbar and in the drop-down ‘Print’ is clicked on.

Auto number The All Clients statement has an Auto-Number field. All entries are numbered automatically by the Extension. This will enable management to keep track of the entries posted. There must be a satisfactory explanation for any missing number!

Help document for Insurance Claims Payment and Delay Analysis

i) New Client Form

Once the extension is installed, the user will click on New Client to bring up a Form. A Form is to be completed for every transaction.
The first two fields to be completed are, namely:
Client ID Identification number of the Client is entered here.
Client Type Individual and Corporate clients are the two client types for which provision is made. The appropriate one is ticked for each transaction.

After completing the above fields, if the client is a company the following fields will be completed:

Company Name The name of the company (the insured) is entered here.
Company Website The web address of the company is entered here.

For the two types of client, the following contact information fields are completed:

Client The name of the contact person in the client’s office or place is entered here.
Department The department of the contact person is entered here.
Email address The email address of the contact person is entered here. If the client is a company, it could be the email address of the company.
Contact address The contact address of the individual or the company is provided in the fields.
Phone number The phone number of the individual or company insured is entered here.

The phone number entered ends the provision of the contact information.

Other fields are now filled, namely: Line of Business A drop-down is provided which when clicked on will list the lines of business. The appropriate one for the transaction is selected which goes into the field.

Policy Number The policy number of the insurance is entered here.
Claim Number This field takes the number the insurer assigns to the claim.
AccDate This is the date the insurer recognizes as the date of accident. The calendar icon is clicked on and the calendar drops. This is scrolled to the appropriate calendar and the date clicked on registers in the field.
Claims Paid This is the amount paid to the claimant/insured. It is mandatory to fill this field.
Date Paid Date of payment of claim is entered in this field. The calendar icon is clicked on and the calendar drops. This is scrolled to the appropriate calendar and the date clicked on registers in the field.
Elapsedtimeinyears This is the period between the accident date and date of payment of claim. The extension calculates this automatically on submission of the New Client Form and it is shown in the All Clients report.
Date Posted The date the entry is made is entered by the data entry officer. The calendar icon is clicked on and the calendar drops. This is scrolled to the appropriate calendar and the date clicked on which now registers in the field. It is mandatory to enter this date.
Email The data entry officer enters his or her email address here.

Other Details

Client Status The applicable status is ticked, Active or Inactive.
Type Of Business The applicable type of business of the insured is ticked.
Preferred Contact Method The insured may have indicated the deferred contact method. This is ticked, Email or Phone.
Additional Information Any additional information on the policy is stated here.
Submit or Reset After the completion of the Form, the ‘Submit’ button is clicked on. If there is the need to cancel the form, the ‘Reset’ button is clicked on.
NB. Every field, except the ‘Additional Information’ field which may or may not have any entry, must be completed before the New Client form can be submitted.
ii) All Clients The data entered in New Client Form are all transmitted to the All Clients. The fields in the Form are represented in the Report.
The following can be done in the All Clients section of the extension.
Sorting Each of the fields can be sorted by entry and by group. By the side of each field is a diamond/triangle icon which when clicked on will give the following drop-down options, Search, Sort by Asc, Sort by Desc, Group by Asc, Group by Desc, and Hide Column.
A sorting can be saved or removed by moving the cursor to the top of the page next to “Sheet Report” when the two options show up and the appropriate one clicked on.
Sorting using MS Excel Further sorting can be done by exporting the Sheet 1 Report to MS Excel.
This is achieved by clicking on the three small horizontal lines (next to the + sign) at the top of the Sheet 1 Report. This gives a drop-down which has ‘Export’ as one of the options. Once Export is clicked on there is another drop-down of a set of options. One of them is ‘.csv’. When .csv is clicked on it brings up the Sheet 1 Report in the .csv MS Excel format. In order to avoid the possibility of losing some features in the .csv format, it is advisable to save in the MS Excel (*xls) format. This is done, in the .csv format, by clicking on the ‘Save As…’ button which brings up a page. A file name is indicated on the page and ‘Save’ is clicked on.
Printing The Report can be printed from the CSV and MS Excel (*xls) formats. In each case, ‘File’ is selected in the Toolbar and in the drop-down ‘Print’ is clicked on.

Help document for Insurance Claims Outstanding and Age Analysis

i) New Client Form Once the extension is installed, the user will click on New Client to bring up a Form. A Form is to be completed for every transaction.
The first two fields to be completed are, namely:
Client ID Identification number of the Client is entered here.
Client Type Individual and Corporate clients are the two client types for which provision is made. The appropriate one is ticked for each transaction.

After completing the above fields, if the client is a company the following fields will be completed:

Company Name
The name of the company (the insured) is entered here.
Company Website
The web address of the company is entered here.

For the two types of client, the following contact information fields are completed:

Client The name of the contact person in the client’s office or place is entered here.
Department The department of the contact person is entered here.
Email address The email address of the contact person is entered here. If the client is a company, it could be the email address of the company.
Contact address The contact address of the individual or the company is provided in the fields.
Phone number The phone number of the individual or company insured is entered here.

The phone number entered ends the provision of the contact information.

Other fields are now filled, namely: Line of Business

A drop-down is provided which when clicked on will list the lines of business. The appropriate one for the transaction is selected which goes into the field.
Policy Number The policy number of the insurance is entered here.
Claim Number This field takes the number the insurer assigns to the claim.
AccDate This is the date the insurer recognizes as the date of accident. The calendar icon is clicked on and the calendar drops. This is scrolled to the appropriate calendar and the date clicked on registers in the field.
Amount Claimed This is the amount claimed by the insured/claimant.
Outstanding Claims Claim outstanding as at the end of accounting year under consideration is entered in this field
ClaimsOutstandingDate This is the accounting year end date under consideration. It is mandatory for the data entry officer to enter this date. The calendar icon is clicked on and the calendar drops. This is scrolled to the appropriate calendar and the date clicked on which now registers in the field. It is mandatory to enter this date.
ClmsOutstAgeinyrs The calculation of claim outstanding age in years is calculated automatically by the Extension. This shows in the All Clients report on submission of the New Client form. The data entry officer is NOT to enter anything in this field.
Date Posted The date the entry is made is entered by the data entry officer. The calendar icon is clicked on and the calendar drops. This is scrolled to the appropriate calendar and the date clicked on which now registers in the field. It is mandatory to enter this date.
Email The data entry officer enters his or her email address here.

“Other Details”, namely:

Client Status The applicable status is ticked, Active or Inactive.
Type of Business The applicable type of business of the insured is ticked.
Preferred Contact Method The insured may have indicated the deferred contact method. This is ticked, Email or Phone.
Additional Information Any additional information on the policy is stated here.
Submit or Reset After entering the additional information and even where there is no additional information, the ‘Submit’ button is clicked on to submit. If there is the need to cancel the form, the ‘Reset’ button is entered.
NB. Every field, except the ‘Additional Information’ field, must be completed before the New Client form can be submitted.
ii) All Clients The data entered in New Client Form are all transmitted to the All Clients. The fields in the Form are represented in the Report.
The following can be done in the All Clients section of the extension.
Sorting Each of the fields can be sorted by entry and by group. By the side of each field is a diamond/triangle icon which when clicked on will give the following drop-down options, Search, Sort by Asc, Sort by Desc, Group by Asc, Group by Desc, and Hide Column.
A sorting can be saved or removed by moving the cursor to the top of the page next to “Sheet Report” when the two options show up and the appropriate one clicked on.
Sorting using MS Excel Further sorting can be done by exporting the All Clients Report to MS Excel. This is achieved by clicking on the three small horizontal lines (next to the + sign) at the top of the Sheet 1 Report. This gives a drop-down which has ‘Export’ as one of the options. Once Export is clicked on there is another drop-down of a set of options. One of them is ‘.csv’. When .csv is clicked on it brings up the Sheet 1 Report in the .csv MS Excel format. In order to avoid the possibility of losing some features in the .csv format, it is advisable to save in the MS Excel (*xls) format. This is done, in the .csv format, by clicking on the ‘Save As…’ button which brings up a page. A file name is indicated on the page and ‘Save’ is clicked on.
Printing The Report can be printed from the CSV and MS Excel (*xls) formats. In each case, ‘File’ is selected in the Toolbar and in the drop-down ‘Print’ is clicked on.