Ankit IT Solutions – Training Institute

Welcome To Ankit IT Solutions!

TallyPrime Course

CGST- SGST Purchase Entry

Local purchase / sales is the movement of Goods and service within the state that is intra – state is called local purchase / sales. Step 1 Press F11 From You Computer Key For Enable It.   Step 2 :- Fill GST Details, Here You Have To Fill You Company GST Details Such As : GST No, State Note :- Set / Alter GST Rate Details Yes   Step 3 :- Create Following Ledger   CGST Ledger Creation   SGST Ledger Creation   Step 4 Create Stock Item   GST details for Stock Item   Step 5 Purchase Voucher   Assignment  

CGST- SGST Purchase Entry Read More »

TCS – On Sale

TCS Full Form Is Tax Collected at Source, TCS is tax that is payable by the seller, which is collected from the buyer. In This Post You Will Learn “How To Record TCS Tax Transaction In Tally Prime Step By Step Guide. TCS Rate and Section 206C of the Income Tax Act Mention? Section 206C of the Income Tax Act, 1961 covers goods on which sellers must collect TCS (Tax Collected at Source) from their purchaser. However, it is only applicable for specified goods. It includes scrap, alcohol for human consumption, forest produce, minerals like coal and iron ore, timber, and tendu leaves. Step 1 Enable TCS In Tally Prime By Press F11 Key   Step 2 Set TCS Details As  Enable Tax Deducted At Source (TDS), Here Fill These Details Like This Tan No: PDES03028F Tax Deduction and Collection A/c No: ABCD12345E Deductor Type: Company   Step 3. Create “TCS Nature Of Goods Scrap Gateway Of Tally >> Create >> TCS Nature Of Goods >> Create   Step 4. Create Following Ledger Gateway Of Tally >> Create >> Ledger 1. Shubham Pvt Ltd Under Sundry Debtor 2. TCS On Sale Under Duties and Taxes 3. Sales A/c Under Sales Account 1. Shubham Pvt Ltd Under Sundry Debtor 2. TCS On Sale Under Duties and Taxes 3. Sales Ledger Creation Sales A/c Step 5. Pass Sales Voucher Gateway Of Tally >> Vouchers >> Sales

TCS – On Sale Read More »

TCS Tax on Purchase in Tally Prime

TCS Full Form Is Tax Collected at Source, TCS is tax that is payable by the seller, which is collected from the buyer. In This Post You Will Learn “How To Record TCS Tax Transaction In Tally Prime Step By Step Guide. TCS Rate and Section 206C of the Income Tax Act Mention? Section 206C of the Income Tax Act, 1961 covers goods on which sellers must collect TCS (Tax Collected at Source) from their purchaser. However, it is only applicable for specified goods. It includes scrap, alcohol for human consumption, forest produce, minerals like coal and iron ore, timber, and tendu leaves.   Step 1 Enable TCS In Tally Prime By Press F11 Key   Step 2 Set TCS Details As  Enable Tax Deducted At Source (TDS), Here Fill These Details Like This Tan No: PDES03028F Tax Deduction and Collection A/c No: ABCD12345E Deductor Type: Company   Step 3 Alter Current Assets Group Gateway of Tally > Alter > Voucher Type > Current Assets Use for calculation (Tax , Discount): Yes   Step 4 Create Following Ledger Gateway Of Tally >> Create >> Ledger 1. TCS On Purchase Under Current Assets 2. SKB PVT Ltd Under Sundry Creditor 3. Purchase A/c Under Purchase Account   1. TCS On Purchase Under Current Assets Percentage of Calculation : 3% Method of Calculation: On Total Sale   Step 5 Now Pass Purchase Voucher Like this Include TCS On Purchase Ledger Gateway Of Tally >> Vouchers >> Purchase      

TCS Tax on Purchase in Tally Prime Read More »

TDS – Tax Deduction at Source

TDS stands for Tax Deducted at Source. It is one of the most important concepts in accounting, taxation, and finance. TDS means deducting tax before making payment to someone. It is collected by the payer (also called deductor) and paid to the Income Tax Department on behalf of the payee (person receiving the income).   Example: You hired a consultant and you have to pay ₹50,000 for their services. According to tax law, you need to deduct 10% TDS (₹5,000) before paying them. You pay ₹45,000 to the consultant. You deposit ₹5,000 with the government as TDS. This way, tax is collected in advance and reported to the government.   Types of TDS Here are some of the income sources that qualify for TDS: Salary Amount under LIC Bank Interest Brokerage or Commission Commission payments Compensation on acquiring immovable property Contractor payments Deemed Dividend Insurance Commission Interest apart from interest on securities Interest on securities Payment of rent Remuneration paid to the director of a company, etc Transfer of immovable property Winning from games like a crossword puzzle, card, lottery, etc.   Basic Concepts of TDS Deductor and Deductee Deductor: Person who deducts TDS (payer) Deductee: Person who receives payment (payee) TAN (Tax Deduction Account Number) – A 10-digit number required by anyone who deducts TDS. It is mandatory for filing TDS returns. PAN (Permanent Account Number) – The deductee must provide PAN; otherwise, TDS is deducted at a higher rate (usually 20%). Threshold Limit – If the total payment during the year is below a certain limit, TDS is not applicable. Each type of payment has a different threshold. Common Sections of TDS Section Nature of Payment Rate of TDS Threshold Limit 192 Salary Slab-based As per salary 194C Contractor Payments 1%/2% ₹30,000 per bill 194J Professional Fees 10% ₹30,000 per year 194I Rent 10% ₹2,40,000 per year 194H Commission/Brokerage 5% ₹15,000 per year How TDS Works Check if TDS is applicable – Look at the type of payment and the amount. Deduct TDS – Calculate and deduct TDS at the correct rate. Pay TDS to the Government – Use Challan ITNS 281 to deposit TDS. File TDS Returns – Every quarter, the deductor must file TDS return (Form 26Q or 24Q). Issue TDS Certificate – Give Form 16 or Form 16A to the deductee.   TDS on Salary (Section 192) – FY 2025–26 TDS on salary is not fixed like other sections (e.g., 10%, 1%, etc.). Instead, it is calculated based on the applicable income tax slab rates of the individual employee for the financial year. Applicable Slab Rates – FY 2025–26 (For Individuals Below 60 Years) Old Regime (with deductions like 80C, HRA, etc.) Income Slab Tax Rate Up to ₹2,50,000 Nil ₹2,50,001 – ₹5,00,000 5% ₹5,00,001 – ₹10,00,000 20% Above ₹10,00,000 30% New Regime (without most deductions but lower rates) Income Slab Tax Rate Up to ₹3,00,000 Nil ₹3,00,001 – ₹6,00,000 5% ₹6,00,001 – ₹9,00,000 10% ₹9,00,001 – ₹12,00,000 15% ₹12,00,001 – ₹15,00,000 20% Above ₹15,00,000 30% Employees can choose between the old and new tax regime each year (by declaration to the employer). How TDS on Salary is Calculated? TDS under Section 192 is calculated as: TDS = Total Income Tax Liability (as per slab) / Number of months of employment It also considers: Deductions claimed (if under old regime) HRA, Standard Deduction, Investments Previous employer income (if applicable) Rebate under Section 87A (if total income ≤ ₹5 lakh under old regime or ≤ ₹7 lakh under new regime) Example: Employee annual salary: ₹6,50,000 Tax regime: New Standard deduction: ₹50,000 Taxable income = ₹6,00,000 Tax = 5% on ₹3,00,000 = ₹15,000 Rebate under 87A = ₹15,000 So, TDS = Nil   Due Dates for E-Filing of TDS Return AY 2023-24   Who Is Required To Deduct TDS? TDS applies in the following scenarios: Professional service fees Fees for technical services Remuneration is paid to directors that do not come under ‘salary.’ Royalty Payments in the form of non-compete fees or fees paid to not share any technical expertise.   What are ‘Professional’ and ‘Technical’ Services? Professional services under Section 194J imply any service in the following fields: • Medical • Legal • Engineering • Architectural profession • Accountancy • Technical consultancy, or • Interior decoration   Professional services mentioned in section 44AA: • Film artist • Authorised representative • Company Secretary   Professional services related to sports activities: • Anchors • Commentators • Event managers • Physiotherapists • Referees and umpires • Sports persons • Sports columnists • Trainers and coaches   Filing TDS Returns TDS must be deposited with the government and a quarterly TDS return on form 26Q must be made.   Simple Assignments with Solutions   Assignment 1: Calculate TDS You paid a contractor ₹1,20,000 during the year. TDS rate is 1%. Calculate how much TDS to deduct and journal entry. Answer: TDS = 1% of ₹1,20,000 = ₹1,200 Net Payment = ₹1,18,800 Journal Entry: Contract Expense A/c Dr. ₹1,20,000 To TDS Payable A/c ₹1,200 To Bank A/c ₹1,18,800   Assignment 2: No TDS Scenario You paid ₹20,000 as rent to a landlord. TDS is applicable only if total rent exceeds ₹2,40,000 in a year. Should you deduct TDS? Answer:No. Since annual payment is below ₹2,40,000, TDS is not applicable. Assignment 3: TDS with No PAN You paid ₹40,000 to a professional who did not provide PAN. What is the TDS rate? Answer:As per Section 206AA, if PAN is not available, TDS is deducted at 20%. TDS = 20% of ₹40,000 = ₹8,000 Net payment = ₹32,000

TDS – Tax Deduction at Source Read More »

What is GST & Types Of GST?

  The GST is “Goods and Services Tax” a comprehensive, multi-stage, destination-based tax that is levied on every value addition. It is designed to replace various indirect taxes like VAT, excise duty, service tax, and others. It is an indirect type of tax, which has to be paid on buying goods or service and the buyer has to pay this tax, this tax is received by the state government and the central government. GST tax has been implemented in India from 1st July 2017. And GST is a completely online tax system. Before 2017, by removing many types of indirect type taxes like “Excise Duty, Vat, Entry Tax, Service Tax” etc. in India, a tax named GST has been brought in their place.   What is GST Number? Whichever person or company or institute gets its registration done under GST, it is given a REGISTRATION number and you can call it GST registration number or GST number if you want. This GST number is made up of total 15 digits and 10 digits of the PAN card of the person or organization who has applied for the GST number are also added to it. For example: 22AAAA0000A1Z5   Types Of GST CGST (central goods and service Tax): – Its collected by the central government on a local State sale (intra – state sale) (example: – within Maharashtra) SGST / UTGST (state goods and service Tax): – Its collected by the state government on a local State sale (intra – state sale) (example: – within Maharashtra) IGST (integrated goods and service tax): – Its collected by the central government for inter – state sale (example: – Maharashtra to Gujrat)   Types of Sales Tax When we talk about sales tax in the context of GST, it can be divided into two types: local sales tax and interstate sales tax. 1. Local Sales Tax (CGST – SGST) Local sales tax refers to sales that happen within the same state, meaning both the production and the sale of the product occur in the same state. For example, if a product is made in Maharashtra and sold in Maharashtra, it is considered a local sale. In this case, CGST and SGST need to be paid. CGST (Central Goods and Service Tax): This tax is collected by the central government for sales within the same state (e.g., sales in Maharashtra). SGST (State Goods and Service Tax): This tax is collected by the state government for sales within the same state (e.g., sales in Maharashtra). 2. Interstate Sales Tax (IGST) Interstate sales tax applies when a sale takes place between two different states. For example, if a product is made in Maharashtra and sold in Gujarat, this is an interstate sale. In such cases, IGST needs to be paid. IGST (Integrated Goods and Service Tax): This tax is collected by the central government for sales between different states (e.g., from Maharashtra to Gujarat).   Understanding GST Registration A business is required to register for GST if its aggregate turnover exceeds a specified threshold limit. However, even if the turnover is below the threshold, certain businesses may still need to register, such as e-commerce businesses or those involved in interstate supply. Who Must Register for GST? Businesses with a turnover exceeding ₹40 Lakhs (₹20 Lakhs for special category states like Jammu & Kashmir, Himachal Pradesh, etc.) Service providers with a turnover exceeding ₹20 Lakhs (₹10 Lakhs for special category states) E-commerce operators Casual taxable persons (e.g., a temporary business at a trade fair)   GST Tax Structure GST applies at different rates, which are designed to suit the nature of the goods and services. The rates are: 5%: Essential items such as spices, tea, etc. 12%: Processed foods, mobile phones. 18%: Services, restaurants (without input tax credit). 28%: Luxury goods such as cars, high-end electronics. Additionally, some goods and services are exempt from GST, such as basic food items, education services, and healthcare services. All Indian states and Union Territories with their respective codes (as per GST), capitals, and other relevant details: ascending order based on State Code (GST Code): State Code (GST Code) State/Union Territory Name Type Capital 01 Andhra Pradesh State Amaravati 01 Jammu & Kashmir Union Territory Srinagar 02 Arunachal Pradesh State Itanagar 02 Himachal Pradesh State Shimla 03 Assam State Dispur 03 Punjab State Chandigarh 04 Chandigarh Union Territory Chandigarh 05 Uttarakhand State Dehradun 06 Haryana State Chandigarh 07 Delhi Union Territory New Delhi 08 Rajasthan State Jaipur 09 Uttar Pradesh State Lucknow 10 Bihar State Patna 11 Sikkim State Gangtok 13 Nagaland State Kohima 14 Manipur State Imphal 15 Mizoram State Aizawl 16 Tripura State Agartala 17 Meghalaya State Shillong 19 West Bengal State Kolkata 20 Jharkhand State Ranchi 21 Odisha State Bhubaneswar 22 Chhattisgarh State Raipur 23 Madhya Pradesh State Bhopal 24 Gujarat State Gandhinagar 26 Dadra and Nagar Haveli and Daman and Diu Union Territory Daman 27 Maharashtra State Mumbai 29 Karnataka State Bengaluru 30 Goa State Panaji 31 Lakshadweep Union Territory Kavaratti 32 Kerala State Thiruvananthapuram 33 Tamil Nadu State Chennai 34 Puducherry Union Territory Puducherry 35 Andaman and Nicobar Islands Union Territory Port Blair 36 Telangana State Hyderabad 38 Ladakh Union Territory Leh 39 Arunachal Pradesh State Itanagar Explanation of Columns: State Code (GST Code): The GST code is a unique two-digit code used for GST-related purposes. State/Union Territory Name: The name of the Indian state or Union Territory. Type: Specifies whether it’s a State or Union Territory. Capital: The capital city of the respective state or Union Territory.

What is GST & Types Of GST? Read More »

How to Print TallyPrime Report or Invoice

Printing invoices and reports in TallyPrime is quick and easy once you know the steps. Whether you need a hard copy for records or a PDF for sharing, TallyPrime provides flexible options to print your reports or invoices effortlessly. TallyPrime is a powerful accounting software widely used by businesses to manage their accounts, invoices, and reports. Open TallyPrime Make sure TallyPrime is installed on your computer and open the software. Select the company for which you want to print reports or invoices. Open your report which you want  to print   Open the Print Preview Once you have selected the invoice or report, follow these steps: Press Alt + P / CTRL + P on your keyboard to open the Print Menu. Select Preview to check how the printout will look before printing.   Adjust Print Settings (Optional) You can customize the print settings before printing: Printer Selection – Choose the printer you want to use. Number of Copies – Select how many copies you need. Paper Size & Orientation – Adjust according to your printer settings. Format Options – Customize details to include in the printout. Black & White / Color – Select printout color.   Print the Invoice or Report After confirming the preview, press Enter or select Print. Your invoice or report will be sent to the selected printer. Bonus: Printing to PDF If you want to save the report as a PDF instead of printing it on paper: In the print menu, choose Microsoft Print to PDF (or any PDF printer installed). Click Print and select where to save the PDF file. The report will be saved on your computer for digital use or sharing.

How to Print TallyPrime Report or Invoice Read More »

How to Export and Import Data in TallyPrime

In TallyPrime, the Export and Import Data feature allows you to transfer your financial data between different systems, create backups, or share information with clients and vendors. This functionality is particularly useful for managing data across multiple branches, transferring data between different accounting systems, or even moving data between different versions of TallyPrime. Export: Exporting data in TallyPrime means transferring your accounting data from TallyPrime to an external file (such as Excel, XML, or CSV) so that it can be used in another system or for backup purposes. Import: Importing data means bringing data from an external file (such as Excel, XML, or CSV) into TallyPrime. This is often used for updating or restoring data from another system or another company file. How to Export Data From Tally Prime? 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 Import Masters Data in New Company? Create New Company (New Data) Press Alt + O Import Masters (Only Tally XML format is supported) File Path : File to import : Master.xml Behavior of import if master already exists: Select as per your requirement Combine opening balance Ignore duplicate Modify with new data Press Enter to import the data Check the ledgers and imported data in Gate way of Tally > charts of Accounts   How to  Protect Company data with Password? Alt+F3 : Company > Alter Company > F12 > configure > Use user access control : Yes Security Control user Access to Company data : Yes User Name: abd Password: 123 Confirm Password : 123 Enable Tally Audit: Yes Accept: Yes F3: Company: Shut Company Reopen with username and password.   How to Remove Password from the Company? F3: Company > Alter Company Control user access to company data :No Current /Existing password: 123 Accept: Yes F3: Company: Shut Company Reopen the Company (username and password is not required)   Exporting and importing data in TallyPrime is an incredibly useful feature that allows businesses to manage their financial data more efficiently. Whether you are backing up data, transferring it between systems, or sharing it with clients, the process is simple and secure.  

