Product Help and Support
What's newVideo tutorialsFAQsContact support
  • Product Guides
  • Clear Finance Cloud
    • 📢Release Notes - Clear Finance Cloud
    • GST Compliance
      • GSTR-1 Filing
      • GSTR-3B Filing
      • GSTR-6 Filing
      • GSTR-7 Filing
      • GSTR-8 Filing
      • ITC-04 Filing
      • GSTR-9 Filing
      • GSTR-9C Filing
      • GSTR-1 vs SR Recon
      • GSTR-2B vs PR Recon
      • Ewb vs G1 Recon
    • E-Invoicing
      • ClearE-Invoicing Video Tutorials
      • Authorising Clear to generate IRN
      • Get started with ClearE-Invoicing
        • Account Setup
          • Create an account
          • Register Defmacro as GSP
          • Set up Business Unit
          • Upload Documents
          • Generate IRN
        • Quick Start Guide
          • Add new members to account
          • Add additional GSTINs/Branches
          • Add NIC Credentials
          • Add UPI ID for B2C QR Code
      • E-Invoicing
        • Upload Data
          • User Guides
            • Upload E-Inv Data - Government Template
            • Upload E-Inv Data - Custom Template
          • FAQs
        • E-Invoice Generation
          • User Guides
          • FAQs
        • E-invoice Cancellation
          • User Guide
          • FAQs
        • E-Invoice Printing
          • User guides
          • FAQs
        • Downloading e-invoices
        • E-Invoice Email
        • Import History
        • E-Inv Vs Sales Reconciliation
        • B2C QR Code
          • FAQs
      • E-Way Bills
        • Eway bill data upload
          • User guides
            • IRN based Eway bill (B2B)
            • Unified template to generate E-way bill for any document type
        • E-Way Bill Generation
        • Multi-Vehicle E-way Bill
        • Consolidated E-Way Bill
        • Update Transporter of E-way bills
        • Printing an E-Way Bill
        • Extend the validity of an e-Way bill
        • Filter by Blank Transporter ID or Vehicle Number
      • Filtering expiring e-Way bills
      • Settings/Configurations
        • ClearIRP API credentials
          • How do I register my GSTIN on ClearIRP from Clear eInvoicing?
          • How do I create API creds if my GSTIN is already registered?
          • I have already created API credentials for my GSTIN, how do I add them?
          • FAQs
        • NIC Credentials
        • Integration Settings
        • E-Way Bill Settings
        • Import Settings
        • Email Settings
        • Business Settings
        • Contact Master
        • User Roles
        • Copy of User Roles
      • E-Invoice & E-way bill error resolution
      • Tally Connector for E-Invoicing
        • Installation
        • User Manual
      • Help
      • FAQs
      • What's new in ClearE-Invoicing
    • ClearID
  • For Enteprises
    • ClearGST
      • ClearGST Video Tutorials
      • Get started with ClearGST
        • Account Setup
          • Add new members to business
          • Install ClearTax Assistant
        • Quick Start Guide
          • Filing Dashboard
          • GSTIN Verification
          • Collect GSTIN of customers
          • Import Data
      • Generate Reports
        • Comparison Reports
          • GSTR-3B vs 1 Comparison Report
          • GSTR-3B Vs 2A Comparison Report
        • Purchase and 2A/2B/6A/4A Reports
          • Multi-month GSTR-2A Report
          • Multi-month GSTR-2B Report
          • GSTR-4A Report
          • Supplier Compliance Reports
        • Sales and G1
          • Rate wise Sales Summary Report
          • Sales HSN Summary Report
          • GSTR-1 Rate wise Summary Report
          • GSTR-1 HSN Summary Report
        • PAN Level Reports
          • PAN Level Multi-Month GSTR-2B Report
        • ITC Cash Ledger Reports
          • Cash Ledger Reports
          • ITC Ledger Reports
        • Tax Saving Reports
          • GSTR 3B vs 1 vs Books Report
          • GSTR 3B vs 2B vs Books Report
        • Filed Reports
      • Reconciliation
        • GSTR-1 vs Sales Register Matching
        • GSTR-2A Vs PR GSTIN Matching
        • GSTR-2A Vs PR PAN Matching
        • GSTR-2B Vs PR GSTIN Matching
        • GSTR-1 Vs E-Way Bill Matching
        • GSTR-9 (Table-8A) Vs PR Matching
      • File Returns
        • GSTR-1
        • GSTR-3B
        • GSTR-4
        • GSTR 6
        • GSTR-9
        • GSTR-9C
      • Tally Connector for GST
        • Prerequisites to Configure Tally for GST
        • Configuring Tally for GST
        • User Manual for GST Tally Connector
        • Common Tally Errors and Resolution
          • Connection issues with Tally
            • Firewall issues for Tally Connector
          • Errors in data imported via Tally
            • Mismatch in Total CGST Value
            • Mismatch in Reverse Charge
            • Mismatch in Export Type
            • Length of Import Bill of Entry Number
            • Invalid receiver GSTIN
            • Mismatch in Seller GSTIN and State
            • Invalid HSN/SAC Code
      • FAQs
        • Get started
        • Data Import
        • File Returns
        • Generate Reports
        • Reconciliation
      • What's new in ClearGST
    • ClearMax ITC
      • Get started with ClearMax ITC
      • Max ITC Reconciliation
        • Data Import
      • ITC Claim Wizard
      • Actions after running recon
      • Extra Functionalities
      • Vendor Payments
      • Table 4 changes
      • FAQs
    • ClearCapture
      • Get started with ClearCapture
        • Register Defmacro as GSP
        • Create an account
        • Add a Business Unit
        • Add GSTIN credentials
        • Add NIC credentials
        • Import invoices
        • Review invoices
        • Export invoices
        • Smart Aggregation
        • Export Issues
      • FAQ's
    • ClearTDS
      • TDS Returns
        • Prepare TDS Return
        • e-Filing TDS Returns
        • e-filing 24Q4 return
          • Form 24Q4 - Original return
          • Form 24Q4 - Correction return
        • Corrections to TDS Returns
      • Other Features
        • Filing Status Dashboard
        • Repository
        • Import and Track LDCs
        • Import Challans
        • ClearTDS Reports
        • Generate Form 16 and other TDS certificates
        • Settings
        • Retrieve Username Password in ClearTDS
        • LDC_Challan Tagging
      • 26AS Recon
        • Product Guide - 26AS Recon
    • ClearTax E-Invoicing KSA
      • Product Guides
        • Onboarding on ClearTax
        • Onboarding for E-Invoicing
        • Exploring the e-Invoicing homepage
        • Onboarding a new device (Online)
        • Onboarding a new offline device for PoS terminals
      • e-Invoicing with ClearTax on NCR-Aloha
        • Prerequisites for offline e-Invoice application
        • Create an account on ClearTax
        • Onboarding on web portal for e-Invoicing
        • Downloading and installing the offline e-Invoice application
        • Device registration on the PoS terminal
        • Generating e-Invoices and printing
      • Product Updates
      • ZATCA Updates
        • ZATCA Violations
        • ZATCA E-invoicing for Wave 2 customers announced
        • ZATCA Portal and APIs are going live
        • New SDK version update released by ZATCA
        • ZATCA Announces the Cancellation of Fines and Penalties
        • New SDK version update released by ZATCA
    • ClearTax E-Invoicing Malaysia
      • Onboarding
        • Create your profile
        • Register your business
      • B2B sales documents
        • Import your data
        • Generate e-invoice(s)
        • Generate consolidated e-invoice
        • Audit Trail
        • Delete imported data
        • Cancel an e-invoice
        • View rejection request
        • Print e-invoice(s)
        • Download report
        • E-mail invoice
        • Check sales import history
      • Purchase documents
        • Import data
        • Generate self-billed e-invoice(s)
        • Cancel a self-billed e-invoice
        • Print e-invoice(s) & download report
        • Check purchase import history
      • MIS Dashboard
      • Reconciliations
        • Reconciliation logic
        • Sales Register vs E-invoice Reconciliation
        • Purchase Register vs E-invoice Reconciliation
      • Settings
        • User access management
        • Custom Ingestion Template
        • Alerts and Communications
        • E-invoicing
          • Timezone
      • E-Invoicing customer portal
        • Registration & account creation
        • Generate your e-invoice
        • Download/Print generated e-invoice
      • Resources
        • Frequently asked questions (FAQs)
        • Error resolution guide
        • Add ClearTax as an intermediary on MyInvois portal
    • Clear Invoicing
    • Platform
      • SSO
    • Our APIs
  • For SMEs
    • ClearGST
      • ClearGST Video Tutorials
      • Get started with ClearGST
        • Account Setup
          • Add new members to business
          • Install ClearTax Assistant
          • Configuring Tally
        • Quick Start Guide
          • Filing Dashboard
          • GSTIN Verification
          • Collect GSTIN of customers
          • Import Data
      • Generate Reports
        • Comparison Reports
          • GSTR-3B vs 1 Comparison Report
          • GSTR-3B Vs 2A Comparison Report
        • Purchase and 2A/2B/6A/4A Reports
          • Multi-month GSTR-2A Report
          • Multi-month GSTR-2B Report
          • GSTR-4A Report
          • Supplier Compliance Reports
        • Sales and G1
          • Rate wise Sales Summary Report
          • Sales HSN Summary Report
          • GSTR-1 Rate wise Summary Report
          • GSTR-1 HSN Summary Report
        • PAN Level Reports
          • PAN Level Multi-Month GSTR-2B Report
        • ITC Cash Ledger Reports
          • Cash Ledger Reports
          • ITC Ledger Reports
        • Tax Saving Reports
          • GSTR 3B vs 1 vs Books Report
          • GSTR 3B vs 2B vs Books Report
        • Filed Reports
      • Reconciliation
        • GSTR-1 vs Sales Register Matching
        • GSTR-2A Vs PR GSTIN Matching
        • GSTR-2A Vs PR PAN Matching
        • GSTR-2B Vs PR GSTIN Matching
        • GSTR-1 Vs E-Way Bill Matching
        • GSTR-9 (Table-8A) Vs PR Matching
      • File Returns
        • GSTR-1
        • GSTR-3B
        • GSTR-4
        • GSTR-6
        • GSTR-9
        • GSTR-9C
      • FAQs
        • Get Started
        • File Returns
        • Generate Reports
        • Reconcilliation
      • What's new in ClearGST
    • ClearOne Suite
      • Get Started with ClearOne Suite
        • Account Setup
        • Quick Start Guide
          • Add Customers
          • Add Items
      • ClearInvoicing
      • ClearCompliance
        • ClearE-Invoicing
          • Create NIC Credentials
          • Add NIC Credentials
          • E-Invoice Generation
        • ClearE-WayBills
          • E-Way Bill Generation
      • FAQs
  • For Tax Experts
    • ClearPro Suite
      • ClearGST
        • ClearGST Video Tutorials
        • Get started with ClearGST
          • Account Setup
            • Add new clients
            • Add new members to Business
            • Install ClearTax Assistant
            • Configuring Tally
          • Quick Start Guide
            • Filing Dashboard
            • GSTIN Verification
            • Collect GSTIN of customers
            • Import Data
        • Generate Reports
          • Filed Reports
          • Tax Saving Reports
            • GSTR 3B vs 1 vs Books Report
            • GSTR 3B vs 2B vs Books Report
          • ITC Cash Ledger Reports
            • Cash Ledger Reports
            • ITC Ledger Reports
          • PAN Level Reports
            • PAN Level Multi-Month GSTR-2B Report
          • Sales and G1
            • Rate wise Sales Summary Report
            • Sales HSN Summary Report
            • GSTR-1 Rate wise Summary Report
            • GSTR-1 HSN Summary Report
          • Comparison Reports
            • GSTR-3B vs 1 Comparison Report
            • GSTR-3B Vs 2A Comparison Report
          • Purchase and 2A/2B/6A/4A Reports
            • Multi-month GSTR-2A Report
            • Multi-month GSTR-2B Report
            • GSTR-4A Report
            • Supplier Compliance Reports
        • Reconciliation
          • GSTR-1 vs Sales Register Matching
          • GSTR-2A Vs PR GSTIN Matching
          • GSTR-2A Vs PR PAN Matching
          • GSTR-2B Vs PR GSTIN Matching
          • GSTR-1 Vs E-Way Bill Matching
          • GSTR-9 (Table-8A) Vs PR Matching
        • File Returns
          • GSTR-1
          • GSTR-3B
          • GSTR-4
          • GSTR-6
          • GSTR-9
          • GSTR-9C
        • FAQs
          • Get Started
          • File Returns
          • Generate Reports
          • Reconcilliation
        • What's new in ClearGST
      • ClearTDS
        • Get started with ClearTDS
          • Retrieve Username Password in ClearTDS
        • TDS Returns
          • Prepare TDS Return
          • e-Filing TDS Returns
          • Corrections to TDS Returns
          • Revise TDS Returns
        • Generate Form 16 in ClearTDS
      • ClearTaxCloud
        • FAQs
      • ClearPro Desktop App
        • Import Data using Desktop App
        • File Returns on Desktop
          • GSTR-1 on Desktop App
          • GSTR-1 NIL Return on Desktop App
          • GSTR-3B on Desktop App
          • GSTR-3B Nil Return on Desktop app
          • GSTR-4 on Desktop App
          • GSTR-9 on Desktop App
          • GSTR-9C on Desktop App
        • Create a Challan and Pay Tax
  • For Individuals
    • File ITR
      • File ITR on ClearTax
      • FAQs
    • Invest and Save
      • FAQs
    • Expert Assistance
      • FAQs
  • Other Support Links
  • Video Tutorials
  • FAQs
  • ClearLearn
  • Contact support
Powered by GitBook
On this page
  • What is GSTR 3B vs GSTR 1 vs Books Report
  • Advantage of GSTR 3B vs GSTR 1 vs Books Report
  • Importance of Section level Summary in GSTR-3B vs 1 vs Books Report
  • Guide to Download GSTR 3B vs GSTR 1 vs Books Report
  • Step 1 : Select GSTR 3B vs 1 vs Books Reports
  • Step 2: Click on 'GSTN'
  • Step 3: Download GSTR-1/3B data from GSTN
  • Step 5: Download Report
  • Guide to Match GSTR-3B vs 1 vs Books Report in Overall Summary
  • PART A : Outward Supplies as per GSTR 3B
  • Step 1: Download GSTR 3B Filed Report
  • Step 2: Match relevant sections for each Return Period
  • PART B : Outward Supplies as per GSTR 1
  • Step 1 : Download the GSTR 1 Filed Report
  • Step 2 : Get Taxable value for Return period
  • Step 3: Identify Amendments and Original documents
  • Step 4:- Map and compare Amendments
  • Part C : Outward Supplies as per Books
  • Step 1 : Import data into ClearTax portal
  • Step 2: Select Template
  • Step 3: Select Import Your Data
  • Step 4 : Re-generate Report
  • Guide to fix discrepancies in GSTR-3B/1/Books data
  • Feedback
  1. For SMEs
  2. ClearGST
  3. Generate Reports
  4. Tax Saving Reports

GSTR 3B vs 1 vs Books Report

Learn how to use and analyze GSTR 3B vs GSTR 1 vs Books Report

What is GSTR 3B vs GSTR 1 vs Books Report

  • The GSTR 3B vs GSTR 1 vs Books report identifies and reconciles the differences between upcoming filings of GSTR 3B , GSTR 1 and books of accounts imported into Cleartax on both overall and section summary level

  • If the user’s data is filed , we compare the GSTR 3B data with filed GSTR-1 data. If the user’s data is not filed yet, before filing GSTR-3B, the user compares the supplies reported in GSTR-1 with the data reported in books of accounts with color coding for filed and not filed data

  • Green is used to mark the filed data while white for not filed or imported data. Differences are marked in red.

  • Reconciliation of outward supplies is a must to ensure that the details disclosed match the details disclosed in GSTR-1 and GSTR-3B as mismatch means there is shortage of tax paid by the supplier and the same must be paid along with interest @ 18 p.a and penalties.

Advantage of GSTR 3B vs GSTR 1 vs Books Report

With a quick fix reconciliation of differences before filing this report ensures maximum savings

Importance of Section level Summary in GSTR-3B vs 1 vs Books Report

  • GSTR-3B is a monthly summary return filed by a taxpayer.It discloses supplies made during the month along with GST to be paid, input tax credit claimed, purchases on which reverse charge is applicable, etc., and also makes a provision for the payment of taxes. GSTR-1 is a monthly or quarterly return filed by taxpayers to disclose details of their outward supplies for the month – along with their tax liability. Here, invoice-wise details are to be uploaded so that the Government can keep a check on every transaction

  • While filing GSTR-1 and GSTR-3B, there can be instances where reporting of supplies under the wrong table in GSTR-3B, but correctly reporting the same when declaring it invoice-wise in GSTR-1

  • There can be instances where reporting of supplies under the wrong table in GSTR-1, but correctly reporting the same when declaring it in GSTR-3B

