https://direct.lc.chat/15221502/

Help documentation for Debtors Control 

JUSTIFICATION FOR INSTALLING DEBTORS CONTROL EXTENSION 

The extension can be installed by all businesses of all sizes, including the Micro, Small and Medium-sized Enterprises (MSMEs), who may desire to computerize the credit control aspect of their accounting functions (if none was in place before) or will want to replace the existing one with our robust extensions. The extension, Debtors Control, can be a stand-alone installation. Large enterprises can also acquire it as a bespoke application.

The justification for installing the Debtors Control extension is also true for its counterpart, Creditors Control extension. The debtors' control account is an account in the General Ledger that represents the total amount owed by all the individual debtors. It reflects the sales transactions with all the debtors and the total amount collected from debtors..to arrive at the total amount receivable from all debtors.' The extension gives the individual accounts of debtors and the balances due from them whose total forms the basis for the control amount. The fields in the extension with the explanations are as follows:  i) Debtor Name - Once the extension is installed, the 'Debtor Name' comes up or the user may need to click on 'Debtor Name' on the left panel for it to come up. A Form is to be completed for every transaction. The fields to be completed are, namely: 

• Debtor Name - The name of the debtor is stated here.
• Debtor Type - The appropriate type is ticked out of the three types provided.
• Address - The address fields are completed. Each of the fields can store data. A field is double-clicked to display the stored items. If the required item is in the list, it is clicked on and gets entered in the field. If the required item is not in the list, the new item is entered and it is stored along with others for subsequent or future use.
• Account Number - The Account Number of the Debtor is filled here.
• Voucher Type - A drop-down is provided listing three Voucher Types. The relevant one is clicked on for the field.
• Voucher Date - The Voucher Date is entered here.
• Voucher Number-The Voucher Number is entered here.
• Voucher Amount - The amount on the Voucher is to be entered in this field.
• Payment Received - The field must not be left empty! If no payment was received, then '0' (zero) must be entered in the field.
• Debtor Balance - NOTHING is to be entered in this field as the System will generate the value!
• Debtor’s Account Balance – NOTHING is to be entered in this field also. This is the field that shows the balance due from/(-to) ALL debtors.
• Name – This item has two fields for completion: First Name and Last Name. Help text is provided underneath the fields which reads Data Entry Officer.                                                                                     Each field can store names. In entering the First Name, you are to double-click on the field when all the stored names would be displayed. If the name is in the list, you just click on the name and it will be entered in the field. If the name is not in the list, you add it by typing the name in the field when it is also stored and would be available for use subsequently or in the future. The same procedure goes for Last Name. You double-click on the empty field of Last Name when all the stored names are displayed and one can further click on the required name, if displayed. If not displayed, the new name is entered and this will now be stored and be available for future/subsequent use.
• Add your Note here - You may add your note in this field, if you have any.
• 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. All fields asterisked in red must be completed before the Debtor Name form can be submitted.
• 
  
• ii) All Debtor Names - The data entered in Debtor Name Form are all transmitted to the All Debtor Names. The fields in the Form are represented in the Report. ii) All Debtor Names Report - The data entered in Debtor Name Form are all transmitted to the All Debtor Names Report when the Submit button is clicked on in the Form. The fields in the Form are represented in the Report.
• The following activities can be carried out in the All Debtor Names Report section of the extension, namely, Edit, Duplicate, Delete, Print, and Export.

 Any of the above activities can be  done for any of the entries or a combination of them or for all of the entries. To work on an entry, the box in front of it is ticked and all the activities earlier mentioned appear at the top of the report. The activity required is then clicked on, and the directives are followed (it is interactive). 

To work on more than one entry, the boxes against the required boxes are ticked when all the activities appear at the top of the report. The activity required is then clicked on, and the directives are followed (it is interactive). 

To work on all of the entries, the first box, in between the eye-like image and Auto Number column, is ticked which automatically ticks all of the entries. The activity required is then clicked on, and the directives are followed (it is interactive). 

TAKE - ON BALANCES                                                                                                                                       Unless a business is new and just starting operation when it might not have acquired debtors, otherwise an existing business would have had debtors on its books. On installation of this extension, and to ensure completeness of record, it would be necessary to ascertain balances outstanding against the individual debtors before introduction of the extension. It is important that the aggregate of these balances must equal the Accounts receivable figure in the last Statement of Financial Position (Balance Sheet). Such debtors' balances must be posted in the extension to the respective debtors' accounts with take-on balance or any other suitable name as the narration. A situation might arise where there is no available Statement of Financial Position after the audited one of the preceding year.                                                                                

