Home Tutorials Videos Q&A MCQ Shortcuts Exercises Appointment Login
Tutorial Exercises MCQ Test Interview Q&A
Lesson 38 of 48 – GST Reports
76%

📊 GST Reports in Tally Prime

GST Reports help businesses verify GST transactions, monitor tax liabilities, review Input Tax Credit (ITC), reconcile purchase and sales data, and prepare GST returns.

Lesson Objective Learn how to view GST reports, understand Purchase and Sales Registers, analyze Input and Output GST, reconcile GST data and prepare accurate GST returns.
1. What are GST Reports?

GST Reports are system-generated reports that display GST-related transactions recorded in Tally Prime. These reports help verify GST calculations and prepare GST returns.

Report Purpose
GST Summary Overall GST overview.
Purchase Register View GST Purchase transactions.
Sales Register View GST Sales transactions.
Input Tax Summary Review eligible Input GST.
Output Tax Summary Review GST collected on sales.
2. Why are GST Reports Important?
  • Verify GST calculations.
  • Review Purchase and Sales transactions.
  • Monitor Input Tax Credit (ITC).
  • Check Output GST liability.
  • Detect missing or incorrect entries.
  • Prepare GST Returns accurately.
  • Support GST audits.
  • Improve accounting accuracy.
Regularly reviewing GST Reports helps prevent filing errors and improves compliance.
3. Types of GST Reports
Report Purpose
GST Summary Overall GST status.
Purchase Register Purchase transactions.
Sales Register Sales transactions.
Exception Reports Identify possible errors or incomplete GST data.
Input Tax Summary Eligible ITC review.
Output Tax Summary GST collected from customers.
HSN/SAC Summary Goods and Services classification summary.
These reports help verify GST data before filing GST returns.
4. How to View GST Reports
Steps
  1. Open Tally Prime.
  2. Go to Display More Reports.
  3. Select Statutory Reports.
  4. Choose GST.
  5. Select the required GST Report.
  6. Review the report carefully.
Always verify GST reports before preparing GST returns.
5. GST Reporting Workflow
  1. Record Purchase Vouchers.
  2. Record Sales Vouchers.
  3. Verify GST Ledgers.
  4. Open GST Reports.
  5. Review Purchase & Sales Registers.
  6. Check Input and Output GST.
  7. Correct any errors.
  8. Prepare GST Returns.
A systematic review of GST Reports ensures accurate GST compliance and reporting.
6. GST Summary Report

The GST Summary Report provides an overall summary of GST transactions recorded during a selected period. It displays tax liability, Input Tax Credit (ITC) and other GST-related information.

Navigation
  1. Gateway of Tally → Display More Reports
  2. Select Statutory Reports.
  3. Select GST.
  4. Open GST Summary.
Section Purpose
Outward Supplies View taxable sales.
Inward Supplies View taxable purchases.
Input Tax Credit Review eligible ITC.
Output Tax Liability Review GST collected.
Exceptions Identify transactions requiring attention.
Review the GST Summary before preparing GST returns to ensure that all transactions have been recorded correctly.
7. Purchase Register & Sales Register

The Purchase Register and Sales Register provide detailed lists of GST transactions recorded during a selected period.

Report Purpose
Purchase Register Shows all purchase transactions.
Sales Register Shows all sales transactions.
Supplier Details Displays supplier-wise purchases.
Customer Details Displays customer-wise sales.
GST Amount Shows tax calculated on each voucher.
Benefits
  • Verify voucher entries.
  • Identify duplicate or missing transactions.
  • Match invoices with accounting records.
  • Prepare GST returns more accurately.
Regularly reviewing Purchase and Sales Registers helps maintain accurate GST records.
8. Input Tax Summary & Output Tax Summary

These reports help compare GST paid on purchases with GST collected on sales.

Input Tax Summary Output Tax Summary
GST paid on purchases. GST collected on sales.
May be available as Input Tax Credit (ITC), subject to GST law. Represents Output GST liability.
Based on Purchase Vouchers. Based on Sales Vouchers.
Used while determining eligible ITC. Used while determining GST payable.
Example
Description Amount
Output GST ₹90,000
Eligible Input GST ₹60,000
Net GST Liability ₹30,000
Always reconcile eligible Input GST with Output GST before preparing GST returns.
9. Exception Reports & GST Return Verification

Exception Reports highlight transactions that may contain incomplete or incorrect GST information.

Exception Recommended Action
Missing GSTIN Update the Party Ledger.
Incorrect HSN/SAC Code Correct the Stock Item details.
Missing GST Rate Update GST configuration.
Voucher Pending Verification Review and correct the voucher.
Incorrect Tax Classification Verify the GST nature of the transaction.
Before Filing GST Returns
  • Verify GST Summary.
  • Review Purchase Register.
  • Review Sales Register.
  • Check Input Tax Summary.
  • Check Output Tax Summary.
  • Resolve all Exception Reports.
