Page Comparison

• Go to Extended Module > Malaysia GST > Reports > GST Audit File > GST Audit File (GAF) Version 2
• Generate GAF file from EMP system. Ensure to select Text File format when generating GAF. 

Step 1: Open a blank/ new Excel file. Click on the Data tab and click on the From Text function. Select the downloaded GAF file in Text Format.

Step 2:  Select "Delimited" and Click "Next"

Step 3: Select "Other" > Insert " | " (Shift + |) , Clcik "Next" then click "finish" and "ok" 

Step 4: Separate the P and S element into different Sheet and select border 

Step 5: Click on the F5 key on the keyboard. Click on Special button. Click on Blank and click OK. 

Image Removed

Image Removed

Image Removed

Image Removed

Image RemovedStep 6: Select any colour to fill the blank cells. These step is to identify the blank information that User have not keyed in or empty data.

Image Added

Step 7: Select the whole table. Click on the Insert tab and click on the Pivot Table function, click OK.

Image Added

Image Added

Step 8: On the right section, Pivot Table function will be displayed. Drag and Drop the S12_Tax Code to the Rows box at the bottom. Also, Drag and Drop the S10_SValueMYR and S11_GSTValueMYR. The Pivot Table will appear on the same sheet with classification of tax codes.  

Image Added

Step 9: Double click on the amount at S10_SValueMYR column (Column B), a new page will be directed, to display the list of documents and data deriving from the amount.