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
6 Replies
Eswar Reddy S
(CFO- at NHTF)
(58275 Points)
Replied 08 May 2022
Take help from Auditors and pass journal entries for rectification
CA Rashmi Gandhi
(Chartered Accountant)
(86323 Points)
Replied 09 May 2022
Just sort the name from alphabet and match
Eswar Reddy S
(CFO- at NHTF)
(58275 Points)
Replied 09 May 2022
Excel may be corrected . Is it happened in accounting software also ?
Ankit Singh Tomer
(23 Points)
Replied 10 May 2022
#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
Ruchika Saluja
(2 Points)
Replied 11 May 2022
U can use pivot table help data will be filtered and from there you sum up similar names
CA Rashmi Gandhi
(Chartered Accountant)
(86323 Points)
Replied 11 May 2022
Send me i will do it for you, no other option.
Recent Topics
- Doubt in ITR Filing
- DRC 03 for delayed RCM Payment
- Declaration about Legal Metrology Act
- Intermediary services under GST - SGST CGST IGST
- CSR thru implementing agency
- ETax payment of Revised return
- US based NRI Taxation on endowment plan taken in I
- Is it necessary to fill HSN code in GSTR 1, is the
- Pf advance withdrawal limit
- AOC4 & CFS,STANDALONE
Related Threads
Trending Online Classes
-
6 days Certification Course on GST Practical Return Filing Process
CA Pratibha Goyal16 December 2024
CAclubindia
