Archives: Documentation

  • Contact Management Module

    Viewing Contacts

    Steps:

    1. Open Contact → Contact List
    2. View all contacts in the table
    3. Use the search bar to filter records

    Result:

    All existing contacts are displayed.

    Adding a New Contact

    Steps:

    1. Click Add Contact
    2. Contact Entry Form opens
    3. Enter required information
    4. Click Apply Changes

    Result:

    Contact is saved and visible in the list.

    Editing an Existing Contact

    Steps:

    1. Click Edit icon next to a contact
    2. Update required fields
    3. Click Apply Changes

    Result:

    Contact information is updated.

    Uploading Contacts

    Steps:

    1. Click Download Template
    2. Fill the Excel file
    3. Click Upload Contacts
    4. Select file and submit

    Common Errors:

    – Incorrect template
    – Missing mandatory fields

    Contact Entry Form

    Purpose:

    Used to create or update contact records.

    Contact Type Selection

    Steps:

    1. Select Company or Individual
    2. Set status Active or Inactive
    3. Select type from Debit, cash or bad debts

    Basic Contact Information Includes:

    – Name
    – Type
    – Phone No
    – Mobile No
    – Email
    – picture

    Address & Details Includes:

    – Street
    – Country
    – City
    – Zip Code
    – Language
    – Website

    Sales Information

    Used when contact is a customer.
    Includes

    Sales Person,

    Payment Terms (COD, 15 days, 30 days, 60 days), Price List.

    Purchase Information

    Used when contact is a vendor.
    Includes Payment Terms (Advance, 15 days, 30 days, 60 days)

    Fiscal Information.

    Note: A contact could be both Vendor and customer at the same time

    Invoicing Information

    Includes Bank Name,

    Account Number,

    AR COA  (Account Receivable Chart of Account), AP COA  (Account Payable Chart of Account).

    Saving or Deleting a Contact

    Actions:

    – Apply Changes
    – Cancel
    – Delete (irreversible)

    Common Errors & Troubleshooting

    Save not working: Missing mandatory fields
    Contact not visible: Status inactive
    Upload failed: Wrong template

    Based on the Contact Entry Form screenshot, here is the documentation for the registration module. This form is designed with a multi-role architecture, allowing a single profile to function as a Customer, Vendor, and/or Agent simultaneously.

    Header & Profile Identification

    This section establishes the basic identity and status of the entity.

    • Entity Type: Toggle between Company or Individual to define the legal nature of the contact.
    • Status: Mark the contact as Active or Inactive to control their visibility in transaction modules.
    • Type: A classification dropdown to further categorize the contact.
    • Profile Image: A “Choose File” area to upload a logo or identification photo.

    Multi-Role Configuration (The Catch)

    The form uses specific checkboxes to enable or disable different business roles for the same contact. You can select one, two, or all three depending on your relationship with them.

    A. Sales Role (Customer)

    Enable this by checking the Customer box.

    • Sales Person: Assign an internal staff member to the account.
    • Agents / Agent Contact: Link external intermediaries or specific representatives to this customer.
    • Payment Terms & Price List: Define the credit duration and the specific pricing tier applied to this customer.
    • Internal Reference: Capture internal tracking codes or legacy IDs.

    B. Purchase Role (Vendor / Agent)

    Enable these by checking the Vendor or Agent boxes.

    • Vendor Checkbox: Activating this makes the contact available in the Purchase Order module.
    • Agent Checkbox: Identifies the entity as a third-party service provider or broker.
    • Payment Terms: Set the agreed-upon payment schedule for when you are buying from them.
    • Fiscal Information: Enter tax-related details or financial data specific to procurement.

    Address & Communication Details

    This section centralizes all contact and logistics information.

    • Primary Address: Fields for Street, City, Country, Zip Code, and Route.
    • Digital Reach: Includes Email, Website, and a dedicated Whatsapp field.
    • Legal IDs: Fields for VAT/TRN and License#/EID for compliance checks.
    • Professional Context: Define the contact’s Position, Title, and the Channel (source) through which they were registered.

    System Controls

    • Bar Code: Assign a unique barcode to the contact for physical scanning or inventory tracking.
    • Log Details: A collapsible audit trail that records every change made to the profile.
    • Save and Next: Commits the current data and refreshes the form for a new entry.

    End-User Documentation

    Interactive Grid & Action Buttons in Oracle APEX

    Introduction

    This document explains how to use the Interactive Grid (IG) and its Action Buttons in Oracle APEX applications.

    The Interactive Grid allows users to:

    • View data in tabular form
    • Add, edit, and delete records
    • Filter, sort, and search data
    • Download reports
    • Perform row-level actions

    This guide is written for end users (non-technical users).


    What is an Interactive Grid?

    An Interactive Grid is a dynamic table that displays data from the system. It allows you to interact with records directly on the screen without navigating to another page.

    You can:

    • Edit cells directly
    • Add new rows
    • Delete rows
    • Save changes
    • Apply filters
    • Download data

    Main Components of Interactive Grid

    Toolbar

    Located at the top of the grid. Contains buttons such as:

    • Add Row
    • Delete
    • Save
    • Actions
    • Search
    • Custom Action Buttons (if configured)

    Grid Area

    The main table where data appears in rows and columns.


    Row Selector

    Checkbox column on the left side to select one or multiple rows.


    How to Use Interactive Grid


    Viewing Records

    When the page loads:

    • All available records appear in tabular format.
    • Scroll vertically to view more records.
    • Use pagination if available.

    Adding a New Record

    1. Click Add Row button.
    2. A new empty row appears.
    3. Enter data in required fields.
    4. Click Save.

    If required fields are missing, the system will show a validation message.


    Editing a Record

    1. Click inside a cell.
    2. Modify the value.
    3. Press Tab or click outside the cell.
    4. Click Save to commit changes.

    Changes are not stored until you click Save.


    Deleting a Record

    1. Select the row using the checkbox.
    2. Click Delete button.
    3. Click Save to confirm deletion.

    Using the “Actions” Menu

    Click the Actions button to access advanced features.

    Available options may include:

    Filter

    • Click Actions → Filter
    • Choose column
    • Enter condition
    • Click Apply

    Example:

    • Status = Approved
    • Date > 01-JAN-2026

    Sort

    • Click Actions → Sort
    • Select column
    • Choose Ascending or Descending

    Columns

    • Show or hide specific columns
    • Reorder columns

    Download

    Export data in formats such as:

    • CSV
    • Excel
    • PDF (if enabled)

    Control Break

    Group data based on a column.

    Example:

    • Group by Department
    • Group by Customer

    Using Search

    Use the Search bar at the top right:

    • Type any keyword
    • Press Enter
    • Grid will show matching records

    Custom Action Buttons (If Available)

    Some applications include additional buttons such as:

    • Approve
    • Reject
    • Submit
    • Process
    • Send Email
    • Generate Invoice

    How to Use:

    1. Select a row (if required).
    2. Click the action button.
    3. Confirm if prompted.
    4. System will process the action.

    Some actions may require selecting exactly one row.


    Row-Level Action Buttons

    Some grids include an Action column containing buttons per row.

    Examples:

    • Edit
    • View
    • Delete
    • Print
    • Approve

    Click the button in the respective row to perform the action on that specific record.


    Saving Your Work

    Always remember:

    • Changes are temporary until you click Save
    • If you leave the page without saving, changes may be lost
    • The system may warn you before leaving

    Common Error Messages

    MessageMeaningAction
    Field is requiredRequired field is emptyEnter value
    Invalid numberIncorrect numeric formatEnter correct number
    Record already existsDuplicate entryUse unique value
    No row selectedYou must select a rowSelect checkbox

    Best Practices

    ✔ Always click Save after changes
    ✔ Use filters instead of scrolling large data
    ✔ Verify selected row before clicking Delete
    ✔ Download report before performing mass updates

    Frequently Asked Questions (FAQ)

    They are read-only fields.

    You may not have permission or the record is locked.

    Keyboard Shortcuts (If Enabled)

    • Tab → Move to next field
    • Shift + Tab → Previous field
    • Ctrl + S → Save (if configured)

    Support

    If you experience issues:

    • Contact System Administrator
    • Provide screenshot
    • Mention Page Name and Record ID

    Conclusion

    The Interactive Grid in Oracle APEX provides a powerful and user-friendly way to manage data directly from the browser.

    By understanding:

    • Toolbar functions
    • Action menu
    • Save process
    • Row selection

    Users can efficiently manage their daily operations.

  • Fleet Management

    The Fleet Management module is designed to streamline the oversight of company vehicles. It ensures that all manufacturer data, legal documentation, and maintenance activities are centralized for maximum operational efficiency and compliance.


    Manufacturer

    • Purpose: Maintains a master database of vehicle manufacturers.
    • Function: Stores specific manufacturer details essential for the classification of the fleet.
    • Impact: Serves as a primary reference point for categorizing vehicles across all fleet management reports.

    Service Type

    • Purpose: Standardizes the various categories of maintenance and repair work.
    • Function: Defines specific types of vehicle services allowed within the system.
    • Impact: Helps organize maintenance schedules and provides a structured way to review historical service records.

    Vehicle Registration

    • Purpose: Acts as the official registry for the company’s fleet.
    • Function: Stores critical registration and ownership information for every vehicle.
    • Impact: Ensures that all fleet vehicles are properly documented, legally compliant, and easily identifiable within the system.

    Services

    • Purpose: Tracks the active maintenance lifecycle of each vehicle.
    • Function: Records and monitors the detailed service history for individual fleet units.
    • Impact: Provides the data necessary to schedule, monitor, and manage ongoing fleet maintenance, reducing downtime and extending vehicle life.
  • User Manual: Ticketing Module

    The Ticketing Module is your primary tool for issue tracking, technical support, and internal request management. It ensures that every problem is documented, categorized, and resolved through a structured workflow.


    Core Interface: Ticket Entry Form

    The Ticket Entry Form is the central point for initiating a new request. It is divided into two main sections: General Information and Document Work Flow.


    General Information Section

    This section captures the essential data required to identify and prioritize the issue.

    • Ticket Title: Provide a concise and descriptive name for the issue to help support staff identify the problem at a glance.
    • TRN Date time: This field automatically timestamps the request (e.g., 23-FEB-2026) to ensure chronological tracking.
    • Category: Use this dropdown to classify the ticket (e.g., Bug, Feature Request, Hardware Issue) for proper routing.
    • Severity: Define the urgency of the ticket (e.g., Low, Medium, High, Critical) to manage service level expectations.
    • Modules: Link the ticket to a specific area of the CRM (like Training or Purchase) to help technical teams narrow down the source of the error.
    • Form/Report Name: Specify the exact screen or document where the issue occurred for faster troubleshooting.
    • Department: Select the department initiating the request (e.g., TD-01) to assist with internal reporting and resource allocation.
    • Upload File: Use the “Choose File” button to attach screenshots, error logs, or relevant documents that provide visual evidence of the problem.
    • Notes: A large text area for providing a detailed description of the issue, including steps to reproduce the error or specific requirements for a request.

    Document Work Flow Section

    Located on the right side of the form, this area tracks the lifecycle of the ticket.

    • Status: Displays the current stage of the ticket (e.g., “Created”).
    • Initiated By: Automatically logs the user who created the ticket, ensuring accountability and providing a point of contact for follow-up questions.

    System Actions

    • Save: Located at the top right, this button submits the ticket into the system and triggers the assigned workflow.
    • Cancel: Use this to discard the current entry and return to the Ticket List without saving.
  • Asset and Inventory Management

    This module serves as the core framework for defining how physical goods and company resources are categorized, measured, and tracked within the CRM.


    Unit of Measurement Category

    • Purpose: Defines the standardized magnitudes used to quantify items.
    • Function: Establishes fixed standards (such as weight, length, or volume) for measuring quantities of the same kind.
    • Impact: Ensures all inventory data remains consistent across different modules and reports.

    Category

    • Purpose: Creates a logical organizational structure for all products.
    • Function: Allows for the creation of a hierarchy based on industry or firm-specific standards.
    • Impact: Simplifies the management of large inventories by grouping related items together.

    Product

    • Purpose: Acts as the primary management interface for individual inventory items.
    • Function: Provides tools to manage all specific products and link them to their appropriate categories.
    • Impact: Centralizes product data for accurate tracking and stock management.

    Asset

    • Purpose: Provides oversight for all high-value company-owned resources.
    • Function: Tracks the location and status of company assets in a single, centralized location.
    • Impact: Ensures accurate records and better administrative control over physical property.

    Assessment Profile

    • Purpose: Standardizes the evaluation of personnel within the system.
    • Function: Enables the creation of structured profiles to maintain fair and consistent employee evaluations.
    • Impact: Provides a reliable framework for measuring performance and operator readiness.

    Product Portfolio

    • Purpose: Serves as the high-level dashboard for the entire product range.
    • Function: Consolidates all product information into a single view for easy management and updates.
    • Impact: Keeps the entire catalog organized and ensures information remains current at a glance.
  • User Manual: System Settings (Core Configuration)

    The Settings Module is the foundational core of the CRM. It governs system-wide behaviors, security protocols, financial rules, and data standards. Proper configuration here ensures consistency across all other modules like Training and Purchase.


    Country

    • Purpose: Maintains the master geographic database for the entire CRM.
    • Key Functions: Stores country names, codes, and regional data.
    • Impact: This data is used for system-wide geographic configurations, such as setting up tax regions or shipping zones.

    Users Information

    • Purpose: Serves as the primary directory for all personnel with system access.
    • Key Functions: Stores complete user profiles, including contact details and identification.
    • Impact: It is the central hub for managing logins and maintaining updated user records.

    Module & Forms Registration

    • Purpose: Acts as the registry for every functional component of the ERP.
    • Key Functions: Registers all system modules and individual forms.
    • Impact: Controls the visibility and availability of specific features across the platform.

    Roles

    • Purpose: Establishes the organizational structure within the system.
    • Key Functions: Defines specific job roles and their corresponding responsibilities.
    • Impact: Used to structure permission groups so that access is granted based on job function.

    Users Role Rights

    • Purpose: The granular security gatekeeper for the CRM.
    • Key Functions: Assigns specific “rights” (view, edit, delete, or create) to each defined role.
    • Impact: Controls exactly what actions a user can perform once they are logged in.

    Document Work Flow

    • Purpose: Automates and monitors the path of internal documents.
    • Key Functions: Manages the sequential approval flow for documents.
    • Impact: Ensures that every process is controlled, authorized, and fully trackable for audit purposes.

    Price

    • Purpose: The foundational database for product and service costs.
    • Key Functions: Stores the base prices for all items in the system.
    • Impact: Acts as the “source of truth” for all pricing calculations in sales and purchases.

    Customer Price

    • Purpose: Manages specialized pricing for specific clients.
    • Key Functions: Handles negotiated rates and customer-specific price lists.
    • Impact: Allows the system to automatically apply the correct, non-standard rate during a transaction.

    Terms And Conditions

    • Purpose: Maintains the legal and procedural framework for transactions.
    • Key Functions: Stores and manages T&C templates.
    • Impact: These are applied automatically during transactions to ensure consistent legal compliance.

    Discount

    • Purpose: Regulates standard price reductions.
    • Key Functions: Handles predefined discount rules and percentage values.
    • Impact: Automatically applies valid discounts to transactions based on set criteria.

    Risk Assessment

    • Purpose: Evaluates the safety and viability of business actions.
    • Key Functions: Stores and analyzes various risk factors.
    • Impact: Used for approval triggers and ensuring compliance with company risk policies.

    Sum Discount

    • Purpose: Handles manual, high-level price adjustments.
    • Key Functions: Manages one-time bulk discount entries.
    • Impact: Specifically applied to selected orders or customers when standard discount rules don’t apply.

    List Of Values

    • Purpose: Standardizes data entry across all modules.
    • Key Functions: Maintains the values used in all system-wide dropdown menus.
    • Impact: Ensures data consistency, which is critical for accurate reporting and searching.

    Date Validation Rules

    • Purpose: Ensures chronological accuracy within the system.
    • Key Functions: Sets logic for date-related entries.
    • Impact: Prevents users from entering impossible dates (e.g., a delivery date before an order date).

    Voucher No. Rules

    • Purpose: Standardizes financial record keeping.
    • Key Functions: Defines specific rules for how vouchers are numbered.
    • Impact: Controls the sequence and pattern generation for all financial vouchers.

    Grade

    • Purpose: Provides a classification system for evaluations.
    • Key Functions: Defines different grading levels or categories.
    • Impact: Used across the system for ranking, evaluation, or performance classification.

    Feedback Criteria

    • Purpose: Sets the standard for measuring quality.
    • Key Functions: Maintains parameters used to record and evaluate performance.
    • Impact: Allows for measurable and standardized feedback on users or internal processes.

    Asset and Inventory Management

    • Purpose: Bridges the gap between procurement and resource tracking.
    • Key Functions: Manages the planning and procuring of materials.
    • Impact: Covers the entire lifecycle of assets, from supplier selection to purchasing.

    Report Formatting List

    • Purpose: Standardizes the look and feel of all system outputs.
    • Key Functions: Defines layout, display styles, and presentation rules for reports.
    • Impact: Ensures that all generated documents (invoices, summaries) are professional and consistent.

    Document Sequence

    • Purpose: Ensures every transaction has a unique identity.
    • Key Functions: Sets automatic numbering for documents like invoices and orders.
    • Impact: Guarantees that each document is unique and easily trackable within the database.
  • User Manual: Purchase Management Module

    The Purchase Module is designed to streamline the procurement lifecycle, from the initial creation of orders to the ongoing assessment of vendor partnerships.


    Core Operations

    Purchase Order

    The Purchase Order sub-module is the central engine for procurement transactions.

    • Function: This tool is used to create and manage formal purchase orders directed to suppliers.
    • Capabilities: Users can track the entire lifecycle of an order, including its current status, delivery timelines, and internal approval workflows.
    • Benefit: Ensures that all outgoing spend is documented, authorized, and monitored until the goods or services are received.

    Strategic Management

    Supplier Evaluation

    The Supplier Evaluation sub-module focuses on vendor relationship management and quality control.

    • Function: This tool assesses the performance and reliability of various suppliers.
    • Capabilities: It provides data-driven insights to help the organization maintain high-quality standards and optimize future procurement decisions.
    • Benefit: Empowers the purchasing team to identify high-performing vendors and mitigate risks associated with unreliable suppliers.

    Navigation & Quick Access

    The Purchase interface features a streamlined sidebar for rapid movement between tasks:

    • Home: Return to the primary Purchase dashboard for a high-level overview.
    • Purchase Order: Direct shortcut to the order management suite.
    • Supplier Evaluation: Direct shortcut to performance assessment tools.
  • User Manual: Training Management System

    This manual provides a detailed breakdown of the Training Module components. Each sub-module is designed to handle a specific stage of the educational and certification lifecycle.


    Administrative & Planning Sub-Modules

    Calendar

    The Calendar serves as the central scheduling interface for all training activities.

    • Function: Displays all upcoming scheduled training sessions and critical deadlines in a chronological view.
    • User Benefit: Assists administrators in planning and managing course timelines to prevent scheduling conflicts.

    Course Portfolio

    The Course Portfolio acts as the definitive catalog for all educational programs.

    • Function: Maintains an organized list of every training course available within the system.
    • User Benefit: Provides essential course details required for strategic planning and student enrollment.

    Instructor

    The Instructor sub-module manages the human resources side of the training department.

    • Function: Houses comprehensive instructor profiles, including their specific professional qualifications.
    • User Benefit: Enables the precise assignment of qualified trainers to relevant courses and batches.

    Operations & Execution Sub-Modules

    Student

    The Student sub-module is the primary repository for participant data.

    • Function: Stores individual student profiles, enrollment status, and participation history.
    • User Benefit: Allows for the granular tracking of progress and performance for every learner.

    Batches

    The Batches sub-module facilitates group-based management.

    • Function: Organizes students into specific cohorts or groups for training sessions.
    • User Benefit: Simplifies the tracking of group-wide progress, attendance, and graduation timelines.

    Attendance Sheet

    The Attendance Sheet provides the formal verification of student participation.

    • Function: Records the daily presence or absence of students for each individual session.
    • User Benefit: Ensures high-fidelity reporting for compliance and participation requirements.

    Evaluation & Certification Sub-Modules

    Operator Assessment

    The Operator Assessment sub-module is the tool for skill verification.

    • Function: Evaluates the technical skills and overall performance of students or operators.
    • User Benefit: Generates the necessary data to determine if a student is eligible for certification or requires further training.

    Certificate

    The Certificate sub-module manages the final output of the training process.

    • Function: Automates the generation of official training completion certificates or identification cards.
    • User Benefit: Maintains a secure, searchable record of all issued credentials for verification and compliance audits.

    High-Efficiency (Bulk) Sub-Modules

    Bulk Rejection

    Bulk Rejection is a specialized tool for handling negative assessment outcomes at scale.

    • Function: Processes multiple failed assessments simultaneously within the system.
    • User Benefit: Dramatically reduces the administrative time required for record updates and initiating corrective actions.

    Bulk Printing

    Bulk Printing is a utility for high-volume document production.

    • Function: Enables the mass printing of certificates, cards, or training reports.
    • User Benefit: Ensures document consistency and saves significant time during graduation or reporting cycles.
  • CRM Module: User Manual

    Introduction to the CRM Home Dashboard

    The Home Dashboard serves as your central hub for managing the sales pipeline. It provides quick access to lead tracking, deal progress, and status updates.

    Navigation Menu

    The sidebar on the left allows you to switch between different modules at any time:

    • Home: Returns you to the main dashboard.
    • Lead List: Access the full database of potential clients.
    • Opportunity List: Track active deals and their progression.
    • Lead Status: View visual summaries of where leads sit in the sales cycle.

    Detailed Module Breakdown

    Lead List Card

    This is your primary database for all initial contacts. Use this module to manage the “top of the funnel” before a lead becomes a serious sales opportunity.

    • Purpose: To provide a centralized repository for every lead assigned to you or your team.
    • Key Actions:
      • Filter & Search: Quickly locate specific leads by name, region, or source.
      • Track Interaction: Log notes from calls or emails to ensure consistent follow-up.
      • Status Updates: Move a lead from “New” to “Contacted” or “Qualified.”

    Opportunity List Card

    Once a lead shows genuine interest in CIBMARS Certification services, they move here. This card focuses on the financial and closing side of the relationship.

    • Purpose: To monitor active deals that have a high probability of closing.
    • Key Actions:
      • Monitor Deal Progress: Track which stage of the sales cycle a deal is in (e.g., Proposal Sent, Negotiation).
      • Revenue Forecasting: View the potential value of deals currently in your pipeline.
      • Milestone Tracking: Stay updated on critical deadlines to ensure no deal falls through the cracks.

    Lead Status Card

    This is your analytical bird’s-eye view. Instead of looking at individual names, you are looking at the “health” of your entire sales process.

    • Purpose: To provide a visual summary of the distribution of leads across various stages.
    • Key Actions:
      • Identify Bottlenecks: See if too many leads are stuck in one particular stage (e.g., “Awaiting Documentation”).
      • Action Prioritization: Quickly identify which leads have been stagnant and require immediate outreach.

    Workflow Clarity: Get a clear picture of what needs to happen next to keep the pipeline moving.

  • HRMS Module: User Manual

    Administration Module

    The Administration module is used to set up the organizational structure, payroll rules, and leave policies. It is divided into three critical setup areas:

    Payroll Setup: Allowances Management

    The Allowances sub-module allows HR administrators to define, categorize, and manage all non-base salary financial benefits provided to employees.

    Allowances List (Master View)

    When you click on Allowances from the Payroll Setup menu, the Allowances List appears. This screen acts as a central registry for all active and inactive benefit types.

    • Edit Function: Click the Edit icon next to any allowance to modify its existing configuration.
    • Search & Filter: Use the search bar to quickly find specific allowances by name.
    • Allowance Summary Table:
      • Allowance Name: The full descriptive title (e.g., Basic Salary, Site Allowance, Medical Allowance).
      • Short Name: The system-wide code or abbreviation (e.g., BS, SA, MA).
      • Taxable %: Indicates what portion of the allowance is subject to income tax.
      • Enable/Status: Shows whether the allowance is currently active in the payroll engine.
      • Payment Method: Shows how the amount is disbursed (e.g., Bank).

    Allowance Entry Form

    Clicking the “Add Allowance” button opens a pop-up form. This is where you configure the specific logic and accounting rules for a new benefit.

    Basic Identification

    • Allowance Name: Enter the full name of the benefit.
    • Short Name: Assign a unique code for reporting and payslip display.
    • Allowance Type: Use the dropdown to classify the benefit (e.g., Recurring, One-time).

    Accounting & Tax Configuration

    • Type: Categorizes the nature of the payment.
    • Tax Percentage: Enter the specific percentage of this allowance that should be calculated as taxable income.
    • Account Title (DR/CR): Maps the allowance to the correct General Ledger (GL) accounts for automated financial posting.

    System Flags (Yes/No Toggles)

    These toggles determine how the payroll engine processes the amount:

    • Payroll Flag: Set to Yes to include this allowance in the automated monthly payroll run.
    • Include in Gross Salary: Determines if this amount is part of the “Gross” total before deductions.
    • Fix Flag: Indicates if the amount is a fixed standard or a variable value.
    • Status: Controls if this allowance is currently available for use in employee contracts.
    • Gratuity / Leave Encashment Flag: Sets whether this allowance should be considered when calculating end-of-service gratuity or leave buy-back amounts.

    Standard Pre-Configured Allowances

    The system comes with several standard categories ready for use:

    • Basic Salary (BS): The core fixed component of pay.
    • Accommodation (AC): Housing benefits provided to the employee.
    • Medical Allowance (MA): Health-related stipends.
    • Travelling/Conveyance (TA/CA): Transport-related reimbursements or fixed monthly allowances.
    • Bonus: Periodic performance or festival-based payments.

    Payroll Setup: Deductions Management

    Following the configuration of Allowances, the Deductions sub-module allows HR and Finance administrators to manage all subtractions from an employee’s gross pay, ranging from statutory taxes to internal company recoveries.


    Deductions List (Master View)

    Accessing Deductions from the Payroll Setup menu opens the Deductions List. This view serves as the central database for all subtraction types.

    • Key Columns in the Table:
      • Deduction Name: The full name of the deduction (e.g., Income Tax, Loan, Asset Damages).
      • Short Name: The system code used for payslips and quick reference (e.g., IC, LC, AWL).
      • Taxable %: Specifies if the deduction itself impacts the taxable income calculation (e.g., Income Tax is typically 100%).
      • Enable?: Indicates if the deduction is currently active within the payroll engine.
      • Fix Flag: Shows if the deduction is a fixed amount versus a variable one.
      • Include In Gross Flag: Determines if this deduction is subtracted from the Gross salary calculation.

    Deduction Entry Form

    Clicking the “Add Deduction” button opens the configuration interface. This form ensures that every subtraction follows specific accounting and organizational rules.

    Core Configuration

    • Deduction Name: The official title of the subtraction.
    • Short Name: A unique abbreviation for reporting.
    • Deduction Type: A dropdown to select the nature of the deduction (e.g., FIXED).
    • Tax Percentage: The rate at which this deduction applies to the taxable portion of the salary.

    Financial & System Rules

    • Account Title: Link the deduction to a specific Chart of Accounts (COA) for automated bookkeeping.
    • Bank/Cash Toggle: Select whether the recovered amount is categorized as a Bank or Cash transaction.
    • Fix Flag (Yes/No): Toggle to “Yes” if the amount remains constant every month.
    • Include in Gross Salary (Yes/No): Toggle to “Yes” if this deduction should be factored into the Gross salary calculation logic.
    • Enable? (Yes/No): Toggle to “Yes” to activate this deduction for use in current payroll cycles.

    Advanced Mapping

    The bottom of the form includes two critical mapping tables:

    • Deduction COA: Allows for granular mapping to specific accounts in your financial system.
    • Department: Assigns the deduction to specific departments, ensuring that specialized penalties or recoveries only apply to relevant teams.

    Standard System Deductions

    Commonly pre-configured deductions include:

    • Income Tax (IC): Mandatory government tax based on salary slabs.
    • Late Coming (LC): Automated deductions based on attendance logs.
    • Absent Without Leave (AWL): Salary subtractions for unapproved leave.
    • Assets Damages (AD): Recoveries for damaged or lost company property (e.g., from the Fleet or Asset modules).
    • Loan: Monthly installments for employee salary advances or company loans.

    Payroll Setup: Tax Setup Management

    The Tax Setup sub-module is essential for ensuring organizational compliance with national or regional fiscal regulations. It allows administrators to define tax years and establish the progressive slabs required for accurate income tax calculations.


    Tax Setup List (Master View)

    Selecting Tax Setup from the Payroll Setup menu displays the Tax Setup List. This screen provides an overview of defined fiscal periods and their current status.

    • Tax Year From / To: Displays the start and end dates of the defined fiscal year (e.g., 01-JUL-2025 to 30-JUN-2026).
    • Enable?: Indicates if the tax rules for that specific year are currently being applied by the payroll engine.
    • Management Actions: Users can click the Edit icon to update existing tax slabs or the Add Tax Setup button to configure a new fiscal year.

    Tax Setup Entry Form

    The entry form is divided into two sections: Master (for the time period) and Detail (for the financial slabs).

    Master Configuration

    • Tax Year From & To: Select the calendar dates for the fiscal cycle using the date picker.
    • Tax Deduction: Use the dropdown to link this setup to a specific deduction category (e.g., Income Tax).
    • Enable Toggle: Set to Yes to make these rules active for live payroll processing.

    Detail (Slab Configuration)

    The Detail table is where the actual “math” of the tax engine is defined. You can add multiple rows to create progressive tax brackets.

    • Min & Max Salary Amount: Define the salary range for a specific tax bracket (e.g., $0 to $50,000).
    • Fix Tax Amount: Set a constant tax value to be applied specifically to this bracket.
    • Tax Percentage: Assign a percentage rate for any income falling within this range.
    • Rebate Percentage: If applicable, define the percentage of tax relief or discount allowed for this specific bracket.

    System Impact

    Once saved, the Tax Setup automatically interacts with the Deductions module. When a payroll run is initiated, the system:

    • Calculates the employee’s total taxable income.
    • References the active Tax Setup for the current date.
    • Applies the corresponding percentage and fixed amounts based on the defined slabs.
    • Generates the final tax deduction seen on the payslip.

    Payroll Setup: Payroll Configuration

    The Payroll Configuration sub-module is the primary “rules engine” for the HRMS. It allows you to define complex calculation logic for statutory benefits (Provident Fund, EOBI, ESSI), Overtime, and Tax, specifically tailored to different Employee Types (e.g., Permanent, Contractual).


    Payroll Configuration List (Master View)

    Accessing Payroll Configuration opens a summary list of all active rule sets.

    • Edit Function: Click the Edit icon to update existing rules for a specific employee category.
    • Key Columns: The table provides a high-level overview of active settings including:
      • EOBI & Social Security: Status and company/employee contribution values.
      • Overtime: Factors, minimum/maximum hour thresholds, and calculation cycles.
      • Employee Type: Shows which group (e.g., Permanent) the rule set applies to.

    Payroll Configuration Entry Form

    This comprehensive form is where the detailed math for payroll generation is established. It is categorized into several critical functional blocks:

    Statutory Benefit Blocks (PF, EOBI, ESSI)

    These sections manage mandatory government and company-sponsored benefits. Each follows a similar setup pattern:

    • Y/N Toggles: Enable or disable the benefit (e.g., Provident Fund Y/N).
    • Calculation Type & Values: Define whether the contribution is a percentage or fixed amount, and the specific value for both the Employee and the Company.
    • Expense COA4: Link the company’s contribution to the correct Level 4 Chart of Accounts for automated financial reporting.
    • Deduction/Allowance Mapping: Map these to the specific codes created in the Allowances and Deductions sub-modules.

    Overtime (OT) Logic

    • Overtime Factor: The multiplier used for OT hours (e.g., 1.5x or 2.0x).
    • Calculation On: Define the base for OT (e.g., Basic Salary or Gross).
    • Min/Max Hours: Set the thresholds for valid overtime claims.
    • Calculation Cycle: Set the frequency of OT processing.

    Advanced Payroll Flags

    Located at the bottom of the form, these toggles control high-level system behavior:

    • Income Tax Y/N: Enable automated tax processing based on the Tax Setup slabs.
    • Leave Encashment Y/N: Allow the system to calculate payments for unused leave days.
    • Sandwich Y/N: A policy flag determining if holidays falling between two leave days are also counted as leave.
    • Status: Toggle to Yes to make this entire configuration active for the next payroll run.

    System Workflow Connection

    This module acts as the “glue” for the entire HRMS:

    • It takes Allowances and Deductions.
    • It applies the math defined here based on the Employee Type.
    • It references Weekends and Working Days to calculate final payable amounts.

    Payroll Setup: Weekends Configuration

    The Weekends sub-module is used to define the official non-working days for different categories of employees. This configuration is critical for the payroll engine to accurately calculate attendance, “Loss of Pay” (LOP), and overtime.


    Weekend Entry (Master View)

    When you select Weekends from the Payroll Setup menu, the Weekend Entry list appears. This screen provides a high-level overview of the weekend policies currently active in the system.

    • Key Columns in the Table:
      • Day Title: Specifies the day designated as a weekend (e.g., Sunday).
      • Employee Type: Indicates which group of employees this weekend applies to (e.g., Permanent).
      • Enable?: Shows whether the specific weekend rule is active (Yes) or inactive (No).
    • Management Actions: Use the Edit icon to modify an existing rule or click the Add Weekend button to create a new one.

    Weekend Entry Forum (Pop-up Form)

    Clicking the “Add Weekend” button opens the Weekend Entry Forum. This simplified form allows you to map specific days to specific employee types.

    • Day ID: A dropdown menu to select the day of the week to be marked as a weekend (e.g., Saturday, Sunday, or Friday).
    • Employee Type: A mandatory dropdown to select the relevant workforce category (e.g., Permanent, Contract, or Intern). This allows for flexibility if different departments or roles have different weekly schedules.
    • Enable Toggle: A mandatory switch to activate (Yes) or deactivate (No) the weekend rule.

    System Integration & Impact

    The Weekends configuration directly influences other parts of the HRMS:

    • Attendance Tracking: The system automatically marks these days as “Off” in the attendance logs.
    • Overtime Calculation: If an employee works on a day defined here, the Payroll Configuration engine can trigger specific “Holiday Overtime” rates.
    • Sandwich Policy: References these settings to determine if a holiday falling between two leave days should be deducted from the employee’s leave balance.

    Payroll Setup: Working Days Configuration

    The Working Days sub-module is the final piece of the time-tracking puzzle. While Weekends defines when employees are off, Working Days explicitly defines the expected labor days per month to establish the “Daily Rate” for salary calculations.


    Working Days List (Master View)

    When you select Working Days from the Payroll Setup menu, you are presented with the Working Days List. This acts as the historical record of monthly work expectations.

    • Month & Year: Displays the specific period being configured (e.g., January 2026).
    • Total Days: The calendar days in that month (28, 29, 30, or 31).
    • Working Days: The actual number of days an employee is expected to work after subtracting weekends and gazetted holidays.
    • Employee Type: Shows if the rule applies to Permanent, Contract, or other staff categories.
    • Status: Indicates if the month’s work cycle is “Open” or “Locked” for payroll.

    Working Days Entry Form

    Clicking “Add Working Days” opens the configuration form. This is where the manual calculation meets system automation.

    Period Selection

    • Year & Month: Dropdown menus to select the specific fiscal period.
    • Employee Type: Select the category of employees this specific monthly count applies to.

    Day Count Logic

    • Total Days: Usually auto-filled based on the month selected (e.g., 31 for March).
    • Holidays/Weekends: Input the number of non-working days for that specific month.
    • Net Working Days: The system calculates:
      $$\text{Total Days} – \text{Non-Working Days} = \text{Net Working Days}$$
    • Enable Toggle: Set to Yes to allow the payroll engine to use this number as the divisor for daily wage calculations.

    Why This Matters for Your Payroll

    The Working Days value is the denominator for almost every automated calculation in the HRMS:

    • Daily Rate Calculation:
       $$\frac{\text{Gross Salary}}{\text{Working Days}} = \text{Daily Rate}$$
    • Loss of Pay (LOP): If an employee is absent for 2 days, the system deducts:
      $$2 \times \text{Daily Rate}$$
    • New Joiners/Resignations: If someone starts mid-month, the system uses this count to “Prorate” their first salary accurately.

    Payroll Setup: Employee Tax Adjustment

    The Employee Tax Adjustment sub-module provides the necessary flexibility to handle unique tax scenarios that fall outside of the standard global Tax Setup slabs. It allows HR and Finance administrators to manually modify the tax liability for specific individuals based on special declarations, legal exemptions, or prior over/under-payments.


    Tax Adjustment List (Master View)

    When you select Employee Tax Adjustment from the Payroll Setup menu, you are presented with a summary of all pending and processed adjustments.

    • Employee Name/ID: Identifies the specific staff member receiving the adjustment.
    • Adjustment Amount: Shows the total value being added to or subtracted from the employee’s tax calculation.
    • Type: Indicates if it is a Tax Credit (reducing tax) or a Tax Debit (increasing tax).
    • Status: Displays whether the adjustment is Active, Pending Approval, or already Processed in a past payroll cycle.

    Employee Tax Adjustment Entry Form

    Clicking “Add Tax Adjustment” opens the entry interface where the specific parameters of the change are defined.

    Employee Identification

    • Select Employee: A searchable dropdown to link the adjustment to a specific record in the Employees Setup module.
    • Fiscal Year: Automatically references the active year from the Tax Setup to ensure the adjustment hits the correct tax period.

    Financial Details

    • Adjustment Type: Choose between:
      • Fixed Amount: A specific dollar value (e.g., a $500 rebate).
      • Percentage: A modification based on a percentage of the calculated tax.
    • Amount: Enter the numerical value of the adjustment.
    • Reason/Remarks: A mandatory text field to document the justification for the manual change (e.g., “Investment Declaration” or “Arrears Adjustment”) for audit purposes.

    Execution Controls

    • Effective Date: Defines which payroll month the adjustment should be applied to.
    • One-Time vs. Recurring: Toggle whether this is a single correction or a change that repeats for the remainder of the fiscal year.
    • Enable Toggle: Set to Yes to authorize the payroll engine to include this adjustment in the next “Run”.

    System Integration & Audit Trail

    Because manual tax changes are high-sensitivity actions, the system ensures:

    • Automatic Calculation: The payroll engine first calculates the standard tax, then applies this adjustment to reach the Final Net Tax.
    • Payslip Transparency: The adjustment is clearly labeled on the employee’s payslip so they understand why their tax differs from standard slabs.
    • GL Mapping: Any adjustments are automatically reflected in the linked Tax Deduction COA in the financial ledger.

    Payroll Setup: Deduction Rate Configuration

    The Deductions Rate sub-module is the mathematical engine for variable subtractions. While the Deductions module defines the what, the Deductions Rate defines the how much for specific employee categories, particularly for statutory contributions like Social Security or Provident Funds.


    Deduction Rate List (Master View)

    Selecting Deductions Rate from the Payroll Setup menu displays the registry of all active calculation rules.

    • Deduction Name: Identifies the specific subtraction (e.g., EOBI, Social Security).
    • Employee Type: Specifies which workforce group the rate applies to (e.g., Permanent, Contract).
    • Employee Rate: The percentage or fixed value deducted from the employee’s pay.
    • Company Rate: The matching contribution rate paid by the employer.
    • Enable?: A status indicator showing if the rate is currently being applied to live payroll runs.

    Deduction Rate Entry Form

    Clicking “Add Deduction Rate” opens the configuration interface to link math to policy.

    Rule Identification

    • Select Deduction: A dropdown to choose from the master list created in the Deductions sub-module.
    • Employee Type: Defines the scope of the rule (e.g., different rates for Interns vs. Full-time staff).

    Rate Calculation Logic

    • Calculation Base: Choose whether the rate is calculated based on Basic Salary, Gross Salary, or a Fixed Amount.
    • Employee Contribution: Enter the numerical value (Percentage or Amount) for the staff member.
    • Company Contribution: Enter the matching value for the organization’s expense.
    • Upper/Lower Limits: Set “Ceilings” (Maximums) or “Floors” (Minimums) for the deduction to comply with government caps on statutory funds.

    Activation

    • Effective Date: Sets the specific month when this new rate should start being used.
    • Enable Toggle: Set to Yes to authorize the payroll engine to pull these values during the next generation cycle.

    System Workflow Connection

    The Deductions Rate acts as a bridge between HR policy and Finance:

    • Attendance: It checks the Working Days and Weekends to see if the employee earned enough to trigger the deduction.
    • Payroll Run: The system multiplies the Calculation Base by the Employee Rate to reach the final subtraction on the payslip.
    • Financial Posting: The Company Contribution is automatically posted to the Expense COA defined in the Payroll Configuration.

    HRMS Module: Leave Setup

    The Leave Setup module is designed to manage employee time-off policies, track attendance categories, and define the organizational holiday calendar to ensure seamless workforce management.

    Leave Setup: Leave Types Management

    The Leave Types sub-module allows the organization to define the various categories of time off available to employees. This configuration ensures that leave is requested, approved, and tracked according to company policy and labor laws.

    Leave Types List (Master View)

    When you select Leave Types from the Leave Setup menu, the Leave Types List appears. This screen acts as the central registry for all active and inactive leave categories.

    • Edit Function: Use the Edit icon to modify the rules or entitlement for an existing leave type.
    • Search & Filter: Quickly locate specific categories (e.g., Sick, Annual, Casual) using the search bar.
    • Leave Summary Table:
      • Leave Name: The full descriptive title of the leave category.
      • Short Name: The system-wide abbreviation used for reporting and attendance logs (e.g., AL for Annual Leave).
      • Gender: Indicates if the leave is restricted to a specific gender (e.g., Female for Maternity).
      • Total Days: The default annual entitlement for that specific leave type.
      • Enable Status: Shows if the leave type is currently active in the system.

    Leave Type Entry Form

    Clicking the “Add Leave Type” button opens the configuration form. This is where you define the specific “math” and logic for the leave category.

    Basic Identification

    • Leave Name: Enter the official title of the leave.
    • Short Name: Assign a unique code for payslips and calendars.
    • Gender Selection: Use the dropdown to set the eligibility (Male, Female, or All).

    Entitlement & Rules

    • Total Leaves: Enter the maximum number of days an employee is allowed for this category per year.
    • Encashable Flag (Yes/No): Determines if unused balances can be paid out in cash (usually for Annual Leave).
    • Carry Forward (Yes/No): Sets whether the remaining balance at year-end moves to the next fiscal year or expires.
    • Pro-Rata (Yes/No): If enabled, the system calculates leave based on the joining date (e.g., someone joining in July gets half the annual entitlement).

    System Controls

    • Status (Enable/Disable): Toggles the availability of this leave type for employee requests.
    • Approval Levels: While managed in “Authorization Levels,” this form often flags if a specific type requires single or multi-tier approval.

    Standard Leave Examples

    • Annual Leave (AL): Typically 14–30 days, carry-forward and encashable.
    • Sick Leave (SL): Usually 8–10 days, non-encashable, requires medical proof after a certain threshold.
    • Casual Leave (CL): For short, unplanned absences, usually non-carry-forward.
    • Maternity Leave (ML): Gender-specific, often a fixed block of days (e.g., 90 days).

    Leave Setup: Attendance Types Management

    The Attendance Types sub-module categorizes the daily status of an employee. This is crucial for synchronizing the attendance machine (biometric/log) with the payroll engine to determine if a day is payable, a half-day, or an official duty.

    Attendance Types List (Master View)

    Clicking Attendance Types opens the master list. This registry shows all the ways a workday can be recorded.

    • Attendance Name: The label for the status (e.g., Present, Official Duty, Work From Home, Half-Day).
    • Short Name: The system code used in attendance reports and logs (e.g., PR, OD, WFH, HD).
    • Type/Category: Shows if the status is considered “Present” or “Absent” by the system logic.
    • Enable Status: Indicates if this attendance category is active for selection by HR or employees.

    Attendance Type Entry Form

    When you click the “Add Attendance Type” button, the entry form appears to configure the following fields:

    Basic Information

    • Attendance Name: Enter the descriptive name of the status.
    • Short Name: Assign a 2-4 letter code (e.g., “OD” for Official Duty).
    • Color Code: Often available to help visualize different statuses on the Monthly Attendance Calendar.

    Credit & Calculation Logic

    • Day Credit: Define the numerical value of this attendance type.
      • 1.0 = Full Day (e.g., Present, WFH).
      • 0.5 = Half Day.
      • 0.0 = Absent or Unpaid status.
    • Is Payable (Yes/No): Determines if this status triggers a salary payment.
    • Is Late Applicable (Yes/No): Sets whether the system should still check for “Late Coming” rules if an employee is marked with this status (e.g., “Official Duty” might bypass late rules).

    Permission & Toggles

    • Approval Required (Yes/No): If “Yes,” the employee can request this status (like Work From Home), but it must be approved via the Authorization Level before it counts.
    • Manual Entry Flag: Determines if this type can be manually selected by an admin to override biometric data.
    • Status (Enable/Disable): Keeps the attendance type active or inactive.

    Common Attendance Type Examples

    • Present (PR): Standard biometric clock-in; counts as 1.0 credit.
    • Official Duty (OD): Used when an employee is working at a client site or traveling; counts as 1.0 credit and usually bypasses late-arrival penalties.
    • Work From Home (WFH): Remote work status; usually requires approval.
    • Half-Day (HD): Automatically or manually applied; counts as 0.5 credit.

    Leave Setup: Leave Balance Management

    The Leave Balance sub-module acts as a “bank account” for employee time off. It is the real-time record that prevents employees from over-utilizing their leaves and provides HR with an overview of the organization’s leave liability.

    Leave Balance List (Master View)

    When you select Leave Balance from the menu, a comprehensive table appears showing the current standing for every employee.

    • Employee Name/ID: Identifies the specific staff member.
    • Leave Type: Specifies the category (e.g., Annual, Sick, Casual).
    • Opening Balance: The total leaves assigned at the start of the year or fiscal period.
    • Leaves Consumed: The total number of days the employee has already taken.
    • Closing/Remaining Balance: The net amount available for future requests.
    • Lapsed Leaves: Leaves that were not carried forward or encashed and have expired.

    Leave Balance Entry/Adjustment Form

    While the system usually calculates balances automatically, the “Add/Adjust Leave Balance” form allows for manual overrides or initial setup.

    Selection Criteria

    • Employee: Select the specific individual for balance adjustment.
    • Leave Type: Choose which “bucket” is being adjusted (e.g., adding extra Sick Leave).
    • Fiscal Year: Ensures the balance is applied to the correct annual cycle.

    Balance Details

    • Opening Balance: Manually set the initial entitlement (often used when migrating from an old system).
    • Adjustment Amount: A field to add (+) or subtract (-) days from the current balance.
    • Remarks/Reason: A mandatory field to document why a manual adjustment was made (e.g., “Awarded extra leave for project completion”).

    Carry Forward Logic

    • The form displays whether this specific leave type supports Carry Forward (as defined in the Leave Types module).
    • If enabled, the system automatically migrates the Closing Balance of the previous year into the Opening Balance of the new year.

    System Impact & Validation

    The Leave Balance module acts as a gatekeeper:

    • Request Validation: When an employee applies for leave, the system checks this module. If the request exceeds the Remaining Balance, it is either blocked or flagged as “Unpaid/Loss of Pay”.
    • Payroll Integration: At the end of the month, the system reports “Consumed Leaves” to the payroll engine to calculate any deductions.
    • Encashment: At the end of the year, the system uses the Closing Balance to calculate “Leave Encashment” payments for eligible types.

    Leave Setup: Gazetted Holidays Management

    The Gazetted Holidays sub-module allows HR to pre-define all national, religious, or public holidays for the calendar year. These days are automatically treated as non-working days, ensuring they don’t count against an employee’s personal leave balance or result in a salary deduction.

    Gazetted Holidays List (Master View)

    When you select Gazetted Holidays, you see a chronological list of all holidays defined for the current fiscal or calendar year.

    • Holiday Title: The name of the occasion (e.g., Independence Day, Eid, Christmas).
    • Date: The specific calendar date(s) assigned to the holiday.
    • Day: The day of the week (e.g., Monday).
    • Status: Shows if the holiday is Active (enabled for payroll) or Inactive.
    • Management: An Edit icon is available to change dates (useful for lunar holidays like Eid) or a Delete option for canceled holidays.

    Gazetted Holiday Entry Form

    Clicking the “Add Holiday” button opens a form to register a new date in the company calendar.

    Holiday Details

    • Holiday Name: Enter the official name of the holiday.
    • Short Name: A code for reporting (e.g., “ID24” for Independence Day 2024).
    • Holiday Date: Use the calendar picker to select the specific date.

    Scope & Applicability

    • Gender: If a holiday is gender-specific (e.g., International Women’s Day), it can be restricted here; otherwise, it is set to “All.”
    • Religion: Some systems allow holidays to be restricted by religion (e.g., Holi for Hindu employees), ensuring only relevant staff are marked “Off.”
    • Employee Type: Define if the holiday applies to all staff or only specific groups (e.g., Permanent vs. Daily Wagers).

    Activation

    • Enable Toggle: Set to Yes to push this holiday to the Attendance and Payroll modules.

    System Integration & Impact

    Configuring these holidays correctly is vital for several automated processes:

    • Leave Calculation: If an employee takes a week of leave and a Gazetted Holiday falls in the middle, the system will not deduct that day from their Leave Balance.
    • Payroll & Overtime: If an employee is required to work on a Gazetted Holiday, the Payroll Configuration can trigger a higher “Holiday Overtime” rate (e.g., 2.0x).
    • Sandwich Policy: The system uses this list to determine if a holiday is “sandwiched” between two leave days, which might trigger a full leave deduction depending on company policy.

    Leave Setup: Authorization Level Management

    The Authorization Level sub-module transforms simple data entry into a formal business process. It prevents unauthorized absences and ensures that managers have full visibility over their team’s availability before a leave is finalized.

    Authorization Level List (Master View)

    When you select Authorization Level, the system displays the existing approval workflows.

    • Workflow Name: The title of the approval path (e.g., General Leave Approval, OT Approval).
    • Employee Type/Department: Shows which group of employees follows this specific hierarchy.
    • Number of Levels: Indicates how many people must sign off on a request (e.g., 1-Level, 2-Level).
    • Status: Shows if the workflow is currently active.

    Authorization Level Entry Form

    Clicking “Add Authorization Level” allows you to build the “Chain of Command” for your organization.

    Header Information

    • Authorization Title: Give the workflow a name (e.g., “Standard 2-Tier Approval”).
    • Module Selection: Choose which action this workflow applies to (e.g., Leave Request, Short Leave, Attendance Correction).
    • Employee Category: Select the departments or employee types (Permanent, Contract) governed by this rule.

    Defining the Hierarchy (The Steps)

    The form typically features a grid where you add the sequence of approvers:

    • Level 1 (Immediate Supervisor): Usually the direct Line Manager. They are the first to receive a notification when an employee applies.
    • Level 2 (Department Head/HR): If the first level approves, the request moves here. This is common for longer leaves (e.g., Annual Leave).
    • Final Level: The person whose “Approve” action actually updates the Leave Balance and Attendance Type in the system.

    Action Toggles

    • Email/SMS Notification: Toggle whether approvers receive automatic alerts.
    • Auto-Approve Threshold: Set a time limit (e.g., 48 hours). If the manager doesn’t act, the request can either be auto-approved or escalated to the next level.
    • Enable Toggle: Set to Yes to make the workflow live.

    System Workflow Connection

    This module acts as the “Traffic Controller” for the HRMS:

    • Request Initiation: An employee submits a leave via their portal.
    • Validation: The system checks Leave Balances and Gazetted Holidays.
    • Routing: The system looks at the Authorization Level and routes the request to the Level 1 approver’s dashboard.
    • Finalization: Once the final level approves, the system automatically marks the employee as “On Leave” in the Attendance logs and deducts the days from their balance.

     HRMS Module: Employee Setup

    The Employee Setup module is a comprehensive database used to record personal, professional, and financial details of the workforce. This data feeds directly into Payroll, Attendance, and Performance modules.

    In the Employee Setup module, we begin by defining the organizational structure. The Department sub-module is the first building block, used to categorize the workforce into functional units (e.g., IT, HR, Finance, Production).


    Employee Setup: Department Configuration

    The Department sub-module allows HR to map the organization’s hierarchy. This categorization is essential for reporting, departmental budgeting, and defining approval workflows in the Authorization Level module.

    Department List (Master View)

    When you click on Department, a list of all existing functional units appears.

    • Department Name: The full title of the unit (e.g., Information Technology).
    • Department Code: A short identifier used for backend mapping or employee ID generation (e.g., “IT”, “FIN”).
    • Head of Department (HOD): Displays the assigned lead for the department (if mapped).
    • Status: Indicates if the department is currently Active or Inactive.
    • Management Actions: Includes the Edit icon to rename units and the Add Department button to expand the organizational structure.

    Department Entry Form

    Clicking the “Add Department” button opens a focused form to register a new unit.

    Core Identification

    • Department Name: Enter the official name of the department.
    • Short Name/Code: Assign a unique abbreviation.
    • Parent Department: (Optional) If your organization uses sub-departments, you can link this unit to a “Parent” (e.g., “Software Development” linked to “IT”).

    Financial & Operational Mapping

    • Cost Center: Link the department to a specific Cost Center for financial reporting and payroll expense distribution.
    • Location: Assign the department to a physical branch or office if the company operates in multiple sites.
    • Sort Order: Define the numerical order in which this department appears in dropdown menus and reports.

    System Controls

    • Enable Toggle: Set to Yes so the department appears as an option in the Employee Entry form.

    System Integration & Impact

    The Department setup is not just a label; it drives several automated functions:

    • Payroll Posting: Salary expenses can be grouped and posted to the General Ledger (GL) by Department.
    • Security & Access: Access to specific data or reports can be restricted based on the user’s assigned department.
    • Filtered Requests: In the Authorization Level module, you can set specific approval paths that only apply to the “Sales Department” or “Factory Staff.”

    Employee Setup: Designation Configuration

    The Designation sub-module is used to create a standardized list of job titles. This ensures consistency across the HRMS, preventing duplicate titles (e.g., “Manager” vs. “Mgr”) and enabling precise salary benchmarking and reporting.

    Designation List (Master View)

    The Designation List provides a high-level view of the roles currently defined in the system.

    • Designation Title: The official job name (e.g., Software Engineer, Senior Accountant).
    • Designation Code: A unique short code for system mapping (e.g., SE, SA).
    • Grade/Category: Shows the seniority level associated with the title (if applicable).
    • Status: Indicates if the role is currently active and available for assignment to new hires.
    • Actions: Use the Edit or Delete icons to manage the titles.

    Designation Entry Form

    Clicking “Add Designation” opens the configuration form to define a new role.

    Identity & Rank

    • Designation Name: Enter the full professional title.
    • Short Name: Assign a code (e.g., “GM” for General Manager).
    • Job Description (Optional): A text field to outline the core responsibilities associated with this role.
    • Rank/Level: A numerical value or dropdown to define seniority (e.g., Level 1, Level 2). This helps in sorting organizational charts.

    Reporting Logic

    • Reporting To (Optional): Define the default supervisor title for this role. For example, a “Sales Executive” might by default report to a “Sales Manager.”

    System Controls

    • Sort Order: Determines where this designation appears in lists (e.g., Executives at the top, Juniors at the bottom).
    • Enable Toggle: Set to Yes to make this title selectable in the Employee Entry form.

    Why This Matters for the HRMS

    The Designation setup is critical for several system-wide automations:

    • Salary Slabs: Often, certain Allowances or Deductions are tied to specific designations (e.g., a “Fuel Allowance” for Managers only).
    • Leave Entitlement: Senior designations may be granted more annual leaves than junior roles.
    • Recruitment: When a job vacancy is opened, the system pulls the requirements and descriptions directly from this setup.

    Employee Setup: Shift Configuration

    The Shift sub-module defines the time boundaries for the workday. It tells the system when an employee is expected to “Clock In,” when they are “Late,” and when “Overtime” begins.

    Shift Master List

    This screen displays the different timing templates used by the company.

    • Shift Name: (e.g., Morning Shift, Night Shift, Evening, General).
    • Shift Timings: Displays the Start and End times.
    • Grace Period: Shows how many minutes of “Late Coming” are allowed.
    • Status: Active or Inactive.

    Shift Entry Form

    When you click “Add Shift,” you define the “Rules of Time” for that specific schedule:

    Timing Parameters

    • Start Time & End Time: The official working hours (e.g., 09:00 AM to 06:00 PM).
    • Break Start & End: Defines the unpaid or paid lunch hour.
    • Total Hours: Automatically calculated by the system (e.g., 9 hours).

    Buffer & Grace Rules

    • Grace Time (Late): The number of minutes an employee can be late without penalty (e.g., 15 mins).
    • Grace Time (Early Out): How many minutes an employee can leave early without it being flagged.
    • Late Arrival Threshold: The time after which a “Half Day” or “Short Leave” is automatically deducted.

    Overtime (OT) Rules

    • OT Start Time: Does OT start immediately after the shift ends, or is there a gap (e.g., OT starts 30 mins after End Time)?
    • Min/Max OT: The minimum minutes required to qualify for OT.

    Shift Allocation / Schedule

    Once the shifts are created, they must be assigned to employees.

    • Fixed Shift: The employee works the same shift every day (e.g., General Shift).
    • Rotating Shift: Used for factories or 24/7 operations where employees move from Morning to Night shifts weekly.
    • Shift Roster: A calendar view where HR can bulk-assign shifts to departments or specific teams for the upcoming month.

    System Impact

    • Attendance Machine: When the biometric log arrives, the system compares the “Punch Time” against the Shift Start Time to flag “Late” or “Present.”
    • Payroll: If an employee is consistently late beyond the Grace Time, the system calculates deductions based on the Payroll Configuration rules.
    • Shift Differential: Some companies pay extra for “Night Shifts,” which is triggered by the shift assigned here.

    Employee Setup: Detailed Employee Profile

    The Employees screen is where you finalize the “Hiring” process in the system. This record serves as the “Source of Truth” for every other module.

    Employment & Shift Assignment Tab

    This is where the Shift and Attendance logic is tied to the individual:

    • Shift Selection: A dropdown menu allows you to select from the Shifts created earlier (e.g., Morning, Night, General).
    • Attendance Type: Defines if the employee is tracked via Biometrics, Manual Log, or is Exempt from attendance (e.g., Field Staff).
    • Overtime Eligibility: A toggle to enable or disable OT calculation based on the Payroll Configuration rules.
    • Weekend Policy: Assigns which days (from the Weekends setup) are “Off” for this specific person.

    Professional Mapping Tab

    This section places the employee within the organizational hierarchy we built:

    • Department & Designation: Select the functional unit and job title.
    • Reporting Officer (RO): You select the manager who will appear in the Authorization Level workflow.
    • Reviewer / HOD: Some systems allow for a secondary level of reporting for performance appraisals.

    Statutory & Benefit Tab

    Here, you activate the financial “calculators” for the employee:

    • Tax Status: A toggle for Filer vs. Non-Filer. This tells the system which percentage to pull from the Tax Setup slabs.
    • Social Security & Pension: Toggles for EOBI, ESSI, and Provident Fund.
      • Note: If you toggle “Yes,” the system will look at the Deduction Rates module to know exactly how much to subtract from the salary.

    Document Attachment (The Digital File)

    Most systems include an “Attachments” section within the Employee setup to replace physical folders:

    • Required Docs: CNIC Copy, Appointment Letter, Educational Degrees, and CV.
    • Expiry Alerts: For items like Driving Licenses or Passports, the system can send alerts before they expire.

    System Workflow Integration

    • Syncing to Machine: Once you save an employee with an ID (e.g., 105), the biometric machine will recognize punches for ID 105 and map them to this profile.
    • Payroll Trigger: An employee must be marked as “Active” here to appear in the monthly payroll sheet.
    • Leave Accrual: Based on the Joining Date entered here, the system automatically starts “earning” leaves for the employee in the Leave Balance module.

    Employee Setup: Grade Configuration

    The Grades sub-module is used to standardize salaries and benefits. By grouping employees into grades (e.g., Grade M1, Grade M2, Grade S1), HR ensures internal equity—meaning people at the same level of responsibility receive similar pay ranges and perks.

    Grade List (Master View)

    The master list provides an overview of the organization’s ranking system.

    • Grade Name: The identifier for the rank (e.g., Executive, Management, Staff).
    • Grade Code: A short code (e.g., G-01, G-02).
    • Min/Max Salary: Displays the “Pay Range” or “Band” allowed for this grade.
    • Status: Shows if the grade is currently active for assignment.

    Grade Entry Form

    When you click “Add Grade,” you define the boundaries for that specific rank:

    Basic Identity

    • Grade Name: The official title (e.g., “Senior Management”).
    • Short Name: The code used in backend logic (e.g., “M3”).
    • Rank/Level: A numerical value used to determine seniority for reporting (e.g., Rank 1 is higher than Rank 10).

    Financial & Benefit Anchors

    • Basic Salary Range: Define a Minimum and Maximum salary for this grade. This prevents HR from hiring someone at a salary that is too high or too low for their rank.
    • Fixed Allowances: Often, certain benefits are tied to the grade rather than the person (e.g., All Grade M3 employees get a $200 Fuel Allowance).
    • Leave Entitlements: You can link specific Leave Types to grades (e.g., Managers get 25 days of leave, while Staff get 15).

    Promotion & Hierarchy

    • Next Grade: Define the logical “Promotion Path” (e.g., Grade G-01 promotes into Grade G-02).

    Why Grades are Essential for HRMS

    The Grade setup automates several complex HR functions:

    • Salary Validation: During Employee Entry, if you try to give an employee a salary higher than their Grade Maximum, the system will trigger a warning or require special approval.
    • Benefit Automation: Instead of manually adding a “Medical Allowance” to every new hire, the system sees they are “Grade G-05” and automatically adds all allowances associated with that grade.
    • Reporting: Management can run “Cost to Company” (CTC) reports by Grade to see how much is being spent on Executive levels versus Entry levels.

    Employee Setup: Benefits Terms & Conditions

    This sub-module translates the company’s HR Policy Handbook into system logic. It dictates when a benefit starts, who is eligible, and what happens to that benefit if an employee leaves.

    Policy Master List

    The main screen displays the various benefit policies currently active in the HRMS.

    • Benefit Name: (e.g., Provident Fund Policy, Gratuity Scheme 2024, Annual Bonus).
    • Eligibility Period: Shows the required service time (e.g., “After 6 Months”).
    • Employee Category: Displays which group the policy applies to (e.g., “Permanent Only”).
    • Status: Active/Inactive.

    Terms & Conditions Configuration Form

    When adding or editing a benefit policy, the following fields define the “Rules of Engagement”:

    Eligibility Criteria

    • Minimum Service Period: Defines how long an employee must be with the company before the benefit kicks in (e.g., 3 months of probation must be completed).
    • Employee Type/Grade: Restricts the benefit to specific ranks (e.g., “Car Allowance” only for Grade M1 and above).
    • Confirmation Status: A toggle to decide if the benefit is only for “Confirmed” employees or if “Probationary” staff can also receive it.

    Calculation & Limit Rules

    • Vesting Period: Used specifically for Provident Funds or Stock Options—defines how many years an employee must stay to “own” the company’s contribution (e.g., 25% after 2 years, 100% after 5 years).
    • Formula Base: Links the benefit to a specific salary component (e.g., “Gratuity = $\text{Last Drawn Basic Salary} \times \text{Years of Service}$”).
    • Cap/Ceiling: Sets a maximum limit for the benefit to control company costs.

    Separation (Exit) Terms

    • Notice Period Impact: Defines if the benefit is forfeited if the employee fails to serve their notice period.
    • Encashment Rules: Specifies if the benefit can be “cashed out” upon resignation or retirement.

    System Integration

    The Terms & Conditions act as a filter for the Payroll and Final Settlement modules:

    • Automated Enrollment: The system monitors the Joining Date in the Employee Master. Once the employee hits the “6-month” mark, the system automatically begins deducting Provident Fund based on these terms.
    • Compliance Check: If an HR user tries to manually add a benefit to an ineligible employee, the system will block the action based on these defined conditions.
    • Final Settlement: When an employee resigns, the system references these terms to calculate exactly how much Gratuity or Bonus is owed based on their total tenure.

    Employee Setup: Increment & Promotion

    This module allows HR to update an employee’s profile while maintaining a clear audit trail of their previous roles and salaries. It ensures that when a change is made, it automatically updates the Payroll and Reporting Hierarchy.

    The Increment/Promotion List

    This screen tracks the history of all movements within the organization.

    • Employee Name/ID: Who received the change.
    • Type: Indicates if it was an “Annual Increment,” “Promotion,” or “Off-Cycle Adjustment.”
    • Effective Date: The date the new salary or rank becomes active in the system.
    • Approval Status: Shows if the change has been authorized by the relevant HOD or Finance head.

    Entry Form (Applying the Change)

    When you click “New Promotion/Increment,” the form is usually divided into “Current” and “Revised” sections for comparison.

    Structural Changes (Promotion)

    • Current vs. New Designation: Move an employee from Junior Engineer to Senior Engineer.
    • Current vs. New Grade: Upgrade their rank (e.g., G-01 to G-02).
    • Department Change: Allows for “Lateral Transfers” between departments.

    Financial Changes (Increment)

    • Current Gross/Basic: Shows the existing salary.
    • Increment Type: Choose between Percentage (%) or Fixed Amount.
      • Example: A 10% increase or a flat $500 increase.
    • Revised Salary: The system automatically calculates the new total.
    • Arrears (Yes/No): If the increment is backdated, the system calculates the “Arrears” (back-pay) to be paid in the next payroll cycle.

    Hierarchy Update

    • Change Reporting Manager: If the promotion moves the employee to a new team, you can update their Authorization Level path here.

    System Integration & Impact

    The Increment & Promotion module is a powerful automation tool:

    • Automatic Payroll Update: Once the effective date is reached, the Payroll Module automatically pulls the “Revised Salary” instead of the old one. No manual intervention is needed in the salary sheet.
    • Service Book History: The system saves a “Snapshot” of the old profile. If an employee has been with the company for 10 years, HR can view a timeline of every promotion they’ve ever had.
    • Letter Generation: Most systems allow you to click a button to generate an official Promotion Letter or Increment Letter using the data entered in this form.

    Bulk Increment (Appraisal Cycle)

    During annual reviews, HR can use a Bulk Increment tool to upload an Excel sheet. This allows for updating hundreds of employees at once rather than one by one, applying a standard percentage (e.g., 5%) across a specific department or grade.

    Notification Module

    The Notification Module serves as the primary communication hub within the HRMS. It provides real-time updates and critical information tailored to your specific role and access levels.

    Overview

    The notification system ensures you never miss important actions or updates. The content of your notification feed is dynamic, meaning you will only see alerts related to the modules you are authorized to access (e.g., Leave, Overtime, or Asset Registration).

    Key Features

    FeaturesDescription
    Centralized AlertsDisplays all HR-related notifications such as approvals, status changes, and pending tasks.
    Role-based FilteringNotifications are filtered based on user roles to ensure relevant information is displayed.

    Step-by-step Flow:

    • Login as Employee/Manager/Admin.
    • Navigate to the “Notifications” tab.
    • View pending tasks or alerts.
    • Click to take action (approve, reject, acknowledge).

    Instant Updates: Receive real-time alerts for pending approvals, system updates, or status changes.
    Role-Based Filtering: Your notification list is automatically filtered based on your permissions. For example, a Manager will see “Approval Requests,” while an Employee might see “Request Status Updates.”
    Centralized Tracking: Keep track of all historical activities and communications in one place to ensure no task is overlooked.

    How it Works

    Access: Locate the Notification menu item from the main HRMS dashboard.
    View: Click to open the list of recent updates.
    Action: Clicking on a specific notification will often redirect you to the relevant module (like Leave Request or Overtime Approval) to take immediate action.

    Over Time (OT)

    The Over Time module allows employees to record and submit additional working hours for compensation or tracking.

    Employee View: Over Time Request

    This section is for employees who have worked beyond their standard shift.

    Request Entry: Log the specific date, start time, and end time of your overtime session.
    Reasoning: Provide a brief description of the tasks performed to justify the additional hours.
    Submission: Once submitted, the request enters a “Pending” state until reviewed by a supervisor.

    Manager/Admin View: Over Time Approval

    This section is visible only to users with Approval Rights.
    Review Queue: View a list of all pending OT requests from subordinates.
    Verification: Compare the requested hours against biometric attendance logs (if integrated).
    Action: Approve the request for payroll processing or Reject/Return it with comments for more information.

    Over Time Approval

    The Over Time Approval module is a management tool used to review, verify, and finalize additional hours submitted by employees. This ensures that all overtime costs are justified and accurate before they reach the payroll stage.

    Overview

    This module provides a centralized queue of all pending overtime requests. As an authorized approver, you have the responsibility to ensure that the work performed aligns with company needs and attendance records.

    Key Features

    Approval Queue: A dedicated workspace to see all incoming OT requests from your department or team.
    Request Verification: Review the specific dates, times, and reasons provided by the employee for the extra work.
    Role-Based Authority: Only users assigned Admin or Managerial rights by the system administrator will see this module in their HRMS menu.
    Decision Audit Trail: Every approval or rejection is logged, creating a clear history for HR and payroll auditing.

    How to Process Approvals

    Access: Click the Over Time Approval card or menu item.
    Review Submissions: Examine the “Review and approve employee overtime submissions” list. Check for accuracy and timeliness.
    Validate: Cross-reference the request with the employee’s Biometric Attendance if necessary.
    Finalize: * Approve: Confirm the hours for payroll processing.
    Reject/Return: If information is missing or the hours are incorrect, send it back with a comment for the employee to rectify.

    Leave Module

    The Leave module manages the lifecycle of time-off requests. It provides a structured way for employees to apply for absences and for administrators to manage company-wide attendance efficiently.

    Leave Request (Employee View)

    This sub-module is designed for simplicity, allowing employees to manage their own time off without manual paperwork.

    Submission: Submit a leave request in a few simple steps by selecting the leave type (e.g., Annual, Sick, Casual) and the date range.
    Tracking: Monitor the status of your applications. You can view Pending requests awaiting a manager’s decision and a history of Approved applications.
    Balance Overview: (If applicable) View your remaining leave balance before submitting a new request to ensure eligibility.

    Leave Approval (Admin/Manager View)

    This section is visible only to users with HRMS Administrative rights or managerial permissions.

    Efficient Review: Access a centralized dashboard to review employee leave requests.
    Actionable Decisions: Approve or reject applications with the ability to view “complete details,” such as the reason for leave and how it impacts departmental coverage.
    Administrative Overrides: Users with full HRMS rights can also initiate or apply for leaves on behalf of other employees if required by company policy.

    Pro-Tip: The visibility of the “Leave Approval” card depends entirely on the Rights assigned to your profile by the system admin. If you are a supervisor but cannot see this card, please contact the IT department.

    Attendance Module

    This module provides a comprehensive view of employee timekeeping, ranging from raw biometric logs to high-level management overviews.

    Attendance Management

    Purpose: Allows administrators to easily track and manage overall employee attendance.
    Utility: Ensures that all records are accurate for payroll processing and legal compliance.

    Daily Attendance

    Real-Time Monitoring: Provides an instant view of day-to-day attendance details.
    Activity Tracking: Used to monitor specific check-in and check-out activities for the current day.

    Biometric Attendance

    Data Integration: Provides access to attendance data specifically captured through biometric devices.
    Security: Ensures that time records are tamper-proof and highly accurate by using physical verification.

    Biometric Device Attendance

    Hardware Oversight: Allows users to view raw attendance data received directly from connected biometric hardware.
    Sync Tracking: Used to monitor real-time syncing status and device-wise logs to ensure the hardware is communicating correctly with the HRMS.

    Leave Sandwich Form

    Automated Cleanup: This specialized tool allows administrators to convert unexcused absences into official leave with a single action.
    Data Integrity: Helps maintain clean and accurate attendance records by resolving gaps in the timeline.

    Employee Attendance Module

    The Employee Attendance module provides a detailed, searchable log of work shifts. It is the primary tool for verifying time-logs, shift adherence, and overall attendance status for specific periods.

    Overview

    This module features a comprehensive filter and grid system. Depending on your assigned Admin or HR rights, you can use this to audit your own records or search across the entire workforce to ensure operational consistency.

    Key Search Features

    To view records, users must interact with the following parameters as shown in the interface:

    Employee Selection: A dropdown or search field to select a specific individual or “ALL” employees (typically an Admin-only right).
    Date Range (From/To): Define the specific window you wish to audit (e.g., a single week or a full monthly payroll cycle).
    Search/Actions: Execute the search to populate the data grid or use the “Actions” button to export/manage the results.

    Understanding the Attendance Grid

    Once the search is performed, the system displays a column-based breakdown of the workday:

    Check In / Check Out: The exact timestamps recorded by the system (often via biometric sync).
    Shift Start / Shift End: The official scheduled hours the employee was expected to work.
    Status: A quick-glance indicator of the record (e.g., Present, Late, or Absent).
    Dept: Identifies the department associated with the record for easier organizational sorting.

    Admin vs. User Rights

    Important: While a standard employee may only see their own name in the “Employees” filter, a user with HRMS Administrative rights can toggle between departments and individuals to resolve attendance disputes or verify shift patterns.

    Overtime Module

    The Overtime module is a dual-purpose tool used for reporting and verifying extra work hours. Access to the approval functions is strictly governed by the HR or Admin rights assigned to a user’s profile.

    Overtime (Employee/User View)

    Accessing the Overtime Module

    From your main dashboard, locate the Overtime tile.

    • Purpose: Use this module to submit overtime hours for approval and track the status of your previous submissions.
    • Action: Click the tile to open the Overtime Form.

    Navigating the Overtime Form

    Once the form is open, you will see a search interface and a data table.

    Searching for Records

    To find existing overtime entries, use the filters at the top:

    • Department / Employee ID: Select from the dropdown menus to narrow results.
    • Date Range: Select a From Date and To Date (Required fields marked with a red asterisk).
    • Search: Click the Search button to populate the table.

    Understanding the Table

    The results table displays the following columns:

    • Employee ID & Name: Identification of the staff member.
    • Payment Date: The scheduled date for the overtime pay.
    • Allow Code: The specific category or code for the overtime.
    • OverTime Hours & Amount: The duration worked and the calculated monetary value.
    • Actions: Use the Edit icon to modify a record or the Delete icon to remove it.

    Uploading Overtime Data

    If you need to submit hours in bulk, click the Upload Overtime button in the top right corner. This launches the Data Load Wizard.

    Step 1: Data Load Source

    You have two options for importing data:

    • Upload file: Choose this to upload a .csv or tab-delimited file from your computer.
    • Copy and Paste: Select this (as shown in the wizard) to manually paste delimited data into the provided text box.
    • Action: After selecting your source and providing the data, click Next.

    Step 2: Mapping & Validation

    Follow the wizard through the remaining steps:

    • Data / Table Mapping: Match your uploaded columns to the system’s fields (e.g., ensure your “Hours” column matches “OverTime Hours”).
    • Data Validation: The system will check for errors. Review any flags before proceeding.
    • Data Load Results: Once finished, the system will confirm how many records were successfully uploaded.

    Overtime Approval Form (Admin/HR View)

    This section covers the Overtime Approval process, designed for supervisors to review and authorize employee overtime requests for monthly processing.


    Accessing Overtime Approvals

    Locate the Overtime Approval tile on your dashboard.

    • Purpose: Review and approve pending overtime requests from employees to ensure accurate monthly processing.
    • Action: Click the tile to open the Overtime Approval Form.

    Searching for Pending Requests

    To manage submissions, use the search filters at the top of the form:

    • Department & Employee ID: Filter by specific teams or individual staff members.
    • Date Range: Select a From Date and To Date to view requests within a specific pay period (Required fields).
    • Search: Click the Search button to generate the list of requests.

    Managing the Approval Table

    Once the data is populated, you can review the following details for each entry:

    • Employee Details: View the Employee ID, Name, Dept Name, and Designation.
    • Time Logs: Review the Check In and Check Out times alongside the calculated OT Hours.
    • Status: The OT Approve column indicates the current approval standing.

    Actions:

    • Edit/Save: Use the Edit button to make adjustments and the Save button to commit changes to the approval status.
    • Pull OverTime: Use the Pull OverTime button in the top right to fetch the latest submissions from the system.
    • Delete Overtime: If a request is invalid or a duplicate, use the Delete Overtime button to remove the record.

    Summary of Key Functions

    FeatureDescription
    Pull OverTimeSyncs new employee submissions into your approval queue.
    Search FiltersRequired to narrow down specific pay cycles or departments.
    Save ButtonFinalizes your approvals so they can be sent for payroll processing.

    Arrear Module

    The Arrear module provides a centralized workspace for managing and auditing back-pay records. This screen is designed for high-volume administrative tasks, allowing HR or Admin users to track all pending and processed arrears in one list.

    The Arrear List View

    The Arrears module ensures that retroactive payments are calculated accurately, taxed correctly, and documented for audit purposes.

    Add Arrear Entry Form

    This form is used to create a manual back-pay entry for a single employee. It allows HR to specify exactly which month the money belongs to.

    Employee Selection: Choose the employee from the master list.
    Arrear Type: Select the category (e.g., Salary Arrear, Allowance Arrear, Overtime Arrear).
    Month/Year (From/To): Define the period for which the payment is owed (e.g., “Jan 2026 to Feb 2026”).
    Calculation Mode: * Fixed Amount: You manually enter the total owed (e.g., $500).
    Difference Based: You enter the “Old Rate” and “New Rate,” and the system calculates the gap.
    Taxable Toggle: A checkbox to decide if this arrear should be added to the taxable income for the current month.
    Remarks: A mandatory field to explain the reason (e.g., “Promotion effective from January, processed in March”).

    Arrear Upload Button (Bulk Upload Form)

    In cases like an annual company-wide increment that is back-dated by three months, entering data one by one is impossible. The Arrear Upload feature allows for mass processing.

    Download Template: Click the button to get an Excel/CSV file with the required headers (EmpID, ArrearHead, Amount, Period).
    Data Population: HR fills in the data for hundreds of employees.
    Upload & Validate: Click the “Upload” button. The system performs a “Sanity Check”:
    Checks if Employee IDs are valid.
    Ensures no duplicate entries for the same period.
    Verifies that the amounts are within reasonable limits.
    Bulk Process: Once validated, the system creates “Pending” entries for all employees in the list.

    System Integration & Workflow

    Approval: Like loans or advances, Arrears usually require a “Second Level” approval from the Finance Manager before they appear in the payroll.
    Payroll List Impact: When you Process Payroll, the system looks for any “Approved Arrears” and adds them as a separate line item in the Earnings column.
    Pay Slip Transparency: The employee sees a clear “Arrears” row on their slip, so they know this is not part of their regular monthly base pay.
    Pro-Tip: Using the Arrear Upload is the safest way to handle “Bonus Adjustments” or “Retroactive Reversals” for large teams.

    Reports

    Arrear Register: A summary of all back-payments made in a specific year.
    Pending Arrears: A list of entries that have been “Added” but not yet “Processed” in a payroll cycle.

    Reports Module

    The Reports module provides critical data insights by consolidating HR and payroll activities into readable formats. It is designed for analysis, auditing, and organizational oversight.

    Transactional Reports

    This report is primarily used by Finance and Audit teams to verify the integrity of the payroll. It provides a line-by-line breakdown of every “event” that affected the company’s bank balance.

    Report Parameters (Filters)

    To get the exact data you need, the system allows you to filter the report by:

    • Transaction Date Range: View transactions for a day, a month, or a full quarter.
    • Transaction Head: Filter by specific items like “Mobile Allowance,” “Disciplinary Fine,” or “Bonus.”
    • Employee Group: View transactions only for a specific Grade or Department.
    • Transaction Type: Toggle between Credit (Earnings/Additions) and Debit (Deductions/Recoveries).

    Data Columns (The Audit Trail)

    A standard Transaction Report includes the following detailed columns:

    Column NameDescription
    Trans. IDA unique system-generated number for every entry.
    Employee ID/NameWho the transaction was for.
    Transaction HeadThe specific category (e.g., Arrears, Loan Recovery).
    ReferenceAny linked document (e.g., Loan ID #102 or Promotion Order #55).
    Debit AmountAmounts deducted from the employee.
    Credit AmountAmounts added to the employee’s pay.
    Entry Date/UserCrucial for Audit: Shows exactly who entered the transaction and when.

    Key Uses for the Transaction Report

    Reconciling Arrears

    If an employee receives a back-dated increment, the Transaction Report will show the “Arrears” as a separate credit entry, making it easy to explain the sudden jump in their pay.

    Auditing Manual Adjustments

    Management uses this report to catch unauthorized changes. If an HR user manually adds a “Special Bonus” to their own profile, it will appear here with their username and a timestamp.

    GL (General Ledger) Mapping

    Finance teams use this report to ensure that every dollar is moving into the correct accounting bucket.

    • Example: Total “Fines” in this report must match the “Other Income” account in the Finance module.

    Export & Sharing

    Because this report contains sensitive audit data:

    • PDF with Watermark: For official board-level reviews.
    • Excel Export: For deep-dive analysis and pivot tables to see “Total Benefits Paid” vs “Total Fines Collected.”
    • Direct Print: Optimized for physical filing in the monthly payroll binder.

    Payroll Module

    The Payroll module is the financial heart of the HRMS. It automates complex salary calculations by integrating data from attendance, leave, and overtime modules to ensure accurate and timely disbursements.

    Process Payroll

    The Process Payroll sub-module is where HR performs the monthly “Run.” It is typically broken down into four key stages:

    Stage 1: Selection & Period Defining

    Before the system starts calculating, you must define the scope of the payroll:
    Payroll Month/Year: Select the specific month (e.g., March 2026).
    Company/Branch: If the organization has multiple locations, you can process them one by one or all at once.
    Employee Filter: You can run payroll for the Entire Company, a specific Department, or even a Single Employee (for mid-month exits).
    Cut-off Dates: Define the attendance cycle (e.g., 26th of last month to 25th of this month).

    Stage 2: Data Synchronization (The Fetch)

    Once the period is selected, the system “fetches” the latest data from other modules:
    Attendance Sync: The system pulls “Total Present Days,” “Lates,” and “Absents” from the Attendance Module.
    Leave Integration: It checks how many “Paid Leaves” vs. “Unpaid Leaves (LWP)” were taken.
    Variable Updates: It pulls any one-time Bonuses or Other Deductions entered for this specific month.

    Stage 3: The Calculation Engine

    When you click “Process,” the system runs a massive mathematical formula for every employee:
    $$\text{Net Pay} = (\text{Basic} + \text{Fixed Allowances} + \text{Arrears} + \text{OT}) – (\text{Tax} + \text{Loan/Adv Installments} + \text{LWP Deductions} + \text{Statutory (PF/EOBI)})$$
    Pro-Rata Logic: If an employee joined on the 15th of the month, the system automatically calculates only 15 days of salary.
    Tax Engine: The system looks at the year-to-date earnings and applies the correct tax slab from the Tax Setup.

    Stage 4: Review & Verification (The Register)

    The system generates a Draft Payroll Register. HR must review this before “Locking” the month.
    Variance Report: A very helpful tool that compares this month’s total payroll cost against last month’s. If there is a huge jump, HR can investigate why (e.g., a large bonus or many new hires).
    Error Log: The system flags employees with missing bank accounts or invalid tax IDs.

    Stage 5: Closing & Locking

    Once the numbers are verified, the HR Manager “Closes” the payroll.
    Effect: Once closed, no further changes can be made to that month’s data.
    Next Step: This triggers the Bank Advice generation and the distribution of Pay Slips to the employees.

    Payroll List

    This section serves as a centralized archive for all financial cycles.
    The Payroll List is the final auditing tool for HR and Finance. It allows you to review every calculation, from the gross salary down to the last cent of deduction, before the money leaves the company’s bank account.

    Grid View & Data Columns

    The list is typically organized in a wide table format, with each row representing an employee.

    Employee Identity: Employee ID, Name, Department, and Designation.
    Attendance Summary: Total Days in Month, Presents, Absents, and Paid Leaves.
    Earnings Breakdown:
    Basic Salary: The fixed base.
    Allowances: Separate columns for House Rent, Medical, Conveyance, etc.
    Overtime (OT): The calculated value of extra hours worked.
    Gross Salary: The total of all earnings before any subtractions.
    Deductions Breakdown:
    Statutory: Income Tax, PF, EOBI, and Social Security.
    Recoveries: Installments for Loans and Advances.
    Penalties: Fines or LWP (Leave Without Pay) deductions.
    Net Payable: The final “Take-home” amount ($Gross – Deductions$).

    Functional Features of the List

    The Payroll List isn’t just a static table; it includes several interactive tools:

    Filtering & Sorting

    Departmental View: View the payroll cost for just the “Sales” or “Production” team.
    High-Earner Sort: Sort by Net Pay to identify top earners or potential calculation errors.

    Status Indicators

    Pending: Payroll calculated but not yet approved.
    Approved/Locked: Finalized and ready for payment.
    Paid: Bank transfer has been executed.

    Discrepancy Alerts

    The system may highlight rows in Red if an employee’s net pay is zero or negative (which can happen if deductions exceed earnings), or if the bank account information is missing.

    Export & Reporting Options

    Since this is the “Source of Truth” for the month, the Payroll List can be exported in various formats:

    Excel/CSV: For further analysis or manual adjustment by the Finance team.
    PDF: For a permanent, non-editable archive of the month’s expenses.
    Bank Format: A specialized export used to create the “Bank Advice” file we discussed earlier.

    Audit Trail & Verification

    The Payroll List keeps a record of:
    Prepared By: The HR Officer who ran the process.
    Verified By: The Finance Manager who audited the numbers.
    Approved By: The Director or CEO who gave the final green light.

    Gratuity/Leave Encashment

    This sub-module manages the calculation and disbursement of long-term benefits. It ensures that the company remains compliant with labor laws and that employees receive their exact dues based on their tenure.

    Gratuity Calculation Management

    Gratuity is a statutory benefit for long-term service. The system automates this complex calculation to avoid manual errors.
    +1
    Service Calculation: The system automatically calculates total service years by comparing the Date of Joining with the Date of Leaving (or the current date).
    Formula Selection: Depending on your setup, the system applies the defined formula:
    Standard Formula: $(\text{Last Drawn Basic Salary} \times \text{Years of Service}) \div 26 \text{ (or 30)}$
    Slab-Based Gratuity: Some organizations use slabs (e.g., 15 days of salary for the first 5 years, 30 days for every year after). The system tracks these transitions automatically.

    Leave Encashment (Encashment Process)

    This allows employees to “sell” their unused paid leaves back to the company. This can happen annually or only at the time of leaving.

    Eligible Leave Types: The system filters for leaves marked as “Encashable” (usually Annual/Earned Leave).
    Encashment Limit: HR can set a maximum limit (e.g., “Only 30 days can be encashed; the rest will expire”).
    Rate Calculation: The system calculates the “Per Day Rate” based on the Gross or Basic salary as per company policy.
    Calculation: $(\text{Salary} \div 30 \text{ days}) \times \text{Unused Leave Balance}$

    The Encashment/Gratuity Entry Form

    When processing these for an individual, the form captures:
    Request Type: Is this a “Final Settlement” or a “Yearly Encashment”?
    Date of Separation: (If applicable) This stops the leave accrual and locks the balance.
    Notice Period Adjustment: If an employee leaves without notice, the system can automatically deduct the “Notice Pay” from the total Gratuity/Leave amount.
    Taxation: Gratuity and Leave Encashment often have different tax rules than regular salary. The system applies the specific tax exemptions allowed by the government.

    Integration with Final Settlement

    Once calculated, these values flow into the Final Settlement (F&F) report:
    Total Earnings: Salary + Gratuity + Leave Encashment.
    Total Deductions: Loans + Advances + Asset Recoveries.
    Net Payable: The final cheque amount.

    Key Reports

    Gratuity Provision Report: Helps Finance see how much money they need to keep aside for future gratuity payments for all active employees.
    Leave Liability Report: Shows the total value of all unused leaves currently held by the workforce.

    Payments Module

    The Payments module is a comprehensive financial ledger used to manage all outgoing funds to employees. It ensures that salaries, loans, and end-of-service benefits are disbursed correctly and that all recoveries are tracked.

    Payroll Payments

    Payment Generation & Modes

    Once the monthly payroll is “Processed” and “Closed,” the system generates a payment list. In this module, you can categorize payments by their delivery method:
    Bank Transfer: The most common method. The system generates a Bank Advice file.
    Cash: For staff without bank accounts or daily wagers.
    Cheque: For specific cases or final settlements.

    Bank Advice Generation

    This is the core feature of the Payment module. Instead of manually typing account numbers into a bank portal, the system does the heavy lifting.
    Bank Selection: Choose the corporate bank account from which the salaries are being paid.
    Format Mapping: The system automatically formats the data (Employee Name, Account Number, IBAN, Amount) to match the specific requirements of your bank (e.g., CSV, Excel, or Fixed-Width Text file).
    Download Advice: Click to generate the file, which is then uploaded directly to the bank’s corporate portal for bulk processing.

    Payment Verification & Disbursement

    Before the final “Pay” command is given, this sub-module provides a summary view:
    Total Net Payable: The sum of all salaries to be paid.
    Payment Status: Tracks which employees have been “Paid” and which are “Pending.
    Voucher Generation: The system can automatically create a Journal Voucher (JV) to post the payment entry into your Finance/Accounting software.

    Pay Slips (Salary Slips)

    The Payment module is usually the trigger for distributing Pay Slips.
    Digital Distribution: Once the payment status is marked as “Paid,” the system can automatically email PDF pay slips to all employees or push them to the Employee Self-Service (ESS) portal.
    Slip Details: Every slip includes a transparent breakdown of:
    Earnings: Basic, House Rent, Medical, Bonus.
    Deductions: Tax, PF, EOBI, Loan Installments.
    Net Pay: The final amount transferred.

    Key Controls & Security

    Payment Locking: Once a payment is marked as “Disbursed,” the payroll for that month is Locked to prevent any further changes or duplicate payments.
    Audit Trail: The system records exactly who authorized the payment and when the bank file was generated.

    Advance Payments

    The Advance Payments sub-module ensures that the company can support employees during emergencies while maintaining strict control over recoveries so that no debt goes uncollected.

    Advance Request & Approval

    This is the entry point for the transaction. It can either be entered by HR or requested by the employee through a Self-Service portal.
    Employee Selection: Identify the staff member requesting the funds.
    Advance Amount: The total sum being paid out.
    Reason for Advance: Documentation for audit purposes (e.g., Medical Emergency, Salary Advance).
    Approval Workflow: Links to the Authorization Level module, where a Manager or Finance Head must “Approve” the request before the cash/transfer is released.

    Recovery Configuration

    This is the “Smart” part of the module. You define how the company gets its money back.

    Recovery Start Date: Usually the upcoming payroll cycle.
    Number of Installments: * Full Recovery: 100% of the advance is deducted from the next salary.
    Partial Recovery: The amount is split (e.g., 50% this month, 50% next month).
    Auto-Deduction Toggle: When set to Yes, the system automatically inserts a deduction line-item in the Monthly Payroll Process.

    Advance Payment Disbursement

    Once approved, the payment is executed.
    Payment Mode: Cash, Cheque, or Bank Transfer.
    Voucher Integration: The system generates a Payment Voucher (PV) to record the outflow of cash from the company’s accounts.
    Linked to Payroll: The system flags this employee’s profile so that the Payroll Engine knows an active debt is pending.

    Monitoring & Reports

    HR and Finance use these views to keep track of the company’s “Receivables”:
    Advance Ledger: A detailed history of every advance taken by an employee over their career.
    Outstanding Advance Report: A list of all employees who currently owe money to the company and their remaining balances.
    Recovery Summary: A monthly report showing how much total “Advance Money” was recovered during the last payroll run.

    Key System Rules

    Limit Check: You can set a rule that an employee cannot take an advance exceeding 50% of their Basic Salary.
    Multiple Advances: The system can be configured to block a new advance if a previous one is still “Unpaid.”
    Resignation Check: If an employee resigns, the Final Settlement module automatically pulls the “Outstanding Advance” amount and deducts it from their final dues.

    Loan Payment

    The Loan Payment sub-module manages the lifecycle of a formal loan from the initial application to the final installment. It ensures that the company’s “Loan Book” is accurate and that deductions are made automatically every month without manual entry.

    Loan Application & Type

    The process starts by defining what kind of loan is being granted.
    Loan Category: (e.g., Provident Fund Loan, Motorbike Loan, Marriage Loan).
    Principal Amount: The total sum being lent to the employee.
    Interest Rate (%): If the company charges interest (e.g., 2% or 5%), the system calculates the “Markup.” If it is an “Interest-Free” loan, this is set to 0.

    Installment & Amortization Schedule

    Once the amount is set, the system creates a “Repayment Plan.”
    Number of Installments: How many months the employee has to pay it back (e.g., 12, 24, or 36 months).
    Monthly Installment (EMI): The system automatically divides the Principal + Interest by the number of months.
    Effective Month: The specific month and year when the first deduction will appear on the pay slip.

    Loan Disbursement

    After approval, the money is moved to the employee.
    Payment Voucher: The system generates a PV to document the outflow.
    Disbursement Mode: Usually via Bank Transfer or Cheque to maintain a paper trail.
    Agreement Tracking: Most systems allow you to upload a scanned copy of the signed Loan Agreement directly to this record.

    Automatic Payroll Recovery

    This is the most critical integration. Every month during the Payroll Run:
    Check for Active Loans: The payroll engine looks for any employee with an “Open” loan.
    Auto-Deduction: It pulls the “Monthly Installment” amount and places it in the Deductions column of the pay slip.
    Balance Update: Once the payroll is finalized, the system subtracts the paid installment from the Remaining Loan Balance.

    Special Actions (Adjustments)

    The system allows HR to handle “Exceptions” during the loan term:
    Loan Rescheduling: If an employee faces a crisis, HR can “Pause” deductions for a month or increase the number of installments to lower the monthly burden.
    Lump Sum Repayment: If an employee receives a bonus and wants to pay off $1,000 of their loan at once, HR can record a manual “Cash Recovery” to reduce the balance.
    Early Settlement: If an employee resigns, the Full & Final Settlement module automatically detects the “Outstanding Loan Balance” and recovers the entire amount from their final dues.

    Key Reports

    Loan Master Register: A birds-eye view of all money lent by the company.
    Monthly Recovery Report: Shows exactly how much loan money was collected in the current month’s payroll.
    Ledger View: An individual statement for the employee showing every payment they have made since the loan started.

    Other Deductions

    This sub-module is the “Catch-all” for any amount that needs to be subtracted from an employee’s pay which isn’t a standard Tax or Loan repayment. These can be Fixed (every month) or Variable (one-time).

    Types of Other Deductions

    Common examples managed in this section include:
    Disciplinary Fines: Deductions for lost assets, broken equipment, or policy violations.
    Asset Recovery: Charges for personal use of company resources (e.g., excess mobile phone bills).
    Voluntary Contributions: Donations to a company charity fund or a staff club.
    Uniform/Tool Charges: Initial costs for equipment provided by the company.
    Short Attendance/Late Arrival: If not handled automatically by the Attendance module, manual “Late Sitting” or “Short Hour” deductions are entered here.

    Entry & Configuration Form

    When adding a deduction, HR defines the “Nature” of the subtraction:

    Deduction Mapping

    Deduction Head: Select the category (e.g., “Phone Recovery” or “Fine”). These heads are linked to the Finance/GL Chart of Accounts.
    Amount Type: * Fixed Amount: A flat dollar value (e.g., $10).
    Percentage (%): A calculation based on Basic or Gross salary.

    Occurrence Rules

    One-Time Deduction: Applies only to the current month’s payroll and then disappears.
    Recurring Deduction: Repeats every month until a specific “End Date” is reached or it is manually stopped (e.g., Monthly Club Fee).

    Reference & Remarks

    Reason/Description: Essential for the employee to see on their pay slip (e.g., “Key replacement fee”).
    Document Upload: Attach proof, such as a disciplinary memo or an over-limit mobile bill.

    System Integration: The Pay Slip View

    Once entered, these amounts flow directly into the Monthly Payroll Process:
    Validation: The system ensures the total deductions do not exceed a legal limit (e.g., you cannot deduct more than 50% of a person’s take-home pay in some regions).
    Pay Slip Transparency: Every “Other Deduction” is listed as a separate line item. This prevents confusion and reduces inquiries to the HR department.
    Accounting (JV): When payroll is closed, the system maps these deductions to the correct Expense or Liability accounts in the General Ledger.

    Bulk Upload Utility

    For large organizations, entering individual fines or canteen deductions is inefficient.
    Excel Import: HR can download a template, fill in the Employee IDs and Deduction Amounts, and upload it to the system.
    Validation: The system checks that the IDs are active before applying the bulk data.

    Gratuity Leave Payments

    These payments represent the company’s final legal and contractual obligations to an employee. Because they involve large sums, the system uses strict formulas based on the Benefits Terms and Conditions we set up earlier.

    Gratuity Payment

    Gratuity is a “Thank You” payment for long-term service. The system calculates this based on the employee’s tenure and last drawn salary.

    Eligibility Check

    Minimum Service: The system checks the Joining Date vs. Separation Date. If the policy requires 5 years and the employee has 4.9 years, the system will flag them as “Ineligible” unless a manual override is used.
    Calculation Formula: Usually: $$\text{Gratuity} = \frac{\text{Last Drawn Basic Salary} \times \text{Years of Service}}{\text{Factor (e.g., 26 or 30 days)}}$$

    System Logic

    Rounding Years: The system can be configured to round up (e.g., 5 years and 7 months becomes 6 years) or use exact days for precision.
    Taxation: Gratuity is often subject to specific tax exemptions. The system applies the relevant tax code before showing the “Net Gratuity.”

    Leave Encashment (Leave Payment)

    If an employee has unused “Annual” or “Earned” leaves at the time of resignation, the company “buys” those leaves back.

    Encashable Balance

    Leave Types: Not all leaves are encashable (e.g., Sick Leaves usually expire). The system looks specifically at the Encashable Toggle in the Leave Type Setup.
    Balance Verification: The system pulls the current “Closing Balance” from the Leave Ledger.

    The Calculation

    Per-Day Rate: The system calculates the daily wage:
    $$\text{Daily Rate} = \frac{\text{Gross/Basic Salary}}{30 \text{ (or 26 working days)}}$$
    Final Amount: $\text{Daily Rate} \times \text{Unused Leaves}$.

    The Final Settlement Workflow

    This is where all the payroll pieces we’ve discussed (Loans, Advances, Gratuity, and Leaves) collide into one final document.
    Earnings (+):
    Last Month’s Salary (Pro-rata days worked).
    Gratuity Amount.
    Leave Encashment.
    Any unpaid Bonuses or Incentives.
     
    Deductions (-):
    Outstanding Loan/Advance Balances (The system pulls these automatically).
    Notice Period Recovery (if the employee left without notice).
    Other Deductions (unreturned laptop, etc.).
    Net Payable: The “Bottom Line” amount the employee receives.

    Disbursement & Closing

    Full & Final (F&F) Statement: The system generates a formal report that the employee signs to acknowledge they have received all dues.
    Status Change: Once the payment is marked “Disbursed,” the system changes the employee’s status from Active to Separated, and they can no longer be included in future payroll runs.
    ESS Access: Usually, the employee’s access to the mobile app or web portal is automatically disabled on their last day.

    How to Use Interactive Grid


    Viewing Records

    When the page loads:

    • All available records appear in tabular format.
    • Scroll vertically to view more records.
    • Use pagination if available.

    Adding a New Record

    • Click Add Row button.
    • A new empty row appears.
    • Enter data in required fields.
    • Click Save.

    If required fields are missing, the system will show a validation message.


     Editing a Record

    • Click inside a cell.
    • Modify the value.
    • Press Tab or click outside the cell.
    • Click Save to commit changes.

    ⚠️ Changes are not stored until you click Save.


    Deleting a Record

    • Select the row using the checkbox.
    • Click Delete button.
    • Click Save to confirm deletion.

    Using the “Actions” Menu

    Click the Actions button to access advanced features.

    Available options may include:

    Filter

    • Click Actions → Filter
    • Choose column
    • Enter condition
    • Click Apply

    Example:

    Status = Approved

    Date > 01-JAN-2026


    Sort

    • Click Actions → Sort
    • Select column
    • Choose Ascending or Descending

    Columns

    • Show or hide specific columns
    • Reorder columns

    Download

    Export data in formats such as:

    • CSV
    • Excel
    • PDF (if enabled)

    Control Break

    Group data based on a column.

    Example:

    Group by Department

    Group by Customer


    Using Search

    Use the Search bar at the top right:

    • Type any keyword
    • Press Enter
    • Grid will show matching records

    Custom Action Buttons (If Available)

    Some applications include additional buttons such as:

    • Approve
    • Reject
    • Submit
    • Process
    • Send Email
    • Generate Invoice

    How to Use:

    • Select a row (if required).
    • Click the action button.
    • Confirm if prompted.
    • System will process the action.

    ⚠️ Some actions may require selecting exactly one row.


    Row-Level Action Buttons

    Some grids include an Action column containing buttons per row.

    Examples:

    • Edit
    • View
    • Delete
    • Print
    • Approve

    Click the button in the respective row to perform the action on that specific record.


    Saving Your Work

    Always remember:

    Changes are temporary until you click Save

    If you leave the page without saving, changes may be lost

    The system may warn you before leaving


    Common Error Messages

    MessageMeaningAction
    Field is requiredRequired field is emptyEnter value
    Invalid numberIncorrect numeric formatEnter correct number
    Record already existsDuplicate entryUse unique value
    No row selectedYou must select a rowSelect checkbox

    Best Practices

    ✔ Always click Save after changes
    ✔ Use filters instead of scrolling large data
    ✔ Verify selected row before clicking Delete
    ✔ Download report before performing mass updates


    Frequently Asked Questions (FAQ)

    They are read-only fields.

    You may not have permission or the record is locked.


    Keyboard Shortcuts (If Enabled)

    • Tab → Move to next field
    • Shift + Tab → Previous field
    • Ctrl + S → Save (if configured)

    Support

    If you experience issues:

    • Contact System Administrator
    • Provide screenshot
    • Mention Page Name and Record ID

    Conclusion

    The Interactive Grid in Oracle APEX provides a powerful and user-friendly way to manage data directly from the browser.

    By understanding:

    Toolbar functions

    Action menu

    Save process

    Row selection Users can efficiently manage their daily operations.

  • Accounting Module: Detailed User Manual

    Setup (System Configuration)

    The Setup card is used to define the “rules” of your financial system. It must be completed before any daily transactions are recorded.

    Foundational Setup Modules

    • Company: Manage and update universal company information.
    • Tax: Define and manage tax types applicable to your region or industry.
    • Pay Terms: Standardize payment terms for clients and vendors (e.g., Net 30).
    • Chart of Accounts (COA): The master list of every account used to record financial transactions.
    • Accounting Period: Define your fiscal year and individual accounting months.
    • Journals: Manage different document types and journal categories for organized bookkeeping.
    • GL Mapping Rules: Configure automated rules that dictate how operational actions (like a sale) post to the General Ledger.

    Transaction Management

    The Transaction card is where your daily bookkeeping occurs. It is divided into three specialized workflows:

    Accounting (General Ledger)

    • Manage opening balances for the fiscal year.
    • Record and manage standard financial vouchers.

    Vendor (Accounts Payable)

    • Manage vendor-specific financial documents including bills and payments.
    • Process vendor debit and credit notes for returns or adjustments.

    Customer (Accounts Receivable)

    • Generate and manage customer invoices and receipt vouchers.
    • Handle customer-side debit/credit notes and delivery note tracking.

    Reporting Engine

    The Reporting section uses a standardized Parameter Form to generate precise financial data.

    How to Generate a Report

    1. Set the Date Range: Select a mandatory From Date and To Date.
    2. Define Filters: Optionally filter by A/C Code, Voucher Number, Department ID, or Employee ID to narrow your results.
    3. Select Report Type: Choose the specific report from the Select Report dropdown (e.g., Invoice, Ledger, or Voucher).
    4. Choose Format: Select your preferred output format (typically PDF).
    5. Execute: Click Preview to view the data or Save Set to remember these specific filter parameters for future use.

    Financial Reports (Management View)

    Use this section to access high-level analytical statements:

    • Trial Balance: Verify that total debits equal total credits.
    • General Ledger: View the complete chronological record of all transactions.
    • Cash Flow: Monitor the actual movement of cash into and out of the business.