# 2.Client

#### <span style="color: rgb(53, 152, 219);">Overview </span>

<span style="color: rgb(35, 111, 161);"><span style="color: rgb(0, 0, 0);">The **Clients** section is used to manage client and counterparty-related information within the CTRM system. It supports the handling of contacts, companies, onboarding, compliance, leads, pipeline activities, and overall client relationship management.</span></span>

---

#### <span style="color: rgb(53, 152, 219);">2.1 Contacts   
</span>

<span style="color: rgb(0, 0, 0);">Used to store and manage individual people associated with counterparty organizations. </span><span style="color: rgb(0, 0, 0);">Maintains key information : ***Name, Email, Phone number***</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/6Yaimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/6Yaimage.png)

<span style="color: rgb(0, 0, 0);">**Filters** </span>

- <span style="color: rgb(0, 0, 0);">Search: Find contacts using name, email, or phone number</span>
- <span style="color: rgb(0, 0, 0);">Role: Filters contacts according to their assigned roles</span>

<span style="color: rgb(0, 0, 0);">**Main Functions** </span>

- <span style="color: rgb(0, 0, 0);">Add a new contact </span>
- <span style="color: rgb(0, 0, 0);">Import contacts using a CSV file</span>
- <span style="color: rgb(0, 0, 0);">Edit or delete existing contacts</span>
- <span style="color: rgb(0, 0, 0);">Send an email directly when a email address is available</span>

##### <span style="color: rgb(0, 0, 0);">Methods to add a contact </span>

**<span style="color: rgb(22, 145, 121);">1. Import Contacts from CSV</span>** Allows multiple contacts to be added at once by uploading a CSV file up to 5 MB.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/WYrimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/WYrimage.png)

- Required Columns: first\_name , last\_name
- Optional columns: email, phone, title, contact\_role, counterparty\_code, notes
- Additional columns that are not required are ignored by the system
- Each row is validated indivually before being imported
- Valid rows are imported, while invalid rows are skipped with the reason provided
- A row-by-row import report is displayed after the process is completed.

**Key Characterisitc** <span style="color: rgb(0, 0, 0);">Counterparty Code</span> – Identifies the counterparty organization that the contact belongs to. When contacts are imported through a CSV file, this code helps the system link each contact to the correct counterparty automatically.

<span style="color: rgb(22, 145, 121);">**2. Manual Entry of a company** </span>Allows users to manually create an individual contact record within the system.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/D4Vimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/D4Vimage.png)  
<span style="color: rgb(0, 0, 0);">**Fields:**</span>

- First name
- Last Name
- Title (Job title/position)
- Role (Business role)
- Email
- Phone
- Notes

<span style="color: rgb(0, 0, 0);">**Validations :**</span>

- First name and Last name are mandatory
- At least one contact method, either Email or Phone must be provided.

---

#### <span style="color: rgb(35, 111, 161);"><span style="color: rgb(53, 152, 219);">2.2 Companies</span>  
</span>

Used to manage the organizations that the business trades or works with. Each company is maintained as a counterparty record with its identifying details, type, country, limit, and current status.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/AIfimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/AIfimage.png)

<span style="color: rgb(22, 145, 121);">**Filters**</span>

- Search by name or code - Find a company by company by it's name or company code.
- Type - Filter according to the company type (customer, supplier, producer etc)
- Status - Inactive or active
- Contact - Finds companies associated with a particular contact

<span style="color: rgb(22, 145, 121);">**Main Functions**</span>

- Add a new company.
- Import company records through CSV.
- View company details.
- Edit an existing company.
- Deactivate an active company or reactivate an inactive company.

##### <span style="color: rgb(0, 0, 0);">Methods to add a companies   
  
</span>

**<span style="color: rgb(22, 145, 121);">1. Import companies from csv</span>**

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/jqUimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/jqUimage.png)

  
<span style="color: rgb(0, 0, 0);">Required columns **:** </span>Name , Code , CP Type (Counterparty type)  
<span style="color: rgb(0, 0, 0);">Optional columns: </span>Country, Credit Limit

<span style="color: rgb(22, 145, 121);">**<span style="color: rgb(0, 0, 0);">Validations</span>** </span>Each row in the CSV file is checked separately before import.

- Valid rows are imported successfully.
- Invalid rows are skipped.
- The system provides a reason for any rejected row.
- A row-by-row import report is shown after the import is completed.

**<span style="color: rgb(22, 145, 121);">2. Manual Entry of a company  
</span>**

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/oTUimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/oTUimage.png)

<span style="color: rgb(0, 0, 0);">**Fields to create a new company**</span>

- **Legal Name** – Official name of the company. <span style="color: rgb(132, 63, 161);">*Required.*</span>
- **Code** – Short, unique uppercase code used to identify the company.<span style="color: rgb(132, 63, 161);"> *Required.*</span>
- **Type** – Defines the counterparty type, such as customer. <span style="color: rgb(132, 63, 161);">*Required.*</span>
- **Contacts** – Links existing contacts to the company. *(contact assigned already cannot be assigned again)* <span style="color: rgb(132, 63, 161);">*Required.*</span>
- **Primary Contacts** – Identifies the main contact person from the selected contacts.
- **Country** – Country associated with the company.
- **CRM Owner -** The logged in user. <span style="color: rgb(135, 10, 181);">*Read-Only*</span>

**Key Requirement** A newly created company starts with **KYC (Know Your Cusomter) Pending** status. Before the company can be used in trades:

- KYC must be approved through the Compliance process.
- A credit limit must be assigned through the Credit process.

**Displayed details**

- **Code** – Short code assigned to the company.
- **UID** – Unique system identifier for the company.
- **Name** – Company name.
- **Type** – Classification of the company.
- **Country** – Country in which the company is associated or registered.
- **Limit** – Limit value configured for the company.
- **Status** – Indicates whether the company is currently active or inactive.

<span style="color: rgb(22, 145, 121);">**View Company** <span style="color: rgb(0, 0, 0);">The View Company page provides a complete profile of the selected company and brings together its related information in one place.</span>  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/m4Oimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/m4Oimage.png)

Provides a summary of :

- **Contacts** – Number of contacts linked to the company.
- **Trades** – Number of trades associated with the company.
- **Credit Limit** – Current credit limit assigned to the company.
- **Country** – Country associated with the company.
- **Type** – Counterparty type, such as supplier or customer.
- **Code** – Short code used to identify the company.

<span style="color: rgb(22, 145, 121);">**Edit Company details** </span>

- **Legal Name** – Updates the official company name.
- **Type** – Changes the counterparty type, such as supplier or customer.
- **Country** – Updates the country associated with the company.
- **Status** – Changes whether the company is active or inactive.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/xEtimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/xEtimage.png)

<span style="color: rgb(0, 0, 0);">*The KYC status and Credit Limit cannot be changed directly from this page. These are managed separately through the relevant KYC approval and credit functions.*</span>

<span style="color: rgb(22, 145, 121);">**Sanctions &amp; KYC Screening** </span>Used to record checks performed on the company as part of the KYC and compliance process.

- **Run API Screening** – Performs an automated screening of the company. Currently, the system uses a test/stub screening provider (To be edited)
- **Upload Vendor Report** – Allows a sanctions or **UBO (Ultimate Beneficial Owner)** screening report obtained from an external provider to be uploaded.
- Previous screening results are recorded in this section when available

---

#### <span style="color: rgb(53, 152, 219);">2.3 CAR Request</span>

Used to raise and manage **Compliance Application Required (CAR)** requests initiated by Trade Finance or Logistics. It allows users to track requests submitted for companies and monitor their progress through the compliance/KYC process.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/VHDimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/VHDimage.png)

- **Reference** – System-generated CAR request reference.
- **Company** – Company for which the compliance request is raised.
- **Trader** – Trader associated with the request.
- **Priority** – Request priority (Low, Medium, High).
- **Required By** – Target date for completion.
- **Status** – Current request status, such as **Open**, **In Progress**, or **KYC – Approved**.
- **Actions** – Allows the user to view the request and, depending on its status, edit CAR request and start CAR request.

<span style="color: rgb(22, 145, 121);">**New CAR requests** </span><span style="color: rgb(0, 0, 0);">Allows a CAR request to be raised for a company and assigned to the responsible trader. The request captures the business requirement, priority, and required completion date before being submitted for further processing.</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/NUcimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/NUcimage.png)

- <span style="color: rgb(0, 0, 0);">**Company** - Search and select the company for which the CAR request is being raised. *<span style="color: rgb(135, 10, 181);">Required</span>*</span>
- <span style="color: rgb(0, 0, 0);">**Responsible Trade** - Select the trader responsible for the request</span>
- <span style="color: rgb(0, 0, 0);">**Priority** - Urgency of the request. *<span style="color: rgb(135, 10, 181);">Required</span>*</span>
- **Priority Reason -** Required when priority is set to Medium or High. A reason must be entered why the requests . <span style="color: rgb(135, 10, 181);">*Required*</span>
- <span style="color: rgb(0, 0, 0);">**Business Reason** - Provides the business justification or reason for raising the CAR request. </span>
- <span style="color: rgb(0, 0, 0);">**Required By -** Specifies the date by which the request is required to be completed.  
      
    </span>

<span style="color: rgb(0, 0, 0);"><span style="color: rgb(22, 145, 121);">**Edit a CAR request**</span>   
Users can edit an existing CAR request while it is still open  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/hSzimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/hSzimage.png)

Fields that can be edited

- **Priority** – Low, Medium, or High.
- **Priority Reason** – Mandatory when **Medium** or **High** priority is selected.
- **Business Reason** – Business justification for the CAR request.
- **Required By** – Target date by which the compliance review is required.

<span style="color: rgb(22, 145, 121);">**Start CAR Request - New Onboarding Lead**</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/iUzimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/iUzimage.png)

**A. Company Details**

- **Company** – Selects the company.<span style="color: rgb(135, 10, 181);"> *Required.* </span>
- **Legal Name** – Company’s registered legal name.
- **Trading Name** – Company’s trading/business name.
- **Type** – Company type, such as refinery, supplier, customer, etc.
- **Country of Incorporation** – Country where the company is incorporated.
- **Registration Number** – Company registration number.
- **Business Activity** – Main business activity of the company.
- **UBO Name** – Name of the Ultimate Beneficial Owner.
- **UBO Nationality** – Nationality of the Ultimate Beneficial Owner.

**B. Contact Details**

- **Contact** – Selects the contact associated with the company. <span style="color: rgb(135, 10, 181);">*Required* </span>
- **Contact Name** – Name of the selected contact.
- **Designation** – Contact’s job title/role.
- **Email** – Contact’s email address. <span style="color: rgb(135, 10, 181);">*Required*</span>
- **Phone** – Contact’s phone number.
- **Bank Name** – Company/contact bank information.
- **Bank Country** – Country of the bank.
- **Expected Commodity** – Commodity the company is expected to trade.
- **Expected Volume** – Estimated trading volume.
- **Expected Routes** – Expected trading/shipping routes.
- **Introduced By / Notes** – Details of who introduced the company or any additional notes.

*<span style="color: rgb(0, 0, 0);">The lead information is first checked by the Compliance team. After that, the company receives a </span><span style="color: rgb(0, 0, 0);">secure link to complete the required KYC form and submit its details for review.</span>*

---

#### <span style="color: rgb(53, 152, 219);">2.4 Onboarding</span>

<span style="color: rgb(0, 0, 0);">The **Onboarding** module is used to manage potential companies before they become approved counterparties. It helps track leads through the early sales, onboarding, and KYC stages.</span>

![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/dVZimage.png)

**Filters**

- **Search** – Finds leads using the legal name, trading name, or email.
- **Status** – Filters leads according to their current onboarding status.
- **Country Risk** – Filters leads based on the risk level associated with their country.

**Leads information displayed**

- **Legal Name** – Official name of the potential company.
- **Type** – Counterparty type, *(eg: - customer, supplier, or terminal.)*
- **Country** – Country associated with the lead.
- **Risk** – Indicates the country risk result.
- **Primary Contact** – Main contact person associated with the lead.
- **Status** – Shows the current stage of the onboarding process.

**Status of onboarding leads**

- **Draft**– The company is still a potential counterparty and has not yet moved through the KYC process.
- **KYC Sent** – The KYC request has been sent and the lead is progressing through onboarding. *(documents are expected for review)*
- **KYC Submitted** *–* The requested KYC information or documents have been submitted and are ready for review.
- **Returned** – The submitted KYC information has been sent back because corrections, missing information, or additional documents are required.

**Onboarded** – The company has successfully completed the onboarding process and has been accepted as a counterparty.

- **Rejected** – The lead has been rejected during the onboarding process.

<span style="color: rgb(22, 145, 121);">General flow of a lead:</span>  
Prospect → KYC Sent → KYC Submitted → Onboarded

<span style="color: rgb(132, 63, 161);">If there is an issue with the submitted information:</span>  
KYC Submitted → Returned → Corrected/Resubmitted

<span style="color: rgb(132, 63, 161);">If the lead is not approved:</span>  
KYC Submitted → Rejected

**Country Risk**

- OK
- High Risk
- Banned
- Unknown

---

#### <span style="color: rgb(53, 152, 219);">2.5 Compliance Inbox </span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/xgZimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/xgZimage.png)

<span style="color: rgb(0, 0, 0);">Used to review KYC submissions that haved been submitted and sent for compliance checking. </span>

**<span style="color: rgb(0, 0, 0);">Filters</span>**

- <span style="color: rgb(0, 0, 0);">Search based on Lead name and email</span>
- <span style="color: rgb(0, 0, 0);">Status based on current review status (submitted, Under review) </span>

**<span style="color: rgb(0, 0, 0);">Statuses </span>**

- <span style="color: rgb(0, 0, 0);">Submitted</span>
- <span style="color: rgb(0, 0, 0);">Under review</span>

**<span style="color: rgb(0, 0, 0);">Details displayed</span>**

- <span style="color: rgb(0, 0, 0);">Submitted </span>
- <span style="color: rgb(0, 0, 0);">Company</span>
- <span style="color: rgb(0, 0, 0);">Submitted by</span>
- <span style="color: rgb(0, 0, 0);">Status</span>
- <span style="color: rgb(0, 0, 0);">Actions (Review)  
    </span>

<span style="color: rgb(22, 145, 121);">**Review KYC Pack** <span style="color: rgb(0, 0, 0);">The review page shows the KYC submission details, uploaded documents, company information, risk indicators, and the available compliance actions.</span>  
</span>

**KYC Invitation and Submission Details**

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/f3Jimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/f3Jimage.png)

- **Invitation Status** – Shows whether the KYC invitation email was sent.
- **Sent To** – Email address to which the KYC pack was sent.
- **Expiry Date** – Date and time when the KYC link expires.
- **Signed** – Shows who signed the KYC submission and when.
- **Submitted** – Date and time the KYC pack was submitted.
- **Reviewed** – Shows when and by whom the submission was reviewed.
- **Resend Email** – Allows the KYC invitation to be sent again when required.

**Document Checklist**

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/MRDimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/MRDimage.png)  
  
*The **Document Checklist** shows the documents required for the KYC review and the files uploaded by the company and allows Compliance to view, download, accept, reject, or request the re-submission of each uploaded KYC document.*

**A. Company details**

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/7bKimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/7bKimage.png)

**B. Risk Indicators**   
The reviewer evaluates each compliance risk by selecting Yes or No and provides an explanation where a risk is identified.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/MgAimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/MgAimage.png)

**B.Risk Reviews &amp; approval** Used to assess potential compliance and transaction risks.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/SPPimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/SPPimage.png)

*Where a risk indicator is identified, an explanation may be required. After all indicators have been reviewed, the trader enters their name/signature and selects Sign and submit risk review.*

**Internal submission form** [![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/8whimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/8whimage.png)  
Used to review and record internal company information such as legal entity name, country of incorporation, registration number, business activity, UBO details, bank details, expected commodity, expected volume, and expected routes.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/0Isimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/0Isimage.png)

- **Copy from counterparty form** – Copies the submitted counterparty information into the internal form.
- **Save internal form** – Saves the internal review information.

**Proposed Commodities** The **Proposed Commodities** section shows the commodities the company is expected to trade.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/42uimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/42uimage.png)

For each proposed commodity, Compliance can: **Approve** and **Reject** the commodity.  
  
**Compliance Decision** After reviewing the KYC information, documents, risk indicators, internal form, and proposed commodities, Compliance can take one of the following actions:

- **Approve &amp; Onboard -** Approves the KYC and completes the onboarding process.
- **Return for changes -** Sends the submission back so corrections can be made.
- **Request More info -** Requests additional information before a final decision is made.
- **Require EDD -** Moves the case to Enhanced Due Diligence for further review.
- **Reject -** Rejects the KYC/onboarding application.
- **Withdraw -** Stops the application from proceeding further

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-09/scaled-1680-/xLBimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-09/xLBimage.png)

---

#### <span style="color: rgb(53, 152, 219);">2.6 Workflow Board</span>

<span style="color: rgb(0, 0, 0);">The **Workflow Board** gives a visual view of where each company currently stands in the onboarding process. Companies are grouped into columns based on their current stage</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/6zVimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/6zVimage.png)

<span style="color: rgb(22, 145, 121);">**Stages** </span>

**1. Lead Captured** – The lead has been created, but the KYC invitation has not yet been sent.

**2. KYC Invitation Sent** – The KYC request has been sent and the company is expected to complete and submit it.

**3. KYC Submitted** – The company has submitted the KYC information and it is waiting for further review.

**4. Compliance Review** – The submitted KYC information is being reviewed by the Compliance team.

**Returned for More Information** – The submission has been sent back to the company because additional information or corrections are required.

---

#### <span style="color: rgb(53, 152, 219);">2.7 Leads</span>

<span style="color: rgb(0, 0, 0);">Used to manage potential trading opportunities before they become actual deals. A lead represents an opportunity linked to a company, contact, and commodity.</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/R9Rimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/R9Rimage.png)

**<span style="color: rgb(0, 0, 0);">Filters</span>**

- <span style="color: rgb(0, 0, 0);">Search a lead using the lead title</span>
- <span style="color: rgb(0, 0, 0);">Company </span>

**<span style="color: rgb(0, 0, 0);">Lead information </span>**

- <span style="color: rgb(0, 0, 0);">Title</span>
- <span style="color: rgb(0, 0, 0);">Company</span>
- <span style="color: rgb(0, 0, 0);">Contact</span>
- <span style="color: rgb(0, 0, 0);">Commodity</span>
- <span style="color: rgb(0, 0, 0);">Estimated value *(expected value of the opportunity)*</span>
- <span style="color: rgb(0, 0, 0);">Probability *(chance of the opportunity progressing)*</span>
- <span style="color: rgb(0, 0, 0);">Created</span>

<span style="color: rgb(22, 145, 121);"> **Convert Lead To Deal** </span>

When a lead becomes a qualified business opportunity, the user can select **Convert to Deal**.

- The system asks for confirmation before converting the lead.
- Once confirmed, the lead is moved to the **Pipeline** as a deal.
- The new deal starts at the **Qualified** stage.
- After conversion, the user is redirected to the Pipeline to continue managing the deal.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/6Hnimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/6Hnimage.png)

**How Leads Work**

*<span style="color: rgb(52, 73, 94);">Possible trading opportunity→Lead → Convert to Deal → Qualified → Proposal → Negotiation → Won/Lost</span>*

<span style="color: rgb(52, 73, 94);">Lead → Revert</span><span style="color: rgb(52, 73, 94);"> :</span>*<span style="color: rgb(52, 73, 94);"> Deletes the lead. The Contact and Company remain so you can try again later.</span>*

<span style="color: rgb(22, 145, 121);"> **Create a new lead** </span>The **New Lead** form is used to record a potential trading opportunity before it becomes a deal.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/ZPnimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/ZPnimage.png)

