GSTIN Level List of invoices present in one financial year which belong to previous financial year as per invoice date

This report provides a list of all such invoices where FY (as per invoice date) is different from the FY in which it is uploaded (as per filing period) by Supplier or Purchaser or by both. Column name “Document Financial Year” represents the Financial Year as per invoice date whereas as Column name “Filing Period Financial Year” represents the Financial Year as per the month in which the invoice has been uploaded either by supplier or purchaser or both. Column 2A/2P will provide the detail as to this invoice is present in 2P (Purchaser uploaded data) or 2A (Supplier uploaded data).

Below three types of scenarios are getting covered over here:

• Purchaser booked invoice belonging to current financial year based on invoice date in the current financial year, however, the same invoice booked by the supplier in the next financial year.

e.g. Invoice No.123 dated 30/03/2018 belongs to the Current Financial year 2017-18. Invoice is coming in 2P (purchaser uploaded) in month March 2018 (i.e. Financial Year as per filing period is 2017-2018), however this same invoice is coming in 2A (supplier uploaded) in May 2018 (i.e. Financial Year as per filing period is 2018-2019)

In the above case, the invoices will be from 2A and categorized in Supplier Only Category in Filing Period Financial Year 2018-19. Along with this if this invoice is present in 2P in Purchaser Only category in the Filing Period Financial year 2017-18 then that invoice will also be added in a separate row. So that when we filter by counterparty GSTIN and invoice no., we get a row-wise comparison of 2A and 2P.

• Supplier booked invoice belonging to current financial year based on invoice date in the current financial year, however, the same invoice booked by the purchaser in next financial year

e.g. Invoice No.123 dated 30/03/2018 belongs to the Current Financial year 2017-18. Invoice is coming in 2A (supplier uploaded) in March 2018 (i.e. Financial Year as per filing period is 2017-2018) however this same invoice is coming in 2P (purchaser uploaded) in May 2018 (i.e. Financial Year as per filing period is 2018-2019)

In the above case, the invoices will be from 2P and categorized in Purchaser Only Category in Filing Period Financial Year 2018-19. Along with this if this invoice is present in 2A in Supplier Only category in the Filing Period Financial year 2017-18 then that invoice will also be added in a separate row. So that when we filter by counterparty GSTIN and invoice no., we get a row-wise comparison of 2A and 2P.

• Both Purchaser, as well as Supplier, have booked invoice belonging to current financial year based on invoice date in the next financial year.

e.g. Invoice No. 127 dated 30/03/2018 belongs to the Current Financial year 2017-18. Invoice is coming in 2A (supplier uploaded) as well as in 2P (purchaser uploaded) in month May2018 (i.e. Financial Year as per filing period is 2018-2019).

In the above case, the invoices will be from both 2A & 2P and categorized in Matched, Value Mismatch and Invoice Mismatch Categories.

Sapphire_new reco_GSTIN level report 2

How to get this report in IRIS Sapphire

Sapphire_New reco_GSTIN level report 2

The process is same as a previously explained report, just additionally select over the financial year and click on Generate.


*Note - Here as of now, you can see only one period under financial year drop-down i.e. 2018-2019 because this report will provide you the invoices which belong to previous financial year.