When creating a Sales Invoice, I put the value of service and then provide 10% as Withholding Tax. It works beautifully except when the numbers do not round well.
For example, My amount for billing is Rs. 83,333. When the customer deducts 10%, it should result into Rs. 8333.3/- deducted and It should show 74999.70 as balance. This is a correct calculation and Manager shows exactly that.
However, when the customer pays in real, they would actually pay Rs. 75,000 and balance of 8333 will be shown as Tax Receivable. This is a minor rounding adjustment but results into incorrect balance due. To make this work correctly, I need to use 9.99964% as Withholding rate to round it off correctly.
I don’t really see an easy way to solve it except that there can be an option to provide value apart from % only. Is that possible?