[\/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\/cashflow” 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 admin_label=”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
Why use Google Sheets for cash flow management?<\/h3>\n\n- Flexible: 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: 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: Every other piece of software in the world integrates with Google Sheets. As a result, you can easily pull together income and expenses data from multiple departments simultaneously.<\/li>\n
- Easy to use: 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.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to get started<\/h3>\n
Sheetgo’s cash flow template streamlines cash management, automating updates, payment tracking, and report generation, reducing manual data entry and ensuring accuracy. It separates accounts payable and receivable, offers customization, and integrates data from various accounts for insightful decision-making. It’s a practical tool for optimizing financial management.<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
What you get with this template:<\/h3>\n
The Cash Flow Template has three main files:<\/p>\n
\n- A Receipts spreadsheet: This is where the individual or team responsible records money coming into the company. This might include data from customer sales, clients, bank loans, etc.<\/li>\n
- A Payments spreadsheet: In this file, the person responsible records money leaving the company. This may include operational costs, payments to suppliers, staff wages, taxes, and so on.<\/li>\n
- A Cash Flow master spreadsheet: This is for the manager, containing automated dashboards. Data flows into this file directly from the payments and receipts spreadsheets, via Sheetgo connections.<\/li>\n<\/ol>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_overview.png” alt=”Cash flow template ” title_text=”Cash flow template_overview” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to start using the template<\/h3>\n
Click on the button below to install the free template:<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/cashflow” 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|30px|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” 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.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to use the cash flow template<\/h3>\nStep 1: Enter the settings for your cash flow monitor<\/h4>\n
In the Cash Flow Instructions<\/b> tab, enter the start date for the time period you want to analyze and your starting balance.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_master-sheet.png” alt=”Cash flow template master file” title_text=”Cash flow template_master sheet” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Start entering data<\/h4>\n
The Payments<\/strong> and Receipts<\/strong> files are provided with sample data, to show you how the template works. You can simply delete or overwrite this data and start logging entries in your spreadsheet.<\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_input.png” alt=”Cash flow template inputs” title_text=”Cash flow template_input” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 3: Schedule automatic updates so all your files are up-to-date<\/h4>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_automate.png” alt=”Cash flow template automation” title_text=”Cash flow template_automate” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/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
Start tracking your cashflow<\/span><\/span> automatically<\/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:\/\/app.sheetgo.com\/templates\/cashflow” 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 admin_label=”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.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Check out the automated reports<\/h4>\n
Once you start entering data into the Payments<\/strong> and the Receipts<\/strong> tabs, the template automatically generates reports in the Payment Analysis<\/strong> and the <\/span>Receipt Analysis<\/strong> tabs.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/Cash-flow-4.png” alt=”Cash flow 4″ title_text=”Cash flow 4″ _builder_version=”4.21.2″ width=”100%” 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 Monthly Cash Flow Chart<\/strong> contains an automated dashboard. Data flows into this file directly from the other tabs. Here you’ll get an overview of all the financial activities.<\/span><\/p>\n[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/Cash-flow-1.png” alt=”Cash flow 1″ title_text=”Cash flow 1″ _builder_version=”4.21.2″ 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” 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 tracking your cashflow<\/span><\/span> automatically<\/h3>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/cashflow” 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":"
Keeping an eye on your cash flow is essential for making good business decisions. And a cash flow statement is one of the key documents that lenders and investors take into account when assessing the general health of a company. For your business to be viable, it must generate enough income (receipts) to cover outgoings […]<\/p>\n","protected":false},"author":39,"featured_media":27395,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"
What is Cash Flow Management?<\/h2>\nSimply put, cash flow is the money going in and out of a business. Think payments, expenses, invoicing, etc. Cash flow management is the careful tracking and analysis of these transactions. There\u2019s no dispute that finances are best tracked in a spreadsheet. You could track cash flow in a static spreadsheet, but this will require a lot of manual work and manipulation when what you really want is a system that will make visualizing and reporting financial data a breeze.<\/span>\nUse Spreadsheets To Manage Cash Flow<\/h2>\nAt Sheetgo, we are committed to developing applicable tools for your business. We don't just provide you with our spreadsheet enhancing add-on, and leave you to it, we provide you with the same real-life solutions that we use ourselves! We created a cash flow template to use as the main tool for managing finances day to day. The Sheetgo Cash Flow Template for Google Sheets is not just a static template with pretty fonts and colors. It's a dynamic, automated cash flow management system based on Google Sheets. Our system includes an Accounts Payable spreadsheet and an Accounts Receivable spreadsheet which are connected using Sheetgo to a third Cash Flow spreadsheet. These three spreadsheets are connected using the Sheetgo add-on to automatically update the data that flows between them. Take a look at the diagram\u00a0below to understand\u00a0how our system works:\n\n[caption id=\"attachment_4399\" align=\"aligncenter\" width=\"456\"]![\"Example:](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/05\/structure-diagram-1.png\")
Sheetgo Cash Flow Template Structure[\/caption]\n\n\u00a0\n
Follow the steps in this simple tutorial to have a single tab in your cash flow sheet that summarizes monthly revenue and costs which are then summed to your\u00a0monthly cash movement\u00a0and bank balance. This information is included\u00a0in a simple graphic that allows you to see these variables daily and can easily be included in a Google Site portal or report for management and investors.<\/p>\n\u00a0 ![\"Example:](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/01\/cashflow2.png\")
\n
<\/h1>\nLet's Set Up Your Custom System<\/h1>\nStep 1. Install the Template<\/h3>\nSheetgo is an add-on for Google Sheets which enables your spreadsheets to \"talk to each other\". Using the Sheetgo add-on allows you to make connections between any kind of spreadsheets stored in your Google Drive. Installing Sheetgo is necessary to make this system work.\u00a0Click here<\/a> to install the template. You will be asked to log in with your Google account as the spreadsheets will be created and saved into your Google Drive. Your Sheetgo account will automatically be created after the Google login.\nStep 2. Install the Sheetgo add-on<\/h3>\nInstall the add-on directly from a Google Sheets spreadsheet by clicking the\u00a0add-ons<\/b>\u00a0button in the navigation menu, then click the\u00a0Get add-ons<\/b>\u00a0button.\u00a0A window will pop up for you to browse. Type \u201cSheetgo\u201d in the search box.\u00a0Click the\u00a0Free<\/b>\u00a0button to get the add-on, and you are ready to start using Sheetgo!\n\n \t- Payments<\/span><\/li>\n \t
- Receipts<\/li>\n \t
- Cashflow (Master spreadsheet)<\/span><\/li>\n<\/ol>\nLet's Break Down the Contents of the Spreadsheets<\/strong>\n
Payments (Accounts Payable)<\/h6>\n\n \t- Instructions<\/li>\n \t
- Accounts Payable<\/li>\n \t
- Suppliers<\/li>\n \t
- General Ledger<\/li>\n<\/ul>\n
Receipts (Accounts Receivable)<\/h6>\n\n \t- Instructions<\/li>\n \t
- Accounts Receivable<\/li>\n \t
- Suppliers<\/li>\n \t
- General Ledger<\/li>\n<\/ul>\n
Cash Flow<\/h6>\n\n \t- Instructions<\/li>\n \t
- AR Import<\/li>\n \t
- AP Import<\/li>\n \t
- Cash Flow<\/li>\n<\/ul>\nYour \u201cCash Flow\u201d spreadsheet will have four tabs on the lower left corner: Instructions<\/strong>, AR Import, AP Import<\/strong>, and Cash Flow<\/strong>. The Instructions sheet provides you with a step-by-step guide to configure your cash flow template. AP Import and AR Import will be linked to the \u201cAccounts Payable\u201d and \u201cAccounts Receivable\u201d spreadsheets that you just copied. Finally, the Cashflow combines Accounts Payable and Accounts receivable to create a dynamic cash flow, updated daily based on your own inputs.<\/span>\n
This will create three new sheets in your Spreadsheet: Instructions, AR Import, AP Import, and Cashflow. The Instructions sheet provides you with a step-by-step guide to configure your cashflow template. AP Import and AR Import are linked to external spreadsheets that you will configure with your own accounts payable and receivable. Finally, the Cashflow combines Accounts Payable and Accounts receivable to create a dynamic cash flow, updated daily based on your own imports.<\/p>\n\n
Step 3. Configure the Cash Flow Template<\/h2>\n
Each\u00a0template spreadsheet has an instructions tab that will explain step by step the process to fill in and configure the template. You'll need to have your finances handy to fill out the accounts payable and accounts receivable templates with your revenue and expenses from the past few months. Once filled out you will then connect to the cash flow spreadsheet using Sheetgo.<\/p>\n\n
Congrats!<\/h2>\n
You've configured your Google Sheets cash flow template. Feel free to adapt it as you see fit to meet the needs of your business, and visit our blog<\/a> to learn more about how you can use Google Sheets to improve the way you work. If you have had difficulty making this template work, please contact us through the help center<\/a>\u00a0and we will be happy to assist you with setting it up.<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-4393","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\/4393","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=4393"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/4393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27395"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=4393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=4393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=4393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to get started<\/h3>\n
Sheetgo’s cash flow template streamlines cash management, automating updates, payment tracking, and report generation, reducing manual data entry and ensuring accuracy. It separates accounts payable and receivable, offers customization, and integrates data from various accounts for insightful decision-making. It’s a practical tool for optimizing financial management.<\/span><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Cash Flow Template has three main files:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_overview.png” alt=”Cash flow template ” title_text=”Cash flow template_overview” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click on the button below to install the free template:<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/cashflow” 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|30px|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” 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.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the Cash Flow Instructions<\/b> tab, enter the start date for the time period you want to analyze and your starting balance.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_master-sheet.png” alt=”Cash flow template master file” title_text=”Cash flow template_master sheet” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Payments<\/strong> and Receipts<\/strong> files are provided with sample data, to show you how the template works. You can simply delete or overwrite this data and start logging entries in your spreadsheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_input.png” alt=”Cash flow template inputs” title_text=”Cash flow template_input” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/Cash-flow-template_automate.png” alt=”Cash flow template automation” title_text=”Cash flow template_automate” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/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 [\/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\/cashflow” 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 admin_label=”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.21.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once you start entering data into the Payments<\/strong> and the Receipts<\/strong> tabs, the template automatically generates reports in the Payment Analysis<\/strong> and the <\/span>Receipt Analysis<\/strong> tabs.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/Cash-flow-4.png” alt=”Cash flow 4″ title_text=”Cash flow 4″ _builder_version=”4.21.2″ width=”100%” 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 Monthly Cash Flow Chart<\/strong> contains an automated dashboard. Data flows into this file directly from the other tabs. Here you’ll get an overview of all the financial activities.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/08\/Cash-flow-1.png” alt=”Cash flow 1″ title_text=”Cash flow 1″ _builder_version=”4.21.2″ 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” 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\/cashflow” 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":" Keeping an eye on your cash flow is essential for making good business decisions. And a cash flow statement is one of the key documents that lenders and investors take into account when assessing the general health of a company. For your business to be viable, it must generate enough income (receipts) to cover outgoings […]<\/p>\n","protected":false},"author":39,"featured_media":27395,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":" Follow the steps in this simple tutorial to have a single tab in your cash flow sheet that summarizes monthly revenue and costs which are then summed to your\u00a0monthly cash movement\u00a0and bank balance. This information is included\u00a0in a simple graphic that allows you to see these variables daily and can easily be included in a Google Site portal or report for management and investors.<\/p>\n\u00a0 This will create three new sheets in your Spreadsheet: Instructions, AR Import, AP Import, and Cashflow. The Instructions sheet provides you with a step-by-step guide to configure your cashflow template. AP Import and AR Import are linked to external spreadsheets that you will configure with your own accounts payable and receivable. Finally, the Cashflow combines Accounts Payable and Accounts receivable to create a dynamic cash flow, updated daily based on your own imports.<\/p>\n\n Each\u00a0template spreadsheet has an instructions tab that will explain step by step the process to fill in and configure the template. You'll need to have your finances handy to fill out the accounts payable and accounts receivable templates with your revenue and expenses from the past few months. Once filled out you will then connect to the cash flow spreadsheet using Sheetgo.<\/p>\n\n You've configured your Google Sheets cash flow template. Feel free to adapt it as you see fit to meet the needs of your business, and visit our blog<\/a> to learn more about how you can use Google Sheets to improve the way you work. If you have had difficulty making this template work, please contact us through the help center<\/a>\u00a0and we will be happy to assist you with setting it up.<\/p>","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-4393","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\/4393","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=4393"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/4393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27395"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=4393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=4393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=4393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What you get with this template:<\/h3>\n
\n
How to start using the template<\/h3>\n
How to use the cash flow template<\/h3>\n
Step 1: Enter the settings for your cash flow monitor<\/h4>\n
Step 2: Start entering data<\/h4>\n
Step 3: Schedule automatic updates so all your files are up-to-date<\/h4>\n
Start tracking your cashflow<\/span><\/span> automatically<\/h4>\n
Step 4: Check out the automated reports<\/h4>\n
Start tracking your cashflow<\/span><\/span> automatically<\/h3>\n
What is Cash Flow Management?<\/h2>\nSimply put, cash flow is the money going in and out of a business. Think payments, expenses, invoicing, etc. Cash flow management is the careful tracking and analysis of these transactions. There\u2019s no dispute that finances are best tracked in a spreadsheet. You could track cash flow in a static spreadsheet, but this will require a lot of manual work and manipulation when what you really want is a system that will make visualizing and reporting financial data a breeze.<\/span>\n
Use Spreadsheets To Manage Cash Flow<\/h2>\nAt Sheetgo, we are committed to developing applicable tools for your business. We don't just provide you with our spreadsheet enhancing add-on, and leave you to it, we provide you with the same real-life solutions that we use ourselves! We created a cash flow template to use as the main tool for managing finances day to day. The Sheetgo Cash Flow Template for Google Sheets is not just a static template with pretty fonts and colors. It's a dynamic, automated cash flow management system based on Google Sheets. Our system includes an Accounts Payable spreadsheet and an Accounts Receivable spreadsheet which are connected using Sheetgo to a third Cash Flow spreadsheet. These three spreadsheets are connected using the Sheetgo add-on to automatically update the data that flows between them. Take a look at the diagram\u00a0below to understand\u00a0how our system works:\n\n[caption id=\"attachment_4399\" align=\"aligncenter\" width=\"456\"]
Sheetgo Cash Flow Template Structure[\/caption]\n\n\u00a0\n\n<\/h1>\n
Let's Set Up Your Custom System<\/h1>\n
Step 1. Install the Template<\/h3>\nSheetgo is an add-on for Google Sheets which enables your spreadsheets to \"talk to each other\". Using the Sheetgo add-on allows you to make connections between any kind of spreadsheets stored in your Google Drive. Installing Sheetgo is necessary to make this system work.\u00a0Click here<\/a> to install the template. You will be asked to log in with your Google account as the spreadsheets will be created and saved into your Google Drive. Your Sheetgo account will automatically be created after the Google login.\n
Step 2. Install the Sheetgo add-on<\/h3>\nInstall the add-on directly from a Google Sheets spreadsheet by clicking the\u00a0add-ons<\/b>\u00a0button in the navigation menu, then click the\u00a0Get add-ons<\/b>\u00a0button.\u00a0A window will pop up for you to browse. Type \u201cSheetgo\u201d in the search box.\u00a0Click the\u00a0Free<\/b>\u00a0button to get the add-on, and you are ready to start using Sheetgo!\n
\n \t
Payments (Accounts Payable)<\/h6>\n
\n \t
Receipts (Accounts Receivable)<\/h6>\n
\n \t
Cash Flow<\/h6>\n
\n \t
Step 3. Configure the Cash Flow Template<\/h2>\n
Congrats!<\/h2>\n