- **Title**\* – Short description of the opportunity, for example, *Q3 Copper Requirement – 500MT*. (Required)
- **Company**\* – Select the company related to the opportunity. *(Required)*
- **Contact**\* – Select the relevant contact person from the chosen company.  *(Required)*
- **Commodity**\* – Select the commodity involved in the opportunity. *(Required)*
- **Estimated Value** – Enter the expected value of the opportunity.
- **Currency** – Select the currency used for the estimated value.
- **Probability** – Enter the estimated chance of the opportunity becoming a deal.
- **Expected Close** – Optional date indicating when the opportunity is expected to be completed.

<span style="color: rgb(185, 106, 217);">*The Leads page may also display deals that were created directly in the Pipeline with the **Lead** stage. These records are already deals and therefore cannot be converted again. Only pre-deal leads can use the **Convert to Deal** function.*</span>

---

#### <span style="color: rgb(53, 152, 219);">2.8 Pipeline</span>

<span style="color: rgb(0, 0, 0);">Used to track trading opportunities after they have been converted into deals. It shows how deals progress through different sales stages until they are either **won or lost**.</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/wHuimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/wHuimage.png)

<span style="color: rgb(22, 145, 121);"> **Create a new deal** </span><span style="color: rgb(0, 0, 0);">Allows a deal to be created directly in the Pipeline without first creating it as a Lead.</span>

<span style="color: rgb(0, 0, 0);">Pipeline deals can be added by :</span>

<span style="color: rgb(0, 0, 0);">1. Lead → Convert to Deal → Pipeline</span>

<span style="color: rgb(0, 0, 0);">2. New Deal → Create directly in Pipeline.</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/IvGimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/IvGimage.png)

**Deal Details**

- <span style="color: rgb(0, 0, 0);">Title\* –</span> Name or short description of the deal. *(Required)*
- <span style="color: rgb(0, 0, 0);">Organization </span>– Company or counterparty related to the deal.
- <span style="color: rgb(0, 0, 0);">Commodity – </span>Commodity involved in the deal.
- <span style="color: rgb(0, 0, 0);">Estimated Value </span>– Expected monetary value of the deal.
- <span style="color: rgb(0, 0, 0);">Currency </span>– Currency used for the estimated value.
- <span style="color: rgb(0, 0, 0);">Probability %</span> – Estimated chance of successfully winning the deal.
- <span style="color: rgb(0, 0, 0);">Stage </span>– Current stage of the deal
- <span style="color: rgb(0, 0, 0);">Expected Close </span>– Expected date for the deal to be completed.  
      
    <span style="color: rgb(0, 0, 0);">Source Information : </span>
- <span style="color: rgb(0, 0, 0);">Source</span> – Indicates how the deal originated.
- <span style="color: rgb(0, 0, 0);">Source Company\* </span>– Company that introduced or referred the deal. *(Required)*
- <span style="color: rgb(0, 0, 0);"> Source Contact\* </span>– Contact person from the source company who introduced the deal. *(Required)*  
    <span style="color: rgb(135, 10, 181);">*The Source Company and Source Contact therefore help identify where the business opportunity came from.* </span><span style="color: rgb(135, 10, 181);"><span style="color: rgb(0, 0, 0);">  
    Next Step : </span>  
    </span>The user can also record the next planned action for the deal:
    
    
    - <span style="color: rgb(0, 0, 0);">Date –</span> When the next action should take place.
    - <span style="color: rgb(0, 0, 0);">Type – T</span>ype of follow-up/action.
    - <span style="color: rgb(0, 0, 0);">Description </span>– Additional details, such as *“Follow up on revised offer.”*

<span style="color: rgb(22, 145, 121);">**Pipeline view (Pipeline Summary)**</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/QLfimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/QLfimage.png)<span style="color: rgb(22, 145, 121);">  
</span>**<span style="color: rgb(0, 0, 0);">1.Pipeline value by currency :</span>**

- <span style="color: rgb(0, 0, 0);">EUR </span>
- <span style="color: rgb(0, 0, 0);">GBP </span>
- <span style="color: rgb(0, 0, 0);">JPY </span>
- <span style="color: rgb(0, 0, 0);"> SGD </span>
- <span style="color: rgb(0, 0, 0);">USD   
    </span>*<span style="color: rgb(0, 0, 0);">(Each currency shows its own</span>*<span style="color: rgb(0, 0, 0);"> pipeline </span>*<span style="color: rgb(0, 0, 0);">value so that amounts from different currencies are not mixed together.)</span>*

