Latest news with #Excel


Time of India
2 days ago
- Business
- Time of India
Here's why Paytm's five latest product innovations make it the most trusted UPI app
Academy Empower your mind, elevate your skills Paytm (One97 Communications Limited) pioneered mobile payments in India, introducing transformative technologies such as QR codes and Soundbox, which fundamentally changed how millions transact digitally. As a technology-first and most trusted UPI payments platform, Paytm continues to lead the way in innovation, building real-world solutions that enhance daily payment experiences. The company's five latest product innovations reaffirm its position as the best UPI app in India, combining ease of use, top-tier security, and feature-rich design to address the evolving needs of consumers and merchants alike. With a relentless focus on product excellence over pure marketing, Paytm has become the go-to app for secure, fast, and trusted UPI is the only UPI app to introduce the following innovations that simplify payments for freelancers, shopkeepers, students, businesses and households alike:This industry-first privacy feature empowers users to hide or unhide specific UPI transactions from their payments history, giving them greater control over sensitive payments like gifts, personal expenses, or confidential transfers. Hidden payments are removed from 'Balance & History' and moved to a secure 'View Hidden Payments' section, accessible only through user authentication. This keeps records intact without compromising enables downloading UPI transaction statements in PDF and Excel formats, making it easier to track expenses, manage budgets, and maintain financial records. This convenient feature supports personal and business needs by providing clear, downloadable reports for accounting and tax allows creating personalised UPI IDs, enabling secure payments with handles like name@ptyes or name@ptaxis, eliminating the need to share mobile numbers. This enhances privacy while providing a unique and convenient way to transact provides the ability to check the balance of a UPI-linked bank account, as well as view the total balance across all bank accounts linked via UPI handles created on the platform. This offers a consolidated and convenient way to monitor funds without switching between multiple banking introduces the 'Receive Money' QR widget, allowing cab drivers, delivery agents, and freelancers to place their Paytm QR code directly on the smartphone home screen. It enables quick and easy payment collection without opening the app, making transactions faster and more the platform has introduced Auto Top-Up on Paytm UPI Lite, which automatically replenishes the balance from the linked bank account when it runs low. This ensures uninterrupted payments for small, everyday transactions, offering a convenient and seamless cashless experience while keeping bank statements clean and the streamlined, clutter-free interface of Paytm UPI Lite and the ability to use RuPay credit cards on UPI, to the convenience of self-transfer for seamless transactions between multiple bank accounts, Paytm offers a secure, fast, and feature-rich UPI payments cutting-edge innovations reinforce Paytm's position as India's best and most trusted UPI app, committed to making digital payments smarter, safer, and more accessible for everyone. Paytm continues to lead India's transition to a secure and inclusive digital economy.


Geeky Gadgets
2 days ago
- Business
- Geeky Gadgets
New Excel Automation Features : Bulk Send Email, Create PDFs without VBA
Have you ever wished Excel could do more than crunch numbers and organize data? Imagine generating polished PDFs or sending out personalized emails—directly from your spreadsheet—without needing to wrestle with complex VBA scripts or third-party tools. It sounds almost too good to be true, but Microsoft has turned this vision into reality. With the introduction of new features powered by Office Scripts, Excel now offers a seamless way to automate tasks like creating PDFs and sending bulk emails, all while staying within the familiar interface you already know. These updates aren't just incremental improvements—they're a bold leap toward making Excel a true powerhouse for automation and productivity. Excel Off The Grid takes you through how these new features can transform the way you work. From crafting tailored reports in PDF format to delivering visually engaging, dynamic emails, these tools are designed to save time and eliminate tedious manual processes. You'll learn how Office Scripts acts as the backbone of this innovation, allowing you to automate workflows with minimal effort. Whether you're managing large-scale reporting or streamlining communication, these capabilities promise to make your tasks not only faster but smarter. It's a shift that could redefine how you approach your daily work—one that's worth exploring in depth. Excel Automation with Office Scripts Office Scripts: The Core of Automation At the center of this new capability is Office Scripts, a powerful tool accessible through the Automate tab in Excel. Office Scripts allows you to automate complex tasks, such as generating PDFs and sending emails, with minimal technical expertise. To use this feature, you must have a compatible Microsoft 365 license. By integrating Office Scripts into your workflow, you can replace traditional VBA or external tools with a more seamless and efficient solution. This tool is particularly valuable for users seeking to streamline repetitive processes, offering a modern alternative to older methods of automation. Its integration within Excel ensures a smoother experience, eliminating the need for additional software or programming knowledge. Streamlined PDF Creation The ability to create PDFs directly in Excel has been made more intuitive and efficient. Using the `convert to PDF` method in Office Scripts, you can generate PDFs in memory without saving them as files on your device. This approach offers several advantages: Customize your PDFs by selectively including specific worksheets while hiding others, making it ideal for tailored reports. Generate and name multiple PDFs in a single automated workflow, significantly reducing manual effort. This feature is particularly useful for professionals who need to produce customized reports or documents regularly. By automating the process, you can save time and ensure consistency across your outputs. New Excel Automation Features for 2025 Watch this video on YouTube. Discover other guides from our vast content that could be of interest on Excel functions. Enhanced Email Functionality The email-sending capability uses the `send mail` method in Office Scripts, allowing you to send personalized emails to multiple recipients with ease. This feature supports a wide range of options, including: Specifying recipients, CC, and BCC fields for targeted communication. Customizing subject lines and setting importance levels to prioritize messages. Formatting email content using HTML tags, allowing for rich text and embedded images. Attaching files, such as the PDFs generated within Excel, directly to the email. These options make it a powerful tool for professional communication, allowing you to deliver polished, customized messages efficiently. Whether you're sending performance updates, marketing materials, or internal reports, this feature ensures your emails are both professional and impactful. Automating Bulk Tasks with Dynamic Reports One of the most practical applications of these new features is the ability to automate bulk tasks. By using a control table, you can dynamically generate and distribute region-specific reports. This process involves: Defining variables such as region names, recipient email addresses, and specific worksheet data in a control table. Automating the updating of report content, PDF creation, and email distribution—all within a single workflow. This functionality is particularly beneficial for scenarios requiring repetitive, large-scale reporting, such as sales updates, performance summaries, or compliance documentation. By automating these tasks, you can reduce errors, save time, and ensure consistency across all outputs. Dynamic Content and Visual Appeal The integration of HTML formatting within the email functionality allows for the creation of visually engaging messages. This capability is especially useful for embedding dynamic content, such as charts, images, or other visuals, directly into the email body. Key applications include: Sending performance reports with embedded graphs for better data visualization. Delivering marketing materials enriched with visuals to capture attention. Enhancing internal or external communications with graphical elements for clarity and impact. By combining automation with dynamic content, you can ensure your communications are not only informative but also visually appealing, leaving a lasting impression on recipients. Licensing and Future Availability Currently, these features are available exclusively to Excel Insiders, a group of users enrolled in Microsoft's Insider program. To access Office Scripts, you must also have a compatible Microsoft 365 license. Microsoft has announced plans to expand the availability of these features in future updates, making it essential to stay informed about upcoming releases if you are not yet an Insider. For those who qualify, these tools offer a significant opportunity to enhance productivity and streamline workflows. As Microsoft continues to refine and expand these capabilities, they are expected to become a standard feature for all Excel users. Transforming Productivity with Excel The new PDF creation and email-sending features in Excel represent a major step forward in task automation. By using Office Scripts, you can streamline workflows, improve communication, and save valuable time. Whether you're generating customized reports, embedding visuals in emails, or automating repetitive tasks, these tools provide a robust solution for modern Excel users. As Microsoft continues to innovate and expand these capabilities, they are set to become an indispensable part of your productivity toolkit. Media Credit: Excel Off The Grid Filed Under: AI, Guides Latest Geeky Gadgets Deals Disclosure: Some of our articles include affiliate links. If you buy something through one of these links, Geeky Gadgets may earn an affiliate commission. Learn about our Disclosure Policy.
&w=3840&q=100)

