Business
Monthly Payroll Run: Payslips, Bank File & Statutory Summary
Drop in a salary sheet and get the whole month's payroll: a payslip PDF for every employee in a zip, a combined PDF, the bank bulk-transfer CSV, and a register workbook with PF, ESI, professional tax and TDS summaries. Pro-rates by paid days, computes the statutory deductions or takes them from your sheet, and refuses to run if anyone's net pay is negative. Runs in your browser; nothing is uploaded.
Privacy
Your file never leaves your device. It is read and converted by your own browser, so nothing is uploaded, queued or logged — which is what makes this safe for a client’s books.
Tips
- One row per employee. Column names are matched for you — Employee ID, Name, Basic, HRA, Paid Days, PF, TDS and so on — and every match is shown in a dropdown you can correct. Only the employee name is genuinely required; everything else can be blank.
- Any numeric column the mapping did not claim is offered back to you as an extra earning or an extra deduction, so an "Arrears", "Shift allowance" or "Canteen recovery" column prints on the payslip under its own name without any setup.
- Pro-rating applies to Basic, DA, HRA, conveyance and other allowances, at paid days ÷ days in the month. Overtime, incentive and any extra earning column are paid as typed, because those figures are already for the days worked.
- Statutory rates and the professional tax slabs are written in one clearly-marked constant at the top of this file with the date they were last checked. PF is 12%, the employer's 12% splits 8.33% to the pension scheme (on wages up to Rs 15,000) and the rest to EPF, EDLI is 0.5%, ESI is 0.75% and 3.25% on gross wages up to Rs 21,000, and ESI contributions are rounded up to the next rupee. Check all of it against the current rules before you file.
- The run stops, and writes nothing, if anyone's deductions exceed their earnings — those people are named. It warns, but still runs, when paid days plus loss of pay do not add up to the days in the month, or when a bank account or IFSC is missing from someone whose net pay is positive.
- Banks differ on the bulk-transfer format: some want a header row, some a fixed column order, some a debit-account line on top. The CSV here has the five fields every format is built from — account number, IFSC, name, amount and narration — and the register workbook repeats them with a note, so you can reorder for your bank in a minute.
- The rupee sign cannot be drawn with the standard PDF fonts, so the payslips print "Rs". Every bank and auditor reads it the same way.
Frequently asked questions
What does it actually produce from one run?
Four downloads: payslips.zip with one PDF per employee named by employee ID, name and month; payslips-combined.pdf with every slip in order for printing; bank-transfer.csv with the account number, IFSC, beneficiary name, amount and narration; and payroll-register.xlsx with a Register sheet listing every component for every employee, plus PF, ESI, professional tax, TDS and bank-transfer summary sheets whose totals tie back to the slips.
Does it compute PF, ESI and professional tax, or do I supply them?
Either. Leave it on "compute" and PF is 12% of Basic+DA (capped at the Rs 15,000 wage ceiling if you choose), ESI applies while gross wages are Rs 21,000 or less, and professional tax comes from the state you pick. Switch it to "take from the sheet" and your own columns are used untouched — useful when your consultant has already computed them.
Is TDS calculated?
No. Monthly TDS depends on each employee's projected annual income, their regime, their declarations and what has already been deducted this year — none of which is in a salary sheet. Put your computed TDS in a column and it is carried through to the payslip, the register and the TDS summary. The CTC calculator on this site will estimate a year's tax if you need a starting figure.
How many employees can it handle?
It is arithmetic and PDF drawing in your browser, so a few hundred rows is comfortable. Every payslip is one A4 page; a very long list of components will be trimmed to what fits the page and the register workbook still carries everything.
Does the salary sheet leave my device?
No. It is read by your own browser, the PDFs and the workbook are written there, and the downloads come from memory. Nothing is uploaded, queued or logged.