Payroll Management
--
Checking...
WKT Admin
Administrator
WA
Run Payroll
Select period → employees → attendance → generate
Loading...
Run Payroll Wizard
1
Select Period
2
Employees
3
Attendance
4
Incentive & Arrear
5
Salary Advance
6
Short Hours
7
Prof Tax & TDS
8
PLI Deduction
9
Generate Payroll
Payroll Period
Pending Payroll Period
Detecting...
Auto-detected from last completed payroll
Payroll period is auto-detected as the next month after the last completed payroll.
Use Unlock Previous Payroll to edit and re-process an already-generated month.
Employee Management
0 Missing Fields
| # | EMP ID | Name | Division | Designation | Salary | Joining | Status | Actions |
|---|
Attendance -- Leave & Comp-Off Hours
Option A: Download template, fill Leave Days and Comp-Off Hours, then upload.
Option B: Edit Leave / Comp-Off directly in the table below and save row by row.
| # | EMP ID | Employee Name | Leave Deduction (Days) |
Comp-Off (Hours) |
Save | Exclude from Payroll |
|---|
Incentive & Arrear
Auto-calc: (Salary / Days) × Days
| Inc. | EMP ID & Name | Salary | Type | Days | Amount (Rs) | Remarks | Recurring | Add Row |
|---|
Salary / Cash Advance
Salary / Cash Advance
| # | EMP ID | Employee Name | Advance Amt | EMI / Month | Deduction Starts | Status | Action |
|---|
Short Hour / Late Penalty
Enter short working days and penalty amount. Amount auto-calculates from salary.
| # | EMP ID | Employee Name | Salary | Short Days | Deduction Amt (Rs.) | Remarks | Save |
|---|
Prof Tax & TDS Configuration
Prof Tax = Rs.200 per employee. Toggle exempt to skip. TDS can be % of gross or fixed amount. EPF and ESIC exemptions are remembered for future months.
| EMP ID | Employee Name | Prof Tax Exempt | Exempt From (Month/Year) | TDS Type | TDS Value | EPF Exempt | ESIC Exempt | Force ESIC | Save |
|---|
PLI Deduction & Release
PLI deduction = Rs.2,000 / month for employees who joined on or after 01-Feb-2025.
Deduction stops once cumulative total reaches Rs.24,000.
Toggle Exclude to permanently skip an employee — this is remembered for all future months.
| # | EMP ID | Employee Name | Joining Date | Cumulative PLI Deducted | Remaining Capacity | This Month Deduction | Max Reached | Exclude Permanently | Reason (optional) |
|---|---|---|---|---|---|---|---|---|---|
| Loading... | |||||||||
PLI Release I: After 12 installments (Rs.24,000 total), release 50% = Rs.12,000 in the following month.
PLI Release II: Remaining 50% is released 12 months after Release I.
If an employee's balance is already settled, no further PLI release will be suggested.
Released amounts appear as negative in payroll (e.g. −12,000).
Use Manual Release checkbox to release any employee early, or add employees below using the search.
Showing 0 employees
| # | EMP ID | Employee Name | First Deduction | Total Deducted | Already Released | Release I After 12 installments |
Release II After 12M of Release I |
To Release This Month |
Balance | Release No. |
Release Amount (Rs.) |
Include in Payroll |
Reason (optional) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Click Refresh to load release data. | |||||||||||||
Add Manual Release for Any Employee
Payroll
| S.No | EMP ID | EMPLOYEE NAME | SALARY | DIVISION | DESIGNATION | NET SALARY |
NO. OF LEAVE & SHORT HRS |
LEAVE DEDUCTION |
WORKING DAYS |
BASIC | DA | HRA | MEDICAL ALLOWANCE |
CONVEYANCE ALLOWANCE |
OVER TIME HOURS |
OVERTIME AMOUNT |
INCENTIVE & ARREAR |
GROSS SALARY |
EPF SALARY |
SALARY ADVANCE / CASH |
PROF TAX |
TDS | ESIC DEDUCTION |
EPF DEDUCTION |
SHORT HR DEDUCTION |
PLI DEDUCTION |
TOTAL DEDUCTION |
SALARY CASH IN HAND |
REMARKS | SLIP |
|---|
Employee Master
Payroll History
Loading...
Employees
--
Total Gross
--
Total Deductions
--
Net Pay
--
Total EPF
--
Total TDS
--
OT Amount
--
Select month(s) and year, then click Load Data.
Welcome back, WKT Admin
Last updated: --
Total Employees
--
On payroll
Monthly Payroll
--
Gross (latest run)
Missing Fields
--
Click to review & fix
Compliance Health
--
Employee data completeness
Upcoming Payroll Run
-- Payroll Cycle
Next scheduled run
Division Headcount
Quick Actions
0 Missing Fields
Compliance Alerts
0No compliance issues found
Payroll Analytics
Historical data - Select period belowRecords
--
Total Gross
--
Deductions
--
Net Pay
--
EPF
--
TDS
--
Overtime
--
Incentive
--
Select month(s) above and click Apply to load payroll analytics
Attendance Management
Track daily attendance, overtime & leave deductions
Total Active
--
Employees on roll
Present Today
0
Present today
Absent Today
0
Absent today
On Leave Today
0
On leave today
Overtime Count
0
Overtime days this month
Welcome to the Attendance Management System
This module allows you to track and manage daily attendance, leaves, and overtime. Use the sub-tabs above to access different features:
- Dashboard: View today's attendance summary and general stats.
- Register / Daily Grid: Upload Excel attendance sheets, download dynamic templates, and view/edit daily attendance codes inline.
- Attendance Codes: Manage configured abbreviations (P, AB, CL, SL, VHF, etc.) for attendance logging.
- Employee Details: Look up a specific employee's attendance record, summary days, and exact dates of leaves.
- Monthly Summary: Access month-wise consolidated report showing employee summaries, attendance %, and export to Excel or PDF.
Monthly Attendance Register (Daily Grid)
| Click Load to view attendance grid |
Attendance Codes & Abbreviations
| Abbreviation | Description | Counts As Category | Half Day? | Multiplier | Deducts Salary? (Unpaid) | Actions |
|---|
Attendance Categories
| Category Key / Code | Category Name / Label | Actions |
|---|
Employee Attendance Breakdown
January
February
March
April
May
June
July
August
September
October
November
December
--
ID: -- | Designation | Division
Selected Period
June 2026
Dates Breakdown by Category
Search for an employee name or code to display their detailed attendance logs and leave dates.
Consolidated Monthly Attendance Report
| # | Emp ID | Employee Name | Present | Absent | Casual Leave | Sick Leave | Vacation | Comp Off | Overtime Days | Attendance % |
|---|---|---|---|---|---|---|---|---|---|---|
| Click Refresh to load summary data | ||||||||||
| # | EMP ID | Employee Name | Comp Off Earned | Comp off Availed | Comp-Off Paid | Balance |
|---|
Employee: --
Earned: 0
Availed: 0
Paid: 0
Balance: 0
Date-Wise Comp-Off Logs (FIFO Trace)
| Date | Type | Days | Details / FIFO Adjustment |
|---|
Enter an employee ID/name and click search to view their complete date-wise FIFO timeline.
Leave Management
Track leave balances, approvals & leave policies
Casual Leave (CL)
12/yr
8
4 used - 0 pending
Sick Leave (SL)
10/yr
9
1 used - 0 pending
Earned Leave (EL)
18/yr
15
3 used - 0 pending
Maternity Leave
26 wks
26
0 used - 0 pending
Leave Requests
| # | EMP ID | Employee Name | Leave Type | From | To | Days | Reason | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|
| No leave requests found. Employees can apply via the Apply Leave button. | |||||||||
Leave Policy Configuration
| Leave Type | Code | Annual Quota | Accrual | Carry Forward | Applicable To | Actions |
|---|---|---|---|---|---|---|
| Casual Leave | CL | 12 days | Monthly | No | All | |
| Sick Leave | SL | 10 days | Yearly | Up to 5 days | All | |
| Earned Leave | EL | 18 days | Monthly | Up to 30 days | All | |
| Maternity Leave | ML | 26 weeks | Once | No | Female |
Reimbursements
Manage expense claims and approval workflows
Pending Claims
0
Awaiting approval
Approved This Month
0
Total value: 0
Rejected
0
This month
Total Paid Out
0
This financial year
Expense Claims
| # | Claim ID | Employee | Category | Claim Date | Amount | Description | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| No reimbursement claims found. Click + New Claim to submit one. | ||||||||
Loans & Advances
Manage salary advances, loans & EMI recovery schedules
Active Advances
--
Open records
Total Outstanding
--
Principal balance
EMI Due This Month
--
Across all employees
Closed This Year
--
Fully recovered
Advance / Loan Records
| # | Advance ID | EMP ID | Employee Name | Advance Date | Amount | EMI / Month | Deduction Start | Total Inst. | Paid Inst. | Pending Inst. | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading advances... Click Refresh if this persists. | ||||||||||||
Statutory Compliance (India)
EPF - ESI - Professional Tax - TDS & other statutory filings
Upcoming Filing Deadlines
April 2026TDS Deposit (Form 26QB)
Due: 7th April 2026 - Q4 advance tax
EPF Challan (EPFO)
Due: 15th April 2026 - March 2026 contribution
ESI Contribution
Due: 21st April 2026 - March 2026 wages
Professional Tax Return
Due: 30th April 2026 - Q4 return
EPF (Employee Provident Fund)
Section 80C benefit
Employee Rate12% of Basic
Employer Rate13.61% of Basic
Wage Ceiling15,000/month
This month contribution
--
ESI (Employee State Insurance)
Wage limit: 21,000/month
Employee Rate0.75% of Gross
Employer Rate3.25% of Gross
Eligible Employees--
This month contribution
--
Professional Tax
State-level deduction
Standard Deduction200/month
Annual Cap2,500/year
Exempt Employees--
This month PT collected
--
TDS (Tax Deducted at Source)
Section 192 - Salary TDS
New Regime RatePer slab (FY26)
Old Regime RatePer slab with deductions
TDS-applicable Employees--
This month TDS
--
Payroll Reports
Select a period and click Load Reports
Loading report data...
No Payroll Data
No payroll data available for the selected period.
Total Employees
0
Total Gross
0
Total Deductions
0
Cash In Hand
0
0 validation warnings
Payroll Summary
Payroll Details
Preview all payroll records first, then download from inside this panel.
Employee-wise Salary Register
Bank Transfer Workspace
Manage editable bank-upload rows, hold payments, and export in bank format.
Loading bank transfer workspace...
Total Rows
0
Export Rows
0
Export Amount
Rs.0
Held Amount
Rs.0
Held Payments To Review
Payroll rows stay synced with current payroll cash in hand. Only held, manual, or carried rows can change the bank-transfer total.
EPF ECR
Manage payroll-ready ECR rows, uploaded return PDFs, and future reconciliation from one workspace.
EPF ECR Workspace
Review EPF rows, remove employees from this export, and fill Father Name / UAN before download.
EPF Rows
0
Missing Father Name
0
Missing UAN
0
EPF Wages
Rs.0
Father Name and UAN are pulled from Employee Master. If missing, a warning sign appears and you can update the values here before downloading.
ECR Return
Upload EPFO return PDFs, review all saved months, and keep the PF return dataset inside Payroll.
Total EE Contribution
Rs.0
Members
0
EPF Wages
Rs.0
Visible Months
0
This view uses the same saved PF return dataset as the standalone PF tool, but keeps the layout aligned with Payroll.
PDF Processing Issues
EPF Reconciliation
Compare salary PF deductions with saved ECR Return EE contributions month by month or across all months.
Visible Months
0
EE Contribution
Rs.0
PF Deduction
Rs.0
Difference
Rs.0
Recon uses saved ECR Return data from the database. If you uploaded fresh PDFs, save them first in ECR Return so they are included here.
Employee-wise Reconciliation
Salary PF deductions are compared against EE contribution from ECR Return for the selected month scope.
Earnings Breakdown
Deduction Analysis
Statutory Compliance Reports
Payroll Analytics
Salary Entry
Journal-style debit and credit view for the loaded payroll month.
Quick Export Sheets
Payroll Details
Preview complete payroll with all components
PREVIEW
Bank Transfer
Editable bank upload with holds and dual export
XLSX / XLS
EPF ECR File
Review rows first, then download from inside
PREVIEW
ESIC Report
Employee & employer contribution
XLSX
TDS Summary
Tax deducted at source
XLSX
Prof Tax Challan
State-wise professional tax
XLSX
PLI Management
Track PLI Deductions, Releases and Employee Balances
Total PLI Deducted
0
Total PLI Released
0
Net PLI Balance
0
Employees Involved
0
Average PLI Per Employee
0
Monthly PLI details
| Month | Employees Count | PLI Deducted | PLI Released | Net Movement | Closing Balance |
|---|
Employee PLI Ledger
| Employee Code | Employee Name | Division | Department | Month | PLI Deducted | PLI Released | Running Balance |
|---|
PLI Distribution Summary
Overview Metrics
Total PLI Deducted0
Total PLI Released0
Current Outstanding PLI0
Employees Covered
Employees with PLI Data0
Active Employee Pool0
PLI Coverage Ratio0%
Department Wise PLI
| Department | Deducted | Released | Balance |
|---|
Division Wise PLI
| Division | Deducted | Released | Balance |
|---|
Designation Wise PLI
| Designation | Deducted | Released | Balance |
|---|
PLI Analytics Charts
Monthly Deduction Trend
Monthly Release Trend
Net PLI Trend (Deducted vs Released)
Department Wise PLI Balance
Top 10 Employees by Deduction
Top 10 Employees by Release
Outstanding PLI Balance List
Employees with a positive outstanding PLI balance (Deductions > Releases)
| Employee Code | Employee Name | Department | Total Deducted | Total Released | Outstanding Balance |
|---|---|---|---|---|---|
| Grand Total | 0 | 0 | 0 | ||
Export Performance Linked Incentive (PLI) Reports
Monthly PLI Report
Month-wise summary of PLI deductions, releases and closing balances.
XLSX
PDF
CSV
Employee PLI Ledger
Transaction-level ledger details per employee, containing cumulative balances.
XLSX
PDF
CSV
Outstanding PLI Report
Active employees with remaining positive outstanding balances.
XLSX
PDF
CSV
Annual PLI Report
Year-wise overview of total deducted, released, and net movements.
XLSX
PDF
CSV
Department Wise Report
Summarized balances and transaction aggregates categorized by Department.
XLSX
PDF
CSV
Division Wise Report
Summarized balances and transaction aggregates categorized by Division.
XLSX
PDF
CSV
Select Export Format
Documents
Store and manage employee & company documents
Categories
Payslip - March 2026
All Employees - Generated 1 Apr 2026
EPF ECR - March 2026
Compliance - Generated 1 Apr 2026
TDS Certificate - Q3 FY26
Compliance / TDS - 15 Jan 2026
Uploaded documents are stored securely. Payslips are auto-generated when you run payroll.
Settings
Configure company profile, salary structure & system preferences
Company Information
Salary Structure & Components
Configure how salary components are split. Changes affect future payroll runs only.
Basic Salary
As % of CTC
%
HRA
% of Basic
%
DA (Dearness Allowance)
% of Basic
%
Medical Allowance
%
Deduction settings applied automatically each payroll cycle.
Professional Tax
Monthly deduction amount
EPF - Employee
% of EPF wage
%
EPF - Employer + Admin
%
ESI Wage Ceiling
Leave Policy
Leave Year Start
Calendar year or April-March
Leave encashment on exit
Pay out unused earned leave
Auto-carry forward EL
Carry unused EL to next year (max cap applies)
Negative leave allowed
Allow employees to go into negative leave balance
Payroll Settings
Payroll run day
Day of month payroll is processed
of month
Salary credit day
Day salary is credited to bank
of next month
Lock payroll after generation
Prevent changes after payroll is finalized
Auto-send payslips via email
Email payslips to employees after generation
Superbase Cloud Database
Engine: Local PostgreSQLConfigure Supabase keys, generate production schema DDL, test live cloud connectivity, and migrate all data seamlessly.
Active Engine
Local PostgreSQL
localhost:5432 / wkt_salary
Supabase Cloud Ping
Not Tested
Latency / Handshake
Schema Tables
29 Tables
Schema: wkt_salary
Local Data Records
57,302
Supabase: 0 rows
Supabase Project Keys & Connection
Provide your Supabase project credentials. You can either paste your Supabase PostgreSQL connection string or enter individual credentials.
From Supabase Dashboard: Project Settings → Database → Connection String → URI (Use port 5432 direct or 6543 pooler)
Your Supabase project endpoint URL
Used for client-side / anon REST queries
Used for privileged admin tasks (never exposed to public)
Direct PostgreSQL Database Credentials
e.g. db.projectref.supabase.co
5432 (direct) or 6543 (pooler)
Usually 'postgres'
Default is 'postgres'
Password set when creating Supabase project
Supabase enforces SSL encryption
Query to Create All Related Tables at Superbase
Production-ready DDL query for
wkt_salary schema, 29 tables, unique indexes, and lookup seed data.
Loading SQL Schema Query...
Move Data to Superbase
Fast batch transfer from your Local PostgreSQL database to Supabase Cloud with automatic timestamp cleansing and verification.
Migration Progress
Ready
Live Migration Terminal
[Ready] Superbase migration engine initialized. Click "Start Migration" to begin data transfer.
Table Row Verification (29 Tables)
| # | Table Name | Local Rows | Supabase Rows | Sync Status | Action |
|---|---|---|---|---|---|
| Loading table statuses... | |||||
Active Database Engine Selector
Choose which database engine powers the WKT Payroll system. When switched, all dashboard KPIs, employee records, attendance, and payroll runs will execute against the selected engine.
Local PostgreSQL
Host: localhost:5432 • DB: postgres
Direct on-premises database stored on your local workstation. Fast local access, does not require internet connection.
Superbase Cloud
Host: db.[ref].supabase.co
High-availability managed PostgreSQL on Supabase Cloud. Accessible anywhere, automatic backups, and real-time support.
Database Backup & Restore
Engine: Active DBKeep full multi-sheet Excel backups of all payroll records, restore to local or cloud database, and synchronize between environments.
Active DB
Current Data Source
29 / 29
Tables Protected
--
Active DB Records
--
Local Workstation Records
Master Multi-Sheet Excel Backup
Format: .xlsx (Excel Workbook)
Generates a single Master Excel workbook with all 29 database tables organized as separate tabs (Employee Master, Salary, Payroll Records, PLI, Attendance, Bank Transfers, etc.).
Universal backup format, easy to inspect in Excel, and ready to restore anytime.
Modular ZIP Archive of Excels
Format: .zip (Contains 29 individual .xlsx files)
Exports each table into its own individual .xlsx file bundled inside a single zip archive with an automated manifest.json verification file.
Best for modular backups or extracting single tables for individual departmental use.
Protected Tables Matrix (29 Tables)
Live status and record counts across all schema tables.
| # | Table Name | Category | Active DB Rows | Local DB Rows | Status |
|---|---|---|---|---|---|
| Loading table statistics... | |||||
Restore Database from Backup File
Upload your Master Excel (.xlsx) or Backup Archive (.zip) to restore data.
Click to choose or drag & drop backup file (.xlsx or .zip)
Supports Master Excel (.xlsx) and ZIP archives
Analyzing file...
| Sheet / Table Name | Match Status | Rows Detected |
|---|
// Ready to restore. Upload a backup file above to analyze.
Local Workstation Database Settings
Connect to your on-premises PostgreSQL database when running the app locally on your workstation.
Direct Cloud to Local Sync
Supabase Cloud → Local Workstation
Copies all current live payroll data from your Supabase Cloud database directly into your Local Workstation PostgreSQL with a single click.
- Copies all 29 tables seamlessly.
- Safely updates employee records, attendance, PLI, and salary data.
- No need to manually download and upload files.
Understanding Backup & Restore Modes
Answers to common questions about keeping your payroll data safe, restoring backups, and how updates work.
MODE A
Upsert / Update Mode (Incremental)
Will it replace my entire database? NO.
- Matches each record by its Unique ID or Primary Key (e.g.,
emp_id,id,row_key). - Updates existing records with the latest details found in the Excel backup file.
- Inserts new records that did not exist before.
- Preserves all existing data: Records in the database that are not mentioned in the backup file remain completely untouched!
- Best For: Daily/monthly sync, merging salary adjustments, or importing attendance sheets without losing other records.
MODE B
Full Replace / Overwrite Mode
Will it replace my entire database? YES.
- Cleans / truncates the target database tables.
- Inserts the exact snapshot from your Excel backup file.
- Resynchronizes sequence counters and IDs.
- Creates an exact, identical duplicate of the backup file state.
- Best For: Disaster recovery, resetting to a clean state, or setting up a brand new workstation clone.
Recommended Workflow for Daily Operations:
Step 1: Regular Excel Backups
After finalizing payroll each month, click "Download Master Excel Backup" and store the .xlsx file in your company drive or folder.
Step 2: Sync to Local Workstation
Use the "Direct Sync Cloud → Local" button under Tab 3 while running locally to keep your workstation's PostgreSQL database identical to the cloud.
Step 3: Safe Restores
If you need to restore or roll back, choose "Upsert / Update Mode" to safely merge changes without risking data loss.