IMS vs Purchase Register Reconciliation
Last updated
Was this helpful?
Last updated
Was this helpful?
Step 1: Log in to Masters India GST Software with valid credentials then click Sign In.
Step 2: After Signing in the 'Dashboard' module will appear. Click on the 'GST Reconciliation' module on the Navigational bar on the left.
Step 3: Click on the IMS Vs Purchase Register ‘View Reconcile’ tab
Step 4: Click on the 'Configure New Reco' button.
Step 5: Configure Reconciliation Job
Purchase Return Period: Users can select the custom return period for the Purchase Return Period as shown below.
IMS Return Period: Select the IMS return period.
Select Businesses: Users can 'Select GSTINs' from the drop-down, for which they want to execute the reconciliation regularly.
Frequency: Users can select the frequency for Auto-reconciliation by clicking the drop-down.
Start Date: Users can select the Start Date for Reconciliation.
Start Time: Users can select the time to Start reconciliation.
Segregated by GSTIN Checkbox: In case 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.
Buffer Tax Value: It is a tax tolerance value or tax threshold value a user can input according to their business operations.
Buffer Taxable Value: It is a taxable tolerance value or taxable threshold value a user can input according to their business operations.
Step 6: After clicking - the 'Submit' button, the user will be redirected to the Job list page - mentioning the Serial Number of Jobs and their GSTIN along with other details.
'Download' Button: The user can click the 'Global 'Download' button on the top right corner to get Reconciliation Reports 'Consolidated Reports' or 'Vendor Wise Summary Report'.
This is a consolidated report where a user can get Invoice Level Wise (Both IMS &PR) bucket segregation of Invoices. This includes all the invoices users have accepted or have forced Match.
It is a report containing all unique vendors and their status according to IMS, PR & Reconciliation. In other words, a summary will be generated by the system which will provide values against each GSTIN present in IMS, PR, Match, Mismatch, Not Present in PR, Not Present in IMS, Invoice Number Mismatch, & Not Reconcile.
Users can use the Bulk operations feature in the following cases:-
Bulk Accept: If the user wants to accept a certain number of invoices.
Bulk De-Link: If the user wants to de-link a certain number of invoices.
Bulk Remark: If the user wants to update remarks on a certain number of invoices.
Bulk Force Match: If the user wants to force match a certain number of invoices.
Go to the Reconciliation job list, and click on the Action button for the reconciliation job you want to operate.
Select the Bulk Job option from the list.
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.
Once the file is downloaded, prepare the file by entering the details as per the headers provided and save it.
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.
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.
