[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-chart-2.png” alt=”Monthly Cash Flow Chart tab plotting cash balance, receivables and payables in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Cash Flow Analysis tab” _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
Copy the free cash flow template<\/span><\/span><\/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\/15u4WIS4YJKMwSHdxriL8Aiz2-SShr2rTthbCUgkPcDA\/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=”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|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 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 get income and expenses data out of the tools your teams already use and into your sheet.<\/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
What the cash flow template does<\/h3>\n
The Sheetgo cash flow template<\/a> keeps money coming in and money going out on two separate tabs, so you can see what you have received and what you have paid without picking through one long list. Everything else in the file \u2014 your running cash balance, receivables and payables by month, and the chart that plots them \u2014 is worked out from those two logs by formulas that are already in place.<\/p>\nYou are not tied to the version that arrives, either. Rename the categories, add columns, switch the currency: it is your own copy of an ordinary Google Sheets file, so you can shape it around the way your business actually runs.<\/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 template is one Google Sheets file. Alongside a Read me<\/b> tab that explains how it fits together, you get:<\/p>\n\n- Inputs<\/b>: the start date for the period you want to track, and your opening balance.<\/li>\n
- Receipts<\/b>: a log for money coming in, invoice by invoice \u2014 client name, invoice number, invoice amount, amount received, date received and a product category.<\/li>\n
- Payments<\/b>: the same layout on the outgoing side \u2014 supplier, invoice number, invoice amount, amount paid, date paid and an expense category.<\/li>\n
- Cash Flow Analysis<\/b>: your cash balance, receivables and payables month by month, calculated from those two logs.<\/li>\n
- Monthly Cash Flow Chart<\/b>: the same three lines plotted over time.<\/li>\n
- Receipts Analysis<\/b> and Payments Analysis<\/b>: a breakdown of each side on its own.<\/li>\n<\/ol>\n
There is also an Automate this<\/b> tab. That one is not part of the bookkeeping \u2014 it is where you can look into having a Sheetgo virtual employee take the data entry off your hands later on.<\/p>\n
[\/et_pb_text][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 the button below to make your own copy of the free template:<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/15u4WIS4YJKMwSHdxriL8Aiz2-SShr2rTthbCUgkPcDA\/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_margin=”30px||30px||true|false” 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” 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” sticky_enabled=”0″][\/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 your start date and opening balance<\/h4>\n
Open the Inputs<\/b> tab and fill in two settings: the start date of the period you want to look at, and the balance you are starting from. Every figure the file works out counts forward from there.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-inputs-2.png” alt=”Inputs tab with the start date and start balance settings in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Inputs tab” _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: Log the money coming in<\/h4>\n
The Receipts<\/b> tab is where you record everything the business takes in: customer sales, client payments, loans, interest. Each row holds the client, the invoice number, the invoice amount, how much of it has actually landed and the date it landed, plus a product category you can rename to match your own. The tab arrives with sample rows so you can see the layout \u2014 delete or overwrite them and start logging your own entries.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-receipts-2.png” alt=”Receipts tab logging invoices and amounts received in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Receipts tab” _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 3: Log the money going out<\/h4>\n
The Payments<\/b> tab works the same way on the outgoing side: supplier, invoice number, invoice amount, amount paid, date paid and a category such as Travel, Marketing or Office expenses. An invoice you settle in two instalments is simply two rows. Clear the sample data here too, then keep the tab up to date as you pay.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-payments-2.png” alt=”Payments tab logging supplier invoices and amounts paid in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Payments tab” _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 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″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Read your cash position<\/h4>\n
With your entries in, the Cash Flow Analysis<\/b> tab lays out your cash balance, receivables and payables month by month, with a small sparkline beside each line so you can see the shape at a glance. It moves as soon as you add a row to Receipts or Payments \u2014 there is nothing to refresh.<\/p>\n
The Monthly Cash Flow Chart<\/b> tab plots the same three lines over time, which is the quickest way to spot a month where payments are about to outrun the money coming in. When you want a closer look at one side on its own, Receipts Analysis<\/b> and Payments Analysis<\/b> break down each log separately.<\/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 tracking your cash flow<\/span><\/span><\/h3>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/15u4WIS4YJKMwSHdxriL8Aiz2-SShr2rTthbCUgkPcDA\/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=”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|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 the cash flow 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=”What do I need to set up first?” 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
Two things on the Inputs tab: the start date and your opening balance. After that you log receipts and payments as they happen.<\/p>\n
[\/difl_faqitem][difl_faqitem question=”Does it forecast future cash flow?” 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
It projects your balance forward from what you have entered. It does not predict anything on its own \u2014 the figures are the ones you put in.<\/p>\n
[\/difl_faqitem][\/difl_faq][\/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":"closed","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":[],"permalink_manager":null,"_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}]}}
- \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 get income and expenses data out of the tools your teams already use and into your sheet.<\/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
What the cash flow template does<\/h3>\n
The Sheetgo cash flow template<\/a> keeps money coming in and money going out on two separate tabs, so you can see what you have received and what you have paid without picking through one long list. Everything else in the file \u2014 your running cash balance, receivables and payables by month, and the chart that plots them \u2014 is worked out from those two logs by formulas that are already in place.<\/p>\n
You are not tied to the version that arrives, either. Rename the categories, add columns, switch the currency: it is your own copy of an ordinary Google Sheets file, so you can shape it around the way your business actually runs.<\/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 template is one Google Sheets file. Alongside a Read me<\/b> tab that explains how it fits together, you get:<\/p>\n
- \n
- Inputs<\/b>: the start date for the period you want to track, and your opening balance.<\/li>\n
- Receipts<\/b>: a log for money coming in, invoice by invoice \u2014 client name, invoice number, invoice amount, amount received, date received and a product category.<\/li>\n
- Payments<\/b>: the same layout on the outgoing side \u2014 supplier, invoice number, invoice amount, amount paid, date paid and an expense category.<\/li>\n
- Cash Flow Analysis<\/b>: your cash balance, receivables and payables month by month, calculated from those two logs.<\/li>\n
- Monthly Cash Flow Chart<\/b>: the same three lines plotted over time.<\/li>\n
- Receipts Analysis<\/b> and Payments Analysis<\/b>: a breakdown of each side on its own.<\/li>\n<\/ol>\n
There is also an Automate this<\/b> tab. That one is not part of the bookkeeping \u2014 it is where you can look into having a Sheetgo virtual employee take the data entry off your hands later on.<\/p>\n
[\/et_pb_text][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 the button below to make your own copy of the free template:<\/p>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/15u4WIS4YJKMwSHdxriL8Aiz2-SShr2rTthbCUgkPcDA\/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_margin=”30px||30px||true|false” 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” 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” sticky_enabled=”0″][\/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>\n
Step 1: Enter your start date and opening balance<\/h4>\n
Open the Inputs<\/b> tab and fill in two settings: the start date of the period you want to look at, and the balance you are starting from. Every figure the file works out counts forward from there.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-inputs-2.png” alt=”Inputs tab with the start date and start balance settings in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Inputs tab” _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: Log the money coming in<\/h4>\n
The Receipts<\/b> tab is where you record everything the business takes in: customer sales, client payments, loans, interest. Each row holds the client, the invoice number, the invoice amount, how much of it has actually landed and the date it landed, plus a product category you can rename to match your own. The tab arrives with sample rows so you can see the layout \u2014 delete or overwrite them and start logging your own entries.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-receipts-2.png” alt=”Receipts tab logging invoices and amounts received in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Receipts tab” _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 3: Log the money going out<\/h4>\n
The Payments<\/b> tab works the same way on the outgoing side: supplier, invoice number, invoice amount, amount paid, date paid and a category such as Travel, Marketing or Office expenses. An invoice you settle in two instalments is simply two rows. Clear the sample data here too, then keep the tab up to date as you pay.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/cashflow-payments-2.png” alt=”Payments tab logging supplier invoices and amounts paid in the Sheetgo cash flow template for Google Sheets” title_text=”Cash flow template Payments tab” _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 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″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Read your cash position<\/h4>\n
With your entries in, the Cash Flow Analysis<\/b> tab lays out your cash balance, receivables and payables month by month, with a small sparkline beside each line so you can see the shape at a glance. It moves as soon as you add a row to Receipts or Payments \u2014 there is nothing to refresh.<\/p>\n
The Monthly Cash Flow Chart<\/b> tab plots the same three lines over time, which is the quickest way to spot a month where payments are about to outrun the money coming in. When you want a closer look at one side on its own, Receipts Analysis<\/b> and Payments Analysis<\/b> break down each log separately.<\/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 tracking your cash flow<\/span><\/span><\/h3>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/15u4WIS4YJKMwSHdxriL8Aiz2-SShr2rTthbCUgkPcDA\/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=”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|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 the cash flow 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=”What do I need to set up first?” 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
Two things on the Inputs tab: the start date and your opening balance. After that you log receipts and payments as they happen.<\/p>\n
[\/difl_faqitem][difl_faqitem question=”Does it forecast future cash flow?” 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
It projects your balance forward from what you have entered. It does not predict anything on its own \u2014 the figures are the ones you put in.<\/p>\n
[\/difl_faqitem][\/difl_faq][\/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":"closed","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>\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\nFollow 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
\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<\/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":[],"permalink_manager":null,"_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}]}}
- Receipts<\/b>: a log for money coming in, invoice by invoice \u2014 client name, invoice number, invoice amount, amount received, date received and a product category.<\/li>\n
- Inputs<\/b>: the start date for the period you want to track, and your opening balance.<\/li>\n