Ankit IT Solutions – Training Institute

Welcome To Ankit IT Solutions!

TallyPrime Course

Budget & Control in Tally Prime

A budget is a plan to prepared for the flow of funds / money in an organization. It contains financial guidelines for the future plan of action for a selected period of time. By creating budgets for income, expenses, and specific projects, and comparing the actual performance with the budgeted figures, businesses can make better financial decisions Budgeting helps businesses to set a financial plan (budget) for different accounts, groups. after its enables you can compare actual performance with your planned budget and take necessary actions when deviations occur.  Budget Control is a simple yet powerful way to:  Control expenses 💸  Track income targets 📈  Improve business performance 💼  With proper budgeting, you can manage your resources better and make smarter financial decisions.  Multiple budgets can be created for specific purposes in Tally Prime, Such as Marketing Budgets, Finance Budgets, and so on, can also be created.   Step 1 Create Expense Ledger   Step 2 Create Budget Gateway Of Tally >> Create >> Budget If You Didn’t Find “Budget” Option Then Click On Show More Option And Search   Budget Creation Budget Name – Office Budget Under – Primary Period of Budget – 1-Apr-22 to 31Mar-23 Ledger – Yes     Budget Amount Setup    Step 4 : Payment Voucher as Your Expense, Now Pass You Entry Which Amount Paid By Your Company over the time. Here Passed Two Entry For Expense Which Amount Paid By Cash To Advertisement Agency And Other Stationary Shop   Profit & Loss A/c GOT >> Profit & Loss A/c  >> Indirect Expenses   Click Budget Variance   Budget     Example 1: Budget for Office Rent  Ledger  Monthly Budget  Annual Budget  Rent A/c  ₹10,000  ₹1,20,000  You can now track if monthly rent exceeds this budget.    Example 2: Departmental Sales Target  Department  Annual Sales Budget  Electronics Dept.  ₹10,00,000  Clothing Dept.  ₹5,00,000  Tally compares actual sales and tells you how much is achieved.    Example 3: Event Budget Tracking  Expense Type  Budgeted Amount  Venue Rent  ₹50,000  Catering  ₹30,000  Decoration  ₹20,000  Helps in managing cost of events like seminars, training, etc.   

Budget & Control in Tally Prime Read More »

Manufacturing Voucher or Bill of Materials (BOM) in TallyPrime

“Manufacturing” is a broader concept that refers to the process of creating / producing goods through the transformation of raw materials or components into finished products. Bill of Materials (BOM): Tally Prime allows you to create and manage Bill of Materials, which is a detailed list of all the components, raw materials, and sub-assemblies required to manufacture a finished product. Cost Tracking: Manufacturing involves various costs such as raw materials, labor, overheads, and more. Tally Prime’s manufacturing features help in tracking and calculating these costs accurately, providing insights into the overall cost of production. Manufacturing means converting raw materials into a finished product.  In TallyPrime, you can record the process of manufacturing using features like:  Bill of Materials (BOM) Manufacturing Journal Stock Items & Units Cost Tracking    Why Use Manufacturing in TallyPrime?  Using the manufacturing feature in TallyPrime helps you:  Purpose  Benefit  Track material usage  Know how many raw materials were used  Record finished goods  Maintain correct stock of manufactured items  Calculate actual cost of production  Include all direct costs in finished product  Save time  Automated material consumption entries    To make it efficient, TallyPrime uses a Bill of Materials (BOM), which is a predefined list of raw materials required to manufacture a finished product.   Step 1 Purchase Following Raw Material GOT >> Vouchers >> Purchase   Step 2 Create A New Voucher Gate Way Of Tally >> Create >>Voucher Type Select type of voucher Use as Manufacturing voucher journal   Step 3 Create Finishing Stock Item “Computer Assemble”   Set Up Components or Raw Materials Ratio Quantity   Step 4 Pass Manufacturing Voucher by Pressing ALT F7   Manufacturing Voucher will be like this   Example 1: Computer Assembling  Party: TechSource Traders  Raw Material Purchase:  Item  Qty  Rate  Amount  CPU  10  ₹20,000  ₹2,00,000  Monitor  10  ₹10,000  ₹1,00,000  Keyboard  10  ₹1,000  ₹10,000  Mouse  10  ₹500  ₹5,000  Total Purchase = ₹3,15,000  Production:  You assemble 5 Computer Sets using 5 of each component.  Used Material  Qty Used  CPU  5  Monitor  5  Keyboard  5  Mouse  5  Finished Product: 5 Computer Sets @ ₹63,000 each = ₹3,15,000    Balance Stock:  Item  Opening  Used  Balance  CPU  10  5  5  Monitor  10  5  5  Keyboard  10  5  5  Mouse  10  5  5  Computer Set  0  —  5    Example 2: Car Manufacturing  Party: AutoZone Parts Ltd.  Raw Material Purchase:  Item  Qty  Rate  Amount  Car Engine  5  ₹1,50,000  ₹7,50,000  Car Body  5  ₹2,00,000  ₹10,00,000  Tyre Set  5  ₹25,000  ₹1,25,000  Paint Material  5  ₹5,000  ₹25,000  Total Purchase = ₹19,00,000    Production:  Assemble 5 Cars  Used Material  Qty Used  Car Engine  5  Car Body  5  Tyre Set  5  Paint Material  5  Finished Product: 5 Cars @ ₹3,80,000 each = ₹19,00,000    Balance Stock:  Item  Opening  Used  Balance  All Items  5  5  0  Car  0  —  5    Example 3: Cake Manufacturing in a Bakery  Party: Fresh Bake Suppliers  Raw Material Purchase:  Item  Qty  Rate  Amount  Flour  50 kg  ₹40  ₹2,000  Sugar  20 kg  ₹45  ₹900  Butter  10 kg  ₹200  ₹2,000  Eggs  100  ₹10  ₹1,000  Boxes  20  ₹20  ₹400  Total Purchase = ₹6,300    Production:  Bake 20 Cakes  Used Material  Qty Used  Flour  20 kg  Sugar  10 kg  Butter  5 kg  Eggs  40  Boxes  20  Finished Product: 20 Cakes @ ₹315 each = ₹6,300    Balance Stock:  Item  Opening  Used  Balance  Flour  50 kg  20  30 kg  Sugar  20 kg  10  10 kg  Butter  10 kg  5  5 kg  Eggs  100  40  60  Boxes  20  20  0  Cakes  0  —  20           

