Set 1: Advanced Purchase & Sales Transactions with
GST
1. Local Purchase Entry (GST Credit on Raw Materials)
Your company purchased raw materials for manufacturing from Maharashtra Traders (GSTIN:
27AABCT1234F1Z5) on 5th April 2024, on credit.
CCTV Camera Lens (HSN: 900710) – 200 units @ ₹250 each
DVR Motherboard (HSN: 8521) – 100 units @ ₹500 each
GST Rate: 18%
Freight Charges (GST Exempt): ₹5,000
Payment Terms: 30 days credit
🔹 Task:
1. Record the purchase invoice under Purchase Voucher (F9) in Tally.
2. Apply GST Input Tax Credit (ITC) correctly.
3. Add freight charges as an indirect expense in the ledger.
4. Generate GSTR-2A reconciliation report to match with supplier data.
2. Local Sales Entry with Detailed Invoice Requirements
On 10th April 2024, your company sold the following products to Techno Solutions Pvt Ltd (GSTIN:
27AACCT9876R1Z5, Maharashtra).
DVR Camera Set (HSN: 8521) – 50 units @ ₹1,200 each
HD Camera (HSN: 900710) – 80 units @ ₹800 each
GST Rate: 18%
Discount: 5% on total invoice value
E-way Bill Required? Yes, since the total invoice exceeds ₹50,000
Transporter Name: Blue Dart Logistics
LR Number: 2567890001
🔹 Task:
1. Record the sales invoice in Tally (F8) with correct GST treatment.
2. Apply trade discount before GST calculation.
3. Generate an E-way Bill for this transaction.
4. Verify GSTR-1 Report to ensure correct GST is applied.
2: Payment Transactions with GST & TDS
3. Payment to Supplier (GST & TDS Adjustments)
On 15th April 2024, you made the full payment of ₹1,50,000 to Maharashtra Traders (for the purchase
in Q1).
TDS on Purchase of Goods @0.1% applied before payment.
Payment Mode: RTGS via ICICI Bank
TDS Payable Account: Created in Tally
🔹 Task:
1. Record TDS deduction on purchase in Tally Prime.
2. Pass the payment entry under Bank Ledger.
3. Check TDS Payable in Statutory Reports.
3: Export Transactions with Payment & LUT Filing
4. Export Sales Entry with LUT (Zero-Rated GST)
On 20th April 2024, your company exported the following items to ABC Technologies, New York, USA.
AI Security Cameras (HSN: 900710) – 100 units @ $120 each
Total Invoice Value: $12,000
Exchange Rate: ₹83 per USD
GST Rate: 0% (Export under LUT)
Shipping via: DHL Express
Invoice Currency: USD
Payment Terms: 50% advance, balance on delivery
🔹 Task:
1. Record the export sales invoice in USD in Tally.
2. Apply Zero-Rated GST under LUT.
3. Record 50% advance payment from ABC Technologies in Tally.
4. Generate export shipping invoice with exchange rate conversion.
5. Update foreign exchange gain/loss adjustment at month-end.
5. Export Payment Receipt & Exchange Rate Adjustment
On 5th May 2024, you received the balance payment of $6,000 from ABC Technologies in your ICICI
Bank USD Account.
Bank Charges deducted by the bank: $50
Exchange Rate on Payment Date: ₹84 per USD
Foreign Exchange Gain/Loss to be adjusted in Tally.
🔹 Task:
1. Record the receipt entry in Tally with adjusted exchange rate.
2. Deduct bank charges as an expense.
3. Show the impact of foreign exchange gain/loss in P&L.
4: GST Compliance & Filing Questions
6. Filing GSTR-1 for Outward Supplies
On 1st May 2024, your company needs to file GSTR-1 for April transactions.
🔹 Task:
1. Extract GSTR-1 report from Tally.
2. Check for any mismatch in outward supplies.
3. Verify if zero-rated export sales are reported correctly.
4. Submit JSON file for GSTR-1 upload on the GST Portal.
7. GST Refund Claim on Export
On 10th May 2024, your company wants to claim a GST Refund for unused Input Tax Credit (ITC) of
₹50,000 from the April export sale.
🔹 Task:
1. Prepare the GST Refund Application (RFD-01) in Tally Prime.
2. Attach supporting documents (Invoice, LUT Certificate, Shipping Bill).
3. Verify the Refund Ledger in Tally.
4. Submit RFD-01 on GST Portal.
8. Reverse Charge Mechanism (RCM) on Import of Services
On 15th May 2024, you paid $2,000 to XYZ Marketing, UK, for digital marketing services.
GST @18% applicable under Reverse Charge
Payment made via SWIFT Transfer from ICICI Bank
Exchange Rate: ₹83 per USD
🔹 Task:
1. Record the import service entry under RCM in Tally.
2. Apply GST liability in GSTR-3B.
3. Adjust GST paid on RCM under ITC utilization.
9. Credit Note Entry for Goods Return
A customer returned 5 security cameras due to defects.
Generate a Credit Note in Tally and adjust GST accordingly.
10. Job Work Accounting in Tally
Send 500 units of DVR Motherboard for processing to a vendor.
Record a Job Work Out entry and apply E-way Bill rules.
11. Advance Received from Customer (GST on Advance Payment)
You received ₹1,00,000 advance for a future order.
Record GST on advance received under GSTR-1.
