[et_pb_section fb_built=”1″ _builder_version=”4.22.2″ custom_padding=”54px|0px|0|0px|false|false” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ 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.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Keeping on top of your team’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’s good to keep track of expenses over time.<\/p>\n
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
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 on expensive dedicated software. Instead, consider Sheetgo\u2019s free Expense tracker template in Google Sheets: one spreadsheet the whole team logs expenses in, with a dashboard that adds them up for you.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
[\/et_pb_text][\/et_pb_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:\/\/docs.google.com\/spreadsheets\/d\/1pWafwCuWfFrI5cGSWUxsco0XyyWd237XC3dIghJGwC4\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ 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
Sheetgo\u2019s Expense tracker template is one free Google Sheets file. You copy it to your own Google Drive, share it with the people who spend money, and each of them adds a row for every expense they need reimbursed. The Dashboard<\/strong> tab totals those rows and charts them, so you can see what the team is spending without asking anyone for a figure.<\/p>\n There is nothing to set up first: no software to add, no files to connect, and no Sheetgo account needed to use it.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It is a single Google Sheets file. The expense log, the formulas and the finished charts all live in the same spreadsheet, on separate tabs. Copy it once and you have your own private version, pre-filled with sample data you can overwrite with your own figures.<\/p>\n One tab is for typing into \u2014 All expenses<\/strong>. Everything else is calculated from what you enter there, so you never have to write a formula yourself.<\/p>\n The trade-off compared with a file per person is privacy between colleagues: anyone with edit access can see the whole table. If that matters for your team, use Google Sheets\u2019 own sharing settings and protected ranges to control who can open and change what.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Copying the Expense tracker template saves one Google Sheets file to your Google Drive. Inside it you will find:<\/p>\n Two helper tabs, Data preparation<\/strong> and Accrual Period Table<\/strong>, are hidden. They hold the formulas that feed the dashboard, so you can leave them alone.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click the blue button below, then click Make a copy<\/strong> to save your own version to Google Drive.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1pWafwCuWfFrI5cGSWUxsco0XyyWd237XC3dIghJGwC4\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|20px|0px|false|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Your copy arrives with sample data in it, so you can see how everything behaves before you commit to it. Click through the tabs along the bottom of the spreadsheet to get your bearings, then delete or overwrite the sample rows when you start using the file for real.<\/p>\n The Read me<\/strong> tab stays in the file, so you can go back to it whenever you need a reminder of how the pieces fit together.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Open your copy and click Share<\/strong> in the top right-hand corner of Google Sheets. Give everyone who submits expenses Editor<\/strong> access so they can add their own rows.<\/p>\n If you would rather people could not touch the charts, select the Dashboard<\/strong> tab and use Data<\/strong> > Protect sheets and ranges<\/strong> to lock it, leaving All expenses<\/strong> open for editing.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n When a member of staff pays for something they need back, they add a row to the All expenses<\/strong> tab: the date, a short description, the invoice number, the amount, and the Type of expense<\/strong> from the dropdown. In the Link for the receipt<\/strong> column they can paste a link to a photo of the receipt they have uploaded to Google Drive. Last, they put their own name in the Team member<\/strong> column \u2014 that is the column that keeps everybody\u2019s claims apart in the charts.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/expense-tracker-all-expenses-2.png” alt=”All expenses tab of the Sheetgo expense tracker template in Google Sheets, with a Team member column” title_text=”Expense tracker template All expenses tab” align=”center” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Dashboard<\/strong> tab updates as rows are added to the log. It shows expenses per day, expenses per month, the amount per type of expense as a share of the total, expenses per individual, and expenses per month for each individual. There is also a space at the top left where you can drop in your company logo.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/expense-tracker-dashboard-2.png” alt=”Dashboard tab of the Google Sheets expense tracker template charting spending per day, month, type and team member” title_text=”Expense tracker template Dashboard tab” align=”center” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” text_orientation=”center” custom_margin=”-30px||||false|false” custom_padding=”||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Dashboard tab breaks spending down by day, by month, by type of expense and by team member.<\/em><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The charts show the last 365 days by default. To change that, type a different number into the white box on the Dashboard<\/strong> tab that reads Bring data from the last \u2026 days<\/strong>.<\/p>\n The file arrives with a handful of expense categories in the dropdown: Air & Trans., Lodging, Fuel, Meals & Tips, Phone and Entertainment. To use your own instead, go to the All expenses<\/strong> tab, select the cells in the Type of expense<\/strong> column, open Data<\/strong> > Data validation<\/strong>, edit the list of items and save. The dropdown then offers your categories.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/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\/1pWafwCuWfFrI5cGSWUxsco0XyyWd237XC3dIghJGwC4\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ 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 Adding a colleague does not mean adding a file. Share the same spreadsheet with them, and have them type their name in the Team member<\/strong> column when they log an expense. From that point on they appear in the per-individual charts alongside everyone else.<\/p>\n If you would prefer names to be picked from a list rather than typed, treat the Team member<\/strong> column the same way as the expense types: select the cells, open Data<\/strong> > Data validation<\/strong>, and add each name to the list of items.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Expenses are only one part of the picture. Once the tracker is running, pair it with the other free Sheetgo templates for Google Sheets \u2014 such as budget monitoring<\/a> or cash flow<\/a> \u2014 so you can see what you planned to spend next to what you actually spent.<\/p>\n The one thing a spreadsheet cannot do is fill itself in. Someone still has to add the rows and chase the receipts that never turn up. If that is the part you would rather hand over, the Automate this<\/strong> tab in the file introduces Owen, Sheetgo\u2019s finance virtual employee, who picks up the expense and reconciliation legwork for you.<\/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 [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1pWafwCuWfFrI5cGSWUxsco0XyyWd237XC3dIghJGwC4\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.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 [\/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 expense tracker 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=”Can I track expenses for a whole team in one file?” 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. The All expenses tab has a Team member column, so everyone’s expenses sit in the same file and the Dashboard breaks the totals down per person.<\/p>\n [\/difl_faqitem][difl_faqitem question=”Does it collect receipts or reimburse people?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n No. There is a column to paste a receipt link, but the spreadsheet does not chase receipts or pay anyone. That is what Sheetgo’s finance virtual employee does.<\/p>\n [\/difl_faqitem][\/difl_faq][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Keeping on top of your team’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’s good to keep track of expenses over time. Many […]<\/p>\n","protected":false},"author":39,"featured_media":27391,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-15303","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\/es\/wp-json\/wp\/v2\/posts\/15303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=15303"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/15303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/27391"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=15303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=15303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=15303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What kind of template is this?<\/h3>\n
Working in a single spreadsheet gives you:<\/h5>\n
\n
What you get with this template:<\/h3>\n
\n
How to get your copy<\/h3>\n
\n
How the template works<\/h3>\n
How to use the Expense tracker template<\/h3>\n
Step 1: Share the file with your team<\/h4>\n
Step 2: Colleagues enter their expenses<\/h4>\n
Step 3: Read the Dashboard<\/h4>\n
Step 4: Adjust the settings (optional)<\/h4>\n
Start tracking your expenses<\/span><\/span><\/h4>\n
Adding more people to the tracker<\/h3>\n
Build a complete accounting system in Google Sheets<\/h3>\n
Start tracking your expenses<\/span><\/span><\/h3>\n
Frequently asked questions<\/h2>\n