Updating Sales and Purchase Ledgers for GST Compliance

If many items you sell have the same tax rate, specify the tax rate and other GST details in your sales ledger. Similarly, if the items you purchase have the same tax rates, update your purchase ledger.

If you sell items with multiple tax rates, you can still maintain a single sales ledger, and record all GST details at the stock item or stock item or stock group level. You can create a single purchase ledger similarly.

  • Updating a Sales Ledger
  • Updating a Purchase Ledger

Updating a Sales Ledger

To update a sales ledger

1.    Go to Gateway of Tally > Accounts Info. > Ledgers > Alter > select the sales ledger.

2.    Is GST Applicable – Applicable.

3.    Set/alter GST Details – Yes, specify the details in the GST Details screen, and save. Alternatively, you can use a classification to use the tax details defined in the classification.

To view the history of tax rate changes, press Alt + L.

To specify further GST-related details, click F12: Configure.

4.    Select the Type of supply. By default the type of supply is set to Goods.

5.    Press Ctrl + A to save.

Updating a Purchase Ledger

To create a purchase ledger

     Follow the steps used for updating the sales ledger, with the nature of transaction and rates for purchase.

While recording a sale or purchase transaction, you can select the respective ledger.

Updating Stock Items and Stock Groups for GST Compliance

If the items you sell have different tax rates, update your stock item masters or stock groups with the applicable GST rates, and select the type of supply, as applicable.

  • Updating a stock item
  • Updating a stock group

Updating a stock item

In case you need different tax rates for different items, modify the stock items to include the applicable tax rates.

To update a stock item

1.    Go to Gateway of Tally > Inventory Info. > Stock Items > Alter > select the item.

2.    Set/alter GST Details: Yes to specify the details in the GST Details screen, and save.

Integrated Tax: When you enter the integrated tax, state tax and central tax are calculated as half of the integrated tax specified. You can change state tax or central tax by using F12 configuration.

Note: If you have modified the tax rates before, press Alt + L to view the history of tax rate changes.

3.    Select the Type of supply.

4.    Press Ctrl + A to save.

Updating a stock group

In case you need the same tax rates for the items in a stock group, modify the group to include tax applicability and rates.

To update a stock group

1.    Go to Gateway of Tally > Inventory Info. > Stock Groups > Alter > select the group.

2.    Set/alter GST Details: Yes to specify the details in the GST Details screen, and save.

Integrated Tax: When you enter the integrated tax, state tax and central tax are calculated as half of the integrated tax specified. You can change state tax or central tax by using F12 configuration.

3.    Press Ctrl + A to save.

Setting Up GST Rates in Tally.ERP 9

Quickly set up GST rates for your company, stock item-wise or stock group-wise, using the GST Rate Setup option. You must enable GST in your company to provide GST rates. You can set up GST rates at the company level, stock group level, stock item level, ledger group level, and ledger level.

To set GST rates for stock groups and stock items

1.    Go to Gateway of Tally > Display > Statutory Reports > GST > GST Rate Setup.

Note: Brackets indicate that tax rates are captured from the company or stock group level.

2.    Select the stock group or stock item, and press Alt+S to provide the applicable tax rates. You can press Spacebarto select multiple stock groups or stock items. Set the tax rates and save.

The rate entered for integrated tax will be equally divided between central tax and state tax.

To view the history of tax rate changes, press Alt + L.

To specify further GST-related details, click F12: Configure.

Activating GST for Your Company

To use Tally.ERP 9 for GST compliance, you need to activate the GST feature. Once activated, GST-related features are available in ledgers, stock items, and transactions, and GST returns can be generated.

To activate GST

1.    Open the company for which you need to activate GST.

2.    Press F11 > F3.

3.    Enable Goods and Services Tax (GST) – Yes.

4.    Set/alter GST details – Yes.

State: Displays the state you have selected for your company. Helps in identifying local and interstate transactions. If you change the state, it will be updated in the company details.

5.    Specify the GSTIN/UIN for the business. This can be printed in the invoices as required. You can specify this later.

6.    Specify Applicable from date. GST will be applicable for your transactions from this date onwards.

You can record transactions using the ledgers with GST details, and print invoices with GSTIN.

If required, deactivate other taxes like VAT, as applicable. For this, open the corresponding tax details screen and specify the Deactivate from date

How are Imports and Exports Treated in GST

How-are-imports-and-exports-treated-in-GST-704x286

Taxation laws have laid down the taxes applicable on import and export of goods and services. In the current tax regime, laws of Customs duty, Excise, Service Tax and VAT lay down the tax treatment of imports and exports. In the GST regime, Excise, Service Tax and VAT will be subsumed into GST and customs duty will continue to be levied separately. Let us understand the tax implication on imports and exports under GST in comparison to the current regime.

