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)
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 Topic
- GST on Post-OC Installments – Payment Milest
- Sec-54F exemption and Carry forward losses
- FEMA treatment — USD gift from LRS-funded fo
- RSU and Schedule FA related
- ELIGIBILITY FOR COMPOSITION SCHEME
- Doubt regarding the purpose of Section 52(3) of Co
- 112 A Filling
- Long Term Capital Loss in ITR2
- LOAN INTEREST BENEFIT ON NEW TAX REGIME
- Retirement funds under new tax regime
Related Topics
CAclubindia
