Business & Operations
HR & People Analytics in Excel
BeginnerCertificate$9.99
Payroll Accounting & Bookkeeping
Run a full monthly payroll for 8 employees: gross pay, deductions, employer costs, the payroll register, journal entries, payments, accruals and the reconciliation, every cell checked live.
- One-time payment
- 14-day money-back guarantee
- Secure checkout with Stripe
What you'll build
What you will be able to do
Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.
- Work out May's gross pay for all 8 employees of Harbor Lane Studio Ltd.: monthly salaries, hourly wages, overtime at a premium and sales commission.
- Take May's gross pay from lab 1 to net pay: pre-tax pension, income tax withholding on taxable pay and employee social contributions.
- Calculate the employer's own contributions on top of gross pay, including a pension ceiling, and show the total employer cost per employee in a stacked column chart.
- Total the May payroll register for all 8 employees, cross-foot every row and flag the one row that does not add up.
- Post May's payroll register to the ledger: gross salaries, the withheld liabilities, the employer contributions and the net pay transfer.
- Work out the due date, pay the three payroll liabilities in June and prove that the cash paid for May equals the total employer cost.
- Accrue the hourly wages earned after the last pay run, calculate the holiday pay liability for all 8 employees and book the month-end accruals.
- Reconcile the May payroll register with the general ledger and with the bank transfers, flag every difference and count what needs investigating.
About this course
Payroll touches cash, liabilities and expenses every month, so small errors spread quickly. This course follows one payroll cycle through to the ledger. You calculate gross pay for salaried, hourly, overtime and commission staff, then apply deductions for pension, withholding and social contributions to reach net pay. Employer on-costs show the full cost of an employee. A payroll register is totalled and cross-footed with error flags, and you post journal entries for expense, liabilities and cash. Separate labs settle amounts owed to the tax office, social fund and pension fund, accrue unpaid wages and holiday pay at month end and reconcile register, ledger and bank. Generic illustrative rates; not tax advice.
Curriculum
Course content
8 lessons · 8 labs · 2.1 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
Certificate
Finish with a certificate you can verify
Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.
- Names the course, your score and the date of issue
- A verification link for your CV or LinkedIn profile
- 12 questions, 75% to pass, unlimited retries.
A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.
Before you buy
Questions about this course
Is this a subscription?
No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.
What exactly do I get?
All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.
Can I get a refund?
Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.
When can I start?
Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.
Do I need Excel or other software?
No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.
Is the certificate an official qualification?
No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.
Full details are in our Terms · hello@tutorvo.com