A challenge related to the treatment of the "Travel Allowance" payroll category
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.
I had a similar thing that needed to be done a long time ago (Can't remember if it was for MYOB -probably)
The solution was to effectively switch the multiplier around, have the non-complying one be set at x1 and then have the incoming data have the varing number.
edit: If I recall correctly we also had a problem with the source data not being able to do cents (dicimal points) so we had the source data come in in cents and had the multiplier convert it to dollars ie x1 became x0.01.
