Net Gross Salary Calculation

There is an Excel file that teaches how to perform the Net Gross Salary Calculation operation.

Excel Powered Net Gross Salary Calculation

This file, which consists of 2 pages in total, is used to easily calculate salaries with Excel. It will be sufficient to make the necessary definitions for the relevant year on the parameters page. 2926 On the Calculation page, it is possible to calculate the salary as desired. It is possible to select:

• Wage
• Wage Type (Net, Gross)
• SGK Type (Normal, Retired)
• Disability Degree
• BES
• Incentive Rate

for each month. Net to gross or gross to net is done in the same table. 2927 NOTE: The file was prepared only with Excel Formulas. When calculating from net to gross, a macro was used due to the need for a loop and the "Iterative Activation" and "Automatic Calculation" settings, as some users do not know the setting. Therefore, it is recommended to enable macros at startup. However, the file will run smoothly even if Macros are not enabled. It may only be necessary to set "Recursive Activation" and "Automatic Calculation" manually.

Hope it is useful.