As you are aware, our payroll data is generated in a specific format which we aim to seamlessly import into MYOB. However, during the import process, we are encountering a problem with the "Travel Allowance" category. Unlike other categories, "Travel Allowance" is not based on the conventional unit and fixed rate model. Instead, the amount varies for each employee, making it incompatible with the unit-based multiplication approach.
Our current import process treats the "Unit" column in the provided data as a unit to be multiplied by the established fixed rate. This works well for most categories but does not suit the "Travel Allowance" category. The challenge lies in the fact that the travel allowance amounts are generated individually for each employee, and there is no fixed rate to apply.
To ensure accurate accounting and payroll calculations, we need to find a solution that allows us to treat the "Travel Allowance" amount as just that—an amount that should be directly imported without undergoing any unit-based multiplication.
