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.
Last updated