How to Customize and Use the “Export to Excel” Feature on Screener.in for Stock Analysis

  1. Financial Data Sourced from Screener
  2. Customizing the Default “Export to Excel” Sheet
  3. Uploading the Customized “Export to Excel” Sheet on Screener.in
  4. Discrepancies in Financial Ratios Across Different Sources
  5. Investor Queries Regarding “Export to Excel”

Screener.in is a top resource for equity investors in the Indian market. It provides key information about companies listed on the BSE and NSE, helping investors analyze stocks effectively.

We have been using Screener.in as a key part of our stock analysis and investment process for many years and continue to be impressed by its powerful tools that simplify an investor’s research. Screener.in is a top resource for equity investors, and one of its most powerful tools is the ‘Export to Excel’ feature. Some of the most valuable features for equity investors include:

  • Stock Screening: Filter stocks based on multiple financial parameters and share these as “Saved Screens.”
  • Comprehensive Company Pages: Access critical company data on a single page, including financial statements (balance sheet, profit & loss, cash flow), quarterly results, corporate announcements, links to annual reports, credit rating reports, and historical stock price movements. A quick scroll provides investors with essential insights for forming an initial opinion on a company.
  • Email Alerts: Receive notifications when new stocks match your “Saved Screens.”
  • Watchlist Updates: Get email alerts for updates on companies in your watchlist.

While all these features are highly beneficial, one standout feature unique to Screener.in is “Export to Excel”, which provides investors with deep analytical capabilities.

The “Export to Excel” feature on Screener.in enables investors to download a company’s financial data into an Excel file for deeper analysis. This allows for greater flexibility in evaluating stocks beyond the platform’s built-in tools.

One of the most powerful aspects of this feature is its customization. Investors can modify the Excel file to suit their preferences by:

  • Creating their own financial ratios.
  • Organizing data in a preferred layout.
  • Uploading the customized Excel file to their Screener.in account.

Once uploaded, every time an investor downloads the “Export to Excel” sheet for any company, the data is automatically formatted in their customized structure—complete with pre-calculated ratios and key metrics.

This ability to instantly access company financials in a personalized format has significantly enhanced our stock analysis. With just a click, we can evaluate critical financial ratios and form an initial view of a company within minutes.

Having used this feature for many years, we consider it an essential part of our research. It has greatly streamlined our stock evaluations and helped us provide valuable insights to our readers.

This article provides detailed explanations on:

  • The financial data included in Screener.in’s “Export to Excel” file and how it reconciles with a company’s annual report.
  • Step-by-step guidance for investors to customize the “Export to Excel” template.
  • Instructions on uploading a customized Excel file to Screener.in, ensuring that future downloads automatically reflect the investor’s preferred format.

Financial Data Provided by Screener

The “Export to Excel” file on Screener.in includes a “Data Sheet” that contains a company’s financial data, which is then used to calculate ratios and perform in-depth analysis.

As mentioned by Ayush and Pratyush in the Moneylife session, Screener.in sources its financial data from Capitaline, a well-known provider of financial information in India.

The Data Sheet includes key financial details such as:

  • Balance Sheet
  • Profit & Loss Statement
  • Quarterly Results
  • Cash Flow Statement

This structured dataset enables investors to analyze company performance efficiently.

We have taken the example of KNR Constructions Limited (FY2024: standalone financials) to illustrate the reconciliation of data provided by Screener.in in its “Export to Excel” file with the data presented in the company’s annual report.

Investors can read our detailed analysis of KNR Constructions Limited in the following article: Analysis: KNR Constructions Limited.

Now, let’s explore how Screener.in presents financial data for any company.

Balance Sheet:

This section often raises the most investor queries, as Screener.in organizes annual report items differently when presenting financial data.

Let’s understand how the Balance Sheet data is structured in the “Data Sheet” of the “Export to Excel” file, using the FY2024 financials of KNR Constructions Limited as an example.

Balance Sheet Screener.in “Data Sheet”

Balance Sheet (Annual Report FY2024)

Annual report Balancesheet

Balance Sheet of KNR Constructions Limited as of March 31, 2024

EQUITY & LIABILITIES

1) Equity
  • Equity Share Capital: ₹5,624.70 lakh
  • Other Equity: ₹3,16,941.21 lakh

Total Equity: ₹3,22,565.91 lakh


2) Liabilities
A) Non-current Liabilities
  • Financial Liabilities (Lease Liability): ₹421.65 lakh
  • Provisions: ₹663.23 lakh
  • Other Non-current Liabilities: ₹1,071.60 lakh

Total Non-current Liabilities: ₹2,156.48 lakh


