Tag Archives: GST

Amending GST amount on Purchase Invoice

Software: MoneyWorks accounting software

There are two methods of computing the GST on Tax Invoice when the invoice contains more than one item with the standard rated supplies. The line item method, which commonly used in accounting software; this method computes the GST on each line item and then sums up the GST amount. The second is a subtotal method, which calculates GST based on the total payable.

Document Preferences

Assuming you sold 9 pieces of product A at $13.98 each and 7 pieces of product B at $17.38 each.

Method one (the line item method):

9 x Product A @$13.98 = $125.82 x 7% GST = $8.80
7 x Product B @$17.38 = $121.66 x 7% GST = $8.51
Total GST = $17.31

Method two (Subtotal method):

9 x Product A @$13.98 = $125.82
7 x Product B @$17.38 = $121.66
Subtotal: $247.48
7% GST = $247.48 x 7% = $17.32

Amend GST

Both methods of computing the total GST are acceptable so long as you apply the chosen method consistently.

IRAS Calculating GST on invoice

Due to a different method used or rounding between two systems, the GST amount on supplier invoice may differ from your entry. You need to set to show tax column from the MoneyWorks Document Preferences to allow amending the GST amount on Purchase Invoice transaction. A warning message may prompt when printing the GST report, and the report highlights those transactions in question.

Sign up a free demo to find out more about how to use MoneyWorks for your business.

GST on imported goods

Software: MoneyWorks accounting software

Oversea suppliers are not supposed to charge GST if they are not a GST registered trader. The GST is paid to the Custom or a forwarder (if they paid the GST on your behalf) when goods arrived.

You can use the cost of goods sold or an expense account as a dummy account in the account tab of a payment transaction to record the GST paid. For example, you paid $700 GST on goods purchased; the entry will be:

Detail line 1:
Account: Cost of Goods Sold
Taxable amount: 10,000
Tax Code: IM
GST: 700

Detail line 2:
Account: Cost of Goods Sold
Taxable amount: -10,000 (negative)
Tax Code: OP (or *)
GST: 0

Imported GST

The Cost of Goods Sold contra off with each other and left the GST paid.

Due to differences between the internal exchange rate and the rate used by the Custom, the taxable amount could be different from the purchase value in Singapore dollar.

Note: You are supposed to record the import permit number in either Transaction user field 1, 2, or 3 on both purchase invoice and the GST payment, which will use in the IAF (Iras Audit File) report later if required. The Transaction User field label can be renamed to ‘Permit No’ from the Document Preferences to ease the data entry.

Sign up a demo to find out how to use MoneyWorks efficiently to manage your business finance.

QuickBooks foreign currency transaction

Software: Intuit Quickbooks Desktop accounting system

In QuickBooks, only bank, accounts receivable, accounts payable, and the credit card accounts have the multiple currencies option.

After turning on the multiple currencies feature in QuickBooks, you have to set the trading currency in each debtor or creditor profile. So, the related transaction will record in foreign currency.

QuickBooks multiple currency

By default, the foreign currency transaction will pick up the exchange rate from the currency table; however, you can change the exchange rate to match the GST in Singapore dollar which shows on the foreign currency bill.

Local Supplier who billed you in foreign currency has to show the amount before GST, GST, and the amount inclusive of GST in Singapore dollar equivalent. You have to follow the exchange rate shown on the bill instead of the system exchange rate, so to claim the input tax correctly.

For example, your system exchange rate is 1USD:1.3500SGD. You received a US dollar bill from a local supplier shows a GST of US$700 (S$947.10 Singapore dollar equivalent). Then, you record the bill at 1USD:1.3530SGD instead of the system exchange rate. It affects the GST amount in Singapore dollar if using the system exchange rate instead.

Join our training to learn the proper way of recording transaction in QuickBooks.

Intuit QuickBooks Desktop 2019 is coming soon, contact us if you are interested.