**<span style="color: rgb(0, 0, 0);">2.Pipeline Totals by Currency  
</span>**<span style="color: rgb(0, 0, 0);">For each currency, the system displays: </span>**<span style="color: rgb(0, 0, 0);">  
</span>**

- <span style="color: rgb(0, 0, 0);">Total Deals – </span>Total number of deals recorded in that currency.
- <span style="color: rgb(0, 0, 0);">Open Deals – </span>Number of deals that are still in progress.
- <span style="color: rgb(0, 0, 0);">Open Value –</span> Total value of all open deals.
- <span style="color: rgb(0, 0, 0);">Weighted Value</span> – Expected value of open deals after considering their probability of success.
- <span style="color: rgb(0, 0, 0);">Won Value – </span>Total value of deals marked as Won.
- <span style="color: rgb(0, 0, 0);">Lost Value – </span>Total value of deals marked as Lost.

<span style="color: rgb(22, 145, 121);">**Calculations**</span>

<span style="color: rgb(0, 0, 0);">1. Open value : </span>*<span style="color: rgb(0, 0, 0);"> </span>calculated by adding all values of the deals that are still open*  
<span style="color: rgb(224, 62, 45);">Open Value = Sum of all Open Deal Values</span>  
  
<span style="color: rgb(0, 0, 0);">2. Weighted Value : </span>Considers both the value and its probability of success  
<span style="color: rgb(224, 62, 45);">Weighted Value = Deal Value × Probability %  
</span>  
3\. Won Value :  
<span style="color: rgb(224, 62, 45);">Won Value = Sum of all deals marked as Won</span>

<span style="color: rgb(224, 62, 45);"><span style="color: rgb(0, 0, 0);">4. Lost Value : </span>  
Lost Value = Sum of all deals marked as Lost  
</span>

<span style="color: rgb(224, 62, 45);"><span style="color: rgb(0, 0, 0);">5.Total pipeline value by currency : <span style="color: rgb(52, 73, 94);">Each currency includes the open, won, lost deal values  
</span></span>Total Pipeline Value = Open Value + Won Value + Lost Value</span>

<span style="color: rgb(224, 62, 45);"><span style="color: rgb(0, 0, 0);">6. Total deals </span>  
Total Deals = Deals by pipeline stage + Leads  
  
</span>

**3.Pipeline Stages** The Pipeline groups deals according to their current stage:

**Lead → Qualified → Proposal → Negotiation → Won / Lost**

- **Lead** – Early stage of the deal.
- **Qualified** – The opportunity has been identified as a valid deal.
- **Proposal** – An offer or proposal is being prepared or presented.
- **Negotiation** – Deal terms are being discussed and finalized.
- **Won** – The deal has been successfully secured.
- **Lost** – The deal was unsuccessful.

*For each active stage the system displays **Deals, Values, Weighted Value***

**4. Pipeline Deal Information** For each deal, the system shows:

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/Niaimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/Niaimage.png)

- **Ref** – Unique reference number assigned to the deal.
- **Title** – Name or short description of the deal.
- **Organization** – Company associated with the deal.
- **Commodity** – Commodity involved.
- **Value** – Estimated deal value together with its currency.
- **Prob.** – Probability of successfully winning the deal.
- **Owner** – User responsible for the deal.
- **Stage** – Current stage of the deal.
- **Actions** – Allows the deal to be edited.

**Filters**

- Search by title and ref
- Stage
- Company
- Currency

---

#### <span style="color: rgb(53, 152, 219);">2.9 Activities </span>

<span style="color: rgb(0, 0, 0);">The **Activities** module is used to manage follow-up activities such as **tasks, calls, meetings, messages, emails, and reminders**. It helps users keep track of what needs to be done, when it is due, and who is responsible</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/6ZTimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/6ZTimage.png)

**<span style="color: rgb(22, 145, 121);">Activity Views</span>**

- **Open** – Shows activities that are still pending.
- **All** – Shows both open and completed activities.
- **Completed** – Shows activities that have already been completed.