In this case, take-on balances derived from the preceding year's audited Statement are posted into the extension. In addition, individual transactions from the beginning of the current year to the time of installation are also posted. Where available, figures of the audited interim financial statements or of the management accounts might be used. It is suggested that a Journal is raised for the take-on balances. A spreadsheet (for example, Microsoft Excel) may be used for the Journal for ease of calculation. All the debtor balances are entered in the Excel sheet and the total must be the same as the figure for Accounts Receivable or Debtors in the Statement of Financial Position or Balance Sheet. The Journal now stands as the Voucher for posting to the extension.

LINK TO THE INSTALLATION PROCESSING PAGE

Please find below the link (URL) to the installation processing page.     Once it is clicked on, the installation page opens.        

Marketplace app link

At the top of the page are two buttons namely, Start free trial and Buy Now. If the decision is to have a trial first, the Start free trial button is clicked on and the process of installation is initiated. The process for purchase is initiated by clicking on the Buy Now button.

At the button of the page is the Help documentation button. A click on this will open the documention that will guide the user on the interaction with the Extension.

Help documentation for Creditors Control 

JUSTIFICATION FOR INSTALLING CREDITORS CONTROL EXTENSION 

The extension can be installed by all businesses of all sizes, including the Micro, Small and Medium-sized Enterprises (MSMEs), who may desire to computerise the credit control aspect of their accounting functions (if none was in place before) or will want to replace the existing one with our robust extensions. The extension, Creditors Control, can be a stand-alone installation. Large enterprises can also acquire it as a bespoke application. The justification for installing the Debtors Control extension is also true for its counterpart, Creditors Control extension. 

The creditors' control account is an account in the General Ledger that represents the total amount owed to all the individual creditors. It reflects the total sales transactions with all the creditors and the total amount paid to these creditors to arrive at the total amount payable to all the creditors. The extension gives the individual accounts of creditors and the balances due to them whose total forms the basis for the control amount. 

i) Creditor Name Form 

A Form is to be completed for every transaction. The fields to be completed are, namely: 

• Creditor Type - The appropriate type is ticked out of the three types provided. 

• Creditor Name - The name of the creditor is stated here. 

• Address - The address fields are completed. Each of the fields can store data. A field is double-clicked to display the stored items. If the required item is in the list, it is clicked on and gets entered in the field. If the required item is not in the list, the new item is entered and it is stored along with others for subsequent or future use. 

• Account Number - The Account Number of the Creditor is filled here. 

• Voucher Types - A drop-down is provided listing three Voucher Types. The relevant one is clicked on for the field. 

• Voucher Date - The Voucher Date is entered here. 

• Voucher Number-The Voucher Number is entered here. 

• Voucher Amount - The amount on the Voucher is to be entered in this field. 

• Payment made - The field must not be left empty! If no payment was received, then '0' (zero) must be entered in the field. 

• Creditor Balance - NOTHING is to be entered in this field as the System will automatically calculate the value! 

• Creditor’s Account Balance – NOTHING is to be entered in this field as the System will also automatically calculate the value. This field shows the balance due to/from ALL the creditors. 

• Name – This item has two fields for completion: First Name and Last Name. Help text is provided underneath the fields which reads Data Entry Officer. Each field can store names. o In entering the First Name, you are to double-click on the field when all the stored names would be displayed. If the name is in the list, you just click on the name and it will be entered in the field. If the name is not in the list, you add it by typing the name in the field when it is also stored and would be available for use subsequently or in the future. The same procedure goes for Last Name. You double-click on the empty field of Last Name when all the stored names are displayed and one can further click on the required name, if displayed. If not displayed, the new name is entered and this will now be stored and be available for future/subsequent use. 

• Add your Note here - You may add your note in this field, if you have any. • 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. All fields asterisked in red must be completed before the Creditor Name Form can be submitted. 

ii) All Creditor Names - The data entered in Creditor Name Form are all transmitted to the All Creditor Names. The fields in the Form are represented in the Report. 

All Creditor Names Report - The data entered in Creditor Name Form are all transmitted to the All Creditor Names Report when the Submit button is clicked on in the Form.                                                                         The following activities can be carried out in the All Creditor Names Report section of the extension, namely, Edit, Duplicate, Delete, Print, and Export. Any of the above activities can be done for any of the entries or a combination of them or for all of the entries. 

To work on an entry, the box in front of it is ticked and all the activities earlier mentioned appear at the top of the report. The activity required is then clicked on, and the directives are followed (it is interactive). 

To work on more than one entry, the boxes against the required boxes are ticked when all the activities appear at the top of the report. The activity required is then clicked on, and the directives are followed (it is interactive). 

To work on all of the entries, the first box, in between the eye-like image and Auto Number column, is ticked which automatically ticks all of the entries. The activity required is then clicked on, and the directives are followed (it is interactive). 

TAKE - ON BALANCES 

