🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 68 (from laksa064)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa068.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/\')), getAhrefsUnparsedNoserviceFromURL(\'https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/","crawl_time":1776297195,"first_indexed_time":1668121497,"http_code":200,"src_unparsed":"com,corporatefinanceinstitute!\/resources\/financial-modeling\/pl-profit-and-loss-template\/ s443","src_root_hash":"407738686562150068","history_drop_reason":null,"meta_title":"Profit and Loss Template - Free Download","meta_descriptions":["Free Profit and Loss template (P&L template) to download. Create your own income statement with monthly and annual versions in the Excel file."],"attrs_boilerpipe_text":"Download the free Excel templates\nPublished\nDecember 27, 2018\nRead Time\n4\n                                                      minutes\nOver 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.\nStart Free\nCFI’s Profit and Loss (P&L) template provides a free downloadable Excel file for creating monthly and annual income statements. The template allows users to enter their data, which is then automatically used to generate financial statements. The following guide includes instructions for using and modifying the templates, highlighting key components like revenue, expenses, and net earnings. The tools are ideal for businesses of all sizes to track financial performance.\nFree Profit and Loss Template (P&L Template)\nDownload CFI’s free Profit and Loss template (P&L template) to easily create your own income statement.  After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output.\nThe downloadable Excel file includes four templates. A\nStatement of Profit and Loss\n(also called an\nIncome Statement\n) summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period.\nDownload the Template\nDownload the free Excel template now to advance your knowledge of financial modeling.\nHow to Use the Profit and Loss Template\nHere are the steps to follow to effectively use your templates:\nDownload the Excel file (see\nall free templates\n)\nUse the monthly or annual worksheet, depending on what type of statement you want to produce\nReplace all the blue cells that contain hard-coded numbers with your company’s information\nDouble-check to ensure all the formulas in black cells are working properly\nSave as a new file and consider saving a version as PDF as well as XLS\nThe two types of templates included in the file are shown below.\n1. Monthly Profit and Loss Template (P&L Template)\nThe monthly P&L template is perfect for businesses that require regular reporting and detail.  By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown.\nThe monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required. Learn more about\nmonthly cash flow forecast modeling\n.\nFill out the form above to download the Excel file.\n2. Annual Profit and Loss Template (P&L Template)\nFor businesses that have been in operation for several years, it may be helpful to show an annual (full\nfiscal year\nor\nyear-to-date\n) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods.\nThis template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary. It is also useful for performing\nyear-over-year (YoY) analysis\n.\nFill out the form above to download the free annual P&L template Excel file.\nComponents of the P&L Template\nWhile each income statement is unique to every company, there are many common line items that you will see over and over again.\nThe most common P&L line items include:\nRevenue streams\n(also called sales streams)\nReturns, Refunds, Discounts\nTotal Net Revenue\nCost of Goods Sold\nGross Profit\nAdvertising & Promotion\nDepreciation\n& Amortization\nRent and Office\nSalaries, Benefits & Wages\nTelecommunication\nTravel\nUtilities\nSelling, General & Administrative\n(SG&A)\nEarnings Before Interest & Taxes\n(EBIT)\nInterest Expense\nEarnings Before Taxes\n(EBT)\nIncome Taxes\nNet Earnings\nHow to Modify the Profit and Loss Template\nAll the\nCFI templates\nincluded in the free Excel file can be easily edited and changed to suit your own business.\nIf you require more line items, simply insert additional rows in the section where you need to add revenues or expenses. Then, check to make sure the formulas adding up the totals capture those new rows.\nIf you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly.\nTo learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation\nhere\n.\nConnect what you just learned to a clear career path with CFI’s role‑based courses and certification programs.\nAdditional Resources\nThank you for checking out CFI’s free templates for making your own annual and monthly P&L statements in Excel. To keep learning and advancing your career as a\ncertified financial analyst\n, these additional resources will be helpful:\nAnalysis of Financial Statements\nWhat is Financial Modeling?\nValuation Methods\nDCF Financial Modeling Guide\nSee all Excel resources\nSee all Financial Modeling resources","attrs_markdown":"[Corporate Finance Institute](https:\/\/corporatefinanceinstitute.com\/)\n\nMenu\n\n- [Certifications](https:\/\/corporatefinanceinstitute.com\/certifications\/)\n- [Courses](https:\/\/corporatefinanceinstitute.com\/collections\/)\n- [Resources](https:\/\/corporatefinanceinstitute.com\/resources\/)\n- [About](https:\/\/corporatefinanceinstitute.com\/about-cfi\/)\n- [Pricing](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n- [Teams](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/)\n\n[My Dashboard](https:\/\/learn.corporatefinanceinstitute.com\/dashboard)\n\n[Log In](https:\/\/learn.corporatefinanceinstitute.com\/auth\/login)\n\n[Start Free](https:\/\/learn.corporatefinanceinstitute.com\/auth\/registration)\n\n- [Certifications](https:\/\/corporatefinanceinstitute.com\/certifications\/)\n- [Courses](https:\/\/corporatefinanceinstitute.com\/collections\/)\n- [About CFI](https:\/\/corporatefinanceinstitute.com\/about-cfi\/)\n- [Pricing](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n- [CFI For Teams](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/)\n- [Resources](https:\/\/corporatefinanceinstitute.com\/resources\/)\n\n[My Dashboard](https:\/\/learn.corporatefinanceinstitute.com\/dashboard)\n\n[Log In](https:\/\/learn.corporatefinanceinstitute.com\/auth\/login)\n\n[Start Free](https:\/\/learn.corporatefinanceinstitute.com\/auth\/registration)\n\n[Home](https:\/\/corporatefinanceinstitute.com\/ \"Go to Corporate Finance Institute.\")\n\n›\n\n[Resources](https:\/\/corporatefinanceinstitute.com\/resources\/ \"Go to Resources.\")\n\n›\n\n[Financial Modeling](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/ \"Go to the Financial Modeling Resource Type archives.\")\n\n›\n\nProfit and Loss Template\n\nTable of Contents\n\n- [Free Profit and Loss Template (P\\&L Template)](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/#free-profit-and-loss-template-pl-template)\n- [How to Use the Profit and Loss Template](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/#how-to-use-the-profit-and-loss-template)\n- [Components of the P\\&L Template](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/#components-of-the-pl-template)\n- [How to Modify the Profit and Loss Template](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/#how-to-modify-the-profit-and-loss-template)\n- [Additional Resources](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/#additional-resources)\n\n# Profit and Loss Template\nDownload the free Excel templates\n\nWritten by  [Tim Vipond, FMVA](https:\/\/corporatefinanceinstitute.com\/author\/tim-vipond\/)\n\nPublished December 27, 2018\n\nRead Time  4 minutes\n\nOver 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.    [Start Free](https:\/\/learn.corporatefinanceinstitute.com\/auth\/registration)\n\nCFI’s Profit and Loss (P\\&L) template provides a free downloadable Excel file for creating monthly and annual income statements. The template allows users to enter their data, which is then automatically used to generate financial statements. The following guide includes instructions for using and modifying the templates, highlighting key components like revenue, expenses, and net earnings. The tools are ideal for businesses of all sizes to track financial performance.\n\n## Free Profit and Loss Template (P\\&L Template)\nDownload CFI’s free Profit and Loss template (P\\&L template) to easily create your own income statement. After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output.\n\nThe downloadable Excel file includes four templates. A [Statement of Profit and Loss](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/profit-and-loss-statement-pl\/) (also called an [Income Statement](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/income-statement\/)) summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period.\n\n### Download the Template\nDownload the free Excel template now to advance your knowledge of financial modeling.\n\n![Profit and Loss Statement Template Screenshot]()\n\n## How to Use the Profit and Loss Template\nHere are the steps to follow to effectively use your templates:\n\n1. Download the Excel file (see [all free templates](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/))\n2. Use the monthly or annual worksheet, depending on what type of statement you want to produce\n3. Replace all the blue cells that contain hard-coded numbers with your company’s information\n4. Double-check to ensure all the formulas in black cells are working properly\n5. Save as a new file and consider saving a version as PDF as well as XLS\n\nThe two types of templates included in the file are shown below.\n\n### 1\\. Monthly Profit and Loss Template (P\\&L Template)\nThe monthly P\\&L template is perfect for businesses that require regular reporting and detail. By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown.\n\nThe monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required. Learn more about [monthly cash flow forecast modeling](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/monthly-cash-flow-forecast-model\/).\n\nFill out the form above to download the Excel file.\n\n![Download Monthly Profit and Loss Template (P\\&L Template)]()\n\n### 2\\. Annual Profit and Loss Template (P\\&L Template)\nFor businesses that have been in operation for several years, it may be helpful to show an annual (full [fiscal year](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/fy-fiscal-year\/) or [year-to-date](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/year-to-date-ytd\/)) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods.\n\nThis template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary. It is also useful for performing [year-over-year (YoY) analysis](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/year-over-year-analysis-yoy-template\/).\n\nFill out the form above to download the free annual P\\&L template Excel file.\n\n![Download Annual Profit and Loss Template (P\\&L Template)]()\n\n## Components of the P\\&L Template\nWhile each income statement is unique to every company, there are many common line items that you will see over and over again.\n\nThe most common P\\&L line items include:\n\n- [Revenue streams](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/revenue-streams\/) (also called sales streams)\n- Returns, Refunds, Discounts\n- Total Net Revenue\n- [Cost of Goods Sold](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/cost-of-goods-sold-cogs\/)\n- [Gross Profit](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/gross-profit\/)\n- Advertising & Promotion\n- [Depreciation](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/what-is-depreciation-expense\/) & Amortization\n- Rent and Office\n- Salaries, Benefits & Wages\n- Telecommunication\n- Travel\n- Utilities\n- [Selling, General & Administrative](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/what-is-sga\/) (SG\\&A)\n- [Earnings Before Interest & Taxes](https:\/\/corporatefinanceinstitute.com\/resources\/valuation\/ebit\/) (EBIT)\n- [Interest Expense](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/interest-expense\/)\n- [Earnings Before Taxes](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/earnings-before-tax-ebt\/) (EBT)\n- [Income Taxes](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/accounting-for-income-taxes\/)\n- [Net Earnings](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/what-is-net-income\/)\n## How to Modify the Profit and Loss Template\nAll the [CFI templates](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/) included in the free Excel file can be easily edited and changed to suit your own business.\n\nIf you require more line items, simply insert additional rows in the section where you need to add revenues or expenses. Then, check to make sure the formulas adding up the totals capture those new rows.\n\nIf you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly.\n\nTo learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation [here](https:\/\/viewpoint.pwc.com\/dt\/us\/en\/pwc\/accounting_guides\/financial_statement_\/financial_statement___18_US\/chapter_1_general_pr_US\/11_chapter_overview__4_US.html).\n\nConnect what you just learned to a clear career path with CFI’s role‑based courses and certification programs.\n\n[Advance Your Career](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n\n## Additional Resources\nThank you for checking out CFI’s free templates for making your own annual and monthly P\\&L statements in Excel. To keep learning and advancing your career as a [certified financial analyst](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-modeling-valuation-analyst-fmva-program\/), these additional resources will be helpful:\n\n- [Analysis of Financial Statements](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/analysis-of-financial-statements\/)\n- [What is Financial Modeling?](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/what-is-financial-modeling\/)\n- [Valuation Methods](https:\/\/corporatefinanceinstitute.com\/resources\/valuation\/valuation\/)\n- [DCF Financial Modeling Guide](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/dcf-model-training-free-guide\/)\n\n**[See all Excel resources](https:\/\/corporatefinanceinstitute.com\/topic\/excel\/)**\n\n**[See all Financial Modeling resources](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/)**\n\nGet Certified for Financial Modeling (FMVA)®\n\nGain in-demand industry knowledge and hands-on practice that will help you stand out from the competition and become a world-class financial analyst.\n\n[Learn More](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-modeling-valuation-analyst-fmva-program\/)\n\n- Share this article\n- [![Share on LinkedIn]()](http:\/\/www.linkedin.com\/shareArticle?mini=true&url=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F&summary=Profit+and+Loss+Template \"Share on LinkedIn\")\n- [![Share on Facebook]()](https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F \"Share on Facebook\")\n- [![Share on Twitter]()](https:\/\/twitter.com\/intent\/tweet?text=Profit+and+Loss+Template&url=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F \"Share on Twitter\")\n- [![Share on WhatsApp]()](https:\/\/wa.me\/?text=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F&summary=Profit+and+Loss+Template \"Share on WhatsApp\")\n- [![Copy link]()](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/ \"Copy link\")\n\n- [About CFI](https:\/\/corporatefinanceinstitute.com\/about-cfi\/)\n  - [Overview](https:\/\/corporatefinanceinstitute.com\/about-cfi\/)\n  - [Instructors](https:\/\/corporatefinanceinstitute.com\/about-cfi\/instructors\/)\n  - [Team](https:\/\/corporatefinanceinstitute.com\/about-cfi\/faculty-team\/)\n  - [Careers at CFI](https:\/\/corporatefinanceinstitute.com\/about-cfi\/careers-at-cfi\/)\n  - [Editorial Standards](https:\/\/corporatefinanceinstitute.com\/about-cfi\/editorial-standards\/)\n  - [CFI for Students](https:\/\/corporatefinanceinstitute.com\/finance-certifications-for-students\/)\n  - [CPE Credits](https:\/\/corporatefinanceinstitute.com\/about-cfi\/cpe-credits-online\/)\n  - [Learner Reviews](https:\/\/corporatefinanceinstitute.com\/learner-reviews\/)\n  - [Partnerships](https:\/\/corporatefinanceinstitute.com\/partnerships\/)\n  - [Affiliates](https:\/\/corporatefinanceinstitute.com\/affiliates\/)\n  - [Newsroom](https:\/\/corporatefinanceinstitute.com\/resources\/newsroom\/)\n- [Certifications](https:\/\/corporatefinanceinstitute.com\/certifications\/)\n  - [FMVA®](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-modeling-valuation-analyst-fmva-program\/)\n  - [FPAP™](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-planning-analysis-professional-fpap\/)\n  - [CMSA®](https:\/\/corporatefinanceinstitute.com\/certifications\/capital-markets-securities-analyst-cmsa\/)\n  - [CBCA®](https:\/\/corporatefinanceinstitute.com\/certifications\/commercial-banking-credit-analyst-certification-cbca\/)\n  - [BIDA®](https:\/\/corporatefinanceinstitute.com\/certifications\/business-intelligence-data-analyst-bida\/)\n  - [FPWMP®](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-planning-and-wealth-management-fpwm-program\/)\n  - [FTIP®](https:\/\/corporatefinanceinstitute.com\/certifications\/fintech-industry-professional\/)\n  - [All Certifications](https:\/\/corporatefinanceinstitute.com\/certifications\/)\n  - [Compare Certifications](https:\/\/corporatefinanceinstitute.com\/certifications\/compare-certifications\/)\n  - [Topics](https:\/\/corporatefinanceinstitute.com\/topics\/)\n  - [Specializations](https:\/\/corporatefinanceinstitute.com\/specializations\/)\n  - [Courses](https:\/\/corporatefinanceinstitute.com\/collections\/?tab=courses)\n- [Pricing](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n  - [For Individuals](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n  - [For Students](https:\/\/corporatefinanceinstitute.com\/finance-certifications-for-students\/)\n  - [For Teams](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/pricing-plans\/)\n- [CFI For Teams](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/)\n  - [Financial Services](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/for-financial-services\/)\n  - [Corporate Finance](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/for-finance-teams\/)\n  - [Professional Services](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/for-professional-services\/)\n  - [For Employers](https:\/\/corporatefinanceinstitute.com\/for-employers\/)\n  - [Teams](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/)\n  - [For Universities](https:\/\/corporatefinanceinstitute.com\/cfi-for-teams\/for-universities\/)\n- [Careers & Roles](https:\/\/corporatefinanceinstitute.com\/careers\/)\n  - [FP\\&A](https:\/\/corporatefinanceinstitute.com\/careers\/financial-planning-and-analysis\/)\n  - [Investment Banking](https:\/\/corporatefinanceinstitute.com\/careers\/investment-banking\/)\n  - [Capital Markets](https:\/\/corporatefinanceinstitute.com\/careers\/capital-markets\/)\n  - [Commercial Lending](https:\/\/corporatefinanceinstitute.com\/careers\/commercial-lending\/)\n  - [Risk Management](https:\/\/corporatefinanceinstitute.com\/careers\/risk-management\/)\n  - [Asset Management](https:\/\/corporatefinanceinstitute.com\/careers\/asset-management\/)\n  - [Hedge Funds](https:\/\/corporatefinanceinstitute.com\/careers\/hedge-funds\/)\n  - [Private Equity](https:\/\/corporatefinanceinstitute.com\/careers\/private-equity\/)\n  - [Wealth Management](https:\/\/corporatefinanceinstitute.com\/careers\/wealth-management\/)\n- [Support](https:\/\/help.corporatefinanceinstitute.com\/)\n  - [Help \\| FAQ](https:\/\/help.corporatefinanceinstitute.com\/)\n  - [Legal](https:\/\/corporatefinanceinstitute.com\/about-cfi\/legal\/)\n- [Community](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/)\n  - [Member Community](https:\/\/corporatefinanceinstitute.com\/member-community\/)\n  - [What’s New](https:\/\/corporatefinanceinstitute.com\/whats-new\/)\n  - [Resources](https:\/\/corporatefinanceinstitute.com\/resources\/)\n  - [Podcast](https:\/\/corporatefinanceinstitute.com\/resources\/finpod\/)\n\n[![Corporate Finance Institute (CFI) A+ BBB Business Review]()](https:\/\/www.bbb.org\/ca\/bc\/vancouver\/profile\/online-education\/corporate-finance-institute-cfi-0037-2405665\/#sealclick)\n\n![SOC for Service Organizations]()\n\n[Trustpilot](https:\/\/www.trustpilot.com\/review\/corporatefinanceinstitute.com)\n\n[Logo ![CFI on App Store]()](https:\/\/apps.apple.com\/us\/app\/corporate-finance-institute\/id6599859785)\n\n[Logo ![CFI on Google Play]()](https:\/\/play.google.com\/store\/apps\/details?id=lms.corporatefinanceinstitute.com)\n\n© 2015 to 2026 CFI Education Inc.\n\n[Follow us on LinkedIn](https:\/\/www.linkedin.com\/school\/corporate-finance-institute-cfi\/ \"Follow us on LinkedIn\")   [Follow us on Instagram](https:\/\/www.instagram.com\/corporatefinanceinstitute\/ \"Follow us on Instagram\")   [Follow us on Facebook](https:\/\/www.facebook.com\/corporatefinanceinstitute.CFI\/ \"Follow us on Facebook\")   [Follow us on YouTube](https:\/\/www.youtube.com\/c\/Corporatefinanceinstitute-CFI \"Follow us on YouTube\")\n\n- [Privacy Policy](https:\/\/corporatefinanceinstitute.com\/about-cfi\/privacy-policy\/)\n- [Terms of Use](https:\/\/corporatefinanceinstitute.com\/about-cfi\/website-terms-of-use\/)\n- [Terms of Service](https:\/\/corporatefinanceinstitute.com\/about-cfi\/cfi-terms-of-service\/)\n- [Legal](https:\/\/corporatefinanceinstitute.com\/about-cfi\/legal\/)\n\n[Corporate Finance Institute](https:\/\/corporatefinanceinstitute.com\/)\n\n[Back to Website](https:\/\/corporatefinanceinstitute.com\/)\n\n0 search results for ‘’\n\nPeople also search for:   excel   power bi   esg   accounting   balance sheet   fmva   real estate\n\nExplore Our Certifications\n\n[Financial Modeling & Valuation Analyst (FMVA)®](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-modeling-valuation-analyst-fmva-program\/)\n\n[Commercial Banking & Credit Analyst (CBCA)®](https:\/\/corporatefinanceinstitute.com\/certifications\/commercial-banking-credit-analyst-certification-cbca\/)\n\n[Capital Markets & Securities Analyst (CMSA)®](https:\/\/corporatefinanceinstitute.com\/certifications\/capital-markets-securities-analyst-cmsa\/)\n\n[Certified Business Intelligence & Data Analyst (BIDA)®](https:\/\/corporatefinanceinstitute.com\/certifications\/business-intelligence-data-analyst-bida\/)\n\n[Financial Planning & Wealth Management Professional (FPWMP)®](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-planning-and-wealth-management-fpwm-program\/)\n\n[FinTech Industry Professional (FTIP)®](https:\/\/corporatefinanceinstitute.com\/certifications\/fintech-industry-professional\/)\n\nResources\n\n[Mastering Excel Shortcuts for PC and Mac Work Smarter in Excel with Keyboard Shortcuts If you're still reaching for the mouse every few seconds, it's time to level up. The best Excel keyboard...](https:\/\/corporatefinanceinstitute.com\/resources\/excel\/excel-shortcuts-pc-mac\/)\n\n[Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building blocks, and common tips, tricks,...](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/free-financial-modeling-guide\/)\n\n[SQL Data Types What are SQL Data Types? The Structured Query Language (SQL) comprises several different data types that allow it to store different types of information...](https:\/\/corporatefinanceinstitute.com\/resources\/data-science\/sql-data-types\/)\n\n[Structured Query Language (SQL) What is Structured Query Language (SQL)? Structured Query Language (known as SQL) is a programming language used to interact with a database....](https:\/\/corporatefinanceinstitute.com\/resources\/data-science\/structured-query-language-sql\/)\n\n[See All Resources See All](https:\/\/corporatefinanceinstitute.com\/resources\/)\n\nPopular Courses\n\n[![Excel Fundamentals - Formulas for Finance]() BIDA Prep Course 2h 14min Excel Fundamentals - Formulas for Finance](https:\/\/corporatefinanceinstitute.com\/course\/excel-fundamentals-formulas-for-finance\/)\n\n[![3-Statement Modeling]() FMVA Required 3h 15min 3-Statement Modeling](https:\/\/corporatefinanceinstitute.com\/course\/3-statement-modeling\/)\n\n[![Introduction to Business Valuation]() FMVA Required 3h 9min Introduction to Business Valuation](https:\/\/corporatefinanceinstitute.com\/course\/intro-business-valuation\/)\n\n[![Scenario & Sensitivity Analysis in Excel]() FMVA Required 48min Scenario & Sensitivity Analysis in Excel](https:\/\/corporatefinanceinstitute.com\/course\/sensitivity-analysis-financial-modeling\/)\n\n[![Excel Data Visualization and Dashboards]() FMVA Required 1h 30min Excel Data Visualization and Dashboards](https:\/\/corporatefinanceinstitute.com\/course\/dashboards-and-data-visualization\/)\n\n[![Leveraged Buyout (LBO) Modeling]() 4h 33min Leveraged Buyout (LBO) Modeling](https:\/\/corporatefinanceinstitute.com\/course\/leveraged-buyout-lbo-modeling\/)\n\n[See All Courses See All](https:\/\/corporatefinanceinstitute.com\/collections\/)\n\nRecent Searches\n\nSuggestions\n\n[Excel Courses](https:\/\/corporatefinanceinstitute.com\/topic\/excel\/)   [Financial Modeling & Valuation Analyst (FMVA)®](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-modeling-valuation-analyst-fmva-program\/)\n\n×\n\n### Create a free account to unlock this Template\nAccess and download collection of free Templates to help power your productivity and performance.\n\n[Create a Free Account](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/)\n\nAlready have an account? [Log in](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/)\n\n×\n\n### Supercharge your skills with Premium Templates\nTake your learning and productivity to the next level with our Premium Templates.\n\nUpgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.\n\n[Discover Paid Memberships](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n\nAlready have a Self-Study or Full-Immersion membership? [Log in](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/)\n\n×\n\n### Access Exclusive Templates\nGain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.\n\n[Discover Full-Immersion Membership](https:\/\/corporatefinanceinstitute.com\/pricing\/)\n\nAlready have a Full-Immersion membership? [Log in](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/pl-profit-and-loss-template\/)","attrs_readable_markdown":"Download the free Excel templates\n\nPublished December 27, 2018\n\nRead Time  4 minutes\n\nOver 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.    [Start Free](https:\/\/learn.corporatefinanceinstitute.com\/auth\/registration)\n\nCFI’s Profit and Loss (P\\&L) template provides a free downloadable Excel file for creating monthly and annual income statements. The template allows users to enter their data, which is then automatically used to generate financial statements. The following guide includes instructions for using and modifying the templates, highlighting key components like revenue, expenses, and net earnings. The tools are ideal for businesses of all sizes to track financial performance.\n\n## Free Profit and Loss Template (P\\&L Template)\nDownload CFI’s free Profit and Loss template (P\\&L template) to easily create your own income statement. After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output.\n\nThe downloadable Excel file includes four templates. A [Statement of Profit and Loss](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/profit-and-loss-statement-pl\/) (also called an [Income Statement](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/income-statement\/)) summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period.\n\n### Download the Template\nDownload the free Excel template now to advance your knowledge of financial modeling.\n\n![Profit and Loss Statement Template Screenshot](https:\/\/cdn.corporatefinanceinstitute.com\/assets\/00087-Profit-and-Loss-Statement-1024x634.png)\n\n## How to Use the Profit and Loss Template\nHere are the steps to follow to effectively use your templates:\n\n1. Download the Excel file (see [all free templates](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/))\n2. Use the monthly or annual worksheet, depending on what type of statement you want to produce\n3. Replace all the blue cells that contain hard-coded numbers with your company’s information\n4. Double-check to ensure all the formulas in black cells are working properly\n5. Save as a new file and consider saving a version as PDF as well as XLS\n\nThe two types of templates included in the file are shown below.\n\n### 1\\. Monthly Profit and Loss Template (P\\&L Template)\nThe monthly P\\&L template is perfect for businesses that require regular reporting and detail. By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown.\n\nThe monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required. Learn more about [monthly cash flow forecast modeling](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/monthly-cash-flow-forecast-model\/).\n\nFill out the form above to download the Excel file.\n\n![Download Monthly Profit and Loss Template (P\\&L Template)](https:\/\/cdn.corporatefinanceinstitute.com\/assets\/profit-and-loss-monthly-1024x670.png)\n\n### 2\\. Annual Profit and Loss Template (P\\&L Template)\nFor businesses that have been in operation for several years, it may be helpful to show an annual (full [fiscal year](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/fy-fiscal-year\/) or [year-to-date](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/year-to-date-ytd\/)) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods.\n\nThis template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary. It is also useful for performing [year-over-year (YoY) analysis](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/year-over-year-analysis-yoy-template\/).\n\nFill out the form above to download the free annual P\\&L template Excel file.\n\n![Download Annual Profit and Loss Template (P\\&L Template)](https:\/\/cdn.corporatefinanceinstitute.com\/assets\/profit-and-loss-annual.png)\n\n## Components of the P\\&L Template\nWhile each income statement is unique to every company, there are many common line items that you will see over and over again.\n\nThe most common P\\&L line items include:\n\n- [Revenue streams](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/revenue-streams\/) (also called sales streams)\n- Returns, Refunds, Discounts\n- Total Net Revenue\n- [Cost of Goods Sold](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/cost-of-goods-sold-cogs\/)\n- [Gross Profit](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/gross-profit\/)\n- Advertising & Promotion\n- [Depreciation](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/what-is-depreciation-expense\/) & Amortization\n- Rent and Office\n- Salaries, Benefits & Wages\n- Telecommunication\n- Travel\n- Utilities\n- [Selling, General & Administrative](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/what-is-sga\/) (SG\\&A)\n- [Earnings Before Interest & Taxes](https:\/\/corporatefinanceinstitute.com\/resources\/valuation\/ebit\/) (EBIT)\n- [Interest Expense](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/interest-expense\/)\n- [Earnings Before Taxes](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/earnings-before-tax-ebt\/) (EBT)\n- [Income Taxes](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/accounting-for-income-taxes\/)\n- [Net Earnings](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/what-is-net-income\/)\n## How to Modify the Profit and Loss Template\nAll the [CFI templates](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/) included in the free Excel file can be easily edited and changed to suit your own business.\n\nIf you require more line items, simply insert additional rows in the section where you need to add revenues or expenses. Then, check to make sure the formulas adding up the totals capture those new rows.\n\nIf you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly.\n\nTo learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation [here](https:\/\/viewpoint.pwc.com\/dt\/us\/en\/pwc\/accounting_guides\/financial_statement_\/financial_statement___18_US\/chapter_1_general_pr_US\/11_chapter_overview__4_US.html).\n\nConnect what you just learned to a clear career path with CFI’s role‑based courses and certification programs.\n\n## Additional Resources\nThank you for checking out CFI’s free templates for making your own annual and monthly P\\&L statements in Excel. To keep learning and advancing your career as a [certified financial analyst](https:\/\/corporatefinanceinstitute.com\/certifications\/financial-modeling-valuation-analyst-fmva-program\/), these additional resources will be helpful:\n\n- [Analysis of Financial Statements](https:\/\/corporatefinanceinstitute.com\/resources\/accounting\/analysis-of-financial-statements\/)\n- [What is Financial Modeling?](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/what-is-financial-modeling\/)\n- [Valuation Methods](https:\/\/corporatefinanceinstitute.com\/resources\/valuation\/valuation\/)\n- [DCF Financial Modeling Guide](https:\/\/corporatefinanceinstitute.com\/resources\/financial-modeling\/dcf-model-training-free-guide\/)\n\n**[See all Excel resources](https:\/\/corporatefinanceinstitute.com\/topic\/excel\/)**\n\n**[See all Financial Modeling resources](https:\/\/corporatefinanceinstitute.com\/topic\/financial-modeling\/)**","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

