Ankit IT Solutions – Training Institute
How to check purchase bill make pending – Display More Reports Statements of Inventory Purchase Bills Pending Reports
How to See / View Purchase Bills Pending Reports in TallyPrime Read More »
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
How to Check Delivery Note Register Read More »
Click on Sales Order Outstandings Reports Click on All Orders Reports of Sales Order Outstandings Reports
How to Check Sales Order Outstandings Reports – Read More »
Sales bills pending or outstanding are the invoices raised for sales but not yet paid by customers. These bills are recorded as Receivables under the accounts group ‘Sundry Debtors’ in the balance sheet. TallyPrime provides detailed reports to track and manage these outstanding bills. Tracking pending or outstanding sales bills helps businesses maintain a healthy cash flow and efficiently follow up with customers for payments. Types of Outstanding Reports in TallyPrime TallyPrime offers several types of outstanding reports: Ledger-wise Outstanding: Shows pending bills for each customer account. Group-wise Outstanding: Categorizes outstanding bills by customer groups. Bill-wise Outstanding: Displays individual pending invoices with due dates and aging analysis. Receivables & Payables Report: Shows a comprehensive view of all receivables and payables, helping businesses understand their cash flow position. Click on Display More Reports Click On Statement of Inventory Sales Bills Pending Report Reports – No Pending Bills
How to Check Sales Bills Pending / Outstanding in TallyPrime Read More »
Exporting the balance sheet from TallyPrime to Excel is a straightforward process that enhances your ability to analyze and present financial data. open your reports which want to Export for example Balance sheet See Balance Sheet Step 2: Go to Export Option TallyPrime will prompt you to choose the Type of Data you want to export. Some of the common types of data you can export include: Once the company is open, press Alt + E or go to Gateway of Tally > Export. Masters (like ledgers, stock items, etc.) Transactions / Vouchers (like invoices, receipts, payments, etc.) Reports (like trial balance, P&L, balance sheet, etc.) Selected (Current) Choose the Specific Data to Export After selecting the format, you’ll need to specify what kind of data you want to export. This could include: Specific Ledger: Export transactions of a particular ledger. Voucher Types: Export data related to particular voucher types (like Sales, Purchase, Payment, etc.). Reports: If exporting reports, select the desired report (e.g., Profit and Loss, Balance Sheet, etc.). If exporting a report, choose the Period (e.g., for a specific month or year). Here configure information Step 3: Select the Format for Export TallyPrime allows you to export in different formats Select the format based on your requirement. For example, if you want to export a report to Excel, after select the format then press CTRL + A Excel (XLS): For easy data analysis in Excel. XML: For importing/exporting data between TallyPrime and other systems. CSV: For transferring data in a comma-separated format. PDF: For reports you want to keep in a readable format. now need to backup / export folder where data will be saved after exported Change the Destination Path Next, TallyPrime will ask you to specify the destination where you want to save the exported file, Select specific Path Select the Destination Path Enter the file path where you want to save the exported data, Press Enter to confirm and export the path. Select Backup folder – D:\TallyBacupFolder Paste or type here file path to export report – D:\TallyBacupFolder , after pasting or typing press CTRL + A Now here you can also change name of file just make sure add the extension of file format type. after all configuration press CTRL + A Exporting Start See Exported into Excel Verify the Export Once the export is complete, TallyPrime will show a confirmation message. You can now go to the folder where you saved the exported file and open it to check the data. See Backup / Export Folder after export
How to Configure & Print Balance Sheet Report in TallyPrime to in Excel? Read More »
TallyPrime is a powerful and easy-to-use business accounting software developed by Tally Solutions Pvt. Ltd. It is designed to manage everything from accounting, inventory, taxation, payroll, banking, invoicing, and more — all in one place. TallyPrime is the latest version of Tally ERP 9 with enhanced features and a more user-friendly experience. It simplifies accounting, GST compliance, inventory management, payroll, and more—all in one platform. 🧾 Key Features of TallyPrime Here are some core features that make TallyPrime a complete business management tool: 1. Accounting & Invoicing Maintain ledgers, vouchers, and financial records Create professional invoices with GST details Track payables and receivables 2. Inventory Management Manage stock items, units, and godowns Track stock movements and reorder levels Handle multiple price levels and batches 3. GST Compliance Generate GST invoices easily File GSTR-1, GSTR-3B, and other returns Automatically apply HSN/SAC codes and tax rates 4. Banking Bank reconciliation Digital payments Print cheques and manage bank ledgers 5. Payroll & Employee Management Calculate salaries and deductions Generate payslips and manage employee records Comply with PF, ESI, and other statutory requirements 6. Multi-User and Remote Access Use Tally in LAN or online mode Access your data from anywhere (with Tally.NET subscription) 7. Reports & Analysis Generate Balance Sheets, P&L accounts, cash flow, and more Get insights through dashboards and drill-down reports What is Tally ERP 9? Tally ERP 9 was the previous version of Tally software, widely used for accounting and business management. It provided core functionalities like financial accounting, inventory management, payroll processing, GST compliance, and multi-user access.
What is TallyPrime Software? Read More »
TallyPrime provides a range of shortcut keys to make accounting tasks easier and faster. Below is a comprehensive list of over 500 shortcut keys, categorized for better readability. Basic Navigation Shortcuts Esc – Close the current screen or exit TallyPrime Ctrl + A – Save and accept the screen Alt + G – Open the “Go To” search bar Alt + K – Open Company menu Alt + Y – Open the Reports menu Alt + H – Open Tally Help Ctrl + Q – Quit TallyPrime Ctrl + M – Switch to Main Area of TallyPrime Ctrl + N – Open Calculator Ctrl + T – Open Task Manager Ctrl + U – Restore Default Settings Company Management Shortcuts F1 – Select or Load Company Alt + F1 – Shut the active Company Ctrl + F3 – Select different companies Alt + F3 – Company Information (Create, Alter, Backup, Restore) Alt + F2 – Change Period Ctrl + F2 – Date Range Selection Alt + B – Create Company Backup Voucher Entry Shortcuts F2 – Change the Date F4 – Contra Voucher F5 – Payment Voucher F6 – Receipt Voucher F7 – Journal Voucher F8 – Sales Voucher F9 – Purchase Voucher F10 – Memorandum Voucher Alt + F9 – Debit Note Alt + F10 – Reversal Journal Alt + I – Insert a Voucher Alt + X – Cancel a Voucher Alt + D – Delete a Voucher Alt + F8 – Credit Note Alt + F6 – Stock Journal Ctrl + F6 – Rejections Out Ctrl + F8 – Sales Order Ctrl + F9 – Purchase Order Ctrl + F7 – Rejections In Ctrl + H – Change Mode in Voucher Entry. Inventory & Stock Management Shortcuts Ctrl + I – Open Stock Summary Ctrl + S – Open Stock Details Ctrl + R – Reorder Stock Alt + E – Export Stock Report Alt + O – Import Stock Data Alt + L – Open Price List Accounting & Reports Shortcuts Alt + P – Print current screen Ctrl + P – Print a Report Ctrl + E – Export a Report Alt + C – Create a new Ledger, Stock Item, or Group Alt + R – Restore a Deleted Voucher Ctrl + D – Delete a Ledger F12 – Configuration Ctrl + W – Open Trial Balance Ctrl + B – Open Balance Sheet Ctrl + Y – Open Profit & Loss Account Ctrl + K – Cash Flow Report Ctrl + O – Outstanding Report GST & Taxation Shortcuts Alt + J – GST Reports Ctrl + J – Open GST Portal Alt + S – Statutory Reports Alt + T – Tax Computation Ctrl + G – GSTR-1 Filing Ctrl + L – GSTR-3B Filing Ctrl + F4 – Open Tax Ledger Ctrl + F5 – Input Tax Credit Report Banking Shortcuts Alt + B – Bank Reconciliation Ctrl + F10 – Cheque Printing Ctrl + F11 – Bank Statement Import Alt + U – Update Bank Details Miscellaneous Shortcuts Ctrl + Shift + R – Refresh Reports Ctrl + Shift + P – Change Print Settings Ctrl + Shift + E – Export Data in Excel Ctrl + Shift + X – Cancel a Transaction Alt + F4 – Close Application This is a comprehensive list of TallyPrime shortcuts to help users navigate and manage accounting tasks efficiently. Mastering these shortcuts can significantly improve productivity and ease of use in TallyPrime.
500 Shortcut Keys for TallyPrime Software Read More »
Bank interest is a common part of accounting, and understanding how to calculate it and record it properly in accounting software like TallyPrime is essential for accurate financial tracking. Bank interest is the money you earn from the bank when you deposit funds into an interest-bearing account (like savings or fixed deposit accounts). Banks pay interest as a percentage of the balance you hold, and this is typically calculated based on an annual percentage rate (APR). Understand the Key Terms for Loan Interest Calculation Before you can calculate loan interest, you need to know the following details about the loan: Loan Amount (Principal): The amount of money you’ve borrowed. Interest Rate: The rate at which interest is charged, usually an annual percentage rate (APR). Time Period: The length of time you will repay the loan, typically in months or years. Repayment Frequency: How often interest is charged (monthly, quarterly, annually). Calculate Loan Interest There are different methods for calculating loan interest, but the two most common ones are Simple Interest and Compound Interest. 1. Simple Interest The formula for calculating simple interest is: Simple Interest = (Principal × Rate × Time) ÷ 100 Where: Principal is the loan amount. Rate is the interest rate per year. Time is the loan term in years. Example: Let’s assume you took a loan of ₹100,000 at an interest rate of 8% per year for 2 years. To calculate the simple interest: Interest = (100,000 × 8 × 2) ÷ 100 Interest = ₹16,000 So, the total interest on ₹100,000 over 2 years at 8% per year will be ₹16,000. 2. Compound Interest Compound interest is more complicated, as it’s calculated on the principal plus any interest that has already been added to the loan. The formula for compound interest is: Compound Interest = P × (1 + (r/n))^(nt) – P Where: P is the principal loan amount. r is the annual interest rate (in decimal form). n is the number of times interest is compounded per year (e.g., monthly = 12). t is the time the money is borrowed for, in years. Example: For the same ₹100,000 loan at 8% annual interest, compounded monthly for 2 years, the compound interest formula would look like this: Compound Interest = 100,000 × (1 + (0.08/12))^(12×2) – 100,000 Compound Interest = ₹16,612.15 The total compound interest for the same loan amount, time, and rate comes out to ₹16,612.15 (slightly higher than the simple interest calculation due to compounding).
How to Calculate Bank Interest and Record It in TallyPrime Read More »
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. This assignment focuses on understanding and practicing the Contra Voucher Entry in TallyPrime. 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 – TallyPrime Tutorial Read More »
Backing up your company data in TallyPrime is an essential practice to ensure the safety of your financial records. Regular backups protect your data from unexpected issues like system crashes, corruption, or accidental deletions. By following this guide, you can ensure that your data is secure and recoverable in case of any unforeseen issues. Make backup creation a regular part of your accounting routine to avoid unnecessary stress and data loss. Open TallyPrime Launch the TallyPrime application on your computer, Ensure you are on the Gateway of Tally screen. Press Alt + Y or click on Data Access the Company Backup Option Press Alt + Y on your keyboard, Alternatively, click on Data from the top menu and select the Backup option. Specify the Backup Location Destination: Specify the location where you want to save the backup file. You can Browse and select a folder on your computer or Use an external drive or network location for added safety. In the Backup Companies screen, you will see the following fields: After Selected file Backup Destination Path Backup Destination Folder before Backup Select the Company to Backup Source: This is the location where your current company data is stored. By default, TallyPrime will automatically detect it. A list of all companies in the source location will appear. Use the spacebar to select the company or companies you want to back up. You can select one or multiple companies as needed. In the Backup Companies screen, you will see the following fields: Company Selected Step 5: Start the Backup Process Once you’ve selected the destination and the companies to back up, press Enter to start the backup process, TallyPrime will display a confirmation message once the backup is complete. Successfully Backup Taken Step 6: Verify the Backup Navigate to the destination folder you specified Tips for Effective Backups Backup Regularly: Schedule regular backups to ensure your data is always safe. Use Multiple Locations: Save backups in multiple locations, such as an external drive or cloud storage, for extra protection. Name Folders Clearly: Use descriptive folder names with dates (e.g., “Backup_Jan2025”) to easily identify your backups. Test Restores: Periodically restore a backup to ensure the data is recoverable and the file isn’t corrupted. Secure Your Backups: Protect your backup files by storing them in secure, access-controlled locations.
Backup Company in Tally Prime Read More »