Unless a business is new and just starting operation when it might not have acquired creditors, otherwise an existing business would have had creditors on its books. On installation of this extension, and to ensure completeness of record, it would be necessary to ascertain balances due to be paid to the individual creditors before introduction of the extension. It is important that the aggregate of these balances must equal the Accounts payable figure in the last Statement of Financial Position (Balance Sheet). Such creditors' balances must be posted in the extension to the respective creditors' accounts with take-on balance or any other suitable name as the narration. A situation might arise where there is no available Statement of Financial Position after the audited one of the preceding year. In this case, take-on balances derived from the preceding year's audited Statement are posted into the extension. In addition, individual transactions from the beginning of the current year to the date of installation are also posted. Where available, figures of the audited interim financial statements or of the management accounts might be used. It is suggested that a Journal is raised for the take-on balances. A spreadsheet (for example, Microsoft Excel) may be used for the Journal for ease of calculation. All the creditor balances are entered in the Excel sheet and the total must be the same as the figure for Accounts Payable or Creditors in the Statement of Financial Position or Balance Sheet. The Journal now stands as the Voucher for posting to the extension

LINK TO THE INSTALLATION PROCESSING PAGE

Please find below the link (URL) to the installation page.     Once it is clicked on, the installation page opens.   https://marketplace.zoho.com/app/customapps/creditors-control

At the top of the page are two buttons namely, Start free trial and Buy Now. If the decision is to have a trial first, the Start free trial button is clicked on and the process of installation is initiated. The process for purchase is initiated by clicking on the Buy Now button.

At the button of the page is the Help documentation button. A click on this will open the documention that will guide the user on the interaction with the Extension.

Help documentation for Cash Book

JUSTIFICATION FOR INSTALLING CASH BOOK 

The extension can be installed by all businesses of all sizes, including the Micro, Small and Medium-sized Enterprises (MSMEs), who may desire to computerise the Cash Book aspect of their accounting function (if none was in place before) or will want to replace the existing one with our robust extension. The extension, Cash Book, can be a stand-alone installation. Large enterprises can also acquire it as a bespoke application/extension.          A cash book records all the cash transactions of a business. It has two sides to it, Receipts side and Payments side. Transactions are recorded in chronological order and the balance is updated and verified on a continuous basis. Cash information can be accessed faster from the cash book. How the cash book works enables efficient management of cash and also helps cash budgeting.                                                                                        

The fields in the extension with the explanations are as follows:                                                                               i) Cash Book - Once the extension is installed, the 'Cash Book/Receipts and Payments' comes up.                        A Form is to be completed for every transaction. The fields to be completed are, namely: 