Manufacturing Voucher or Bill of Materials (BOM) in TallyPrime Read More »

How to Calculate Interest in TallyPrime: A Step-by-Step Guide

Interest calculation in TallyPrime means calculating interest automatically on outstanding receivables or payables (like overdue invoices, loans, advances).  Interest can be calculated on the basis of Simple or Compound Interest , In TallyPrime, you can calculate Simple Interest easily, which is one of the simplest methods for interest calculation. You can calculate interest:  Party-wise (Customer/Supplier)  Voucher-wise (Individual invoice)  Automatically or manually    Enable Interest Calculation in TallyPrime  Go to: Gateway of Tally → Press F11 (Features)  Enable: Accounting Features  Set “Activate Interest Calculation” to Yes  Press Ctrl + A to save    Step 1 Enable Interest Calculation Features In Tally Prime by Pressing F11 Key.   Required Following Details Party A/c under Sundry Creditors / Debtors  Purchase A/c under Purchase Accounts  Interest Paid under indirect Expense   Step 2 How to Create a Party Ledger with Interest Parameters Gateway of Tally → Create → Ledgers  Name: ABC Traders /Advantech Computer Under: Sundry Debtors or Sundry Creditors  Maintain Balances Bill-by-Bill: Yes  Set “Activate Interest Calculation”: Yes  Create / Alter A Ledger and Enable Activate interest calculation.   Step 3 Set Interest Parameters:  Calculate Interest Transaction-by-Transaction: Yes  Override Parameters for Each Transaction: Yes/No (Your choice)  Interest Rate: e.g., 10%  Style of Calculation: calender year or 30-day month  Interest Type: Simple (or Compound if required)  In this Tutorial Suppose Interest Will Apply 10% Yearly After Payment Due Date When Any Party Crossed His Payment Date, Then We will Charge  @ 10% Yearly as Interest or (According to your Companies / Farm Rules).   Important Interest Terms  Term  Meaning  Rate of Interest  The % rate applied annually (e.g., 12%)  From Due Date  Interest will start after the credit period  Override Parameters  You can change interest for each invoice at voucher level  Style of Calculation  Based on 365-day year or 30-day month style    Step 4 Company Purchase Following Item on Credit 30 days – Purchase Voucher  Voucher Entries  1Apr- 2023 – Laptop 2 Nos @43000 from ABC Traders on Credit  Credit Days 30 Due Date 01-05-23 2Nov- 23 -Credit Note – Interest Paid  Make Full Payment     Step 5 Due Date or Credit Days Setup (30 Days) – according to your requirement   How to View Interest Reports  Go to: GOT >> Display More Report >>  Statement of Account >>  >> Interest Calculation >>  Interest Payable >> F2 > Choose Period Company didn’t pay their amount till 02-11-23 due any reason , so here interest will be applied. See Interest Report     Interest Report Credit Note Voucher Pass Credit Note Voucher (ALT + F6)  of Interest Amount to Party Account Credit Note Voucher Date – 02-11-23 Voucher Mode – Interest Accounting Ledger Name Interest Paid Under Indirect Expense Ledger Creation (Interest Paid)   Note : Open Credit Note Voucher and Press CTRL + H to change Voucher Mode –   Select Party Account   Credit Note will be like some thing this   Balance Sheet After Credit Note You will be showed interest amount added into part account and your Liabilities will be Increased.   Payment Voucher Make Full Payment Voucher Against bill No and Credit note   Payment Voucher   Sales Voucher-   Required Following Ledger  Party A/c under Sundry Debtor  Sales A/c under Sales Accounts  Interest Received under Indirect Income  Voucher Entries  1 July-25 Sold 1 LAPTOP to Rahul Kumar @53200 on credit 15 days   31 July-25 10% Interest Yearly    Make Full Payment    Assignments    Assignment 1: Interest on Customer Outstanding  Party: Ravi Traders (Debtor) Interest Rate: 15% per annum Invoice Date: 01-Apr-2025 Invoice Amount: ₹50,000 Credit Period: 30 days Payment Not Received till 31-May-2025  Tasks:  Enable interest calculation with advanced parameters  Create Ravi Traders ledger under Sundry Debtors  Set up 15% interest from due date  Pass a sales invoice of ₹50,000  View interest due in Interest Calculation Report    Assignment 2: Interest on Loan Payable  Party: ABC Finance (Creditor) Loan Taken: ₹1,00,000 on 1-Jan-2025 Interest Rate: 10% p.a. Interest Type: Simple Payment Not Made till 31-Mar-2025  Tasks:  Create ABC Finance ledger under Sundry Creditors  Enable simple interest @10%  Pass a journal entry for loan received  Check interest payable on 31-Mar-2025 in report    TallyPrime simplifies the process of Simple Interest Calculation, saving time and reducing errors. Whether you’re tracking loans, delayed payments, or investments, the feature helps you manage your finances effectively. Follow the step-by-step guide above to start calculating interest in TallyPrime effortlessly.

