EINVOICE RECONCILIATION EXCELL TOOL

I can suggest a simple reconciliation template to get you started: *

Reconciliation Template:* | *e-Invoice Data* | *Tally Sales Data* | *Reconciliation* | | --- | --- | --- | | 

Invoice Number | Invoice Number | Match (Y/N) | | Date | Date | Match (Y/N) | | Amount | Amount | Difference | | Quantity | Quantity | Difference | You can use VLOOKUP or INDEX-MATCH functions to populate the Tally Sales Data columns and then use IF statements to compare values and highlight discrepancies. 

*Example Formula:* =IF(VLOOKUP(A2, TallySalesData, 

2, FALSE)=B2, "Match", "Difference") *Note:* A2 = e-Invoice Invoice Number, B2 = e-Invoice Amount, TallySalesData = Range for Tally Sales Data 

This template is a basic starting point. You may need to modify it to suit your specific requirements.