Current Regime

Import of goods

In the current regime, a person who imports goods has to pay customs duty, countervailing duty (CVD), and special additional duty (SAD). CVD is levied at a rate equivalent to the rate of Excise on such goods, if they had been manufactured in India. SAD is equivalent to VAT on the goods in India. CVD and SAD are imposed to bring the imported product’s price to its true market price in India. If the importer uses the imported goods to manufacture dutiable goods in India or provide taxable services, CVD paid on inputs is available as tax credit. If the importer is just a trader, CVD on imports is not available as credit. SAD paid on import is eligible for refund, subject to conditions. However, no credit is given on customs duty paid and it becomes a cost for the importer.

Let us see an example to understand the levy of import duties in case of import of goods in the current regime.

Example: Manoj Apparel in Bangalore, Karnataka purchases apparel from a supplier, Oz Designs, in Sydney, Australia.

Tax calculation

Particulars Nos. Price per no. (Rs.) Amount(Rs.)
Women’s T-shirts 200 2,500 (51.68 AUD) * 5,00,000
Men’s T-shirts 100 5,000 (103.37 AUD) * 5,00,000
Total 300 10,00,000
Customs duty @ 10%       1,00,000
Customs education cess @ 3% on customs duty (1,00,000*3%)             3,000
Sub total     11, 03,000
CVD @ 12.5%       1,37,875
Sub total     12,40,875
SAD @ 4%          49,635
Total cost of import     12,90,510

* Exchange rate taken is 0.021 AUD = 1 Rupee

Import of services

A person who imports services has to pay Service Tax on the imported service at the Service tax rate applicable in India. The importer can claim tax credit of the Service Tax paid on imports.

For example: Rajesh Apparels in Hyderabad, Telengana, avails fashion designing services of Rs. 50,00,000 from Kaushi Designs in Colombo, Sri Lanka.

Tax calculation

Particulars Amount (Rs.)
Fashion designing services   50,00,000
Service Tax @14%     7,00,000
Krishi Kalyan Cess @0.5%        25,000
Swachh Bharat Cess @0.5%        25,000
Total cost of import  57,50,000

Exports

In the current regime, export of goods and services is zero rated, i.e. rate of tax on exports is 0%. An exporter can also claim refund of the tax paid on inputs used to manufacture/purchase/provide the exported goods or services.

GST Regime

Import of goods

In the GST regime, a person who imports goods has to pay customs duty and IGST. The difference here is that CVD and SAD levied on imports in the current regime will be replaced by IGST under GST. IGST will be levied at the rate applicable to the imported goods in India. An importer can claim full tax credit of IGST paid on imports. Hence, importers who were unable to claim credit of CVD or SAD in the current regime can now claim full tax credit of the IGST paid on imports. However, no tax credit will be given on customs duty paid and it remains a cost for the importer under GST also.

Let us take an example to understand the levy of import duties in case of import of goods in the GST regime.

Example: Manoj Apparel in Bangalore, Karnataka purchases apparel from a supplier, Oz Designs, in Sydney, Australia.

Tax calculation

Particulars Nos. Price per no. (Rs.) Total Price (Rs.)
Women’s T-shirts 200 2,500    (51.68 AUD) *   5,00,000
Men’s T-shirts 100 5,000    (103.37 AUD) *   5,00,000
Total 300 10,00,000
Customs duty @ 10%        1,00,000
Education cess @ 3% on customs duty (10,000*3%)              3,000
Sub total     11,03,000
IGST @18% **       1,98,540
Total cost of import     13,01,540

* Exchange rate taken is 0.021 AUD = 1 Rupee
**Assuming GST rate of 18% on apparel.

Import of Services

Under GST, a supply will be considered as an import of service when-

  1. The supplier of the service is located outside India.
  2. The recipient of the service is located in India and
  3. The place of supply of the service is in India.

For example: Rajesh Apparels in Hyderabad, Telengana, avails fashion designing services of INR 50,00,000 from Kaushi Designs in Colombo, Sri Lanka

Location of supplier: Colombo, Sri Lanka

Location of recipient: Hyderabad, Telengana

Place of supply: Place of supply will be the location of the recipient, i.e. Hyderabad, Telengana.

Hence, this supply is an import.

Tax calculation

Particulars Amount (Rs.)
Fashion designing services   50,00,000
IGST @ 18%*     9,00,000
Total cost of import  59,00,000

* Assuming GST rate of 18% on fashion designing services

Exports

Under GST, exports will be zero rated, similar to the current regime. An exporter can also claim refund of the tax paid on inputs used to manufacture/purchase/provide the exported goods or services.

Export of services

