E-kundali professional 6.0 rapidshare%3a software, free download. For the financial year, the 2076-77 salary slab is changed. You can download the updated excel sheet for calculation of Salary TDS 2076-77 as per income tax Nepal. After the introduction of SSF(social security fund), there are certain changes in the Salary TDS calculation 2076-77 as per income tax Nepal.
Update: there is no change in the Tax rate for a salaried person in 2077/78 as well as 2078/79 finance bill so you can use the same sheet for 2077/78 and 2078/79 also
Link for old excel sheet download Salary Calculation Sheet 76-77 & 77-78
As TDS is calculated on yearly income, multiply the corresponding figure from above calculation by 12. This is your yearly taxable income from salary. If you have any other income source such as income from house rent or have incurred losses from paying housing loan interests, add/subtract this amount from the figure in step (4). This sheet will ease your payroll calculation and make it a simple and quick process. It is now just 3 step process: update attendance regularly, enter Salary Calculations and print Salary Slips. Your work is all done. All the files are interlinked with each other. No repetitive tasks. Save a data source. In Tableau Desktop, open the workbook that has the connection to the data you want to save as a file. At the top of the Data pane, right-click (Control-click on Mac) the name of the data source, and then select Add to Saved Data Sources. Enter a file name, select the file type (.tds or.tdsx), and then click Save.
Link for the old sheet with 3L deductionSalary sheet with 3L deduction of CIT and PF
Link for SSF excel sheet download SSF salary TDS calculation 76/77 and 77/78
Effect of SSF(Social Security tax) on the calculation of TDS.
- For calculation of TDS as per normal provision (i.e Staff not registered in SSF) 1% SST should deduct in 1st 400000/450000 for single and couple respectively. Separate 1% SST need not be deducted on such amount if the staff is registered in SSF since contribution is already made in on SSF. No need to pay tax on 1st 400000/450000 if Staff is registered in SSF.
- Maximum Deduction Rs 300000 is allowed for retirement contributions like PF and CIT, but such a limit is increased to 500000 in case of staff registered in SSF(social security tax) for Salary TDS calculation 2076-77 as per income tax Nepal. Retirement contribution consists only 28.33% out of 31% but there is no specific notification so you can consider 31 % until further notice
Note: As per the income tax act Nepal, Payments of salaries and wages to workers/employees in excess of 3000 without PAN is an inadmissible expense so obtain PAN for all the staff.
Note: For calculation of 31% SSF of basic salary minimum 60% of total salary should consider for detail understanding read calculation of Minimum SSF(social security fund) contribution.
Note: Since there is no notification or circular regarding the effect of SSF except attached one so legal position regarding TDS for staff registered on the middle of the year is still unclear.
Income Tax Rate For Employee 2076/77 (2019/20) & 2077/78(2020/21)
Individual/Natural Person
| Income Slab | Tax Rate |
| Up to NPR 400,000 | 1% |
| Next NPR 100,000 | 10% |
| Above NPR 200,000 | 20% |
| Beyond NPR 600,000 | 30% |
| Taxable income > NPR 2,000,000 | 36% (20% additional tax on the calculation made under 30% slab) |
1.2 Married
| Income Slab | Tax Rate |
| Up to NPR 450,000 | 1% |
| Next NPR 100,000 | 10% |
| Above NPR 200,000 | 20% |
| Above NPR 550,000 | 30% |
| Taxable income > NPR 2,000,000 | 36% |
Also Read:Tax Amendment by finance act 2077/78 (i.e 2020/21)
Sincere efforts have been made to avoid mistake or error or omission, however, there is always a scope of error so please check the formula for at least one person’s salary manually before use.
If you’ve created a data connection that you might want to use with other workbooks or share with colleagues, you can export (save) the data source to a file. You might want to do this also if you’ve added joined tables, default properties, or custom fields—such as groups, sets, calculated fields, and binned fields—to the Data pane.
Note: This topic describes how to save a data source that you reuse locally, if you do not publish to Tableau Server or Tableau Online. For information about sharing data sources on a server, see Publish Data Sources and Workbooks.
Options for saving a local data source
You can save a data source to either of the following formats:
Data Source (.tds) - contains only the information you need to connect to the data source, including the following:
Data source type
Connection information specified on the data source page; for example, database server address, port, location of local files, tables
Groups, sets, calculated fields, bins
Default field properties; for example, number formats, aggregation, and sort order
Tds Working Sheet In Excel Download
Use this format if everyone who will use the data source has access to the underlying file or database defined in the connection information. For example, the underlying data is a CSV file on your computer, and you are the only person who will use it; or the data is hosted on a cloud platform, and your colleagues all have the same access you do.
Packaged Data Source (.tdsx) - contains all information in the data source (.tds) file, as well as a copy of any local file-based data or extracts.
A packaged data source is a single zipped file. Use this format if you want to share your data source with people who do not have access to the underlying data that is defined in the connection information.
Save a data source
In Tableau Desktop, open the workbook that has the connection to the data you want to save as a file.
At the top of the Data pane, right-click (Control-click on Mac) the name of the data source, and then select Add to Saved Data Sources.
Enter a file name, select the file type (.tds or .tdsx), and then click Save.
Connect to your data source
By default, Tableau saves .tds and .tdsx files to the Datasources folder under your Tableau repository. When you use the default location, you can connect to the data source on the Connect pane.
If you specified a different location, you can connect to the data source by selecting File > Open and navigating to it.
Updating a data source after the underlying data location changes
Tds Working Sheet In Excel Format
If you move a local data file that a .tds file contains a reference to, when you try to open the data source in Tableau, you will be prompted to locate or replace the original data source. If you replace the original data source, the replacement data must be of the same type (for example, Excel or MySQL). To avoid saving a specific file path, save the data source as a .tdsx file.