B) Current Liabilities
  • Financial Liabilities
    • Borrowings: ₹17.00 lakh
    • Trade Payables:
      • Dues to Micro & Small Enterprises: ₹140.00 lakh
      • Dues to Other than Micro & Small Enterprises: ₹27,732.47 lakh
    • Other Financial Liabilities: ₹1,05,363.84 lakh
  • Provisions: ₹2,799.67 lakh
  • Other Current Liabilities: ₹1,88,792.51 lakh
  • Current Tax Liability (Net): ₹1,888.83 lakh

Total Current Liabilities: ₹99,052.33 lakh
Total Equity & Liabilities: ₹4,23,774.72 lakh


ASSETS

1) Current Assets
  • Inventories: ₹22,072.06 lakh
Financial Assets
  • Trade Receivables: ₹1,36,421.53 lakh
  • Cash & Cash Equivalents: ₹21,652.84 lakh
  • Bank Balances (other than above): ₹8,816.94 lakh
  • Loans: ₹184.48 lakh
  • Other Financial Assets: ₹88,453.49 lakh
Other Current Assets
  • Other Current Assets: ₹7,234.72 lakh

Total Current Assets: ₹2,85,841.00 lakh


2) Non-current Assets
  • Property, Plant, and Equipment: ₹36,597.05 lakh
  • Capital Work-in-Progress: ₹218.43 lakh
  • Right of Use Asset: ₹355.32 lakh
  • Investment Property: ₹6,634.77 lakh
  • Other Intangible Assets: ₹4.38 lakh
Financial Assets
  • Investments: ₹35,020.71 lakh
  • Other Investments: ₹31,171.16 lakh
  • Trade Receivables: ₹4,172.00 lakh
  • Loans: ₹74.95 lakh
  • Other Financial Assets: ₹13,645.51 lakh
Other Non-current Assets
  • Deferred Tax Assets (Net): ₹13,674.51 lakh
  • Non-current Tax Assets (Net): ₹2,614.43 lakh
  • Other Non-current Assets: ₹131.47 lakh

Total Non-current Assets: ₹1,37,933.72 lakh
Total Assets: ₹4,23,774.72 lakh

It is important to note that certain additional items, if present in the balance sheet, are usually shown by screener.in as part of “Other Liabilities” or “Other Assets” depending upon their nature (Liability/Assets). E.g. “Money Received Against Share Warrants” is shown as a part of “Other Liabilities” in the “Data Sheet” in the “Export to Excel” file.

Profit and Loss Statement

Now, let’s analyze the reconciliation of the profit and loss data presented in the company’s annual report with the data provided by Screener.in in the “Data Sheet” of the “Export to Excel” feature.

screener-export-excel-customization.png".

Profit and Loss Statement Annual report FY2024

Annual report profit and loss account

Income Statement Breakdown

  1. Revenue from Operations:
    • ₹4,09,097.84 lakhs (FY24) vs. ₹3,74,379.62 lakhs (FY23)
    • The company witnessed a revenue growth of approximately 9.3% YoY, indicating strong operational performance.
  2. Other Income:
    • ₹14,216.90 lakhs (FY24) vs. ₹3,208.72 lakhs (FY23)
    • Other income has increased significantly (over 4x), possibly due to interest income, asset sales, or government incentives.
  3. Total Income (I + II):
    • ₹4,23,314.74 lakhs (FY24) vs. ₹3,77,588.34 lakhs (FY23)
    • The total income grew by approximately 12.1% YoY.

Expenses Breakdown

  1. Cost of Materials Consumed:
    • ₹1,66,015.31 lakhs (FY24) vs. ₹1,49,474.47 lakhs (FY23)
    • Increase in material costs aligns with revenue growth, indicating consistent material procurement and execution of projects.
  2. Construction Expenses:
    • ₹1,36,770.43 lakhs (FY24) vs. ₹1,28,819.96 lakhs (FY23)
    • A moderate rise, showing that project execution remains in line with past trends.
  3. Employee Benefit Expenses:
    • ₹17,354.77 lakhs (FY24) vs. ₹17,099.95 lakhs (FY23)
    • Slight increase due to potential salary increments and workforce expansion.
  4. Finance Costs:
    • ₹2,928.98 lakhs (FY24) vs. ₹3,091.19 lakhs (FY23)
    • Decrease in finance costs, which could be due to reduced debt or better interest rate management.
  5. Depreciation & Amortization:
    • ₹12,450.25 lakhs (FY24) vs. ₹14,743.35 lakhs (FY23)
    • Depreciation has decreased, possibly due to fewer new asset additions or completion of depreciation cycles.
  6. Other Expenses:
    • ₹18,861.40 lakhs (FY24) vs. ₹6,814.06 lakhs (FY23)
    • A significant rise in other expenses suggests higher miscellaneous costs, increased operational expenses, or new overheads.
  7. Total Expenses:
    • ₹3,54,381.31 lakhs (FY24) vs. ₹3,20,872.48 lakhs (FY23)
    • 10.4% increase in total expenses, slightly lower than the revenue growth rate.

