Migration System Features-How to handle the GST Past Documents Opening Balance for Customer and Supplier: Difference between revisions

From eStream Software
 
(43 intermediate revisions by the same user not shown)
Line 7: Line 7:


:'''Overview of the GST Past Documents for Customer and Supplier:'''<br />
:'''Overview of the GST Past Documents for Customer and Supplier:'''<br />
:[[File:Opening GST Flow Chart-01.jpg | 40PX]]
:[[File:Opening GST Flow Chart-01.jpg | 440PX]]
<br />
<br />


Line 14: Line 14:
''[Tools | Options...General Ledger]''<br />
''[Tools | Options...General Ledger]''<br />


:1. Let's said under the Tools | Options... I have set the following:-<br />
:1. Let's said the company GST reporting period is '''Monthly'''. Under the Tools | Options... set the following:-<br />
:: '''Financial Start Period''' : 01 Jan 2016<br />
:: '''Financial Start Period''' : 01 Jan 2016<br />
:: '''System Conversion Date''' : 01 Feb 2016 (Cut-off Date for Opening Entry)<br />
:: '''System Conversion Date''' : 01 Feb 2016 (Cut-off Date for Opening Entry)<br />
'''NOTE:'''
It is not recommended to set the '''System Conversion Date fall within the quarterly GST reporting period.
Lets said the company GST reporting period is '''Quarterly'''.
                      GST effective date :''' 01 April 2015'''
You should set the '''System Conversion Date: 01 April 2016''' or next quarter start date (ie. '''01 July 2016''').


:2.  See below screenshot:<br />
:2.  See below screenshot:<br />
Line 29: Line 36:
::[[File:Opening GST-Effective Date.jpg | 440PX]]<br />
::[[File:Opening GST-Effective Date.jpg | 440PX]]<br />
<br />
<br />
'''Important:'''
It is very important to set the GST Effective Date where the GST commerce date started.
Bad debt relief will based on the GST Effective date.
<br />
For example,  '''GST effective date set on 1 April 2015''' and '''system conversion date is 1 Jan 2016'''.
Pass document dated in 15 July 2015 '''(it is after the GST effective date)'''.
Therefore, the Bad Debt Relief will be process in GST Returns-Jan 2016 automatically.


===Enter the Past Documents (AR & AP)===
===Enter the Past Documents (AR & AP)===
Line 54: Line 69:
| style="vertical-align: top;" | To enter the Supplier Past Tax Invoice || a. Go to Supplier / Supplier Invoice...<br /> b. Refer the above step 1.
| style="vertical-align: top;" | To enter the Supplier Past Tax Invoice || a. Go to Supplier / Supplier Invoice...<br /> b. Refer the above step 1.
|-
|-
| style="vertical-align: top;" |  To enter the Customer Past Non-Refundable Deposit || a. Customer / Customer Payment...<br /> b. Refer the above step 1.<br /> c. Tick the Non-Refundable checkbox.
| style="vertical-align: top;" |  To enter the Customer Past Non-Refundable Deposit (for SR, ZRL, ZRE) || a. Customer / Customer Payment...<br /> b. Refer the above step 1.<br /> c. Tick the Non-Refundable checkbox (for SR only).<br /> d. Untick the Non-Refundable checkbox (for ZRL & ZRE).


|}<br />
|}<br />
Line 61: Line 76:
:1. Open the past tax invoice document.<br />
:1. Open the past tax invoice document.<br />
:2. '''Press CTRL + ALT + G...'''. You able to assign the tax code (SR / ZRL / ZRE / TX / IM...etc), the taxable amount (eg. Rm 1,000.00) and the tax amount (eg. Rm 60.00) for past document. <br />
:2. '''Press CTRL + ALT + G...'''. You able to assign the tax code (SR / ZRL / ZRE / TX / IM...etc), the taxable amount (eg. Rm 1,000.00) and the tax amount (eg. Rm 60.00) for past document. <br />
'''Note: '''
Document must be saved before '''press CTRL + ALT + G'''.
:3. Save it.
:3. Save it.
:4. See screenshot below.<br />
:4. See screenshot below.<br />


: '''Screenshot 3: GST Taxable:'''
: '''Screenshot 3: GST Taxable:'''
::[[File:Opening GST-Taxable-01.jpg | 140PX]]<br />
::[[File:Opening GST-Taxable-02.jpg | 140PX]]<br />
<br />
<br />


Line 73: Line 90:
! Action !! Where to Enter?
! Action !! Where to Enter?
|-
|-
| style="vertical-align: top;" | To enter GST Taxable for the Customer Past Tax Invoice || a. Go to Customer / Customer Invoice...<br /> b. Refer the above step 1.<br /> c. Tax code commonly apply to this matter is '''SR / ZRL / ZRE / SL_AJP-BD (for bad debt relief claimed as input tax in old system)'''.
| style="vertical-align: top;" | To enter GST Taxable for the Customer Past Tax Invoice || a. Go to Customer / Customer Invoice...<br /> b. Refer the above [[Migration_System_Features-How_to_handle_the_GST_Past_Documents_Opening_Balance_for_Customer_and_Supplier#Enter_the_GST_Taxable_for_Past_Documents_.28AR_.26_AP.29|step 1]].<br /> c. Tax code commonly apply to this matter is '''SR / ZRL / ZRE / SL_AJP-BD (for bad debt relief claimed as input tax in old system)'''.
|-
|-
| style="vertical-align: top;" | To enter GST Taxable for the Supplier Past Tax Invoice || a. Go to Supplier / Supplier Invoice...<br /> b. Refer the above step 1. <br /> c. Tax code commonly apply to this matter is '''TX / IM / PH_AJS-BD (for bad debt relief paid as output tax in old system)'''.
| style="vertical-align: top;" | To enter GST Taxable for the Supplier Past Tax Invoice || a. Go to Supplier / Supplier Invoice...<br /> b. Refer the above [[Migration_System_Features-How_to_handle_the_GST_Past_Documents_Opening_Balance_for_Customer_and_Supplier#Enter_the_GST_Taxable_for_Past_Documents_.28AR_.26_AP.29|step 1]]. <br /> c. Tax code commonly apply to this matter is '''TX / IM / PH_AJS-BD (for bad debt relief paid as output tax in old system)'''.
|-
|-
| style="vertical-align: top;" | To enter GST Taxable for the Customer Past Non-Refundable Deposit || a. Go to Customer / Customer Payment...<br /> b. Refer the above step 1. <br /> c. Tax code commonly apply to this matter is '''SR'''.
| style="vertical-align: top;" | To enter GST Taxable for the Customer Past Non-Refundable Deposit || a. Go to Customer / Customer Payment...<br /> b. Refer the above [[Migration_System_Features-How_to_handle_the_GST_Past_Documents_Opening_Balance_for_Customer_and_Supplier#Enter_the_GST_Taxable_for_Past_Documents_.28AR_.26_AP.29|step 1]]. <br /> c. Tax code commonly apply to this matter is '''SR'''.
|}<br />
|}<br />


Line 90: Line 107:
::[[File:Opening GST-Taxable-Listing.jpg | 140PX]]<br />
::[[File:Opening GST-Taxable-Listing.jpg | 140PX]]<br />
<br />
<br />


==GST Returns==
==GST Returns==
Line 150: Line 166:
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Tax Date !! Tax !! Taxable Amount !! Local Tax Amount !! SubTotal
! Tax !! Taxable Amount !! Local Tax Amount !! SubTotal
|-
|-
| 10 Aug 2015 || SR || style="text-align:right;"| 902.92 || style="text-align:right;"| 54.17 || style="text-align:right;"| 957.09
| SR || style="text-align:right;"| 902.92 || style="text-align:right;"| 54.17 || style="text-align:right;"| 957.09
|}
|}
:::OR  
:::OR  
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Tax Date !! Tax !! Taxable Amount !! Local Tax Amount !! SubTotal
! Tax !! Taxable Amount !! Local Tax Amount !! SubTotal
|-
|-
| 10 Aug 2015 || SR || style="text-align:right;"| 902.92 || style="text-align:right;"| 54.17 || style="text-align:right;"| 957.09
| SR || style="text-align:right;"| 902.92 || style="text-align:right;"| 54.17 || style="text-align:right;"| 957.09
|-
|-
| 10 Aug 2015 || ZRL || style="text-align:right;"| 902.91 || style="text-align:right;"| 0 || style="text-align:right;"| 902.91
| ZRL || style="text-align:right;"| 902.91 || style="text-align:right;"| 0 || style="text-align:right;"| 902.91
|-
|-
| ||  ||  || Total Outstanding || style="text-align:right;"| 1,860.00
| ||  || Total Outstanding || style="text-align:right;"| 1,860.00
|}<br />
|}<br />
:: See example of '''past GST taxable''' in below screenshot.<br />
:: See example of '''past GST taxable''' in below screenshot.<br />
::[[File:Opening GST-PastDoc-03b.jpg | 140PX]]<br />
::[[File:Opening GST-PastDoc-03c.jpg | 140PX]]<br />
<br />
<br />