How to Export and Import Data in TallyPrime Read More »

How to Split a Company in TallyPrime: A Simple Step-by-Step Guide

The Split Company means divide your existing company into two or more separate companies, preserving the financial data and transactions. When you split a company, TallyPrime ensures the transactions are properly carried over, and you can continue with the new company files separately. TallyPrime offers a simple and efficient feature called “Split Company” to help you manage this process. Businesses can face situations where they need to divide their company into two or more entities for various reasons such as mergers, acquisitions, or separating divisions. Split Company Data Gateway of Tally > Alt + Y (Data) > Split > Split Data, to open the Split Company Data screen. Gateway of Tally > Alt + Y (Data) > Split > Split Data,   Select the required company from the List of Companies. Enter the required date in the Split from field, and press Enter to proceed. Splitting a company in TallyPrime is a straightforward process that helps businesses efficiently manage their operations when restructuring or dividing into multiple entities. By following the simple steps in this guide, you can ensure that the process is done correctly, without losing any important data.

How to Split a Company in TallyPrime: A Simple Step-by-Step Guide Read More »

How to Send Emails from TallyPrime: A Simple Step-by-Step Guide

Sending emails directly from TallyPrime saves time and ensures accuracy when sharing important business documents. By using Email Feature, you can quickly set up email functionality and start sending invoices, receipts, and reports with ease. Whether you’re communicating with clients, vendors, or internal stakeholders, this feature streamlines your business processes. TallyPrime’s Email Feature allows you to: Send Invoices, Receipts, and other reports directly via email. Automatically attach documents such as Sales Invoices, Purchase Invoices, and Ledger Reports. Simplify communication and reduce paperwork.   Sending a Invoices via Email in TallyPrime Invoice send to client and you want to send it via email. Open the Any Voucher or Reports   To email the invoice, press Alt + m (or click E-mail). In the email dialog: Enter the email address from – sender email (e.g., ankititsolutions@gmail.com).   Enter the recipient’s email address (e.g., contact@ankititsolutions.com).   In the email dialog: Enter the email address (e.g., client@example.com). Enter the subject (e.g., “Sales Invoice for January 2025”). Add any message (e.g., “Please find attached your sales invoice for the month of January”). Click E-mail The invoice will be sent to your client’s email.   Enter the password  

How to Send Emails from TallyPrime: A Simple Step-by-Step Guide Read More »

Learn Auditing In TallyPrime

Auditing in TallyPrime refers to reviewing and verifying the financial transactions entered in the system to ensure they are correct, accurate, and comply with legal requirements. Auditing is an essential part of any business process and helps in ensuring that financial transactions and reports are accurate, comply with regulations, and meet internal controls. In TallyPrime, auditing features are designed to make the auditing process simple and effective. TallyPrime offers tools that allow auditors to: Review and validate entries. Identify discrepancies or errors in accounts. Conduct internal control checks. Generate audit reports for analysis. Auditing in TallyPrime helps businesses stay compliant with tax regulations and internal policies by identifying any inconsistencies or errors in accounting entries.   Step 1 Go to Statistics Gateway Of Tally >> Display More Report >> Statement Of Account >> Statistics Step 2 Here You Will See Data For Tally Audit Here You Will See All Data Information  Which Entered In That Company Like Here Passed Some Vouchers . Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics Contra Journal Payment Purchase Sales Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> // Select Voucher Or Ledger , Items Or Etc.   Step 3 Tap On Contra Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Contra // Select Months   Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Contra >> April   Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Contra >> April  >> Select Voucher // Tap On Voucher Step 6 Tap On Stock Journal Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Stock Journal   Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Stock Journal >>  Select Month April   Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Stock Journal >> April // Select Voucher   Step 7 Tap On Stock Journal Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Payment   Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Payment  >> Select Month   Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Payment  >> April // Select Voucher   Step 8 Tap On Purchase Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Purchase Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Purchase >> April // Select Month Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Purchase >> April // Select Voucher Step 9 Tap On Sales Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Sales Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Sales >> April // Select Month Gateway Of  Tally  >>  Display More Report  >> Statement Of Account  >> Statistics >> Sales >> April // Select Month //  Select Voucher  

Learn Auditing In TallyPrime Read More »

Scroll to Top