How to Calculate Interest in TallyPrime: A Step-by-Step Guide Read More »

Cost Center Maintenance in TallyPrime: A Step-by-Step Guide

A Cost Center is a unit or part of your business (like a department, employee, branch, or project) where you want to track income and expenses.  If your business has different departments, branches, or projects, you need a smart way to track the expenses and incomes for each one separately. Cost Center helps you know which part of your business is making money and which part is spending more.  Departments: Marketing, Sales, Administration. Projects: Construction Project A, Software Development Project B. Locations: Branch A, Branch B. By assigning transactions to Cost Centers, you can monitor the financial performance of each unit independently.   Step 1. Enable Cost Centre Features by Pressing  F11 Key Enable Cost Centres = “YES”   Step 2. Create Cost Center as You Required GOT → Create → Cost Centres   Step 3. Create Ledger as You Required GOT → Create → Ledger Suppose “Incentive Paid” to Our Employee which is Like this.   Step 4. Pass Payment Voucher With Cost Center GOT → Vouchers → Payment Select cost center here, if you are not able to see then press F12 key from keyboard.   display cost centres configuration   Now pass payment voucher   Assignment Create following cost centres GOT → Create → Cost Centres A. Salary Paid B. Electricity Charges C. Telephone Charges D. Commission Received E. Discount Received   Create following Ledger   Assignment Post the following transactions: 1. 01.04.2006 Salary Paid Rs. 200000: A. Purchases Department 30%; B. Sales Department 40%; C. Production Department 30%. 2. 01.05.2006 Electricity Charges Paid Rs. 30000: A. Purchases Department 25%; B. Sales Department 35%; C. Production Department 40%. 3. 01.07.2006 Telephone Charges Rs. 12000; A. Purchases Department 30%; B. Sales Department 35%; C. Production Department 35%. 4. 01.08.2006 Commission Received Rs.6000; A. Purchases Department 40%; B. Sales Department 40%; C. Production Department 20%. 5. 01.09.2006 Discount Received Rs. 4000; A. Purchases Department 40%; B. Sales Department 40%; C. Production Department 20%.   Example 1: Department-wise Expense Tracking (Office Setup)  A company is setting up a new office and wants to track how much money is spent by the Marketing and IT departments.  Create Cost Centres:  Marketing Dept  IT Dept  Transactions:  Expense Description  Amount  Cost Centre  Voucher Type  Purchased Laptops  ₹80,000  IT Dept  Purchase  Bought Posters & Flyers  ₹10,000  Marketing Dept  Purchase  Internet Setup Charges  ₹5,000  IT Dept  Journal  Social Media Ads  ₹15,000  Marketing Dept  Payment  Purpose:  Now, management can see how much each department spent and make budget decisions based on that.    Example 2: Branch-wise Profit Tracking (Retail Business)  A retail business has two branches—Delhi and Mumbai. The owner wants to see the profit made by each branch.  Create Cost Centres:  Delhi Branch  Mumbai Branch  Transactions:  Description  Amount  Cost Centre  Voucher Type  Sales at Delhi  ₹1,20,000  Delhi Branch  Sales  Purchase for Delhi  ₹80,000  Delhi Branch  Purchase  Sales at Mumbai  ₹1,50,000  Mumbai Branch  Sales  Purchase for Mumbai  ₹1,10,000  Mumbai Branch  Purchase  Profit Calculation:  Branch  Income  Expense  Profit  Delhi Branch  ₹1,20,000  ₹80,000  ₹40,000  Mumbai Branch  ₹1,50,000  ₹1,10,000  ₹40,000  Purpose:  Branch-wise tracking helps compare performance and plan future investments or expansions.    Cost Centers in TallyPrime are a powerful tool to track and analyze expenses and incomes for specific business units. Whether you’re managing departments, projects, or locations, Cost Centers help streamline financial reporting and improve decision-making.

Cost Center Maintenance in TallyPrime: A Step-by-Step Guide Read More »

