The whole job in one video: a bank statement in Excel or CSV goes into TallyPrime with the free Synergy Tally Connector extension - from installing it to checking every posted entry in the Post Log. You still choose the ledger for every row; nothing is posted until you confirm. Since the video was made, the extension also reads the PDF statement you download from net banking (beta).
Install from Chrome - freeSee all features
Chapters
- 0:00Intro
- 0:26Install
- 0:43Connect Tally
- 1:08Import the statement
- 1:30Review the rows
- 1:56Choose ledgers
- 2:43Post to Tally
- 3:06Check the Post Log
- 3:23Outro
Transcript
As spoken in the video (Hindi-English).
0:00 · Intro
Bank statement ki entries ek-ek karke Tally mein daalna, mahine ka sabse lamba kaam hai. Aaj dekhenge, yahi kaam Synergy Tally Connector se kuch minute mein kaise hota hai. Yeh video apne CA dost ke saath zaroor share kijiye. Isse unka bahut time bachega. Har step aaram se dikhayenge, aur aakhir mein Tally mein post hote hue bhi dekhenge.
0:26 · Install
Sabse pehle Chrome Web Store kholiye, aur Synergy Tally Connector search kijiye. Yeh extension bilkul free hai. Add to Chrome par click kijiye. Install hote hi app khul jaata hai, aur pehli screen For Review dikhati hai.
0:43 · Connect Tally
Ab TallyPrime kholiye, aur apni company load kijiye. Upar hara pill Tally connected dikhaye, toh link taiyaar hai. Agar not reachable dikhe, toh Tally mein F1, Connectivity mein jaakar port nau hazaar on kijiye. Header mein company aur bank chuniye. Har company aur har bank ki entries alag rehti hain.
1:08 · Import the statement
Ab Import Statement par jaiye. Apna Excel ya CSV bank statement yahan drag and drop kijiye. Upar bank ka logo aur address ho, tab bhi header row khud mil jaati hai. File aayi, bees entries ke saath. Connector pehle hi warning dikhata hai.
1:30 · Review the rows
For Review mein saari bees entries dikh rahi hain. Har row padhi jaati hai, Payment ya Receipt ke saath. Slash dabaiye, aur kisi bhi party ko search kijiye. Jaise, Shree Traders. Amount ki range bhi laga sakte hain. Jaise, tees hazaar se upar. Date, narration ya amount theek karna ho, toh wahin edit kar sakte hain.
1:56 · Choose ledgers
Ab ledger chuniye. Row par click kijiye, aur naam type kijiye. Ledger list seedha aapke Tally se aati hai. Ledger chunte hi row Ready ho jaati hai. Ek hi party ki kayi entries hon, toh ek-ek karke chunne ki zaroorat nahi. Ek click, Apply to all, sab Ready. Neeche selection totals turant dikhte hain. Cash ya bank ledger chunein, toh entry khud Contra ban jaati hai. Isi tarah Salary, Rent aur baaki parties ke ledger chun lijiye. Ledger aap khud chunte hain. Aapke office mein mahine mein kitni bank entries hoti hain, comment mein zaroor likhiye.
2:43 · Post to Tally
Ek click, aur Post to Tally. Post se pehle aap sab dekh lete hain. Kitne Payment, kitne Receipt, aur kul kitna amount, sab ek nazar mein. Sab theek ho, toh Yes, post to Tally. Bees vouchers, seedha TallyPrime mein.
3:06 · Check the Post Log
Post Log mein har entry ka record hai. Har row ke aage OK. Koi entry na jaaye, toh vajah bhi saaf likhi hoti hai. Tally band ho, toh entries queue mein rukti hain, aur Tally khulte hi post ho jaati hain.
3:23 · Outro
Toh bank statement se Tally entry, ab kuch minute ka kaam. Synergy Tally Connector. Free, Chrome Web Store par. Aur yeh video apne CA dost ke saath share karna mat bhooliye.