Skip to main content

NominaSoft Documentation

Complete PostgreSQL-based payroll management system designed for Colombian labor law compliance. Calculate employee wages, deductions, and benefits with precision.

Get StartedDatabase Schema
Colombian labor law compliance
Automated payroll calculation
Flexible payment periods
Complete employee management

Quick Start

Get NominaSoft up and running in minutes with these simple steps.

1

Set up the database

Execute the main schema creation script to initialize all tables and relationships.
script_nomina.sql
-- Run the complete schema setup
psql -U your_username -d your_database -f script_nomina.sql
2

Configure system parameters

Insert your company parameters including minimum wage, transport subsidy, and payroll period.
SELECT fun_insert_pmtros(
  'YOUR_COMPANY_NAME',
  'Q',        -- Payment period: 'Q' for biweekly, 'M' for monthly
  1423500,    -- Current minimum wage (SMLV)
  200000,     -- Transport subsidy value
  2,          -- Multiplier for transport subsidy eligibility
  2025,       -- Current year
  1,          -- Current month
  12,         -- Interest percentage for severance
  30          -- Days per fiscal month
);
3

Add your first employee

Create an employee record with all required information.
SELECT fun_insert_emplea(
  'Juan',           -- First name
  'Pérez',          -- Last name
  FALSE,            -- Gender: FALSE = Male, TRUE = Female
  'Calle 123 #45-67', -- Address
  3001234567,       -- Phone number
  3,                -- Socioeconomic stratum (1-6)
  0,                -- Marital status: 0=Single, 1=Married, 2=Divorced, 3=Widowed, 4=Other
  0,                -- Number of children
  'O+',             -- Blood type
  30,               -- Age
  1,                -- Position ID (must exist in tab_cargos)
  2500000,          -- Basic salary
  '2025-01-15'      -- Hire date
);
4

Calculate payroll

Run the payroll calculation function for the current period.
-- Calculate payroll for year 2025, month 1, period 1
SELECT fun_act_nomina(2025, 1, 1);
The function will process all employees and generate payroll records including:
  • Basic salary calculation (prorated by days worked)
  • Transport subsidy (if applicable based on salary)
  • Mandatory deductions (EPS, AFP)
  • Net payment amount
Results are stored in tab_nomina table for reporting.

Explore the System

Discover the core components of NominaSoft’s payroll management platform.

Database Schema

Explore the complete data model including employees, concepts, and payroll records.

Payroll Calculation

Learn how the automated payroll engine calculates earnings and deductions.

Function Reference

Browse all available stored procedures for CRUD operations and processing.

Employee Management

Master the complete employee lifecycle from hiring to payroll processing.

Key Features

Built specifically for Colombian payroll compliance with powerful automation.

Colombian Labor Law Compliance

Built-in support for mandatory concepts including EPS (health), AFP (pension), and transport subsidy calculations based on current regulations.

Flexible Payment Periods

Support for both biweekly (quincenal) and monthly (mensual) payment periods with automatic prorating of salary and benefits.

Overtime & Bonuses

Track overtime hours (diurnal, nocturnal, holiday) and bonuses through the novelties system with configurable percentage rates.

Robust Error Handling

Comprehensive error management using PostgreSQL SQLSTATE codes with descriptive messages for debugging and compliance.

Ready to streamline your payroll?

Start processing accurate, compliant payroll in minutes with NominaSoft’s powerful PostgreSQL-based system.

Get Started Now