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 Threads
- TDS demand payment notice
- Invoice NOT in 2B but showing in 2A, and supplier
- Is ITC available on VRF AC
- Capital gains on sale of furnished flat
- Heard & Seen Around – Your Daily Economi
- Gst interest and penalty doubts regarding missing
- Import of goods IMS telated
- ITR 6 submitting Problem
- Partnership Firm Closure Process
- Why the Costing Department Is Important ?
Related Threads
CAclubindia