Resolving exceptions before filing GST returns helps reduce reporting errors.
10. Common Mistakes While Reviewing GST Reports
Common Mistake Correct Practice
Ignoring Exception Reports. Resolve all exceptions before filing returns.
Incorrect GST Rate. Verify GST configuration for all items.
Wrong GSTIN. Check customer and supplier GSTINs.
Missing Purchase Vouchers. Ensure every taxable purchase is recorded.
Missing Sales Vouchers. Record every taxable sale.
Incorrect HSN/SAC Code. Update stock items with correct codes.
Not reconciling Input and Output GST. Review tax summaries regularly.
Filing returns without verification. Review all GST reports before filing.
Regular GST report verification improves accounting accuracy and helps ensure timely GST compliance.
11. Real Business Case Studies

Let's understand how different businesses use GST Reports to monitor GST transactions and prepare accurate GST returns.

Business GST Report Used Purpose
Retail Shop Sales Register Verify daily GST sales invoices.
Manufacturing Company Purchase Register Review GST on raw material purchases.
Medical Store GST Summary Check total GST collected and paid.
Software Company Output Tax Summary Review GST on software services.
Wholesale Distributor Input Tax Summary Verify eligible Input Tax Credit.
E-Commerce Business Exception Report Identify missing GST details before filing returns.
Regular review of GST Reports helps businesses maintain accurate tax records and simplifies GST return preparation.
12. GST Report Verification Checklist
Checklist Item Status
Purchase Vouchers Verified ✔
Sales Vouchers Verified ✔
Customer GSTIN Checked ✔
Supplier GSTIN Checked ✔
HSN/SAC Codes Verified ✔
GST Rates Verified ✔
Input Tax Summary Reviewed ✔
Output Tax Summary Reviewed ✔
GST Summary Reviewed ✔
Exception Reports Cleared ✔
GST Liability Verified ✔
GST Returns Ready for Filing ✔
Use this checklist before filing GST returns to reduce errors and ensure complete GST compliance.
13. Professional GST Reporting & Reconciliation Tips
  • Review GST Reports at regular intervals instead of waiting until the return filing date.
  • Match Purchase Register entries with supplier invoices.
  • Match Sales Register entries with customer invoices.
  • Verify HSN and SAC Codes for all taxable items and services.
  • Review GST Summary after every major accounting period.
  • Resolve all Exception Reports promptly.
  • Reconcile eligible Input Tax Credit with purchase records.
  • Verify Output GST before preparing GST returns.
  • Keep supporting invoices and documents safely.
  • Back up Tally Prime data regularly.
Professional accountants reconcile GST Reports every month to identify errors early and maintain accurate statutory records.
14. Practical Exercise & Interview Questions
Practical Exercise
  1. Open the GST Summary Report.
  2. Review the Purchase Register.
  3. Review the Sales Register.
  4. Check the Input Tax Summary.
  5. Check the Output Tax Summary.
  6. Identify any Exception Reports.
  7. Correct one GST-related error in a voucher.
  8. Verify that the GST Summary updates correctly.
Interview Questions
  1. What are GST Reports?
  2. Why are GST Reports important?
  3. How do you open GST Reports in Tally Prime?
  4. What information does the GST Summary provide?
  5. What is the purpose of the Purchase Register?
  6. What is the purpose of the Sales Register?
  7. What is the Input Tax Summary?
  8. What is the Output Tax Summary?
  9. What are Exception Reports?
  10. Why should GST Reports be reviewed before filing returns?
  11. How do you verify GST calculations?
  12. Why is GST reconciliation important?
  13. What should you do if a GSTIN is incorrect?
  14. How do HSN and SAC Codes affect GST Reports?
  15. How can missing vouchers affect GST Reports?
  16. How do GST Reports support GST return preparation?
  17. Which GST report helps identify incorrect transactions?
  18. How often should GST Reports be reviewed?
  19. What precautions should be taken before filing GST returns?
  20. Why is GST reporting important for accountants?
15. Lesson Summary
  • Learned the purpose of GST Reports.
  • Reviewed the GST Summary Report.
  • Understood the Purchase and Sales Registers.
  • Compared Input Tax Summary and Output Tax Summary.
  • Learned how to identify and resolve GST exceptions.
  • Studied GST report verification procedures.
  • Reviewed practical business examples.
  • Completed practical exercises.
  • Prepared for GST interviews.
  • Built a strong foundation for GST reporting and reconciliation.
Congratulations! You can now confidently use GST Reports in Tally Prime to verify GST transactions, reconcile tax data, identify exceptions and prepare accurate GST returns.

🧠 Quick Quiz

Which report is primarily used to review GST collected on sales?



← Previous Next →