<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Sudeshna Bhattacharya on Medium]]></title>
        <description><![CDATA[Stories by Sudeshna Bhattacharya on Medium]]></description>
        <link>https://medium.com/@sudeshnabhattacharya?source=rss-5c75567e4aa3------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*H4hOsuLKtXp0vvcj2DeJaA@2x.jpeg</url>
            <title>Stories by Sudeshna Bhattacharya on Medium</title>
            <link>https://medium.com/@sudeshnabhattacharya?source=rss-5c75567e4aa3------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 22:41:19 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@sudeshnabhattacharya/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[How Automation is Transforming Everyday Finance Work]]></title>
            <link>https://medium.com/@sudeshnabhattacharya/how-automation-is-transforming-everyday-finance-work-8ff349460cce?source=rss-5c75567e4aa3------2</link>
            <guid isPermaLink="false">https://medium.com/p/8ff349460cce</guid>
            <category><![CDATA[coding]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[finance]]></category>
            <category><![CDATA[excel]]></category>
            <dc:creator><![CDATA[Sudeshna Bhattacharya]]></dc:creator>
            <pubDate>Tue, 10 Mar 2026 03:31:00 GMT</pubDate>
            <atom:updated>2026-03-10T03:31:00.942Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>How Automation is Transforming Everyday Finance Work</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2B-RVsCrVPWUHnVSL0E2-Q.png" /></figure><p>Automation has quietly become the backbone of modern organizations. From small repetitive tasks to large data-driven processes, automation is helping teams save time, reduce manual effort, and improve accuracy.</p><p>Broadly speaking, automation tools fall into two categories:</p><ol><li><strong>Open-source automation tools</strong> that require basic programming knowledge.</li><li><strong>Low-code or no-code workflow tools</strong> that allow users to automate processes with minimal technical expertise.</li></ol><p>One of the biggest advantages of open-source automation tools is cost — they are <strong>free to use</strong>. With only a basic understanding of programming, any one can build powerful solutions that dramatically improve productivity.</p><p>Among programming languages, <strong>Python has emerged as the most widely used language for automation. </strong>It is easy to learn, highly versatile, and supported by a massive ecosystem of libraries. Whether the automation need is small-scale or enterprise-level, Python handles it well.</p><h3>Automation Use Cases in Finance</h3><p>Having worked in the Finance domain for over 10 years, I’ve seen countless processes that traditionally took <strong>2–4 days of manual effort</strong> being completed <strong>in just a few minutes through automation</strong>.</p><p>Here are some of the most common and impactful use cases.</p><h3>1. Data Consolidation and Transformation</h3><p>Finance teams often receive data from multiple sources in different formats. Automation can consolidate these datasets, transform them into a standardized structure, and generate clean output files automatically.</p><p>What used to take hours of manual copy-pasting and formatting can now be done instantly.</p><h3>2. Approval Workflow Matrix Tracking</h3><p>Approval matrices in organizations frequently change based on <strong>designation levels, approval thresholds, or organizational restructuring</strong>.</p><p>Automation can compare current and previous versions of approval matrices and quickly highlight:</p><ul><li>Entries present only in the current month</li><li>Entries present only in the previous month</li><li>Entries that remain unchanged in both files</li></ul><h3>3. Automated Pivot Creation for Large Datasets</h3><p>Finance professionals often work with large weekly or monthly datasets. Creating multiple pivot tables manually for analysis can be time-consuming.</p><p>Automation allows users to generate <strong>multiple pivots instantly</strong>, enabling faster analysis of trends, variances, and performance metrics.</p><h3>4. Splitting Large Datasets into Multiple Files</h3><p>Another common requirement is creating <strong>multiple output files from a single dataset</strong> based on different parameters. Instead of manually filtering and saving dozens of files, automation can generate all required files in seconds.</p><h3>5. Email Automation and API Integration</h3><p>Automation can also integrate with email systems to send reports automatically. This eliminates repetitive manual communication tasks.</p><p>For example:</p><ul><li>Attach files from a specific folder</li><li>Send emails to predefined stakeholder groups</li></ul><h3>The Common Thread: Excel</h3><p>Across all these automation scenarios, one tool appears consistently — <strong>Excel</strong>.</p><p>In finance, professionals interact with many systems, but Excel remains the most widely used tool for data handling and reporting. As a result, most automation initiatives in finance revolve around <strong>improving Excel-based workflows</strong>.</p><p>Whether it’s data transformation, reporting, reconciliation, or analysis, automating excel can unlock enormous productivity gains.</p><h3>Final Thoughts</h3><p>Automation doesn’t always require complex systems or expensive tools. Sometimes, a simple script can eliminate hours of repetitive work.</p><p>The key is to identify <strong>repeatable processes</strong> and gradually start automating them.</p><p>Once you begin, you’ll realize that tasks that used to take days can often be reduced to <strong>just a few minutes</strong>.</p><p>And that’s where the real power of automation lies.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8ff349460cce" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>