Ankit IT Solutions – Training Institute

Welcome To Ankit IT Solutions!

TallyPrime Advance Course

Job Costing Manage in TallyPrime

Job Costing is a method of costing where costs are assigned to a specific job project or batch. Each job is treated as a unique cost unit, and all related income and expenses are tracked to analyze profitability. Job Costing is used to track expenses and incomes related to a specific project, contract, or job. It helps to know the profit or loss for each job or project.  Enable Job Costing in TallyPrime  Press F11 → Accounting Features.  Set “Maintain cost centres” to Yes.  Set “Use cost centre for job costing” to Yes.  Press Ctrl + A to save.    Steps to Use Job Costing  Create Cost Centres (Jobs/Projects):  Go to: Gateway of Tally → Create → Cost Centres   Allocate Expenses and Income to Cost Centres  While passing any expense/income entry, Tally will ask: “Allocate to Cost Centre?”  View Report  Gateway of Tally → Display More Reports → Cost Centres → Cost Centre Break-up  It shows profit/loss for each project.    Assignment 1: Building Construction Project  You are handling a construction project for a client. You record purchases and services involved.  ➤ Create Cost Centre: Building Construction  Transaction  Amount  Voucher Type  Allocate to  Cement Purchase  ₹1,20,000  Purchase  Building Construction  Labour Charges  ₹50,000  Journal  Building Construction  Site Supervision Expense  ₹10,000  Payment  Building Construction  Payment Received from Client  ₹2,00,000  Receipt  Building Construction  Profit = ₹2,00,000 – ₹1,80,000 = ₹20,000    Assignment 2: Office Renovation Work  You manage renovation for a client’s office. The project includes furniture purchase and labour.  Step 1: Create Cost Centre – Office Renovation  Step 2: Record Entries:  Transaction  Amount  Voucher Type  Allocate to  Purchase of Furniture  ₹75,000  Purchase  Office Renovation  Labour Charges  ₹25,000  Journal  Office Renovation  Payment Received  ₹1,20,000  Receipt  Office Renovation  Task:  Record purchases and labour under Office Renovation.  Record income as Receipt.  Profit = ₹1,20,000 – ₹1,00,000 = ₹20,000    Assignment 3: Computer Lab Setup for College  You are setting up a computer lab in a college. The project includes buying systems and hiring an installation team.  Create Cost Centre: College Lab Setup  Transaction  Amount  Voucher Type  Allocate to  Purchase of 10 Computers  ₹3,00,000  Purchase  College Lab Setup  Installation Charges  ₹25,000  Journal  College Lab Setup  Network Cabling & Accessories  ₹15,000  Journal  College Lab Setup  Payment Received from College  ₹3,75,000  Receipt  College Lab Setup  Profit = ₹3,75,000 – ₹3,40,000 = ₹35,000    Job Costing Summary Table  Project Name  Total Expense  Total Income  Profit  Building Construction  ₹1,80,000  ₹2,00,000  ₹20,000  Office Renovation  ₹1,05,000  ₹1,25,000  ₹20,000  College Lab Setup  ₹3,40,000  ₹3,75,000  ₹35,000       

Job Costing Manage in TallyPrime Read More »

Backup Company in Tally Prime

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 »