Point of Sale (POS) in TallyPrime: A Simplified Guide

  POS (Point of Sales) is a feature through which we can create an Invoice at a point of sales, and collect the payment from the customers in various method. POS (Point of Sale) means the place where a customer makes payment for goods or services at a store.  it can be a reception counter or retail place where sales transaction records. TallyPrime provides a Point of Sale (POS) feature, specifically designed for retail businesses. It streamlines the billing process, handles inventory automatically, and provides insights into sales performance. Features of POS in TallyPrime Fast Billing: Generate invoices quickly to minimize customer wait times. Multi-Mode Payment: Accept payments through cash, credit card, or digital wallets. Inventory Management: Automatically update stock levels after every sale. Customizable Invoices: Generate sales invoices tailored to your business needs. Discounts and Offers: Easily apply discounts or promotional pricing. In TallyPrime, POS is used in retail businesses where fast billing is needed. It supports different payment methods like cash, debit card, credit card, coupons, wallets, etc.  Payment Methods in POS (TallyPrime)  Payment Method  Description  Cash  Payment made in physical currency  Credit Card  Payment through credit card machine  Debit Card  Payment through customer’s bank debit card  Coupon Code  Gift voucher, promo code, discount coupon  Bank  Payment via UPI, Cheque, Online Transfer    How to Create POS Voucher Type  Voucher Name : POS Invoice Select type of voucher : Sales Use for POS invoicing : Yes Save Step 2 1. Gateway of Tally > Vouchers > F8: Sales > Point of Sale Billing.   Gateway of Tally > Vouchers > F8: Sales > Point of Sale Billing. Go to Gateway of Tally > Vouchers  Press F8 or select your POS voucher  Select Customer or Walk-in customer  Choose Items being sold  Add Quantity and Rate  In Payment Methods, you will see multiple modes:  Cash  Add the correct amount in each method  Press Enter and Save the voucher      Point of Sale in Tally Prime (Method 2 – Enable Gift Vouchers Credit/Debit Card) Enabling Gift Vouchers Credit/Debit Card Payment In Point of Sale Voucher. Step 1. Create Following Ledger Coupon Voucher Under Sundry Debtor SBI Bank Under Bank Account Step 2 Gateway Of Tally >> Create>> Voucher Type>> Point of Sale Billing Add Class POS     Set Your Default Ledger For Point of Sale Invoice in Voucher Class.     Point of Sale Invoice Go to Gateway of Tally > Vouchers  Press F8 or select your POS voucher  Select Customer or Walk-in customer  Choose Items being sold  Add Quantity and Rate  In Payment Methods, you will see multiple modes:  Cash  Credit Card  Debit Card  Coupon Code  Bank (via UPI, Cheque, etc.)  Add the correct amount in each method  Press Enter and Save the voucher    The Point of Sale (POS) feature in TallyPrime simplifies retail billing, helps manage inventory, and ensures smooth business operations. Whether you run a small store or a large retail chain, POS in TallyPrime is a valuable tool for handling day-to-day sales efficiently.   Assignment 1: POS Invoice with Mixed Payments  Customer Name: Ramesh Traders  Ledgers to Create:  Cash A/c – Under Cash-in-hand  Bank Accounts A/c – Under Bank Accounts  Coupon Code A/c – Under Indirect Expense   POS Invoice Entry  Voucher Type: POS Invoice Customer: Ramesh Traders Date: 01-Apr-2025  Item  Quantity  Rate  Amount  Laptop  1 Nos  ₹50,000  ₹50,000  Smartphone  1 Nos  ₹20,000  ₹20,000  Total      ₹70,000    Payment Methods Used:  ₹30,000 – Cash  ₹25,000 – Credit Card  ₹15,000 – Coupon Code     Assignment 2: POS Sale with Debit Card and Bank Payment  Customer Name: Suresh Enterprises  POS Invoice Entry  Voucher Type: POS Invoice Customer: Suresh Enterprises Date: 01-Apr-2025  Item  Quantity  Rate  Amount  Laptop  1 Nos  ₹45,000  ₹45,000  Smartphone  2 Nos  ₹15,000  ₹30,000  Total      ₹75,000   Payment Methods Used:  ₹35,000 – Debit Card  ₹40,000 – Cash   

Point of Sale (POS) in TallyPrime: A Simplified Guide Read More »

How to Record Zero Value Entries & Blank Cheque Entries in TallyPrime

