Tally PRIME

Bank Accounts in Tally Prime

Posted by Asok K Nadhani on

Bank Account Management with Tally PRIME

Every business organisation keeps at least one bank account for its business transactions. Tally Prime provides certain operation & features specially related to Bank Accounts operations, like Cheque printing, Deposit Slip Printing, Bank Reconciliation etc.

For Banking operations, first set up respective options at Company Bank Ledger Accounts and Party Ledger Accounts to enter relevant details.

Bank Ledger Account set up in Tally PRIME

At the Bank Ledger Creation / Alteration (GoT>Create>Ledger or GoT>Ledger>Ledger) screen (F-1B), click F12:Configure to get Ledger Configuration screen (F-1A)

At Ledger Configuration screen (F-1A), set the following options (F-1A):

  • Bank Ledger Details : At Left part, at Provide Bank Account Details, set Yes.
  • Bank Details : At Right Part, under Bank Details section, at Provide Bank Account Details for Bank Ledgers, set Yes to enable entry of Bank Accounts Details in Bank Ledger Account. Further, you may also set Yes at Set Bank Reconcilation to enable Bank Reconciliation also, else set No.
  • Cheque Details: At Provide Cheque Book and Cheque Printing Details, set Yes to enable Cheque Printing.

F-1A: Bank Ledger Account Configuration

At Bank Ledger Account creation / Alteration screen, set the following options under Bank Configuration section  (F-1B).

F-1B: Bank Ledger Account details for Banking Features

F-1C: Cheque Book details

Party Bank Account set up in Tally PRIME

Debtors & Creditors Ledger Account Creation / Alteration (GoT>Create>Ledger or GoT>Ledger>Ledger) screen (F-2A) have been explained earlier.

F-2A: Party Ledger Account Banking option set up

At the Customer (under Sundry Debtor Group) / Supplier (under Sundry Creditor Group) Ledger Accounts (F-2A), set Yes at the option Provide Bank Details, to enable entry of Bank Account details. At Party Ledger Banking details (F-2B), select the Payment Mode from the list.

F-2B: Party Bank details set up

Banking Details in Voucher entry in Tally PRIME

We have already explained entry of Contra Voucher, Payment Voucher & Receipt Voucher. Here we explain additional details entry in respect Bank ledger transaction in such vouchers.

F-3A: Banking option set up in Voucher entry Configuration

At Voucher entry screen GoT>Vouchers (F-3B), click F12:Configure and set the Bank details option under Bank details section (F-3A).

F-3B: Voucher entry for Bank transaction

F-3C: Bank details in Voucher

At Voucher entry, after entry of Amount for Bank Ledger (F-3B), enter the Cheque details at Bank Allocation screen (F-3C)

Banking Menu in Tally PRIME

After Banking Option set up in Bank Ledgers (F-1A to F-1C) and Party Ledgers (F-2A / F-2B), to access Banking related task, select GoT>Banking (F-4A) / Go To > Banking Utilities (F-4B).

F-4A: Banking Menu from GoT

F-4B: Banking Utiliies from Go To list

Cheque Printing in Tally PRIME

Select GoT>Banking> Cheque Printing (F-4A) / GoT>Banking Utilities> Cheque Printing (F-4B).  Select the Bank, Click F2, enter Period. At Cheque Printing screen(F-5B), click F12:Configure to get Cheque Printing Configuration (F-5A) and set the Cheque  Printing Configuration (F-5A) oprions.

F-5A: Cheque Printing Configuration

F-5B: Cheque Printing Report.

 The list of Cheques issued as per Voucher Entry would appear. Select the Cheque record and enter the Cheque details.

GoT>Banking> Cheque Printing (F-4A) / GoT>Banking Utilities> Cheque Printing (F-4B)

Cheque Details Entry in Voucher in Tally PRIME

During Voucher entry, the Cheque Details (cheque Number etc) are entered as explained. If Cheque details not entered during Voucher entry, the Cheuqe Numbers may be entered later on (before or after Cheque Printing).

