दोस्तों मैंने आप लोगों के लिए एक बहुत ही बेहतरीन एमएस एक्सेस में यूटिलिटी तैयार की है जिसकी मदद से आप कुछ ही सेकंड में अपना बैंक स्टेटमेंट अपनी टैली में पूरा की पूरा लेजर्स के नाम के साथ साथ ला सकते हैं| दोस्तों यह यूटिलिटी आपकी घंटों की मेहनत को बचा सकती है|
टेली भी यह फैसिलिटी प्रोवाइड करती है जिसे हम ऑटो बैंक रिकॉन्सिलिएशन कहते हैं लेकिन उसके अंदर लेजर के नाम नहीं आते हैं , हमें खुद से ledgers के नाम डालने पड़ते हैंl
लेकिन दोस्तों इस यूटिलिटी के माध्यम से आप एंट्री के अन्दर automatic lasers ke naam Dal Payenge.
अधिक जानकारी के लिए नीचे दिए गए वीडियो पर क्लिक कर लीजिए
Question:- is bank statement must be download from site in csv format. Can i download in excel format?
Answer:- if your bank provide facility to download excel statement then it will better so now you no need to convert csv to excel. It means if you download statement in excel format your 1 step reduce to utilize this utility.
Question:- how can i maintain same format of bank statement if my bank not pnb unlike your video?
Answer:- you can maintain columns exactly I shown in the video. If you unable do that share with me your sample bank statement I will create video for your bank statement or may create another utility as per your needs.
Error solution
Question:- if asking for f10 parameter value? What is this..is it error?
Answer:- after creating xls format statement...make sure that a1 cell of excel statement must have anything value. A1 cell not to be empty. If empty write anything in cell a1 and save your statement. Then try this utility. Enjoy...
Question:- error:Unrecognized database format?
Answer:- use office 2013 to run this utility
Very Nice & Helpful Utility. Thank
ReplyDeleteutility downlaod ka link to nahi hai. aise hi logo ko murkh banate ho kya
ReplyDeleteBhai sahab dhyan se dekhiye link diya hai download now link diya hai sabse last me
DeleteAapko iss bhasha ka use nhi karna chaiye, He is helping and providing many useful TDL and other files without any charges, You should respest him, and must say sorry
Deletekaise kaise log hain is dharati me
ReplyDeleteAnkhe khol kar dekhiye download now likha hua hai article k bilkul last me
DeleteSir ms access file not open its show the massage "unrecognized data base format"
ReplyDeletemail me your file
DeleteSir ms access file not open its show the massage "unrecognized data base format"
ReplyDeletemail me your file
DeleteKindly Use Microsoft Access 2010 or More
DeleteKindly provide your contact no
ReplyDeletepls mail.excel
ReplyDeleteSir yah msg aa raha he Uneconized database format/bankquickentries-v2-2.accdb
ReplyDeleteSir ms access file not open its show the massage "unrecognized data base format"
ReplyDeleteSir, please let me know the meaning of this error ::::
ReplyDeleteunrecognized database format 'C:\User\admin\Downloadas\Bankquickentries-v2\bankquickentries-v2.accob'.
LINE :240: NO ENTRY IN VOUCHER ERROR COMING SIR
ReplyDeletesirji, only first 2 entries (payment) are imported, 3rd entry (receipt) is not imported .
ReplyDeletefollowing error message aa raha hai- can't Import!Check Tally.imp for details
in Tally file, i got following message -
Importing Data from 'E:\BankEntry.XML' on 21-May-2020 at 17:49:03
Importing Data to company: 'A2Z Enterprise'
ERROR: Voucher: ID:, Voucher Type: Payment, Source Voucher Number: TRANSFER FROM 3199415044304, Voucher Number: 49, Date: 7-Jan-2020
No Entries in Voucher!
Import Summary
Created : 2
Altered : 0
Deleted : 0
Combined: 0
Ignored : 0
Errors : 1
----------------------------------------------
bank statement me, A1 cell me ABC type kiya hua hai and pura coloumn A blank hai.
B column DATE - C BLANK - D CHEQ NO - E BLANK - F DEBIT AMOUNT - G BLANK - H CREDIT -I BALANCE - J NARRATION.
NO PENDING ENTRY IN SUSPENSE - ALL ARE AVAILABLE IN NON SUSPENSE ENTRIES.
KINDLY DO THE NEEDFULL.
THANKING YOU FOR HELPING HAND.
IMPORT BENIFICIARY BANK DETAILS' LABEL:0070: NO OPEN FILE IN CURRENT CONTEXT!'
ReplyDelete
ReplyDeleteImporting Data from 'F:\OFFEICE FILES\bank statements\bankquickentries - v2-3\BankEntry.XML' on 3-Jul-2020 at 11:11:46
Importing Data to company: 'Sai Charith Agencies - 2019-20'
ERROR: Voucher: ID:, Voucher Type: Payment, Source Voucher Number: , Voucher Number: 9, Date: 9-Apr-2019
No Entries in Voucher!
Import Summary
Created : 3
Altered : 0
Deleted : 0
Combined: 0
Ignored : 0
Errors : 1
----------------------------------------------
ERROR:
ReplyDeleteVoucher Type: Payment, Source Voucher Number: , Voucher Number: 1, Date: 11-Jun-2020
No Entries in Voucher!
Sir plz ek esa utility bnaiyye jo MS office 2007 se easly access ho pae Q ki jyadatr log fast work ke liye ise use karte hai or dusri baat ek specific excel format ke sath bnaiyye Q ki sabhi banks k statements alg alg design k hote h. plz rply and also contact me on pandeyanand090@gmail.com ...u are genius.
ReplyDeletesir ji,
ReplyDeletenaya file upload kar dijiye
Very nice tdls provide us
ReplyDeletesir ye file serial no. mangraha he
ReplyDeleteSir I have 2 bank accounts kotak mahindra bank and idbi bank respectively.
ReplyDeletethe format after downloading the statement is different from yours shown in the video,
what can i do for bank entries, Please help me with the Solution.
Attachment for the reference sending on your mail id
I cant able to download the file
ReplyDeleteLINE 24 NO ENTRIES IN VOUCHER. ALL ENTRIES ARE THERE IN ALL LINES. KINDLY SOVE
ReplyDeleteWHILE UPLOADING XML IN TO TALLY, TALLY IS SHOWING AT LINE NO.24 NO ENTRIES . BUT I HAVE VERIFIED, ALL THE ROWS ARE WITH ENTRIES. PL SOLVE
ReplyDeleteAwesome thing made by you... Just loved it. Kindly update for june.
ReplyDeleteDear Sir,
ReplyDeleteplz update bankquick utility my license has been expired.
Dear Sir,
ReplyDeleteI want to Buy This Bank quick Utility but i want it in my own bank format,
this utility doesn't work after using any junk cleaner in win7 10 after dowload again from your website it doesn't work
Hope you Understand me Better Plz Fix This issue i'm waiting for your Kind Reply....
Thanks for good information.
ReplyDeleteAlso you can Auto import Bank Statements Entries in Tally with cheque data by SMAART Excel Utility.
Try - https://www.xltally.in | https://www.nikash.in
The utility has one problem while making contra entries, it shows entries in non suspense entries but when xml file is run into tally the contra entries all goes missing in bank ledger. pls help to resolve the issue.
ReplyDelete