A Zero Value Entry refers to any transaction in TallyPrime where the monetary value of the item or transaction is zero, i.e., no amount is paid or received, but the movement of stock, asset, or document is recorded.  Zero value transaction is used when you want to pass the entry without any amount, for example free samples Distributed or Received, there is no value of goods to be received or paid. You Have To Make Some Changes in Payment Voucher For Pass Zero value transaction. When & Why to Use Zero Value Entry?  When stock is sent or received as a sample (no payment involved).  When goods are placed in a store for display or consignment, but ownership isn’t transferred.  When blank cheques are issued or received without specifying amount.  For internal transfers without any value exchange.  Examples include: Free Samples: Giving samples to customers for marketing purposes. Promotional Offers: Recording free products in “Buy One Get One Free” deals. Replacements: Issuing replacements for defective goods at no charge. Internal Transfers: Moving stock between departments without a monetary transaction.   Example of Zero Value Entry Your business gives 5 units of Product A as a free sample to a customer. The price per unit is ₹100, but since it’s a free sample, the total amount is ₹0.   Step 1 Enable Zero Valued Transaction Click on Voucher Type Click on Purchase   Here You Have To Allow Zero Valued Transaction = Yes   Here You Have To Allow Zero Valued Transaction = Yes Now record transaction Sample Received   Now Sample issued Alter sales voucher Here You Have To Allow Zero Valued Transaction = Yes     Sales   Sampling – Zero Value Stock Entries  In these cases, goods are issued or received for sampling purposes, without any monetary value.  📘 Assignment 1: Issue Laptop Sample to Dealer  Item  Quantity  Rate  Amount  Narration  Laptop  1 Nos  ₹0  ₹0  Sample issued to Tech World  Task:  Enable: Allow Zero Valued Transactions in F11 → Inventory.  Create Stock Item: Laptop.  Use Delivery Note voucher.  Qty: 1 | Rate: ₹0 | Amount: ₹0.  Narration: “Sample laptop issued to Tech World – No commercial value.”    📘 Assignment 2: Receive Smartphone Sample from Vendor  Item  Quantity  Rate  Amount  Narration  Smartphone  2 Nos  ₹0  ₹0  Received samples from ABC Mobiles  Task:  Create Stock Item: Smartphone.  Use Receipt Note voucher.  Qty: 2 | Rate: ₹0.  Narration: “Sample smartphones received – No purchase value.”    📘 Assignment 3: Issue Tablet for Demo Event  Item  Quantity  Rate  Amount  Narration  Tablet  3 Nos  ₹0  ₹0  Issued for demo event at college  Task:  Use Delivery Note voucher.  Item: Tablet | Qty: 3 | Rate: ₹0.  Narration: “Tablets sent for product demonstration – No cost involved.”      Blank Cheque Entries – Zero Value Journal or Payment  Blank cheques are issued or received for security with no value filled.  Assignment 1: Blank Cheque Issued to Vendor  Ledger  Amount  Narration  Bank A/c (Cr)  ₹0  Issued blank cheque to Ravi Traders for security  Ravi Traders (Dr)  ₹0    Task:  Use Journal Voucher.  Credit: Bank A/c ₹0  Debit: Ravi Traders ₹0  Narration: “Blank cheque issued to Ravi Traders as security.”    Assignment 2: Blank Cheque Received from Client  Ledger  Amount  Narration  ABC Enterprises (Cr)  ₹0  Received blank cheque for future payment  Bank A/c (Dr)  ₹0    Task:  Use Journal Voucher.  Credit: ABC Enterprises ₹0  Debit: Bank A/c ₹0  Narration: “Blank cheque received from client for future use.”    Assignment 3: Blank Cheque Issued to Staff for Travel Advance  Ledger  Amount  Narration  Bank A/c (Cr)  ₹0  Issued blank cheque to Mr. Anil for travel advance  Anil Kumar (Dr)  ₹0    Task:  Use Payment Voucher.  Credit: Bank A/c ₹0  Debit: Anil Kumar (Staff) ₹0  Narration: “Blank cheque issued for travel – no amount specified.”    Summary Table  Type  Entry Type  Item/Ledger  Rate/  Amount  Purpose  Sample Issue  Delivery Note  Laptop, Tablet  ₹0  Marketing/demo/sample distribution  Sample Receive  Receipt Note  Smartphone  ₹0  Received for testing/showcase  Blank Cheque Issued  Journal/Payment  Vendor, Staff  ₹0  Security deposit or future use  Blank Cheque Received  Journal  Client, Bank  ₹0  Security or advance cheque    Why Zero Value Entries Are Important?  Transparency: Keeps a clear record of all movement.  Audit Compliance: Helps during audits to justify stock movement.  Operational Control: Shows how many samples were issued or where goods were placed.  Recording zero-value entries in TallyPrime is straightforward and helps businesses maintain accurate inventory and financial records. Whether you’re dealing with free samples, replacements, or promotional offers, these entries ensure transparency and proper stock management.      

How to Record Zero Value Entries & Blank Cheque Entries in TallyPrime Read More »

Price List and Price Level in TallyPrime: Simplified Guide

Price List is a feature in Tally where you can fix the rate of an item for different groups or occasions.  In business, you may want to sell the same item at different prices to different types of customers like wholesalers, retailers, or regular customers. TallyPrime offers an excellent feature to manage different pricing for various customers, such as Distributors, Wholesalers, Retailers, and others. This is done using Price Lists and Price Levels. With this feature, businesses can streamline their sales process and automatically apply the correct price for each category of customers. Price List: A predefined list of prices for items based on different categories (e.g., distributor price, wholesale price, retail price). Price Level: Categories or groups created for different customer types (e.g., Distributor, Wholesaler, Retailer). When you associate a price level with a customer, TallyPrime automatically applies the corresponding prices during sales transactions.   Why Use Price List and Price Level? Efficient Pricing: Automatically apply the correct price for different customers. Time-Saving: No need to manually calculate or apply discounts for each sale. Error-Free Billing: Reduces the chances of pricing errors in sales invoices. Price Level  For Whom  Wholesale  Wholesalers  Retail  Retailers  Customer  End Customers    Example: Price List for “Smartphone”  Price Level  Item  Rate  Wholesale  Smartphone  ₹12,000  Retail  Smartphone  ₹13,500  Customer  Smartphone  ₹15,000    Enable Multiple Price Level by Pressing F11 Key   Click on Create Create Following Stock Group   Click on Price Level   Create Following Levels   Click on Price List (Stock Group) to Setup Price Fill Information for Distributor Price Level     Fill Information related to Item qty and rate or discount if any   Fill Information for Retailer Price Level Fill Information related to Item qty and rate or discount if any   Fill Information for Whole Saller Price Level Fill Information related to Item qty and rate or discount if any       Sale Stock Item with Distributer Price Level Here You will see the item rate will automatically appear. Gateway Of Tally >> Vouchers >> Sales   Sale Stock Item with Whole Saller Price Level Here You will see the item rate will automatically appear. Gateway Of Tally >> Vouchers >> Sales    

Price List and Price Level in TallyPrime: Simplified Guide Read More »

How to Handle “Buy One Get One Free” Offers or Billing Quantity vs. Actual Quantity in TallyPrime

Promotional offers like “Buy One Get One Free” (BOGO) are common in sales, and managing such transactions in accounting,  there are 3 important concepts to understand: Billing Quantity and Actual Quantity. These help you record sales accurately while ensuring proper stock management. Actual Quantity: This refers to the total physical quantity of the items being delivered or purchased. Billing Quantity: This is the quantity being billed to the customer or vendor. In offers like “Buy One Get One Free,” you may deliver more items than you bill.   Method 1: Use Zero Rate for Free Item  Invoice Entry Example  Item  Quantity  Rate  Amount  Smartphone  1 Nos  ₹15,000  ₹15,000  Smartphone (Free)  1 Nos  ₹0  ₹0  Total      ₹15,000  Steps in Tally:  Go to Accounting Vouchers → Sales (F8)  Select Customer Ledger  Select item Smartphone, Quantity: 1, Rate: ₹15,000  Again, select Smartphone, Quantity: 1, Rate: ₹0  Complete the invoice    Method 2: Show Discount Instead of Free Item (optional)  Instead of adding the free item, give 50% discount on total quantity.  Item  Quantity  Rate  Discount  Amount  Smartphone  2 Nos  ₹15,000  50%  ₹15,000  In this method, you show 2 items but give 50% item-wise discount to match the BOGO offer.  Use this if you want to avoid showing ₹0 value items in inventory reports.    Method 3: Use Actual Quantity & Billed Quantity  In this method, you issue 2 units but bill only 1 unit.  Why is This Important? Using the Billing Quantity and Actual Quantity fields ensures that: Your stock reflects the correct physical movement of goods. Discounts, free items, or offers are recorded properly in the sales or purchase invoices. There is transparency in your invoices, showing what was sold and what was offered for free. BOGO means:  Customer pays for 1 item and gets another 1 free. The free item has no extra cost.  Example: Buy 1 Smartphone @ ₹15,000 and get 1 Smartphone free.  Example:  Actual Quantity = 2 Billed Quantity = 1 Rate = ₹15,000  Item: Laptop  Method  Actual Qty  Billed Qty  Rate  Total  Smartphone  2  1  ₹40,000  ₹40,000    Tally automatically calculates total as 1 × ₹15,000 = ₹15,000  Steps:  Enable this setting:  Gateway of Tally → F11: Features → Inventory Features  Set Use Actual and Billed Quantity to Yes  In Sales Voucher:  Item: Smartphone  Actual Qty: 2  Billed Qty: 1  Rate: ₹15,000  Total = ₹15,000  Free unit is accounted but not charged  This method is cleaner — especially for stock tracking, GST reports, and invoicing.    Step 1 : Enable Actual And Billed QTY , Press F11 Key for Enable Suppurate Quantity And Actual Quantity” Feature.   Step 2 Pass Purchase Entry Here you can see two column in quantity first of Actual and second will billed. So here you need to fill total purchase in actual column and in billed column fill paid quantity which quantity’s amount paid. for example company purchase following item on buy 1 get 1 rate.   Pass Sales Entry Here you can see two column in quantity Column first of Actual and second will billed Column. Here you need to fill total Sales Qty in actual column and in billed column fill quantity which quantity’s amount Receipt.     Assignment: BOGO Sales Entry  Method 1: Free Item with Zero Rate  ➤ In this method, you pass two item lines:  1 item with full rate  1 item with ₹0 rate (free)    Assignment 1.1:  Party: Ravi Traders Date: 01-Apr-2025  Item  Quantity  Rate  Amount  Smartphone  1 Nos  ₹15,000  ₹15,000  Smartphone  1 Nos  ₹0  ₹0  Total      ₹15,000  Tasks:  Create item: Smartphone  Create ledger: Ravi Traders under Sundry Debtors  Enter sale with 1 paid + 1 free smartphone    Assignment 1.2:  Party: Komal Electronics Date: 10-Apr-2025  Item  Quantity  Rate  Amount  Laptop  1 Nos  ₹40,000  ₹40,000  Laptop  1 Nos  ₹0  ₹0  Total      ₹40,000  Tasks:  Create item: Laptop  Create ledger: Komal Electronics under Sundry Debtors  Enter sale with 1 paid + 1 free laptop    Assignment 1.3:  Party: Sagar Tech Store Date: 15-Apr-2025  Item  Quantity  Rate  Amount  Smartphone  2 Nos  ₹15,000  ₹30,000  Smartphone  2 Nos  ₹0  ₹0  Total      ₹30,000  Tasks:  Create item: Smartphone  Create ledger: Sagar Tech Store  Enter sale of 2 paid + 2 free smartphones    Method 3: Actual Quantity & Billed Quantity  ➤ In this method:  Actual Qty = Total items given  Billed Qty = Only the items you charge  Rate applies only to billed qty    Assignment 2.1:  Party: Ankit Digital Mart Date: 01-May-2025  Item  Actual Qty  Billed Qty  Rate  Amount  Laptop  2 Nos  1 Nos  ₹40,000  ₹40,000  Tasks:  Enable Actual & Billed Qty in Inventory Features  Create item: Laptop  Create ledger: Ankit Digital Mart  Enter sale using this method    Assignment 2.2:  Party: Sona Infotech Date: 05-May-2025  Item  Actual Qty  Billed Qty  Rate  Amount  Smartphone  2 Nos  1 Nos  ₹15,000  ₹15,000  Tasks:  Create item: Smartphone  Create ledger: Sona Infotech  Pass entry: 2 units issued, only 1 billed    Assignment 2.3:  Party: Techno Bazaar Date: 10-May-2025  Item  Actual Qty  Billed Qty  Rate  Amount  Laptop  4 Nos  2 Nos  ₹40,000  ₹80,000  Tasks:  Create item: Laptop  Create ledger: Techno Bazaar  Enter sale: 4 laptops issued, 2 billed, total = ₹80,000  Handling promotional offers like “Buy One Get One Free” is easy in TallyPrime with the Billing Quantity and Actual Quantity features. By following the steps in this guide, you can efficiently manage stock, create transparent invoices, and maintain accurate records of your sales offers.

