[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”54px|0px|2px|0px|false|false” 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″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
For small to medium-sized enterprises (SMEs), creating an income statement can be a time-consuming and costly process. Also referred to as a profit and loss statement <\/strong>(PnL), revenue statement<\/strong>, or operating expenses statement<\/strong>, an income statement helps you measure the performance of your company. On top of that,\u00a0 it can be used to secure financing as well as to calculate and pay taxes.<\/p>\n An income statement is one of the three main financial statements for reporting. It summarizes company revenues and expenses over a specific period of time. It differs from a cash flow statement in that it is based on the accrual of expenses and revenues for accounting purposes rather than for payment. Finally, there is the balance sheet, which summarizes your assets and liabilities.<\/p>\n Essentially, an income statement shows directors and investors whether or not the company made money during that accounting period.<\/p>\n Normally, you have to manually collect and enter data into accounting software to create an income statement. Many small companies send that data to an external accountant … and then wait for the accountant to process it.<\/p>\n Using an income statement template enables you to generate your own income statements automatically, in-house, with the data you already have.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AIS1.png” alt=”income-statement-dashboard” title_text=”AIS1″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This spreadsheet-based workflow template is a pre-built system that allows you to pull together real-time income and expenses data from across the company. The template merges this data to generate an automated monthly income statement, as well as income and expenses reports.<\/p>\n The template can be used by companies of all sizes. It provides teams with a user-friendly way to collect and share income and expenses data while generating automated reports and dashboards for accountants and company directors.[\/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” ab_subject=”on” ab_subject_id=”2″ locked=”off” 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 [\/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:\/\/app.sheetgo.com\/templates\/income-statement” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” ab_goal=”on” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” 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″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n A regular spreadsheet template is a single file containing pre-built charts and formulas. In contrast, a Sheetgo workflow template is an interconnected system. It consists of multiple Google Sheets files that transfer data between them.<\/p>\n This allows team members to work in their own private spreadsheet while sharing data with managers automatically. As a result, accountants and company directors get an automated income statement, without having to gather and collate data manually.<\/p>\n Generate automated income reports from your spreadsheet data:<\/em><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Income-statement-\u2013-1.png” alt=”income-statement-accrual-mapping-input” title_text=”Income statement \u2013 1″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n When you install the Sheetgo Income Statement template, three Google Sheets files with pre-built Sheetgo connections are saved to your Google Drive:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Income-statement-template_overview.png” alt=”Income statement template” title_text=”Income statement template_overview” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click the blue button below to get started.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/income-statement” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|20px|0px|false|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” locked=”off” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The income statement master sheet opens inside Sheetgo.<\/p>\n To open the Income Inputs <\/strong>or Expenses Inputs<\/strong> file, click Workflow<\/strong> in the sidebar on the side of the screen.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Income-statement-\u2013-2.png” alt=”income-statement-open-workflow-bar” title_text=”Income statement \u2013 2″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Firstly, you need to select which year you want to create a statement for. In the Income Statement master sheet, go to the Instructions<\/strong> tab and enter the year in the Initial Input<\/strong> box.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AIS4.png” alt=”income-statement-initial-input-year” title_text=”AIS4″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Secondly, open the Income Inputs<\/strong> file by clicking on Workflow<\/strong> on the side of the screen.<\/p>\n This is the spreadsheet where your colleague(s) responsible for processing invoices can enter company income.<\/p>\n In the Instructions<\/strong> tab, enter the year.<\/p>\n Note that the Income<\/strong> tab contains sample data to show you how the template works. You or your colleague can simply delete this data or overwrite it.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AIS5.png” alt=”income-inputs-income-tab” title_text=”AIS5″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To share this spreadsheet with your accountant or the person responsible for processing invoices and income, click Edit in new<\/strong> and the file will open in a new tab in your browser.<\/p>\n If you want to automate the data entry process, you can connect other spreadsheets to this file using Sheetgo connections. You can also use Google Forms<\/a> to ensure data validation and gather data from other departments without sharing this file.<\/p>\n Once your colleagues have started entering data in the Income<\/strong> tab, the template creates automated income reports in the Accrual Mapping<\/strong> and Summary per Month<\/strong> tabs automatically.<\/p>\n As you can see, these tabs have a padlock icon to remind you not to edit this data.<\/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” locked=”off” 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 [\/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:\/\/app.sheetgo.com\/templates\/income-statement” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” 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″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AIS6.png” alt=”income-statement-summary-per-month” title_text=”AIS6″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The other spreadsheet in the template is Expenses Inputs<\/strong>.<\/p>\n In this file, your colleague should enter all invoices paid in the Expenses<\/strong> tab.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AIS7.png” alt=”income-statement-expenses-sheet-expenses-tab” title_text=”AIS7″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As with the Income Inputs sheet, you can also connect Google Forms or other spreadsheets to this file. If you have other departments and colleagues processing payments, this will enable you to gather and collate that data automatically.<\/p>\n Again, you can share the Expenses Inputs sheet with your colleagues by clicking Edit in new <\/strong>> Share<\/strong>.<\/p>\n The template uses the data in the Expenses<\/strong> tab to automate an Expenses report<\/strong> in the Summary per Month<\/strong> tab.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AIS8.png” alt=”income-statement-expenses-sheet-summary-per-month” title_text=”AIS8″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once you have shared the Income and Expenses Inputs sheets with your colleagues and they have started to log payments and receipts, you need to bring this data back to the Automated Income Statement master sheet.<\/p>\n To do this, click Run<\/strong> and Sheetgo will update both the connections in the workflow.<\/p>\n The Sheetgo connections import data from the Expenses and Income Inputs spreadsheets into the master sheet.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Income-statement-8.png” alt=”income-statement-run-workflow” title_text=”Income statement 8″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]The template creates an automated Expenses report<\/strong> and a separate Income report<\/strong>.<\/p>\n The pre-written formulas in the template use this data to generate the automated Income Statement<\/strong>.<\/p>\n Now that the template is up and running, you can schedule automatic transfers.<\/p>\n This will ensure that your Income Statement, Expenses\/Income reports always contain the latest data from the Input spreadsheets.<\/p>\n Data will flow at regular intervals without you having to open a spreadsheet or open Sheetgo.<\/p>\n Go to Workflow <\/strong> and click Automate<\/strong>.<\/p>\n Choose how frequently you want Sheetgo to transfer the data: from once an hour to once a month.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Income-statement-\u2013-4.png” alt=”income-statement-automate” title_text=”Income statement \u2013 4″ _builder_version=”4.16″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/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” locked=”off” 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 [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/income-statement” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" For small to medium-sized enterprises (SMEs), creating an income statement can be a time-consuming and costly process. Also referred to as a profit and loss statement (PnL), revenue statement, or operating expenses statement, an income statement helps you measure the performance of your company. On top of that,\u00a0 it can be used to secure financing […]<\/p>\n","protected":false},"author":39,"featured_media":27398,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":" 3.1 Connecting your Income Inputs Spreadsheet to the Template<\/strong><\/p>\n 1. Inside the Income Inputs Spreadsheet, in the menu, click on add-ons > Sheetgo > Start.\nOnce installed, go to the P&L Spreadsheet, in the menu, click on add-ons<\/strong> > Sheetgo<\/strong> > Start<\/strong>.\n2. Click on the green + button and select file \u201c1 Income Inputs Spreadsheet\u201d.\n3. Select the tab \"Income\"\n4. In settings, click on \"enable transfer formatting\"\n5. Finally, we click on the \u201cSave Connection\u201d button.<\/p>\n 3.2 Connecting your Expenditures Spreadsheet to the Template<\/strong><\/p>\n 1. Inside the Expenditures Spreadsheet, in the menu, click on add-ons > Sheetgo > Start.\n2. Click on the green +<\/span> button and select the file \u201c2 Expenditures Spreadsheet\u201d.\n3. Select the tab \"Expenditures\"\n4. In settings, click on \"enable transfer formatting\"\n5. Finally, we click on the \u201cSave Connection\u201d button.<\/p>\n 3.3 Updating the Profit and Loss Statement Spreadsheet<\/strong><\/p>\n Inside the Profit and Loss (P&L) Spreadsheet, open the Sheetgo add-on. You will see the 2 connections that you've created. Simply click on the arrows within the Sheetgo add-on to bring the data from your Income and Expenditures to your Income Statement spreadsheet.<\/p>\n\nWhy use Google Sheets to create an income statement?<\/h3>\n
\n
How to get started<\/h3>\n
Sign up for Sheetgo and start generating your income statement<\/span><\/span> automatically<\/h4>\n
What\u2019s a spreadsheet-based workflow template?<\/h3>\n
A spreadsheet-based workflow template gives you:<\/h5>\n
\n
What you get with this template:<\/h3>\n
\n
How to install the workflow template<\/h3>\n
\n
How the template works<\/h3>\n
How to use the income statement template<\/h3>\n
Step 1: Set up the master sheet<\/h4>\n
Step 2: Configure the Income Inputs sheet<\/h4>\n
Start generating your income statement<\/span><\/span> automatically<\/h4>\n
Step 3: Share the Expenses Inputs sheet<\/h3>\n
Step 4: Transfer the data<\/h3>\n
Step 5: Automate the workflow<\/h4>\n
Start generating your income statement<\/span><\/span> automatically<\/h3>\n
What is the Income Statement Template?<\/h1>\nThe income statement is one of the three main Financial Statements<\/em> that a company must maintain. It summarizes your revenues and expenses<\/em> over a period of time. It differs from a Cash Flow Statement<\/em> in that it is based on the accrual<\/em> of expenses and revenues for accounting<\/em> purposes instead of the payment. It is frequently presented to managers and investors to communicate the profit or loss<\/em> during a certain period (different from a balance sheet<\/em> which summarizes your assets and liabilities<\/em>). You may also know a Profit and Loss Statement<\/em> as Profit and Loss Account<\/em>, Income Statement<\/em>, Revenue Statement<\/em>, Operating Expenses\/Statement<\/em>, or simply PnL<\/em>.\n
Why you should have your Income Statement Automated in Google Sheets<\/h1>\nYour finances are undoubtedly best managed in spreadsheets. However,it can require lots of manual work, and potential data loss with copy-pasting. We, therefore, created a plug and play system in the shape of a Template for you to visualize and report financial data<\/em>.\n\nIncome statements<\/em> are used to calculate and pay taxes<\/em> to your local authorities and are used for securing financing and measuring the performance of a company. Normally, Small to Medium Business<\/em>\u00a0(SMBs)<\/em> needs to devote money and time to input data into accounting software<\/em> or spend time collecting all their information and sending to the external accountants<\/em>, and wait until the accountant<\/em> has time to process them.\u00a0With an easily automated Income Statement Template<\/em>, you can have a daily view of your Profit and Loss<\/em>. Calculating profit margins<\/em>, generating reports<\/em> for investors and preparing income statements<\/em> at the end of the year become simpler and painless processes.\n
Simple Technology to get this Sheet done!<\/h1>\nThe services that we will be used to set up your template are:\n
\n \t
Instructions<\/h2>\n
Step 1. Copy the Template Sheets<\/h3>\nClick on the links below and select \u201cMake a Copy<\/strong>\u201d and your copy will open in Google Sheets, and be automatically saved into your Google Drive<\/em>.\n
\n \t
Step 2. Install the Google Sheets add-on Sheetgo<\/h3>\nClick here to install Sheetgo<\/a>. Don\u2019t worry, it\u00b4s a free add-on for Google Sheets to connect your spreadsheets<\/strong>, and much more! The add-on is necessary to connect and automate the spreadsheets to get your P&L Template in Google Sheets.\n
Step 3. Configure the PnL Template<\/h3>\n
Awesome, you did it!<\/h1>\nCongrats, you\u2019ve configured your Google Sheets Profit and Loss Template using Google Sheets.\n
In need of a Cash Flow Template?<\/h1>\nWe\u2019ve got you covered! Click here to install our Cash Flow Template<\/a>.\n\nFeel free to share<\/strong> your feedback or suggestions for new templates in the comments below, or click on the chat button below on your right! <3","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-11895","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-templates","tag-finance"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/11895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=11895"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/11895\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27398"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=11895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=11895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=11895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}