Correct GST rounding discrepancy on invoices
I have been using Sage/Simply for ten years and it's been really good to me and very easy to use. I live in BC and since I have transfered over to 5% from 12%, the GST amount has been inaccruate.
We own a courier company and have many waybills or delivery charges per day. I bill out to our customers at the end of the month, listing each delivery charge on the invoice. Simply then tallies the amount, stating the subtotal, the tax amount and the toal at the end of the invoice. However, if you calculate the amount of GST on the full amount of the subtotal, it's 2 - 4 pennies less than the amount that simply has calculated. I understand that this is a rounding problem - but the amount shouldn't be out as much as it usually is.
My customers have noticed the discrepancy. I do have an option to adjust the GST on the inovice, however, the invoice still shows the 'simply calulated' GST then a negative transaction stating 'GST not included.' This looks very unprofessional on our part, appearing that we are not charging the full GST amount.
I have reimput all the separate transactions in an Excel sheet, calculating all the GST amounts individually then totalled at the end of the columns.There is never such a rounding discrepancy in Excel as there is in Simply.
This rounding descrepancy should be corrected.