How to Handle “Buy One Get One Free” Offers or Billing Quantity vs. Actual Quantity in TallyPrime Read More »

Multi-Currency in TallyPrime: A Step-by-Step Guide

Multi-Currency means the ability to record transactions in more than one currency (like Rupees, Dollars, Euros).  Managing international transactions is a part of modern business. If you are buying or selling in other countries, you’ll deal with foreign currencies like USD, EUR, etc. Many businesses deal with international clients and vendors, making it essential to manage transactions in multiple currencies. TallyPrime makes this process seamless with its multi-currency feature, allowing businesses to handle transactions, reports, and balances in different currencies. The multi-currency feature in TallyPrime allows you to: Record transactions in different currencies, such as USD, EUR, or GBP. Automatically calculate currency conversions based on exchange rates. Generate financial reports and statements in multiple currencies.   How to Create a New Currency?  👉 Go to Gateway of Tally → Create → Currencies Example: To create USD (US Dollar)  Field  Details  Symbol  $  Formal Name  US Dollar  ISO Code  USD  Decimal Places  2  Suffix Symbol  Yes  Show Amounts In  Millions  Base Currency  No (if not INR)    Click on Create Click on Show More   Create Currencies After enabling the feature, you need to create the currencies you want to use: Go to Gateway of Tally > Create > Currency Fill in the details: Symbol: Enter the currency symbol (e.g., $, €, £). Formal Name: Enter the full name of the currency (e.g., US Dollar, Euro). Decimal Places: Specify the number of decimal places (e.g., 2 for USD). Save the currency by pressing Ctrl + A. Click on Create New Create Your Currency ($ Us Doller), if you are creating first time Set Exchange Rates You need to define exchange rates for currency conversions: Standard Rate  ₹1 = $0.012 (or as per rate)  Selling Rate  ₹1 = $0.0122 (optional)  Buying Rate  ₹1 = $0.0118 (optional)   Go to Gate way Of Tally >> Create >> Rate of Exchange Select the currency for which you want to set the exchange rate. Under Standard Rates, enter the rate for: Buying: If you are purchasing goods in this currency. Selling: If you are selling goods in this currency. Average Rate: For general purposes. Save the changes by pressing Ctrl + A. After Created Currency you will see one more option visible – Rates of Exchange click on it and now fill here the details of rate of exchange after it go to voucher and select sales voucher and make it jut when you enter the rate then enter rate with dollar symbol if you created dollar otherwise what you created select that one Note Here Rate Amount Must Be In That Form Which Currency Created By You ($) – For Example $300   Here check the rate of exchange and other details rate of exchange   here you can see amount reflex in both currency   Now see Purchase Voucher   Example 1: Export Sale in USD  Business: Ankit IT Solutions Customer: John Traders (USA) Currency: US Dollar (USD) Transaction: Sale of Software Services    📦 Details:  Particular  Value  Item  Software Service  Quantity  1  Rate (USD)  $1,000  Total (USD)  $1,000  Exchange Rate  ₹1 = $0.012  Total (INR)  ₹83,333.33  💡 Tally Entry:  Create Customer Ledger in USD  Record sales voucher → Select USD → Enter rate  Tally will convert $1,000 to ₹83,333.33   

Multi-Currency in TallyPrime: A Step-by-Step Guide Read More »

Discount on Purchase / Sales Entries in TallyPrime?

