E-Invoice vs Sale Reconciliation

Matching Between E-Invoice and Sales to make E-Invoice more accurate.

Steps1: Login to Enterprise with valid credentials then click Sign In.

Step2: After Sign-In - 'Dashboard' will appear - click – 'GST Reconciliation' tab on left

Step 3: Click on E-Invoice Vs Sales Register ‘View Reconcile’ tab

Step 4: Click on Configure New Reco

Step 5 (A): Return Period- User can select the custom return period for E-INVOICE as shown below

Step 5 (B): Select Sales Register return period

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

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

CONFIGURE RECO JOB

Step 8: Start Date- User can select the Start Date for Reconciliation.

Step 9:Start Time- User can select time to Start reconciliation.

Step 10: Segregated by GSTIN- In case user have multiple registrations and wants to submit a job separately for all their GSTIN, user can select this checkbox.

Note: Preferably, we ask users to not to select the checkbox to get results for all their business units under a single Job

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

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

Step 13: 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.

On Listing screen, We can see different options in report section as described below

1 DOCUMENT VIEW- User can view participation of invoices ,there matched,mismatched entries after reco execution in different buckets accordingly.

2 EXECUTE- To execute reco ,user need to use this button present in action section.

3 DELETE- User can use delete button present to clear and delete reco data . Since it is very critical option so, it has OTP based authentication which can only be used by admin.

4 EDIT – User can edit job through edit option

5 VIEW- User can view configured job through view option

Reconciliation 'Bucket/ Tabs and their meaning

While carrying out reconciliation you may find invoices in below buckets namely:

Matched - When your vendor and you, both have entered the invoice and the entries are getting matched between both the documents taking along Supplier GSTIN & Invoice Number as the base fields, in other words, the system will first check for Supplier GSTIN & Invoice Number, if these two are matching, then only system will proceed further to check whether other fields are also matching or not.

Mismatch - When your vendor and you, both have entered the invoice, but there are certain mismatches in the content/ values/ data of the same invoice, then the system will throw those invoices in these buckets. Although, there are sub-buckets as well which a user can view in this Section.

Invoice Number and Date mismatch - If the Invoice Number is the same for Financial Year and date are different for the same Invoice.

Not Present in E-Invoice - As per the naming convention, this bracket contains all those invoices which is present in your purchase register but missing in counter party filed E-Invoice

Accepted Records - We have provided an option to the user where they can accept the records from different buckets for their known match / mismatch bucket, this will help them to reconcile the rest of the data.

DOCUMENT VIEW FEATURES

● User can view and download Sales data , E-Invoice Data from respective buckets present in document view

● There is summary tab provided in each buckets So that user can also view on document view as well

● User can select invoice type from the option provided to view data accordingly

● Option of filters in each columns field provided such as INVOICE NUMBER,SUPPLIER GSTINs

● User can view match status of each invoices in sales and E-Invoice buckets also which makes user easy to go to the respective bucket firmly

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 consolidate report where a user can get Invoice Level Wise (Both E-Invoice and sales) bucket segregation of Invoices. This includes all the invoices user have accepted or have forced Match.