Ad free CAclubindia and daily updates on your mobile. Subscribe Now!

EASYOFFICE

EASYOFFICE

EINVOICE RECONCILIATION EXCELL TOOL

Rajkiran Ghosh (480 Points)

29 October 2024

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.

Reply
Follow
Share

1 Replies

Rama chary Rachakonda (Master in Accounts & Lawyer email ID:ramachary64@gmail.com voice no:9989324294) (4778 Points)
Replied 29 October 2024

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.

Upgrade to CAclubindia Pro. Subscribe Now!

Join CCI Pro

Recent Topics

More recent discussions | Post

Related Threads

Popular Discussion

Start a New Discussion

CCI Pro

Trending Online Classes

GST Live Certification Course (40th Batch)(With Certificate)

Industry Expert

Enroll Now

17 November 2024
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India

Mr.Balamurugan Ranganathan

Enroll Now

08 November 2024
Certification Course on Chat GPT and AI Tools for Professionals

CA Deepak Gupta

Enroll Now

05 November 2024

view all classess

Subscribe to the latest topics :

Search Forum:

Forum Home

Popular Threads

Recent Posts

Unreplied Threads

Settings