Reconciliation logic

The reconciliation is run to match 2 data sources. One is the e-invoice that is present with ClearTax, other is the SR or the PR data which is present in the customer's ERP. After matching, each invoice is categorised into different buckets based on logics mentioned below-

Category	Logic
Match
Exact	If all the 13 fields match exactly on LHS and RHS
Suggested	- If all the document identifier fields match and one of the amount field does not match - If all the amount fields match but one of the document identifier fields does not match
Low	Threshold of amount mismatch is +1 MYR to -1 MYR
Medium	Threshold of amount mismatch is +5 MYR to -5 MYR
High	Threshold of amount mismatch is +15 MYR to -15 MYR
Mismatch	- If more than one of the document identifier fields does not match - If the document identifier fields match but one or more of the amounts fields mismatch by a difference of more than +- 15 MYR
Missing
Missing in EInv	Present in sales data but not found in EInv data
Missing in Sales	Present in EInv data but not found in sales data