There is obviously a recurring issue here, but I am not sure about having the ability to edit the GST amount, as misuse could have severe consequences (we would at least need to be able to restrict it in user permissions).
My issue was that the client defaulted to GST exclusive invoicing, including Products and Services set as exclusive, but the invoice total would not reach a round number - it was either $149.99 or $150.01 - even with just one line item.
The unit price can be adjusted to 4 decimal places, but changing that didn't help - the totals seem to be locked into 2dp.
Looking at comments below, the issue compounds with more line items.
A solution could be to provide variable settings that can be adjusted depending on which figure needs to be exact, for example:
Calulate GST based on:
- Invoice Total
- Invoice Subtotal
- Each line item
If calculated on the total, the rounding variance would need to be automatically spread across the line items.
Another option could be to have the ability to manually add a small variance to an invoice without having to have a specific line item showing on the invoice. An invoice could have the option to "add rounding adjustment" to either the total and/or the GST amount. It could be like the Minor Adjustment field while reconciling, but available to allow invoices to be tidied up before sending.
There is obviously a recurring issue here, but I am not sure about having the ability to edit the GST amount, as misuse could have severe consequences (we would at least need to be able to restrict it in user permissions).
My issue was that the client defaulted to GST exclusive invoicing, including Products and Services set as exclusive, but the invoice total would not reach a round number - it was either $149.99 or $150.01 - even with just one line item.
The unit price can be adjusted to 4 decimal places, but changing that didn't help - the totals seem to be locked into 2dp.
Looking at comments below, the issue compounds with more line items.
A solution could be to provide variable settings that can be adjusted depending on which figure needs to be exact, for example:
Calulate GST based on:
- Invoice Total
- Invoice Subtotal
- Each line item
If calculated on the total, the rounding variance would need to be automatically spread across the line items.
Another option could be to have the ability to manually add a small variance to an invoice without having to have a specific line item showing on the invoice. An invoice could have the option to "add rounding adjustment" to either the total and/or the GST amount. It could be like the Minor Adjustment field while reconciling, but available to allow invoices to be tidied up before sending.