{"id":38940,"date":"2022-02-21T11:55:40","date_gmt":"2022-02-21T10:55:40","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=38940"},"modified":"2026-08-22T15:37:25","modified_gmt":"2026-08-22T13:37:25","slug":"modelo-de-demonstracao-de-resultados-2","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-templates\/profit-and-loss-statement-template\/","title":{"rendered":"Modelo de demonstra\u00e7\u00e3o de lucros e perdas"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

A profit and loss statement and an income statement are the same report, under two different names.<\/strong> The free Sheetgo template in this article is published as the Income statement template<\/strong>, so that is the name you\u2019ll see when you open the file. What it produces is your P&L.<\/p>\n

A profit and loss statement is one of the three financial statements most businesses have to produce regularly. It gives you a clear picture of your revenue, costs, and expenses over a set period. You need it to know where your business stands, and lenders, investors, and tax authorities often ask for one too. Pulling all that financial data together by hand takes time. Hire an external accountant and it costs money; do it in-house by copying and pasting between spreadsheets and you invite mistakes. The Sheetgo income statement template gives you a third option: one Google Sheets file where you log what comes in and what goes out, and the statement is worked out for you.<\/p>\n

Most businesses already keep their financial information in Google Sheets, and for good reason. It\u2019s cloud-based, so your team can reach it from anywhere, and several people can enter the latest figures without emailing versions back and forth. The Sheetgo income statement template is built on Google Sheets for those same reasons.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Is a profit and loss statement the same as an income statement?<\/h2>\n

Yes. Profit and loss statement, P&L, and income statement all describe the same report: revenue in, costs out, and the profit or loss left over for the period. Which of the three names you see depends on the country and on the habit of the finance team writing it.<\/p>\n

That\u2019s why the template you copy below is called the Income statement template<\/strong>. Everything it gives you is your profit and loss statement.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Why use the Sheetgo profit and loss statement template?<\/h2>\n

The Sheetgo income statement template is a single Google Sheets file that turns the income and expenses you log into a month-by-month profit and loss statement. You copy it to your own Google Drive, clear the sample data, and start entering your own figures. There\u2019s nothing to connect and no account to create.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Build your profit and loss statement<\/span><\/span> in Google Sheets<\/h4>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1R-mcM8mlKvp8ZIVkRExDdrJry0FwEzqPKsR_j2hOS8E\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.27.4″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#FFFFFF” button_bg_color=”#2979FF” button_border_width=”0px” button_border_color=”#2979FF” button_border_radius=”6px” button_font=”|600|||||||” button_use_icon=”off” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|20px|15px|20px|true|false” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_text_color__hover_enabled=”on|desktop” button_border_color__hover_enabled=”on|hover” button_border_color__hover=”#2666E2″ button_text_color__hover=”#FFFFFF” button_bg_color__hover=”#2666E2″ button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Here are a few more reasons to keep your profit and loss statement in a spreadsheet-based template:<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

    \n
  • Flexible<\/strong>: No matter what kind of business you run, Google Sheets allows you to build a tailor-made system. You can adapt it as needs change, without any new software.<\/li>\n
  • Accessible<\/strong>: You and your coworkers can access, share, and work with all of your financial data from any corner of the world. All you need is an internet connection.<\/li>\n
  • Compatible with everything<\/strong>: Google Sheets sits comfortably alongside the rest of your finance stack. You can download the file as Excel, CSV, or PDF whenever your accountant, your bank, or your board asks for a particular format.<\/li>\n
  • Easy to use<\/strong>: There\u2019s no need to onboard your team as they\u2019ll already be working with spreadsheets on a daily basis. Maintenance is easy and there\u2019s no need for IT support.<\/li>\n<\/ul>\n

    [\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

    Here is what\u2019s inside the file, and how to get your first statement out of it.<\/p>\n

    [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

    How to use the profit and loss statement template<\/h3>\n

    The Sheetgo income statement template is one Google Sheets file. You copy it into your own Google Drive, and everything happens inside that single file.<\/p>\n

    Alongside a Read me<\/strong> tab that explains how the file fits together, you get:<\/p>\n

      \n
    • Inputs<\/strong>: the year you want to report on, plus a small table that sets how an amount is spread over time.<\/li>\n
    • Income Input<\/strong>: log the money your business receives.<\/li>\n
    • Expenses Input<\/strong>: log what your business spends.<\/li>\n
    • Income Statement Monthly<\/strong>: your profit and loss statement, month by month, worked out from the two input tabs.<\/li>\n
    • Income Summary per Month<\/strong> and Expenses Summary per Month<\/strong>: each side of the statement broken down on its own.<\/li>\n
    • Income Accrual Mapping<\/strong>: shows how each income entry is spread across periods, following the table in Inputs<\/strong>.<\/li>\n<\/ul>\n

      The formulas do the arithmetic, so the statement and the summary tabs move as soon as you add a row.<\/p>\n

      [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 1: Make your own copy of the template<\/h4>\n

      Click the button below. Google will ask you to save a copy of the file to your own Google Drive, and that copy is yours to edit.<\/p>\n

      [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1R-mcM8mlKvp8ZIVkRExDdrJry0FwEzqPKsR_j2hOS8E\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.27.7″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#FFFFFF” button_bg_color=”#2979FF” button_border_width=”0px” button_border_color=”#2979FF” button_border_radius=”6px” button_font=”|600|||||||” button_use_icon=”off” custom_padding=”15px|20px|15px|20px|true|false” hover_enabled=”0″ global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_text_color__hover_enabled=”on|desktop” button_border_color__hover_enabled=”on|hover” button_border_color__hover=”#2666E2″ button_text_color__hover=”#FFFFFF” button_bg_color__hover=”#2666E2″ button_bg_enable_color__hover=”on” theme_builder_area=”post_content” custom_margin=”30px||30px||true|false” sticky_enabled=”0″][\/et_pb_button][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 2: Set the year you want to report on<\/h4>\n

      Open the Inputs<\/strong> tab and enter the year you want to report on. Underneath it, the accrual periods table controls how an amount is spread over time: leave a period on Immediate<\/strong> to count the full amount straight away, or set it to 5 years<\/strong> to divide it across five.<\/p>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/income-statement-inputs-2.png” alt=”Inputs tab of the Sheetgo income statement template, with the year to report on and the accrual periods table” title_text=”Income statement template Inputs tab” align=”center” _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 3: Enter your income<\/h4>\n

      Go to the Income Input<\/strong> tab, delete the sample rows, and log the money your business receives. Each row is one entry, so you can keep adding as the year goes on.<\/p>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/income-statement-income-input-2.png” alt=”Income Input tab of the profit and loss statement template in Google Sheets, with sample revenue rows” title_text=”Income statement template Income Input tab” align=”center” _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      From those entries the template fills in the Income Summary per Month<\/strong> and Income Accrual Mapping<\/strong> tabs. You don\u2019t type anything into either one; the figures there come from what you logged in Income Input<\/strong>.<\/p>\n

      [\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 4: Enter your expenses<\/h4>\n

      Do the same on the Expenses Input<\/strong> tab: clear the sample rows and log what your business spends, one row per item.<\/p>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/income-statement-expenses-input-2.png” alt=”Expenses Input tab of the Sheetgo income statement template in Google Sheets” title_text=”Income statement template Expenses Input tab” align=”center” _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      The Expenses Summary per Month<\/strong> tab then lays your monthly spending out side by side, calculated from those rows.<\/p>\n

      [\/et_pb_text][et_pb_text _builder_version=”4.21.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Step 5: Read your profit and loss statement<\/h4>\n

      The Income Statement Monthly<\/strong> tab is the report itself. It draws on both input tabs, works out the totals and subtotals for each section, and lays out your profit and loss for every month of the year you set in Inputs<\/strong>.<\/p>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/income-statement-monthly-2.png” alt=”Income Statement Monthly tab showing a month-by-month profit and loss statement in Google Sheets” title_text=”Income statement template Income Statement Monthly tab” align=”center” _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      How do I make a P&L statement?<\/h3>\n

      Log what comes in, log what goes out, and let the formulas handle the rest. The Sheetgo income statement template gives you a profit and loss statement that keeps up with the figures you enter, in a Google Sheets file you own and can shape around the way your business reports.<\/p>\n

      [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_orientation=”center” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Start building your profit and loss statement<\/span><\/span><\/h3>\n

      [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1R-mcM8mlKvp8ZIVkRExDdrJry0FwEzqPKsR_j2hOS8E\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.27.4″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#FFFFFF” button_bg_color=”#2979FF” button_border_width=”0px” button_border_color=”#2979FF” button_border_radius=”6px” button_font=”|600|||||||” button_use_icon=”off” custom_padding=”15px|20px|15px|20px|true|false” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_text_color__hover_enabled=”on|desktop” button_border_color__hover_enabled=”on|hover” button_border_color__hover=”#2666E2″ button_text_color__hover=”#FFFFFF” button_bg_color__hover=”#2666E2″ button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

      Frequently asked questions<\/h2>\n

      [\/et_pb_text][difl_faq faq_item_gap=”25px” enable_schema=”on” close_icon_color=”#82afff” close_icon_size=”28px” open_icon_color=”#82afff” faq_anime_duration=”200″ faq_item_wrapper_bg_bgcolor=”#FFFFFF” que_text_margin=”10px|20px|10px|20px|true|true” ans_text_padding=”0px|20px|10px|20px|false|true” _builder_version=”4.27.6″ _module_preset=”default” question_text_font=”|600|||||||” question_text_font_size=”19px” design_answer_text_font=”|300|||||||” design_answer_text_font_size=”16px” design_answer_text_line_height=”1.6em” border_radii_faq_item_wrapper_border=”on|12px|12px|12px|12px” border_color_all_faq_item_wrapper_border=”#deeaf7″ global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”][difl_faqitem question=”Is a profit and loss statement the same as an income statement?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n

      Yes. They are two names for the same report. The template is named Income statement and produces exactly what a profit and loss statement shows.<\/p>\n

      [\/difl_faqitem][difl_faqitem question=”Is the template free?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n

      Yes. It is a Google Sheets file you copy to your own Drive and keep. There is nothing to install and no account to create.<\/p>\n

      [\/difl_faqitem][difl_faqitem question=”Do I have to build the formulas myself?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n

      No. You type revenue into the Income Input tab and costs into the Expenses Input tab; the Income Statement Monthly tab is already built.<\/p>\n

      [\/difl_faqitem][\/difl_faq][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

      A profit and loss statement and an income statement are the same report, under two different names. The free Sheetgo template in this article is published as the Income statement template, so that is the name you\u2019ll see when you open the file. What it produces is your P&L. A profit and loss statement is […]<\/p>\n","protected":false},"author":41,"featured_media":38963,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-38940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-templates","tag-finance"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/38940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=38940"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/38940\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/38963"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=38940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=38940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=38940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}