TallyPrime Banking

  A blank cheque is one where the payee and amount fields are left empty by the drawer. Recording such cheques is crucial for tracking and ensuring transparency in your accounting records. Issuing cheques for payments or receiving them as part of your transactions, keeping a record of cheques, especially blank cheques, in your accounting system is important. In TallyPrime, recording blank cheque details is straightforward and can be done efficiently.   Fill your cheque book details such as cheque range.    Bank Details Ledger Name: Union Bank Of India Under: Bank Accounts A/c No : 87624245242909 IFSC Code: UBINO765432 Opining Balance: 100000 Dr Note: you can ignore this step if you have already done it. Set/Alter range of Cheque Books   Cheque Book Name: 1st Cheque Book Cheque Book Range: 100901 to 101000 No Of Cheque: 100 Nos     For record blank cheque details in prime so first of all we have to make following changes in payment voucher as shown below.   Alter Payment Voucher Gateway Of Tally >> Alter >> Purchase Type > Payment Allow zero – valued transactions – Yes   Create a Ledger Of Party Gateway Of Tally > Create > Ledger Itech Education Under Sundry Creditor   Select Cheque For Issue Blank Cheque Gateway Of Tally > Banking > Cheque Register Select your Bank Ledger to issue Blank Cheque   Select your Cheque Book for Blank Cheque   Press Spacebar to Select a Cheque then press “ALT + S”   Select Blank Cheque   Pass Purchase Voucher Narayan Pvt Ltd Gateway Of Tally >> Voucher >> Payment   Cheque No And Details   After This You Can See Your Selected Cheque Is Blank Issued   In the Narration field, type “Blank Cheque issued” for clarity. You can include additional details such as the purpose for which the cheque is held, if required. Save the voucher.   This entry creates a record for the blank cheque, which will be useful once the cheque is filled out or deposited. Recording blank cheques in TallyPrime is an important process that ensures transparency and prevents the misuse of cheques in your business operations. TallyPrime makes this task easy by allowing you to create cheque registers, record blank cheques, track them as they are filled out, and reconcile them against bank statements.    

Bank Reconciliation Statement also known as BRS. Bank reconciliation is a process of matching entries (e.g. customer payments, receipt, bank fees etc.) on the company’s tally books with the corresponding data on its bank statements. Using BRS companies can confirm that the company’s records are correct or not. Bank reconciliation is a vital accounting process for businesses of all sizes. It ensures that the company’s financial records match the bank’s records and helps in identifying any discrepancies. Bank reconciliation is crucial for several reasons: Ensures Accuracy: Helps confirm that your cash flow records match with the bank’s statements. Identifies Discrepancies: Highlights any missing transactions or errors in your records or the bank’s. Improves Financial Management: Helps detect fraudulent transactions, incorrect payments, or bank charges that may have been overlooked. Legal Compliance: Ensures that your business maintains transparency and accurate financial reporting. By regularly reconciling your bank accounts, you ensure that your business finances are in check, and you can trust the accuracy of your financial statements.   How to Perform Bank Reconciliation in TallyPrime TallyPrime streamlines the entire reconciliation process, making it easy to reconcile your bank accounts. Follow these simple steps: Set up Bank Accounts in TallyPrime Before you start with reconciliation, ensure that the bank accounts are correctly configured in TallyPrime. Open TallyPrime click on create Under Ledgers, select Create to add a new ledger. Select the Bank Accounts group. Enter the bank account name (e.g., HDFC Bank Current Account). Fill in the bank account details, such as account number, branch name, and IFSC code. Save the ledger. Repeat these steps for all the bank accounts you want to reconcile.   Record Bank Transactions Ensure all bank transactions such as deposits, withdrawals, and payments have been recorded in TallyPrime. This can be done through Vouchers like Payment, Receipt, and Contra.   Record the following transactions in the books of M/s ABC Limited and prepare Bank Reconciliation Statement for the month of January 2020:   Go to the Gateway of Tally and select Vouchers. Choose the appropriate voucher type: Payment Voucher for payments made from the bank. Receipt Voucher for receipts credited to the bank. Contra Voucher for bank transfers between different accounts. Make sure to enter the correct date, amount, and corresponding bank ledger while recording the transactions.   Step 3: Open the Bank Reconciliation Screen Once all the transactions are recorded, it’s time to reconcile the bank account. Go to the Gateway of Tally. Select Banking and then choose Bank Reconciliation. A list of bank accounts will be displayed. Select the bank account you wish to reconcile.   Step 4: Adjust and Resolve Discrepancies In case there are discrepancies between the bank’s records and TallyPrime entries, you’ll need to resolve them. If there are bank charges, interest, or any other fees that have been recorded in the bank statement but not in your Tally account, create a voucher to record them. Similarly, if there are deposits or withdrawals that haven’t been entered in Tally, you need to record them. You can use the F5 (Payment) and F6 (Receipt) buttons to add those missing entries. To review, go to Banking> Statements of Accounts > Bank Reconciliation. This will show you a detailed report of all reconciled and unmatched transactions.   By completing this assignment, you will gain hands-on experience in performing bank reconciliation in TallyPrime, which is a fundamental skill in financial management. You will also understand how to identify and resolve discrepancies between the business’s accounting records and the bank statement.

Recording and maintaining cancelled cheque details in TallyPrime is essential for accurate financial management. Whether cancelling an already issued cheque or maintaining records for voided cheques during issuance, TallyPrime offers a straightforward approach to handle these tasks. In business operations, it’s common to cancel cheques due to errors, void transactions, or other reasons. TallyPrime allows you to record and maintain the details of cancelled cheques effectively. This guide explains two scenarios: Recording a cheque as cancelled after it has been issued. Maintaining the details of a cancelled cheque during issuance.   Maintaining cancelled cheque records in TallyPrime helps you: Track all cheque transactions, including cancellations. Avoid discrepancies during bank reconciliation. Maintain transparency and accuracy in financial records.   Best Practices for Managing Cancelled Cheques Use Clear Narrations: Always mention the reason for cancellation in the narration field. Regularly Update Cheque Register: Ensure all cheque statuses are updated promptly in the cheque register. Avoid Duplicate Cheques: Allocate a new cheque number for reissued payments. Backup Your Data: Regularly back up TallyPrime data to secure your financial records, including cheque details. Click on Banking Click on Cheque Register   Bank Select for Cheque Select Cheque for Select Cheque Number Select Cheque which available Press Spacebar for select a particular cheque and press alt + s now select   Add Reson why cheque cancel   see selected check is cancel   To cancel a cheque in Tally Prime, you can follow these steps: 1. Go to the ‘Payment Voucher’ or ‘Receipt Voucher’ option in the Accounting Voucher menu. 2. Select the voucher in which the cheque was issued. 3. Press the ‘Ctrl + X’ key or click on the ‘Cancel Voucher’ button. 4. Tally Prime will ask for confirmation to cancel the voucher. Press ‘Y’ or click on ‘Yes’ to confirm. 5. Tally Prime will cancel the voucher, and the corresponding cheque will also be cancelled. Note: If the cheque has already been presented to the bank, you cannot cancel it in TallyPrime. In such a case, you should contact your bank and follow their process to cancel the cheque.

   Bank ledgers can be used to record bank deposits, withdrawals, transfers, and other bank transactions. By maintaining a bank ledger, businesses can keep track of their cash flow and reconcile their bank statements. In Tally Prime, a bank ledger is a master record that is used to record all financial transactions related to a particular bank account. Tips for Managing Bank Ledgers Use Accurate Details: Always double-check the bank details to avoid errors in transactions. Bank Reconciliation: Use the bank ledger for reconciling your company’s bank transactions with your bank statement. Multiple Bank Accounts: You can create separate ledgers for each bank account to keep your records organized. Edit Bank Ledger: To make changes later, go to Alter Ledger in the Master menu.   Bank Details Name : IDBC Bank A/c No : 1752021233445 IFS Code : IDBC0000017 Opening Balance : 50,000 Dr IDBC Bank Ledger Creation Opening Balance: ₹5,00000 As on: 1st April 2023   Click on Create from Got Screen. Click on Ledger Enter Ledger Info After entering all the required details, press Enter until you reach the confirmation screen. Select Yes to save the bank ledger. Assignments for Practice: Bank Ledger Creation Assignment 1 Bank Name: HDFC Bank Account Number: 17520212334 IFSC Code: HDFC0000017 Opening Balance: ₹50,000 Dr Assignment 2 Bank Name: AXIS Bank Account Number: 18568212334 IFSC Code: HDFC0000317 Opening Balance: ₹0 Assignment 3 Bank Name: ICICI Bank Account Number: 19875234234 IFSC Code: ICIC0000247 Opening Balance: ₹25,000 Dr Assignment 4 Bank Name: SBI Bank Account Number: 11345987654 IFSC Code: SBIN0004567 Opening Balance: ₹10,000 Dr Assignment 5 Bank Name: Punjab National Bank Account Number: 12345678901 IFSC Code: PUNB0123456 Opening Balance: ₹0 By completing these assignments, students will gain hands-on experience in creating and managing bank ledgers in TallyPrime. Practice regularly to master this essential accounting task!