Specific conditions have been laid down for a supply to be considered an export of service under GST. These are:

  1. The supplier of the service is located in India.
  2. The recipient of the service is located outside India.
  3. The place of supply of the service is outside India
  4. The payment for the service has been received by the supplier in convertible foreign exchange and
  5. The supplier and recipient are not establishments of the same person.

For example: Rohan Consultants in Mumbai, Maharashtra, provides business consultancy services to Abey’s Engineering in Singapore. The payment for the service has been received in Singapore Dollars.

Here,

Location of supplier: Mumbai, Maharashtra

Location of recipient: Singapore

Place of supply: Place of supply will be the location of the recipient, i.e. Singapore.

Payment for the service: Payment for the service has been received in convertible foreign exchange, i.e. Singapore Dollars.

Relationship between the supplier and recipient: The supplier and recipient are distinct persons.

Hence, this supply qualifies as an export of service. Rate of tax on the supply will be 0%.

Export of service under GST

The levy of taxes and treatment of taxes in case of imports and exports largely remain the same under GST in comparison with the existing laws. In case of an importer, full input credit will be available on the IGST paid on imports and additional input credit will be available on the GST paid on all types of inputs used or intended to be used in the course of or for the furtherance of business. Similarly, in the case of an exporter, refund will be given on the tax paid on all inputs used in the course of business. Overall, costs of import and export are expected to reduce under GST and compliance is expected to become easier with the convergence of multiple tax laws into one law.

What are the Accounts and other Records you should Maintain under GST

Banner_GST-AccountsRecords_1

Accounts and records are the primary source of data for any organization’s financial reporting. Every law of Direct and Indirect Tax in our country also mandates that information in a prescribed manner has to be captured and preserved for a certain period of time. These accounts and records form the basis for returns filed by tax payers under each law.

Current regime

In the current indirect tax regime, every tax law mandates certain accounts and records of transactions to be maintained for a specific period of time, apart from the regular books of accounts.

Under Excise, the general records to be maintained are the RG-1 register (Daily stock account of excisable goods), Form IV register (Register of receipt or issue of raw material), invoice book and job work register

Under Service Tax, the suggested records include the bill register, receipt register, debit/credit notes register, CENVAT credit register, etc

Under VAT, the records to be maintained include purchase records, sales records, stock records, VAT account containing details of input and output tax, works contract account, etc

These records are required to be retained for at least 5 years from the end of the financial year in which they were effected.

GST regime

Under GST, the activities of manufacture, provision of taxable service and sale of goods will have a common law and hence, businesses can now maintain consolidated information which was maintained separately earlier.

Under GST, every registered taxable person is required to maintain correct accounts of the following details at the principal place of business specified in the registration certificate: –

  1. Manufacture of goods
  2. Inward and outward supply of goods and/or services
  3. Stock of goods
  4. Input tax credit availed
  5. Output tax payable and paid

If more than one place of business is specified in the registration certificate, accounts relating to each place of business must be kept at the respective places.

Maintaining books and records in electronic form will be ideal and convenient for accurate and timely compliance under GST.

Persons whose turnover during the financial year exceeds Rs. 1 crore

In addition to maintaining the accounts specified above, a registered person whose turnover during the financial year exceeds Rs. 1 crore is required to,

  • Get the accounts audited by a Chartered Accountant or Cost Accountant and
  • Submit a copy of the audited annual accounts and a reconciliation statement in Form GSTR- 9B while filing the annual return in Form GSTR-9.

In the reconciliation statement, the Chartered Accountant or Cost Accountant is required to certify that the value of supplies declared in the annual return reconciles with the audited annual financial statement.

Persons owning or operating a warehouse or godown

An owner or operator of a warehouse or godown or any other place used for storage of goods, irrespective of whether he is registered or not, is required to maintain records of the consignor, consignee and other details which are yet to be prescribed in the law.

How long should accounts and records be retained?

Every registered person is required to retain accounts and records for 5 years from the due date of filing of annual return for the year to which the accounts and records pertain.

For example: For accounts and records pertaining to Financial Year ’17-’18, annual return must be filed by 31st December ’18. These accounts and records must be retained till 31st December ’23.

Tally.ERP 9 Series A Release 5.5.2, February 2017

The new Tally.ERP 9 Release 5.5.2 is available now!

Whats new in Tally.ERP 9 Release 5.5.2

  • During certain licensing and product upgrade activities, Tally.ERP 9 had to be restarted manually in administrator mode. Now, Tally.ERP 9 will restart automatically in administrator mode if you have administrator rights. If you do not have administrator rights, you need to provide your Windows administrator user name and password to restart Tally.ERP 9 in administrator mode.
  • While splitting data, Tally.ERP 9 now recognizes excise duty classifications defined using earlier versions of Tally