• Date - The date of entry of the transaction, receipt or payment, is entered here. This is mandatory.
• Account Name - The name of the transaction: debtor or creditor, purchase or sale of item. This is mandatory.
• Account Number - The Account Number of the debtor or creditor, item purchased or sold for cash. This is mandatory.
• Voucher Types - A drop-down is provided listing various voucher types. The relevant one is clicked on for the field. This is mandatory.
• Voucher Number-The Voucher Number is entered here. This is mandatory.
• Voucher Date – The date on the Voucher is entered here. This is mandatory
• Cash Receipt - The cash amount received stated on the Voucher is to be entered in this field. This is mandatory. If the transaction being entered is for bank receipt, 0 must be entered here while the Bank Receipt field has the amount for it.
• Bank Receipt – Amount stated in the bank credit advice is entered in this field. This is mandatory. If the transaction being entered is for cash receipt, 0 must be entered here while the Cash Receipt field has the amount for it.
• Cash Payment – Cash paid is entered here. It is mandatory. If there is no cash payment, 0 is entered.
• Bank Payment – Payment made by cheque or by a standing order to the bank is entered here. This is mandatory. If no bank payment, 0 is entered.
• Discount Allowed – Discount allowed to a debtor is entered here when the debtor makes payment. If no discount, 0 is entered as it is mandatory.                                                                                                               It is to be noted that Discount Allowed is a revenue/income statement item that pertains to a particular accounting year. So, this should be closed at the last day of the accounting year by transferring the total to the debit of discount allowed account in the expense ledger/revenue account. The individual debtors are credited with the amounts relating to them. This is effected in the extension by entering in the Discount Allowed field of the Receipts and Payments Form a negative figure of the latest amount shown in the Total Discount Allowed column of the Receipts and Payments Report.
• Total Discount Allowed - NOTHING is to be entered in this field as the System will generate the value!         This is the field that gives the updated amount of total discounts allowed when an entry is made.
• Discount Received - Discount received from a creditor is entered here when payment is made to the creditor. If no discount, 0 is entered as it is mandatory.                                                                                       It is to be noted that Discount Received is a revenue/income statement item that pertains to a particular accounting year. So, this should be closed at the last day of the accounting year by transferring the total to the credit of discount allowed account in the revenue account. The individual creditors are debited with the amounts relating to them. This is effected in the extension by entering in the Discount Received field of the Receipts and Payments Form a negative figure of the latest amount shown in the Total Discount Received column of the Receipts and Payments Report.
• Total Discount Received - NOTHING is to be entered in this field as the System will generate the value!    This is the field that gives the updated amount of total discounts received when an entry is made.
• Ledger Folio No. – The number of the ledger folio of the counterpart entry of the Cash Book entry is entered here.
• Cash in Hand - NOTHING is to be entered in this field as the System will generate the value.
• Cash at Bank - NOTHING is to be entered in this field as the System will generate the value!
• Cash Balance - NOTHING is to be entered in this field as the System will generate the value! This is the physical cash in hand at a date.
• Bank Balance – NOTHING is to be entered in this field as the System will generate the value! This is the amount in the bank at a date.
• Notes – Additional particulars of the transaction are stated along with any other information.
• Name – This item has two fields for completion: First Name and Last Name. Help text is provided underneath the fields which reads Data Entry Officer. Each field can store names. In entering the First Name, you are to double-click on the field when all the stored names would be displayed. If the name is in the list, you just click on the name and it will be entered in the field. If the name is not in the list, you add it by typing the name in the field when it is also stored and would be available for use subsequently or in the future. The same procedure goes for Last Name. You double-click on the empty field of Last Name when all the stored names are displayed and one can further click on the required name, if displayed. If not displayed, the new name is entered and this will now be stored and be available for future/subsequent use.
• 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. All fields asterisked in red must be completed before the Receipts and Payments form can be submitted.
• ii) Receipts and Payments Report - The data entered in Receipts and Payments Form are all transmitted to the Receipts and Payments Report when the Submit button is clicked on in the Form. The fields in the Form are represented in the Report.
• The following activities can be carried out in the Receipts and Payments Report section of the extension, namely, Edit, Duplicate, Delete, Print, and Export.

 Any of the above activities can be  done for any of the entries or a combination of them or for all of the entries. To work on an entry, the box in front of it is ticked and all the activities earlier mentioned appear at the top of the report. The activity required is then clicked on, and the directives are followed (it is interactive). 

To work on more than one entry, the boxes against the required boxes are ticked when all the activities appear at the top of the report. The activity required is then clicked on, and the directives are followed (it is interactive). 

To work on all of the entries, the first box, in between the eye-like image and Auto Number column, is ticked which automatically ticks all of the entries. The activity required is then clicked on, and the directives are followed (it is interactive). 

TAKE - ON BALANCES On installation of this extension, and to ensure completeness of record, it would be necessary to ascertain cash and bank balances before the introduction of the extension. It is important that the figures that appeared in the last Statement of Financial Position (Balance Sheet) would be the opening figures in the extension, provided the installation took place and became operational on the first day of the succeeding year. However, if the installation is done during the accounting year, it may be necessary to draw up a Bank Reconciliation as at the date of installation so as to determine the take-on figure for the bank. A certified Statement of Cash Balance as at the date of installation issued by a designated officer (the CEO or Company Secretary) might be needed. Furthermore, figures of the audited interim financial statements or of the management accounts might be used.

This is a generic article you can use for adding article content / subjects on your website.
You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button.This is a generic article you can use for adding article content / subjects on your website. You can edit all of this text and replace it with anything you have to say in your news/topic article.

You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website.
You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well.
Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website.

You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website. You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website.

You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button.

This is a generic article you can use for adding article content / subjects on your website.
You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button.This is a generic article you can use for adding article content / subjects on your website. You can edit all of this text and replace it with anything you have to say in your news/topic article.

You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website.
You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well.
Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website.

You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website. You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button. This is a generic article you can use for adding article content / subjects on your website.

You can edit all of this text and replace it with anything you have to say in your news/topic article. You can also change the title listed above and add new articles as well. Edit your Articles from the Pages tab by clicking the edit button.

https://direct.lc.chat/15221502/

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 All Clients 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 All Clients 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.

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.
• PremiumOrCommission - The 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 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 All Clients 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 All Clients 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 an explanation for any missing number!

Help document for Insurance Claims Payment and Delay Analysis   i) New Client - 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 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 All Clients 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 All Clients 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.

    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 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 All Clients 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.

  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 Accruals and Prepayments 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 All Clients 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 All Clients 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.

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.
• PremiumOrCommission - The 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 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 All Clients 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 All Clients 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 an explanation for any missing number!

Help document for Insurance Claims Payment and Delay Analysis   i) New Client - 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 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 All Clients 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 All Clients 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.

    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 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 All Clients 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.

  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!