Pearl does not calculate the PAYE and NI required for payroll purposes (it’s being developed) - you will need to use another software package or get your accountants to give you the payroll data.
When you receive your payroll statement from your payroll manager, you will have a liability to your staff and the Inland Revenue. Until these balances are settled (when you actually pay your staff or send a cheque to the IR), you have a current liability that needs to show up on your balance sheet.
When the balances are paid, do a bank transfer from current account or cheque account to employee or Inland Revenue. These two stages cancel each other so that you have no liabilities and your Profit and Loss report will show the correct overheads.
There are two steps to entering wages into Pearl : the first is to create the wages journals and the second is to make the payments from your bank account. If you just have time to pay your employees (step 2), then you must use the wage wizard later at some point to update your profit and loss accounts correctly.
It is not enough to simply record the payments made to your staff or the inland revenue from your bank account.
- Enter wages using the wizard
- Open the Wage Wizard
- From your payroll report, copy across the relevant figures. Total debits must equal total credits
- Submit the form
- Bank payment (to employees)
- Open the Bank payment page
- Select your bank account
- Choose code 2200 (Net wages)
- Enter the payment date and amount
- Select tax code T9
- Submit the form
- Bank payment (to HM Customs)
- Open the Bank payment page
- Select your bank account
- Choose code PAYE (2210) or NI (2211)
- Enter the payment date and amount
- Select tax code T9
- Submit the form
- Bank payment (to pension company)
Create another bank payment, to account 2230, tax code T9.
Once you have completed the payroll cycle, ie entered the Wages wizard and then made the payments to your staff and the inland revenue, your Trial Balance should show no value for NI, PAYE or Net wages.
| Payment Summary (Part 1) | |||||||||||
| Employee | Total Gross |
Taxable Gross |
Other Payments |
Tax Credit |
Student Loan |
PAYE | Employee NIC |
Employee Pension |
Statutory Payments |
Other Deductions |
Net Pay |
| 1 | 538.46 | 538.46 | 538.46 | 0.00 | 0.00 | 118.36 | 37.94 | 0.00 | 0.00 | 0.00 | 382.16 |
| 2 | 538.46 | 538.46 | 538.46 | 0.00 | 0.00 | 67.57 | 37.94 | 0.00 | 0.00 | 0.00 | 432.95 |
| 3 | 538.46 | 538.46 | 538.46 | 0.00 | 0.00 | 67.57 | 37.94 | 0.00 | 0.00 | 0.00 | 432.95 |
| 4 | 538.46 | 538.46 | 538.46 | 0.00 | 0.00 | 67.57 | 37.94 | 0.00 | 0.00 | 0.00 | 432.95 |
| 2,153.84 | 2,153.84 | 2,153.84 | 0.00 | 0.00 | 321.07 | 151.76 | 0.00 | 0.00 | 0.00 | 1681.01 | |
| Box 1 | Box 4 | Box 7 (add Box 6) |
Box 3 | ||||||||
| Payment Summary (Part 2) | |||||||||||
| Employee | NI'able earnings |
E'ee + E'er NI contribution |
Employer NI Contribution |
Employee NI Contribution |
Employer NI rebate |
Employee NI rebate |
Employer Pension |
Tax Code |
Week1/ Month1 |
NI Cat |
Con Out |
| 1 | 538.00 | 82.10 | 44.16 | 37.94 | 0.00 | 0.00 | 0.00 | BR | Y | A | N |
| 2 | 538.00 | 82.10 | 44.16 | 37.94 | 0.00 | 0.00 | 0.00 | 484L | Y | A | N |
| 3 | 538.00 | 82.10 | 44.16 | 37.94 | 0.00 | 0.00 | 0.00 | 484L | Y | A | N |
| 4 | 538.00 | 82.10 | 44.16 | 37.94 | 0.00 | 0.00 | 0.00 | 484L | Y | A | N |
| 2,152.00 | 328.40 | 176.64 | 151.76 | 0.00 | 0.00 | 0.00 | |||||
| Box 5 | Box 2 | Box 6 | |||||||||
Interested? Click here for access to the FREE demo