{"id":9355,"date":"2018-08-14T12:00:18","date_gmt":"2018-08-14T10:00:18","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9355"},"modified":"2018-08-14T12:00:18","modified_gmt":"2018-08-14T10:00:18","slug":"como-criar-um-rastreador-de-despesas-simples","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/finance-templates\/how-to-create-a-simple-expense-tracker\/","title":{"rendered":"Como criar um rastreador de despesas simples"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][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 admin_label=”Text” _builder_version=”4.21.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Whether for a business or personal use people should track their expenses to understand where their money is being allocated. By tracking your expenses you will gain insight into how your resources are used and find ways to save money. In this blog post, we show you how to create a simple expense tracker and provide you with a template to get you going.<\/p>\n

Choose simple expense tracker software<\/h3>\n

For personal finances, there are several apps such as Dollarbird, Goodbudget, and Fudget that get the job done. I personally like to use spreadsheets as they are more flexible than any off the shelf software. Spreadsheets are also more useful for business purposes as you can easily integrate them to manage multiple processes together (e.g., link your expense tracker to HR database for salary payments).<\/p>\n

In this example, we’ll show you how to create your own do-it-yourself expense tracker in spreadsheets. For this exercise, I recommend Google Sheets as it is free (if you have a Gmail account) and you can access it from anywhere.<\/p>\n

Create your expense categories<\/h3>\n

The best way for you to examine your expenses is by categorizing them. In any given month you can have hundreds or thousands (for a business) of payments. In order to visualize where you are spending your money, it is important to categorize them. Categories for personal expenses would be things like housing, transport, and utilities, whereas for a business they would be things like office expenses, salaries, and supplies. We recommend between 8 and 15 categories to give you sufficient visibility into your spending, while not overwhelming.<\/p>\n

Create your expense input sheet<\/h3>\n

Once you’ve created your expense categories you can now begin to input your expenses. For your expense sheet, you should include columns for categories (use data validation to create a pull-down menu), payment date, payment amount, and notes (for detailed info). With the structure set up, you can begin to input your expenses.<\/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

Sign up for Sheetgo and start tracking your expenses<\/span><\/span> automatically<\/h4>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/expense-tracker” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text admin_label=”Text” _builder_version=”4.21.2″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Create your expense input sheet<\/h3>\n

Once you’ve created your expense categories you can now begin to input your expenses. For your expense sheet, you should include columns for categories (use data validation to create a pull-down menu), payment date, payment amount, and notes (for detailed info). With the structure set up, you can begin to input your expenses.<\/p>\n

Create your summary tab<\/h3>\n

With your expenses input, you can begin to summarize them on one tab. Try using formulas like =SUMIFS() to sum all expenses in a given category over a given timeframe. From there you can create graphics to easily visualize where your money is being spent.<\/p>\n

 <\/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 expenses<\/span><\/span> automatically<\/h3>\n

[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/expense-tracker” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Whether for a business or personal use people should track their expenses to understand where their money is being allocated. By tracking your expenses you will gain insight into how your resources are used and find ways to save money. In this blog post, we show you how to create a simple expense tracker and […]<\/p>\n","protected":false},"author":40,"featured_media":35397,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Whether for a business or personal use people should track their expenses to understand where their money is being allocated. By tracking your expenses you will gain insight into how your resources are used and find ways to save money. In this blog post, we show you how to create a simple expense tracker and provide you with a template to get you going.\n

Choose the software that you'll use<\/h2>\nFor personal finances, there are several apps such as Dollarbird, Goodbudget, and Fudget that get the job done. I personally like to use spreadsheets as they are more flexible than any off the shelf software. Spreadsheets are also more useful for business purposes as you can easily integrate them to manage multiple processes together (e.g., link your expense tracker to HR database for salary payments).\n\nIn this example, we'll show you how to create your own do-it-yourself expense tracker in spreadsheets. For this exercise, I recommend Google Sheets as it is free (if you have a Gmail account) and you can access it from anywhere.\n

Create your expense categories<\/h2>\nThe best way for you to examine your expenses is by categorizing them. In any given month you can have hundreds or thousands (for a business) of payments. In order to visualize where you are spending your money, it is important to categorize them. Categories for personal expenses would be things like housing, transport, and utilities, whereas for a business they would be things like office expenses, salaries, and supplies. We recommend between 8 and 15 categories to give you sufficient visibility into your spending, while not overwhelming.\n

Create your expense input sheet<\/h2>\nOnce you've created your expense categories you can now begin to input your expenses. For your expense sheet you should include columns for categories (use data validation to create a pull-down menu), payment date, payment amount, and notes (for detailed info). With the structure set up, you can begin to input your expenses.\n

Create your summary tab<\/h2>\nWith your expenses input, you can begin to summarize them on one tab. Try using formulas like =SUMIFS() to sum all expenses in a given category over a given timeframe. From there you can create graphics to easily visualize where your money is being spent.\n

User our template<\/h2>\nWe created a simple expense tracking template for you to begin using. Simply click THIS LINK<\/a> and then the blue \"Make a Copy\" button to make your own copy of our template. We've pre-filled it with some dummy data, but feel free to overwrite the \"Categories\" and \"Payments\" tab with your own data.\n\nIf you have any questions and\/or suggestions, let us know in the comment section!","_et_gb_content_width":"","footnotes":""},"categories":[57],"tags":[50],"class_list":["post-9355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-templates","tag-finance"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=9355"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/9355\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/35397"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=9355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=9355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=9355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}