Last Updated on: 5th July 2024, 01:47 pm
Practical Assignments : GST Accounts–Tally
The Practical Assignments-Tax Accounts- covers Basic tasks of Maintaining GST Accounts, from set up, Data Entry to GST Reports, in Tally Prime Rel 3.x.
This assignment is in continuation to Practical Assignments of Basic Financial Accounting & Basic Invoicing & Inventory Accounts. Maintain GST Accounts in the same Company in which Basic Financial Accounts and Basic Invoicing & Inventory Accounts Practical Assignments data were entered.
Perform the operations for each Assignment as explained. Capture the screenshots (Prtscr) and paste it in MS Word file in 1×1 cell. Write the number and Name of screen shot as indicated. Explain the options and operational step.
This way, capture the screenshots and place in MS Word file, in sequence. Don’t repeat same screenshot.
After completing all assignments, take Back up of the data files. Now email to dvidyamail@gmail.com, attaching the Data Back Up file and screenshot zip file.
GST Accounting – Practical Assignments
Continue in same Company after previous assignments
01-1 Company GST Features
[At Company >Click F11. At Company Features, under section Taxation, set Yes at Enable Goods & Services Tax (GST). Next, At GST Details screen, under GST Registration Details section, enter the relevant details.]
Capture Screenshot 1-1A : Company Features. 1-1B : Company GST Details set up
For more details, visit
https://dvidya.com/goods-service-tax-gst/
https://dvidya.com/goods-services-tax-gst-set-up-composition-dealers-tally/
https://dvidya.com/goods-services-tax-gst-set-up-regular-dealers-tally/
https://youtu.be/STv3wbduT8A
https://youtu.be/RwJJIYC6msE
https://youtu.be/VSS48c_LZXY
https://youtu.be/OjSvFYUJ_bI
https://youtu.be/mLrLyOeDX78
https://youtu.be/7wlTsturfks
02 GST Masters
02-1 Create SGST Ledger Account Master
[Select GoT>Create>Ledger. At Ledger Account creation, at Name, enter SGST; at Under, select Duties & Taxes; atTax Type, select SGST/UTGST; At Inventory Values are affected, set No.
Capture Screenshot 1-2 : SGST Ledger Account Creation.
https://dvidya.com/gst-set-up-accounts-inventory-masters-tally/
https://youtu.be/x8VZLjVEeug
https://youtu.be/XVZbi0-ufDY
https://youtu.be/Uzsise4yZXg
02-2 Create CGST Ledger Account Master
[Select GoT>Create>Ledger. At Ledger Account creation, at Name, enter CGST; at Under, select Duties & Taxes; at Tax Type. At Inventory Values are affected, set No. Capture Screenshot 2-2 : CGST Ledger Account Creation.
02-3 Create IGST Ledger Account Master
[Select GoT>Create>Ledger. At Ledger Account creation, at Name, enter IGST; at Under, select Duties & Taxes; at Tax Type select IGST; At Inventory Values are affected, set No.
Capture Screenshot 2-3 : CGST Ledger Account Creation.
02-4 UQC set up in UoM Master
Set UQC in UoM – Kilograms [Select GoT>Alter>Unit. Select Kilogram. At Unit Alteration, at Unit Quantity Code (UQC), select KGS-Kilograms from the UQC list. Press Ctrl+A to save].
Capture Screenshot 2-4 : UoM-UQC set up.
02-5 GST details set up in Stock Item Master
Set GST details in Stock Item Wheat, Select GoT>Alter>Item. Select Wheat, At Stock Item Alteration, Under HSN/SAC & Related Details, at HSN/SAC Details , select Specify Details Here. At HSN Description – Food grains, HSN Code- 1234, At Description of Goods, select Specify Details Here, Under GST Rate and related Details, At GST Rate details, select Specify Details Here. At Taxability Type, select Taxable. At GST Rate, enter the GST Rate applicable for the Item. At Type of Supply, select Goods.
2-5 : Capture Screenshot UoM-UQC set up.
https://youtu.be/U7fuonC9dkI
https://youtu.be/LK-df_Oh6Vk
02-6 Set GST details in Supplier Master
At Supplier Ledger Account, enter Tax related details [Select GoT>Alter>Ledger, select ABC & Co. At Ledger Alteration, click F12:Configure. At Ledger Master Configuration screen, under Party Tax Registration details, set Yes at Provide GST Registration details. At Tax Registration details of Ledger Account Master, Enter Registration Type- Regular, GSTIN 19AAAC1234K1ZV. At Set Alter Additional Details, set Yes and then Place of Supply, select the State of the Party.
Capture Screenshot : 2-6A: Ledger Account Master, 2-6B: Ledger Master Configuration screen,
https://youtu.be/1_jlZD8mXkI
https://youtu.be/B6jEPMw26Tg
03 GST Invoicing
3-1 Create GST Sales Invoice.
Create Sales Invoice for 10 kg of Wheat @25 per kg sold to ABC & Co on 1-5-21. [Select GoT>Vouchers. Click F8:Sales (or press F8). Select Sales Voucher type from List. Click Ctrl+H and select Item Invoice. Enter Voucher Date 1-5-21. At Party A/c Name, select ABC & Co. At Sales Ledger, select Sales. At Name of Item, select Wheat, At Quantity, enter 10 kg. at Rate, enter 25/kg. The amount 250 would be shown. In next line, select End of List. Next select SGST, the SGST amount (15.00) would be auto calculated. Next select CGST. the CGST amount (15.00) would be auto calculated. The total Invoice amount (250.00+15.00+15.00 = 280.00) is displayed. Press Ctrl+A to save the Voucher].
Capture Screenshot : 3-1 GST Sales Invoice Entry ,
https://youtu.be/L57aR4Zb7GM
https://youtu.be/S0y56oS7r1U
3-2 Print the Sales Voucher
Voucher dated 1-5-23 on ABC Co [Select GoT>Day Book. At Day Book display, press F2 and Date 1-5-23. Select the Sales Voucher from the list to get the Voucher Alteration. Press Ctrl+P to get the Print screen. Click I:Preview to View the Print form of the Invoice on screen]
Capture Screenshot : 3-2 GST Sales Invoice in Print ,
https://youtu.be/L57aR4Zb7GM
https://youtu.be/S0y56oS7r1U
03-03 GST Reports
- Display GSTR-1 for 1-4-23 to 31-7-23
[Select GoT>Display more reports>GST Reports>GSTR-1. Click F2:Period (or press F2) and enter Period from 1-4-23 to 31-7-23 to display GSTR-1 Report
Capture Screenshot : 3-3 GSTR-1 Display,
https://dvidya.com/gsrt-1-return-filing-tally/
