Monday 6 July 2020

All bank entries import into tally - Download Now

दोस्तों मैंने आप लोगों के लिए एक बहुत ही बेहतरीन एमएस एक्सेस में यूटिलिटी तैयार की है जिसकी मदद से आप कुछ ही सेकंड में अपना बैंक स्टेटमेंट अपनी टैली में पूरा की पूरा  लेजर्स के नाम के साथ साथ ला सकते हैं| दोस्तों यह यूटिलिटी आपकी घंटों की मेहनत को बचा सकती है|


टेली भी यह फैसिलिटी प्रोवाइड करती है जिसे हम ऑटो बैंक रिकॉन्सिलिएशन कहते हैं लेकिन उसके अंदर लेजर के नाम नहीं आते हैं ,  हमें खुद से 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

Download Now

34 comments:

  1. Very Nice & Helpful Utility. Thank

    ReplyDelete
  2. utility downlaod ka link to nahi hai. aise hi logo ko murkh banate ho kya

    ReplyDelete
    Replies
    1. Bhai sahab dhyan se dekhiye link diya hai download now link diya hai sabse last me

      Delete
    2. Aapko 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

      Delete
  3. kaise kaise log hain is dharati me

    ReplyDelete
    Replies
    1. Ankhe khol kar dekhiye download now likha hua hai article k bilkul last me

      Delete
  4. Sir ms access file not open its show the massage "unrecognized data base format"

    ReplyDelete
  5. Sir ms access file not open its show the massage "unrecognized data base format"

    ReplyDelete
  6. Kindly provide your contact no

    ReplyDelete
  7. Sir yah msg aa raha he Uneconized database format/bankquickentries-v2-2.accdb

    ReplyDelete
  8. Sir ms access file not open its show the massage "unrecognized data base format"

    ReplyDelete
  9. Sir, please let me know the meaning of this error ::::
    unrecognized database format 'C:\User\admin\Downloadas\Bankquickentries-v2\bankquickentries-v2.accob'.

    ReplyDelete
  10. LINE :240: NO ENTRY IN VOUCHER ERROR COMING SIR

    ReplyDelete
  11. sirji, only first 2 entries (payment) are imported, 3rd entry (receipt) is not imported .
    following 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.

    ReplyDelete
  12. IMPORT BENIFICIARY BANK DETAILS' LABEL:0070: NO OPEN FILE IN CURRENT CONTEXT!'

    ReplyDelete


  13. Importing 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
    ----------------------------------------------

    ReplyDelete
  14. ERROR:
    Voucher Type: Payment, Source Voucher Number: , Voucher Number: 1, Date: 11-Jun-2020
    No Entries in Voucher!

    ReplyDelete
  15. 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.

    ReplyDelete
  16. sir ji,
    naya file upload kar dijiye

    ReplyDelete
  17. sir ye file serial no. mangraha he

    ReplyDelete
  18. Sir I have 2 bank accounts kotak mahindra bank and idbi bank respectively.
    the 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

    ReplyDelete
  19. I cant able to download the file

    ReplyDelete
  20. LINE 24 NO ENTRIES IN VOUCHER. ALL ENTRIES ARE THERE IN ALL LINES. KINDLY SOVE

    ReplyDelete
  21. WHILE 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

    ReplyDelete
  22. Awesome thing made by you... Just loved it. Kindly update for june.

    ReplyDelete
  23. Dear Sir,
    plz update bankquick utility my license has been expired.

    ReplyDelete
  24. Dear Sir,
    I 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....

    ReplyDelete
  25. Thanks for good information.
    Also 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

    ReplyDelete
  26. 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