Data Management in Tally
GST Integration with Tally.ERP 9 Part I by Tally Expert
Latest Tally.ERP 9 Release 6 with GST
What is GST
GST- Ready Tally.ERP 9 Release 6
GST is India’s single largest tax reform since independence. GST aims to help replace the federal tax structure with a more unified one to help reduce the cascading tax on tax impact, and remove the barriers to trade across state boundaries.
Highlights
You can quickly get started with GST in a few easy steps
Start Using Tally.ERP 9 for GST Compliance
To record a GST transaction, you have to activate GST and also update or create the required ledgers.
To use Tally.ERP 9 for GST compliance,
1.    Activate GST
2.    Set up tax rates
Note: You can find the list of HSN codes/SAC on the website of the department of revenue.
3.    Update or create ledgers as required.
Depending on the business requirements you will need to update the following ledgers, either immediately or later.
â—Â Â Â Â Â Update stock items, and stock groups to include GST details.
â—Â Â Â Â Â Update sales and purchase ledgers to use in GST transactions.
â—Â Â Â Â Â It is recommended that you restart voucher numbering for GST transactions to ensure that unique voucher numbers are used for all your vouchers. If Automatic (Manual Override) is set as the method of voucher numbering, it ensures that unique voucher numbers are set for your vouchers.
â—Â Â Â Â Â Update party GSTIN/UIN for parties buying from you or selling items to you.
â—Â Â Â Â Â Create GST tax ledgers to calculate taxes in transactions.
â—Â Â Â Â Â Create income and expense ledgers to distribute the expenses and incomes against items appropriately.
Your company is ready with all the masters. You can use TE9 for transactions.
â—Â Â Â Â Â Recording Sales
â—Â Â Â Â Â Recording Purchases
Click here for release notes
Click here for download
How to record Purchase Invoice under GST
Once you activate GST in your company, you can record the purchase of goods and services that attract GST using a purchase voucher. Ensure that you provide unique voucher numbers for your purchase vouchers, and use a new series of voucher numbering.
- Local purchase
- Interstate purchase
Local purchase
The purchase of goods or services from a supplier in the same state attracts central tax and state tax.
To record a local purchase transaction
1.    Go to Gateway of Tally > Accounting Vouchers > F9: Purchase.
Supplier invoice no.: Displays the sales invoice no. of the supplying party.
Date: Displays the date on which the sales invoice was passed by the supplier.
2.    In Party A/c name, select the supplier’s ledger or the cash ledger.
3.    Select the purchase ledger applicable for local taxable purchases.
4.    Select the required items, and specify the quantities and rates.
5.    Select the central and state tax ledgers.
You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.
Interstate Purchase
The purchase of goods or services from a supplier from another state attracts integrated tax.
To record an interstate purchase
â—Â Â Â Â Â Follow the steps used for recording a local purchase transaction, with the following changes:
o     Select the purchase ledger applicable for interstate purchases.
o     Select the integrated tax ledger.
Depending on the location of the supplier, you can record a local or interstate purchase transaction with the applicable GST rates.
How to record Sales Invoice under GST and Printing the Invoice
Once you activate GST in your company, you can record the sale of goods and services that attract GST using a sales voucher. Ensure that you provide unique voucher numbers for your sales vouchers, and use a new series of voucher numbering.
- Local sales
- Printed invoice format
- Interstate sales
Local Sales
The sale of goods or services to customers in the same state attract central tax and state tax.
To record a local sales transaction
1.    Go to Gateway of Tally > Accounting Vouchers > F8: Sales.
2.    In Party A/c name, select the customer ledger or the cash ledger.
3.    Select the sales ledger.
4.    Select the required items, and specify the quantities and rates.
5.    Select the central and state tax ledgers.
You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.
6.    In the sales invoice, press Alt+P to print the invoice in the required format.
For multiple copies: Press Alt+P and then Alt+C to select the number of copies.
Printed Invoice Format
As per GST guidelines, details such as the applicable taxes and tax rates, and the GSTIN/UIN of the company and the customer will be captured. Depending on your requirements, you can include additional details in your invoice by clicking F12: Configure.
Interstate Sales
Sale of goods or services to a customer in another state attract integrated tax.
To record an interstate sale
â—Â Â Â Â Â Follow the steps used for recording a local sales transaction. The only difference is that you have to select the integrated tax ledger instead of central tax and state tax.
Depending on the location of the party, you can record a local or interstate sales transaction with the applicable GST rates, and print the invoice.
How to enable GST for Income and Expense Ledgers
Supply of goods or rendering of services may involve additional expenses, which can either form part of stock items or service value, or can be charged separately. When such an expense is recovered from customers, it becomes an income.
While accounting for expenses and incomes, the ledgers have to be grouped under Direct Expenses, Indirect Expenses, Direct Incomes or Indirect Incomes.
To create an expense or income ledger
1.    Go to Gateway of Tally > Accounts Info. > Ledgers > Create.
2.    In the option Appropriate to select,
o     Goods, if the expense or income value has to be included in the stock item cost.
o     Services, if the expense or income value has to be included in the service value.
o     Both, if the expense or income value has to be included in stock item cost or service value.
3.    Select the Method of Calculation based on the selection made for the option Appropriate to.
If the option Appropriate to is set to Goods, select the Method of Calculation as:
o     Based on Quantity, if the expense or income amount has to be distributed based on the quantity entered for each stock item in the invoice.
o     Based on Value, if the expense or income amount has to be distributed based on the value of each stock item or service selected in the invoice.
Note: If the option Appropriate to is set to Services or Both, the field Method of Calculation is skipped and the calculation is made based on the value entered for each stock item or service in the invoice.
Similarly, you can create income ledgers to record direct and indirect incomes.
How to restart Voucher Numbering in Tally.ERP 9
You can restart voucher numbering for any voucher type.
To restart voucher numbering
1.    Go to Gateway of Tally > Accounts Info. > Voucher Types > Create.
2.    Method of Voucher Numbering? – Automatic (Manual Override).
Note: For GST transactions, it is recommended that you restart voucher numbering to ensure that unique voucher numbers are used for all your vouchers. If Automatic (Manual Override) is set as the method of voucher numbering, it ensures that unique voucher numbers are set for your vouchers.
3.    Set the option Use Advance Configuration? to Yes.
4.    Press Enter to save. The Voucher Type Alteration (Secondary) screen appears as shown below:
â—Â Â Â Â Â Enter the number of the voucher in the Starting Number field.
â—Â Â Â Â Â Enter the required value in the Width of Numerical Part field.
â—Â Â Â Â Â Set the option Prefill with zero? to Yes, to add zero to the voucher number. If this option is set to No, the voucher number is left blank.
For example, if the Width of Numerical Part is specified as 3, and if Pre-fill with zero? is set to Yes, then the voucher number appears as Sales Invoice No: 001.
â—Â Â Â Â Â Enter the Applicable From date in the Restart Numbering column. You can specify more than one restart dates.
â—Â Â Â Â Â Select the required interval from the Types of Periods list in the Particulars field.
â—Â Â Â Â Â Define the Prefix Details in the Particulars field. Examples of prefix details are: Month of the voucher, i.e., Â April/, company information like ABC/, and even fixed number series like 1000.
Note: The numeric section begins immediately after the prefix information. Therefore, a slash (/) or some other special character is used to highlight a separation; for example, April/. The slash would cause the voucher number to appear as April/001, otherwise it would appear as April001. This simplifies fixed number series appearing, for example, as 200100001 where 2001 is the prefix, and 00001 is the starting number with a width of 5, and with leading zeros.
You can choose different prefix information for different periods, or you can continue with one. The prefix continues from the date mentioned under Applicable from to the date mentioned under Applicable from.
â—Â Â Â Â Â Define the Suffix Details for the voucher number. The same rules apply as that for Prefix Details.
5.    Press Enter to save.
The Sales Invoice voucher number appears as shown below:
How to update Party GSTIN/UIN in Tally.ERP 9
Quickly update the GSTIN/UIN details for your parties group-wise from the Update Party GSTIN/UIN report. You can also provide this at the individual party ledger level. Use the Import Party GSTIN tool to import GSTINs for several parties in one shot.
- Update Party GSTIN
- Import Party GSTIN
To update party GSTIN or UIN
1.    Go to Gateway of Tally > Display > Statutory Reports > GST > Update Party GSTIN/UIN.
2.    Select the group and ledger for which you want to update the GSTIN/UIN.
3.    In the Update Party GSTIN/UIN screen, enter the GSTIN/UIN number for each party.
Click F5 to toggle between Show All and Show Pending.
Show All: Lists all the parties.
Show Pending: Lists the parties with missing details, such as country, state, registration type, or GSTIN/UIN.
Once you have updated the GSTIN/UIN for your parties, you can print the GSTIN details in your invoices for filing returns.
Import Party GSTIN
The Import Party GSTIN add-on helps you update GSTIN details of all parties at once from Microsoft Excel. It is very useful if you have the GSTIN information of all parties outside Tally.ERP 9 and want to import the information to update the party ledgers in Tally.ERP 9.
Note: You need to export existing party information to MS Excel using Update Party GSTIN, and use this MS Excel file to fill in the GSTINs that you want to import.
To install the Import Party GSTIN add-on
1.    Download the Import Party GSTIN add-on from the Add-ons section here.
2.    In Tally.ERP 9, click F12: Configure > Product & Features > F4: Manage Local TDLs.
3.    In the TDL Configuration screen, set the option Load TDL files on startup to Yes.
4.    Specify the name of the add-on with the folder path containing the add-on in the field List of TDL files to preload on startup.
5.    Press Enter to save.
Import Party GSTIN appears under GST Reports.
To import party GSTIN details
1.    Go to Display > Statutory Reports > GST > Update Party GSTIN.
2.    Select All Items in the Name of Group and Name of Ledger fields in Select Group screen and press Enter. The Update Party GSTIN/UIN screen lists all parties without a GSTIN.
3.    Click Export to export the information in excel format.
4.    Open the exported file, specify GSTIN details for the parties, and save the file.
5.    In Tally.ERP 9, go to Display > Statutory Reports > GST > Import Party GSTIN.
6.    Specify the name of the MS Excel file to be imported with the path in the field Name of the file to be imported (Excel).
7.    Specify the name of the sheet containing information in MS Excel file in the field Sheet name.
8.    Press Enter to import.
When the import is completed, the MS Excel file opens and displays the message Data imported successfully.
Note: Ensure the party names are not altered in the MS Excel file exported from Tally.ERP 9. Also, the name of Country, State and Registration Type specified in the MS Excel file must match the spellings given in Tally.ERP 9.
To correct errors in the imported data
1.    Open the MS Excel file and check for a sheet called Errors. If this sheet is there, it means that some data was incorrect for some parties and has not been imported into Tally.ERP 9.
2.    Check and make necessary corrections in the Errors sheet. Save the file.
3.    Import the file again, and specify the sheet name as Errors. The corrected information is imported this time.