SG - Manually edit GST amount
There is a need to manually edit the amount of GST paid instead of using Xero's calculation. For example, for credit card merchant fees, merchants calculate GST based on individual transactions and sum up the total GST payable, add onto the merchant fees for the total amount payable. As Xero calculate GST based on the total amount, there is a difference in the GST payable. Other accounting systems allows you to adjust, and it will automatically adjust the total amount. Without this feature, we have to use either rounding (for below 0.10c) or add a new line item. The problem then is rounding results underpayment to the tax authorities as it goes into the P&L while adding a new line in bills goes straight to GST account does not reflect in the GST Form 5 transactions report as GST rate was not selected.
This is a very basic feature that Xero should have as we're answerable to the tax authorities for the GST reported and should tally with the invoices/bill figures, which should override Xero's auto calculation.
Glen Chan
shared this idea
Hi 👋 Xero calculates the GST on each line item in invoices, bills and other transactions. The GST is then rounded to the nearest cent. The total GST is the sum of these amounts.
We don't offer alternative rounding methods but if you have the global or Singapore versions of Xero you can enter a tax adjustment if you want to.
Simply,
- Select the Tax Exclusive option in the Amounts are field.
- Edit the amount shown in the Tax Amount box - if this box isn't showing, click the + symbol next to the Tax Rate heading
We have more information in our article here.