Purchasing items with discounts is a common transaction in business. In TallyPrime, you can enter purchase transactions while applying discounts on individual items. Discount is a reduction in the price of an item or total invoice amount. In TallyPrime, you can apply discounts in several ways: Discount entry in TallyPrime refers to recording purchases/ sales where a discount is applied to items or invoice. Businesses use discounts to attract customers or to get benefits from suppliers.     Types of Discount in TallyPrime  Type of Discount  Applied On  Where to Use  50% Discount  On item rate (percentage)  In the discount column during item entry  Flat Discount  On item or total  Reduce item rate manually or use discount column  Discount on Full Bill  On total invoice amount  Use ledger like “Discount Allowed” after item entry     50% Discount in TallyPrime  % Discount on Rate” means the discount is calculated as a percentage of the item’s rate and subtracted from it before calculating the final amount.  A 50% discount means half the price of a product is deducted before the customer pays. It’s a percentage-based reduction applied on the selling price or MRP.  Example 1: 50% Discount on Rate  Item  Quantity  Rate  Discount  Amount  Smartphone  2 Nos  ₹15,000  50%  ₹15,000    Explanation:  Rate = ₹15,000, Quantity = 2 Total before discount = ₹30,000 50% discount = ₹15,000 Final amount = ₹15,000    Flat Discount ₹50 Per Item  A Flat Discount means a fixed amount is reduced from the total bill or item price — not based on percentage. It is a straight ₹-value deduction, such as ₹50 or ₹500 off, regardless of the original price.  Item  Quantity  Rate  Discount  Amount  Laptop  1 Nos  ₹40,000  ₹50  ₹39,950  Explanation:  Flat ₹50 discount given on one laptop.    ₹50 Total Discount on Full Bill  Discount on Total” (also called Invoice-level Discount or Full Bill Discount) means a fixed amount or a percentage is applied to the entire invoice amount, not on individual items. Item  Quantity  Rate  Discount  Amount  Smartphone  1 Nos  ₹15,000  –  ₹15,000  Laptop  1 Nos  ₹40,000  –  ₹40,000  Flat Discount  –  –  ₹50 (on total)  ₹(50)  Total        ₹54,950  Explanation:  No item-wise discount — instead, ₹50 discount applied to total bill using a Discount Allowed ledger.    How to record Item-wise Discount Purchase / Sales Entry in TallyPrime TallyPrime is a comprehensive accounting tool that makes it easy to handle invoices, manage stock, and track payments. One feature that many users look for is adding a discount column in their invoices. Discounts are an integral part of sales and purchase transactions, and TallyPrime provides an easy way to handle them. How to Enable Item-Wise Discount Column  Go to Gateway of Tally → F11 (Features) → Inventory Features  Set Use Separate Discount Column in Invoices to Yes  Press Ctrl + A to save    Create Part Ledger go to Vouchers     Item-wise Discount  Go to Vouchers → Sales (F8) or Purchase (F9)  Select Party Name  Enter stock items one by one  In the Discount column, enter discount percentage for each item Example: 10%  Purchase Voucher with Discount Column – Item wise Discount Purchase Entry in TallyPrime Sales Voucher with Discount Column – Item wise Discount Purchase Entry in TallyPrime   Invoice-Level (Total) Discount  Create a Discount Ledger:  Go to Accounts Info → Ledgers → Create  Name: Discount  Under: Indirect Expenses (for sales discount) OR Indirect Incomes (for purchase discount)  Type of Ledger: Sales or Purchase  In the invoice, after item entry, add Discount ledger manually  Enter the discount amount directly (like ₹500)    Method 2   Assignments  I. Percentage Discount on Items (Different Rates)  This discount is applied individually on each item in the sales voucher by enabling the discount column.  Assignment 1 – Smartphone with 30% Discount  Item  Qty  Rate  Discount  Final Amount  Smartphone  2 Nos  ₹15,000  30%  ₹21,000  Task:  Enable “Use Separate Discount Column” in F11 (Inventory Features).  In Sales voucher, enter Smartphone (2 Nos @ ₹15,000).  Apply 30% discount, so the total becomes ₹21,000.    Assignment 2 – Laptop with 10% Discount  Item  Qty  Rate  Discount  Final Amount  Laptop  1 Nos  ₹40,000  10%  ₹36,000  Task:  Enter laptop @ ₹40,000.  Apply 10% discount → Final = ₹36,000.    Assignment 3 – Tablet with 20% Discount  Item  Qty  Rate  Discount  Final Amount  Tablet  4 Nos  ₹10,000  20%  ₹32,000  Task:  Record 4 Tablets @ ₹10,000.  Apply 20% off on each → ₹8,000 per unit → Final total = ₹32,000.    2. Flat Discount (Fixed ₹ Value Off)  This discount is applied on the individual item or total invoice by reducing a fixed amount from the original price.  Assignment 1 – Laptop with ₹2,000 Flat Discount  Item  Qty  Rate  Flat Discount  Final Amount  Laptop  1 Nos  ₹40,000  ₹2,000  ₹38,000  Task:  Enter laptop @ ₹40,000.  Apply flat ₹2,000 discount → Final = ₹38,000.    Assignment 2 – Smartphone with ₹1,500 Flat Discount  Item  Qty  Rate  Flat Discount  Final Amount  Smartphone  2 Nos  ₹15,000  ₹1,500  ₹28,500  Task:  Enter smartphone (2 Nos @ ₹15,000).  Apply flat ₹1,500 discount per unit → Final total = ₹28,500.    Assignment 3 – Tablet with ₹500 Flat Discount  Item  Qty  Rate  Flat Discount  Final Amount  Tablet  4 Nos  ₹10,000  ₹500  ₹38,000  Task:  Record 4 Tablets @ ₹10,000.  Apply flat ₹500 discount on each unit → Final total = ₹38,000.    3. Discount on Full Bill (Invoice-level Discount)  This discount is applied to the entire invoice after all items have been entered, providing a fixed discount on the total bill amount.  Assignment 1 – Laptop and Smartphone with ₹2,000 Invoice-Level Discount  Item  Qty  Rate  Total Item Amount  Laptop  1 Nos  ₹40,000  ₹40,000  Smartphone  2 Nos  ₹15,000  ₹30,000  Total      ₹70,000  Invoice Discount      ₹2,000  Final Amount      ₹68,000  Task:  Enter items: Laptop (₹40,000) and Smartphone (₹30,000).  Apply ₹2,000 invoice-level discount after entering the items.  The final amount becomes ₹68,000 after the discount is applied.    Assignment 2 – Tablet and Monitor with ₹1,000 Invoice-Level Discount  Item  Qty  Rate  Total Item Amount  Tablet  3 Nos  ₹10,000  ₹30,000  Monitor 

Discount on Purchase / Sales Entries in TallyPrime? Read More »

Scroll to Top