Online Software Educational Training - IT Tutorials - Online Education Training for Computer Software


Home

TALLY TUTORIAL

Reconciling the Company's Bank Accounts with the Bank Statement is a fundamental and regular task of accounting.

At the end of this unit you will able to reconcile the company's bank accounts with your banker's statement.

Tally Walk-through on reconciling bank accounts

  • Your current account bank has sent you a bank statement for the week ended 7 May 1998 showing the following entries

Bank Statement of J C Computer Supplies - Current Account

Date Particulars Deposits Withdrawals Balance
1-5-98 Balance b/f     35000.00
4-5-98 Cheque 12789 ref Employee Wages   600.00 34400.00
4-5-98 Cheque 12790 ref R N lyer   500.00 33900.00
7-5-98 Balance c/f     33900.00
  • Bring up the monthly summary of Current Account. (Display/Account Books/Bank Books and select the account).
  • Bring your cursor to May and enter.  This brings up the vouchers for the month of May l998.  Since you want to reconcile the statement for the period 1-5-98 to 7­5-98, change display dates to reflect the same period. (Hint - press F2).
  • It is helpful to see the Narration as that contains cheque numbers and other details.  So press Fl2:Configure and activate Show Narration.
  • Since this is a Bank Account, an additional button F5: Reconcile will be visible on the right. Click on F5.
  • The display now becomes an Edit screen in reconciliation mode. The primary components are :
    • A column for the Banker's Date .
    • The Reconciliation at the button of the screen, showing:- Balance as per Company Books amounts not reflected in Bank and Balance as per bank.
  • Enter the bank date for the two payment vouchers for 500.00 and 600.00. Note that you will find the change at the bottom for each and every voucher reconciled. Leave the dates blank for other vouchers by press Enter and accept the screen.
  • The next time you come for reconciliation, you will be presented with only those vouchers, which remain unreconciled. You are taken back to the ledger display of the account.
Previous---- ? Next---- ?