Profitability Metrics

  1. Profit Before Exceptional Items and Tax (III – IV):
    • ₹68,933.43 lakhs (FY24) vs. ₹56,710.86 lakhs (FY23)
    • Strong growth in operating profits (21.6% YoY), indicating better operational efficiency.
  2. Exceptional Items:
    • No exceptional income or expenses in FY24.
  3. Profit Before Tax (PBT):
    • ₹68,933.43 lakhs (FY24) vs. ₹70,507.47 lakhs (FY23)
    • Slight decline, possibly due to higher other expenses in FY24.
  4. Tax Expenses:
    • Current Tax: ₹20,283.59 lakhs
    • Deferred Tax: ₹(1,535.23) lakhs
    • Total Tax Expense: ₹19,550.31 lakhs (FY24) vs. ₹20,624.15 lakhs (FY23)
    • Tax expenses decreased slightly, which could be due to tax optimization.
  5. Net Profit (Profit After Tax – PAT):
    • ₹49,383.12 lakhs (FY24) vs. ₹49,883.32 lakhs (FY23)
    • Flat YoY growth due to higher operating costs despite revenue growth.
  6. Other Comprehensive Income (OCI):
    • Remeasurement of Defined Benefit Plans: ₹612.52 lakhs
    • Deferred Tax on Above Items: ₹(154.16) lakhs
    • Total Comprehensive Income: ₹49,841.48 lakhs (FY24) vs. ₹49,933.67 lakhs (FY23)

