Print GST Listing: Difference between revisions

From eStream Software
 
(77 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Introduction==
==Introduction==
:To analyse the detail of GST transactions group by tax type. It can be use to check against with GST-03.
:To generate a summary and details of the GST transactions after process the GST Returns. It is easy to cross check against with GST-03.


==GST Listing==
==GST Listing==
''[GST | Print GST Listing...]''
''[GST | Print GST Listing...]''
<br />
<br />
::[[File: GST-GST Listing-01.jpg| 30PX]]
::[[File: GST-GST ListingV1-01.jpg | 800px]]
<br />
<br />


===GST Listing-Parameter===
===GST Listing-Parameter===
::[[File: GST-GST Listing-02.jpg| 30PX]]
::[[File: GST-GST ListingV1-02.jpg| 600px]]
<br />
<br />
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Parameter !! Type || Explanation
! Parameter !! Type || Explanation
|-
| GST Process || Lookup || To select the GST Process period.
|-
|-
| Date || Date || To range the date to retrieve the data after apply it.
| 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.
| Tax || Lookup || To select the tax code.
Line 25: Line 25:
<br />
<br />


===GST Listing-Main Data===
===GST Listing-Summary===
:1. Select the date range or GST Process
::[[File: GST-GST ListingV1-03.jpg| 800px]]
:2. Select the tax if you would like to get a particular tax code GST listing.
<br />
:3. Click on '''APPLY'''.
:1. '''Double click''' on the tax code (eg. SR) in the Summary.
:4. See the below screenshot.  
:2. It will auto filter the GST transactions by tax code (SR) in the Details.
::[[File: GST-GST Listing-03.jpg| 30PX]]
::[[File: GST-GST ListingV1-03a.jpg| 800px]]
<br />
:3. '''Deselect''' the tax code (SR), click on the X button. See the screenshot below.
::[[File: GST-GST ListingV1-03b.jpg| 800px]]
<br />
<br />


===GST Listing-Detail Data===
===GST Listing-Detail===
:1. Point on the '''Tax Type''', eg. SR.
::[[File: GST-GST ListingV1-04.jpg| 800px]]
:2. You can see the breakdown detail in documents level. See the below screenshot.
<br />
::[[File: GST-GST Listing-04.jpg| 30PX]]
:1. '''Find Panel''' is very useful to search in any columns by the keywords entered by you.
::[[File: GST-GST ListingV1-04b.jpg| 400px]]
<br />
:2. It help to search the transactions contain the keywords, eg. '''"UPKEEP", "TX" or "ZP"'''. You just need to enter the keywords directly with a space in between each keywords. See the screenshot below.
::[[File: GST-GST ListingV1-04c.jpg| 800px]]
<br />
 
==Find Panel Helper==
:1. With this function, you can easily narrow down the search to identify the errors before the GST Returns submission.
:2. Let said I wish to find the word '''UPKEEP'''.
:3. Type the '''UPKEEP''' in the find panel.
::[[File: GST-GST ListingV1-04d.jpg| 800px]]
<br />
:4. If you want to '''exclude''' the '''BL''' tax code, then you have to enter as '''UPKEEP -BL''' in the find panel.
::[[File: GST-GST ListingV1-04e.jpg| 800px]]
<br />
 
:'''Explanation of Extended Search Syntax :'''
::{| class="wikitable"
|-
! Example Search Syntax !! Filter Operator !! Explanation
|-
| apple pineapple mango || OR || Any transaction lines contains apple, pineapple, '''OR''' mango will be search out.
|-
| apple +pineapple || AND || Transaction lines which have combination of apple '''AND''' pineapple will be search out.
|-
| apple -mango || EXCLUDE || Transaction lines which have the word apple but '''EXCLUDE''' mango. Result is apple and pineapple will be search out.
|-
| "pineapple apple" || EXACT WORD || Search for the exact words of '''"pineapple apple"'''.
|}
'''NOTE:'''
Spacing is very important to make your search more accurate.
<br />
<br />


Line 42: Line 76:
:1. Click on '''Preview'''.
:1. Click on '''Preview'''.
:2. Select a report to preview or print or export.
:2. Select a report to preview or print or export.
::[[File: GST-GST Listing-05.jpg| 30PX]]
::[[File: GST-GST ListingV1-05.jpg| 800px]]
<br />
<br />


Line 53: Line 87:
| 02 || GST Detail 2 || To show the '''document item details 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.
| 03 || GST Detail 3 - GST F5-(SG) || For Singapore GST, 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
| 04 || GST Detail 3 - GST-03 || For Malaysia GST, to show the '''GST-03 details''' in GST Listing.
|-
|-
| 05 || GST Lampiran 2 || GST form '''not compulsory''' to print and submit. It is upon as requested by RMCD.
| 05 || GST Detail 4 - Mixed Supplies || Applicable to Mixed Supplies. To show the calculations for DmR and Longer Period Adjustment.
|-
|-
| 06 || GST Listing - Yearly GST Analysis || To analyse the '''yearly''' tax amount and taxable amount.
| 06 || GST Lampiran 2 || GST detail listing for standard rated. It is upon as requested by RMCD.
|-
|-
| 07 || GST Summary Sheet - MY || GST Summary Sheet format.
| 07 || GST Lampiran 2-with ZR || Another GST detail listing for the standard rated and zero rated separately.
|-
| 08 || GST Lampiran 4 - Ringkasan Maklumat Permohanan Tuntutan Pelepasan Hutang Lapuk || Lampiran 4 as requested by Kastam Officer
|-
| 09 || GST Listing - Yearly GST Analysis || To analyse the '''yearly''' tax amount and taxable amount.
|-
| 10 || GST Summary Sheet - MY || GST Summary Sheet format.
|-
| 11 || GST-Lampiran B-0 PT GST Bil 2B (ATS) (IS) || A special GST detail listing for Approved Trader Scheme (Refer to GST-03 item 14 & 15).
|-
| 12 || GST-Penyata Eksport (ZRE) || A special GST detail listing for Zero Rated Export supply (Refer to GST-03 item 11).
|-
| 13 || GST-Penyata Pembekalan Dikecualikan (ES & IES) || A special GST detail listing for Exempted Supplies (refer to GST-03 item 12).
|-
| 14 || GST-Penyata Pembekalan Tempatan Berkadar Sifar (ZRL) || A special GST detail listing for Zero Rated Local supply (refer to GST-03 item 10).
|}
|}
<br />
<br />
Line 72: Line 120:
  4. _D = Annual Adjustment TX-RE
  4. _D = Annual Adjustment TX-RE
  5. _X = Realised Gain Loss
  5. _X = Realised Gain Loss


==Pivot Table==
==Pivot Table==
:1. Select the '''date range''' or '''GST Process'''. Click '''Apply'''.
:1. Right click on any of the grid columns.
::[[File: GST-GST Listing-06.jpg]]
:2. From the menu, select '''Pivot Table'''.
::[[File: GST-GST ListingV1-06.jpg| 800px]]
<br />
<br />
:2. On the right bottom corner, you can see a word '''Pivot Table'''. Click on it.
:3. At Pivot Table, there are 3 sections as below:  
::[[File: GST-GST Listing-07.jpg]]
:: a. '''Data Fields ''' - Data field will auto inserted when you launch the pivot table.
<br />
:3. Pivot Grid. Available grid data to be use to structure the pivot reporting. See the screenshot below.
::[[File: GST-GST Listing-08.jpg]]
<br />
: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.
:: b. '''Row Fields ''' - To structure the grouping for Rows.
:: c. '''Column Fields''' - To structure the grouping for Columns.
:: c. '''Column Fields''' - To structure the grouping for Columns.
::[[File: GST-GST Listing-09.jpg]]
::[[File: GST-GST ListingV1-08.jpg|600px]]
<br />
:5. Drag and drop the '''Local Amt''' into the '''Data Fields''' to display the local amount.
::[[File: GST-GST Listing-10.jpg]]
<br />
:6. '''Local Amt''' will be display under Grand Total column. See the screenshot below.
::[[File: GST-GST Listing-11.jpg]]
<br />
:7. '''1st Grouping at row''', drag and drop the '''Tax Type''' into the ''Row Fields''' to display the tax type.
::[[File: GST-GST Listing-12.jpg]]
<br />
: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.
::[[File: GST-GST Listing-13.jpg]]
<br />
: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.
::[[File: GST-GST Listing-14.jpg]]
<br />
: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.
::[[File: GST-GST Listing-16.jpg]]
<br />
<br />
 
:3. Use the grid columns to structure the pivot format. See the screenshot below.
'''TIPS:'''
::[[File: GST-GST ListingV1-07.jpg|600px]]
You right click on the row field to '''Expand All'''.
::[[File: GST-GST Listing-15.jpg]]
<br />
 
: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.
::[[File: GST-GST Listing-17.jpg]]
<br />
<br />
: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.
:4. Drag the grid column into Row fields or Column fields.
::[[File: GST-GST Listing-19.jpg]]
::[[File: GST-GST ListingV1-09.jpg|800px]]
<br />
<br />


  '''TIPS:'''
  '''Hint 1:'''
  You right click on the row field to '''Expand All'''.
  1. Right click on the '''Row Field'''
  ::[[File: GST-GST Listing-18.jpg]]
2. Select '''Expand All'''.
  [[File: GST-GST ListingV1-10.jpg|600px]]
  <br />
  <br />


:13. If you want to show the breakdown for '''Local Tax Amount''' by the multiple grouping at row.
'''Hint 2:'''
:14. Just drag and drop the '''Local Tax Amt''' into the ''Data Fields'''.
1. Right click on the grey area.  
::[[File: GST-GST Listing-20.jpg]]
2. A small menu pop out.
<br />
[[File: GST-GST ListingV1-11.jpg|600px]]
:12. '''Local Tax Amt''' will be display under Grand Total column. See the screenshot below.
  a. '''Show Field List''' - Not really use to it.
::[[File: GST-GST Listing-21.jpg]]
  b. '''Show Prefilter Dialog''' - Insert filter conditions.
<br />
  c. '''Print Grid''' - To print the grid.
  d. '''Grid Export''' - To export the grid data into EXCEL, TEXT, HTML and XML.


==See also==
==See also==
* [[New GST Return]]
* [[New GST Return]]
* [[Open GST Return]]
* [[Open GST Return]]

Latest revision as of 03:05, 14 January 2017

Introduction

To generate a summary and details of the GST transactions after process the GST Returns. It is easy to cross check against with GST-03.

GST Listing

[GST | Print GST Listing...]

GST-GST ListingV1-01.jpg


GST Listing-Parameter

GST-GST ListingV1-02.jpg


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


GST Listing-Summary

GST-GST ListingV1-03.jpg


1. Double click on the tax code (eg. SR) in the Summary.
2. It will auto filter the GST transactions by tax code (SR) in the Details.
GST-GST ListingV1-03a.jpg


3. Deselect the tax code (SR), click on the X button. See the screenshot below.
GST-GST ListingV1-03b.jpg


GST Listing-Detail

GST-GST ListingV1-04.jpg


1. Find Panel is very useful to search in any columns by the keywords entered by you.
GST-GST ListingV1-04b.jpg


2. It help to search the transactions contain the keywords, eg. "UPKEEP", "TX" or "ZP". You just need to enter the keywords directly with a space in between each keywords. See the screenshot below.
GST-GST ListingV1-04c.jpg


Find Panel Helper

1. With this function, you can easily narrow down the search to identify the errors before the GST Returns submission.
2. Let said I wish to find the word UPKEEP.
3. Type the UPKEEP in the find panel.
GST-GST ListingV1-04d.jpg


4. If you want to exclude the BL tax code, then you have to enter as UPKEEP -BL in the find panel.
GST-GST ListingV1-04e.jpg


Explanation of Extended Search Syntax :
Example Search Syntax Filter Operator Explanation
apple pineapple mango OR Any transaction lines contains apple, pineapple, OR mango will be search out.
apple +pineapple AND Transaction lines which have combination of apple AND pineapple will be search out.
apple -mango EXCLUDE Transaction lines which have the word apple but EXCLUDE mango. Result is apple and pineapple will be search out.
"pineapple apple" EXACT WORD Search for the exact words of "pineapple apple".
NOTE:
Spacing is very important to make your search more accurate.


Reports

1. Click on Preview.
2. Select a report to preview or print or export.
GST-GST ListingV1-05.jpg


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 F5-(SG) For Singapore GST, To show the GST-03 details in GST Listing.
04 GST Detail 3 - GST-03 For Malaysia GST, to show the GST-03 details in GST Listing.
05 GST Detail 4 - Mixed Supplies Applicable to Mixed Supplies. To show the calculations for DmR and Longer Period Adjustment.
06 GST Lampiran 2 GST detail listing for standard rated. It is upon as requested by RMCD.
07 GST Lampiran 2-with ZR Another GST detail listing for the standard rated and zero rated separately.
08 GST Lampiran 4 - Ringkasan Maklumat Permohanan Tuntutan Pelepasan Hutang Lapuk Lampiran 4 as requested by Kastam Officer
09 GST Listing - Yearly GST Analysis To analyse the yearly tax amount and taxable amount.
10 GST Summary Sheet - MY GST Summary Sheet format.
11 GST-Lampiran B-0 PT GST Bil 2B (ATS) (IS) A special GST detail listing for Approved Trader Scheme (Refer to GST-03 item 14 & 15).
12 GST-Penyata Eksport (ZRE) A special GST detail listing for Zero Rated Export supply (Refer to GST-03 item 11).
13 GST-Penyata Pembekalan Dikecualikan (ES & IES) A special GST detail listing for Exempted Supplies (refer to GST-03 item 12).
14 GST-Penyata Pembekalan Tempatan Berkadar Sifar (ZRL) A special GST detail listing for Zero Rated Local supply (refer to GST-03 item 10).


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. Right click on any of the grid columns.
2. From the menu, select Pivot Table.
GST-GST ListingV1-06.jpg


3. At Pivot Table, there are 3 sections as below:
a. Data Fields - Data field will auto inserted when you launch the pivot table.
b. Row Fields - To structure the grouping for Rows.
c. Column Fields - To structure the grouping for Columns.
GST-GST ListingV1-08.jpg


3. Use the grid columns to structure the pivot format. See the screenshot below.
GST-GST ListingV1-07.jpg


4. Drag the grid column into Row fields or Column fields.
GST-GST ListingV1-09.jpg


Hint 1:
1. Right click on the Row Field
2. Select Expand All.
GST-GST ListingV1-10.jpg

Hint 2:
1. Right click on the grey area. 
2. A small menu pop out.
GST-GST ListingV1-11.jpg
 a. Show Field List - Not really use to it.
 b. Show Prefilter Dialog - Insert filter conditions.
 c. Print Grid - To print the grid.
 d. Grid Export - To export the grid data into EXCEL, TEXT, HTML and XML.

See also