**Filters**

- **Search** – Searches activities using the subject, notes, or linked record.
- **Type** – Filters activities by activity type.
- **Owner** – Filters activities according to the user responsible for them.

**<span style="color: rgb(22, 145, 121);">Activity Information</span>**

- **Type** – Type of activity, such as task, call, message, or email.
- **Subject** – Short description of the activity.
- **Linked To** – Shows the related record, such as a deal, where applicable.
- **Due** – Date and time by which the activity should be completed.
- **Logged** – Date and time the activity was created or recorded.
- **Owner** – User responsible for the activity.
- **Actions** – Allows the activity to be completed, edited, or deleted.

<span style="color: rgb(22, 145, 121);">**Overdue Activities** </span>If an open activity passes its due date without being completed, the system marks it as **Overdue.**

<span style="color: rgb(22, 145, 121);">**Create New Activity** </span>Used to record a new task, call, meeting, message, email, or other follow-up activity.

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/rQtimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/rQtimage.png)

- **Type** – Select the type of activity.
- **Logged At** – Date and time the activity was recorded. This can also be back-dated if the activity happened earlier. *Required*
- **Subject** – Short description of the activity. *Required*
- **Link to Deal** – Connects the activity to a specific deal. *Optional*
- **Link to Contact** – Connects the activity to a specific contact. *Optional*
- **Notes** – Additional details about the activity.

**Key Characteristic** Activities can be linked directly to a **Deal** or **Contact**, which makes it easier to track follow-ups related to a specific business opportunity or person.  
<span style="color: rgb(22, 145, 121);">  
</span>

**<span style="color: rgb(22, 145, 121);">Activity Notifications</span>**

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/uhwimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/uhwimage.png)

When an activity is created and linked to a contact, the system uses the **email address stored in the Contacts module** to send the relevant activity notification to that contact.

The system also provides **notifications/reminders for upcoming activities**, for users keep track of scheduled follow-ups and activities that are approaching their due date.

If an activity passes its due date without being completed, it is shown as **Overdue** in the system.

**Main Functions**

- Create a new activity.
- Mark an activity as completed. *(Which cannot be reverted back)*
- Edit an existing activity.
- Delete an activity.
- Link an activity to a related record such as a deal.

---

#### <span style="color: rgb(53, 152, 219);">2.10 CRM Dashboard</span>

<span style="color: rgb(0, 0, 0);">The **CRM Dashboard** provides an overall view of the sales pipeline, deal performance, and client-related activities in one place.  
</span>

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/YYMimage.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/YYMimage.png)

[![image.png](http://wiki.lalco.la/uploads/images/gallery/2026-08/scaled-1680-/Z71image.png)](http://wiki.lalco.la/uploads/images/gallery/2026-08/Z71image.png)

**<span style="color: rgb(0, 0, 0);">Information Displayed </span>**

- **Open Deals** – Number of deals that are still in progress.
- **Open Pipeline (USD)** – Total value of all open deals after converting them to USD.
- **Weighted Forecast (USD)** – Expected value of the open pipeline after considering the probability of each deal.
- **Win Rate** – Percentage of completed deals that were won.
- **Won Value (USD)** – Total value of deals marked as Won.
- **Lost Value (USD)** – Total value of deals marked as Lost.
- **Contacts** – Total number of contacts recorded in the CRM.
- **Overdue Activities** – Number of open activities that have passed their due date.
- **Pipeline value by stage**
- **Activities by Type -** CRM activities recorded under each activity (Email, Task, Note, Call, Message)
- Follow-ups
    
    The **Follow-ups** section gives a quick view of pending CRM actions and contact coverage.
    
    
    - **Overdue** – Number of activities that have passed their due date and are still not completed.
    - **Upcoming** – Number of activities that are scheduled for a future date.
    - **Organizations with Contacts** – Number of organizations that currently have at least one contact linked to them.

**<span style="color: rgb(22, 145, 121);">Calculations   
</span>**<span style="color: rgb(224, 62, 45);">Win Rate = Won Deals ÷ (Won Deals + Lost Deals) × 100</span>