In past lecture, I had taught you the manual system of bank reconciliation in Tally.ERP 9. Today, I am teaching automatic bank reconciliation in Tally.ERP 9. Remember it, this facility is not in free educational version of this accounting software.
If you want to use this facility, you need to buy the Tally.ERP 9. After this, you can use this.
1st Step : Download Your Bank Statement in Ms Excel format through Your Net Banking
Just login your net banking and Open the account statement for the period which you want to do auto bank reconciliation.
2nd Step : Import the Bank Statement in Tally.ERP 9
Now, you have to use the import feature of Tally.ERP 9 and import the downloaded bank statement.
3rd Step : Check Amount of Bank Statement not Reflected in Company's books
Just go to Display, then go to ledger accounts, then go to cash and bank account. In the bank account's right side, you will see reconcile. Tally will show the report which transactions is not passed in our books through unreconciled list of entries from the bank statement under the amount not reflected in company books.
Now, your Tally.ERP 9 software will check which bank transactions were passed by your accountant and which transactions were passed by your Bank.In reconciliation report, all the account and amount which is not our books will show. Today is the time of internet and mobile banking. So, there is more fast of payment and trasfer of money from one account to another. Tally will show all these transactions which do not match with your bank statements.
4th Step : Use Auto Reconciliation option
Now, you have to go to each transaction whose amount not reflected in company's books. For example, your bank has automatically charged the bank charges. Just carry your cursor on the required transaction like bank charges. Press Alt+C for create voucher. Your voucher will automatically take the bank charges entry from your imported bank statement. Press accept.
If any transaction which you have done but not bank, you can just go to that transaction and press Alt+R and with this, your record will match with your bank. Next time, you can Alt+C for auto record from bank statement.
This will save your money and time for manual reconciliation of each transaction.
If you want to use this facility, you need to buy the Tally.ERP 9. After this, you can use this.
1st Step : Download Your Bank Statement in Ms Excel format through Your Net Banking
Just login your net banking and Open the account statement for the period which you want to do auto bank reconciliation.
2nd Step : Import the Bank Statement in Tally.ERP 9
Now, you have to use the import feature of Tally.ERP 9 and import the downloaded bank statement.
3rd Step : Check Amount of Bank Statement not Reflected in Company's books
Just go to Display, then go to ledger accounts, then go to cash and bank account. In the bank account's right side, you will see reconcile. Tally will show the report which transactions is not passed in our books through unreconciled list of entries from the bank statement under the amount not reflected in company books.
Now, your Tally.ERP 9 software will check which bank transactions were passed by your accountant and which transactions were passed by your Bank.In reconciliation report, all the account and amount which is not our books will show. Today is the time of internet and mobile banking. So, there is more fast of payment and trasfer of money from one account to another. Tally will show all these transactions which do not match with your bank statements.
4th Step : Use Auto Reconciliation option
Now, you have to go to each transaction whose amount not reflected in company's books. For example, your bank has automatically charged the bank charges. Just carry your cursor on the required transaction like bank charges. Press Alt+C for create voucher. Your voucher will automatically take the bank charges entry from your imported bank statement. Press accept.
If any transaction which you have done but not bank, you can just go to that transaction and press Alt+R and with this, your record will match with your bank. Next time, you can Alt+C for auto record from bank statement.
This will save your money and time for manual reconciliation of each transaction.
Comments