Release 5.5.2 – Highlights

Telangana VAT and CST

  • Release 5.5.2 supports the latest format of Telangana VAT Form 200 and CST Form VI (for Purchase and Sales).

TDL:

  • Enjoy the newly supported data source types Rule Set, Num Set, and Flag Set, to populate data to a collection using the attribute Data Source

Accounting

  • In the Voucher Type Alteration screen after enabling the option Use advanced configuration?, under the columns Prefix Details and Suffix Details:
    • If a date was entered under the column Applicable From, and
    • If the column Particulars was left blank, the prefix and suffix details entered for the previous period was displayed for the subsequent periods.
  • This issue is resolved.
  • While recording or altering a voucher in single entry mode, if a line item was removed by pressing Ctrl+D, the preceding or succeeding line item was deleted. This issue is resolved.
  • When exported vouchers were imported, the voucher numbers were not retained. This occurred if the option Overwrite vouchers, instead of duplicating, during import? was enabled in F12: Configuration, and Automatic (Manual Override) method of numbering was selected, in the Voucher Type master.This issue is resolved.
  • In an invoice, if the party ledger selected was enabled with multiple mailing details, and predefined with the mailing name of another ledger, the Address Type of the other ledger was displayed in the Party Details screen.

This issue is resolved. Now, in addition to ledger mailing name, the corresponding ledger name is also displayed in the List of Address Types of the Party Details screen.

  • During verification of vouchers for audit, if the sampling method was set as manual sampling by clicking S: Set Manual Sampling in the Voucher Register report, the text Manually Sampled was not displayed against the voucher. This issue is resolved.

Banking

  • While configuring cheque printing by selecting the User Defined format for a bank ledger, the top and bottom lines for A/c Payee in the cheque was not displayed. This issue is resolved.

  • In the Bank Reconciliation screen, while creating a voucher for an unreconciled transaction imported from the bank statement, the field Transaction Type was displaying Cheque in case of payments and Cheque/DD in case of receipts if a different transaction type was set in the ledger master. This issue is resolved.

  • For DBS Bank, when you printed the Bank Reconciliation report, the Particulars column was blank in the print. This issue is fixed, and the Particulars column displays the values as seen in the report.

Payroll

  • An error file with the message Invalid found on line numbers was being generated while uploading the ECR text file. This was occurring as separator characters were getting added at the end of each line in the ECR text file. This issue is resolved.

Click here for release notes

Click here for download

Tally.ERP 9 Series A Release 5.5, January, 2017

The new Tally.ERP 9 Release 5.5 is available now!

Whats new in Tally.ERP 9 Release 5.5

  • Release 5.5 provides important improvements relating to the VAT, Payroll, and the overall product experience in your Tally.ERP 9.

Release 5.5 – Highlights

VAT

  Chhattisgarh, Himachal Pradesh, Jharkhand, and Uttarakhand: New statutory Experience

  • Generate accurate forms and annexures with ease. Also, experience faster exception handling. View and verify Included, Not-relevant and Incomplete transactions seamlessly. Enjoy the flexibility of defining tax rates at various levels, and create user-defined classifications.

Karnataka: Enhanced VAT Experience

  • If you have been using the VAT module in Tally. ERP 9 5.x series to file returns, you will be delighted with the speed with which you can now resolve exceptions. You can group exceptions item-wise or ledger-wise, and resolve multiple exceptions together.

    With Release 5.5 you can,

    o      Use the new Nature of Transactions that define goods at 0% CST against Form C.

    o      Filter e-Sugam voucher details as per the latest notification by the Commercial Taxes Department and as per invoice values defined by you.

    o      Maintain voucher totals even with transactions with discounts.

    o      Experience seamless CST apportionment and accurate voucher totals as CST amount is now added to purchase cost while making inter-state transactions.

Chandigarh: New template supported

  • Export Form VAT 15 as per the latest version (AMM_VAT15(CH).xlsx) prescribed by the Excise and Taxation department.

Haryana: Revised template supported

  • Export invoice-wise details of interstate branch and consignment transfers in the latest format TEMPLATE-VAT-RETURN-R1-LP5-LIST_OF_GOODS_IMPORTED.xls prescribed by the Excise and Taxation department. Click here to understand the changes in the revised template.

Delhi: Commodity details for labour charges collected made optional

  • From Release 5.5 onwards, you can skip entering the commodity name and code details for labour charges collected. This will not be listed as an exception on exporting the annexures from Form D VAT 16.

Payroll

  • New ESI monthly wage threshold of Rs. 21,000 is supported.

  • The revised format of the e-Challan Report (ECR) with support for Universal Account Number (UAN) is provided.

 

Click here for release notes

Click here for download