• Grab your Tally before Price rise

  • Free E class of Tally.erp 9

    Reconcilation in tally

    Today I will explain you the concept the reconciliation. In accounts reconciliation is very important and tally makes it much easier job

    In Accounts reconciliation is done for the following kind of transitions

    1) Bank Reconciliation
    2) Party Statement reconciliation
    3) Tds challans Reconciliation

    In business receipts and payments are done through bank/cheques etc.

    Now whenever a firm issues a cheque it is accounted in the books of account of Issuer Company immediately however the same may not be entered in the books of account of receiver party or the bank itself due to many reasons.

    It results in mismatch of balance between the books of accounts of related parties on a particular date.

    Let’s assume Red & White Bros have issued a cheque of Rs. 50K to its suppliers m/s Anmol brothers as on 30.04.2009.

    M/s Anmol Bros. receives the cheque on date 2.5.2009 and deposit it to their bank account which is credited into their account on 5.5.2009.

    If the Red & Bros. Prepares a trial balance as on 30.4.2008, its bank balance will show a less balance of Rs. 50 k comparing to its actual bank balance while Rs. 50K is still lying in his bank account

    Here it is needed to reconcile the bank statement with the ledger account

    The format of bank reconciliation is as follows:

    1) Balance as per books of account of the company as on date XXXXX
    2) Add : cheques issued however the same is not XXX
    3) cleared by the bank as on date
    4) Less : cheques deposited into the bank which is not cleared as on date XXX

    BALANCE AS PER BANK STATEMENTS XXXXX

    In another meaning, debit the bank accounts for whatever the bank has credited to your account and credit the bank for whatever the bank has debited (charged) to your account

    The same way reconciliation is done for transaction with suppliers and customers and other third parties

    Finally to avoid mistakes in accounts and finance there is a very famous quote in Gujarati Business
    (1) “ Lai ne lakh “ : means first receive the receivables/cheques/cash /materials etc and only after then account it
    (2) “Lakhine Aap” : Means first account a transaction before you hand over the cash/cheque/payment/issue of materials etc.

    These quotes are very important to avoid any mistake in accounts and there is a vision behind the quote.

    Mahendra  (193 Posts)

    Mahendra is founder and CEO of the I Vision Infotech, Authorised Tally Sales and Service Partner and helping Tally users to learn Tally and accounting free through this site


    Related posts:

    1. Axis Bank Cheque Printing in Tally |step by step guide
    2. Opening and Closing Stock in Tally
    3. Branch Accounting in Tally |how to do ?
    4. Tally 9 :How to start writing books of Accounts
    5. Basic Rules of Accounting entries
    6. SBI Cheque Printing in tally.erp 9
    7. How to Print ICICI Bank Cheque in Tally 9 ?

    10 Responses to Reconcilation in tally

    1. Mamatha.hd says:

      Very good and it helped me a lot in my work…

    2. kumar says:

      how to reconcilation in bank a.c for the march the data spliet in another data

      • Mahendra says:

        Dear Kumar,
        To reconcile, go to bank ledger account, Press F7 select the month for which you wanted to reconcile,
        now press F5
        it will ask you to set date of clearance of cheque by the bank. just fill up date as per bank statement and its all done.
        for data splitting, please read my articles on how to data splitting. it is available on the home page of my site

    3. Vishwanath says:

      In tally 9 how we can restrict bank payment upto particular amount?

    4. Renuka says:

      How to reconcile party accounts if the pay in advance and invoice raised at later date?

    5. Harish Sundriyal says:

      if some cheque issued in month of march and these cheques not presented in bank till 31.3.11 and these chs stand in reconciliation of 31.3.11.
      now new books of f/y 2011-12 how reconcile it because books is diffrent.

    6. sandeep says:

      how to mail emil in tally 7.2

    Leave a Reply

    *

    Online Tally Test Check for Schedule of Free online Tally test