Tuesday, 28 April 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. 

Download Now

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

16 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
  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