At Cheque Printing (GoT>Banking> Cheque Printing) Report (F-5B), select the voucher from the list, select Cheque Book from the list and enter the Cheque Number (F-6A).

F-6A: Cheue details entry in Voucher

Cheque  & Payment Advice Printing in Tally PRIME

Sometimes, you need to send Cheque / Payment advice (called covering letter) giving the details of cheque and deliver / handover the Cheque with Covering Letter. The Payment advice may be printed alongwith cheque printing, in the same step, or advice may be printed through separate step.

Now a days, mostly payments are made through electric transfer. In such case, though no cheque is printed, the Payment advice should be printed and send to Payee to inform about the details of payments made.

F-7A: Payment Voucher / Payment Advice Printing

F-7B: Cheque Printing

  • : After Cheque Details entry in a voucher (F-6A), Click P:Print to Configure / Preview / Print the Voucher (F-7A), as explained in Reports Printing.
  • : After Voucher Printing, at Payment Voucher printing (F-7A), click C:Configure and set Yes at Print Payment Advice, and then Click P: Print (F-7A) to print the Payment Advice (F-9A)

F-8A: Cheque in Print

F-9A: Payment Advice in Print

Deposit Slip Printing in Tally PRIME

Normally, the Deposit slip is entered manually in the Bank’s own form of Deposit Slip Form, at the time of Cash / Cheque Deposit into Bank. Before printing Deposit slip from Tally, consult with the Bank, whether they would Accept Deposit Slip in other forms (other than Bank’s own Deposit Slip form).

To print Deposit Slip from Tally itself in Tally’s own deposit slip Form, during Voucher Entry / Alteration of Cash Deposit Voucher entry (normally Contra Voucher), enter the Cash Denominations, for receipt of instruments (normally Receipt Vouchers), enter the details of instruments (e.g Cheques etc), as explained in Voucher Entry

F-11A: Cash Deposit Slip Entry

During Voucher Printing, set the options for Cash Deposit Slip Printing Deposit Slip

F-10A: Deposit Slip Printing

At Banking menu, select Deposit Slip and then select the Bank for which you like to print the deposit slip to get Deposit Slip screen. Click Ctrl+P to get Deposit Slip Printing screen.

Cash Deposit Slip List

Cash Deposit Slip Printing

For Cash Deposit slip Printing, select the respective Voucher. Click P:Print button to get Cash Deposit slip printing options. At  Cash Deposit Printing screen.

Cash Deposit Slip Printing Configuration

Cash Deposit Slip Printing

Cash Deposit Slip in Print

At Deposit Slip screen, on selection of Bank, Cheque Deposit List for the selected period appears.

Cheque Deposit Slip List

Cheque Deposit Slip Printing

At  Cheque Deposit Printing screen, Type Yes at Print Cheuqe Deposit Slip. Type Yes at print Customer’s copy to print Banker’s Copy and Customer’s Copy (with proper labels in each for identification) in one page.

Cheque Deposit Slip in Print

Bank Reconciliation in Tally PRIME

Bank Reconciliation is the process of matching the entries between Bank Book & Pass Book) with Bank Pass Book) and tracing the unmatched entries in either of the books (Bank Book or the Pass Book), It is essential to ensure correctness of Bank Accounts.

Select GoT>Banking > Bank Reconciliation and select a Bank Account from the list to get Bank Reconciliation screen.

At Bank Reconcilitaion screen, click F12:Configure to get Bank Reconciltaion Configurtaion screen to set the options.

Bank Reconciliation Configuration

Pass Book Date Entry : Enter the Bank Pass Book Date of the matched Vouchers at bank date column in Bank Reconcilation Statement and print the Bank Reconcilation Showing unmatched Vouchers, to tally the Bank passbook balance with Bank Book Balance. Bank Reconciliation Opening entries  : To start Bank Reconciliation from a date having unreconciled entries, click H: Opening BRS button to get the Opening BRS screen, and enter the details of such opening unreconciled entries.

Banking – Key Points

Audio