{"id":15303,"date":"2020-10-14T11:00:51","date_gmt":"2020-10-14T09:00:51","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=15303"},"modified":"2025-12-18T00:06:57","modified_gmt":"2025-12-17T23:06:57","slug":"modele-de-suivi-des-depenses-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/finance-templates\/expense-tracker-template-in-google-sheets\/","title":{"rendered":"Mod\u00e8le de suivi des d\u00e9penses dans Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.22.2&#8243; custom_padding=&#8221;54px|0px|0|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Keeping on top of your team&#8217;s spending is a key part of budgeting and business management. Rather than waiting to collect a pile of receipts at the end of the month (and possibly getting a nasty shock at how much money your employees have spent), it&#8217;s good to keep track of expenses over time.<\/p>\n<p>Many small to medium-sized businesses don\u2019t have a formal system for submitting and reimbursing expenses. Often, staff will simply submit a pile of paper receipts or send an email with an uploaded image attached.<\/p>\n<p>For accountants, keeping track of receipts and reimbursements can be a nightmare. It\u2019s more efficient to have all of that information centralized in one place, online. Although there are specialist expenses tools available for this there\u2019s no need to spend money expensive dedicated software. Instead, consider Sheetgo&#8217;s Expense tracker template in Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Why use Google Sheets to manage expenses?<\/h3>\n<ul>\n<li>Flexible: Online spreadsheets allow you to create a versatile expenses submission and tracking system that\u2019s customized to your business. You can adapt and expand the system over time, without any coding skills.<\/li>\n<li>Accessible: As Google Sheets is cloud-based, your colleagues can submit expenses from their laptop or mobile at any time, even when they\u2019re on the road. Admin staff can process expenses quickly and easily, without any special software.<\/li>\n<li>Compatible with everything: Every piece of software integrates with Google Sheets. As a result, you can easily import data from other areas of the business, giving you everything you need in your Google Sheets.<\/li>\n<li>Easy to use: It\u2019s likely that your entire team can already use spreadsheets so rolling out the system is straightforward. A Google Sheets expenses solution is future-proof and easy to maintain.<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Sign up for Sheetgo and start tracking your <span style=\"background-color: rgba(41,121,255,0.2);\"><span>expenses<\/span><\/span> automatically<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/expense-tracker&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to get started<\/h3>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Sheetgo\u2019s spreadsheet-based workflow template is a pre-built system for automated expense tracking that can be used by any business.<\/p>\n<p>The template lets team members submit their expenses quickly and easily while giving managers an up-to-date overview of spending in the master sheet and dashboard:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/EXPENSE-TRACKER-GOOGLE-SHEETS-MASTER-SHEET.png&#8221; alt=&#8221;EXPENSE TRACKER GOOGLE SHEETS MASTER SHEET&#8221; title_text=&#8221;EXPENSE TRACKER GOOGLE SHEETS MASTER SHEET&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>What is a spreadsheet-based workflow template?<\/h3>\n<p>Whereas a regular spreadsheet template is a single file containing tables, charts, layouts, and formulas, a Sheetgo workflow template is a complete system.<\/p>\n<p>It\u2019s a group of interconnected Google Sheets that exchange data between them. This enables you to share data with others while working autonomously in your own individual file.<\/p>\n<p>A spreadsheet-based workflow template gives you:<\/p>\n<ul>\n<li>Organization and data privacy: Each file is dedicated to one single task, which keeps data secure and separated. Employees submit expenses in their own spreadsheet and keep an eye on their spending in their personal dashboard. Data from all the individual spreadsheets flows into the master sheet, so only the manager can see everybody\u2019s expenses.<\/li>\n<li>Scalability: Google Sheets has a powerful sharing function but multiple people working in the same spreadsheet can make the file heavy and slow. Separating data into individual spreadsheets keeps the system working smoothly. When you need to expand the template, simply duplicate one of the <strong>Individual Expenses<\/strong> spreadsheets and share it with the new employee.<\/li>\n<li>Integration: As well as allowing you to import data from other software packages, a spreadsheet-based workflow allows managers to merge data from departments. In a few clicks, you can connect your expenses workflows with your budget workflow (or those from other departments) to generate directors\u2019 reports.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/EXPENSE-TRACKER-GOOGLE-SHEETS-INDIVIDUAL.png&#8221; alt=&#8221;EXPENSE TRACKER GOOGLE SHEETS INDIVIDUAL&#8221; title_text=&#8221;EXPENSE TRACKER GOOGLE SHEETS INDIVIDUAL&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;-30px||||false|false&#8221; custom_padding=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><em>Every employee gets their own personal dashboard to track their expenses.<\/em><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>What you get with this template:<\/h3>\n<p>When you install <a href=\"https:\/\/www.sheetgo.com\/templates\/finance\/expenses-tracker-template\/\" target=\"_blank\" rel=\"noopener\">the Sheetgo Expense tracker template<\/a>, four Google Sheets files with ready-made Sheetgo connections are saved to your Google Drive:<\/p>\n<ul>\n<li>Three <strong>Individual expenses<\/strong> spreadsheets. Share these files with the team members who will submit expenses and make as many copies as you need for additional staff. Each employee uses their copy of this spreadsheet to submit expenses, share receipts, and monitor their own spending.<\/li>\n<li>One <strong>Team Expense tracker<\/strong> master sheet, for the administrator or company accountant. In this file, they receive expenses submissions from across the company. In the automated dashboard, they get a visual overview of expenses per day, month, expense type, and individual.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/04\/expense-tracker-full-01.png&#8221; alt=&#8221;Expense tracker template in Google Sheets: Master Sheet and Individual Expense Tracker Sheets&#8221; title_text=&#8221;expense-tracker-template-master-sheet&#8221; align=&#8221;center&#8221; align_tablet=&#8221;center&#8221; align_phone=&#8221;&#8221; align_last_edited=&#8221;on|desktop&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to install the workflow template<\/h3>\n<p>Click on the button below to install Sheetgo\u2019s Expense Tracker template.<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/expense-tracker&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|20px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ol>\n<li>Login to Sheetgo with your Google, Microsoft, or Dropbox account.<\/li>\n<li>Click <strong>Install template<\/strong>.<\/li>\n<li>Wait a few moments while Sheetgo creates copies of the files and connects them.<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How the template works<\/h3>\n<p>The <strong>Team expense tracker<\/strong> master sheet opens inside Sheetgo. Take a look at all the files to familiarize yourself with the template. You will find that the spreadsheets contain sample data to demonstrate how the template works. Just delete or overwrite this information when you start using the template.<\/p>\n<p>To open any of the spreadsheets, double click on the file in the sidebar on the right. When you want to close the sidebar, just click on the small cross located at the top of the right-hand corner .[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/TETA.png&#8221; alt=&#8221;expense-tracker-template&#8221; title_text=&#8221;TETA&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use the Expense tracker template<\/h3>\n<h4>Step 1: Share the Individual expense tracker files<\/h4>\n<p>From inside Sheetgo, go to <strong>Files<\/strong> or <strong>Workflow<\/strong>.<\/p>\n<p>Click on one of the<strong> Individual expense tracker<\/strong> files to open it inside Sheetgo. <\/p>\n<p>In the top right-hand corner of the screen, click <strong>Share<\/strong>.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/TETB.png&#8221; alt=&#8221;expense-tracker-template-open-in-new&#8221; title_text=&#8221;TETB&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]The <strong>Individual expense tracker<\/strong> spreadsheets contain sample data. You can delete this before sharing the files with your colleagues or instruct them to do it.<\/p>\n<h4>Step 2: Colleagues enter their expenses<\/h4>\n<p>When a member of staff pays for something that they need to put on their expenses, they should record it in the <strong>Expenses<\/strong> tab in their personal spreadsheet. In <strong>Column F<\/strong> they can enter a link to a photo of a receipt that they have uploaded to Google Drive.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/TETC.png&#8221; alt=&#8221;expense-tracker-template-individual-expenses-tab&#8221; title_text=&#8221;TETC&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start tracking your <span style=\"background-color: rgba(41,121,255,0.2);\"><span>expenses<\/span><\/span> automatically<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/expense-tracker&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 3: Transfer the data<\/h4>\n<p>Once your colleagues have started updating their spreadsheets, you want to import that data into the manager\u2019s master sheet.<\/p>\n<p>To do this, go back to the <strong>Workflow<\/strong> by clicking on the sidebar to the left of the screen Afterwards, click on <strong>Run<\/strong> located in the left bottom corner.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/expense-tracker-\u2013-1.png&#8221; alt=&#8221;expense-tracker-template-run-workflow&#8221; title_text=&#8221;expense tracker \u2013 1&#8243; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>The Sheetgo connections now pull data from all the <strong>Individual expense tracker<\/strong> spreadsheets straight into the master sheet.<\/p>\n<p>You can see this data in the <strong>Consolidated expenses<\/strong> tab and\u00a0quickly check how much each team member is spending.<\/p>\n<p>As you will notice, this tab has a padlock icon. That\u2019s just to remind you that this is a connected tab, pulling data from the other files \u2014 so don\u2019t try to edit this tab.<\/p>\n<p>There are also some hidden tabs in this file. These contain formulas to prepare the data for the dashboard.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/TETE.png&#8221; alt=&#8221;expense-tracker-template-consolidated-expenses&#8221; title_text=&#8221;TETE&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 4: Adjust the settings (optional)<\/h4>\n<p>The charts in the master sheet dashboard are configured to display expenses data from the past year. To adjust this, just enter the number of days in the white box on the dashboard.<\/p>\n<p>You will also notice that the template contains 7 options for Type of expense. These are Air &amp; Transport, Lodging, Fuel, Meals &amp; Tips, Phone, Entertainment, and Other.<\/p>\n<p>If you want to change these options, go to the <strong>Consolidated expenses<\/strong> tab in your <strong>Team expense tracker<\/strong> (master sheet).<\/p>\n<p>Select a range of cells in <strong>Column E<\/strong> (Type of Expense) and click on <strong>Data Validation<\/strong>.<\/p>\n<p>Edit the criteria next to <strong>List of items<\/strong> and click <strong>Save<\/strong>.<\/p>\n<p>The next time you update the workflow, this data will be sent to the <strong>Individual Expense Tracker<\/strong> files. The new list will be available via the dropdown menu in each spreadsheet.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/10\/expense-tracker-template-data-validation.png&#8221; alt=&#8221;expense-tracker-template-data-validation&#8221; title_text=&#8221;expense-tracker-template-data-validation&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 5: Automate the workflow<\/h4>\n<p>Once your colleagues are regularly submitting their expenses into their spreadsheets, there is no need to run the workflow manually. Instead, you can schedule automatic transfers to run at regular intervals.<\/p>\n<p>Click on the <strong>Automate<\/strong> button located next to the <b>run<\/b> button. Select how frequently you want the data to be transferred: from once an hour to once a month.[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/10\/expense-tracker-template-automate.png&#8221; alt=&#8221;expense-tracker-template-automate&#8221; title_text=&#8221;expense-tracker-template-automate&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>How to add more Individual files to the workflow<\/h4>\n<p>Adding another colleague to the <strong>Expense<\/strong>\u00a0<strong>management<\/strong> workflow is pretty straightforward. Simply copy one of the <strong>Individual expense tracker<\/strong> files and connect it with new Sheetgo connections.<\/p>\n<p>Here\u2019s how to do it:<\/p>\n<ol>\n<li>Go to your <strong>Google Drive<\/strong> &gt; <strong>Sheetgo Templates<\/strong> &gt; <strong>Expense tracker<\/strong>.<\/li>\n<li>Copy one of the <strong>Individual expense tracker<\/strong> files by right-clicking on <strong>Make a copy<\/strong>.<\/li>\n<li>Rename the file as appropriate.<\/li>\n<li>Open Sheetgo and go to your <strong>Expense Tracker workflow<\/strong> &gt; <strong>Connections<\/strong>.<\/li>\n<li>Click on the 3-dots menu (<strong>\u22ee<\/strong>) <strong>Edit.<\/strong><\/li>\n<\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start tracking your <span style=\"background-color: rgba(41,121,255,0.2);\"><span>expenses<\/span><\/span> automatically<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/expense-tracker&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/TETF.png&#8221; alt=&#8221;expense-tracker-template-edit-connection&#8221; title_text=&#8221;TETF&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Under <strong>Source data<\/strong> &gt; <strong>Multiple files<\/strong>, you will see a list of the three files that are already connected as part of the template.<\/p>\n<ol>\n<li>Click <strong>+Add another source file<\/strong>.<\/li>\n<li>Locate the new file you have just created inside your Google Drive.<\/li>\n<li>In the <strong>FILE TAB<\/strong> box, select <strong>Expenses<\/strong>. This is really important to ensure that you import data from the correct tab (sheet) in the spreadsheet.\u00a0<\/li>\n<li>Click <strong>Finish &amp; Save<\/strong>.<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/10\/expense-tracker-add-new-file-finish-save.png&#8221; alt=&#8221;expense-tracker-template-add-new-file-finish-save&#8221; title_text=&#8221;expense-tracker-add-new-file-finish-save&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>In the workflow view, you will see that there are now 4 Individual files connected to the master sheet.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/TETG.png&#8221; alt=&#8221;expense-tracker-new-workflow-four-files&#8221; title_text=&#8221;TETG&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>If you have multiple employees and a lot of timesheets, you can also use Sheetgo to consolidate data from an entire folder of spreadsheets.<\/p>\n<p>This enables you to automate another step of the process. By simply dropping a new <strong>Individual expense tracker file<\/strong> into the folder, it will automatically be included in the workflow.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Build a complete accounting system in Google Sheets<\/h3>\n<p>To create a more advanced system, you can customize the template further or link it to other company workflows such as your <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/budget-vs-actual-template-in-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">budget monitoring<\/a> or <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/cash-flow-template\/\" target=\"_blank\" rel=\"noopener noreferrer\">cash flow<\/a> system.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Start tracking your <span style=\"background-color: rgba(41,121,255,0.2);\"><span>expenses<\/span><\/span> automatically<\/h3>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/expense-tracker&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Keeping on top of your team&#8217;s spending is a key part of budgeting and business management. Rather than waiting to collect a pile of receipts at the end of the month (and possibly getting a nasty shock at how much money your employees have spent), it&#8217;s good to keep track of expenses over time. Many [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":27391,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-15303","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\/15303","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=15303"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/15303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27391"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=15303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=15303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=15303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}