Print GST Listing

From eStream Software

Introduction

To analyse the detail of GST transactions group by tax type. It can be use to check against with GST-03.

GST Listing

[GST | Print GST Listing...]

30PX


GST Listing-Parameter

30PX


Parameter Type Explanation
Date Date To range the date to retrieve the data after apply it.
GST Process Lookup To select the GST Process period.
Tax Lookup To select the tax code.
Include Zero Local Tax Amount Boolean To show the zero local tax amount.


GST Listing-Main Data

1. Select the date range or GST Process
2. Select the tax if you would like to get a particular tax code GST listing.
3. Click on APPLY.
4. See the below screenshot.
30PX


GST Listing-Detail Data

1. Point on the Tax Type, eg. SR.
2. You can see the breakdown detail in documents level. See the below screenshot.
30PX


Reports

1. Click on Preview.
2. Select a report to preview or print or export.
30PX


No. Report Name Purpoase
01 GST Detail 1 To show the document description in GST Listing.
02 GST Detail 2 To show the document item details description in GST Listing.
03 GST Detail 3 - GST-03 To show the GST-03 details in GST Listing.
04 GST Lampiran 4 - Ringkasan Maklumat Permohanan Tuntutan Pelepasan Hutang Lapuk Lampiran 4 as requested by Kastam Officer
05 GST Lampiran 2 GST form not compulsory to print and submit. It is upon as requested by RMCD.
06 GST Listing - Yearly GST Analysis To analyse the yearly tax amount and taxable amount.
07 GST Summary Sheet - MY GST Summary Sheet format.


NOTE: 
From Doc Types in GST Listing Detail are consists of:
1. _A = Unclaimable Non-Incidental Exempt Supplies (TX-N43)
2. _B = Unclaimable TX-RE 
3. _C = Annual Adjustment Non-Incidental Exempt Supplies (TX-N43)
4. _D = Annual Adjustment TX-RE
5. _X = Realised Gain Loss


Pivot Table

1. Select the date range or GST Process. Click Apply.
GST-GST Listing-06.jpg


2. On the right bottom corner, you can see a word Pivot Table. Click on it.
GST-GST Listing-07.jpg


3. Pivot Grid. Available grid data to be use to structure the pivot reporting. See the screenshot below.
GST-GST Listing-08.jpg


:4. At the Pivot Grid, there are 3 sections: 
a. Data Fields - Data to be sum according to the Row and Column structure.
b. Row Fields - To structure the grouping for Rows.
c. Column Fields - To structure the grouping for Columns.
GST-GST Listing-09.jpg


5. Drag and drop the Local Amt into the Data Fields to display the local amount.
GST-GST Listing-10.jpg


6. Local Amt will be display under Grand Total column. See the screenshot below.
GST-GST Listing-11.jpg


7. 1st Grouping at row', drag and drop the Tax Type into the Row Fields to display the tax type.
GST-GST Listing-12.jpg


8. Tax Type will be display on the row and the Local Amt will be sum according to the Tax Type. See the screenshot below.
GST-GST Listing-13.jpg


9. 2nd Grouping at row', drag and drop the GL Account Desc into the Row Fields to add into second grouping after the tax type.
GST-GST Listing-14.jpg


10. GL Account Desc will be display on the row and the Local Amt will be sum according to the Tax Type and GL Account Desc. See the screenshot below.
GST-GST Listing-16.jpg


TIPS:
You right click on the row field to Expand All.
::GST-GST Listing-15.jpg

11. 3rd Grouping at row', drag and drop the Doc No into the Row Fields to add into third grouping after the Tax Type and GL Account Description.
GST-GST Listing-17.jpg


12. Doc No will be display on the row and the Local Amt will be sum according to the Tax Type, GL Account Desc and Doc No. See the screenshot below.
GST-GST Listing-19.jpg


TIPS:
You right click on the row field to Expand All.
::GST-GST Listing-18.jpg

13. If you want to show the breakdown for Local Tax Amount by the multiple grouping at row.
14. Just drag and drop the Local Tax Amt' into the Data Fields.
GST-GST Listing-20.jpg


12. Local Tax Amt will be display under Grand Total column. See the screenshot below.
GST-GST Listing-21.jpg


See also