EINVOICE RECONCILIATION EXCELL TOOL

453 views 1 replies
User Avatar

480 Points Joined February 2018
Dear sir,
I require a excell tool to reconcile einvoice and tally sales.
Can you provide me?It will be very very helpfull for me.
0 Reply Share Follow
On 29 October 2024 at 18:01 Report
Replies (1)
User Avatar

Master in Accounts & high court Advocate
9570 Points Joined December 2011

 

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. 

Reply
On 29 October 2024 at 19:10


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading