Mere pass excel ke 2 sheet hai jisme sundry debtors ke name hai lgvg 20000 party ke aaspass honge aur dono sheet me party name me kuch na kuch spelling mistakes hai. example ke liye
1st sheet me (Jagdamba Falam Traders Pvt. Ltd) hai aur 2nd sheet me (Jagadamba Phalam Traders pvt. Ltd hai)
aise hi 80% party ke case me hai to mjhe ab formulas lgana hai dono ke closing balance check krne ke liye to mai ese ab kaise kru
Menu
Excel sheet for formulas or function
Replies (6)
Quick Summary
Take help from Auditors and pass journal entries for rectification
Just sort the name from alphabet and match
Excel may be corrected . Is it happened in accounting software also ?
#ca rashmi gandhi mam mujhe ye jaana hai ca club of india ke team se ki eska koi other option ni hai jisse work pura simple ho jaye jaise ki formulas work krta hai work ko simple krne me
U can use pivot table help data will be filtered and from there you sum up similar names
Send me i will do it for you, no other option.
Recent Topics :
- GSTR1 amendment Bulk bills
- Capital Gain on Sale of Gold
- GST SALES RETURN MISSING 2025-26 FY
- Enquiry on FAST-DS system generated email
- Capital gain on sale of agriculture land
- Demand from TRACES
- FY 2025-26 ITC CLAIM DUE DATE
- 96084000 and 48202000 HSN code ka Tax Rate kya hai
- Clarifications for intra day transactions
- CA FINAL FR FINANCIAL INSTRUMENTS (Ind AS 109) Dou
Related Topics :
CAclubindia