Guide to Download GSTR 3B vs GSTR 1 vs Books Report

Step 1 : Select GSTR 3B vs 1 vs Books Reports

For selecting the reports, log into ClearTax GST, select the 'Business' tab

Then click on the 'Reports' tab and select 'GSTR 3B vs 1 vs Books Reports'

You can also access 'GSTR 3B vs 1 vs Books Reports' by clicking on Reports tab directly when logged into ClearTax GST

Step 2: Click on 'GSTN'

Step 3: Download GSTR-1/3B data from GSTN

Click on ‘Download data from GSTN’ to pull data from GSTN. The yearly data from the GSTN will be fetched after verification via OTP-based login credentials

Select the ‘Financial Year’ . Go to ‘Download GSTR-1 Data’ and ‘Download GSTR-3B data’ and click on ‘Download GSTR-1/3B data from GSTN’ respectively. Enable connection with GSTN by clicking on ‘Connect to GSTN’ incase the OTP is inactive

Step 5: Download Report

You can download the report by clicking on the ‘Download Report’ in Excel format

You can use , analyze and share the report in Excel form

Guide to Match GSTR-3B vs 1 vs Books Report in Overall Summary

PART A : Outward Supplies as per GSTR 3B

Step 1: Download GSTR 3B Filed Report

Download GSTR 3B Filed Report for relevant Return Periods and identify Table 3.1 ‘Details of Outward Supplies and inward supplies liable to reverse charge’

Step 2: Match relevant sections for each Return Period

Match relevant sections of Table 3.1 ‘Details of Outward Supplies and inward supplies liable to reverse charge’ with those of ‘PART A’ of the ‘GSTR 3B vs GSTR-1 vs Books Report’ for each Return Period

  • The following values will be included or excluded as per relevant sections of Table 3.1 ‘Details of Outward Supplies and inward supplies liable to reverse charge’ as falling under major tax heads and taxable value

  • To arrive at the value in ‘PART A’ of the ‘GSTR 3B vs GSTR-1 vs Books’ report , including or excluding the figures in the following table will render the required figures net of all documents i.e Invoice + Debit Notes - Credit Notes

PART B : Outward Supplies as per GSTR 1

Step 1 : Download the GSTR 1 Filed Report

Download the GSTR 1 Filed Report for relevant Return Periods

Step 2 : Get Taxable value for Return period

To arrive at the figure of Taxable value for each Return period , add the Taxable value of all the relevant sections as per GSTR-1 Filed Report as indicated in the following table

To arrive at the figure of Tax amount of major tax heads i.e IGST,CGST and SGST for each Return period , add the Tax amounts of all the relevant sections as per GSTR-1 Filed Report as indicated in the following table

Step 3: Identify Amendments and Original documents

To identify the Amendments related to previous months in GSTR-1 Filed report, look up all sections related to amendments i.e B2BA , B2CLA , B2CSA , EXPA , CDNRA , ATA , ATADJA and CDNURA

To identify the Original documents corresponding to such amendments in GSTR-1 Filed report , look up all sections related to original documents i.e B2B , B2CL , B2CS , EXP , CDNR , AT , ATADJ and CDNUR as per the ‘Original Invoice Number’ and ‘Original Invoice Date’ mentioned in the amendment document

Step 4:- Map and compare Amendments

Look up the amendments as per GSTR-1 Filed report and map to (c) (i) Amendment Value as identified in the previous step for each Return Period

Also, look up the Original Value pertaining to such amendments as in the previous step and map them to (c) (ii) Original Value in the same Return Period in which the amendment has been made

Take the net of amendment documents [ AMENDMENT - ORIGINAL ]

Part C : Outward Supplies as per Books

Step 1 : Import data into ClearTax portal

Incase data is not already present, navigate to ‘GSTR-1/3B Return’ flow to import data into ClearTax portal

Step 2: Select Template

Step 3: Select Import Your Data

After selecting the appropriate period, Select ‘Import Your Data’

Step 4 : Re-generate Report

After successfully importing data, navigate back to ‘MTSG GSTR-3B vs 1 vs Books Report’ ,you can ‘Re-generate report’ from ‘Fix it now’ Drop down in the report

Guide to fix discrepancies in GSTR-3B/1/Books data

Feedback

PreviousTax Saving ReportsNextGSTR 3B vs 2B vs Books Report

Last updated 3 years ago