# Staff salary sheet format and a simple salary slip

> A staff salary sheet format and a simple salary slip, as tables with invented figures, with net pay worked out, and how SellyPOS records pay and commission.

**Short answer:** A staff salary sheet format is a monthly table with one row for each person: the basic pay, allowances, commission, deductions, advances and the net pay. A salary slip is the same figures for one person on one page. This page gives both as tables you can copy and says how SellyPOS records pay.

Source: https://sellypos.com/blog/staff-salary-sheet-format-and-salary-slip/
Updated: 2026-11-04

Pay day goes wrong when the figures live in several notebooks. A staff salary sheet format puts every person's pay on one page, so the total can be checked before any money leaves the till. Below you will find a monthly sheet, a slip for one person, a worked example with invented figures, and a note on what SellyPOS records.

## What columns does a staff salary sheet need?

A staff salary sheet needs one row for each person. The columns are the basic pay, any allowance, any commission, the amount deducted for absence, any advance taken in the month, and the net pay. Add a total row at the bottom, so the sheet can be checked against the money paid out.

| Staff member | Basic pay | Allowance | Commission | Absence deduction | Advance | Net pay |
|---|---|---|---|---|---|---|
| Staff A | 20,000 | 2,000 | 1,500 | 1,000 | 3,000 | 19,500 |
| Staff B | 15,000 | 1,000 | 0 | 0 | 0 | 16,000 |
| Staff C | 18,000 | 0 | 500 | 2,000 | 1,000 | 15,500 |
| Total | 53,000 | 3,000 | 2,000 | 3,000 | 4,000 | 51,000 |

## How do you work out net pay?

Net pay is the basic pay, plus any allowance and commission, minus any deduction and advance. Work it out in that order for each person, then add the net column to check the total. Use the same rule every month, so each figure can be traced back to its own line.

For example, Staff A has a basic pay of 20,000 and an allowance of 2,000, which come to 22,000. Adding the commission of 1,500 makes 23,500. Taking off the absence deduction of 1,000 and the advance of 3,000 leaves a net pay of 19,500, the figure in the sheet.

Decide which deductions apply with each person, and write the rule down before you set a formula.

## What goes on a simple salary slip?

A simple salary slip shows one person's pay for one month on one page: the pay parts, the deductions, any advance and the net pay. Give the person the slip, and keep a copy with the sheet. Both copies should show the same figures.

For Staff C, for November, the slip reads as follows:

| Item | Amount |
|---|---|
| Basic pay | 18,000 |
| Commission | 500 |
| Gross pay | 18,500 |
| Absence deduction | 2,000 |
| Advance taken | 1,000 |
| Net pay | 15,500 |

## Can SellyPOS print a payslip?

Printing a payslip is not built in SellyPOS, so the slip above is one you make on paper. The Pay page lists who is owed what, and each person's statement lists their advances, payslips and payments, so the paper copy can be checked against them.

## Where SellyPOS stands

Staff pay, commission and final pay are in Professional only. They are not in Lite or Basic.

- **Each person's pay setup, with its history.** A staff member's Pay setup tab sets how they are paid, from which date, their weekly off, standard day and shift start. Changes are made from a date, and the tab keeps the pay history. Professional.
- **Pay one person, or everyone.** The Pay page lists who is owed what. Pay one person up to a date, or pay everyone, and a sentence says what will leave which account. Printing a payslip, and named fixed monthly additions and deductions, are not built. Professional.
- **A statement with the balance after each line.** The Statement tab lists each advance, payslip and payment for a person, with the balance after each line. It also shows what they have earned since the last payslip. Printing a statement is not built. Professional.
- **Commission paid on a payslip.** Commission on recent sales is held back for a set number of days. A Commission view shows the date each commission is held until and what is payable now, with a Make payslip action. Professional.
- **Final pay when a staff member leaves.** Archive pays what is owed to a paid person in one step, then archives them with their last day. Archive is refused while the shop still owes the person. Professional.

The setup of each person is covered in [how to add a staff member and choose what they can do](/help/staff/add-a-staff-member-and-choose-what-they-can-do/). The sales each person made are in [see what each person sold](/help/staff/see-what-each-person-sold/). The pay tools are on the [staff and permissions module](/features/staff-and-permissions/) and on the [staff attendance, pay and commission page](/features/staff-attendance-pay-and-commission-software/).

## Next

Read [how to calculate sales commission for shop staff](/blog/how-to-calculate-sales-commission-for-shop-staff/) before you set a commission rate. See [the salesperson commission page](/features/salesperson-commission/) for how SellyPOS holds and pays it. Compare the editions on the [pricing page](/pricing/), or [download SellyPOS](/download/).
