AutoCount Accounting Version 1.8.25 Release Note

Introduction

This version of AutoCount 1.8.25 Accounting is a maintenance release for version 1.8. Some of the improvements implemented in this version are:

  • GST Enhancement

Improvements Introduced

GST Enhancement

With the release of the revised version of the Guide on Accounting Software Enhancement towards GST Compliance (Revised as at 01 August 2016), several changes has been made to the AutoCount Accounting software with regards to the GST function. Below are the changes implemented into the system.

Changes to the Tax Codes

Several changes has been implemented to the tax codes used in AutoCount Accounting. When updating to this version, the system will generate a file to show what changes is done to which tax code. The user can then save and open the file to review the changes done to the tax codes in AutoCount Accounting. One of the most minor changes is the discontinuation of the usage of the _ (underscore) symbol inside the tax code. All tax codes will instead now use the – (dash) symbol inside itself.

A major change to the tax code line up in AutoCount Accounting are the addition of new tax codes. The following table illustrates the new additions to the Supply Tax Codes.

Tax Code Description Rate Government Tax Code Special Note
ZDA Output Tax 0% – Zero Rated Supplies to Designated Area 0% ZDA
ZDA-CG Output Tax 0% – Zero Rated Supplies of Capital Goods to Designated Area 0% ZDA
SR-MS Output Tax 6% – Standard Rated Supplies under Margin Scheme 6% SR-MS
SR-JS Output Tax 6% – Standard Rated Supplies under Jeweller Scheme 6% SR-JS While available, the system does not support the Jeweller Scheme at the time of writing.
OS-ER Output Tax 0% – Out of Scope Supplies for Enforcement and Regulatory functions 0% OS-ER
OS-OV Output Tax 0% – Out of Scope Supplies between overseas country with other overseas country 0% OS-OV
NS Output Tax 0% – Non-supply 0% NS

 

The following is the new addition for the Purchase Tax Codes

Tax Code Description Rate Government Tax Code Special Note
RP Input Tax 0% – Relief 0% RP
TX-FRS Input Tax 2% – Purchase under Flat Rate Scheme 2% TX-FRS
TX-NC Input Tax 6% – GST incurred and choose not to claim the input tax. 6% TX-NC
TX-ER Input Tax 6% – To perform regulatory and enforcement functions by local authority or statutory body. 6% TX-ER
IM-RE Input Tax 6% – Import of Goods to make both taxable and exempt supplies 6% IM-RE
NP Input Tax 0% – Purchase treated as Non-supply 0% NP

 

Other than the new additions, some updates is also applied to some of the original tax codes. Below is the table describing the changes done to the Supply Tax Codes.

Tax Code Description Rate Government Tax Code Special Note
GS Output Tax 0% – Disregarded Supplies 0% GS The GST-03 Mapping is updated to Field 13.
IES/td> Output Tax 0% – Incidental Exempt Supplies 0% IES Replaces the old tax code ES43
ES-GU Output Tax 0% – Exempt Supplies Of Land For General Use 0% ES Replace the old tax code ES_LGU
OS-OVT Output Tax 0% – Out of Scope Supplies Of Oversea which are taxable in Malaysia 0% OS Replace the old tax code OS_O
SR-CG Output Tax 6% – Disposal of business assets 6% SR Replace the old tax code SR_C
ZRE-CG Output Tax 0% – Zero Rated Supplies Of Capital Goods (Exports) 0% ZRE Replace the old tax code ZRE_C
OS-CG Output Tax 0% – Out Of Scope Supplies Of Capital Goods 0% OS Replace old tax code OS_C
RS-CG Output Tax 0% – Relief Supplies Of Capital Goods 0% RS Replace the old tax code RS_C
GS-CG Output Tax 0% – Disregarded Supplies Of Capital Goods 0% GS Replace the old tax code GS_C
ES-CG Output Tax 0% – Exempt Supplies Of Capital Goods 0% ES Replace the old tax code ES_C

 

The following shows the changes done to the Purchase Tax Codes

Tax Code Description Rate Government Tax Code Special Note
TX-CG Input Tax 6% – Capital Goods Acquired To Make Taxable Supplies 6% TX-CG Replace the old tax code TX_C
TX-ES Input Tax 6% – To make Non-Incidental Exempt Supplies 6% TX-ES Replace the old tax code TX-N43
TX-IES Input Tax 6% – To make Incidental Exempt Supplies 6% TX-IES Replace the old tax code TX-E43
IM-CG Input Tax 6% – Import of Capital Goods 6% IM-CG Replace the old tax code IM_C
IS-ATMS Recipient self-accounting done by local customer under the ATMS 0% Remove the government tax code associated to it
TX-IES-CG/td> Input Tax 6% – Capital Goods Acquired To make Incidental Exempt Supplies 6% TX-IES Replace the old tax code TX-E43_C
TX-ES-CG Input Tax 6% – Capital Goods Acquired To make Non-Incidental Exempt Supplies 6% TX-ES Replace the old tax code TX-N43_C
TX-RE-CG Input Tax 6% – Residual Input Tax of Capital Goods 6% TX-RE Replace the old tax code TX-RE_C

New GST-03 Mapping

With the addition and changes done to the tax code line up, the GST-03 mapping is also updated to reflect the changes. The following table illustrates the changes:

Field Description Tax Code
5a Total Value of standard rate supply SR, SR-MS, DS
5b Total Output tax (inclusive of tax value on bad debt recovered & other adjustments) SR, SR-MS, DS, AJS
6a Total value of standard-rate and flat rate acquisition TX, TX-IES, TX-RE, IM-RE, IM, TX-CG, TX-ER, TX-FRS, IM-CG, TX-ES(if pass de minimis rule)
6b Total input tax (inclusive of tax value on bad debt relief & other adjustments) TX, TX-IES, IM, TX-CG, TX-ER, TX-FRS, IM-CG, AJP, TX-ES(if pass de minimis rule)
10 Total value of local zero-rated supplies ZRL, ZDA
11 Total value of export supplies ZRE
12 Total value of exempt supplies ES, IES
13 Total value of supplies granted GST relief RS, GS
14 Total value of goods imported under approved trade scheme IS
15 Total value of GST suspended under item 14 IS * 6%
16 Total value of capital goods acquired TX-CG, IM-CG, TX-RE-CG, TX-IES-CG, TX-ES-CG(if pass de minimis rule)
17 Total value of bad debt relief inclusive tax AJP-ARBD
18 Total value of bad debt recovered inclusive tax AJS-ARBD

Imported Service and ATMS Journal Entry

Previously the Imported Service and ATMS Journal Entry generation allows for user to either choose to generate the journal entry for either making Taxable Supply or Non-Taxable Supply. In this version of AutoCount Accounting a new option is added that allows user to choose to generate the journal entry for making both Taxable and Non-Taxable Supply.

The new option for Imported Services Journal Entry

The new option for Imported Services Journal Entry

The new option for ATMS Journal Entry

The new option for ATMS Journal Entry

Lampiran B-0 (ATS)

A new GST Attachment report is added into the system. This report known as Lampiran B-0 (ATS) is used by user who are under the ATS (Approved Trader Scheme). Before using this report the user must first enter their No. SPL information at the GST Setting window under the Special Scheme tab.

The No. SPL field

The No. SPL field

Lampiran B-0 (ATS)

Lampiran B-0 (ATS)

Export Lampiran to Excel in GST Return/GST Instant Info

Previously the Export Lampiran 2 in Excel only allows the user to export the Lampiran 2 format to Excel. Now that button has been renamed to Export Lampiran to Excel. This change is because the user can now export 2 lampiran format to Excel which are Lampiran 2 and the newly added Lampiran B-0 (ATS) as mentioned above.

The Export Lampiran to Excel button and the selection available for users

The Export Lampiran to Excel button and the selection available for users

GAF File Changes

The GAF File has also been updated to meet the latest specification set by RMCD. Some of the changes done to it are as follows:

  1. The introduction of Header record for each record type. These Header record is just contains the Header names of each element of the record.
  2. The addition of 2 new element in the P record. These 2 elements are the Supplier GST Number and Posting Date. The Supplier GST Number is linked to the GST Registration number of the company from which the purchase is made(if any) while the Posting Date is linked to the Tax Date of the document.
  3. 2 new element is also added to the S record. These are the Customer GST Number and the Export Declaration Number. The Customer GST Number is linked to the GST Registration number of the company from which supply was made(if any) and the Export Declaration Number(e.g Customs Form No. 2) is linked to the GST Permit No in the AutoCount System.
  4. 1 new element is added to the L record and it is the Account Type. There are three type of account type for this element which are Profit and Loss (PL), Balance Sheet (BS) and Retained Earning (RE).

 Note: Any GST Return done before applying this update will only generate the first version of the GAF file. If the user is required to generate the latest version, they may either have to reset the GST Processor and redo it again or use the GST Instant Info and select the period to generate the GAF file for. It is highly recommended to use the second way as it will remove the issue of data inconsistency (e.g forgetting which bad debt was claimed). 

Changes to the Partial Exemption Module

There are also some changes applied to the Partial Exemption Module. One of these changes is that the IM-RE tax code is also added in the longer period determination. Another changes is applied to the IRR formula and the De Minimis rules formula. Previously there is the T1 and T2 column in the Partial Exemption maintenance. Both columns are now merged into 1 column which is the Value of Taxable Supplies (T) column. The following tax codes are now considered in the columns for Partial Exemption:

Column Government Tax Code System Tax Code
Value of Taxable Supplies (T) SR, SR-MS, ZRL, ZRE, DS, RS, GS, ZDA, OS-ER, OS-OV OS-OVT, OS-CG
Value of Exempt Supplies (E) ES, IES
Value of Excluded Taxable Supplies (O1) SR-CG, ZRE-CG, RS-CG, GS-CG, ZDA-CG, OS-CG, DS-ATMS, DS-I
Value of All Excluded Supplies (O2) IES SR-CG, ZRE-CG, ES-CG, ES-GU, RS-CG, GS-CG, ZDA-CG, OS-CG, DS-ATMS, DS-I

Bugs Fixed and Minor Enhancement

Among the newer bugs fixed and minor enhancement introduced in AutoCount Accounting version 1.8 are:

  1. Fix Bug: Fix a bug in Assembly Request Processing which generates Stock Assembly with an empty description.
  2. Fix Bug: Fix the code calling sequence of OnFormInquiry event in Monthly Sales Analysis and Monthly Purchase Analysis.
  3. Fix Bug: Fix a bug in Document Item Transaction Listing in which the Unit Price column is incorrect when the amount entered in the Invoice and Purchase Invoice is Inclusive GST.
  4. Enhancement: Support Audit Trail for Pos Price Plan.
  5. Fix Bug: Fix a bug in Debit Note Entry in which the Subtotal cannot display the default amount.
  6. Enhancement: Add Withholding Tax Function in Cash Book document.
  7. Enhancement: GST Tax Code changes to follow new guidelines.