How do you create the GST Purchase / Sales invoice in Tally?

Lets take an Assignment to solve this query.

INTRASTATE PURCHASE & SALES

  1. Company Purchased the following stock from ABC Companies (Andhra Pradesh) and stored at Rajam godown and with GST @ 18%
    HSN CODE: 4202. Reference Number: abc/500
S.NoName of the ItemQuantityRate
1Trunks500399
2Suit Cases2501340
3Executive Cases6003999
4Brief Cases8004999
5Guitar Cases320614
6Camera Cases460999
7Shopping Bags960299
8Wallets630455
9Purses710990
10Sports Bags8201499

2. The company sold the following goods with GST @ 18% to RSS Companies (Andhra Pradesh) and delivered from Rajam godown.
HSN CODE: 4202. ref number : rss/600

S.NoItem NameQuantityRate
1Trunks500499
2Suti Cases2501640
3Executive Cases 6004999
4Brief Cases8005999
5Guitar Cases320814
6Camera Cases4601299
7Shopping Bags960499
8Wallets630655
9Purses7101100
10Sports Bags8201699

SOLUTION

STEP: 01 (Setting-up features)

  • Gateway of Tally > Press F11 for Company Features
  • Press F2 for Inventory Features
    Maintain Multiple Godowns: YES
  • Press F3 for Statutory & Taxation
    Enable Goods & Service Tax — YES
    Set / Alter GST Details: YES (Press Enter)
    GST DETAILS
    State: Andhra Pradesh
    Registration Type: Regular
    Assessee of Other Territory: NO
    GSTIN / UIN: APAA12345678901
    Applicable From: 01-04-2020
    Periodicity of GSTR1: Monthly
    e-way bill applicable: Yes
    Applicable from: 01-04-2020
    Threshold Limit Includes: Invoice Value
    Threshold Limit: 50,000
    Applicable from Intrastate: Yes
    Threshold Limit: 50,000
    Enable Tax Liability on advance receipt: YES
    Enable tax Liability on reverse charge: No
    (Purchase from unregistered dealer )
    Set / Alter GST rate details: NO
    Enable GST classifications: YES
    Provide LUT / BOND details: NO
    PRESS ENTER_ACCEPT – YES
  • ACCEPT THE TOTAL SCREEN