Round Off Invoice Value in TallyPrime

  Round Off in TallyPrime is used to adjust small decimal differences in the invoice total. It helps in making the final amount whole or clean, especially when tax and discount calculations lead to amounts like ₹10,542.53.  For example:  Invoice Total = ₹10,542.53  Rounded Off = ₹10,543.00  Round Off Amount = ₹+0.47 (automatically adjusted by Tally)  Why Use Round Off?  For easier billing and cash handling  To match printed invoice totals  Avoids decimal paise confusion  Ensures cleaner accounting records    Steps to Enable and Use Round Off in TallyPrime  Create Round Off Ledger  Go to Gateway of Tally → Create → Ledgers   Name: Round Off  Under: Indirect Expenses (for negative value) OR Indirect Incomes (for positive value)  Type of Ledger: Invoice Rounding  Rounding Method: Normal Rounding  Rounding Limit: 0.50 or 1.00  Save  💡 Tally will auto-adjust the balance and post difference to this ledger.    Add Round Off to Invoice  Go to Vouchers → Sales (F8) / Purchase (F9) Create invoice as usual with items and taxes  After applying taxes, add a ledger line:  Select Round Off ledger  Tally will auto-calculate and round the amount    Click on Create   Click on Ledger Round Ledger Create   Party Name Create Purchase A/c   Stock Item Create   Stock Category Create   Vouchers   Purchase Voucher with round off   Sales Vouchers with round off   Assignments  Assignment 1: Round Off in Sales Invoice  Party: Ravi Traders (Debtor) Date: 01-Apr-2025  Invoice Items:  Item  Quantity  Rate  Amount  Laptop  1 Nos  ₹15,499.49  ₹15,499.49  Smartphone  1 Nos  ₹9,999.65  ₹9,999.65  Sub Total      ₹25,499.14  GST 18%      ₹4,589.85  Total      ₹30,088.99  Rounded      ₹30,089.00  Round Off      ₹+0.01    Tasks to Perform:  Create Ravi Traders under Sundry Debtors  Create stock items: Laptop, Smartphone  Create Round Off Ledger under Indirect Expenses  Pass Sales Invoice with GST and auto Round Off  Check that invoice total becomes ₹30,089.00    Assignment 2: Round Off in Purchase Invoice  Party: ABC Electronics (Creditor) Date: 01-Jan-2025  Invoice Items:  Item  Quantity  Rate  Amount  Laptop  1 Nos  ₹24,999.40  ₹24,999.40  Smartphone  1 Nos  ₹14,999.30  ₹14,999.30  Sub Total      ₹39,998.70  GST 18%      ₹7,199.77  Total      ₹47,198.47  Rounded      ₹47,198.00  Round Off      ₹–0.47    Tasks to Perform:  Create ABC Electronics under Sundry Creditors  Create stock items: Laptop, Smartphone  Use the same Round Off Ledger  Pass Purchase Voucher with GST and auto Round Off  Check that invoice total becomes ₹47,198.00   

Round Off Invoice Value in TallyPrime Read More »

Post-Dated Vouchers in TallyPrime

A Post-Dated Voucher is a voucher (like Payment, Receipt, Journal, etc.) that is entered today but is dated for a future date.  It does not affect your books of accounts or reports until that future date arrives.  Post-dated vouchers help you plan and schedule transactions for future periods, making it easier to manage your finances, and they are typically associated with cheques, payments, or receipts scheduled for a later date. They help in better planning, managing cash flow, and avoiding missed entries when the actual payment/receipt happens later.  Common Use Cases for Post-Dated Vouchers: Post-dated cheques for payments and receipts Future-dated salary payments Scheduled vendor payments EMI payments for loans   Create a Post-Dated Voucher  Go to Accounting Vouchers  Select Payment, Receipt, or Journal  Press Ctrl + T or click Post-Dated (You’ll see “Post-Dated” at the top)  Enter the future date  Fill the voucher details  Save  🎯 This voucher is now saved as Post-Dated. It won’t affect reports until the set date.    Select Voucher and mark it Post Dated   Press F2 and fill dates   Cheque details   Example 1: Post-Dated Cheque Payment  Party: Ravi Traders  Amount: ₹10,000  Date of Cheque: 20-May-2025  Voucher Entry Date: 10-May-2025  Enter Payment Voucher → Mark it as Post-Dated with 20-May-2025. It will not reflect in the ledger or bank until 20th May.    Example 2: Future Receipt from Customer  Customer: ABC Electronics  Amount: ₹25,000  Receipt Scheduled: 01-Jun-2025  Use Post-Dated Receipt Voucher to record it now. It helps plan your cash inflow in reports.    Example 3: Journal Entry for EMI  Expense: Monthly Loan EMI  Date: 10th of every month  You can create multiple Post-Dated Journal Vouchers for each EMI. This way, you can plan future expenses and track them in advance.    The post-dated voucher will not impact your financial accounts until the specified date arrives. On the specified date, the transaction will automatically become active, and its effects will be reflected in your financial statements.

