What I asked at the GST Expo &
Conference 2014
The GST Expo kicked off today 1st
October 2014 and it was rather crowded considering it being a working day. My
interest was centered on finding good GST compliant accounting software but only
managed to ask 3 vendors: SQL, QnE & Wavelet due to my time rush.
Hopefully, this feedback could
prove useful to you all. Please do leave a comment if you have anything to add
on…
I don’t claim to be an expert in
GST or Tax and only took about a day to pick up some pointers here and there
from Google and my student, Helen Phang to help clarify some technical terms.
So, do help to correct me for any unintended mistakes and inaccuracy if any.
I got requests from some students
regarding which accounting software is good and GST compliant. Thus, I have
listed some questions which you may be asking when shopping for GST compliant accounting
software (You need some basic knowledge of GST to understand the software
system requirements):
1. Auto calculate GST
for Sales amount and/or auto include GST within the Sales figure function
Most software will auto
calculate the 6% GST based on the sales amount but some software may be less
flexible when you want to absorb the GST for your customer. For example,
Selling price is $100 and GST should be $6 (6% X $100) but if you absorb the
GST then the customer only pays you $100 but you still need to allocate for 6%
of GST. Thus, the system should be able to auto INCLUDE GST (Sales $94.34 and
6% GST $5.66). SQL and MYOB have such feature. Also check other software as I
didn’t managed to ask them.
2. Most GST compliant
software can autofill all your data for the GST 3 Form to be submitted to
Customs every quarterly?
Companies are required to
submit quarterly GST 3 Summary Report to Customs and each GST transaction needs
to be grouped into specific categories in accordance with their standardized
form. If the software doesn’t have this feature then the poor Accounts
Assistant has to manually categorize and fill in the forms every 3 months, a
very daunting task indeed. SQL, MYOB and Tally.ERP9 have such features and
perhaps some others also have.
3. GST kept for at
least 7 years?
GST records should be kept
for a minimum of 7 years and Customs may request you to provide a detailed listing
of all this transactions. Check that your remote server or cloud computing
allows your records to be stored for such long period, taking into
consideration the volume of your transactions, storage space, storage costs,
etc.
4. GST Audit File
(GAF) format for tax audit by Customs
Customs may request you to
provide a detailed listing of all transactions via a fixed formatted text file GST
Audit File (GAF) that can be submitted online via customs GST portal to assist their
audit. This file is automatically generated.
5. Which server;
either Microsoft SQL or Firefox or ‘whatever’?
Your data would be stored in
their servers and they could be running on Microsoft SQL or Firefox or
something. Check how much do the vendors charge annually for data storage. You
should also check the processing capacity of the servers and I heard that Microsoft
SQL handles large data well. Not too sure about others. Not much of an IT geek,
can someone please comment further, thanks.
6. Keeping track of
the 21 Days rule
Tax Invoice must be issued
within 21 days after the D.O. or services performed. Most system can’t keep
track of the 21 days and send a reminder for you to track and prevent any late
issue of invoice. QnE can track the 21 days. Others probably can too.
7. Bad Debt relief
adjustment
You have
included GST for Tax Invoice but that customer failed to pay you and became a
bad debt but you have already paid the GST portion on his behalf. The software
should allow you to list out such GST amount for you to get a refund.
If later on after 180 days,
the same customer pays you back the amount, then, you need to be able to track
back the bad debts and pay back again that portion of GST to Customs.
8. Generate
Notification letter for Bad debts relief
When you claim back the GST
for Bad debts, the system should be able to generate out a Notification letter
for Bad debts relief to be sent to your customer. QnE can print out such
Letter. I am not sure but I think others may not.
9. The system should
already have all the 23 Tax Codes and most have more (up to 30 Tax Codes) to
allow for different circumstances e.g. purchase for own use
There is a total of 23 Tax
Codes eg. Purchases exempted from GST, Purchases (GST not claimable), Sales
(GST not claimable), etc. and you should be able to set for each customer
regarding their GST status, the same applies to suppliers as some input tax may
not be claimable while others are claimable. The big problem with this is that
the same supplier may sell you goods which are GST claimable and also other
goods which are not GST claimable. Your system should be able to handle the
different combination well for different customers, suppliers and also GST
claimable and not claimable goods. If you are selling to a Labuan customer,
then, you can’t charge the customer GST at all.
10.
The system should automatically enter the double entry
for Input tax, Output tax, Payable tax, etc.
Another issue is that sometimes
goods are purchased for own use, then, you can’t claim the GST but have to
charge it as part of your expenses or capitalized within asset purchased. The
system should be able to handle the journal entries. Claimable GST (Input tax)
should be capitalized as an asset while Payable GST (Output tax) is recognised
as liability (not tax expense). However, GST paid to supplier that is not
claimable is recognised as expense. I know this gets very confusing so get some
help if you don’t get this…
11.
Convert from DO to invoice or POS to invoice? Which is
better?
I heard that some system can do automated data entry from the point of sales. Meaning to say, there is no need to key in the data for sales. I don’t how it works as the technical guy was busy showing others and I didn’t get a chance to see how. Furthermore, it handles Point of Sales from many branches and allow for group reporting of GST. Wavelet has that function and uses cloud computing.
12.
E-voucher claim
Make sure you claim RM1,000 when you purchase the GST compliant accounting software. Ask the vendor how to claim otherwise you might end up paying the full price of the software.
13.
iPad, Android access
Most systems runs on multiple devices such as iPad or iPhone, Android devices as well as Window based computers. Better check with the vendors and test where possible. One freelancer I met that day told me his client complained about the font size of the reports which is too small for his eyes and that is why he used QnE as there is a magnifying function. However, the client still complained about it every now and then. Using other touch screen devices may help to magnify the figures in the reports.
14.
Free training 6 months to one year
Also check
out the free training offered by vendors; which ranges from 6 months to one
year. Mostly they limit to one or two staff and will charge for any additional
staff. This has always been a problem because staff turnover is very high for
companies. I know that UBS becomes popular as the training is widely available
in Malaysia. Better to go for one where training is solid and well supported.
But I was surprised that UBS and Sage were not represented in the Expo.
Hope the above information helps.
Happy software hunting!