Description
A comprehensive HR and payroll ERP solution built on Google Sheets—covering everything from employee records, salary structures, and attendance to leave management, loans, tax calculations, and a streamlined payroll process that generates payslips with a single click. This system features six distinct roles, an employee self-service portal, and a robust configuration layer that allows for modifications without touching the code.
The Column Manager
This distinctive feature elevates it beyond a mere template. If your organization needs an additional field in the employee record, you no longer have to dive into the Apps Script editor where errors can occur. Simply access Settings, select Column Manager, choose the relevant module, name the new field, assign its type—be it text, number, date, dropdown, yes/no, or long text—indicate if it’s mandatory, whether it’s visible in the table, and specify which of the six roles can access it. Save your changes, and the column is instantly active in both the sheet and the interface.
Payroll That Adapts to Real Rules
Salary structures are built from pay heads that can be fixed amounts or percentage overrides, one-time or recurring, with clearly defined effective-from and effective-to dates. Underpinning this are the rules you set up yourself: income tax slabs with tiers, rates, and regulatory frameworks; exemption guidelines; provident fund regulations; overtime parameters including multipliers and calculation bases; leave policies; and shift definitions with grace minutes and half-day hours. Process any period, and every payslip is generated, ready for A4 printing. Once finalized, periods are locked, and payroll tools conduct a pre-commit audit to calculate any arrears before you finalize.
Highlights
– A 360-degree employee profile encompassing salary, payslips, leave balances and history, attendance, loans, claims, documents, and tax settings in a comprehensive view.
– Management of loans and salary advances detailing principal, installments, and outstanding balance.
– A streamlined reimbursement claim process with an approvals queue that includes comments on each decision to approve or reject.
– Detailed leave balances by type indicating opening, earned, taken, and remaining leave, in addition to a holiday calendar.
– Gratuity accrual, full and final settlements, and a bank salary transfer file.
– Payroll vouchers that can post and approve, and are immutable once completed.
– Extensive reporting capabilities for salary statements, payroll registers, PF returns, tax and TDS, full and final settlements, and leave summaries.
– CSV import functionality that filters out duplicates, retaining only unique entries.
Who It’s For
Ideal for companies with fifty to several hundred employees that have outgrown their traditional payroll spreadsheets but prefer to avoid a monthly SaaS fee per employee, while ensuring that tax and leave regulations align with their own policies rather than default settings from a vendor.