Tally For GST
Tally For GST
Tally For GST
2.GSTR-1
a. Returns Summary
b. Particulars (Computation Details)
c. Summary of Exceptions
d. Table-wise GSTR-1
e. Status Reconciliation
f. HSN Summary
g. Exporting GSTR-1
h. Challan Reconciliation
3.FAQ’S
For Tally Sales & Service Contact @
Shravan Kumar Varma 9014411112 / 9866039659
Ask Soft Tech - Hyderabad , 901441112 / 9866039659
Note: You can find the list of HSN codes/SAC on the website of the department of revenue.
Depending on the business requirements you will need to update the following ledgers, either
immediately or later.
● 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.
● Create income and expense ledgers to distribute the expenses and incomes against items
appropriately.
● Recording Sales
● Recording Purchases
To activate GST
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.
See also:
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 Spacebar to 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 create GST classification, enable the options Enable Goods and Services Tax (GST)? and
Set/alter GST details? in Statutory and Taxation features under F11: Features. In the
Company GST Details screen, enable the option Enable GST classification?.
1. Go to Gateway of Tally > Accounts Info. > Statutory Info. > GST Classifications >
Create.
2. Select the Nature of Transaction that is applicable for your goods or services.
3. Enter the rates applicable for Integrated Tax and Cess. The rate entered for integrated tax will
be equally divided between central tax and state tax.
You can specify further GST details for the GST classification by clicking F12: Configure.
You can create multiple classifications and group goods or services in specific categories, for
example, GST at 18%, exempt goods, zero-rated goods, and so on.
In case you need different tax rates for different items, modify the stock items to include the
applicable tax rates.
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.
Taxability: Select Taxable for goods and services that are classified as taxable type of supply under
GST. Select Exempt, if the type of supply is exempted from tax under GST, or select Nil Rated, if
the tax rate applicable to the type of supply is 0% under GST.
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.
The type of supply selected for a stock item is applicable only for that item. If multiple items with
varying type of supply configuration are selected in an item, the type of supply configured for one
item is not inferred for another.
In case you need the same tax rates for the items in a stock group, modify the group to include tax
applicability and rates.
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.
Taxability: Select Taxable for goods and services that are classified as taxable type of supply under
GST. Select Exempt, if the type of supply is exempted from tax under GST, or select Nil Rated, if
the tax rate applicable to the type of supply is 0% under GST.
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.
Non-GST Goods
Some goods such as petroleum crude, high-speed diesel, motor spirit (petrol), natural gas, aviation
turbine fuel and liquor fit for human consumption, are not covered under GST and hence are
classified as non-GST goods. In Tally.ERP 9 items can be set as non-GST goods.
1. In the GST Details screen of the stock item or stock group, click F12: Configure.
4. In the GST Details screen, set the option Is non-GST goods? to Yes to configure the
item/group as non-gst.
1. Go to Gateway of Tally > Accounts Info. > Ledgers > Alter > select the ledger.
Taxability: Select Taxable for goods and services that are classified as taxable type of supply under
GST. Select Exempt, if the type of supply is exempted from tax under GST, or select Nil Rated, if
the tax rate applicable to the type of supply is 0% under GST.
You can use this ledger to bill the services rendered by your business, in Accounting Inv
The HSN details, tax rate and type of supply selected in sales and purchase ledger will be applicable
to all items or services selected in a transaction where these ledgers are applied. The GST details and
type of supply configuration in the stock items will be overridden in the transaction with the details
configured in the sales/purchase ledger.
1. Go to Gateway of Tally > Accounts Info. > Ledgers > Alter > select the sales ledger.
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.
Taxability: Select Taxable, if sales ledger is used for supply of goods and services that are classified
as taxable under GST. Select Exempt, if it is used for sale of type of supply that is exempted from
tax under GST, or select Nil Rated, if it is used for sale of goods or services that attract 0% tax rate
under GST.
4. Select the Type of supply. By default the type of supply is set to Goods.
● 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.
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.
Once you have updated the GSTIN/UIN for your parties, you can print the GSTIN details in your
invoices for filing returns.
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.
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.
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.
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.
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.
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.
See Also
To account for the different taxes to be paid under GST (central tax, state tax, union territory tax,
integrated tax, and cess), you have to create a tax ledger for each tax type.
Similarly, you can create ledgers for state tax, integrated tax, and cess by selecting the relevant Tax
type under GST.
While accounting for expenses and incomes, the ledgers have to be grouped under Direct
Expenses, Indirect Expenses, Direct Incomes or Indirect Incomes.
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. For more information, refer to Using the option Allow method of appropriation.
Similarly, you can create income ledgers to record direct and indirect incomes.
In Tally.ERP 9, you can record sales in the item invoice mode or in the accounting invoice mode.
Local sales
Interstate sales
Local Sales
The sale of goods or services to customers in the same state attract central tax and state tax.
2. In Party A/c name, select the customer ledger or the cash ledger.
4. Select the required items, and specify the quantities and rates.
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.
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
● 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.
When you maintain only accounting transactions (but not inventory of your goods), or when your
company deals with services, you can use the accounting invoice mode for recording your local and
interstate sales.
3. Select the required goods/service ledgers, and specify the quantities and rates. Alternatively, press
Alt+C to create the ledgers.
4. Select the central and state tax ledgers for local sales and the integrated tax ledger for interstate
sales.
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. You have the choice of using item invoice or accounting
invoice according to your business requirements.
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.
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.
4. Select the required items, and specify the quantities and rates.
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.
● Follow the steps used for recording a local purchase transaction, with the following changes:
Depending on the location of the supplier, you can record a local or interstate purchase transaction
with the applicable GST rates.
3. Account: Select the bank from which the payment will be made.
4. Select the central and state tax ledgers. If you have to pay interest, penalty, late fee or other dues,
select the ledgers to make the payment. created to account for these dues. Ensure these ledgers are
grouped under Direct Expenses/Indirect Expenses/Current Liabilities.
6. Provide GST details: Enable this option to enter the bank details.
If the bank details are not available, you can enter them later in the Challan Reconciliation report.
7. In the Bank Allocations screen, select the ledgers, enter the amount and provide the payment
details.
Similarly, you can record other tax payments to be made to the GST department.
As GST is a new tax structure, the tax credits of previous tax regime will not be automatically carried
forward to the GST account. Based on the date from which you want to maintain the books of
accounts under GST, you need to carry forward the tax credit to state/central tax by recording a
journal voucher.
The tax credits of service tax, krishi kalyan cess and CENVAT has to be transferred to the central
tax ledger. The tax credit of VAT, additional tax, surcharge and cess has to be transferred to the
state tax ledger. Hence, two separate journal vouchers have to be recorded to account for the
opening balance of central and state taxes.
Note: You can also create a journal voucher from Gateway of Tally > Display > Statutory
Reports > GST > GSTR-1 or GSTR-2.
3. In the Stat Adjustment Details screen, select the options as shown below:
5. Transfer the tax credit of service tax and CENVAT to central tax ledger as shown below:
6. Transfer the tax credit of VAT to state tax ledger as shown below:
Note: Along with the VAT ledger, the cess/surcharge/additional tax ledger can be selected based
on the state for which the VAT transactions were recorded prior to implementation of GST.
Entering the tax credit as ledger opening balance for a new user or new business
starting from 1st July 2017
You can enter the balance of tax credit as the opening balance in central tax and state tax ledgers,
when your books beginning date is on 1st July 2017. However, it is recommended to record a
journal voucher as the tax credit can be transferred on or after 1st July 2017. Enter the closing
balance of:
● VAT or VAT with surcharge/cess/additional tax as the opening balance (debit balance) for state
tax ledger.
● CENVAT, service tax and krishi kalyan cess as the opening balance (debit balance) for central tax
ledger.
The opening balance entered for central tax and state tax/UT tax in ledger master or journal
voucher is a book entry and will not reflect in the reports.
To record purchases from an unregistered dealer, you need to update your party ledgers and create a
ledger for unregistered purchases.
Inward supply > Raise tax liability > Pay tax and file returns
Same month: Advance payments > Inward supply > Raise tax liability > Pay tax and file returns
Different months: Advance payments > Raise tax liability > Pay tax and file returns > Inward
supply in another month > Reverse the tax liability > File returns in the subsequent month
Same month: Exclude the advance payment voucher from the GSTR-2
Different month: Record a journal voucher to reverse the tax liability to the extent to which the
transaction is cancelled
Same month before raising liability for complete invoice value: Purchase invoice > Cancel the
invoice (press Ctrl+X to cancel) > File returns
Same month after raising liability: Purchase invoice > Raise tax liability and claim credit > Record a
debit note > Reverse the tax liability and tax credit to the extent of purchase returns > File returns
Different month: Record a debit note to the extent of purchase returns > Reverse the tax liability
and tax credit to the extent of purchase returns > File returns
1. Go to Gateway of Tally > Accounts Info. > Ledgers > Alter > select the ledger.
This ledger is to account for the purchases transactions from unregistered dealers.
o Taxability - Taxable.
o Is reverse charge applicable? - Yes. Press F12: Configure and set Enable reverse charge
calculation? to Yes.
Create a new bill reference when you are purchasing the goods from an unregistered dealer and then
making a payment. If you have made an advance payment, then you can adjust it against the
purchase invoice.
1. Go to Gateway of Tally > Accounting Vouchers > Accounting Vouchers > F9: Purchase.
Link the bill reference of the payment voucher (by selecting Agst Ref in the Bill-wise Details
screen) to the purchase invoice, if you have made an advance payment.
3. Click A: Tax Analysis > F1: Detailed to view the detailed Tax Analysis report that displays the
reverse charge amount.
When you make an advance payment to an unregistered dealer for goods due to be received on a
future date, you can record an advance payment voucher.
Note: Payment vouchers recorded without clicking V: Reverse Chrg. Adv. will not have GST
implications, and will form part of the Summary of Excluded Vouchers.
3. In Account, select the bank from which the payment will be made.
4. Select the party ledger predefined as unregistered dealer, and enter the details in the Advance
Payment Details screen.
Note: To categorise and display the stock item or ledgers attracting reverse charge in the Advance
Payment Details screen, set the option Enable reverse charge calculation? to Yes in the
Configuration screen of GST Details screen (displayed on enabling the option Set/alter GST
details? in the stock item or ledger master).
The tax type appears as integrated tax or central tax and state tax, based on the state selected for the
party ledger.
6. Select the type of reference as Advance and enter the reference details in the Bill-wise Details
screen.
Recording a journal voucher to raise liability for reverse charge on advance payments
When an advance payment is made to a unregistered dealer, or purchases are made from an
unregistered dealer, the liability due under reverse charge gets captured in the GSTR-2 report.
When you purchase from a unregistered dealer, you have to raise the tax liability in your books and
then pay it to the department. You can record a journal voucher to raise this liability under reverse
charge.
3. Click F2: Date and change the voucher date as required. You can record a journal voucher to
raise the liability for each advance payment, or at the end of the month, record a voucher to raise
liability for all the advance payments made, against a particular party.
4. Debit the ledgers grouped under Current Assets and credit the GST ledgers.
Recording a journal voucher to reverse the tax liability raised for purchases from an
unregistered dealer to claim tax credit
When you have made the advance payment in previous period and created the purchase invoice in
the current period, you can view the transaction details in GSTR-2 report.
You can claim the tax paid on purchases from unregistered dealer as tax credit by recording a journal
voucher, and can view the tax credit claimed in GSTR-2.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
2. Click V: Default View and F1: Detailed to view the purchase invoice recorded in the current
period adjusted against the advance payment of the previous period.
Claim tax credit when the advance amount paid matches with the purchase value
4. Debit the GST ledgers and enter the amount claimed as credit on purchase invoices recorded
against unregistered dealers.
Claim tax credit on the purchases from unregistered dealer when the purchase value exceeds the
advance amount paid
● To account for the GST liability, a journal voucher is recorded by crediting the GST ledgers, and
debiting the tax on advance (Current Liabilities) ledger for 18,000.
● Now to raise the tax liability of 34,200 and claim tax credit for 52,200 record a journal voucher.
To record a journal voucher to raise a liability and account for tax credit in the same voucher
4. Debit the GST ledgers and enter the total tax credit available on the purchase invoice.
5. Credit the GST ledgers and enter the amount of tax liability to be raised on the purchase value
after deducting the advance payment.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
2. Click V: Default View and F1: Detailed to view the journal voucher recorded to reverse the tax
liability raised on advance payments.
If you cancel a purchase order after advance payment to an unregistered dealer, you can reverse the
liability on cancellation of purchase.
If the order cancellation is done in the same month, you need to exclude the advance payment
voucher from GSTR-2. Otherwise, reverse the liability on cancellation.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
5. Click Yes for the message Do you want to exclude this voucher?.
1. Click J: Stat Adjustment in GSTR-2 report or from the Accounting Vouchers > F7: Journal.
3. Debit the GST ledgers and credit the ledgers grouped under Current Assets.
Consider a purchase invoice recorded for purchase from unregistered dealer as shown below:
The tax liability gets calculated and displayed in the Tax Analysis screen (click A: Tax Analysis in
the above purchase invoice) as shown below:
Record a journal voucher, to raise the liability and claim credit on the tax calculated in the Tax
Analysis screen of the above purchase invoice, as shown below:
When the purchase returns happens either partially or fully after filing returns, record a debit note to
reverse the transaction to the extent of goods returned.
Go to Gateway of Tally > Accounting Vouchers > Ctrl+F9. If the purchase returns happens
partially, record the debit note to the extent it is reversed as shown below:
The tax liability gets calculated and displayed in the Tax Analysis screen (click A: Tax Analysis in
the above debit note) as shown below:
Record a journal voucher to reverse the liability and tax credit claimed in the previous month to the
extent it is returned.
To record a journal voucher to reverse the tax liability and input tax credit
1. Click J: Stat Adjustment in GSTR-2 report or from the Accounting Vouchers > F7: Journal.
3. Debit and credit the GST ledgers with the same tax values as shown below:
To record purchase of services under reverse charge, you need to update your purchase ledger.
Inward supply > Raise tax liability > Pay tax and file returns
Same month: Advance payments > Inward supply > Raise tax liability > Pay tax and file returns
Different months: Advance payments > Raise tax liability > Pay tax and file returns > Inward
supply in another month > Reverse the tax liability > File returns in the subsequent month
Same month: Exclude the advance payment voucher from the GSTR-2
Different month: Record a journal voucher to reverse the tax liability to the extent to which the
transaction is cancelled
Same month before raising liability for complete invoice value: Purchase invoice > Cancel the
invoice (press Ctrl+X to cancel) > File returns
Same month after raising liability: Purchase invoice > Raise tax liability and claim credit > Record a
debit note > Reverse the tax liability and tax credit > File returns
Different month: Record a debit note > Reverse the tax liability and tax credit > File returns
This ledger is to account for the purchase of services under reverse charge.
o Taxability - Taxable.
Create a new bill reference when you are purchasing taxable services and then making a payment. If
you have made an advance payment, then you can adjust it against the purchase invoice.
1. Go to Gateway of Tally > Accounting Vouchers > Accounting Vouchers > F9: Purchase.
Link the bill reference of the payment voucher (by selecting Agst Ref in the Bill-wise Details
screen) to the purchase invoice, if you have made an advance payment.
Recording an advance payment for purchase of taxable services under reverse charge
When you make an advance payment for a taxable service under reverse charge, due to be received
on a future date, you can record an advance payment voucher.
2. Click V: Reverse Chrg. Adv. to mark the voucher for advance payment. The values entered in
this voucher are captured in GSTR-2 report.
Note: Payment vouchers recorded without clicking V: Reverse Chrg. Adv. will not have GST
implications, and will form part of the Summary of Excluded Vouchers.
3. In Account, select the bank from which the payment will be made.
4. Select the party ledger, and enter the details in the Advance Payment Details screen.
Note: To categorise and display the ledgers attracting reverse charge in the Advance Payment
Details screen, set the option Enable reverse charge calculation? to Yes in the Configuration
screen of GST Details screen (displayed on enabling the option Set/alter GST details? in the
stock item or ledger master).
The tax type appears as integrated tax or central tax and state tax, based on the state selected for the
party ledger.
6. Select the type of reference as Advance and enter the reference details in the Bill-wise Details
screen.
When an advance payment is made for a service under reverse charge, the liability gets captured in
the GSTR-2 report.
When you purchase classified as reverse charge, you have to raise the tax liability in your books and
then pay it to the department. You can record a journal voucher to raise this liability under reverse
charge.
● Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
3. Click F2: Date and change the voucher date as required. You can record a journal voucher to
raise the liability for each advance payment, or at the end of the month, record a voucher to raise
liability for all the advance payments made, against a particular party.
4. Debit the ledgers grouped under Current Assets and credit the GST ledgers.
Recording a journal voucher to reverse the tax liability raised for purchase of services
under reverse charge to claim tax credit
When you have made the advance payment in previous period and created the purchase invoice in
the current period, you can view the transaction details in GSTR-2 report.
You can claim the tax paid on purchase of services under reverse charge as tax credit by recording a
journal voucher, and can view the tax credit claimed in GSTR-2.
2. Click V: Default View and F1: Detailed to view the purchase invoice recorded in the current
period adjusted against the advance payment of the previous period.
Claim tax credit when the advance amount paid matches with the purchase value
4. Debit the GST ledgers and enter the amount claimed as credit on purchase invoices recorded for
services under reverse charge.
Claim tax credit on the purchase of services under reverse charge when the purchase value exceeds
the advance amount paid
● On 5th July, an advance payment of 1,00,000 is made for purchase of service under reverse
charge.
● On 2nd August, a purchase invoice is recorded for 2,90,000 (attracting GST of 52,200) by
adjusting the advance amount of 1,00,000. The tax liability on the balance amount of 1,90,000
(purchase value 2,90,000 - advance amount 1,00,000) is 34,200.
● Now to raise the tax liability of 34,200 and claim tax credit for 52,200 record a journal voucher.
To record a journal voucher to raise a liability and account for tax credit in the same voucher
4. Debit the GST ledgers and enter the total tax credit available on the purchase invoice.
5. Credit the GST ledgers and enter the amount of tax liability to be raised on the purchase value
after deducting the advance payment.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
2. Click V: Default View and F1: Detailed to view the journal voucher recorded to reverse the tax
liability raised on advance payments.
If you cancel a purchase order after advance payment made for a service under reverse charge, you
can reverse the liability on cancellation of purchase.
If the order cancellation is done in the same month, you need to exclude the advance payment
voucher from GSTR-2. Otherwise, reverse the liability on cancellation.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
5. Click Yes for the message Do you want to exclude this voucher?.
1. Click J: Stat Adjustment in GSTR-2 report or from the Accounting Vouchers > F7: Journal.
3. Debit the GST ledgers and credit the ledgers grouped under Current Assets.
The tax liability gets calculated and displayed in the Tax Analysis screen (click A: Tax Analysis in
the above purchase invoice) as shown below:
Record a journal voucher to raise the liability and claim credit on the tax calculated in the Tax
Analysis screen of the above purchase invoice, as shown below:
When the purchase returns happens, record a debit note to reverse the transaction.
The tax liability gets calculated and displayed in the Tax Analysis screen (click A: Tax Analysis in
the above debit note) as shown below:
Record a journal voucher to reverse the liability and tax credit claimed.
To record a journal voucher to reverse the tax liability and input tax credit
1. Click J: Stat Adjustment in GSTR-2 report or from the Accounting Vouchers > F7: Journal.
3. Debit and credit the GST ledgers with the same tax values as shown below:
See also
For any advance received for goods or services, if the corresponding sales invoice is not raised in the
same month, the dealer who has received the advance has to pay the GST.
Same month: Advance receipt > Outward supply > Pay tax
Different month: Advance receipt > Raise tax liability > Pay tax and generate returns > Outward
supply in the next month > Reverse tax liability > File returns for the month
Same month: Advance receipt > Exclude the advance receipt from GSTR-1 > File returns
Different month: Advance receipt > Raise tax liability > Pay tax for the liability raised > File return
> Reverse the tax liability in the next month > Receive the advance amount > File returns
Advance Receipt exclusive of tax adjusted against Sales Invoice in the same month
Advance Receipt voucher exclusive of tax
To record a receipt voucher for advance receipt from customer exclusive of tax
Note: Receipt vouchers recorded without clicking V: Advance Receipt will not have GST
implications, and will form part of the Summary of Excluded Vouchers.
5. In the Advance Receipt Details screen, select the Stock Item (goods enabled for GST) or
Ledger Name (services enabled for GST). Based on the GST rates defined in the stock item or
ledger, the breakup of GST rate for Central Tax, State Tax and Cess is displayed.
6. Enter the advance received in the Amount column. You can adjust this against the sales invoice
partially/fully, based on the sale value. At the end of the month, depending on the balance amount
of advance available, you can record a journal voucher to raise the liability.
Note: It is recommended to enter the entire advance amount in the Amount column so that the
entire advance can be used to setoff against the sales invoice raised in the same month or different
month.
Based on the amount entered, the breakup of GST amount gets auto calculated for Central Tax,
State Tax and Cess, if applicable. The Advance Receipt Details screen appears as shown below:
Note: The central and state tax rates shown in the above screen, are captured in the GSTR-1 report.
7. Press Ctrl+A to accept the Advance Receipt Details screen and return to receipt voucher.
8. Select the type of reference as Advance and enter the reference details in the Bill-wise Details
screen.
9. If the amount is received through bank, select the Transaction Type and enter the required
details in the Bank Allocations screen.
11. Click P: Print and enable the option Print Advance Receipt to Yes to print the invoice.
The printed payment voucher with the GST details appears as shown below:
The GSTR-1 report displays the tax liability on advance receipts as shown below:
The advance receipt voucher count appears in the Included in returns row.
When the sales invoice is recorded in the same month, the receipt voucher has to be linked to it by
selecting the Type of Ref as Agst Ref in the Bill-wise Details screen of sales invoice.
As the sales invoice is recorded in the same month, the GSTR-1 report displays only the sales
invoice as shown below:
The advance receipt voucher appears as part of transactions Not relevant for returns and is
categorised as No GST Implications in the Summary of Excluded Vouchers report.
At the end of the month, record a journal voucher to raise the liability to pay tax as shown below:
The journal voucher that is recorded does not have any impact on the GSTR-1 report.
1. In the receipt voucher, click V: Advance Receipt, select the bank/cash account, and the party
ledger enabled for bill-wise details.
2. In the Advance Receipt Details screen, enter the Amount (Incl of Tax). The Amount
available for setoff against sales invoice and the taxes included in the advance amount appears as
shown below:
3. In the advance receipt voucher, select the GST ledgers. The tax amount appears automatically.
This voucher can be linked to sales invoice by adjusting only 55000 in the Bill-wise Details screen.
Based on the amount offset against sales invoice, you need to reverse the tax deducted in the receipt
voucher by selecting the GST ledgers using a journal voucher.
● The tax liability raised in the advance receipt voucher of the current/previous month.
To reverse the tax liability, record a journal voucher by debiting the GST ledgers and crediting the
expense ledger or ledger grouped under Current Assets, as shown below:
If an advance receipt voucher is recorded,a journal voucher is recorded to raise the tax liability, and
then the transaction is cancelled:
● Record a journal voucher to reverse the tax liability to the extent to which the transaction is
cancelled.
If an advance receipt voucher is recorded, a journal voucher is recorded to raise liability, and then
the transaction is cancelled in the next tax period:
To exclude a transaction
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-1.
5. Click Yes for the message Do you want to exclude this voucher?.
1. Click J: Stat Adjustment in GSTR-1 report or from the Accounting Vouchers > F7: Journal.
3. Debit the GST ledgers and credit the ledger grouped under Current Assets as shown below:
Nil-rated sales
Exempt sales
SEZ sales
Deemed export
While recording any type of sales transaction, you can choose either of the following methods:
● Method 2: You can select the common sales ledger during the sales transaction, press F12 and
enable the option Allow modification of tax details for GST?, and select the
Classification/Nature.
Nil-rated Sales
The sales of nil-rated goods to a local or interstate customer does not attract GST, and can be
recorded using a sales voucher. For goods or services classified as nil rated (0%), the option Nil
Rated has to be selected as the Taxability in the GST Details screen of the item or group master.
Depending on the location of the party, you can record a local or interstate nil-rated sales
transaction.
Exempt Sales
The local or interstate sale of goods exempted from GST can be recorded using a sales voucher. For
goods or services that are exempted from tax under GST, the option Exempt has to be selected as
Taxability in the GST Details screen of the item or group master.
SEZ Sales
The sale of goods and services to a party in an SEZ can be recorded using a sales vouchers. In an
SEZ sales transaction, taxes are applicable based on the type of sale:
● Taxable SEZ sale: In SEZ sales, integrated tax is applicable for both local and interstate parties.
● SEZ sale under LUT/bond: No tax is applicable. SEZ sales under LUT/bond are allowed when
you have signed up a letter of undertaking with the department for the sale of goods without the
payment of duty.
To provide details of the LUT/bond, enable the options Enable Goods and Services Tax (GST)?
and Set/alter GST details? in Statutory and Taxation features. In the Company GST Details
screen, enable the option Provide LUT/Bond details?, and enter the details in the LUT/Bond
Details screen.
Provide GST details: Enable this option if you want to enter additional details regarding the export
transaction.
Deemed Export
Deemed exports are defined as transactions in which the supply and manufacture of goods takes
place within India. Essentially, deemed exports refer to the supply of goods to end-exporters.
For example, if a two-wheeler spare parts manufacturer supplies rear-view mirrors to a motorcycle
manufacturer and exporter, then the sale of the rear-view mirrors would be considered as deemed
exports.
The deemed export of goods and services can be recorded using a sales vouchers.
● Select the applicable Sales ledger. For example, Sales - Deemed Export.
You can record sales to consumers (end users of your goods or services) and unregistered dealers,
using a sales invoice.
Depending on the transaction value and the location of the party, the sales invoice will be captured
in different tables in GSTR-1 returns.
● B2C (Large) Invoices: Captures interstate sales transactions where the invoice value is more
than Rs. 2.5 lakh.
The following images show how large invoices are captured in GSTR-1 for an interstate party:
o Interstate sales transactions: where the total invoice value is less than Rs. 2.5 lakh.
The following images show how small invoices are captured in GSTR-1:
2. Select the applicable tax ledgers (central and state/union territory taxes for local supply,
integrated tax for interstate supply).
See also
2. In Original invoice no., enter the invoice number of the original sales transaction against which
you are recording the current sales return.
3. In Party’s A/c Name, select the party against which the original sales was made.
You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-
up.
Similarly, you can record sales returns against an interstate sales transaction by selecting the relevant
party, sales ledger, and integrated tax ledger.
2. Original invoice no: Enter the invoice number of the original purchase transaction against
which you are recording the purchase return.
3. In Party’s A/c Name, select the party from which the original purchase was made.
5. Provide GST details: Enable this option if you want to enter additional details about the
purchase return.
Similarly, you can record purchase returns against an interstate purchase by selecting the relevant
party, purchase ledger, and integrated tax ledger.
You can record an inward supply of services that are imported, in a purchase invoice.
3. In the field Party's A/c Name, select the supplier ledger predefined with Country other than
India.
4. Select the service grouped under Purchase Accounts, and enter the amount.
When you import services, you have to raise the tax liability in your books and then pay it to the
department. You can record a journal voucher to raise this liability under reverse charge.
4. Debit the ledger grouped under Current Assets and credit the integrated tax ledger.
2. Debit the integrated tax ledger and credit the ledger grouped under Current Assets.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
2. Click V: Default View and F1: Detailed, to view the purchase invoice details with the tax credit
claimed on the purchase.
You can record an inward supply of services that are imported, in a purchase invoice.
3. In the field Party's A/c Name, select the supplier ledger predefined with Country other than
India.
4. Select the service grouped under Purchase Accounts, and enter the amount.
When you import services, you have to raise the tax liability in your books and then pay it to the
department. You can record a journal voucher to raise this liability under reverse charge.
You can claim the tax liability paid on imports as tax credit by recording a journal voucher. The
purchase invoice details with the tax credit claimed on the purchase is shown in GSTR-2.
4. Debit the ledger grouped under Current Assets and credit the integrated tax ledger.
1. In the journal voucher, click J: Stat Adjustment and set the options as shown below:
2. Debit the integrated tax ledger and credit the ledger grouped under Current Assets.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2.
2. Click V: Default View and F1: Detailed, to view the purchase invoice details with the tax credit
claimed on the purchase.
o Export under LUT/bond: No tax is applicable. This type of export is applicable when you have
signed up a letter of undertaking with the department for the export of goods without the payment
of duty.
To provide details of the LUT/bond, enable the options Enable Goods and Services Tax (GST)?
and Set/alter GST details? in Statutory and Taxation features. In the Company GST Details
screen that opens, enable the option Provide LUT/Bond details?, and enter the details in the
LUT/Bond Details screen.
2. In Party A/c name, select the customer ledger or the cash ledger.
3. Select the sales ledger applicable. You can create separate sales ledgers for taxable exports,
exempt exports, and exports under LUT/bond.
5. Provide GST details: Enable this option if you want to enter additional details regarding the
export transaction.
Depending on the type of the export, you can record a sales transaction with the applicable GST
rates.
Note: You can also create a journal voucher from Gateway of Tally > Display > Statutory
Reports > GST > GSTR-1 or GSTR-2.
3. In the Stat Adjustment Details screen, select the options as shown below:
5. In the journal voucher, debit and credit the ledgers as per the scenarios mentioned below:
● Debit the
integrated tax ledger.
Utilisation of integrated tax credit, Credit the integrated tax ledger to
when only integrated tax credit is set-off the payable amount against
● Enter the amount
available. the available credit.
to the extent of credit
available.
3. In the Stat Adjustment Details screen, select the options as shown below:
5. Debit the integrated tax/central tax/state tax/UT tax/cess ledger and enter the amount that can
be claimed as credit.
Note: You can also create a journal voucher from Gateway of Tally > Display > Statutory
Reports > GST > GSTR-1 or GSTR-2.
3. In the Stat Adjustment Details screen, select the options as shown below:
5. Debit the integrated tax, central tax, state tax/UT tax, cess ledger and enter the amount that can
be claimed as credit.
3. In the Stat Adjustment Details screen, select the options as shown below:
5. Debit the bank ledger, and enter the amount of interest liability.
Similarly, you can record the journal voucher by selecting the Additional Details in the Stat
Adjustment Details as:
● Late Fee, for refund of excess payment made towards late fee.
3. In the Stat Adjustment Details screen, select the options as shown below:
4. Debit the state tax, central tax, integrated tax or cess ledgers and credit the party ledger.
3. In the Stat Adjustment Details screen, select the options as shown below:
● For availing tax credit on excise and service tax, debit the central tax ledger and credit the service
tax and CENVAT ledgers.
● For availing tax credit on VAT, additional tax, cess, TDS and entry tax, debit the state tax/UT
tax ledger and credit the VAT, additional tax, cess, TDS and entry tax ledgers.
To record a journal voucher for interest, penalty, late fee and other dues payable
3. In the Stat Adjustment Details screen, select the options as shown below:
5. Debit the expenses or party ledger, and enter the amount of interest liability.
Similarly, you can record the journal voucher by selecting the Additional Details in the Stat
Adjustment Details as:
To record a journal voucher for interest, penalty, late fee and other dues payable
3. In the Stat Adjustment Details screen, select the options as shown below:
5. Debit the expenses or party ledger, and enter the amount of interest liability.
Similarly, you can record the journal voucher by selecting the Additional Details in the Stat
Adjustment Details as:
3. In the Stat Adjustment Details screen, select the options as shown below:
5. In the journal voucher, debit the expense or party ledger, and credit the integrated tax, central tax,
state tax/UT tax or cess ledgers.
GSTR-1
GSTR-1 is the monthly GST return to be filed by taxable person registered under GST. GSTR-1 will
include the details of all outward supplies made in the given period. In the standard format released
by the department, GSTR-1 return form is divided into multiple tables, each table is used for a
different type of outward supply. In Tally.ERP 9, GSTR-1 can be viewed in a report format with tax
computation details. This report can be changed to table-wise format (department format) with the
click of a button.
All transactions, whether recorded correctly, incorrectly or inadequately, are captured and
categorised in this report. Further, to help you verify the tax details before exporting the returns, the
GSTR-1 report in Tally.ERP 9 provides you with options to resolve exceptions in transactions that
are not forming part of the returns due to incomplete information or mismatch.
The report also enables you to update the status of each transaction in the return based on the
acceptance and reconciliation status of the transaction on GSTN portal using the Status
Reconciliation option.
● Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR–1.
Returns Summary: This section displays a snapshot of business operations in the given period.
Particulars (computation details): This section displays the taxable value and tax amount from
outward supplies considered in the returns.
Drill down from any part to display detailed information at the subsequent levels.
F12: Configure
Show break-up of nett values?: Enable this option to display Gross Value, Returns, and
Addition/Deduction values in detailed mode of the report. This option is disabled by default.
Show tax types in separate columns?: Enable this option to view all GST tax types in separate
columns. This option is enabled by default. When this option is displayed, tax amount is displayed in
a single column without the Central Tax, state tax and integrated tax break-up.
Displays the total number of vouchers recorded in the reporting period. Drill down will lead to the
Statistics report, which displays the number of vouchers recorded against each voucher type, divided
into included, excluded and uncertain based the vouchers participating in the GST returns. The
statistics report on drill down from Total number of vouchers for the period appears as shown
below:
Included in returns
Displays count of all vouchers that have requisite information to comply with requirements of GST
returns. Only these transactions will be exported as part of returns. Drill down from this row to
view the Summary of Included Vouchers report, with the list of voucher-types with voucher count.
Displays the count of all vouchers which are not part of returns, as GST details are not provided in
these vouchers. These vouchers will have no implication on returns. Drill down from this row to
view Summary of Excluded Vouchers report, with transaction type-wise voucher count. The
Summary of Excluded Vouchers report appears as shown:
Transaction Types
Excluded by User: Displays the count of vouchers manually excluded by user from list of included
or uncertain transactions. Drill down will lead to list of all the excluded vouchers. An excluded
voucher can be included by clicking I: Include Vouchers. Based on information in the voucher it will
move to either included or uncertain.
Contra Vouchers: Displays the count of contra entries which involve only bank and cash ledgers.
Drill down to view all the contra vouchers.
Order Vouchers: Displays the count of sales order, purchase order, job work in order and job work
out order vouchers. Drill down to view the all order vouchers.
Inventory Vouchers: Displays the count of receipt note, stock journal, delivery note, material in,
material out, rejections in, rejections out and physical stock vouchers as they are purely inventory in
nature and do not attract GST . Drill down to view all inventory vouchers.
Payroll Vouchers: Displays the count of transactions recorded using payroll and attendance
vouchers. GST does not apply to these transactions. Drill down to view all the payroll vouchers.
No GST Implications: Displays the count of receipts, payments, and journal vouchers that do not
have any GST implication. Drill down to view all the vouchers.
Other voucher: Displays the count of memorandum and reversing journal vouchers. Drill down to
view all memorandum and reversing journal vouchers.
All the transaction types are not displayed by default. Based on the voucher type used and the
exclusions done by user, the relevant categories appear with the voucher count.
Displays the count of all vouchers with insufficient GST related information. These are exceptions
that need to be resolved for the vouchers to be included in the returns. Drill down from this row to
view the list of exception types and number of exceptions under each type. These exceptions can be
resolved right away, without having to alter vouchers or update masters one by one.
Outward Supplies
Total outward supplies (local and interstate), which include taxable value, and the corresponding tax
amount are displayed here. The total local and interstate sales are divided into Taxable and
Exempted. To view all the sales transactions,
You can view this report ledger wise or commodity wise by clicking L: Ledger-wise or S: Stock
item-wise, and A: Party-wise respectively.
You can correct exceptions in the vouchers before exporting GST returns. The Vouchers with
incomplete/mismatch in information report for GSTR - 1 appears as shown below:
The exceptions are listed in the order of priority, based on the importance of the information for
generating returns. Hence, a voucher with multiple exceptions is listed in the exception type higher
up the order. Once that exception is resolved, the voucher will move down to the next exception
type. Such vouchers with multiple exceptions continue to be listed as exceptions until all
incomplete/mismatch information are resolved. This will ensure that all exceptions are resolved
before filing the returns.
However, vouchers with only one exception are moved to Included in returns list after that
exception is resolved.
Displays the count of total vouchers with exceptions. Drill down from this row to view all the
vouchers with exceptions, number of exceptions in each voucher, and type of exception. All
exceptions can be resolved from here without having to open different exception categories.
To resolve all exceptions without having to go from one exception type to another
2. Press Enter to display Exception Resolution screen with the list of vouchers, number of
exceptions in each voucher, and exception types. The Exception Resolution screen appears as
shown below:
3. Select any transaction and press Enter to display the Voucher Details Alteration screen which
is divided into multiple sections, one for each exception in the voucher, as shown below:
4. Select or enter required information for the first exception type. Further, you can click F5:
Recompute or A: Accept as is to recompute or accept the details, respectively.
For Tally Sales & Service Contact @
Shravan Kumar Varma 9014411112 / 9866039659
Ask Soft Tech - Hyderabad , 901441112 / 9866039659
5. Press Enter to navigate to next exception type.
7. Press Enter after all exceptions in the voucher are resolved to view the next voucher with
respective exceptions.
8. Continue resolving the exceptions voucher by voucher, or press Esc to return to Exception
Resolution screen.
Note: Click X: Exclude Vouchers in the Exception Resolution screen to exclude the voucher
from forms and annexures.
1. Select the exception Country, state and dealer type not specified.
2. Press Enter. All the transactions of the exception type are displayed. The Exception Resolution
screen appears.
3. Select the state, specify the GSTIN and select dealer type for each transaction.
Note: Click X: Exclude Vouchers to exclude the voucher from forms and annexures.
Displays the count of transactions for which the rate or tax type is not selected in the item/ledger
master.
2. Press Enter. All the transactions of the exception type are displayed. The Exception Resolution
screen appears as shown below:
Note: Click X: Exclude Vouchers to exclude the voucher from forms and annexures.
Displays count of transactions in which the Nature of transaction, taxable value or rate of tax
defined in the ledger master has been changed in the transaction.
1. Select the exception Nature of transaction, taxable value, rate of tax modified in voucher.
2. Press Enter. All the transactions of the exception type are displayed, as shown below:
4. Click R: Resolve to select Nature of transaction and enter other details manually, or click A:
Accept as is. A message is displayed as shown below:
2. Press Enter. All the transactions of the exception type are displayed, as shown below:
Displays the count of transactions in which difference is found between the calculated and entered
tax amount. The mismatch due to modified value can be resolved by following one of the options.
2. Press Enter. All the transactions of the exception type are displayed.
Resolve
2. Press Enter. All the transactions of the exception type are displayed.
4. Click R: Resolve, and enter the tax value in As per transaction column of the voucher.
Accept as is
2. Press Enter. All the transactions of the particular exception are displayed.
3. Select the required voucher and click A: Accept as is. A message is displayed as shown below:
Displays the count of journal transactions in which Nature of adjustment is not selected.
2. Press Enter. All transactions are displayed of a particular exception are listed, as shown below:
3. Select the Nature of adjustment and Additional details for each voucher.
Displays the count of transactions excluded from table-wise format of GSTR-1 due to incomplete
information. The button Exception Types is provided to resolve all party ledger level or voucher
level corrections from a single screen.
To resolve all exceptions without having to go from one exception type to another
2. Press Enter to display Exception Resolution screen with list of vouchers with
mismatch/incomplete information.
3. Select any voucher and press Enter to display the Table-wise exceptions(s) screen, as shown
below:
4. Enter the missing information or update the incorrect details, and press Enter to return to the
Exception Resolution screen.
For Tally Sales & Service Contact @
Shravan Kumar Varma 9014411112 / 9866039659
Ask Soft Tech - Hyderabad , 901441112 / 9866039659
5. Select the next voucher to update the details required for annexures and continue.
Exception Types
Using this option you can resolve exceptions from a common screen by grouping all table-wise
related exceptions into two buckets Party Ledger level Corrections and Configuration Level
Corrections. Exceptions in each group can be resolved from a single screen without having to
move voucher by voucher.
2. Press Enter to display Exception Resolution screen with list of vouchers with
mismatch/incomplete information.
3. Press Ctrl+E.
4. Select Party Ledger Level Corrections in the Select Exception Resolution Type screen.
5. Select the State Name, State Code and enter party GTIN number for the listed parties in the
Party Ledger Level correction screen, as shown below:
2. Press Enter to display Exception Resolution screen with list of vouchers with
mismatch/incomplete information.
3. Press Ctrl+E.
4. Select Configuration Level Corrections in the Select Exception Resolution Type screen.
Drill-down from any row and resolve the respective exceptions to include the vouchers in return.
Item Exceptions
Total Masters
Drill down from this column to view information missing/mismatch in item at master level. You
can provide the required details at stock group level to update all items in the group or at individual
item level. By providing required information at item master level, all voucher level exceptions
resulting from that item are resolved.
2. Navigate to required exception type and press Enter from Total Masters column to display
Multi Stock Alteration screen.
Total Vouchers
Drill down from this column to view information missing/mismatch in the items at voucher level.
You can provide the required details for each transaction.
2. Navigate to required exception type and press Enter from Total Masters column to display
Exception Resolution screen, as shown below:
Ledger Exceptions
Total Masters
Drill down from this column to view information missing/mismatch at ledger master level. You can
provide the required details at ledger group level to update all ledgers in the group or at individual
ledger level. By providing required information at leger master level, all voucher level exceptions
resulting from that ledger are resolved.
2. Navigate to required exception type and press Enter from Total Masters column to display Multi
Ledger alteration screen, as shown below:
Total Vouchers
Drill down from this column to view information missing/mismatch in the ledger at voucher level.
You can provide the required details for each transaction.
2. Navigate to required exception type and press Enter from Total Vouchers column to display
Exception Resolution screen, as shown below:
Table-wise GSTR-1
GSTR-1 report can be viewed in the table-wise format. The table-wise report is structured in line
with the GSTR-1 format given by the department.
By default the table-wise format displays rows related to values for current reporting period. And
rows of previous period amendments, if values are available. To view all the amendment rows,
enable the option Show amendment tables with zero values? under F12: Configure.
Nature of transaction as
● Sales Taxable
● Sales Exempt
Taxability as
● Taxable
● Exempt
Registration type as
● Regular
● Composite
Nature of transaction as
Taxability as
● Taxable
● Exempt
● Nil Rated
Registration Type as
● Unregistered
● Consumer
Sales Taxable
Sales Exempt
Taxability as:
Taxable
Exempt
Nil Rated
Unregistered
Consumer
and invoice value of less than 2.5 lakhs are captured in this table.
7A Amendments to Displays amendments to details of taxable value and tax amount from taxable outward supplies
B2C(Small) Invoices to consumer (Other than captured in table 6) of earlier tax periods.
8 Credit/Debit Notes Displays the taxable value and tax amount from credit and debit notes recorded in the reporting
period. The credit and debit note transactions recorded with
Nature of transaction as
● Sales Exempt
Taxability as
● Taxable
● Exempt
● Nil Rated
Registration type as
● Regular
● Composite
Nature of transaction as
● Sales Exempt
Taxability as
● Taxable
● Nil Rated
Registration type as
● Regular
● Composite
● Unregistered
Nature of transaction as
● Exports Taxable
● Exports - LUT/Bond
● Exports Exempt
Taxability as
● Taxable
● Exempt
● Nil Rated
Registration type as
● Composite
● Consumer
● Unregistered
● Unknown
10A Amendments to Displays details of amendments to supplies exported of earlier tax periods.
Exports Invoices
● Supplier receiving the modified supply details in GSTR-1A. Supplier approving or disapproving
the updated supply details.
● Generating GSTR-3 the supplier with payment of taxes when buyer and seller approve all the
supply details.
All the approval, rejection, modification and confirmation is done on the GST portal. The supplier
or the buyer has to login to the GST portal to check the status of each voucher. The GSTR-1 report
in Tally.ERP 9 has the status reconciliation feature that enables you to mark the status of each
transaction based on the online status. This will allow you to track the status of all the transactions
uploaded without having to login to the portal.
1. Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR – 1.
2. Click U: Status Reconciliation. The Status Reconciliation screen appears as shown below:
Count: Displays the total count of vouchers under the particular table for the reporting period.
To Be Uploaded: Displays the number of vouchers yet to be exported. The count vouchers that
are not yet exported to GSTR-1 return file are displayed in this column.
Uploaded: Displays the number of vouchers exported. This column is automatically updated when
a voucher is exported to GSTR-1 return file.
Rejected by GST: Displays the count of vouchers marked as Rejected by GST. You can mark the
voucher status as rejected when GST rejects the voucher for reasons such as, duplicate invoice,
reference of original transaction is not found in case of debit/credit note, GSTIN of any user being
suspended, and so on.
Accepted: Displays the count of vouchers marked as Accepted. You can mark the status as
accepted when input tax claim made by the buyer in the GSTR-1A.
Rejected: Displays the count of vouchers marked as Rejected. You can mark the status as rejected
when the buyer rejects the voucher details as displayed in the GSTR-1A.
Not Reconciled: Displays the count of vouchers marked as Not Reconciled. You can mark the
status as Not Reconciled when the details in the online portal do not match with your books.
Set Status
Drill down from any table to view the voucher register with list of vouchers and change the status of
the voucher.
The voucher register displayed on drill down from a table in Status Reconciliation screen appears
as shown below:
3. Select the Activity status and Reconciliation status of the voucher based on the details in the
GST portal and press Enter.
Status-wise View
F12: Configure
Show uncertain transactions?: Enable this option to view the number vouchers that are not
included in the returns due to incomplete information or mismatch. This voucher count is displayed
at the bottom of the Status Reconciliation screen.
******
HSN/SAC Summary
HSN/SAC Summary report contains the details of HSN/SAC-wise taxable value and tax amount
that needs to be filed along GST returns. The HSN Summary in the GSTR-1 report of Tally.ERP 9
provides HSN/SAC-wise details of all outward supplies. And, in GSTR-2 the HSN/SAC-wise
details of all inward supplies are provided.
2. Click N: HSN/SAC Summary in the GSTR-1 report. The HSN/SAC Summary report
appears.
Type of Supply: Display the Type of Supply selected for the HSN/SAC.
Quantity UOM: Displays the quantity supplied for the period using the defined unit of
measurement.
Taxable Value: Displays the consolidated taxable value from all the transactions in the period for
the HSN/SAC.
Integrated Tax Amount: Displays the consolidated integrated tax amount from all the interstate
transactions in the period for the HSN/SAC.
Central Tax Amount: Displays the consolidated central tax amount from all the interstate
transactions in the period for the HSN/SAC.
Cess Amount: Displays the consolidated cess tax amount from all the interstate transactions in the
period for the HSN/SAC.
Total Tax Amount: Displays the total tax amount from all the interstate transactions in the period
for the HSN/SAC.
F12: Configure
View Summary of: This option enables you to view report with values for only goods or services or
both.
View vouchers based on HSN/SAC: This option enables you view the report with values of
goods or services that have HSN/SAC information or without these details or both.
● Go to Gateway of Tally > Display > Statutory Reports > GST > Challan Reconciliation.
GST FAQ
This topic lists the important FAQ on GST.
You need to create your service bill as a sales voucher in accounting invoice mode, by selecting the
relevant service and tax ledgers.
2. Is it required to print date and time of removal of Goods for GST invoices?
No. GST invoice rules do not mandate printing the date and time for removal of goods.
3. I have sold goods on 28th Jun 2017, but need to record a sales return on 1st Jul 2017. How
do I record my credit note for the sales return?
Even if the VAT rates are levied in the sales invoices recorded on 28th Jun 2017, you need to record
the credit note with the GST rates applied, for the returns on 1st Jul 2017.
4. HSN is not getting printed in the sales invoice although the same is updated in the GST
Rate Setup screen. Why?
Refer to the HSN/SAC code is not getting printed in the invoice topic for more details.
For detailed information, refer to Start Using Tally.ERP 9 for GST Compliance.
Refer to Transferring Tax Credits of VAT, excise and service tax to GST for more information.
Tally.ERP 9 Release 6 currently does not provide configuration support for composite dealer type.
HSN provided during excise regime may be 8 digits and the same need not be furnished for GST.
Therefore, Tally.ERP 9 is does not automatically copy the HSN code on activating GST for your
existing data.
9. How do we calculate IGST when buyer and consignee are in different locations?
GST is calculated based on the buyer's state selected in the supplementary details screen of an
invoice. If you select a state that is different from the state selected in the party master, then IGST is
calculated. Refer to Interstate Sales for more information.
In a single invoice, select the stock items each attracting a different GST rate, and then select the tax
ledger. Press Alt+A to view the tax calculations for each of the stock items selected in the invoice.
11. Why are CGST and SGST not getting calculated in my invoice?
● Ensure that the date of your transaction is on or after 1st July 2017.
● Select the tax vouchers individually while recording a transaction. Alternatively, create a voucher
class to automate the calculation of the GST rates. Refer to Using Voucher Class for Auto
Calculating GST in Vouchers for more information.
12. How do we adjust the ITC available at HO as we have registered under ISD.
Refer to Recording a Journal Voucher for ISD Credit under GST for detailed information.
13. In case of reverse charge transactions with unregistered dealers, we need to create self-
invoices. How can we generate such invoices in Tally?
Create a voucher type with separate voucher numbering and generate invoices for tracking reverse
charge to unregistered dealers.
14. How to generate E-Way bill from Tally and also entered Transport details in Sales
Invoice / Delivery Note?
CBEC is yet to notify alternatives for E-Way bill. Since it is not a legal requirement, Tally.ERP 9
does not support this functionality.
15. How to enter HSN code in multiple companies each having the same stock items?
You have to provide HSN code in each company individually, in one of the following ways:
o Go to Gateway of Tally > Display > Statutory Reports > GST > GST Rate Setup, and enter
the HSN code in the GST Rate Setup screen.
16. The Sales Invoice format changed after upgrading and activating GST. Why?
Tally.ERP 9 Release 6.0 onwards, the invoice formats have been enhanced for GST. The invoice
formats currently supported are Tax invoice, Bill of Supply, and Advanced Receipts.
17. Can I create GST e-Cash, e-Credit, and e-Liability masters in Tally.ERP 9?
You can create ledgers named as e-Cash, e-Credit, and e-Liability in Tally ERP 9. You can maintain
these ledgers separately for GST.
You can create multiple addresses for one customer in Tally.ERP 9, and update all the GSTINs of
that customer along with the corresponding address.
19. If our company has multiple GSTINs, do we need to have one company with multiple
godowns, or should we create multiple companies in Tally.ERP 9?
You can have only one GSTIN per company. If you have multiple GSTINs, you need to create
multiple companies in Tally.ERP 9.
You can enable the option Maintain Accounts Only in F11: Features > F1, and enable GST in
F11: Features > F3.
21. How does auto calculation happen for central tax/state tax/integrated tax using voucher
class?
Auto calculation will happen when you create a voucher class with central tax/state tax/integrated
tax as a default additional ledger.
22. How do we carry forward excess of Input Credit to next month in Tally.ERP 9?
This happens automatically in Tally. ERP 9. There is no provision to capture input credit in GSTR-1
and GSTR-2. You can check the available input tax credit in GSTR-3 by logging in to GSTIN
portal. In Tally.ERP 9, check the closing balance of ledgers created under Duties & Taxes. If there
is input tax to be availed the tax ledgers will show a debit balance.
23. How does GST Classification for Capital Goods happen in Tally.ERP 9?
In the GSTR-1 report, the first 4 boxes are pre-filled with information related to the company and
the return period. Return details begin from box 5.
Since information related to boxes 1-4 are already available on the GSTN Portal, they are not
required to be uploaded again. The GSTR-1 excel file does not have fields to capture information
from box 1 to box 4. Therefore, Tally.ERP 9 does not provide this information on the GSTR-1
report.
25. I have about 20 companies in Tally.ERP 9. How do I migrate all companies at one shot?
After upgrading to Tally.ERP 9 Release 6, you just have to open all the companies one by one, after
which data of all the companies data will be automatically migrated.
VAT TIN gets printed on the bill when VAT is enabled along with GST. If you do not want TIN to
be printed, then you can deactivate VAT features.
If you are not sure about the registration type of your party while creating or updating the party
master, you can select Unknown as the registration type in the party ledger.
You can update the details later by altering the party ledger. If you want to update the details of
multiple parties, you can conveniently do so from the Update Party GSTIN/UIN report. If such
parties are part of taxable transactions, ensure that you update the details before filing the final
returns.
Exempt sales will get captured in table 9 (Nil Rated Invoices) in the table-wise report of GSTR-1.
If the method of voucher numbering is set to Automatic, then duplication of the invoice number
might occur if you delete invoices. For GST transactions, unique voucher numbers have to be used
for all your vouchers. Therefore, we recommend that Automatic (Manual Override) should be set
For Tally Sales & Service Contact @
Shravan Kumar Varma 9014411112 / 9866039659
Ask Soft Tech - Hyderabad , 901441112 / 9866039659
as the method of voucher numbering, which will ensure that unique voucher numbers are set for
your vouchers.
30. Can I have both exempt and non-exempt goods in the GST bill?
No, exempt and taxable goods cannot be part of the same bill. A tax invoice has to be issued for
taxable goods and services. A bill of supply has to be issued for exempt, nil rated, and non-GST
goods.
31. How do I claim Input Tax Credit (ITC) for the purchase of capital goods?
There is no separate process for claiming ITC for the purchase of capital goods. The tax paid on the
purchase of capital goods is added to the e-credit ledger, which can be used for input credit at any
time.
32. How to record expenses incurred in the furtherance of business like rent, telephone
expenses, stationery and so on, and claim them under GST?
Expenses incurred for the furtherance of business, such as rent (commercial), telephone bill,
stationery and so on, can be claimed under GST by recording them as purchases and not as
expenses. To record such purchases, create a party ledger (party from whom such goods are
procured) and ensure that GSTIN of the party is updated in the ledger. When the supplier uploads
his GSTR-1, the details will appear in your GSTR-2A. You can claim input credit by confirming the
same in your GSTR-2.
Consignment sales is similar to other sales under GST. You can record the sales invoice with GST
ledgers (if it is taxable), and record a tax payment voucher to pay tax.
34. Why does the warning message Potential Mismatch in Tax Amount for GST appear?
The warning message Potential Mismatch in Tax Amount for GST !! appears when:
● GST ledgers are not selected while recording taxable sales or purchases.
● GST value auto calculated in the taxable sales or purchase invoice is manually altered.
If you proceed with the transaction after this warning appears, then the transaction will appear in the
Summary of Exceptions in GSTR-1 (for sales transaction) or GSTR-2 (for purchase transactions),
where you can correct the exceptions in the vouchers before exporting GST returns.
35. How to make stock transfer entry between two godowns of same organisation inside the
state and outside the state?
Under the GST regime, stock transfer to a godown or to an entity with a different GSTIN
registration is considered taxable supply. Hence, if stock is transferred to a godown of the same
For Tally Sales & Service Contact @
Shravan Kumar Varma 9014411112 / 9866039659
Ask Soft Tech - Hyderabad , 901441112 / 9866039659
organisation, it is recorded as a transfer if the godown is operating under the same GSTIN. In case
the godown has a different GSTIN, it is recorded as an taxable outward supply. You can record
transfers using delivery note or material out voucher types, and taxable outward supplies using sales
vouchers in Tally.ERP 9.
In case of supply to a godown outside the state, it is recorded as a taxable outward supply, since the
same GSTIN cannot be used for business operations in two different states.
36. Can I view the central tax (CGST) and state tax (SGST) bifurcation of tax amount in
Profit and Loss A/c?
No, the values of duties and taxes are not displayed in Profit and Loss A/c. The consolidated value
of all duties and taxes is displayed in Balance Sheet under Current Liabilities. To view ledger-wise
value of each tax type, drill down by selecting Duties & Taxes in Balance Sheet.
37. How to manage GST accounts when I have multiple branches in different states?
You have to create a separate company for each registration obtained under GST for the branch
offices, and maintain your data.
Works contract is treated as a service under GST. The works contract purchases and sales have to be
recorded as taxable purchases and sales. Based on the State in which the party is located, you can
select the taxable Nature of transactions provided for sales and purchases, and the GST ledgers in
the invoice.
You can manage your job work entries using the existing features of job work in Tally.ERP 9. When
the GST rules related to job work are finalised, necessary changes will be incorporated, and made
available in Tally.ERP 9.
The tax paid on procuring certain services and goods is not eligible for input credit. Services such as
renting of motorcab, supply of tour operator services and items that are used in manufacturing of
exempt goods fall under this ineligible for input credit category. You can not claim credit for tax
paid for these items.
In Tally.ERP 9 you can set goods or services as ineligible for input credit by enabling the option Is
ineligible for input credit? to Yes in the GST Details screen of the item master or purchase ledger.
This option can be activated by enabling Set ineligible input credit? to Yes under F12:
Configure.
42. How to use my existing license in both Release 4.93 and Release 6.0.1?
After installing Tally.ERP 9 Release 6.0.1, select Configure your existing license in the Startup
screen and enter your existing license details. For more information, refer to Configuring Tally.ERP
9 License.
Refer to Renewing TSS for Tally.ERP 9 and Upgrading to Tally.ERP 9 Release 6 for detailed
information.
44. How can I get the HSN code for any product?
You can find the chapter-wise-rate-wise GST rate schedule for goods on the website
http://www.cbec.gov.in/htdocs-cbec/gst/index. Alternatively, contact your CA/business
consultant for more details.