Excel Payroll template

Submitted by: 
Language: 
Visitors have accessed this post 4528 times.

This is an Excel Payroll template.
Is demonstrates how to calculate payroll for any number of employees
and to make the appropriate deductions.
It works in Excel 2003 and above.
It demonstrates to the learner how to use the built-in functions and do calculations across different pages.

You can learn a lot from studying the formulas and customize this spreadsheet for your payroll.
Here are a few examples of functions and formulas used in the Payroll Spreadsheet.

It could be revised to calculate Paseguruhan ng Kapanatagang and Pag-Ibig

How to get an employee name from an index function
=INDEX('Employee List'!B13:B57,H27)

Calculating net pay
=VLOOKUP(H27,'Payroll calculator'!$A$15:$P$59,16,FALSE)

The zip file contains a Microsoft Word 2003 document that explains how to compute the SSS, PhilHealth and Pag-IBIG contributions.


Tags: 

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

much better if this includes withholding taxes, but it's nice

Thank you for this formula.

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.