Description
Turn your monthly payroll totals by department into a balanced journal entry: salary and pension expense, net pay to the WPS bank file, deductions recovered and pension payable.
- Automatic summary: Dr Salaries & wages expense, Dr Employer pension expense, Cr Net salaries payable (WPS), Cr Employee advances & loans recovered, Cr Other deductions payable, Cr Pension payable (employee + employer), Check: debits − credits (should be 0)
- Calculated for you: Gross pay, Net pay, Total employer cost
- Drop-down menus for quick, consistent entry
- Built-in chart that updates as you type
- Example rows and a step-by-step "How to Use" sheet
Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.
Payment & Security
Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.