Post-Dated Vouchers in TallyPrime Read More »

Physical Stock Voucher in TallyPrime

A Physical Stock Voucher in TallyPrime is a type of voucher used to record the actual physical count of inventory items on hand.  A Physical Stock Voucher in TallyPrime is used to record actual physical stock available in your store or warehouse. It helps to adjust your book stock (stock shown in Tally) with real stock counted physically.  Physical Stock Vouchers help you keep your Tally stock reports accurate based on real physical availability. They are essential during stock audits or when there is damage, loss, or mismatch.  To reconcile book stock with actual stock. To record shortages or excess stock found during verification. Helps in audit and inventory management. Ensures accurate stock records for better decision-making.   Why Use Physical Stock Voucher?  Situation  Why Use Physical Stock Voucher  Stock damaged, stolen, or lost  Reduce quantity to match actual stock  Found extra stock while counting  Increase quantity to reflect reality  Periodic stock audit or verification  Compare physical vs. system stock  Adjust errors from wrong entries  Fix mistakes without affecting old entries    Create a Physical Stock Voucher  Go to Gateway of Tally → Inventory Vouchers  Press F10 or click Physical Stock  Select the date of stock check  Enter:  Item Name  Actual Quantity counted  Location (if using multiple godowns)  Narration (optional)  Save  ✅ The system compares this with book stock, and adjusts excess or shortage automatically.  Example 1: Shortage of Monitors  Item  Book Qty  Physical Qty  Adjustment  Monitor  10  8  2 Shortage  Enter 8 units as actual qty in Physical Stock Voucher. Tally will reduce stock by 2 units.    Example 2: Excess Stock of Keyboards  Item  Book Qty  Physical Qty  Adjustment  Keyboard  15  18  3 Excess  Enter 18 units. Tally increases the stock by 3.    Example 3: Complete Stock Count of Multiple Items  Item  Physical Qty  Laptop  5 Nos  Mouse  10 Nos  Headphones  3 Nos  Create a single Physical Stock Voucher, enter all items and their actual counted quantity. Tally will compare with book balance and update differences.    By using the Physical Stock Voucher, you accurately reflect the actual stock levels in your records, ensuring that your financial statements provide an accurate representation of your inventory position. This is crucial for making informed business decisions and maintaining accurate financial records.

Physical Stock Voucher in TallyPrime Read More »

Optional Vouchers in TallyPrime – A Step-by-Step Guide

An Optional Voucher in TallyPrime is a temporary voucher that does not affect the books of accounts unless converted into a regular voucher.  It means you can enter a full transaction, save it, but it won’t affect your accounts or stock unless you make it regular later. Here’s why Optional Vouchers are useful:  Situation  Use of Optional Voucher  Bill not finalized yet  Save as Optional  Trial entry for checking impact  Optional voucher shows effect in reports  Need supervisor approval before posting  Save optional, confirm later  Proforma Invoice (Quotation)  Use Optional Sales Voucher    Go to vouchers and select any voucher and see right sidebar – optional by default vouchers are are regular mode if you want to record details in optional mode then you can enable clicking on its button to on or off. after clicking you will see here its marked as optional   after saving the voucher see reports by clicking See here all list of receipt voucher Click on Exceptions reports   Optional Voucher See reports See voucher and once convert it regular   and save it after saving voucher see receipt note voucher report it will start seen, as it you can apply another voucher as your need

Optional Vouchers in TallyPrime – A Step-by-Step Guide Read More »

Scroll to Top