Training By Himanshu

Tag: tally prime gst tutorial

  • Step-by-Step Guide: How to File GSTR-1 in Tally Prime Accurately and Easily (Complete Tutorial)

    Filing GSTR-1 is one of the most important responsibilities for every GST-registered business in India. It is a monthly or quarterly return that contains all the details of outward supplies (sales) made during the period. Tally Prime, one of India’s most trusted accounting software, simplifies this process by automating data compilation and helping users file GSTR-1 accurately.

    This article provides a complete, step-by-step guide on how to file GSTR-1 in Tally Prime, along with detailed explanations, tables, and best practices to ensure error-free compliance.

    What is GSTR-1?

    GSTR-1 is a return that includes details of outward supplies of goods or services made by a registered taxpayer under GST. It must include invoice-wise sales data, debit and credit notes, and export invoices.

    Key Facts About GSTR-1:

    ParticularsDetails
    Form NameGSTR-1
    Type of ReturnOutward Supplies (Sales) Return
    Who Must FileEvery GST-registered dealer
    FrequencyMonthly (if turnover > ₹1.5 crore) / Quarterly (if turnover ≤ ₹1.5 crore)
    Due Date (Monthly)11th of the following month
    Due Date (Quarterly)13th of the month following the quarter end
    PurposeTo report all sales transactions under GST

    Why File GSTR-1 Using Tally Prime?

    Tally Prime automates the entire process of preparing and exporting GSTR-1 data. It reduces manual effort and minimizes errors while ensuring accuracy.

    Key Benefits of Using Tally Prime for GSTR-1:

    1. Auto-calculates GST for each transaction.
    2. Classifies sales transactions correctly (B2B, B2C, Exports).
    3. Identifies missing or incorrect GSTINs automatically.
    4. Enables direct JSON export for GST portal upload.
    5. Helps reconcile data with GSTR-3B and GSTR-2A.

    Step-by-Step Process: How to File GSTR-1 in Tally Prime

    Let’s now explore each step in detail.

    Step 1: Activate GST in Tally Prime

    Before filing GSTR-1, GST must be activated in your company data.

    To enable GST:

    1. Open your company in Tally Prime.
    2. Go to Gateway of Tally → F11 (Features) → Statutory Features.
    3. Set Enable Goods and Services Tax (GST) to Yes.
    4. Enter your GSTIN, State, and Registration Type.
    5. Accept the screen and save settings.

    This ensures Tally Prime starts tracking all GST-related data automatically.

    Step 2: Record Sales Transactions

    Once GST is enabled, all your outward supplies (sales) must be recorded correctly.

    To record a GST-compliant sales voucher:

    1. Go to Gateway of Tally → Vouchers → F8: Sales.
    2. Select the Customer Ledger (ensure GSTIN is entered).
    3. Choose the correct Sales Ledger (e.g., Local Sales, Interstate Sales).
    4. Enter Stock Items, Quantity, Rate, and Taxable Value.
    5. Tally will automatically calculate CGST, SGST, or IGST as per place of supply.
    6. Save the voucher.

    Make sure all transactions are updated regularly to keep your data ready for GSTR-1 reporting.

    Step 3: Check GSTR-1 Report in Tally Prime

    Tally Prime offers a built-in GSTR-1 report that automatically compiles all outward supply details.

    To view GSTR-1:

    1. Go to Gateway of Tally → Display More Reports → Statutory Reports → GST Reports → GSTR-1.
    2. Choose the reporting period (month or quarter).
    3. The screen will display data categorized under various tables of GSTR-1 such as:
      • B2B Invoices
      • B2C (Large)
      • B2C (Small)
      • Exports
      • Credit/Debit Notes
      • Nil-rated/Exempted supplies

    Step 4: Understand GSTR-1 Report Structure in Tally Prime

    Tally presents GSTR-1 data in a structure that mirrors the actual GST form.

    SectionDetails IncludedPurpose
    B2B InvoicesBusiness-to-Business sales with GSTINCaptures taxable value and tax rate per invoice
    B2C (Large)Business-to-Consumer sales > ₹2.5 lakh (Interstate)Identifies large consumer sales
    B2C (Small)Sales to unregistered customers < ₹2.5 lakhConsolidated data
    ExportsZero-rated sales (with/without payment of tax)Export transactions
    Credit/Debit NotesAdjustments against salesReflects return or additional charges
    Nil/Exempted/NON-GSTNon-taxable salesSummary view

    Step 5: Verify and Correct Errors

    Before exporting your return, verify the report carefully.

    • Check for missing GSTINs in B2B invoices.
    • Ensure HSN codes are entered for all goods/services.
    • Confirm GST rates are correctly applied.
    • Verify place of supply for interstate transactions.
    • Review credit/debit notes for correct linkage.

    Tally Prime also highlights any errors or missing data in red for easy identification.

    Step 6: Export GSTR-1 Data from Tally Prime

    After validation, the next step is to export your data in a format compatible with the GST portal.

    To export the report:

    1. From the GSTR-1 screen, press Alt + E (Export).
    2. Choose Format: JSON (Data Interchange Format).
    3. Select the return period and destination folder.
    4. Press Enter to export.

    Tally will create a GSTR1.json file containing all your outward supply data.

    Step 7: Upload JSON File on GST Portal

    Once the file is generated, log in to the GST portal and upload it under the GSTR-1 section.

    The portal will validate your data and show any discrepancies. After successful upload, preview the summary, make corrections if needed, and submit the return.

    Step 8: File GSTR-1 with EVC or DSC

    After reviewing, file the GSTR-1 return using:

    • EVC (Electronic Verification Code) for proprietors and partnerships.
    • DSC (Digital Signature Certificate) for companies and LLPs.

    Once filed, an Acknowledgment Reference Number (ARN) will be generated, confirming successful submission.

    Common Mistakes to Avoid While Filing GSTR-1 in Tally Prime

    MistakeImpactHow to Avoid
    Missing GSTIN for B2B customersRejection of invoicesUpdate all GSTINs in ledger masters
    Incorrect HSN/SAC codesMismatch in complianceMaintain correct HSN/SAC mapping
    Wrong tax rate appliedOver/under paymentUse correct GST ledgers
    Not reconciling before filingMisreportingMatch with GSTR-3B
    Forgetting debit/credit notesData mismatchInclude all notes before export

    Pro Tips for Accurate GSTR-1 Filing in Tally Prime

    1. Use proper voucher classification (local, interstate, export).
    2. Reconcile GSTR-1 with GSTR-3B monthly.
    3. Maintain HSN summary for every sale item.
    4. Regularly update ledgers and stock masters with correct GST details.
    5. Review Nil-rated and exempted sections to ensure full reporting.
    6. Backup data before final export to prevent file loss.

    Advantages of Using Tally Prime for GSTR-1 Filing

    FeatureBenefit
    Automated GST calculationReduces manual workload
    Built-in error detectionEnsures accurate return
    JSON export supportSeamless GST portal integration
    Multi-period analysisHelps monitor filing consistency
    Data reconciliationMatches sales with purchase returns

    Conclusion: Simplify GST Compliance with Tally Prime

    Filing GSTR-1 in Tally Prime is not just about generating reports—it’s about ensuring accuracy, compliance, and efficiency. With its automated GST features, Tally Prime saves time and minimizes errors. Whether you are a small business or a large enterprise, mastering this process ensures smooth GST return filing and avoids penalties.

    By following the above step-by-step method, you can prepare, verify, export, and file your GSTR-1 return confidently every month or quarter.

    Disclaimer

    This article is for informational and educational purposes only. The procedures, rules, and due dates mentioned are subject to change as per GST laws and government notifications. Users are advised to verify the latest updates before filing returns.

  • Tally Multi GST Rate Entry in Tally Prime – Step-by-Step Guide with Examples for Tally Interview

    In modern business accounting, it’s common for companies to deal with products or services taxed at different GST rates. For example, a company may sell two categories of products:

    • Category 1: 18% GST
    • Category 2: 12% GST

    If you are a Tally user or preparing for a Tally interview, knowing how to handle multiple GST rate entries is crucial. In this guide, we will explain step-by-step how to enter multiple GST rates in Tally Prime.

    What is Multi GST Rate Entry?

    Multi GST Rate Entry in Tally Prime refers to the ability to record transactions with different GST rates in a single invoice or voucher. This is useful when your company sells products or services under different GST slabs.

    Benefits of Multi GST Rate Entry

    • Reduces manual effort of creating multiple invoices
    • Ensures accurate GST calculation for all categories
    • Simplifies reporting for GST returns
    • Commonly tested in Tally interviews

    Scenario Example

    Suppose your company sells:

    Product CategoryGST RateSale Amount
    Electronics18%₹50,000
    Stationery12%₹20,000

    You want to record both sales in a single invoice.

    Step-by-Step Procedure in Tally Prime

    1. Enable GST in Tally Prime

    1. Go to Gateway of Tally → F11: Features → Statutory & Taxation
    2. Enable Goods and Services Tax (GST)
    3. Set GST details like state, GSTIN, and registration type

    2. Create GST Ledgers

    1. Navigate to Accounts Info → Ledgers → Create
    2. Create GST ledgers for each rate:
      • CGST 9% (for 18% GST)
      • SGST 9% (for 18% GST)
      • CGST 6% (for 12% GST)
      • SGST 6% (for 12% GST)

    Tip: Tally automatically calculates CGST and SGST based on GST rate selected.

    3. Create Stock Items

    1. Navigate to Inventory Info → Stock Items → Create
    2. Enter details for each product:
      • Name
      • Unit of Measure
      • GST rate (e.g., 18% for Electronics, 12% for Stationery)

    4. Record Sales Voucher with Multi GST Rates

    1. Go to Accounting Vouchers → F8: Sales
    2. Select Party Name (customer)
    3. Add stock items with respective GST rates
    4. Tally will calculate GST automatically for each category
    5. Verify tax amount for each GST rate

    Example Voucher Table

    ProductQuantityRateAmountGST RateCGSTSGSTTotal
    Electronics105,00050,00018%4,5004,50059,000
    Stationery10020020,00012%1,2001,20022,400
    Total70,0005,7005,70081,400

    5. Verify GST Report

    • Navigate to Display → Statutory Reports → GST → GST Liability
    • Check CGST and SGST separately for each GST rate
    • Ensure all entries are accurately reflected

    Key Points for Tally Interview

    • Always mention stock items assigned with correct GST rates
    • Explain CGST and SGST calculation
    • Demonstrate multi GST rate entry in a single invoice
    • Show how to verify using GST reports in Tally Prime

    Conclusion

    Handling multiple GST rates in Tally Prime is essential for accurate accounting in businesses dealing with diverse products or services. By mastering Multi GST Rate Entry, you can save time, ensure compliance, and impress in Tally interviews.

    💡 Pro Tip: Always double-check GST ledgers and stock items before recording the voucher to avoid errors in GST calculation.

    Tally Interview Questions & Answers – Multi GST Rate Entry

    Q1: What is Multi GST Rate Entry in Tally Prime?

    A1: Multi GST Rate Entry allows you to record transactions where different GST rates apply to different products or services in a single invoice. For example, electronics may have 18% GST, while stationery has 12% GST. Tally automatically calculates CGST and SGST for each category.

    Q2: How do you enable GST in Tally Prime?

    A2: To enable GST in Tally Prime:

    1. Go to Gateway of Tally → F11: Features → Statutory & Taxation
    2. Enable Goods and Services Tax (GST)
    3. Enter GST details such as state, GSTIN, and registration type
      This allows Tally to manage GST for all transactions.

    Q3: How do you record a sales transaction with multiple GST rates?

    A3: Steps to record multi-GST rate sales:

    1. Create stock items with respective GST rates.
    2. Create GST ledgers for CGST and SGST at different rates.
    3. Go to Accounting Vouchers → F8: Sales, select customer, and add products with their GST rates.
    4. Tally calculates GST automatically for each item.

    Q4: How can you verify that GST is calculated correctly for multiple rates?

    A4: You can verify GST calculations in Tally Prime by:

    1. Navigating to Display → Statutory Reports → GST → GST Liability
    2. Checking CGST and SGST totals for each GST rate
    3. Drilling down into vouchers to ensure correct GST amounts for each product category

    Q5: Why is knowledge of Multi GST Rate Entry important for Tally interviews?

    A5: Multi GST Rate Entry is commonly tested in Tally interviews because it shows:

    • Understanding of GST concepts
    • Ability to record complex invoices
    • Accuracy in financial reporting
    • Practical knowledge of Tally Prime accounting features