STEP : 02 (Creating Ledgers)

  • Gateway of Tally > Accounts Info > Ledgers > Create
  • NAME: ABC COMPANIES
    UNDER: Sundry Creditors
    Maintain Balances Bill by Bill: Yes
    Mailing Details:
    Select Country INDIA and STATE: Andhra Pradesh
    (Note: selecting the applicable state is compulsory to calculate GST during the voucher entry
    Tax registration Details:
    Registration Type: Regular
    GSTIN / UIN: enter te party GST Identification Number
    set / alter GST details: No
  • Press Enter – Accept Yes
  • NAME: RSS COMPANIES
    UNDER: Sundry Debtors
    Maintain Balances Bill by Bill: Yes
    Mailing Details:
    Select Country INDIA and STATE: Andhra Pradesh
    (Note: selecting the applicable state is compulsory to calculate GST during the voucher entry
    Tax registration Details:
    Registration Type: Regular
    GSTIN / UIN: enter te party GST Identification Number
    set / alter GST details: No
  • Press Enter – Accept Yes
  • Name: Purchase A/c
    Under: Purchase Accounts
    Inventory Values are affected: Yes
    Statutory Information:
    Is GST Applicable: Applicable
    Set / Alter GST Details: Yes
    HSN / SAC Details:
    Description:
    HSN / SAC Details: 4202
    Is Non-GST Goods: No
    Nature of Transaction: Purchase Taxable
    Tax Details:
    Taxability: Taxable
    Is reverse Charge Applicable: No
    Is ineligible for input credit: No
    Press F12 for Configuration:
    Show all GST tax Types: YES (Press Enter)
    Tax Type Rate
    Integrated tax 18%
    Central tax 9%
    State Tax 9%
    PRESS ENTER
    Type of Supply: Goods
    Press Enter – Accept Yes
  • Name: Sales A/c
    Under: Sales Accounts
    Inventory Values are affected: Yes
    Statutory Information:
    Is GST Applicable: Applicable
    Set / Alter GST Details: Yes
    HSN / SAC Details:
    Description:
    HSN / SAC Details: 4202
    Is Non-GST Goods: No
    Nature of Transaction: Sales Taxable
    Tax Details:
    Taxability: Taxable
    Is reverse Charge Applicable: No
    Is ineligible for input credit: No
    Tax Type Rate
    Integrated tax 18%
    Central tax 9%
    State Tax 9%
    PRESS ENTER
    Type of Supply: Goods
    Press Enter – Accept Yes
  • Name: CGST
    Under: Duties & Taxes
    Type of Duty / Tax: GST
    Tax Type: Central Tax
    Percentage of calculation: 9%
    Press Enter — Accept – Yes
  • Name: SGST
    Under: Duties & Taxes
    Type of Duty / Tax: GST
    Tax Type: State Tax
    Percentage of calculation: 9%
    Press Enter — Accept – Yes
  • Name: IGST
    Under: Duties & Taxes
    Type of Duty / Tax: GST
    Tax Type: Integrated Tax
    Percentage of calculation: 18%
    Press Enter — Accept – Yes

STEP: 03 (Stock items Creation)

  • Gateway of Tally > Inventory Info > Stock Items > Create

    NAME: Trunks
    UNDER: Primary
    Units: Alt + C > No.s > Unit Quantity Code : Numbers
    Statutory Information:
    GST Applicable: Applicable
    Set / Alter GST Details: Yes
    HSN / SAC: 4202
    Tax Details:
    Taxability: Taxable
    Is reverse Charge Applicable: No
    Is ineligible for input credit: No
    Tax Type Rate
    Integrated tax 18%
    Central tax 9%
    State Tax 9%
    PRESS ENTER
    Type of Supply: Goods
    Press Enter — ACCEPT_YES
  • Similarly, Create the remaining items also (as per given in assignment)

STEP: 04 (Purchase Voucher with GST)

  • Gateway of Tally > Accounting Vouchers
  • Press F9 for purchase Voucher
  • supplier invoice no: abc/500
  • Party’s A/c Name: ABC Companies
  • Purchase Ledger: Purchase A/c
  • Name of Item: Trunks
    Godown: Alt + C – Rajam
    Enter Quantity & Rate as per given in the assignment
  • select remaining all the items and specify Quantity & Rate
  • next, select the CGST, SGST ledgers press Enter (Tally automatically calculates the tax)
  • Provide GST / E-Way Bill Details: YES
    Enter the E-Way Bill details and Transport Details and Consignor Details
  • New Ref: abc/500
  • Press Enter – Accept_YES

STEP: 05 (Sales Voucher with GST)

  • Press F8 for Sales Voucher
  • supplier invoice no: RSS/600
  • Party’s A/c Name: RSS Companies
  • Sales Ledger: Sales A/c
  • Name of Item: Trunks
    Godown: Rajam
    Enter Quantity & Rate as per given in assignment
  • select remaining all the items and specify Quantity & Rate
  • next, select the CGST, SGST ledgers press Enter (Tally automatically calculates the tax)
  • Provide GST / E-Way Bill Details: YES
    Enter the E-Way Bill details and Transport Details and Consignor Details
  • New Ref: rss/600
  • Press Enter – Accept_YES

REPORTS:

  • Gateway of Tally > Balance Sheet > Current Liabilities > Duties & Taxes > C.G.S.T – 2,22,399.00
    > S.G.S.T – 2,22,399.00
  • Company Purchased the following stock from ABC Companies (Andhra Pradesh) and stored at Rajam godown and with GST @ 18%
    HSN CODE: 4202. Reference Number: abc/500 ON APR / 2/ 2020
S.NoName of the ItemQuantityRate
1Trunks500399
2Suit Cases2501340
3Executive Cases6003999
4Brief Cases8004999
5Guitar Cases320614
6Camera Cases460999
7Shopping Bags960299
8Wallets630455
9Purses710990
10Sports Bags8201499

REPORTS:

  • Gateway of Tally > Balance Sheet > Current Liabilities > Duties & Taxes
    CGST 6,86,141.10
    SGST 6,86,141.10

The company sold the following goods with GST @ 18% to RSS Companies (Andhra Pradesh) and delivered from Rajam godown.
HSN CODE: 4202. ref number : rss/610

S.NoItem NameQuantityRate
1Trunks500499
2Suti Cases2501640
3Executive Cases 6004999
4Brief Cases8005999
5Guitar Cases320814
6Camera Cases4601299
7Shopping Bags960499
8Wallets630655
9Purses7101100
10Sports Bags8201699

Reports:

Gateway of Tally > Balance Sheet > Current Liabilities > Duties & Taxes >
CGST 4,44,798.00
SGST 4,44,798.00

GST PAYMENT:

Gateway of Tally > Accounting vouchers > press F5 for payment :
Alt + S for statutory payment :
Period : 1-4-2020 to 02-05-2020
Tax: GST
Account : SBI
Particulars :
CGST – 4,44,798.00
SGST – 4,44,798.00


SEE MORE: