Payroll Template

Run monthly payroll per employee: earnings, overtime, PF, professional tax and TDS roll up to net pay and year-to-date totals.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Employees, Payslips

Fields

26

Views

grid, calendar, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Employees

10 fields · 3 sample rows

  • Employees (Grid)
EmployeeTextEmployee IDAutonumberDesignationTextDepartmentSingle selectMonthly basicCurrencyPANTextBank accountTextPayslipsLink to another tableYTD grossRollupYTD netRollup
Aditi KulkarniEMP-0001Senior Backend EngineerEngineering₹90,000ABCPK1234FHDFC ••• 4521Oct 2026 · Aditi, Nov 2026 · Aditi₹3,02,000₹2,61,000
Farhan QureshiEMP-0002Operations LeadOperations₹60,000AQRPQ5678KICICI ••• 7788Oct 2026 · Farhan, Nov 2026 · Farhan₹2,04,300₹1,85,900
Shreya RaoEMP-0003Support SpecialistSupport₹28,000BRSPR9012LSBI ••• 1290Oct 2026 · Shreya, Nov 2026 · Shreya₹93,900₹89,900
Field details
Employee · Text
Employee ID · Autonumber
Designation · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Monthly basic · Currency
INR
PAN · Text
Bank account · Text
Payslips · Link to another table
Links to Payslips
YTD gross · Rollup
sum of Gross pay via Payslips
YTD net · Rollup
sum of Net pay via Payslips

Payslips

16 fields · 6 sample rows

  • Payroll register (Grid)
  • Unpaid (Grid)
  • Pay days (Calendar)
  • Payroll cost (Dashboard)
PayslipTextEmployeeLink to another tablePay periodSingle selectBasicCurrencyHRAFormulaSpecial allowanceCurrencyOvertime hoursNumberOvertime rateCurrencyGross payFormulaPF (12%)FormulaProfessional taxCurrencyTDSCurrencyTotal deductionsFormulaNet payFormulaPayment dateDatePaidCheckbox
Oct 2026 · AditiAditi KulkarniOct 2026₹90,000₹36,000₹25,000₹1,51,000₹1,800₹200₹18,500₹20,500₹1,30,5004 Nov 2026Yes
Oct 2026 · FarhanFarhan QureshiOct 2026₹60,000₹24,000₹15,0006.0₹700₹1,03,200₹1,800₹200₹7,200₹9,200₹94,0004 Nov 2026Yes
Oct 2026 · ShreyaShreya RaoOct 2026₹28,000₹11,200₹6,00010.0₹350₹48,700₹1,800₹200₹0₹2,000₹46,7004 Nov 2026Yes
Nov 2026 · AditiAditi KulkarniNov 2026₹90,000₹36,000₹25,000₹1,51,000₹1,800₹200₹18,500₹20,500₹1,30,5004 Dec 2026
Nov 2026 · FarhanFarhan QureshiNov 2026₹60,000₹24,000₹15,0003.0₹700₹1,01,100₹1,800₹200₹7,200₹9,200₹91,9004 Dec 2026
Nov 2026 · ShreyaShreya RaoNov 2026₹28,000₹11,200₹6,000₹45,200₹1,800₹200₹0₹2,000₹43,2004 Dec 2026
Field details
Payslip · Text
Employee · Link to another table
Links to Employees
Pay period · Single select
Sep 2026, Oct 2026, Nov 2026
Basic · Currency
INR
HRA · Formula
ROUND({Basic} * 0.4, 0)
Special allowance · Currency
INR
Overtime hours · Number
Overtime rate · Currency
INR
Gross pay · Formula
{Basic} + {HRA} + {Special allowance} + ROUND({Overtime hours} * {Overtime rate}, 0)
PF (12%) · Formula
MIN(ROUND({Basic} * 0.12, 0), 1800)
Professional tax · Currency
INR
TDS · Currency
INR
Total deductions · Formula
{PF (12%)} + {Professional tax} + {TDS}
Net pay · Formula
{Gross pay} - {Total deductions}
Payment date · Date
Paid · Checkbox

Payroll Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates