Ankit IT Solutions – Training Institute

Welcome To Ankit IT Solutions!

TallyPrime Course

Bank Reconciliation in TallyPrime

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.

Bank Reconciliation in TallyPrime Read More »

Banking Transaction Assignment

This assignment focuses on understanding and practicing the Contra Voucher Entry in TallyPrime. Contra vouchers are used when there is a transfer of cash or bank funds between two accounts. For instance, when cash is deposited into the bank or withdrawn from the bank to cash. Assignment No 1  Bank Details Name : HDFC Bank A/c No : 17520212334 IFS Code : HDFC0000017 Opening Balance : 50,000 Dr Cheque Book with 100 Cheque leaves and the starting number is “009601”   Banking Transactions Record following banking transactions in New Company 1. A cheque amounting to Rs. 20,000 was printed and paid to the supplier Anu Traders via Cheque 2. Received cash from the customer Music Shop Rs. 3,500 and the same deposited into the bank 3.Purchased a printer for office use for Rs. 15,000 from Metro Shoppe and cheque paid against the purchases; 4. Withdrawn Cash from bank Rs.2,000 for the petty expenses 5. Rent paid for the Office by cheque Rs. 5,000; 6. Cheque Received for Rs. 20,000 from Music Shop 7. Cheque received from customer Savita Traders Rs. 10,000 8. Cheque issued to Magnum Honda as blank cheques from 5th of every month for 12 months. Assignment   Bank Details Name : HDFC Bank A/c No : 17520212334 IFS Code : HDFC0000017 Opening Balance : 50,000 Dr Cheque Book with 100 Cheque leaves and the starting number is “009601”   Banking Transactions Record following banking transactions in New Company 1. A cheque amounting to Rs. 20,000 was printed and paid to the supplier Anu Traders via Cheque 2. Received cash from the customer Music Shop Rs. 3,500 and the same deposited into the bank 3.Purchased a printer for office use for Rs. 15,000 from Metro Shoppe and cheque paid against the purchases; 4. Withdrawn Cash from bank Rs.2,000 for the petty expenses 5. Rent paid for the Office by cheque Rs. 5,000; 6. Cheque Received for Rs. 20,000 from Music Shop 7. Cheque received from customer Savita Traders Rs. 10,000 8. Cheque issued to Magnum Honda as blank cheques from 5th of every month for 12 months.   Assignment 1: Record a Cash Deposit into Bank Account Scenario: You have ₹50,000 in cash, and you deposit ₹30,000 into your bank account. Use the Contra Voucher to record this transaction. Steps: Open TallyPrime. Create the necessary ledgers: Cash Account (under Cash in Hand) Bank Account (under Bank Accounts) Record the Contra Voucher for the cash deposit. Submit a screenshot of your entry. Assignment 2: Record a Bank Withdrawal for Cash Scenario: You withdraw ₹10,000 from your bank account and take it as cash. Use the Contra Voucher to record this transaction. Steps: Open TallyPrime. Create the necessary ledgers: Cash Account (under Cash in Hand) Bank Account (under Bank Accounts) Record the Contra Voucher for the bank withdrawal. Submit a screenshot of your entry. Assignment 3: Transfer from One Bank Account to Another Scenario: You transfer ₹25,000 from one bank account to another within the same company. Use the Contra Voucher to record this transaction. Steps: Open TallyPrime. Create the necessary ledgers: Bank Account 1 (under Bank Accounts) Bank Account 2 (under Bank Accounts) Record the Contra Voucher for the bank-to-bank transfer. Submit a screenshot of your entry. Assignment 4: Cash Transfer from Cash Account to Petty Cash Scenario: You transfer ₹2,000 from the main cash account to the petty cash account for office expenses. Record the transfer using the Contra Voucher. Steps: Open TallyPrime. Create the necessary ledgers: Cash Account (under Cash in Hand) Petty Cash Account (under Cash in Hand) Record the Contra Voucher for the transfer. Submit a screenshot of your entry. Assignment 5: Record Cash Received from Bank for Business Transactions Scenario: You receive ₹15,000 from the bank for a business sale. You deposit this cash directly into your company’s bank account. Use the Contra Voucher to record the deposit. Steps: Open TallyPrime. Create the necessary ledgers: Cash Account (under Cash in Hand) Bank Account (under Bank Accounts) Record the Contra Voucher for the cash received from the bank. Submit a screenshot of your entry. Assignment 6: Bank Transfer for Payment to Supplier Scenario: You pay ₹40,000 to a supplier using a bank transfer. Use the Contra Voucher to record the payment. Steps: Open TallyPrime. Create the necessary ledgers: Supplier Account (under Sundry Creditors) Bank Account (under Bank Accounts) Record the Contra Voucher for the payment to the supplier. Submit a screenshot of your entry. Assignment 7: Cash Payment to Vendor Scenario: You make a cash payment of ₹5,000 to a vendor for materials purchased. Use the Contra Voucher to record the transaction. Steps: Open TallyPrime. Create the necessary ledgers: Vendor Account (under Sundry Creditors) Cash Account (under Cash in Hand) Record the Contra Voucher for the payment to the vendor. Submit a screenshot of your entry. Assignment 8: Cash Deposit in Bank after Sale Scenario: You deposit ₹12,000 received from a sale into your bank account. Use the Contra Voucher to record the deposit. Steps: Open TallyPrime. Create the necessary ledgers: Sales Account (under Sales) Bank Account (under Bank Accounts) Cash Account (under Cash in Hand) Record the Contra Voucher for the cash deposit in the bank. Submit a screenshot of your entry. Assignment 9: Transfer of Funds for Loan Repayment Scenario: You pay ₹30,000 from your bank account towards a loan repayment. Use the Contra Voucher to record the repayment. Steps: Open TallyPrime. Create the necessary ledgers: Loan Account (under Liabilities) Bank Account (under Bank Accounts) Record the Contra Voucher for the loan repayment. Submit a screenshot of your entry. Assignment 10: Record a Cash Withdrawal for Business Expense Scenario: You withdraw ₹8,000 from your bank account for office-related expenses in cash. Use the Contra Voucher to record the withdrawal. Steps: Open TallyPrime. Create the necessary ledgers: Business Expenses Account (under Indirect Expenses) Cash Account (under Cash in Hand) Bank Account (under Bank Accounts) Record the Contra Voucher for the cash withdrawal for business expenses. Submit a screenshot of your entry.

Banking Transaction Assignment Read More »

Record Cancelled Cheque Details in TallyPrime: Step-by-Step Guide

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.

Record Cancelled Cheque Details in TallyPrime: Step-by-Step Guide Read More »

Cheque Printing in TallyPrime: Step-by-Step Guide

Printing cheques directly from TallyPrime can save a lot of manual effort and reduce the risk of errors in writing cheque details. Whether you are issuing payments to suppliers, employees, or other parties, TallyPrime’s cheque printing feature makes the process quick, accurate, and professional. Happy accounting with TallyPrime! Create Ledger Click on Vouchers   Payment Voucher Made   Cheque References Preview   Cheque Issued Payment Pass Another Entries like this…. 1. Paid 15000 to Rahul Narayana Pvt Ltd by Cheque No 150201 2. Paid Salary to Sangam Ompuri by Cheque No 150202 3. Paid 5000 Advertisement Fee to Suresh Banshal by Cheque No 150203 4. Paid 5600 Light Bill by Cheque No 150205 5. Paid 7500 to Transport Charge by Cheque No 150206    

Cheque Printing in TallyPrime: Step-by-Step Guide Read More »

How to Create a Bank Ledger in TallyPrime: Step-by-Step Guide

   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!  

How to Create a Bank Ledger in TallyPrime: Step-by-Step Guide Read More »

Credit Note Voucher in TallyPrime – Sales Cycle / Proccess

A Credit Note Voucher is used to record transactions where a business gives credit to a customer, which helps record returns or adjustments when goods are returned by customers, discounts are given, or any other credit adjustment is required. In TallyPrime, Credit Notes help record sales returns or adjustments in receivables from customers. Credit note document is prepared by the supplier on receiving the goods return By the customers/debtors. It directly has a negative effect on the sellers accounting balance. The credit note informs clients about the credit provided in their account.   🧾 Common Situations for Issuing a Credit Note: Scenario Example Sales return Customer returns damaged goods worth ₹10,000 Overbilling Customer was billed ₹12,000 instead of ₹10,000 Post-sale discount ₹500 discount issued for bulk purchase   How to record Credit Note in TallyPrime Step 1 Click on vouchers   Step 2 Click on Other vouchers   Step 3 Click on Credit Note (ALT + F6) If this voucher not showing in Tally Prime then you can press on show Inactive   Enter the following details: Party’s Name: Select the customer or party to whom the credit applies. Items or Ledger: Add the returned items or ledger for which the credit is being issued. Amount: Enter the total credit amount. Narration: Add a note explaining the reason for the credit.   1.  Following item retuned to Ghansyam IT Hub   2.  Following item retuned to Dubay Mobile Marketing   3. Following item retuned to Adarsh A to Z Mobile Hub   Example of a Credit Note Voucher Scenario: Your business, ABC Traders, sold 10 items to a customer, but 2 items worth ₹500 each were returned due to damage. Here’s how you can record this: Open Credit Note Voucher. Select the customer’s account (e.g., Customer A). Under Items, add the product being returned. Enter the quantity (2) and the value (₹500 each). The total credit amount will automatically calculate as ₹1,000. In the Narration, write: “Goods returned due to damage (Invoice #456).” Save the entry. Now the customer’s account is credited with ₹1,000, and your records are updated.   🧾 Credit Note vs Debit Note Basis Credit Note Debit Note Issued By Seller Buyer Used For Sales return or price reduction Purchase return or price reduction Account Affected Customer account is credited Supplier account is debited 🧾 Example Entries for Credit Notes 1. Sales Return with GST Dr. Sales Return A/c ₹10,000 Dr. CGST Output A/c ₹900 Dr. SGST Output A/c ₹900 Cr. Customer A/c ₹11,800 Narration: Being return of goods by customer with GST adjustment. 2. Overcharged Invoice Adjustment Dr. Sales A/c ₹1,695 Dr. CGST Output A/c ₹152.50 Dr. SGST Output A/c ₹152.50 Cr. Customer A/c ₹2,000 Narration: Being credit note issued for overcharged invoice #202.

Credit Note Voucher in TallyPrime – Sales Cycle / Proccess Read More »

Receipt Voucher in TallyPrime – Purchase Cycle / Proccess

A Receipt Voucher in TallyPrime is used when you receive money from customers, banks, or any other source. It helps record cash, cheque, or online transactions accurately. Receipts are an official record that represents proof of a financial transaction or purchase. Receipts are also important for tax purposes as proof of certain expenses. TallyPrime is a powerful accounting software used by businesses to manage their financial records. One of its key features is the Receipt Voucher, which is used to record all money received by a business. In this blog, we will understand what a Receipt Voucher is, how to create one, and practice with simple examples and assignments. For example, if a customer pays you for goods purchased, you use a Receipt Voucher to record this payment.   Click on Vouchers   Select Receipt Voucher by Preesing F6 or Click from Side Bar   Select Party Name   Enter amount what received   Method of Adjustments agst Ref select pending bills   accept it after filing information   select where money received like cash, bank   Other details related to transaction   Receipt voucher now accept   now see reports – click on balance sheet Balance Sheet Report   Bank Accounts   Select Your bank   Select Month and date   See All Bank Transaction from 1st apr to 30 apr –   Balance Sheet          

Receipt Voucher in TallyPrime – Purchase Cycle / Proccess Read More »

Sales Voucher in Tally – Sales Cycle / Proccess

A Sales Voucher is a document used to record sales transactions in TallyPrime. It helps in keeping track of revenue, updating inventory, and ensuring accurate financial records. A sales voucher is a form of a receipt or documentation commonly given to a buyer of supplies or goods. Sales Voucher in Tally​​ It is one of the most widely used accounting vouchers in tally. When a company sells goods / Services on credit or cash, Sales voucher is used to record all the Sales transactions of the company. It is a type of accounting voucher in Tally, you can record all transactions related to sales in This Voucher. TallyPrime is one of the most popular accounting software, making it easy to manage financial transactions. One of its key features is the Sales Voucher, which is used to record all sales transactions. In this article, we will explain what a sales voucher is and provide a simple, step-by-step guide on how to create it in TallyPrime. For example, when you sell products or services to a customer, you record the details in a sales voucher, which updates your accounts and inventory automatically. Benefits of Using Sales Vouchers in TallyPrime Accurate Records: Maintain precise records of all sales transactions. Inventory Updates: Automatically update stock levels after every sale. Tax Compliance: Ensure proper calculation and recording of taxes like GST. Time-Saving: Streamline the sales process by automating calculations and updates. Click on Vouchers   Select Sales Voucher by Pressing F8 or Select from Sidebar   Delivery note note Delivery Note Details Party Details Ledger Now sales voucher make   See Balance Sheet   Current Assets   Sundry Debtors   Party Name Bill Checking Date / Months   Report   How to Check Sales Bills Pending Click on Display More Reports Click On Statement of Inventory Sales Bills Pending Report Reports – No Pending Bills How to Check Sales Order Outstandings Reports – Click on Sales Order Outstandings Reports Click on All Orders Reports of Sales Order Outstandings Reports How to Check Delivery Note Register Click on Delivery Note Register Reports of Delivery Note Register   Delivery Note Voucher   How to See Party Ledger All Transaction Reports – Click on Account Book   Click on Ledger Select here party ledger Reports will be like this  

Sales Voucher in Tally – Sales Cycle / Proccess Read More »

Rejection In Voucher in TallyPrime – Sales Cycle / Proccess

A Rejection In Voucher is used to record goods returned by customers due to defects, wrong items delivered, or other reasons.  it’s helps record and track the return of goods that were rejected by customers. This voucher ensures accurate inventory updates and keeps track of returned items. For example, if a customer receives 20 units of a product and finds 5 units defective, the customer can return those items. The Rejection In Voucher is used to record this transaction. Practical Scenarios for Rejection In Voucher Defective Goods: Record returns of damaged or defective items from customers. Wrong Delivery: Manage returns of incorrect items sent to customers. Excess Supply: Track items returned due to oversupply or order cancellation.   Party Name: Select the customer or party returning the goods. Date: Enter the date of the transaction. Delivery Note Reference (if applicable): Link the voucher to a corresponding delivery note for better tracking. Item Details: Select the item being returned from your inventory. Enter the quantity being returned. Specify the rate and amount if necessary. Reason for Rejection (optional): Add a note or description explaining the reason for rejection. Once all details are entered, press Ctrl + A to save the voucher. Gateway of Tally >> Vouchers >> Other Vouchers >> Rejection In (CTRL + F6) 1. Following Item Returned  from Ghansyam IT Hub   2. Following Item Returned  from Dubay Mobile Marketing   3. Following Item Return from Bagga Mobile Shop   4. Following Item Return from Adarsh A to Z Mobile Hub   The Rejection In Voucher feature in TallyPrime is a simple yet powerful tool for managing returns from customers. This not only helps in better inventory control but also improves your overall business efficiency.  

Rejection In Voucher in TallyPrime – Sales Cycle / Proccess Read More »

Delivery Notes in TallyPrime – Sales Cycle / Proccess

A delivery note is a document used to record the delivery of goods to customers. It contains details like the quantity, description, and condition of the items being delivered. Delivery notes are useful for ensuring smooth order fulfillment and keeping accurate records. You can record delivery notes as the first voucher and generate a sales bill, or generate a delivery note against a sales bill. Delivery notes help to remind a customer of their order and/or inform them of what is included in the current shipment. Delivery notes can also serve a useful purpose on the seller side as well. For example, if your customer places an order for 50 units of a product, a delivery note records the dispatch of these goods.   Go to vouchers now Select Delivery Note Voucher by clicking on ther vouchers or F10 click on show inactive select delivery note before voucher use we need to activate this once Delivery voucher will be like this – Select here party name if any old order pending received then you can select order no here or not applicable Order Details fill Party ledger details check and accept it delivery note of 5 nos office chair enter the Godown / location details now accept it and save now see balance sheet Balance Sheet Report Current Assets Closing Stock Sundry Debtors Pending Sale bill Good Delivery Note now check item details which received – closing stock Group of item Item Details Profit loss Reports How to check sales bill make pending – Display More Reports Statements of Inventory Sales Bills Pending Bill Details  

Delivery Notes in TallyPrime – Sales Cycle / Proccess Read More »

Scroll to Top