3 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.1 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/
Last Crawled	2026-04-15 23:53:15 (3 days ago)
First Indexed	2022-11-10 23:04:57 (3 years ago)
HTTP Status Code	200
Meta Title	Profit and Loss Template - Free Download
Meta Description	Free Profit and Loss template (P&L template) to download. Create your own income statement with monthly and annual versions in the Excel file.
Meta Canonical	null
Boilerpipe Text	Download the free Excel templates Published December 27, 2018 Read Time 4 minutes Over 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course. Start Free CFI’s Profit and Loss (P&L) template provides a free downloadable Excel file for creating monthly and annual income statements. The template allows users to enter their data, which is then automatically used to generate financial statements. The following guide includes instructions for using and modifying the templates, highlighting key components like revenue, expenses, and net earnings. The tools are ideal for businesses of all sizes to track financial performance. Free Profit and Loss Template (P&L Template) Download CFI’s free Profit and Loss template (P&L template) to easily create your own income statement. After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output. The downloadable Excel file includes four templates. A Statement of Profit and Loss (also called an Income Statement ) summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period. Download the Template Download the free Excel template now to advance your knowledge of financial modeling. How to Use the Profit and Loss Template Here are the steps to follow to effectively use your templates: Download the Excel file (see all free templates ) Use the monthly or annual worksheet, depending on what type of statement you want to produce Replace all the blue cells that contain hard-coded numbers with your company’s information Double-check to ensure all the formulas in black cells are working properly Save as a new file and consider saving a version as PDF as well as XLS The two types of templates included in the file are shown below. 1. Monthly Profit and Loss Template (P&L Template) The monthly P&L template is perfect for businesses that require regular reporting and detail. By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown. The monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required. Learn more about monthly cash flow forecast modeling . Fill out the form above to download the Excel file. 2. Annual Profit and Loss Template (P&L Template) For businesses that have been in operation for several years, it may be helpful to show an annual (full fiscal year or year-to-date ) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods. This template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary. It is also useful for performing year-over-year (YoY) analysis . Fill out the form above to download the free annual P&L template Excel file. Components of the P&L Template While each income statement is unique to every company, there are many common line items that you will see over and over again. The most common P&L line items include: Revenue streams (also called sales streams) Returns, Refunds, Discounts Total Net Revenue Cost of Goods Sold Gross Profit Advertising & Promotion Depreciation & Amortization Rent and Office Salaries, Benefits & Wages Telecommunication Travel Utilities Selling, General & Administrative (SG&A) Earnings Before Interest & Taxes (EBIT) Interest Expense Earnings Before Taxes (EBT) Income Taxes Net Earnings How to Modify the Profit and Loss Template All the CFI templates included in the free Excel file can be easily edited and changed to suit your own business. If you require more line items, simply insert additional rows in the section where you need to add revenues or expenses. Then, check to make sure the formulas adding up the totals capture those new rows. If you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly. To learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation here . Connect what you just learned to a clear career path with CFI’s role‑based courses and certification programs. Additional Resources Thank you for checking out CFI’s free templates for making your own annual and monthly P&L statements in Excel. To keep learning and advancing your career as a certified financial analyst , these additional resources will be helpful: Analysis of Financial Statements What is Financial Modeling? Valuation Methods DCF Financial Modeling Guide See all Excel resources See all Financial Modeling resources
Markdown	[Corporate Finance Institute](https://corporatefinanceinstitute.com/) Menu - [Certifications](https://corporatefinanceinstitute.com/certifications/) - [Courses](https://corporatefinanceinstitute.com/collections/) - [Resources](https://corporatefinanceinstitute.com/resources/) - [About](https://corporatefinanceinstitute.com/about-cfi/) - [Pricing](https://corporatefinanceinstitute.com/pricing/) - [Teams](https://corporatefinanceinstitute.com/cfi-for-teams/) [My Dashboard](https://learn.corporatefinanceinstitute.com/dashboard) [Log In](https://learn.corporatefinanceinstitute.com/auth/login) [Start Free](https://learn.corporatefinanceinstitute.com/auth/registration) - [Certifications](https://corporatefinanceinstitute.com/certifications/) - [Courses](https://corporatefinanceinstitute.com/collections/) - [About CFI](https://corporatefinanceinstitute.com/about-cfi/) - [Pricing](https://corporatefinanceinstitute.com/pricing/) - [CFI For Teams](https://corporatefinanceinstitute.com/cfi-for-teams/) - [Resources](https://corporatefinanceinstitute.com/resources/) [My Dashboard](https://learn.corporatefinanceinstitute.com/dashboard) [Log In](https://learn.corporatefinanceinstitute.com/auth/login) [Start Free](https://learn.corporatefinanceinstitute.com/auth/registration) [Home](https://corporatefinanceinstitute.com/ "Go to Corporate Finance Institute.") › [Resources](https://corporatefinanceinstitute.com/resources/ "Go to Resources.") › [Financial Modeling](https://corporatefinanceinstitute.com/topic/financial-modeling/ "Go to the Financial Modeling Resource Type archives.") › Profit and Loss Template Table of Contents - [Free Profit and Loss Template (P\&L Template)](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/#free-profit-and-loss-template-pl-template) - [How to Use the Profit and Loss Template](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/#how-to-use-the-profit-and-loss-template) - [Components of the P\&L Template](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/#components-of-the-pl-template) - [How to Modify the Profit and Loss Template](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/#how-to-modify-the-profit-and-loss-template) - [Additional Resources](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/#additional-resources) # Profit and Loss Template Download the free Excel templates Written by [Tim Vipond, FMVA](https://corporatefinanceinstitute.com/author/tim-vipond/) Published December 27, 2018 Read Time 4 minutes Over 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course. [Start Free](https://learn.corporatefinanceinstitute.com/auth/registration) CFI’s Profit and Loss (P\&L) template provides a free downloadable Excel file for creating monthly and annual income statements. The template allows users to enter their data, which is then automatically used to generate financial statements. The following guide includes instructions for using and modifying the templates, highlighting key components like revenue, expenses, and net earnings. The tools are ideal for businesses of all sizes to track financial performance. ## Free Profit and Loss Template (P\&L Template) Download CFI’s free Profit and Loss template (P\&L template) to easily create your own income statement. After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output. The downloadable Excel file includes four templates. A [Statement of Profit and Loss](https://corporatefinanceinstitute.com/resources/accounting/profit-and-loss-statement-pl/) (also called an [Income Statement](https://corporatefinanceinstitute.com/resources/accounting/income-statement/)) summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period. ### Download the Template Download the free Excel template now to advance your knowledge of financial modeling. ![Profit and Loss Statement Template Screenshot]() ## How to Use the Profit and Loss Template Here are the steps to follow to effectively use your templates: 1. Download the Excel file (see [all free templates](https://corporatefinanceinstitute.com/topic/financial-modeling/)) 2. Use the monthly or annual worksheet, depending on what type of statement you want to produce 3. Replace all the blue cells that contain hard-coded numbers with your company’s information 4. Double-check to ensure all the formulas in black cells are working properly 5. Save as a new file and consider saving a version as PDF as well as XLS The two types of templates included in the file are shown below. ### 1\. Monthly Profit and Loss Template (P\&L Template) The monthly P\&L template is perfect for businesses that require regular reporting and detail. By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown. The monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required. Learn more about [monthly cash flow forecast modeling](https://corporatefinanceinstitute.com/resources/financial-modeling/monthly-cash-flow-forecast-model/). Fill out the form above to download the Excel file. ![Download Monthly Profit and Loss Template (P\&L Template)]() ### 2\. Annual Profit and Loss Template (P\&L Template) For businesses that have been in operation for several years, it may be helpful to show an annual (full [fiscal year](https://corporatefinanceinstitute.com/resources/accounting/fy-fiscal-year/) or [year-to-date](https://corporatefinanceinstitute.com/resources/accounting/year-to-date-ytd/)) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods. This template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary. It is also useful for performing [year-over-year (YoY) analysis](https://corporatefinanceinstitute.com/resources/financial-modeling/year-over-year-analysis-yoy-template/). Fill out the form above to download the free annual P\&L template Excel file. ![Download Annual Profit and Loss Template (P\&L Template)]() ## Components of the P\&L Template While each income statement is unique to every company, there are many common line items that you will see over and over again. The most common P\&L line items include: - [Revenue streams](https://corporatefinanceinstitute.com/resources/accounting/revenue-streams/) (also called sales streams) - Returns, Refunds, Discounts - Total Net Revenue - [Cost of Goods Sold](https://corporatefinanceinstitute.com/resources/accounting/cost-of-goods-sold-cogs/) - [Gross Profit](https://corporatefinanceinstitute.com/resources/accounting/gross-profit/) - Advertising & Promotion - [Depreciation](https://corporatefinanceinstitute.com/resources/accounting/what-is-depreciation-expense/) & Amortization - Rent and Office - Salaries, Benefits & Wages - Telecommunication - Travel - Utilities - [Selling, General & Administrative](https://corporatefinanceinstitute.com/resources/accounting/what-is-sga/) (SG\&A) - [Earnings Before Interest & Taxes](https://corporatefinanceinstitute.com/resources/valuation/ebit/) (EBIT) - [Interest Expense](https://corporatefinanceinstitute.com/resources/accounting/interest-expense/) - [Earnings Before Taxes](https://corporatefinanceinstitute.com/resources/accounting/earnings-before-tax-ebt/) (EBT) - [Income Taxes](https://corporatefinanceinstitute.com/resources/accounting/accounting-for-income-taxes/) - [Net Earnings](https://corporatefinanceinstitute.com/resources/accounting/what-is-net-income/) ## How to Modify the Profit and Loss Template All the [CFI templates](https://corporatefinanceinstitute.com/topic/financial-modeling/) included in the free Excel file can be easily edited and changed to suit your own business. If you require more line items, simply insert additional rows in the section where you need to add revenues or expenses. Then, check to make sure the formulas adding up the totals capture those new rows. If you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly. To learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation [here](https://viewpoint.pwc.com/dt/us/en/pwc/accounting_guides/financial_statement_/financial_statement___18_US/chapter_1_general_pr_US/11_chapter_overview__4_US.html). Connect what you just learned to a clear career path with CFI’s role‑based courses and certification programs. [Advance Your Career](https://corporatefinanceinstitute.com/pricing/) ## Additional Resources Thank you for checking out CFI’s free templates for making your own annual and monthly P\&L statements in Excel. To keep learning and advancing your career as a [certified financial analyst](https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/), these additional resources will be helpful: - [Analysis of Financial Statements](https://corporatefinanceinstitute.com/resources/accounting/analysis-of-financial-statements/) - [What is Financial Modeling?](https://corporatefinanceinstitute.com/resources/financial-modeling/what-is-financial-modeling/) - [Valuation Methods](https://corporatefinanceinstitute.com/resources/valuation/valuation/) - [DCF Financial Modeling Guide](https://corporatefinanceinstitute.com/resources/financial-modeling/dcf-model-training-free-guide/) [See all Excel resources](https://corporatefinanceinstitute.com/topic/excel/) [See all Financial Modeling resources](https://corporatefinanceinstitute.com/topic/financial-modeling/) Get Certified for Financial Modeling (FMVA)® Gain in-demand industry knowledge and hands-on practice that will help you stand out from the competition and become a world-class financial analyst. [Learn More](https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/) - Share this article - [![Share on LinkedIn]()](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F&summary=Profit+and+Loss+Template "Share on LinkedIn") - [![Share on Facebook]()](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F "Share on Facebook") - [![Share on Twitter]()](https://twitter.com/intent/tweet?text=Profit+and+Loss+Template&url=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F "Share on Twitter") - [![Share on WhatsApp]()](https://wa.me/?text=https%3A%2F%2Fcorporatefinanceinstitute.com%2Fresources%2Ffinancial-modeling%2Fpl-profit-and-loss-template%2F&summary=Profit+and+Loss+Template "Share on WhatsApp") - [![Copy link]()](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/ "Copy link") - [About CFI](https://corporatefinanceinstitute.com/about-cfi/) - [Overview](https://corporatefinanceinstitute.com/about-cfi/) - [Instructors](https://corporatefinanceinstitute.com/about-cfi/instructors/) - [Team](https://corporatefinanceinstitute.com/about-cfi/faculty-team/) - [Careers at CFI](https://corporatefinanceinstitute.com/about-cfi/careers-at-cfi/) - [Editorial Standards](https://corporatefinanceinstitute.com/about-cfi/editorial-standards/) - [CFI for Students](https://corporatefinanceinstitute.com/finance-certifications-for-students/) - [CPE Credits](https://corporatefinanceinstitute.com/about-cfi/cpe-credits-online/) - [Learner Reviews](https://corporatefinanceinstitute.com/learner-reviews/) - [Partnerships](https://corporatefinanceinstitute.com/partnerships/) - [Affiliates](https://corporatefinanceinstitute.com/affiliates/) - [Newsroom](https://corporatefinanceinstitute.com/resources/newsroom/) - [Certifications](https://corporatefinanceinstitute.com/certifications/) - [FMVA®](https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/) - [FPAP™](https://corporatefinanceinstitute.com/certifications/financial-planning-analysis-professional-fpap/) - [CMSA®](https://corporatefinanceinstitute.com/certifications/capital-markets-securities-analyst-cmsa/) - [CBCA®](https://corporatefinanceinstitute.com/certifications/commercial-banking-credit-analyst-certification-cbca/) - [BIDA®](https://corporatefinanceinstitute.com/certifications/business-intelligence-data-analyst-bida/) - [FPWMP®](https://corporatefinanceinstitute.com/certifications/financial-planning-and-wealth-management-fpwm-program/) - [FTIP®](https://corporatefinanceinstitute.com/certifications/fintech-industry-professional/) - [All Certifications](https://corporatefinanceinstitute.com/certifications/) - [Compare Certifications](https://corporatefinanceinstitute.com/certifications/compare-certifications/) - [Topics](https://corporatefinanceinstitute.com/topics/) - [Specializations](https://corporatefinanceinstitute.com/specializations/) - [Courses](https://corporatefinanceinstitute.com/collections/?tab=courses) - [Pricing](https://corporatefinanceinstitute.com/pricing/) - [For Individuals](https://corporatefinanceinstitute.com/pricing/) - [For Students](https://corporatefinanceinstitute.com/finance-certifications-for-students/) - [For Teams](https://corporatefinanceinstitute.com/cfi-for-teams/pricing-plans/) - [CFI For Teams](https://corporatefinanceinstitute.com/cfi-for-teams/) - [Financial Services](https://corporatefinanceinstitute.com/cfi-for-teams/for-financial-services/) - [Corporate Finance](https://corporatefinanceinstitute.com/cfi-for-teams/for-finance-teams/) - [Professional Services](https://corporatefinanceinstitute.com/cfi-for-teams/for-professional-services/) - [For Employers](https://corporatefinanceinstitute.com/for-employers/) - [Teams](https://corporatefinanceinstitute.com/cfi-for-teams/) - [For Universities](https://corporatefinanceinstitute.com/cfi-for-teams/for-universities/) - [Careers & Roles](https://corporatefinanceinstitute.com/careers/) - [FP\&A](https://corporatefinanceinstitute.com/careers/financial-planning-and-analysis/) - [Investment Banking](https://corporatefinanceinstitute.com/careers/investment-banking/) - [Capital Markets](https://corporatefinanceinstitute.com/careers/capital-markets/) - [Commercial Lending](https://corporatefinanceinstitute.com/careers/commercial-lending/) - [Risk Management](https://corporatefinanceinstitute.com/careers/risk-management/) - [Asset Management](https://corporatefinanceinstitute.com/careers/asset-management/) - [Hedge Funds](https://corporatefinanceinstitute.com/careers/hedge-funds/) - [Private Equity](https://corporatefinanceinstitute.com/careers/private-equity/) - [Wealth Management](https://corporatefinanceinstitute.com/careers/wealth-management/) - [Support](https://help.corporatefinanceinstitute.com/) - [Help \\| FAQ](https://help.corporatefinanceinstitute.com/) - [Legal](https://corporatefinanceinstitute.com/about-cfi/legal/) - [Community](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/) - [Member Community](https://corporatefinanceinstitute.com/member-community/) - [What’s New](https://corporatefinanceinstitute.com/whats-new/) - [Resources](https://corporatefinanceinstitute.com/resources/) - [Podcast](https://corporatefinanceinstitute.com/resources/finpod/) [![Corporate Finance Institute (CFI) A+ BBB Business Review]()](https://www.bbb.org/ca/bc/vancouver/profile/online-education/corporate-finance-institute-cfi-0037-2405665/#sealclick) ![SOC for Service Organizations]() [Trustpilot](https://www.trustpilot.com/review/corporatefinanceinstitute.com) [Logo ![CFI on App Store]()](https://apps.apple.com/us/app/corporate-finance-institute/id6599859785) [Logo ![CFI on Google Play]()](https://play.google.com/store/apps/details?id=lms.corporatefinanceinstitute.com) © 2015 to 2026 CFI Education Inc. [Follow us on LinkedIn](https://www.linkedin.com/school/corporate-finance-institute-cfi/ "Follow us on LinkedIn") [Follow us on Instagram](https://www.instagram.com/corporatefinanceinstitute/ "Follow us on Instagram") [Follow us on Facebook](https://www.facebook.com/corporatefinanceinstitute.CFI/ "Follow us on Facebook") [Follow us on YouTube](https://www.youtube.com/c/Corporatefinanceinstitute-CFI "Follow us on YouTube") - [Privacy Policy](https://corporatefinanceinstitute.com/about-cfi/privacy-policy/) - [Terms of Use](https://corporatefinanceinstitute.com/about-cfi/website-terms-of-use/) - [Terms of Service](https://corporatefinanceinstitute.com/about-cfi/cfi-terms-of-service/) - [Legal](https://corporatefinanceinstitute.com/about-cfi/legal/) [Corporate Finance Institute](https://corporatefinanceinstitute.com/) [Back to Website](https://corporatefinanceinstitute.com/) 0 search results for ‘’ People also search for: excel power bi esg accounting balance sheet fmva real estate Explore Our Certifications [Financial Modeling & Valuation Analyst (FMVA)®](https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/) [Commercial Banking & Credit Analyst (CBCA)®](https://corporatefinanceinstitute.com/certifications/commercial-banking-credit-analyst-certification-cbca/) [Capital Markets & Securities Analyst (CMSA)®](https://corporatefinanceinstitute.com/certifications/capital-markets-securities-analyst-cmsa/) [Certified Business Intelligence & Data Analyst (BIDA)®](https://corporatefinanceinstitute.com/certifications/business-intelligence-data-analyst-bida/) [Financial Planning & Wealth Management Professional (FPWMP)®](https://corporatefinanceinstitute.com/certifications/financial-planning-and-wealth-management-fpwm-program/) [FinTech Industry Professional (FTIP)®](https://corporatefinanceinstitute.com/certifications/fintech-industry-professional/) Resources [Mastering Excel Shortcuts for PC and Mac Work Smarter in Excel with Keyboard Shortcuts If you're still reaching for the mouse every few seconds, it's time to level up. The best Excel keyboard...](https://corporatefinanceinstitute.com/resources/excel/excel-shortcuts-pc-mac/) [Financial Modeling Guidelines CFI’s free Financial Modeling Guidelines is a thorough and complete resource covering model design, model building blocks, and common tips, tricks,...](https://corporatefinanceinstitute.com/resources/financial-modeling/free-financial-modeling-guide/) [SQL Data Types What are SQL Data Types? The Structured Query Language (SQL) comprises several different data types that allow it to store different types of information...](https://corporatefinanceinstitute.com/resources/data-science/sql-data-types/) [Structured Query Language (SQL) What is Structured Query Language (SQL)? Structured Query Language (known as SQL) is a programming language used to interact with a database....](https://corporatefinanceinstitute.com/resources/data-science/structured-query-language-sql/) [See All Resources See All](https://corporatefinanceinstitute.com/resources/) Popular Courses [![Excel Fundamentals - Formulas for Finance]() BIDA Prep Course 2h 14min Excel Fundamentals - Formulas for Finance](https://corporatefinanceinstitute.com/course/excel-fundamentals-formulas-for-finance/) [![3-Statement Modeling]() FMVA Required 3h 15min 3-Statement Modeling](https://corporatefinanceinstitute.com/course/3-statement-modeling/) [![Introduction to Business Valuation]() FMVA Required 3h 9min Introduction to Business Valuation](https://corporatefinanceinstitute.com/course/intro-business-valuation/) [![Scenario & Sensitivity Analysis in Excel]() FMVA Required 48min Scenario & Sensitivity Analysis in Excel](https://corporatefinanceinstitute.com/course/sensitivity-analysis-financial-modeling/) [![Excel Data Visualization and Dashboards]() FMVA Required 1h 30min Excel Data Visualization and Dashboards](https://corporatefinanceinstitute.com/course/dashboards-and-data-visualization/) [![Leveraged Buyout (LBO) Modeling]() 4h 33min Leveraged Buyout (LBO) Modeling](https://corporatefinanceinstitute.com/course/leveraged-buyout-lbo-modeling/) [See All Courses See All](https://corporatefinanceinstitute.com/collections/) Recent Searches Suggestions [Excel Courses](https://corporatefinanceinstitute.com/topic/excel/) [Financial Modeling & Valuation Analyst (FMVA)®](https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/) × ### Create a free account to unlock this Template Access and download collection of free Templates to help power your productivity and performance. [Create a Free Account](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/) Already have an account? [Log in](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/) × ### Supercharge your skills with Premium Templates Take your learning and productivity to the next level with our Premium Templates. Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs. [Discover Paid Memberships](https://corporatefinanceinstitute.com/pricing/) Already have a Self-Study or Full-Immersion membership? [Log in](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/) × ### Access Exclusive Templates Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more. [Discover Full-Immersion Membership](https://corporatefinanceinstitute.com/pricing/) Already have a Full-Immersion membership? [Log in](https://corporatefinanceinstitute.com/resources/financial-modeling/pl-profit-and-loss-template/)
Readable Markdown	Download the free Excel templates Published December 27, 2018 Read Time 4 minutes Over 3 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course. [Start Free](https://learn.corporatefinanceinstitute.com/auth/registration) CFI’s Profit and Loss (P\&L) template provides a free downloadable Excel file for creating monthly and annual income statements. The template allows users to enter their data, which is then automatically used to generate financial statements. The following guide includes instructions for using and modifying the templates, highlighting key components like revenue, expenses, and net earnings. The tools are ideal for businesses of all sizes to track financial performance. ## Free Profit and Loss Template (P\&L Template) Download CFI’s free Profit and Loss template (P\&L template) to easily create your own income statement. After downloading the Excel file, simply enter your own information in all of the blue font color cells which will automatically produce a monthly or annual statement as the output. The downloadable Excel file includes four templates. A [Statement of Profit and Loss](https://corporatefinanceinstitute.com/resources/accounting/profit-and-loss-statement-pl/) (also called an [Income Statement](https://corporatefinanceinstitute.com/resources/accounting/income-statement/)) summarizes a company’s income and expenses for a period of time to arrive at its net earnings for the period. ### Download the Template Download the free Excel template now to advance your knowledge of financial modeling. ![Profit and Loss Statement Template Screenshot](https://cdn.corporatefinanceinstitute.com/assets/00087-Profit-and-Loss-Statement-1024x634.png) ## How to Use the Profit and Loss Template Here are the steps to follow to effectively use your templates: 1. Download the Excel file (see [all free templates](https://corporatefinanceinstitute.com/topic/financial-modeling/)) 2. Use the monthly or annual worksheet, depending on what type of statement you want to produce 3. Replace all the blue cells that contain hard-coded numbers with your company’s information 4. Double-check to ensure all the formulas in black cells are working properly 5. Save as a new file and consider saving a version as PDF as well as XLS The two types of templates included in the file are shown below. ### 1\. Monthly Profit and Loss Template (P\&L Template) The monthly P\&L template is perfect for businesses that require regular reporting and detail. By showing all of the information in a series of monthly columns, much more detail is visible than if only the annual figures were shown. The monthly profit and loss template is perfect for small, medium, and large businesses as it can easily be adjusted to add or eliminate detail as required. Learn more about [monthly cash flow forecast modeling](https://corporatefinanceinstitute.com/resources/financial-modeling/monthly-cash-flow-forecast-model/). Fill out the form above to download the Excel file. ![Download Monthly Profit and Loss Template (P\&L Template)](https://cdn.corporatefinanceinstitute.com/assets/profit-and-loss-monthly-1024x670.png) ### 2\. Annual Profit and Loss Template (P\&L Template) For businesses that have been in operation for several years, it may be helpful to show an annual (full [fiscal year](https://corporatefinanceinstitute.com/resources/accounting/fy-fiscal-year/) or [year-to-date](https://corporatefinanceinstitute.com/resources/accounting/year-to-date-ytd/)) statement. The annual profit and loss template below follows the same format and structure as the monthly version, however, it doesn’t have a total column at the end that sums up each of the periods. This template is ideal for any size business and can easily be changed by adding or removing line items (rows) as necessary. It is also useful for performing [year-over-year (YoY) analysis](https://corporatefinanceinstitute.com/resources/financial-modeling/year-over-year-analysis-yoy-template/). Fill out the form above to download the free annual P\&L template Excel file. ![Download Annual Profit and Loss Template (P\&L Template)](https://cdn.corporatefinanceinstitute.com/assets/profit-and-loss-annual.png) ## Components of the P\&L Template While each income statement is unique to every company, there are many common line items that you will see over and over again. The most common P\&L line items include: - [Revenue streams](https://corporatefinanceinstitute.com/resources/accounting/revenue-streams/) (also called sales streams) - Returns, Refunds, Discounts - Total Net Revenue - [Cost of Goods Sold](https://corporatefinanceinstitute.com/resources/accounting/cost-of-goods-sold-cogs/) - [Gross Profit](https://corporatefinanceinstitute.com/resources/accounting/gross-profit/) - Advertising & Promotion - [Depreciation](https://corporatefinanceinstitute.com/resources/accounting/what-is-depreciation-expense/) & Amortization - Rent and Office - Salaries, Benefits & Wages - Telecommunication - Travel - Utilities - [Selling, General & Administrative](https://corporatefinanceinstitute.com/resources/accounting/what-is-sga/) (SG\&A) - [Earnings Before Interest & Taxes](https://corporatefinanceinstitute.com/resources/valuation/ebit/) (EBIT) - [Interest Expense](https://corporatefinanceinstitute.com/resources/accounting/interest-expense/) - [Earnings Before Taxes](https://corporatefinanceinstitute.com/resources/accounting/earnings-before-tax-ebt/) (EBT) - [Income Taxes](https://corporatefinanceinstitute.com/resources/accounting/accounting-for-income-taxes/) - [Net Earnings](https://corporatefinanceinstitute.com/resources/accounting/what-is-net-income/) ## How to Modify the Profit and Loss Template All the [CFI templates](https://corporatefinanceinstitute.com/topic/financial-modeling/) included in the free Excel file can be easily edited and changed to suit your own business. If you require more line items, simply insert additional rows in the section where you need to add revenues or expenses. Then, check to make sure the formulas adding up the totals capture those new rows. If you need to remove line items from the templates, simply delete unnecessary rows and ensure all formulas are still working properly. To learn more about the details of financial reporting, check out PWC’s free guide to financial statement presentation [here](https://viewpoint.pwc.com/dt/us/en/pwc/accounting_guides/financial_statement_/financial_statement___18_US/chapter_1_general_pr_US/11_chapter_overview__4_US.html). Connect what you just learned to a clear career path with CFI’s role‑based courses and certification programs. ## Additional Resources Thank you for checking out CFI’s free templates for making your own annual and monthly P\&L statements in Excel. To keep learning and advancing your career as a [certified financial analyst](https://corporatefinanceinstitute.com/certifications/financial-modeling-valuation-analyst-fmva-program/), these additional resources will be helpful: - [Analysis of Financial Statements](https://corporatefinanceinstitute.com/resources/accounting/analysis-of-financial-statements/) - [What is Financial Modeling?](https://corporatefinanceinstitute.com/resources/financial-modeling/what-is-financial-modeling/) - [Valuation Methods](https://corporatefinanceinstitute.com/resources/valuation/valuation/) - [DCF Financial Modeling Guide](https://corporatefinanceinstitute.com/resources/financial-modeling/dcf-model-training-free-guide/) [See all Excel resources](https://corporatefinanceinstitute.com/topic/excel/) [See all Financial Modeling resources](https://corporatefinanceinstitute.com/topic/financial-modeling/)
Shard	68 (laksa)
Root Hash	407738686562150068
Unparsed URL	com,corporatefinanceinstitute!/resources/financial-modeling/pl-profit-and-loss-template/ s443