GST updates in 1.3.3.21

Top  Previous  Next

(From version 1.3.3.021 onwards.)

 

AutoCount Accounting version 1.3.3.021

 

First of all, as from 1st match, 2010, AutoCount Accounting and AutoCount Accounting Express version 1.3.3.021 is compliant with the requirement set out in the e-Tax Guide by Inland Revenue Authority of Singapore (IRAS); including the function of generating a standard file known as the “IRAS Audit File (IAF)”

 

 

Changes made in GST functions:

 

(1) Tools > Options > General > Goods and Services Tax: a new option called ‘Must Specify Tax Type’ is added, which will be checked by default, it means the system will not allow users to save any document/ entry with unassigned tax type.    *for Singapore version, users are not allowed to uncheck this option.

 

 

new001

 

 

 

(2) General Maintenance > Tax Type Maintenance: to select the classification of tax type, either Supply or Purchase.

 

 

new002

 

 

 

(3) When you upgrade your AutoCount Accounting or AutoCount Express from version 1.3.3.20 to 1.3.3.21, the system will perform the following functions automatically.

 

1.Add a new column called SupplyPurchase in TaxType table. This column will contain either ‘S’ (Supply) or ‘P’ (Purchase), which means every tax type can be classified either belong to Supply (means Sales) or Purchase.
2.To make the above changes compliant with existing tax type maintenance and transacted entries, the system will search for all tax types that were used in both Supply and Purchase:
a)First of all, all existing tax types will be classified as Supply;
b)Secondly, the tax types will be duplicated under classification of Purchase (to differentiate from Supply, the tax codes are added with suffix of 0, 1, 2, and etc);
c)Thirdly, those purchase transactions will be updated with new tax type code.

 

(The following screens illustrate the changes)

 

Before upgrading to version 1.3.3.021,

 

Tax Type Maintenance (without classification of Supply/Purchase):

 

new003

 

 

And the purchase related entries (e.g. A/P Invoice Entry) are assigned with common tax type (without classification of Supply/Purchase):

 

 

new004

 

 

 

Having upgraded to version 1.3.3.021,

 

Upon first time logon, the following message will be prompted:

 

new005

 

 

Tax Type Maintenance (new tax types are generated, with classification of Supply/Purchase):

 

 

new006

 

 

 

And the purchase related entries (e.g. A/P Invoice Entry) are updated with Purchase tax type..

 

 

new007

 

 

 

You may change the tax type code at Tools > Change Code > Change Tax Type

 

 

new008

 

 

 

 

(4) Generate IRAS Audit File (for Singapore users)

 

1.This function is available only when:
a.Use Goods & Services Tax (Tax Type) is checked (at Tools > Options > General > Goods and Services Tax)
b.The account book is registered For Singapore use only
c.Access rights are assigned… (General Maintenance > User Maintenance > Assess Rights > General Ledger > Generate IRAS Audit File)
 
 
2. Maintain IRAS Tax Code
 

Go to File > Generate IRAS Audit File

 

new009

 

 

Click on Maintain IRAS Tax Code:

 

 

new010

 

 

This is to link the user-defined Tax Type to a standardized IRAS Tax Code.
For each of the Tax Type, click to assign its matching IRAS Purchase Tax Code or IRAS Supply Tax Code.

 

new011

new012

 

 

(You may click on Save Setting As to save the current IRAS tax code setting or Load Setting to load from an earlier saved IRAS tax code setting.)
 
Click on Save, Yes.

 

 

 

3. Tax Transactions Inquiry
 
Define the date range (Start Date should be the first day of a beginning month and End Date should be the last day of the ending month)
 
Then click on Inquiry:

 

new013

 

Click on Purchase Info tab to display all purchase transaction within the specified date range.
Click on Sales Info tab to display all sales transaction within the specified date range.
Click on GL Info tab to show all general ledger transaction within the specified date range.
  *Permit No: = Cargo Clearance Import Permit Number

 

 

4. Generate IRAS Audit File
 

IRAS Audit File can be generated in 2 formats:

a. XML file (.xml): which is Extensible Markup Language file format

b. Text file (.txt): which is in Text file format
 

Select the file format to be generated, then click on Generate IAF

 

new014

 

 

You will be prompted with ‘Where do you want to save the IRAS file?’ windows, assign a folder and click on Save.

 

new015

 

new016

 

 

You may click on Yes to open and view the generated file:

 

IRAS Audit File in XML format

 

new017

 

 

IRAS Audit File as Text format

 

new018

 

 

 

5.  Produce GST Return Form
 

The system can produce GST F5 Return Form and GST F7 Return Form with those values generated in IRAS Audit File.

Click on GST F5 Return or GST F7 Return tab.

 

new019

 

 

This message is prompted to indicate the current report is not calculated for Partial Exempt Trader.
Just click on OK to continue.

 

new020

new021

 

GST F5
Box1: Total value of standard-rated supplies (IRAS Tax Code = ‘ST’)
Box2: Total value of zero-rated supplies (IRAS Tax Code = ‘ZR’)
Box3: Total value of exempt supplies (IRAS Tax Code = ‘ES33’ and ‘ESN33’)
Box4: Total value of (Box1 + Box2 + Box3)
Box5: Total value of taxable purchases (Total of purchase value at ‘PurchaseValueSGD’ field)
      (IRAS Tax Code = ‘TX7’, ‘IM’, ‘ME’, ‘BL’, ‘NR’, ‘ZP’, ‘EP’, ‘OP’, ‘E33’, ‘EN33’, ‘RE’)
Box6: Output tax due (Total of GST value on supply at ‘GSTValueSGD’ field)
Box7: Input tax and refunds claimed (Total of GST value on purchase ‘GSTValueSGD’ field exclude IRAS
          Tax Code‘BL’)
Box8: Total value of (Box6 – Box7)
Box9: Total value of taxable purchases with IRAS Tax Code ‘ME’

 

 

 

new022

new023

 

GST F7

Box1: Total value of standard-rated supplies (IRAS Tax Code = ‘ST’)

Box2: Total value of zero-rated supplies (IRAS Tax Code = ‘ZR’)

Box3: Total value of exempt supplies (IRAS Tax Code = ‘ES33’ and ‘ESN33’)

Box4: Total value of (Box1 + Box2 + Box3)

Box5: Total value of taxable purchases (Total of purchase value at ‘PurchaseValueSGD’ field)

 (IRAS Tax Code = ‘TX7’, ‘IM’, ‘ME’, ‘BL’, ‘NR’, ‘ZP’, ‘EP’, ‘OP’, ‘E33’, ‘EN33’, ‘RE’)

Box6: Output tax due (Total of GST value on supply at ‘GSTValueSGD’ field)

Box7: Input tax and refunds claimed (Total of GST value on purchase ‘GSTValueSGD’ field

          exclude IRAS Tax Code‘BL’)

Box8: Total value of (Box6 – Box7)

Box11: Total value of taxable purchases with IRAS Tax Code ‘ME’

 

 

 

_____________________________________________________________

Send feedback about this topic to AutoCount. peter@autocountSoft.com

© 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.