Page Comparison

Expand

title	GAF Elements

Element		Description
C	Company	Company, Software and Reporting Period
P	Purchase	Records of Purchases made by the Company
S	Supply	Records of Sales made by the Company
L	Ledger	Records of General Ledger
F	Footer	To verify the accuracy of the file being submitted

Expand

title	Elements - Columns Function

Expand

title	Element P

Record Type	Column	Element Name
P	1	Record Identifier
P	2	Supplier Name
P	3	Supplier BRN
P	4	Supplier GST Number
P	5	Invoice Date
P	6	Posting Date
P	7	Invoice Number
P	8	Import Declaration Number
P	9	Line Number
P	10	Product Description
P	11	Purchase Value (in MYR)
P	12	Purchase Value GST Amount
P	13	Tax Code
P	14	Foreign Currency Code
P	15	Purchase Foreign Currency Amount
P	16	Purchase Currency GST Amount

Note: P Records should have tax codes

Expand

title	Element S

Record Type	Column	Element Name
S	1	Record Identifier
S	2	Customer Name
S	3	Customer BRN
S	4	Customer GST No.
S	5	Invoice Date
S	6	Invoice No
S	7	Export Declaration Number
S	8	Line Number
S	9	Product Description
S	10	Supply Value (in MYR)
S	11	Supply Value GST Amount
S	12	Tax Code
S	13	Country
S	14	Foreign Currency Code
S	15	Supply Foreign Currency Amount
S	16	Supply Currency GST Amount

Note: S Records should have tax codes

Expand

title	Element C

Record Type	Column	Element Name
C	1	Record Identifier
C	2	Company Name
C	3	Company BRN
C	4	Company GST Number
C	5	Period Start
C	6	Period End
C	7	GAF Creation Date
C	8	Software Version
C	9	GAF Version

Expand

title	Element L

Record Type	Column	Element Name
L	1	Record Identifier
L	2	Transaction Date
L	3	Account ID
L	4	Account Type
L	5	Account Name
L	6	Transaction Description
L	7	Entity Name
L	8	Transaction ID
L	9	Source Document ID
L	10	Source Type
L	11	Debit
L	12	Credit
L	13	Closing Balance Sum

Note: L Records should NOT have tax codes

Expand

title	Element F

Record Type	Column	Element Name
F	1	Record Identifier
F	2	Purchase Count
F	3	Purchase Amount Sun
F	4	Purchase GST Amount GST
F	5	Supply Count
F	6	Supply Amount Sum
F	7	Supply GST Amount Sum
F	8	Ledger Count
F	9	Debit Sum
F	10	Credit Sum
F	11	Closing Balance Sum

Expand

title	GAF Analysis

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.

Image Removed

Image RemovedStep 2: Select "Delimited" and Click "Next"

Image Added

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

Image Added

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

Image Added

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

Image Added

Step 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

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.

Image Added

Related Wiki Link:

Analyse the GST Audit File (GAF v.2) using Ms-Excel

Version	Old Version 1	New Version Current
Changes made by	Priyasri Subramaniam (Unlicensed)	Priyasri Subramaniam (Unlicensed)
Saved on	2018-Aug-29	2018-Aug-30

Versions Compared

Key