Net Gross Salary Calculation

An Excel file that teaches how to perform 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. [ATTACH type="full" alt="Net Gross Salary Calculation"]2926[/ATTACH] On the Calculation page, it is possible to calculate the salary as desired. It is possible to select: [LIST] [*]Wage [*]Wage Type (Net, Gross) [*]SGK Type (Normal, Retired) [*]Disability Degree [*]BES [*]Incentive Rate [/LIST] for each month. Net to gross or gross to net is done in the same table. [ATTACH type="full" alt="Excel Net Gross Salary Calculation"]2927[/ATTACH] 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.