GSTR-2A vs Purchase Register Reconciliation

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

How to Configure the Reconciliation?

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

Step 2: After Signing In, the 'Dashboard' will appear. Click the 'GST Reconciliation' tab on the left Navigation Bar.

Step 3: Click on the "GSTR-2A Vs Purchase Register' tile.

Step 4: Click on 'Configure New Reco'

Step 5: Configure Reconciliation Job

1. Return Period- Users can select the custom return period for Purchase and GSTR-2A as shown below.

1. Select Businesses- Users can select GSTINs from the drop-down, for which they want to execute the reconciliation regularly.

1. Frequency- Users can select the frequency for auto-reconciliation by clicking the drop-down.

1. Start Date- Users can select the Start Date for Reconciliation.

2. Start Time- Users can choose the Start Time to Start Reconciliation.

1. Segregated by GSTIN checkbox: If a user has 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

1. 2A Refresh Time- A user can choose a time to refresh their 2A for all the business units at a go using this option.

Note: Kindly make sure to have at least 3 hours of Gap in 2A Job Submission & Reconciliation Job Submission so that updated 2A can participate in the reco.

1. FTP Settings- in case user is using FTP Mechanism, user need to select below FTP options.

2. Import data from FTP

2) Save Reports from FTP

3) Select FTP settings (Drop down to select different FTP settings)

Step13: 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

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

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

Step16:User can select Reconcile CFS -Y only option to reconcile data having Counter party filling status with Y

Step17: 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.

Step22: 'Download' Button: User can click global 'Download' button on the top right corner to get Reconciliation Reports 'Consolidated Reports' or 'Vendor Wise Summary Report

Reconciliation Reports

Consolidate Reports

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

Vendor Wise Summary Report

This is a report containing all unique vendors and their status according to 2A, PR, and reconciliation. In other words, the system will generate a summary that provides values against each GSTIN present in 2A, PR, Match, Mismatch, Not Present in PR, Not Present in 2A, Invoice Number Mismatch, and Not Reconcile.

SUMMARY VIEW FEATURES-

● User can view summary of GSTR2A and PURCHASE and can download in excel format

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.

3. 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 of the same.

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.