N. Selvam Consult was registered as a Consulting Firm way back in 1987. We have two Business Divisions as follows:
We have been operating since 1987 and we have serviced more than 1880 Clients within the Asian Region. We have Sage 300 Clients in Malaysia, Singapore, Thailand, Hong Kong, Cambodia, Philippines, Maldives and Vietnam. Our Client Base is still growing because we have the expertise to provide a wide range of Services relating to the Sage 300.
We believe in rendering Personalized and Professional Services. We are never far from you as we have highly Trained Professional Business Associates/Partners within the Asian Region. We are harnessing the power of Sage to link everyone inside and outside your Organization to a highly efficient and tightly integrated Business Operations Model.
Our Market Focus is small to large Companies who need a System to work as a Standalone or Client/Server or remote/Web Environment and to integrate seamlessly with Third Party Solutions and/or Custom Software and are perfect fit for Microsoft, Oracle and etc. Companies ranging from a few employees to more than 100 with revenue up to RM250 million have been able to utilize our System to streamline their Business Operations.
Successful development of the Sage 300 has been seen in many industries including Manufacturing, Food and Beverage, TV Stations, Engineering, Cosmetics, Automotive, Hotel, Banking, Securities, Oil and Gas, Telecommunication, Services and etc. We have a dedicated team of Professionals to provide you with all the Support and Training for your Sage 300 Software
To provide a Comprehensive Solution in a Cost Effective and Efficient Manner for Sage 300.
Together we can, for the future of better business.
NSC Core Values
Collaboration. Consistency. Continuity. Confidence. Caring.
Sage 300 Awards
Sage Asia Premier Partner 2015
Sage Asia Premier Partner 2014
Sage Asia Premier Partner 2013
Special Course (GST)
Jabatan Kastam Diraja Malaysia
Certificate of Attendance
Chartered Tax Institute of Malaysia
Sage 300 Certified Application Consultant
Sijil Pendaftaran Penyedia Latihan
Pembangunan Sumber Manusia Berhad
PSMB Train the Trainer (TTT) Programme
Pembangunan Sumber Manusia Berhad
A team of dedicated consultants are totally committed to their roles and responsibilities
Selvam N Narayanan
Here is our event schedule
Data Visualization with Tableau for Beginners by N. Selvam
10th June 2020
Book Launch Selvam N Narayanan
Lauching of Data Visualization with Tableau for Beginners.
Libero corrupti explicabo itaque. Brenden Legros
Facere provident incidunt quos voluptas.
Quo qui praesentium nesciunt Willow Trantow
Voluptatem et alias dolorum est aut sit enim neque veritatis.
Take a Peek into N.Selvam Consult
N.SELVAM CONSULT is registered as a Consulting Firm in Malaysia. We are a Sage 300 Premier Business Partner. We have been in business since 1987. Our core business is to sell and provide consulting services for Sage 300 (formerly known as Sage Accpac).
Selvam N Narayanan is the Principal Consultant for N.Selvam Consult. He is a Chartered Accountant, Certified Software Trainer and a Member of The Malaysian Institute of Accountant (MIA) and Chartered Institute of Management Accountants (CIMA-UK).
We are forever grateful to N.Selvam Consult for their reliable, problem free & best SAGE 300 CONSULTANCY, INSTALLATION, AND EVERYTHING UNDER THE SUN services provided to us!
- LAM SENG GROUP OF COMPANIES
We have known N.Selvam Consult for so long and have only 3 words to describe them – 'COMMITTED TO CUSTOMER'.
– TAKAHATA PRECISION (M) SDN BHD
Data Visualization with Tableau for Beginners
by Selvam N Narayanan
What is Data Visualization?
Data visualization is the graphical representation of information and data. By using visual elements like charts, graphs, and maps, data visualization tools provide an accessible way to see and understand trends, outliers, and patterns in data.
What is Tableau?
Tableau software is one of the fastest growing data visualization tools which is currently being used in the BI industry. It is the best way to change or transform the raw set of data into an easily understandable format with zero technical skills and coding knowledge.
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s important. It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.
Data Visualization with Tableau for Beginners
There are 8 Chapters in the Data Visualization with Tableau for Beginners.
If you are using a SQL accounting system, you can use ODBC or SQL Scripts to export your data into Excel and then do the analysis using Tableau Public and share the visualization with your teammates.
About the Author
I wrote my first guide 30 years ago on a very popular DOS-based Accounting Software. I was a lecturer in a local university in Malaysia and conducted hands-on training on how to use the software to keep accounting records. The User Guide by the Developer had hundreds of pages and it was difficult for the students to understand the contents. I also started a software consulting firm and conducted hands-on training. Many of the staff in the accounting department and my students wanted an easy-to-follow guide. I decided the best option was for me to write a step-by-step guide. I am glad I wrote this guide as it gave me the foundation to write books.
To date, I have conducted more than 1000 hands-on training sessions on software and when Malaysia implemented GST in 2015, I did extensive training on how to read and analyse the GST Audit File (GAF) using Excel for the members of the Malaysian Institute of Accountants (MIA) and Chartered Institute of Management Accountants (CIMA). I am member of both professional bodies.
Owing to my extensive experience, I was given TTT exemption by HRDF Malaysia.
I am a Certified Software Consultant and I still conduct training in my own facility for Accounting Software, Excel Tips & Tricks and Pivot Tables. My target market is beginners. I discovered, although many people have been using Excel for many years, they have not learned to use many of the functions in Excel that will help to increase productivity.
Over the last one year, I received so many inquires if I could conduct hands-on training on any data visualization tool and I discovered Tableau. I was amazed by Tableau. I realized it was an extension of my skills with Pivot Tables. I did my own research on Tableau. There are lots of good books, fantastic help sites and so many experts on-line. I now have the opportunity to write my next book “Data Visualization with Tableau for Beginners” and the encouragement I received was tremendous.
If you are new to Tableau, this book will get you started and if you delve deeper in data visualization, it could possibly open new career opportunities. I conducted a hands-on training using my book with a group of final year students in a local university and the results were amazing. They were able to move on their own.
Thank you for your support!
Frequently Asked Questions
Why you need to analyse the SST-SAF?
From April 2015 to August 2018
If you have registered for GST Malaysia, you could have done more than 40 Tax Filing until August 2018.
Most likely, you would be using an Accounting Software accredited by JKDM. All accredited Accounting Software must generate GST03, GST Audit File (GAF) and TAP.
Typically, you would have printed the GST03 Tax Filing Form or generated schedules from your Accounting System or generated the TAP Import File & manually entered or uploaded your GST Values into the KASTAM TAP Portal & hope for the best.
You could be in a paying position or you could be in a refund position.
Did you check your GST03 values before doing your submission or you reported whatever values that was generated by your Accounting System.
I have done more than 300 GST Audit File (GAF) hand-on training and more than 50 GAF Audits on-site. The GST03 values generated from GAF did not agree with the GST03 values that was submitted and for some companies, the variation is significant.
There were 5 major reasons given for not checking the reported values before submission.
a. Insufficient time or lack of resources
b. Assumption that the reported values are good for submission
c. Lacking skills on how & where to check
d. Wrong advice given
e. Should be “safe” if you are in a paying position
6. Challenges experienced during my audit
a. No reconciliation done when GST03 values extracted from GAF did not agree with the GST03 Tax Filing Form generated by the Accounting System
b. GST03 values amended in the KASTAM TAP Portal without proper controls or authorization
c. Not reporting net realized forex gains and Interest received
d. Not charging GST for supply transactions
e. Not reporting purchases of Fixed Assets
f. Assigning incorrect Tax Codes for overseas purchase and supply transactions
g. Questionable exchanges rates for overseas purchase and supply transactions
h. Not accounting for reverse charge for imported services
i. Misuse of Tax Codes OP & OS (used as a dumping tax code)
j. Using self-created Tax Codes and GST03 Tax Mapping Table not available. e.g. Tax Code : DNC
k. Never reported OS in GST03 (required to report in Field 15)
l. GST% not equal to 6%
m. No GST Number and BRN Number in GAF for TX & SR Transaction reported in GST03
n. Non Registered Vendors reported as OP rather than NR
o. Transactions which are blocked (BL or TX-NC) are assigned Tax Code TX and reported in Field 6a/6b
p. Too many blank fields in the GST Audit File (possibly software issue)
q. Invoice date in GAF is not the actual date of the document
r. Back-posting of transactions after GST03 has been reported
s. K1 & K2 numbers not appearing in GAF
t. Differences in opinion to when to assign the K1 number
u. GAF is damaged and cannot be opened in Excel
v. GAF is in Excel Format (should be in TXT or XML format)
w. GAF can only be generated once
x. Blank “key” fields in GAF & cannot proceed with the audit (e.g. blank Tax Code)
y. GAF generated using 3rd party software and lines can be amended or deleted
z. The GAF is incomplete (cannot find all 5 record elements C,P,S,L,F)
aa. The values in F Record Element is incorrect
bb. Purchase Tax Codes appearing in S Record Element and Supply Tax Codes in P Record Element
cc. Cannot reconcile certain values in GAF with GL (e.g. GST Input)
dd. Failure to charge GST for inter-co transactions
ee. The GAF is a “nightmare”, possibly build by someone who has no idea what Malaysia GST is all about
GST Audit File (GAF) is not important
If someone tells you GAF is not important and can be safely ignored, get it in writing & send it to JKDM to “protect” your company
The GST Audit File is there for a good reason. It contains all your Accounting Transactions and in simple words “whatever you enter in your Accounting Software, the authorities will find it in GAF”. Therefore, it make perfect sense for KASTAM and Income Tax to use GAF for Audit. They don’t need to know how your Accounting Software works
The GST Audit File was mentioned many times during the MyGCAP Reviewers Course
When will your challenges start?
You must remember you could have done more than 40 GST03 submissions and someone in your company has to take ownership when there is staff turnover. Likewise when you join a new company, you have to be responsible for the previous submissions given your position.
You challenge will start when the management asked you to verify the previous submissions or you cannot verify how the ex-staff obtained certain values or you receive a letter from KASTAM telling you they are coming in for an audit or asking for breakdown for specific fields in GST03.
You must remember:
Accounting staff will leave without doing any “proper handover”. Typically Excel Files used for reconciliation are never handed over.
Company can change Accounting Software but never generated or verified the GAF from the previous accounting software.
The GAF never “worked” from worked from Day 1 and all parties choose to keep quiet.
The programmer who developed the GAF resigned without fixing outstanding issues/bugs.
The Software Developer/Vendor who sold you the Software “close shop”.
You could join a new company & you have no idea how the Accounting System works and how they generated GST03 from Day 1. What would you do when you cannot verify any of the values in GST03. Would you leave the organization.
The company can use their own Tax Codes which are new to you & you do not have a GST03 Tax Mapping Table.
When you move from GST to SST
Make sure you can still generate GST03, GAF and TAP File for the historical periods.
Make sure your GST Tax Codes are not removed or replaced.
Make sure your accounting software can generate separate reports for GST & SST as you will still have GST Transactions for September 2018, possibly right up to December 2019.
You are expected to keep records for a minimum of 7 years. This also means the GAF will also stay for 7 years.
What we can do for you?
We will be conducting GAF hands-on training for July & August 2018 at subsidized rates (1 full day session @RM350/pax)
During this training, you will learn:
How to load the GST Audit File in Excel & naming conventions
a. The 5 Records Element in GAF and what they represent
b. Check if the GAF File complies with the requirements as per the GST Software Guide
c. How to check the integrity of the F Record Element
d. How to build the GST03 Mapping Table
e. How to generate GST03 from GAF using Pivot Table & Tax Code Mapping Table
f. How to generate Supply & Purchase Reports using different parameters (by Tax Code/Supplier/Customer/Country)
g. How to do exceptions reports (e.g., GST% <> 6%)
h. How to generate the Trial Balance and Ledger from the L Record Element as well as locate double entries
i. How to generate reports for multi-periods
j. How to build audit templates that you can re-use for different periods and different companies
Participants are encouraged to use their own GST Audit Files for this training (best to have at least 3 Reporting Periods). It would be to your advantage to working knowledge of Excel & Pivot Table for this hands-on training
Please feel free to contact us if you need any further information.
Address1108, Block A, 11th Floor, Damansara Intan,
No. 1, Jalan SS 20/27, 47400 Petaling Jaya,
Selangor Darul Ehsan, Malaysia
Please fill out all required* fields. Thanks!