Line 189: Line 205:
::OR Date: '''20 April 2015'''
::OR Date: '''20 April 2015'''
::Knock-Off Amount: '''200.00'''
::Knock-Off Amount: '''200.00'''
::Bad Debt Relief:  
::Bad Debt Relief detail from outstanding invoice:  
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Tax Date !! Tax !! Local Amount !! Local Tax Amount
! Tax !! Local Amount !! Local Tax Amount
|-
|-
| 31 Oct 2015 || AJP-BD || style="text-align:right;"| 902.92 || style="text-align:right;"| 54.17
| AJP-BD || style="text-align:right;"| 902.92 || style="text-align:right;"| 54.17
|}
|}
:c. Payment #2:
:c. Payment #2:
::OR Date: '''01 Nov 2015'''
::OR Date: '''01 Nov 2015'''
::Knock-Off Amount: '''400.00'''
::Knock-Off Amount: '''400.00'''
::Bad Debt Recover:  
::Bad Debt Recover details:  
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Tax Date !! Tax !! Local Amount !! Local Tax Amount
! Tax !! Local Amount !! Local Tax Amount
|-
|-
| 01 Nov 2015 || AJS-BD || style="text-align:right;"| 194.18 || style="text-align:right;"| 11.65
| AJS-BD || style="text-align:right;"| 194.18 || style="text-align:right;"| 11.65
|}
|}
:d. Invoice Outstanding: '''1,460.00'''
:d. Invoice Outstanding: '''1,460.00'''
Line 223: Line 239:
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Tax Date !! Tax !! Taxable Amount !! Local Tax Amount !! SubTotal
! Tax !! Taxable Amount !! Local Tax Amount !! SubTotal
|-
|-
| 31 Oct 2015 || SL-AJP-BD || style="text-align:right;"| 708.74 || style="text-align:right;"| 42.52 || style="text-align:right;"| 751.26
| SL-AJP-BD || style="text-align:right;"| 708.74 || style="text-align:right;"| 42.52 || style="text-align:right;"| 751.26
|}<br />
|}<br />
  '''NOTE: '''
  '''NOTE: '''
  User is not allowed to key-in payment #1 and payment #2 in SQL Account.  
  User no need to key-in the payment #1 and payment #2 in SQL Account.  
  Outstanding Taxable amount = 902.92 (Payment #1) - 194.18 (Payment #2) = '''708.74'''
  Outstanding Taxable amount = 902.92 (Payment #1) - 194.18 (Payment #2) = '''708.74'''
  Bad debt relief not recover = 54.17 (Payment #1) - 11.65 (Payment #2) = '''42.52'''
  Bad debt relief not recover = 54.17 (Payment #1) - 11.65 (Payment #2) = '''42.52'''
  '''Any current payment knock-off to the above invoice will automatically treat as bad debt recover in next taxable period.'''
  '''Any current payment knock-off to the above invoice will automatically treat as bad debt recover in next taxable period.'''
:: See example of '''past GST taxable''' in below screenshot.<br />
:: See example of '''past GST taxable''' in below screenshot.<br />
::[[File:Opening GST-PastDoc-04b.jpg | 140PX]]<br />
::[[File:Opening GST-PastDoc-04c.jpg | 140PX]]<br />


==See also==
==See also==

Latest revision as of 07:29, 27 February 2017

How to handle the GST Past Documents Opening Balance for Customer and Supplier?


Introduction

This guide will teach you the way to handle the past outstanding documents for Customer and Supplier from previous accounting system. We are ensure that the data migration part go smooth with GST matters happened in previous system likes bad debt relief and non-refundable deposit.


Overview of the GST Past Documents for Customer and Supplier:
440PX


How to enter the GST Past Documents?

Financial Start Period and System Conversation Date

[Tools | Options...General Ledger]

1. Let's said the company GST reporting period is Monthly. Under the Tools | Options... set the following:-
Financial Start Period : 01 Jan 2016
System Conversion Date : 01 Feb 2016 (Cut-off Date for Opening Entry)
NOTE:
It is not recommended to set the System Conversion Date fall within the quarterly GST reporting period.
Lets said the company GST reporting period is Quarterly.
                      GST effective date : 01 April 2015
You should set the System Conversion Date: 01 April 2016 or next quarter start date (ie. 01 July 2016).

2. See below screenshot:
440PX


GST Effective Date

[GST | GST Effective Date...]

1. Let's assume the company is GST registered at 01 April 2015.
2. See below screenshot:
440PX


Important:
It is very important to set the GST Effective Date where the GST commerce date started.
Bad debt relief will based on the GST Effective date. 

For example, GST effective date set on 1 April 2015 and system conversion date is 1 Jan 2016. Pass document dated in 15 July 2015 (it is after the GST effective date). Therefore, the Bad Debt Relief will be process in GST Returns-Jan 2016 automatically.

Enter the Past Documents (AR & AP)

1. Create new customer/supplier invoice.
2. Enter the Invoice No.
3. Enter the Original Invoice Date. Date before the system conversation date, the document will converted to "Past Invoice" automatically.
4. Enter the Outstanding Invoice Balance into Total.
5. Save it.
6. See screenshot below.
Screenshot 1: Past Invoice:
140PX


Screenshot 2: Past Payment:
140PX


7. Take note to the below table.
Action Where to Enter?
To enter the Customer Past Tax Invoice a. Go to Customer / Customer Invoice...
b. Refer the above step 1.
To enter the Supplier Past Tax Invoice a. Go to Supplier / Supplier Invoice...
b. Refer the above step 1.
To enter the Customer Past Non-Refundable Deposit (for SR, ZRL, ZRE) a. Customer / Customer Payment...
b. Refer the above step 1.
c. Tick the Non-Refundable checkbox (for SR only).
d. Untick the Non-Refundable checkbox (for ZRL & ZRE).

Enter the GST Taxable for Past Documents (AR & AP)

1. Open the past tax invoice document.
2. Press CTRL + ALT + G.... You able to assign the tax code (SR / ZRL / ZRE / TX / IM...etc), the taxable amount (eg. Rm 1,000.00) and the tax amount (eg. Rm 60.00) for past document.
Note: 
Document must be saved before press CTRL + ALT + G.
3. Save it.
4. See screenshot below.
Screenshot 3: GST Taxable:
140PX


5. Take note to the below table.
Action Where to Enter?
To enter GST Taxable for the Customer Past Tax Invoice a. Go to Customer / Customer Invoice...
b. Refer the above step 1.
c. Tax code commonly apply to this matter is SR / ZRL / ZRE / SL_AJP-BD (for bad debt relief claimed as input tax in old system).
To enter GST Taxable for the Supplier Past Tax Invoice a. Go to Supplier / Supplier Invoice...
b. Refer the above step 1.
c. Tax code commonly apply to this matter is TX / IM / PH_AJS-BD (for bad debt relief paid as output tax in old system).
To enter GST Taxable for the Customer Past Non-Refundable Deposit a. Go to Customer / Customer Payment...
b. Refer the above step 1.
c. Tax code commonly apply to this matter is SR.

Past Documents GST Taxable Listing

[GST | Print GST Taxable Listing (Manual)...]

1. Select the date range to apply.
 date from (GST effective date) and date to (before the system conversion date).
2. See screenshot below.
Screenshot 4: GST Taxable Listing:
140PX


GST Returns

[GST | New GST Return...]

1. Select the date range. See screenshot below.
a. Monthly (eg. 01/02/2016 - 29/02/2016)
140PX
b. Quarterly (eg. 01/02/2016 - 30/04/2016)
140PX
2. Click to Process.
3. Past GST transactions will generated automatically after click Process. See below screenshot.
140PX
Tips:
To check the past GST listing, click on GST Listing button.
4. Current GST Returns will be processed at the same times. See below screenshot.
140PX



SPECIAL CASES

Case 1: Claim bad debt relief based on the outstanding in SQL Accounting

1. Old System
a. Invoice:
Invoice No: IV-00001
Invoice Date: 10 Aug 2015
Invoice Doc Amount: 2,060.00
Invoice Details:
Tax Local Amount Local Tax Amount SubTotal
SR 1,000.00 60.00 1,060.00
ZRL 1,000.00 0.00 1,000.00
Total 2,060.00
b. Payment:
OR Date: 20 Aug 2015
Knock-Off Amount: 200.00
c. Invoice Outstanding: 1,860.00


2. SQL Account
a. Past Invoice:
Past Invoice No: IV-00001
Past Invoice Date: 10 Aug 2015
Past Invoice Total: 1,860.00
NOTE: 
User should key-in the total outstanding in the Past Invoice, eg. 2,060.00 - 200.00 = 1,860.00.
See example of past invoice in below screenshot.
140PX
b. Past GST Taxable Detail:
Tax Taxable Amount Local Tax Amount SubTotal
SR 902.92 54.17 957.09
OR
Tax Taxable Amount Local Tax Amount SubTotal
SR 902.92 54.17 957.09
ZRL 902.91 0 902.91
Total Outstanding 1,860.00

See example of past GST taxable in below screenshot.
140PX


Case 2: Bad debt relief claimed and partial recover in Old System; partial or fully recover in SQL Account

1. Old System
a. Invoice:
Invoice No: IV-00002
Invoice Date: 10 April 2015
Invoice Doc Amount: 2,060.00
Invoice Details:
Tax Local Amount Local Tax Amount SubTotal
SR 1,000.00 60.00 1,060.00
ZRL 1,000.00 0.00 1,000.00
Total 2,060.00
b. Payment #1:
OR Date: 20 April 2015
Knock-Off Amount: 200.00
Bad Debt Relief detail from outstanding invoice:
Tax Local Amount Local Tax Amount
AJP-BD 902.92 54.17
c. Payment #2:
OR Date: 01 Nov 2015
Knock-Off Amount: 400.00
Bad Debt Recover details:
Tax Local Amount Local Tax Amount
AJS-BD 194.18 11.65
d. Invoice Outstanding: 1,460.00


2. SQL Account
a. Past Invoice:
Past Invoice No: IV-00002
Past Invoice Date: 10 April 2015
Past Invoice Total: 1,460.00
NOTE: 
User should key-in the total outstanding in the Past Invoice, eg. 2,060.00 - 200.00 - 400.00= 1,460.00.
See example of past invoice in below screenshot.
140PX
b. Past GST Taxable Detail:
Tax Taxable Amount Local Tax Amount SubTotal
SL-AJP-BD 708.74 42.52 751.26

NOTE: 
User no need to key-in the payment #1 and payment #2 in SQL Account. 
Outstanding Taxable amount = 902.92 (Payment #1) - 194.18 (Payment #2) = 708.74
Bad debt relief not recover = 54.17 (Payment #1) - 11.65 (Payment #2) = 42.52
Any current payment knock-off to the above invoice will automatically treat as bad debt recover in next taxable period.
See example of past GST taxable in below screenshot.
140PX

See also