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

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:

Example to enter the GST Past Documents

Financial Start Period and System Conversation Date

[Tools | Options...General Ledger]

1. Let's said under the Tools | Options... I have set the following:-

Financial Start Period : 01 Jan 2016

System Conversion Date : 01 Feb 2016 (Cut-off Date for Opening Entry)

2. See below screenshot:

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:

Screenshot 2: Past Payment:

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	a. Customer / Customer Payment... b. Refer the above step 1.

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

1. Open the past tax invoice document.

2. To assign the tax code (SR/ZRL/ZRE/TX/IM...etc) and tax amount for past document. Press CTRL + ALT + G...

3. Save it.

4. See screenshot below.

Screenshot 3: GST Taxable:

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.
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.
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.