Ankit IT Solutions – Training Institute

Welcome To Ankit IT Solutions!

TallyPrime Course

What is GSTR-1? GSTR1 Return Filing in TallyPrime

GST R1 Return is an important filing under the Goods and Services Tax (GST) system in India. If you are a business owner registered under GST, you must file this return to report your sales (outward supplies) every month or quarter. GSTR 1 is a monthly, or quarterly GST returns filing form that all taxpayers have to file.  It is a document that provides details of outward supplies made by a registered taxpayer. These supplies may include sales, sales returns, exports, and other relevant transactions. GSTR-1 must be filed by the monthly or quarterly  of each cycle to report transactions for the previous month or quarter. Once you file GST R1, the details of your sales are reflected in your buyers’ GST returns (GSTR-2A).   Who Should File GST R1? All registered businesses under GST that sell goods or services must file GST R1. However, the following businesses are exempt: Composition Scheme Dealers (They file GSTR-4 instead) Input Service Distributors (ISD) Non-resident taxable persons Taxpayers who file GST under QRMP (Quarterly Return Monthly Payment) Scheme   Due Dates for Filing GST R1 The due dates for GSTR-1 are based on your aggregate turnover. Businesses having sales up to Rs.5 crore have the option to file quarterly returns under the QRMP scheme. These are due by the 13th of the month following the relevant quarter. On the other hand, taxpayers who have not opted for the QRMP scheme or have a total turnover above Rs.5 crore are required to file the return every month on or before the 11th of the next month. Monthly Filers: 11th of the following month (e.g., July’s return is due by August 11th) Quarterly Filers (under QRMP Scheme): 13th of the month following the quarter (e.g., for April-June, the due date is July 13th)   Late Fees and Penalties The current late fee for GSTR 1 is Rs.50 per day and Rs.20 per day for nil returns after the due date. The original late fee was Rs.200 (Rs.100 as per SGST Act and Rs.100 as per CGST Act). If you fail to file GST R1 on time, you have to pay a late fee: Rs. 50 per day (Rs. 25 CGST + Rs. 25 SGST) for normal taxpayers Rs. 20 per day (Rs. 10 CGST + Rs. 10 SGST) for NIL returns Interest at 18% per annum on the outstanding tax amount   Considerations While Filing GSTR – 1 You need to be a registered taxpayer under GST, and also have a 15-digit PAN-based GSTIN. You need to have detailed invoices with their unique serial numbers. You also need an OTP to verify your registered mobile number with GST.

What is GSTR-1? GSTR1 Return Filing in TallyPrime 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 »

Memorandum Voucher in TallyPrime – A Step-by-Step Guide

A Memorandum (Memo) Voucher in TallyPrime is a non-accounting entry used to record transactions temporarily. As name of  Memorandum Vouchers like this its used for memories, informational or reference purposes. This feature is useful for handling doubtful transactions, provisional expenses, or transactions pending confirmation.  These entries do not impact the books of accounts until they are converted into actual vouchers.   Uses of Memorandum Voucher To record transactions that are not confirmed yet. To temporarily record expenses or incomes. To keep track of pending transactions before making them final. Helps in decision-making before posting actual transactions. Scenario: Let’s say you want to keep a record of an internal meeting expense, but you don’t want this expense to affect your financial accounts because it’s not related to business operations or external transactions.   Create ledger   Go to Vouchers and click on other vouchers   Click on Show Inactive in not showing and then select memorandum voucher   Active it before use   Make voucher   See reports   Exception Reports   Memorandum Register   Select related months to see report   See Transaction   Voucher   Example 1: Goods Sent on Approval   Item: Headphones Customer: Ravi Electronics Qty: 2 units Rate: ₹2,000 Total: ₹4,000 Status: Not sure if sale will happen  Use a Memorandum Voucher to record it temporarily.  Later, if customer confirms, convert it to a Sales Voucher.    Example 2: Office Furniture Taken by Staff  Item: Chair Employee: Mr. Ajay Qty: 1 unit Rate: ₹2,500 Payment Status: He will pay later  Record it using a Memo Voucher as a temporary transaction.    Example 3: Expense Bill Waiting for Approval   Expense: Stationery Bill Amount: ₹800 Vendor: Paper World Manager Approval: Pending  Enter it as a Memo Voucher until manager confirms.    Summary Table  Feature  Memo Voucher  Updates Accounts  ❌ No  Affects Inventory  ❌ No  Can Convert Later  ✅ Yes (into any actual voucher)  Used For  Trial, Approval, Temporary records    Memorandum Vouchers are like “Notebooks” in Tally — they let you jot down things you’re not ready to finalize. They are perfect for internal use, approvals, testing, or reminders.   

Memorandum Voucher in TallyPrime – A Step-by-Step Guide Read More »

Bill By Bill Entry in TallyPrime – A Simple Guide

This ensures better control over receivables and payables, making it easier to manage business finances. “Bill-by-Bill” is a feature in TallyPrime that is primarily used in the context of managing accounts receivable and accounts payable. It allows you to keep track of individual bills or invoices related to specific transactions. Bill-by-Bill Accounting in TallyPrime allows you to track each invoice separately. It helps in:  Knowing which bills are unpaid or partially paid  Managing due dates  Applying payments to specific bills  Calculating interest on overdue bills (if enabled)  It is mainly used for:  Sundry Debtors (Customers)  Sundry Creditors (Suppliers)    How to Enable Bill-by-Bill in TallyPrime  Go to Gateway of Tally → F11 (Features)  Select Accounting Features  Set Maintain Balances Bill-by-Bill to Yes  Press Ctrl + A to save    How to Create a Ledger with Bill-by-Bill  Go to Accounts Info → Ledgers → Create  Name: XYZ Traders  Under: Sundry Debtors or Sundry Creditors  Set Maintain balances bill-by-bill: Yes  Set credit period (e.g., 30 days)  Save    How to Pass a Sales or Purchase Entry (With Bill Reference)  Go to Vouchers → Sales (F8) or Purchase (F9)  Select the party ledger (who has bill-by-bill enabled)  Enter item details  When asked for bill-wise details, select:  New Ref: For new invoice  Against Ref: For payment or adjustment against existing bill  Advance: If receiving money before invoice  Save the voucher    How to Record Payment Against a Bill  Go to Vouchers → Payment (F5) or Receipt (F6)  Select party ledger  When asked for bill-wise allocation, choose Against Ref  Select the outstanding bill you are paying  Save   Bill No. Select payment agst After selected How to View Bill Outstanding Reports  Go to:  Gateway of Tally → Display More Reports → Statement of Accounts → Outstanding → Receivables / Payables  You can see:  Each bill Amount due Payment status Due date   Benefits of Bill-by-Bill Tracking  Feature  Benefit  Track Invoices  Helps in tracking unpaid or due invoices  Payment Matching  Link payments directly to specific bills  Interest Calculation  Works along with interest on overdue bills  Aging Analysis  Helps identify long-pending bills    Assignment 1: Track Receivable from Customer  Party: Ravi Traders (Debtor) Feature: Bill-by-Bill Enabled Credit Period: 30 days    Sales Invoice Details  Date: 01-Apr-2025 Total Amount: ₹25,000  Stock Items Sold:  Item  Quantity  Rate  Amount  Laptop  1 Nos  ₹15,000  ₹15,000  Smartphone  1 Nos  ₹10,000  ₹10,000  Total      ₹25,000  Bill Reference Name: RAVI001    Receipt Details (Partial Payment)  Date: 01-May-2025 Amount Received: ₹15,000  Adjustment: Against RAVI001    Tasks to Perform in TallyPrime  Enable Bill-by-Bill feature in F11 → Accounting Features  Create a Sundry Debtor Ledger named Ravi Traders with 30 days credit period and bill-wise tracking  Create stock items: Laptop, Smartphone  Pass Sales Voucher on 01-Apr-2025 using New Ref: RAVI001  Pass Receipt Voucher on 01-May-2025 for ₹15,000 using Against Ref: RAVI001  View remaining balance ₹10,000 in Receivables Report    Assignment 2: Track Payable to Supplier  Party: ABC Electronics (Creditor) Feature: Bill-by-Bill Enabled Credit Period: 15 days    🧾 Purchase Invoice Details  Date: 01-Jan-2025 Total Amount: ₹40,000    Using Bill-by-Bill entry in TallyPrime helps businesses keep track of invoices, outstanding payments, and receipts efficiently. By enabling Bill-wise details, recording transactions correctly, and tracking dues through reports, businesses can maintain better financial management. Follow these steps to ensure smooth handling of bills in TallyPrime.  

Bill By Bill Entry in TallyPrime – A Simple Guide Read More »

Stock Journal Class (Transfer & Consumption)

Stock journal voucher is used in accounting to record transactions related to the consumption of items within a company and the transfer of items between different locations or branches. 1. Consumption: Purpose: The consumption aspect of this voucher class is used to record the usage or consumption of inventory items within the company for various purposes, such as production, manufacturing, or general usage. Scenario: For example, if a manufacturing company uses raw materials to produce finished goods, they would record the consumption of those raw materials using this voucher class.   2. Stock Transfer: Purpose: The stock transfer aspect is used to record the movement of inventory items from one location or branch of the company to another. This can be within the same company or between different entities within a corporate group. Scenario: For instance, if a retail company has multiple stores and needs to transfer stock from one store to another to meet demand or balance inventory levels, they would use this voucher class to document the transfer. A stock report in TallyPrime provides details of available inventory, helping businesses manage stock efficiently. When dealing with multiple locations, viewing stock reports godown-wise helps in better decision-making.   Click on Display More Reports Click on Inventory Books Click on Godowns / Locations Select you godown / location Report – Main Location Report – Borivali Location Before Transfer here zero stock item are.. Now go to vouchers   Select details from item, rate, location etc.   Select details where item, rate, location etc. After transfer stocks see reports – click on display more reports Click on inventory books Click on Godowns Select Location where items transferred – borivali Report See Report another location from where items transferred – main location Report

Stock Journal Class (Transfer & Consumption) Read More »

How to Display Stock Report Location/Godown Wise in TallyPrime

A stock report in TallyPrime provides details of available inventory, helping businesses manage stock efficiently. When dealing with multiple locations, viewing stock reports godown-wise helps in better decision-making.   Click on Display More Reports Click on Inventory Books Click on Godowns / Locations Select you godown / location Report

How to Display Stock Report Location/Godown Wise in TallyPrime Read More »

Stock group Summary in TallyPrime

In TallyPrime, the “Stock Group Summary” is a report that provides a consolidated view of your inventory items grouped by their respective stock groups. This report helps you assess the overall stock position of different categories or groups of items in your inventory. To generate a Stock Group Summary report in TallyPrime, follow these steps: Open TallyPrime: Launch TallyPrime and open the company for which you want to generate the Stock Group Summary report. Navigate to Reports: From the Gateway of Tally, select “Display More Reports” from the main menu. Access Stock Group Summary: Under “Display More Reports,” you will find a list of reports. Look for “Stock Group Summary” and select it. Click on Display More Reports Click on Inventory Books Click on Stock Group summery Click on you Stock Group Report   The Stock Group Summary report allows you to quickly analyze the inventory position for different categories or groups of items. It provides valuable insights for managing your inventory efficiently, making informed decisions about purchasing, sales, and overall stock management.

Stock group Summary in TallyPrime Read More »

Scroll to Top