How to Make Salary Slips from an Excel Salary Register

In most government offices, autonomous bodies, schools and many private organisations in Pakistan, salaries are worked out once a month in an Excel salary register: one row per employee, one column per allowance and deduction, and totals at the bottom. The register is accurate and complete — but employees do not want a spreadsheet. They want their own salary slip showing what they earned, what was deducted and what reached their account.

Making those slips by hand — copying figures from the register into a Word template for every employee — is slow and error-prone. This guide explains how to lay out the register so slips can be produced automatically, what to check before issuing them, and how to deliver them in bulk.

What a salary slip must show

A good salary slip is a simple, one-page document that an employee can file, show to a bank or landlord, or use when filing a tax return. It should include:

the organisation’s name and logo, and the month and year;
the employee’s name, designation, pay scale (for example BPS-17) and office or department;
where available, their CNIC and the bank account the salary was paid into;
every pay item and allowance with its amount, and the gross total;
every deduction with its amount, and the total deductions;
the net amount paid — in figures and in words;
the signature or name of the officer issuing it.

If you work in the public sector, our guide to reading a government pay slip explains what each allowance and deduction means.

How to lay out the salary register

Software that turns a register into slips reads the column headings to work out what each column contains. A few simple rules make this reliable:

One heading row

Put all column headings in a single row above the employee data — for example S.No, Name, Designation, BPS, Basic Pay, House Rent Allowance … Total, GPF, Income Tax … Total Deductions, Net Payable. Title rows above it (organisation name, “Salary register for the month of …”) are fine.

Name every column

Never leave a heading cell blank, even for columns that look obvious such as CNIC or account number. A column without a heading cannot be recognised, and its data will be ignored. This is the most common reason a register “does not read properly”.

Keep amounts as numbers

Amount cells should contain numbers, not text. Watch for amounts typed with spaces, the letters “Rs”, or a stray apostrophe that turns the cell into text. Leave a cell empty (or zero) when an allowance does not apply, rather than typing a dash.

Keep the totals

Keep the Total, Total Deductions and Net Payable columns. They are not just for reading — they allow every row to be checked automatically, which is how mistakes are caught before slips are issued.

Format CNICs and account numbers as text

Excel likes to turn long numbers into scientific notation (for example 4.22E+12) or drop leading zeros. Format CNIC and bank account columns as Text before typing or pasting into them, and write CNICs in the usual 00000-0000000-0 form.

Office or department sections

If the register is divided into sections by office, with a sub-total after each, that is fine — keep the section heading in its own row. Slips can then show each employee’s office and be grouped by office when saved.

Check the register before issuing slips

A slip is only as good as the register behind it. Before issuing, check every row:

Pay adds up: the pay and allowance columns should add up to the Total.
Deductions add up: deduction columns should add up to Total Deductions.
Net is right: Total minus Total Deductions should equal Net Payable.
Sub-totals match: office sub-totals and the grand total should equal the sum of their rows.
Pay scales are valid: every BPS should be a real scale, and percentage allowances should match the rate for that scale.
Rounding: registers often contain decimals from percentage calculations. Slips show whole rupees, so differences of a rupee can appear — check that they are only rounding.

Doing these checks by hand for a hundred employees takes hours. Doing them automatically takes seconds, and it is the main reason to use a tool rather than copy-paste.

Producing the slips

There are three common ways to turn a register into slips:

Copy-paste into a Word template. Works for a handful of employees, but is slow and easy to get wrong — one figure pasted into the wrong row is enough.
Mail merge from Excel to Word. Faster, but fiddly to set up, and allowances that apply to some employees but not others make the template complicated. It does not check the totals.
A dedicated payslip tool. Reads the register, checks every row, and produces a formatted slip per employee in one go.

Delivering slips to employees

Once slips are ready, you can:

Print a combined PDF with one slip per A4 page and hand them out.
Save one PDF per employee, named with their name and month, in a ZIP — handy for archiving or sharing department by department.
Email each employee their own slip. If you do, send each slip only to that employee, use your organisation’s own email account, and keep a log of what was sent to whom.

Salary data is sensitive. A salary register holds names, CNICs, bank accounts and pay of every employee. Avoid uploading it to websites that store files on their servers, never share the register itself in WhatsApp groups, and keep old registers out of shared folders and code repositories.

A free tool that does this in your browser

We built PaySlip Maker for exactly this job. You open your Excel register (.xls or .xlsx) in the page; it recognises columns by their headings, checks every row against the register’s totals, and produces an A4 slip for each employee — with allowances on the correct BPS line, net pay in words, your own logos, header and signatory. You can download one PDF per employee in a ZIP, one combined PDF for printing, or email slips one by one through your own mail server. The register is read inside your browser and is never uploaded.

Common questions

Our register has extra columns that are not on the slip. Is that a problem?

Usually not. Columns are recognised by their headings; columns that are not pay, deduction or employee details are ignored. Just make sure they have a heading.

Can the slip show the amount in words in lakh and crore?

Yes — Pakistani-style wording (thousand, lakh, crore) is common on slips, and a good tool lets you choose it over the international style (thousand, million).

How should slips be signed?

Most offices print the name and designation of the issuing officer (for example the accounts officer) at the bottom. Some add a scanned signature; if you do, keep the image file secure.

Quick summary: one heading row, every column named, amounts as numbers, totals kept, CNICs and accounts as text. Check every row adds up before issuing, then print, ZIP or email — and keep the register itself private.