Salary sheet software free download

14.09.2021 By Shannon Genao

salary sheet software free download

Salary Sheet With Attendance Template is a ready-to-use in Excel, Google Sheets, and Open Office Calcpayroll sheet to maintain records of attendance and calculate the salaries of 40 employees. Salary Sheet Excel Template is a payroll document in which you can record payroll xheet for multiple employees along sxlary Salary slip. Basic Salary is fix amount that an employer pays in addition to allowances and subtraction of any deductions. It does not include bonuses, overtime, dearness allowance, etc. Basic Salary is proportionate to the working days. Allowances are the financial benefits an employer provides above the Basic Salary to his employees.
  • 17+ Free Payroll Software Download for Windows, Mac, Android | DownloadCloud
  • How to use the Monthly Payroll template
  • 4+ Salary Sheet Templates in PDF | Free & Premium Templates
  • 100,000+ Ready-Made Designs, Docs & Templates to Start, Run and Grow your Business
  • Then comes the Salary Calculations. In this section, you need to enter the CTC amount of the employee and it will automatically calculate the salary as per the given formula. If you have different calculations you can either change the formulas or you can directly enter the amounts as required. Fgee Gross Salary and Deductions will display the total and finally the take-home amount that sortware the Net Payable Salary.

    Furthermore, you can provide additional information to be displayed in Salary slips at the end like gender, prefix, PF applicability, medical, signatory, etc. The consolidation sheet will display the salxry payroll that you have entered in the database sheet. This sheet is only for approval from higher authorities.

    Just the replica of your payroll calculations with the approval section. Payslips or Salary slips are an important part of the Payroll process. Salary slip consists of all earnings fixed and variable and deductions fixed and variable along with the mandatory deductions.

    Download Salary Sheet With Attendance Register In Single Excel Template. Salary Sheet With Attendance Template is a ready-to-use in Excel, Google Sheets, and Open Office Calcpayroll sheet to maintain records of attendance and calculate the salaries of 40 employees. Table of giai-mong.coted Reading Time: 8 mins. Sep 09,  · Below we have added different salary sheet templates that anyone can use to make and print free salary sheets on desktop computer. All business organizations and companies can use these following salary sheet templates for free. Download Free . Marg ERP offers best payroll software for her management system to manage large employee data, attendance management, & fast payroll processing, etc. Download free payroll software for trial or book free Demo @+91 /5.

    On the right-hand side just select the name of the desired employee and it will automatically display the detail of doftware employee. Vlookup has been used here to fetch data from the database sheet. Once you are done with that just click on the Print button to print the Salary Slip of your employees. The downoad slip will be displayed as shown below:.

    Enjoy using this simple template to manage the attendance and prepare the salary. We have tried our best to avoid any mistakes in calculations. If you find any just let softawre know so that it can be rectified. In addition to the above, if you want another salary slip formats you can check out the below article:.

    If you have any queries please share in the comment section below. I will be more than happy to assist you. Usually, an employee can take salray sick leave in a calendar as per the shops and establishment act. An employee has a minimum annual leave of three times his working days.

    For example, if an employee works 6 days a week he is entitled to annual leave of salarj days each year. Leave encashment regulations are different from company to company. Generally, the amount is calculated on Basic Pay. Divide the monthly Basic day to per day basic amount and then multiply it by the number of paid days to be encashed.

    sumHR. Details. Rating: /5. Price: Free. Download. This software created by sumHR is a web-based payroll and HR management solution that can be used by growing companies to aggregate employee data, track leaves, monitor attendance and much more effectively. Salary sheet templates in Excel don’t anymore need formats to be given. It’s done in the format you want it to be. It’s done in the format you want it to be. + FREE SHEET Templates - Download Now Adobe PDF, Microsoft Word (DOC), Microsoft Excel (XLS), Adobe Photoshop (PSD), Google Docs, Adobe InDesign (INDD & IDML), Apple (MAC) Pages, Microsoft Publisher, Adobe Illustrator (AI), Apple . May 15,  · Download. Description: Payroll processing excel utility is payroll software developed for salary processing of employees. This article will explain about how to use Payroll processing excel utility. Following are the key features of this utility. Process Monthly salary up to employees. Maintain Employee Masters, Salary Masters, Tax Masters for salary giai-mong.coted Reading Time: 30 secs.

    In general, full-time employees are entitled to 3 days of leave for marriage. Salaru is only applicable for the first legal free dowjload mandatory to take within the first six months from the date of marriage. According to the Minimum Wages Act, for an adult worker, the working shest must be set in such a way that it should not exceed 12 hours inclusive of 1-hour of rest.

    According to the Minimum Wages Act, divide the sheet rate by 26 to calculate per day salary that is for 8 hours. Furthermore, divide it by 8 to calculate the per hour salary. Multiply it with 2 or 1. The minimum notice period as per the law is one week for every year worked. The rule for notice is one pay period.

    Thus, frre week if the employee is paid weekly and one month if paid monthly. Skip to primary navigation Skip to main content Skip to primary sidebar. Table of Contents. How many sick leaves can an employee avail in a month? How to calculate annual leave as per Indian Labour Law? How to calculate leave pay? How many days of leave can be availed for marriage in India?

    How many hours an employer can make an employee work continuously? How to calculate OT Pay? What is the rule of notice period? What type of deductions can an shet make your salary? An employer can deduct free following: Company fines as per the company rules and regulations. Pay for leave of absence.

    Deduction against damage or loss of goods entrusted. House Rent in case the accommodation is provided by the company. Deduction against additional amenities and service provided by the employer or contract. Deduction for recovery of advances and interest, and adjustment of overpayment; Recovery of loans lent by the company. Income tax deduction in the form of TDS.

    Deduction against orders of a court or other legal authority. Repayment of advance from PF. Payments to outer cooperative societies if it is agreed between the employer and the employee. LIC premium against authorization by the employee. Post Office Saving Schemes against authorization.

    I have worked in Excel and like to share functional excel templates at ExcelDataPro. This website uses free to sheey your experience. We'll assume you're ok with this, but you sqlary opt-out if you wish. Note: Softward tables and sheet on the Setup sheet need to be customized based on your requirements if necessary before you start including data on the Payroll sheet.

    Salary the first pay period has download paid, you can still add new items to the lists but you should not change any of the rates that are included on software Setup sheet. If you do change any of the rates, frfe will also affect past pay periods which would then create differences between the payroll calculations and download amounts that have been paid for the elapsed months.

    If any of the rates on the Setup sheet need to be amended during the tax year, you need to use the Override feature to affect the salray changes. An earnings code needs to be created for each type of earning which is paid to employees. These earnings codes need to be added to the Earnings list on the Setup sheet.

    The earnings list includes 5 user input fields - the following information is required in each of these fields for each software of earning: Code - you need to enter a softwaare for each type of earning.

    salary sheet software free download

    We highly recommend sticking to the default template convention of using a single letter to represent each type of earning. Once you have linked an earning to a specific letter and you have entered data on the Payroll sheet, you should not change the letter. Description - enter a description for each earning.

    The earning description will be included on all employee pay slips. Short Name - enter a short name for the earning. The short name should not be more than 15 characters in length and is used as a column heading above the earnings columns that are included on the other sheets in the template. Use a short name that will make it easy to identify the type of earning that it refers to.

    Basis - downlowd whether the earning is payable on a monthly, quarterly, bi-annual or annual basis. This selection is important especially for income tax calculation purposes. If no value is selected, the earning basis will be deemed downliad be monthly. The earnings list does not include any earnings values or calculation basis selections.

    This is because monthly earnings values need to be entered or copied into the Earnings columns on the Payroll sheet. Monthly earnings values per employee are therefore subject to user input and not automatically calculated.

    17+ Free Payroll Software Download for Windows, Mac, Android | DownloadCloud

    The default earnings list includes 10 earnings codes. You can customize this list by replacing the default earnings data with your own. The sequence in which earning types are included in the list is important because free same sequence is used on the other sheets in this template.

    If user input values are entered in the earnings columns on one of the other sheets as required on the Payroll sheet and you change the sequence of earning types, the user input values will not align to the correct earning types and the earnings calculations will in all probability become inaccurate. We therefore do not recommend that you change the sequence of earnings after you have entered data on the Payroll sheet.

    New earning codes can however still be added to the end of the list. The default list includes 10 items which can be customized by replacing the default template data with your own. If you require less than 10 earnings codes, you can delete the rows that are not required. If you require more than 10 earnings codes, additional earnings codes can be added to the list by inserting the required number of new rows above the "End of list" entry and entering the required information into each user input field.

    Note: If you add more entries to the list than the default number of entries, you also need to manually insert additional columns or rows on some of the other sheets in this template. A salary deduction code needs to be created for each type of salary deduction which will be deducted from employee salaries.

    These salary deduction codes need to be added to the Salary Deductions list on the Setup sheet. The salary deductions list includes 10 user input fields - the following information is required in each of these fields for each type of salary deduction: Code - enter a code for each salary deduction and use a unique code which will make it easy to identify the appropriate salary deduction and to distinguish between the different types of salary deductions.

    The salary deduction codes are included above the column headings of all the sections on other sheets in this template where salary deductions are included. Description - enter a description for each salary deduction. The descriptions that are entered in this part of the salary deductions list are included on the monthly salary pay slips on the PaySlip sheet and on the Recon sheet.

    Rate - enter the rate that needs to be used in the salary deduction calculation. The rate can be a value or percentage depending on the basis on which the deduction is calculated. Basis - enter the basis on which the salary deduction needs to be calculated. There are three options - gross, fixed or linking the salary deduction to the earnings code of the appropriate single earning type on which the salary needs to be based.

    If nothing is entered in this field, the salary deduction will be calculated based on gross income. Fringe Inclusion - select the basis for including fringe benefits in the salary deduction calculation. There are 3 options - full value if the full value of all fringe benefits need to be included, taxable if the taxable value of all fringe benefits need to be included and none if software fringe benefits should be added in the salary deduction calculation.

    The default option is none which results in no fringe benefits being added in the salary deduction calculations. Earnings Inclusion - select the basis for including earnings in the salary deduction calculation. There are 2 options - full value if the full value of all download need to salary included and taxable if only the taxable value of earnings need to be included in the salary deduction calculation.

    The default option is full value which results in the full value of all the appropriate earning types being included in the salary deduction calculations. Earn Exclusion - enter the earnings sheet of all earnings types which need to be excluded from the salary software calculation.

    The appropriate sheet of the earnings codes need to be included in this section without any spaces or special characters in between. Earnings Max - if there is an annual ceiling maximum value which needs to be applied in the salary deduction calculation, this annual maximum earnings free needs to be entered in this field.

    All the values that are entered in this field therefore needs to be annual equivalents. The gross income which is used in the salary deduction calculation will then be limited to this amount. If no percentage is specified, the salary deduction is assumed not to be deductible for income tax purposes.

    Annual Tax Limit - if the tax deductibility of the salary deduction is limited to a maximum annual limit ceiling valuethis maximum value needs to be entered in download field. If no value if entered, no limit is set for the tax deduction value. For example, pension fund contributions may be limited to sayper annum and this value therefore needs to be included for the pension fund salary deduction.

    The default salary deductions list includes 10 codes.

    salary sheet software free download

    You can customize this list by replacing the default data with your own. The free in which salary deductions are included in the list is important because the same sequence is used on the other sheets in this template. If user input values are entered in the Salary Deduction columns on one of the other sheets as required on the Emp sheet and you change the sequence of salary deductions, the user free values will not align to the correct salary deduction and the salary deduction calculations will in all probability become inaccurate.

    We therefore do not recommend that you change the sequence of salary deductions after you have entered data on the Emp sheet. New salary deduction codes can however still be added to the end of the list. Sheet salary deduction rates that are specified on the Setup sheet relate to the business as a whole and are not employee specific.

    These rates can however be overridden by the deduction rates that are specified on the Emp sheet in the section from column P onwards. We therefore suggest that the rates that you include for each deduction in the Rate input field of the Salary Deductions List are rates that are applicable to most of your employees. Where some employees are subject to a different rate of deduction, these rates can then be added for the specific employees on the Emp sheet and will replace the business rates that are specified on the Setup sheet.

    The type of rate that you specify on either the Setup or Emp sheet is also largely dependent on the basis that sheet specify in the next user input download. If the basis salary "Gross", the rate would typically be a percentage which needs to be entered as a decimal value in the Rate user input field for example 0.

    If the basis is "Fixed", the rate would typically be an amount - for example a rate of If an earnings code has been entered as the basis for a salary deduction, the rate that needs to be specified is usually a percentage of the appropriate earning. The template has been designed with such flexibility that it is even possible to base a salary deduction on only say two or three earnings codes - simply select the "Gross" basis in order to base the salary deduction calculation on gross income total of all earnings codes and then exclude all but the required sheet codes in the Earn Exclusion input field column I.

    Example: If we want to base a salary deduction calculation only on the basic salary earnings code A and leave pay earnings code C of employees, we can exclude all other earnings codes in column I. Example: The unemployment insurance fund UIF salary deduction calculation needs to exclude commissions. If the earnings code for commissions is "B", this letter needs to be included software the Earn Exclusion and the basis set to "Gross".

    The commission amounts that are included in gross income are then deducted when calculating the value of the salary deduction. Some salary deductions may not require the full values of earnings to be included in the calculation of the appropriate salary deduction. We have therefore added functionality to the template in order to include the taxable values of earnings instead of the full values for tax calculation purposes.

    You can use taxable values of earnings instead of full values by selecting the "Taxable" option for the affected salary deductions in the Earn Inclusion input field column H. Note that this setting will be applied to all earnings if the "Gross" basis is selected and to the individual earning if an earning code has been specified as the basis.

    Even though the taxable value setting is applied to all earnings, it salary not affect all earning codes. Setting the Earn Inclusion field to "Taxable" therefore only affects earnings which are not fully taxable. The template also makes provision for the inclusion of fringe benefits in salary deduction calculations.

    You can either elect to include the full value or the taxable value of fringe benefits for calculation purposes by selecting the "Full Value" or "Taxable" option from the Fringe Inclusion input field column G. If fringe benefits should not be included in the calculation, the "None" option can be selected software is also the default option for fringe benefit inclusion.

    Example: If some employees have company cars and only the taxable value of this fringe benefit should be included in the UIF salary deduction calculation, the "Taxable" option needs to be selected in the Fringe Inclusion field for the UIF salary deduction. If you require less than 10 salary deduction codes, you can delete the rows that are not required.

    If you require more than 10 salary deduction codes, additional codes can be download to the list by inserting the required number of new rows above the "End of list" entry and entering the required information into each user input field. A company contribution code needs to be created for each type of company contribution which the employer contributes on behalf of employees.

    These company download codes need to be added free the Company Contributions List on the Setup sheet. The company contribution List includes 8 user input salary - the following information is required in each of these fields for each type of company contribution: Software - enter a code for each company contribution and use a unique code which will make it easy to identify the appropriate company contribution and to distinguish between the different types of company contributions.

    The company contribution codes are included above the column headings of all the sections on other sheets in this template where company contributions are included. Description - enter a description for each company contribution. The descriptions that are entered in this part of the company contributions list are included on the Recon sheet.

    Rate - enter the rate that needs to be used in the company contribution calculation. The rate can be a value or percentage depending on the basis on which the contribution is calculated. Basis - enter the basis on which the company contribution needs to be calculated. There are three options - gross, fixed or linking the company contribution to the salary deduction code of the appropriate single salary deduction on which the company contribution calculation needs to be based.

    If nothing is entered in this field, the company contribution will be calculated based on gross income.

    How to use the Monthly Payroll template

    Fringe Inclusion - select the basis for including fringe benefits in free company contribution calculation. There are 3 options - full value if the full value of all sheet benefits needs to be included, taxable salary the taxable value of all fringe benefits needs to be software and none if no fringe benefits should be added in the company contribution calculation.

    The default option is none which results in no fringe benefits being added in the company contribution calculations. Earnings Inclusion - select the basis for including earnings in the company contribution calculation. There are 2 options - full value if the full value of all earnings need to be included and taxable if only the taxable value of earnings need to be included in the company contribution calculation.

    The default option is full value which results in the full value of all the appropriate earning types being included in the company contribution calculations. Earn Exclusion - enter the earnings codes of all earnings types which need to be excluded from the company contribution calculations.

    Earnings Max - if there is an annual ceiling maximum value which needs to be applied in the company contribution calculation, this annual maximum earnings value needs to be entered in this field. The gross income which is used in download company contribution calculation will then be limited to this amount. The default company contribution list includes 5 company contribution codes.

    You can customize this list by replacing the default data in the template with your own data.

    Download Salary Sheet Excel Template - ExcelDataPro

    The company contribution rates that are specified on the Setup sheet relate to the business as a whole and are not employee specific. Where the contribution rates only need to xownload applied to specific employees, you will need to link the company contribution basis to the appropriate salary deduction code in order to use the salary deduction rates which have been specified on an employee level on the Emp sheet.

    The company contribution rate which is entered for the particular contribution can be used to sheet the salary deduction rates sxlary the Emp sheet. If the contribution rates and salary deduction rates are not a consistent percentage, the Override feature needs to be used in order to apply the correct company contribution values for the affected employees.

    Refer to the Override section of the instructions for more guidance on this feature. The type of rate that you specify on the Setup sheet is rownload dependent softwafe the basis that you specify in the next user input field. If a salary deduction code has been entered soctware the basis for a company contribution, the rate that needs to be specified is usually a percentage of the appropriate salary deduction.

    The template has been designed with such flexibility that downlooad is even possible to base a company contribution on only say one, two or three earnings codes - simply select the "Gross" basis in order to base the company contribution calculation on gross income total of all earnings codes and then exclude all but sheet required earnings codes in the Earn Exclusion input field column I.

    Example: If we want to base a company contribution calculation only on the basic salary earnings code A of employees, we can exclude all other earnings codes in column I. Salary entry in the Earn Exclusion softwars field would salaru be "BCDEFGHIJ" and would result in the company contribution only being calculated on earnings code A download in our default template data is for basic salary only.

    Example: The unemployment insurance fund UIF company downooad calculation needs to exclude commissions. The commission amounts that are included in gross income are then deducted when calculating the value of the company contribution. Some company contributions may not require the full values of earnings to be included in the calculation of the appropriate company contribution.

    You can use taxable values of earnings instead of full values by selecting the "Taxable" free for the affected company contributions in the Earn Inclusion input field column H. Note that this setting will be applied to all earnings if the "Gross" basis is selected excluded downoad will however be deducted.

    Even though the taxable value setting is applied to all earnings, it may not affect all earnings codes. The template cownload makes provision for the salagy of fringe benefits in company contribution calculations. You can either elect to include the full value or the taxable value of fringe benefits for company contribution calculation purposes by downlad the "Full Value" or "Taxable" option from the Fringe Inclusion input field column G.

    Tree If some employees software company cars and only the taxable value of this fringe free should be included in the UIF company contribution calculation, the "Taxable" option needs to be selected in the Fringe Inclusion field for the UIF company contribution. Example: If a company contribution has been linked to a salary deduction, it is not necessary to specify values for any of the other user software settings aside from free rate and basis.

    If we link our company contribution for UIF to the salary deduction for UIF, we do not need to enter anything in the fringe inclusion, earn inclusion, earn exclusion and earnings max input fields. The default list includes 5 items which can be customized by replacing the default download data with your own.

    Sheeet you require less than 5 company contribution codes, you can delete the rows that are not required. If you require more than 5 company contribution codes, additional codes can be added to the list by inserting the required number of new rows above the "End of list" entry and entering the required information sxlary each user input field.

    A fringe benefit code needs to be created for each type of fringe salary that the company offers. These fringe benefit codes need to be added to the Fringe Benefits List on the Setup sheet. The Fringe Benefit List includes 5 user input fields - the following information is required in each of these fields: Code - enter a code for each fringe benefit and use a unique code which will make it easy to identify the appropriate fringe benefit and to distinguish between the different types of ftee benefits.

    The fringe benefit codes are included above the column headings of all the sections on other sheets where fringe benefits are included. Description - enter a description for each fringe benefit. The descriptions that are entered in this part of saary fringe benefits list are salar on the monthly salary pay slips on the PaySlip sheet.

    Rate - enter the rate that needs to be used in the fringe benefit calculation. The fringe benefit calculation consists of the rate which is usually a percentage that is entered in this free and a value which needs to be entered on the Emp sheet for all the participating employees. Basis - enter the basis on which the fringe benefit needs to be calculated.

    There are two options - value or linking the fringe benefit to the company contribution code of the appropriate single company contribution on which the fringe benefit calculation needs to be based. If nothing is entered in this field, the fringe benefit sheet be calculated based on the value option.

    The default fringe benefit list includes 5 codes. The sequence in which fringe benefits are included in the list download important because the same sequence is used on the other sheets in this template. If user input values are entered in the Fringe Benefit columns on one of the other sheets as required on the Emp sheet and you change the sequence of fringe benefits, the user input values will not align to the correct fringe benefit and the fringe benefit calculations will in all probability become inaccurate.

    We therefore do salayr recommend that you change the sequence of fringe benefits salary you have entered data on the Emp sheet. New fringe benefit codes can however still be added to the end of the list. The fringe benefit rates that are specified on the Software sheet relate to the business as a whole and are not employee specific but the fringe benefit calculation consists of a rate and value portion which means that if no value is specified for a particular employee on the Emp sheet, no fringe benefit is calculated.

    This is different from how salary deductions are calculated - salary deduction values on the Emp sheet effectively override the rates on frfe Setup sheet. With fringe benefits, there is no override because both the rate on the Setup sheet and the value on the Emp sheet is used in the calculations.

    As we pointed out doqnload sheet Basis input field, you have the option of calculating fringe benefits based on a value per employee multiplied by the rate on the Setup software or by linking the fringe benefit calculation to a company contribution calculation by entering the company contribution code in the Basis input field.

    If no basis is entered, the value option will be used. Example: If the monthly company car contribution fringe benefit needs to be calculated based on a monthly rate of say 3. Example: If the company contributes to employees' medical salarry payments which is a fringe benefitthe fringe benefit code can be linked to the company contribution by entering the company contribution code for medical aid in the Basis column.

    The salary deductions and company contributions lists contain a user input field for fringe benefit inclusion. If fringe benefit values need to be included in the calculation of a particular salary deduction salqry company contribution, the "Full Value" or "Taxable" options need to be selected in these user input fields.

    If you require less than 5 fringe benefit codes, you can delete the rows that are not required. If you require more than 5 fringe downloas codes, additional codes can be added to the list by inserting the required number of new rows above the "End of list" entry and entering the required information download each user input field.

    Employees can be linked softwarw departments in order to calculate departmental salary costs shewt can be used to allocate payroll sheet for accounting purposes. The department code is linked to individual employees in column C on the Emp sheet and only the department codes which have been included in the Departments list on the Setup sheet will be available for selection.

    The following information is required in the department list: Code shedt enter a unique code for each department which will make it easy to downloav the appropriate department and to distinguish between different departments. Description - enter a description for each department. Cost Centre - enter the general ledger code which should be used for allocation of costs to departments.

    Note: The sfotware template only includes 3 departments but you can add additional departments by inserting the required number of rows above the "End of list" row and adding a department code, description and cost centre for each of the new departments. Note: A summary of payroll dwonload by department is included on the MonthDept sheet.

    4+ Salary Sheet Templates in PDF | Free & Premium Templates

    All the calculations that are included on this sheet are automated and the only user input which download required on this sheet is selecting the appropriate payroll cost measurement at the top of the sheet. If rows or freee need to be added on any of the other sheets, the Status column in the matrix will be highlighted in xoftware.

    If all the cells in the Status column are highlighted in green, it means that there are no inconsistencies and no additional rows or columns need to be added to the other sheets in the template. Note: If you do not add additional items to the lists on the Setup sheet, all the cells in the Status fre will automatically contain green highlighting and saoary do not need to pay any further attention to the matrix.

    The matrix therefore only needs to be used if you add additional list items. None of the lists on the Setup sheet are limited to the default number of entries which means that you can add fref many additional items as required. When you add items to a list, you need to insert the required number of rows one per additional list item above the "End of list" entry and complete the user input in all the columns that form part of the list for all the new items.

    If the total number of list items are more than the number of default items that are provided for, the matrix at the bottom of the Setup sheet will indicate where on the other salary in this template new rows or columns need to be inserted. The starting row or column indicates in which row or column the section starts and the difference between the sheet count and the list count indicates how many new rows or columns need to be inserted.

    You then need to go to the appropriate sheet and section and insert the required number of rows or columns in order to resolve the inconsistency. Note that if there are row or column inconsistencies, the template calculations may be inaccurate and it is therefore imperative software all of these errors are resolved!

    If any of the status cells in the matrix is highlighted in red, the start row or column text will indicate whether rows or columns need to be inserted in order to resolve the error. If the text contains letters, columns need to be inserted and if the text contains numbers, rows need to be inserted. The column or row number sjeet indicates where on the appropriate sheet the section starts.

    If you need to insert columns, you need to go to the starting column of the appropriate section and select the first dark blue cell in the column heading at the end of the section. The section starts at the indicated column which will have a dark blue cell as the column heading followed by a number of light salaey column headings which are then followed by a dark blue column sheet.

    You therefore need to select the first column heading cell with a dark blue column heading at the end of the appropriate section and then insert the required number of columns. After you have inserted the required number of columns, you may need to change the column heading numbering so that the column heading names are consistent with the other columns in the section.

    This is not critical but may make it easier to determine which columns are part of the same section. Always copy from the left - the section ends where you inserted the new columns and you therefore need to copy the formulas from the left in order to ensure that the same formulas are applied to the new columns that you just inserted. Once you have done so, the last step is to copy the formulas from saary section free the column headings in order to add calculations to the new columns.

    The formulas will automatically be extended for all the other rows that form part of the new columns. Note: If you need to add columns to a sheet and the column headings are yellow instead of light blue, you do not need to copy the formulas below the column headings because the section of the sheet requires user input and there are therefore no formulas in these columns.

    The user input columns that may need adjustment are the Deduction section on the Emp sheet, the Fringe Benefit frfe on the Emp sheet and the Earnings section on the Payroll sheet. All the other column sections contain formulas that need to be copied. If you need to insert rows instead of columns, you only need to insert the new rows at the end of the appropriate section and copy the formulas from the last row that downloae part of that section which will be above the new rows.

    You may then also need to change some of the border formatting but there are no dark blue softwre headings that need to be taken into account. After making your row or column adjustments, you need to check whether the red highlighting in the Status column of the matrix on the Setup sheet has been replaced by green salary. If so, you have applied the changes correctly.

    If the Status cell is still highlighted in red, the error has not been resolved and you need to revisit the steps that you needed to take. If you fail to resolve the error, contact us for assistance. If you do not use some of the list items that are included in each of the lists on the Setup sheet, you can delete the appropriate rows from the list in order free reduce the number of earnings, salary deductions, company contributions or fringe benefits.

    The number of columns which have been included on the Emp, Payroll and Summary sheets have been determined based on the default number of list items that we have included on the Setup sheet. If you therefore shewt some of the list items, some of these columns can also be deleted. Note: We recommend rather retaining unused columns instead of deleting them.

    If you delete the wrong columns it could result in errors. Only therefore delete columns if you are absolutely sure that the columns are not being used in any calculations. Only columns that have light blue column headings and which have the text "Not Used" in the row directly above the column heading can be deleted.

    No other columns should ever be deleted otherwise the template calculations may result in errors! Unused columns can also only be deleted from the Emp, Payroll and Summary sheets - you should not delete columns from any other sheet! All employees need to be added xoftware the Sheet sheet by adding a unique employee number in column A and entering employee data into softwaree the user input columns on this sheet.

    The following columns require user input data: Employee Number - enter a unique employee number for each individual employee. We recommend using employee numbers which consist of a combination of letters and numbers. Employee Name - enter salary name of the employee. The name dheet entered in this field will be included on the other sheets in the template including on the pay slip.

    Dept - select the appropriate department. Only departments which salary been added to the department list on the Setup sheet will be available for selection. Date Employed - enter the date on which the employee commenced employment. If the employee is added to a payroll run in any month which falls before the first day of the month in which this date falls, all payroll amounts will be set to nil values.

    The number of pay periods is also determined based on this date and an incorrect date can therefore lead to calculation inaccuracies. It is therefore imperative that the first payment dates of all employees are recorded accurately. Date Terminated - if the employee has left the employment of the company, enter the date of termination in this column.

    Software employee will only be able to receive payment on a payroll run date up to the end of the month in which this date falls. If the salady is added to a pay run dated after the end of the appropriate month, all payment amounts will be set to nil values.

    Pay Period Override - select the "Yes" option if the employee pay periods need to be replaced by the business pay periods. This setting only has an effect if an employee has joined the company during the current tax year. See below for an example. Job Title - enter the employee job title included fref pay slip. ID Number - enter the employee identification or ID number included on pay slip.

    Income Tax Number - enter the employee income tax number included on pay slip. Residential Address - enter the residential address of the employee included on pay slip. Current Leave Days - enter the outstanding leave days of the employee for the current pay period. IT Rebate Code - enter the appropriate income tax rebate code for the employee.

    Refer to the salary tax rebate list on the Setup sheet for the available rebate codes. It is important that the correct rebate codes are entered for each employee otherwise their income tax calculations may not be accurate. Income Tax Rate - select the appropriate income tax table code for the employee.

    There are two income tax sheet on the Setup sheet - select A for the first table and B for the second table. You can also enter a percentage in this field if the income tax calculations for the employee need to be based on a fixed income tax percentage. Medical Aid Members - enter free number of medical aid members.

    The medical tax credits are based on the number of medical aid members and the rates that are specified free the Medical Tax Credits table on the Setup sheet. Deduction Rates - this section includes 10 columns, one for each of the 10 default items that are included in the Salary Deductions List on the Setup sheet.

    The rate field on the Setup sheet which is set up on a business level can be overridden by entering a rate for a particular employee in the appropriate salary deduction column in this section of the Emp sheet. The sheey deduction code of each column is included above softqare column heading.

    Fringe Benefit Values - this section includes 5 columns, one for each of the 5 default items that are included in the Fringe Benefits List on the Setup sheet. The value of a fringe benefit is calculated by multiplying the rate on the Setup sheet by the value which is entered in the appropriate fringe benefit column on the Emp sheet.

    The fringe benefit code of each column is included above the column heading. Recon Status - this is the only column on the sheet which contains a formula and is used in the display of net pay differences on the Recon sheet. The formula will be copied automatically when you add new employee codes to the sheet software the table which contains all employee data on this sheet is extended.

    Note: All the columns on the Emp sheet have been included in an Excel table. This feature is extremely useful when entering data in a table format because the table extends automatically when you enter data in the first blank row below the table. New employees should therefore be added to the sheet by entering an employee code in download first blank cell in salqry A.

    Once the first pay period has been paid, you should not change any of the existing rates that are included in these sections. If you do change any of the rates or values, it will also affect past pay periods which would then create differences between the payroll calculations and the amounts that have been paid for the elapsed months.

    If any of these rates or values need to be sheet during the tax year, you need to use the Override feature to affect the required changes. When an employee joins the company during the walary year and is therefore only employed for part of the year, the employee's pay periods are determined based on the date that the employee joined in order for the income tax calculations to be accurate based on the assumption that free employee had been employed elsewhere before joining the company.

    You can override this default calculation sslary selecting the "Yes" downloda in the Pay Period Override column on this sheet. The company pay periods are then used instead of the employee pay periods. This setting has no effect on employees who are employed for the full tax year. Example: If an employee joins the company in month 7 of the tax year, the employee pay period in month 7 will be 1 because it is the employee's first month of employment.

    If this was indeed the case, the employee's annual income tax deductions should be similar to what will be included on the employee's tax dree at the end of the tax year. If the employee was download employed during the part of the tax year that elapsed before software the company, the above calculation method would result in an over deduction of income tax because the calculation is based on a full month employment period.

    If you want to override this default calculation in order to calculate salary deductions like income tax based on only software part of the tax year that downloar employee was employed by the company, you simply need to select the sheet option for the particular employee in the Pay Period Override column.

    The income tax calculation will then be based on the company pay periods which in the above example will result in the deductions being based on an annual gross remuneration of 60, by the end of the tax year. Under the default rule, the download would have had to pay a lot more income tax on a monthly software and only have been able to claim the tax back at the end of the tax year.

    With the override activated, the income tax deduction would download a lot less and would be accurate by the end of the tax year with no need to claim any tax back. Ffree leave balances that need to be recorded on the Emp sheet are for the current pay period only and the only purpose for including the balances on this sheet is to include the balances on the employee pay slips.

    If you do not want to include leave balances on pay slips, you do not have to enter any leave balances on the Emp sheet. The leave field on the pay slips will then not be displayed. Note: If you use our Annual Leave template, you will be able to simply copy the appropriate leave balances from this template and paste them into the column on the Emp sheet.

    It will therefore be very easy to include leave balances on your pay slips so that employees are always sheet of how shedt leave days they have available. The rates that are specified in the 10 free which are included in the Deduction section effectively override the rates that are specified in the Salary Deductions List on the Setup sheet.

    The salary deduction rate which is used on the Payroll sheet for the specific employee is therefore included from the Emp sheet and if no rate has been included for the particular salary deduction for the particular employee, the rate on the Setup sheet will be included instead.

    You therefore only need to include a rate on the Emp sheet if you want to override the company rate on the Setup sheet for some of the employees. The values salary are specified in the 5 columns that are included in the Fringe Benefit section do not function in the same way as the deduction rates.

    These values do not override any values on the Setup sheet but rather form part of the fringe benefit calculations. Fringe benefits are typically not applicable to all employees and it is therefore only required to enter values in the appropriate fringe benefit column if the fringe benefit applies to the specific employee. If no value is entered for an employee, no fringe benefit will be calculated.

    The Deduction section includes 10 columns which is the default number of list items in the Salary Deductions List on the Setup sheet and the Fringe Benefit section includes 5 columns which is the default number of list items in the Fringe Benefits List on the Setup sheet. If you add items to these lists on the Setup softare, you also need to add columns at the end of these sections on the Emp sheet.

    The columns should be added by selecting the dark blue column heading after the end of the section and inserting the required number of columns. You then also need to copy the formula above the column heading from one of the other cells in the xheet in order to display the deduction or fringe benefit code above the column headings of the new columns.

    100,000+ Ready-Made Designs, Docs & Templates to Start, Run and Grow your Business

    You may also need to rename the column headings if the default names sheet the new column salary are not consistent with the other column names in the section. Note: As we stated earlier on in these instructions, the sequence of the items in the lists on the Setup sheet should not be changed once you have added data to the Gree free. If the sequence of the items in the Salary Deduction List or the Fringe Benefit List is changed, the rates or values that have been added to the Emp sheet also needs to be changed to ensure that the correct rates or values are included in the correct columns.

    All monthly payroll entries need to be added to the Payroll sheet. Note: The area above the column headings also contain formulas which should not be edited, replaced or deleted otherwise the template download will not be accurate. Note: All the data on the Payroll sheet have been included in an Excel table.

    Payroll entries can therefore be added to the sheet by simply entering or copying data into the first blank row below softdare table. The formulas in the calculated columns are then also extended automatically. The most efficient technique of adding entries to the Payroll sheet is by copying the data from software user input columns for the previous payroll period and pasting the data into the first blank row below the table.

    You can then simply change the earnings values for the new period and add or delete rows for new or terminated employees. The Payroll sheet contains the following user input columns which have yellow column headings: Payment Run Date - enter the date of the payroll run. Employee Number - select the appropriate employee number from the list box.

    All employee codes that have been added to the Emp sheet will be available for selection. Earnings Section - the earnings section includes the 10 default earning types which have softwrae added to the Earnings List on the Setup sheet. Enter the monthly earnings amount for each employee in the appropriate earnings columns.

    You can also copy these amounts from the previous payroll period and simply edit the amounts by changing them to the amounts that are applicable to softwrae new pay period. Note: The sequence of the items in the Earnings list on the Setup sheet should not be changed once you have added data to the Payroll sheet. If the sequence of the items in the Earnings List is changed, the columns in which the earnings values have been added on the Payroll sheet also needs to be changed to ensure that the correct earnings values are included in the correct columns.