Business Standard
2 days ago
- Business
- Business Standard
Offline forms for ITR-2, ITR-3 released: How to use them, documents needed
The Income Tax Department has rolled out Excel-based offline forms ITR-2 and ITR-3 for assessment year (AY) 2025–26 for individuals and Hindu Undivided Families (HUFs) with complex income sources such as capital gains, foreign income, or business and professional earnings. Forms, which are called utilities by the department, for ITR-1 and ITR-4 were released earlier and the latest set was delayed. 'The delay stems from major structural changes to the ITR forms for AY 2025–26. These changes required backend system upgrades, utility reprogramming, and extensive validation,' said Ritika Nayyar, partner at Singhania & Co. Niyati Shah, a chartered accountant and personal tax head at '1 Finance', said 'synchronisation issues' with the Annual Information Statement and Taxpayer Information Summary, as well as efforts to align disclosures with international reporting standards and government circulars delayed the forms. What's new in ITR-2 and ITR-3? Changes in ITR-2 and ITR-3 reflect amendments in the Finance (No. 2) Act, 2024, said Naveen Wadhwa, vice-president at Taxmann. 'The threshold for mandatory reporting of assets and liabilities has been increased from Rs 50 lakh to Rs 1 crore, reducing the compliance burden for many taxpayers,' he said. Capital gains segregation: The new forms require taxpayers to disclose whether an asset transfer triggering capital gains occurred before or after July 23, 2024, as this impacts the applicable tax rates, particularly for property sales. Buyback reporting: Taxpayers can claim capital losses on share buybacks after October 1, 2024, provided related dividend income is reported. Tax deducted at source: A new field requires reporting the specific section under which TDS has been deducted. Expanded disclosures: There are now more granular requirements for deductions (like 80C and 80D), foreign assets, and virtual digital assets. 'These changes simplify filing for some taxpayers but also require more detailed information in certain areas,' Wadhwa added. Who should file ITR-2 and ITR-3? Experts explain ITR-2 is for individuals and HUFs with income from salary, multiple house properties, capital gains, or foreign assets, but not having income from business or profession. ITR-3 is for individuals and HUFs with income from a business or profession, including earnings through presumptive taxation schemes under Section 44AD, 44ADA, and 44AE. Salaried individuals and pensioners should note the expanded requirements. 'The new form asks for a comprehensive breakup of salary components, enabling tax authorities to verify exemption claims more effectively,' Wadhwa said. What is Excel utility? The Excel utility is an offline tool that allows taxpayers to fill in return details without an internet connection. Once complete, it generates a JSON file for upload on the tax department's e-filing portal. How to use the Excel utility -Download ITR-2 or ITR-3 Excel utility from -Enable macros in Excel. -Enter income, deduction, and tax payment details. -Validate the entries using the built-in feature. -Generate JSON file. -Log in to the e-filing portal and upload the .JSON file. Tips for self-filing taxpayers 'Taxpayers filing without professional assistance should gather all documents, Form 16, capital gains statements, and receipts for deductions, before starting,' Wadhwa said. 'Pay attention to distinguishing transactions before and after July 23, 2024, as tax treatments differ. Also, use the raised Rs 1 crore threshold for asset reporting to avoid unnecessary work if eligible.' Deadlines -Last date to file ITR: September 15, 2025 (extended from July 31) for non-audit cases; however, a belated return can be filed by December 31 with penalties and interest. -For businesses that require an audit, the last date of filing is October 31st, 2025. Taxpayers are advised to review the changes carefully to avoid errors and notices.


Mint
2 days ago
- Business
- Mint
Income Tax Filing FY 2024-25: ITR-2 and ITR-3 excel forms now live
The Income Tax Department has released the Excel utilities for ITR-2 and ITR-3 for Assessment Year 2025-26. Thus enabling taxpayers with capital gains, crypto earnings, foreign assets along with business income to begin with the filing of their income tax returns for Financial Year 2024-24. This announcement was made today i.e., on July 11, 2025, through the tax departments official X (formerly Twitter) handle. These offline excel based tools are now open for downloads on the Income Tax e-filing portal. It is crucial to keep in mind that the due date for filing these returns is September 15, 2025. Till now only ITR-1 and ITR-4 were available. This resulted in limiting filings to salaried individuals and small businesses under presumptive taxation. With the release of ITR-2 and ITR-3 utilities, a more enhanced and broader taxpayer base can begin with the process of compliance. The Income Tax Department has introduced several important changes and updates to reflect changes from the Finance Act, 2024: Capital gains bifurcation for asset transfers made before or after July 23, 2024. Loss on share buyback permitted if related dividends are disclosed as 'income from other sources.' Asset & liability reporting threshold raised to ₹ 1 crore (up from ₹ 50 lakh). 1 crore (up from 50 lakh). TDS deduction section code now mandatory in Schedule-TDS. ITR-3 also includes a new reference to Section 44BBC (cruise business). These changes and developments focus on streamlining reporting, improve transparency and reduce filing errors. Especially for high income individuals earning between ₹ 50 lakhs and ₹ 1 crore. ITR-2 is for individuals and HUFs without business income, but with capital gains, clubbed income or foreign assets. ITR-3 on the other hand is for those with income from business or profession, including freelancers, consultants and sole proprietors. Once the Excel utility is filled and validated, taxpayers must generate a JSON file and upload it to the portal. Filing must be verified within 30 days of submission. The online filing mode is expected to be launched soon. The online filing mode of submission is expected to be launched soon. For more information on the do refer to the website of the income tax department. Disclaimer: This article is for informational purposes only and does not constitute legal or tax advice. Taxpayers are advised to consult a qualified tax professional or refer to the official website of the Income Tax Department for accurate and up-to-date guidance before filing their returns.


Time of India
2 days ago
- Business
- Time of India
ITR filing FY 2024-25: ITR-2 and ITR-3 excel utilities released by Income Tax Department - here's what taxpayers should know
ITR filing: For the financial year 2024-25 (Assessment Year 2025-26), taxpayers must file their returns by September 15, 2025. (AI image) ITR filing FY 2024-25: The Income Tax Department has now made available the excel utilities for ITR-2 and ITR-3 forms, enabling individuals with taxable capital gains, crypto income and other specified incomes to file their income tax returns for AY 2025-26. For the financial year 2024-25 (Assessment Year 2025-26), taxpayers must file their returns by September 15, 2025. Earlier, only ITR-1 and ITR-4 were accessible, both online and through excel utility, which allowed only specific categories of taxpayers to file returns. On July 11, 2025, the Income Tax Department announced on X (formerly Twitter): "Attention Taxpayers! Excel Utilities of ITR-2 and ITR-3 for AY 2025-26 are now live and available for filing." What is an Excel Utility in ITR? According to an ET report, an Excel-based ITR utility is a downloadable tool available on the income tax department's e-filing portal, specifically for ITR-2 and ITR-3 forms. Upon downloading, you'll receive a Windows zip file that contains an Excel spreadsheet. The Excel file has multiple schedules and fields where taxpayers can input their financial information and declarations. After completing the required details in the spreadsheet, users need to access the ITR e-filing portal to upload the completed file and submit their Income Tax Return . It's essential to note that the filed ITR must be verified within 30 days of submission. Also Read | ITR filing FY 2024-25: New versus old income tax regime - what helps you save more tax? Check calculations before filing return ITR filing FY 2024-25: What are the changes in ITR-2? The form introduces distinct sections in Schedule-Capital Gain to differentiate gains realised before and after July 23, 2024, following Finance Act, 2024 amendments. For share buybacks after October 1, 2024, capital losses are now permissible when the corresponding dividend income appears under other sources. The requirement for asset and liability disclosure now applies only to those with total income exceeding Rs 1 crore. Additional reporting requirements have been implemented for various deductions, including sections 80C and 10(13A). The Schedule-TDS now requires specific mention of TDS section codes for better tracking. Aseem Mowar, Tax Partner, EY India told ET, "The new ITR-2 form simplifies filing for taxpayers earning between Rs 50 lakh and Rs 1 crore by removing the need to report assets and liabilities. Additionally, the form now mandates specifying the section under which TDS has been deducted, enhancing transparency. Furthermore, the reporting of capital gains has been refined, requiring taxpayers to indicate whether asset transfers occurred before or after July 23, 2024, ensuring accurate tax rate application. Overall, the new ITR-2 Form streamlines the reporting requirements and may help reduce return processing errors/defects." Also Read | ITR filing FY 2024-25: Why filing Income Tax Return is important even if you have no tax to pay - explained ITR filing FY 2024-25: What's new in ITR-3? The form includes a revised Schedule-Capital Gain, segregating gains before and after July 23, 2024, following Finance Act 2024 amendments. For share buybacks post October 1, 2024, capital losses are now permissible when corresponding dividend income appears under other sources. The reporting threshold for assets and liabilities has been elevated to ₹1 crore of total income. Additionally, section 44BBC pertaining to cruise business has been incorporated. The updates also feature enhanced reporting requirements for various deductions including 80C and 10(13A). The Schedule-TDS now requires specific TDS section code reporting. Chartered Accountant Gopal Bohra, Partner, Direct Tax, N. A. Shah Associates LLP told ET: "The significant change in ITR-3 is the increased threshold monetary limit of total income from Rs 50 lakh to Rs 1 crore to report the Asset & Liabilities under "Schedule AL" of ITR. Now, individual taxpayers will be required to furnish the details of specified Assets & Liabilities in Schedule AL only if total income for the FY 2024-25 (AY 2025-26) exceeds Rs 1 crore and this move will make tax filing simpler for such an additional number of taxpayers whose total income is in the range of Rs 50 lakh to 1 crore. " Also Read | Income Tax Return: What is Form 16? Top things taxpayers should check in this document before filing ITR Stay informed with the latest business news, updates on bank holidays and public holidays . AI Masterclass for Students. Upskill Young Ones Today!– Join Now