Income tax based on remaining months of contract and multi currency

Hi everyone,

I have 4 type of employees to manage payroll. Hourly Salaried persons in INR, Hourly Salaried persons in USD, Monthly Salaried persons INR, Monthly Salaried Persons USD.
Now the issue is every employee will receive the salary in INR regardless of their payroll currency, which must include the Exchange rates.

Fiscal Year is July 2024 to June 2025.

Issue number 1: If employee’s contract is about to expire in Sept 2025, the income tax should be only calculated for 3 months. But, frappe calculates it for 12 months assuming the employee will be there until the fiscal year. How can I control that? We have 50+ employees who’s contracts are about to expire in Aug, Sept and Oct etc…

Issue Number 2: Let’s say 170hrs of work done in INR at 1200 per hour and 160hrs of work done in USD at 10.22 per hour rate (these both are different employees). their contracts are also expiring in middle of the year and we can’t control the tax amount based on their contract expire date.

Issue Number 3: Need guidance :slight_smile: How can I put an employee in hourly based rate with its structure without overtime, and run a batch payroll for these types of employees (INR per hour rate). Their timesheets are submitted for JULY 2024. Can some one share the basic structure to be used for per hour employees with different rates? 1 employee with 1200 INR per hour 2nd employee 1650 INR per hour…

Issue Number 4: Same as Issue # 3, just currency is changed to USD. Now in this case I need to show the employee both the USD and INR values in payslip and their taxes and exchange rates.

If someone has done any of the thing above let me know :slight_smile: