Masters India GST Software
WebsiteProd Docs
  • 🖌️MastersIndia GST
  • INTRODUCTION
    • Dashboard
    • Configuration
      • Manage Business
      • Manage Users
      • Supplier Master
      • Manage FTP/SFTP
      • Import Tally Data
      • Sales and Purchase Validation off
      • Manage Template
    • Import Data
      • Sales/Purchase Import
      • Add Invoice
      • Exporting Invalid and Duplicate Invoices
      • View Data and Invoice Actions
      • E-invoices data from MI EDoc
    • GST Return
      • GSTR 1
      • GSTR 3B
      • GSTR 6
      • GSTR 9
      • GSTR 9C
      • GSTR-07
      • ITC-04
    • Invoice Management System (IMS)
      • IMS Module Configure and Reco Sync
      • IMS Invoice Actions
    • Reconciliation
      • GSTR-1 vs Sales Register Reconciliation
      • E-Invoice vs Sales Register Reconciliation
      • GSTR-2A vs Purchase Register Reconciliation
      • GSTR-2B vs Purchase Register Reconciliation
      • GSTR-9(8A) vs Purchase Register Reconciliation
      • GSTR-6A vs Purchase Register Reconciliation
      • Outward Eway-Bill vs GSTR-1 Reconciliation
      • IMS vs Purchase Register Reconciliation
    • Payment And Challan
      • How to Generate Challans
        • Manual Challan Generation
        • Saved Challans
      • Payment Methods
    • Notices & Orders
    • Reports
      • GST Reports
      • Comparison Reports
      • Filing Preference Report
      • Ledger Report
      • GSTIN Filing Report
      • Search GSTIN Report
      • ITC Ageing Report
      • ITC summary Report
      • Search GSTIN E-invoice Applicability
      • Cash and Credit Ledger Reports
      • ITC Reversal & Re-Claimed Statement
    • Tax-GPT
  • Help & Support
Powered by GitBook
On this page
  • How to Configure a Reconciliation Job?
  • Reconciliation Reports
  • Consolidated Report
  • Vendor Wise Summary Report
  • Column Wise Comparison Report
  • Bulk Operation
  • Steps to use the Bulk Operation Feature:
  • Latest Added Features
  • 1. Match Delink Button
  • 2. Invoice Date Buffer Range in Accept Rule
  • 3. Credit/Debit Swap

Was this helpful?

  1. INTRODUCTION
  2. Reconciliation

GSTR-2B vs Purchase Register Reconciliation

Matching Between GSTR-2B and Purchase to make GSTR-2B more accurate.

PreviousGSTR-2A vs Purchase Register ReconciliationNextGSTR-9(8A) vs Purchase Register Reconciliation

Last updated 4 months ago

Was this helpful?

How to Configure a Reconciliation Job?

  1. Step 1: Log in to Masters India GST Software with valid credentials then click Sign In.

  1. Step 2: After Sign-In - 'Dashboard' will appear - click – the 'GST Reconciliation' module on the left Navigation Bar.

  2. Step 3: Click on GSTR-2B Vs PR Register ‘View Reconcile’ tab

  1. Step 4: Click on Configure New Reco

  1. Step 5: Return Period: Users can select the custom return period for Purchase and 2B as shown below

  1. Step 6: Select Businesses: Users can 'Select GSTIN's from the drop-down, for which they want to execute the reconciliation on a regular basis.

  1. Step 7: Frequency - User can select the frequency for Auto- reconciliation by clicking the drop down.

  1. Step 8: Start Date- The user can select the Start Date for Reconciliation.

  2. Step 9:Start Time- The user can select a time to Start reconciliation.

  3. Step 10: Segregated by GSTIN- In case a user have multiple registrations and wants to submit a job separately for all their GSTIN, the user can select this checkbox. Note: Preferably, we ask users not to select the checkbox to get results for all their business units under a single Job

  4. Step 11: FTP Settings- In case the user is using the FTP Mechanism, the user needs to select below FTP option. Import data from FTP 2) Save Reports from FTP 3) Select FTP settings (Drop down to select different FTP settings)

  1. Step 13: Auto Accept Rules - Select to Auto Accept any B2B/CDN mismatched invoices. User can select different options under B2B/CDN to Accept Invoices with these mismatched details.

  1. Step 14: Buffer Tax value- It is a tax tolerance value or tax threshold value a user can input according to their business operations.

  2. Step 15: Buffer Taxable Value - It is a taxable tolerance value or taxable threshold value a user can input according to their business operations.

  1. Step 17: After clicking - 'Submit' button , user will be redirected to Job list page - mentioning the Serial Number of Jobs and their GSTIN along with other details

Reconciliation Reports

Users can download a combined reco report for all invoice types in a single sheet. If such a report needs to be downloaded, then the User needs to click on the consolidated report and click next. Later, select the Business GSTIN, 2B and purchase return period and invoice type. Click on the combine check box and then click on the download button.

Consolidated Report

This is a consolidated report where a user can get Invoice Level Wise (Both 2B &PR) bucket segregation of Invoices. This includes all the invoices users have accepted or have forced Match.

Vendor Wise Summary Report

It is a report containing all unique vendors and their status according to 2B, PR & Reconciliation.

In other words, a summary will be generated by the system which will provide values against each GSTIN present in 2B, PR, Match, Mismatch, Not Present in PR, Not Present in 2B, Invoice Number Mismatch, & Not Reconcile.

Column Wise Comparison Report

It is a reorganised consolidated report, where the two columns having the same data from two data sets (purchase register and GSTR-2B) from the consolidated report adhered together. This adherence gives rise to a column-to-column comparison, which would be very helpful for the users to check their final reconciliation working.

Bulk Operation

Users can use the Bulk operations feature in the following cases:-

  1. Bulk Accept: If the user wants to accept a certain number of invoices.

  2. Bulk De-Link: If the user wants to de-link a certain number of invoices.

  3. Bulk Remark: If the user wants to update remarks on a certain number of invoices.

  4. Bulk Force Match: If the user wants to force match a certain number of invoices.

Steps to use the Bulk Operation Feature:

  1. Go to the Reconciliation job list, and click on the Action button for the reconciliation job you want to operate.

  2. Select the Bulk Job option from the list.

  1. Once the side screen opens for the bulk operation, click on the "Export" button and select the required action file to download the sample template.

  1. Once the file is downloaded, prepare the file by entering the details as per the headers provided and save it.

  2. Now come to the Masters India Portal again and click on the "Upload File" Button to import your prepared data. Select the operation and import the file.

  1. Once the file is imported, a job will be scheduled and the same will be reflected on the Bulk Operation listing. Once the job status is completed, the operation will be completed.

Latest Added Features

1. Match Delink Button

Users can delink matched invoices through the delink button as per their requirements.

2. Invoice Date Buffer Range in Accept Rule

While reconciliation, users can provide a date range for accepting invoices which are mismatched on an invoice date basis

3. Credit/Debit Swap

If the client is accounting with different note types then there is a feature to make custom changes i.e. Swapping of Note types in profile settings.

Page cover image