Earnings Per Share (EPS)

  1. Basic EPS: ₹17.56 (FY24) vs. ₹17.74 (FY23)
  2. Diluted EPS: ₹17.56 (FY24) vs. ₹17.74 (FY23

Cash Flow:
The three main components of the cash flow statement—Cash from Operating Activities (CFO), Cash from Investing Activities (CFI), and Cash from Financing Activities (CFF)—are directly sourced from the annual report.
The Net Cash Flow for the financial year is derived by summing CFO, CFI, and CFF.
At times, investors may notice minor discrepancies in the figures due to rounding adjustments.

Cash Flow Statement Screener.in “Data Sheet”

screener-export-excel-customization.png".

Cash Flow Statement Annual Report FY2024

Quarterly Result :

Customizing the Default “Export to Excel” Sheet

One standout feature of Screener.in is its ability to customize the “Export to Excel” template and upload it to an investor’s account. This functionality sets Screener.in apart from other data sources.

In our experience with premium data platforms like CMIE Prowess and Capitaline—accessed through MBA college subscriptions and employer resources—we found that while they, along with free sources like Moneycontrol, offer data export options, their capabilities are limited. These platforms typically export only on-screen data, requiring investors to manually apply formulas for analysis, which is time-consuming.

Screener.in improves upon this by allowing investors to customize their Excel templates with predefined formulas. Once uploaded, any future company data exports automatically apply these formulas, saving significant time and streamlining in-depth financial analysis.

Steps to Customize the Excel Template

When an investor downloads a company’s data using the “Export to Excel” button on Screener.in, the file is generated using the platform’s default Excel template.

Default Excel Template Structure

The template consists of six sheets:

  1. Profit & Loss
  2. Quarters
  3. Balance Sheet
  4. Cash Flows
  5. Customization
  6. Data Sheet

The Data Sheet contains the core financial data of the company, as explained earlier in this article. It is essential not to modify this sheet, as any changes may lead to incorrect calculations.

The Customization sheet provides instructions for uploading a modified template to an investor’s Screener.in account. We will cover these steps in detail later in this article.

The remaining sheets—Profit & Loss, Quarters, Balance Sheet, and Cash Flows—contain predefined ratios and formulas provided by the Screener.in team.

Customization Options

An investor can freely modify all sheets except the Data Sheet. Customization possibilities include:

  • Editing or deleting existing sheets
  • Modifying formulas for ratios
  • Adding new ratios
  • Creating entirely new sheets with custom formulas
  • Linking new calculations directly to the Data Sheet

The investor can make unlimited changes to personalize the Excel file, as long as the Data Sheet remains unchanged.

Uploading a Customized “Export to Excel” Sheet on Screener.in

Screener.in allows investors to upload a customized “Export to Excel” template, enabling them to download stock data in their preferred format. The Customization sheet in the default Excel template provides instructions for this process. Below are the steps to upload a customized template, along with key details for ease of understanding.

Steps to Upload a Customized Excel Template

  1. Customize the Excel File
    • Modify the downloaded Screener.in template as per your requirements.
    • Rename and save the file for future reference.
  2. Log in to Screener.in
    • Visit https://www.screener.in/excel/ in your browser.
    • Ensure you are logged into your Screener.in account. If not, you will be redirected to the login/registration page.
    • New users can create an account, while existing users can log in using their credentials.
  3. Upload the Customized Excel Template
    • After logging in, revisit https://www.screener.in/excel/.
    • Click “Choose File” and select your customized Excel file from your saved location.
    • Once selected, the file name will appear on the screen as confirmation.
    • Click “Upload” to save the customized template to your Screener.in account.

Applying the Custom Template

Once uploaded, every time you download a company’s data using “Export to Excel”, the file will automatically apply your custom formulas, ratios, formatting, and layout, saving time and improving analysis efficiency.

Updating or Changing the Custom Template

  • If you need to make further modifications, edit your Excel file (without altering the Data Sheet) and save it.
  • Repeat the upload steps to replace the existing template.
  • The new template will overwrite the previous one, and future downloads will reflect the updated format.

Resetting to the Default Template

If you wish to remove customizations and revert to the default Screener.in template:

  1. Visit https://www.screener.in/excel/.
  2. Click “Reset Customization” to restore the default settings.
  3. Confirm by clicking “Confirm Excel Reset”.

After resetting, all future downloads will follow the default Screener.in format.

There is no limit to how many times an investor can upload, modify, or reset their template, allowing full flexibility to refine the Excel format best suited for stock analysis.

FAQ: Understanding Differences in Financial Ratios and Data Across Sources

Q1: Why do financial ratios have different values on different websites?

Different financial websites use varying methods to classify and calculate financial metrics. Assumptions regarding what constitutes debt, equity, or other financial parameters can differ, leading to variations in reported ratios. Always ensure consistency in methodology when comparing data from different sources.

Q2: Why do Screener.in data and annual report figures sometimes differ?

Screener.in derives its data from company annual reports but may regroup or classify figures differently for consistency across multiple companies. This can result in apparent discrepancies. Investors should refer to annual reports for final decision-making.

Q3: Which data source should I rely on: Screener, Moneycontrol, or the company’s balance sheet?

The company’s balance sheet and annual report provide the most authentic financial data. However, financial portals like Screener.in and Moneycontrol are useful for preliminary filtering and analysis. It’s best to cross-check important financial metrics directly from the company’s filings before making investment decisions.

Q4: Why do debt/equity ratios vary across sources?

Debt/equity ratios differ due to variations in how debt and equity components are defined. Some sources include only long-term borrowings in debt, while others add short-term borrowings and current liabilities. Always verify ratio calculations based on annual report figures.

Q5: How does Screener.in classify financial data in its balance sheet?

Screener.in uses a specific classification method:

  • Equity Share Capital: Directly from the balance sheet
  • Reserves: Directly from the balance sheet
  • Borrowings: Includes long-term borrowings, short-term borrowings, and current maturity of long-term debt
  • Other Liabilities: Includes payables, provisions, and all other liabilities
  • Net Block: Tangible and intangible net fixed assets
  • Capital Work in Progress: Directly from the balance sheet
  • Investments: Includes current and non-current investments
  • Other Assets: Includes all remaining assets such as inventory, receivables, and loans & advances

Q6: How can I calculate financial ratios manually from Screener data?

Some common calculations include:

  • Total Debt = Long-term debt + Short-term debt + Current maturity of long-term debt
  • Receivable Days = (Average trade receivables * 365) / Sales
  • Market Cap Increase in 10 Years = Current market cap – Market cap 10 years ago
  • Cash & Equivalents = Cash & bank balance + Investments (current + non-current)
  • Free Cash Flow (FCF) = Net operating cash flow – Capital expenditures
  • Book Value = (Equity share capital + Reserves) / Number of shares

Q7: How can I calculate the Current Ratio from Screener’s Excel Export?

Screener’s datasheet does not explicitly list Current Assets and Current Liabilities, making it difficult to directly calculate the Current Ratio. It is recommended to extract this data from the company’s annual report or another financial source.

Q8: How does a change in balance sheet reporting format affect Screener’s financial data?

The classification of financial data can change due to regulatory updates (e.g., Schedule VI format change in 2012). Screener updates its methodology accordingly, which may result in differences between older and newer data presentations.

Q9: How can I clarify data discrepancies with Screener.in?

If you notice inconsistencies or need further clarification, you can contact Screener.in support directly. Additionally, always cross-reference important data with official company filings to ensure accuracy.

Conclusion:

Financial data discrepancies arise due to different classification methodologies across sources. While Screener.in is a useful tool for screening stocks, investors should verify critical financial metrics using official company reports before making investment decisions.

sauravahuja777@gmail.com

Author: Saurav Ahuja is an experienced equity research professional, finance writer. With an MBA in Finance and a passion for stock market research, he provides insightful content on investing, swing trading, and financial literacy. He is the founder of Intrinsicinfo.com, a platform dedicated to stock market investing, technical and fundamental analysis, and educational resources for traders and investors.

This Post Has One Comment

Leave a Reply