{"id":147697,"date":"2023-10-12T17:08:41","date_gmt":"2023-10-12T11:38:41","guid":{"rendered":"https:\/\/www.regenesys.net\/reginsights\/?p=147697"},"modified":"2023-10-12T17:08:41","modified_gmt":"2023-10-12T11:38:41","slug":"practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2","status":"publish","type":"post","link":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2","title":{"rendered":"Practical Tips for Building a Budget Tracker on Excel &#8211; Template Included &#8211; Part 2\u00a0 \u00a0\u00a0"},"content":{"rendered":"<p><i><span data-contrast=\"auto\">The Excel template this article is based on, as well as a full explanation of it that includes part 1, can be requested from MyWealth Investments by e-mailing <\/span><\/i><a href=\"mailto:info@mywealthinvestments.co.za\"><i><span data-contrast=\"none\">info@mywealthinvestments.co.za<\/span><\/i><\/a><i><span data-contrast=\"auto\">.\u00a0<\/span><\/i><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">In last week\u2019s <a href=\"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-1\">article<\/a>, we started the discussion based on the budget template, as shown below. It is important to remember that the \u201ccurrent account\u201d box shown below is your transactional account that keeps track of all money that is flowing in or out of this account. The \u201cCurrent balance\u201d in light green should correspond with what you are seeing as the balance in your banking app. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<figure id=\"attachment_147698\" aria-describedby=\"caption-attachment-147698\" style=\"width: 2560px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template.png\"><img decoding=\"async\" class=\"wp-image-147698 size-full\" src=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template.png\" alt=\"Budget Template\" width=\"2560\" height=\"1297\" srcset=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template.png 2560w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template-300x152.png 300w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template-1024x519.png 1024w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template-1536x778.png 1536w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Budget-template-2048x1037.png 2048w\" sizes=\"(max-width: 2560px) 100vw, 2560px\" \/><\/a><figcaption id=\"caption-attachment-147698\" class=\"wp-caption-text\">View of the budget template<\/figcaption><\/figure>\n<p><span data-contrast=\"auto\">We will continue the discussion by moving on to the \u201cOUT\u201d section in the \u201ccurrent account\u201d box. There are subsections where the expenses will be classified and listed according to the most important \u201cneed to pay\u201d expenses to the lesser urgent \u201cwant to spend\u201d expenses. At the bottom, any money that will be transferred out of the current account into savings or investments will also be listed. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3>Understanding and Managing Fixed and Variable Expenses<\/h3>\n<p><a href=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/managing-fixed-and-variable-expenses.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-147719\" src=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/managing-fixed-and-variable-expenses.png\" alt=\"budget template\" width=\"850\" height=\"357\" srcset=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/managing-fixed-and-variable-expenses.png 850w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/managing-fixed-and-variable-expenses-300x126.png 300w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/a><\/p>\n<p><span data-contrast=\"auto\">The fixed expenses at the top are those that are paid every month and are known amounts, while the variable expenses are also paid every month, but the amount will differ depending on needs. Allocating a budget at the beginning of the month to these variable expenses and luxury expenses is important and should be kept in mind when spending money. Of course, there may be times when you will spend more money than what was budgeted for, but this will keep you mindful of how often and how much you spend over your budget. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3>Managing Savings, Emergency Fund, and Current Account Balances<\/h3>\n<p><span data-contrast=\"auto\">To the top right, all saving accounts and investments are listed from most liquid to least liquid. A savings account with your bank can be used as an emergency fund. Most banks offer a savings account with a slightly higher interest rate than the current account. Using this account works great for an emergency fund as it is a ring-fence and separate savings in a liquid account and can easily be transferred from or into the current account simply on a banking app. Remember the golden rule \u2013 your savings account, or emergency fund, should hold at least three to six months\u2019 worth of your nett income. Emergency and ad hoc expenses are usually paid from this account and if it is used, make sure to top up the current account and show it in the \u201cIN\u201d section. If funds from the emergency fund are used, topping it up again, before investing in less liquid investments, must be prioritised. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/savings-account.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-147720\" src=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/savings-account.png\" alt=\"budget template\" width=\"850\" height=\"357\" srcset=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/savings-account.png 850w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/savings-account-300x126.png 300w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/a><\/p>\n<p><span data-contrast=\"auto\">If funds are left over in your current account balance at the end of the month, consider using some of it to repay expensive debt or to top up the emergency fund. Remember to also show it as an \u201cOUT\u201d item when allocating it as it will be flowing out of the current account. This will ensure your \u201cbalance\u201d remains in line with the amount reflected in your banking app.\u00a0 <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">To the left of the \u201csavings\/investment box\u201d the starting values of each account will be shown and right from it, any funds coming in or withdrawn from the accounts will be shown. The \u201cEND\u201d value to the far right will be the \u201cbrought over\u201d, or \u201cstarting\u201d value placed in this box next month. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The final box on the sheet will show all debt accounts that are outstanding. List these accounts from those with the highest interest rate to the lowest interest rate to serve as a reminder which needs to be repaid first if you have any additional funds.\u00a0\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"><a href=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/budget.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-147721\" src=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/budget.png\" alt=\"budget template\" width=\"850\" height=\"357\" srcset=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/budget.png 850w, https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/budget-300x126.png 300w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/a>\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Remember that this basic template can be built out even further by colour-coding certain expenses or funds that flow from different accounts, using conditional formatting. Charts, pivot tables and filters can also be included to visually show a snapshot of your finances. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Each person\u2019s Excel budget workbook will ultimately look different, but this template and article can serve as a framework for how to think about setting it up. It is important to understand that this is a two-part process that requires you to put in the work at the beginning of each month to set up the budget, but that recording actual funds that flow from your accounts must be done throughout the month. Incorporating this practice into your life will without a doubt be one of the best things you can do for your financial well-being. You will not just be taking ownership and being proactive with your spending, but you will start to get a clear idea of where you are perhaps wasting money within a couple of months of doing this. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel template this article is based on, as well as a full explanation of it that includes part 1, can be requested from MyWealth Investments by e-mailing info@mywealthinvestments.co.za.\u00a0\u00a0 In last week\u2019s article, we started the discussion based on the budget template, as shown below. It is important to remember that the \u201ccurrent account\u201d box<\/p>\n","protected":false},"author":19,"featured_media":147717,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","footnotes":""},"categories":[585],"tags":[],"country":[],"class_list":{"0":"post-147697","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-business"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Practical Tips for Building a Budget Tracker on Excel - Template Included - Part 2\u00a0 \u00a0\u00a0 - RegInsights<\/title>\n<meta name=\"description\" content=\"Advance your budgeting skills with our Excel template in Part 2 of Practical Tips for Building a Budget Tracker. Take control of your finances now\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Practical Tips for Building a Budget Tracker on Excel - Template Included - Part 2\u00a0 \u00a0\u00a0 - RegInsights\" \/>\n<meta property=\"og:description\" content=\"Advance your budgeting skills with our Excel template in Part 2 of Practical Tips for Building a Budget Tracker. Take control of your finances now\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\" \/>\n<meta property=\"og:site_name\" content=\"RegInsights\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RegenesysBusinessSchool\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-12T11:38:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"357\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Charne Olivier\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@RegenesysB\" \/>\n<meta name=\"twitter:site\" content=\"@RegenesysB\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Charne Olivier\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\"},\"author\":{\"name\":\"Charne Olivier\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/#\\\/schema\\\/person\\\/37b1aec02c820663b50deb14aac2ee35\"},\"headline\":\"Practical Tips for Building a Budget Tracker on Excel &#8211; Template Included &#8211; Part 2\u00a0 \u00a0\u00a0\",\"datePublished\":\"2023-10-12T11:38:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\"},\"wordCount\":806,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Featured-image.png\",\"articleSection\":[\"Business and Finance\"],\"inLanguage\":\"en-ZA\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\",\"url\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\",\"name\":\"Practical Tips for Building a Budget Tracker on Excel - Template Included - Part 2\u00a0 \u00a0\u00a0 - RegInsights\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Featured-image.png\",\"datePublished\":\"2023-10-12T11:38:41+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/#\\\/schema\\\/person\\\/37b1aec02c820663b50deb14aac2ee35\"},\"description\":\"Advance your budgeting skills with our Excel template in Part 2 of Practical Tips for Building a Budget Tracker. Take control of your finances now\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#breadcrumb\"},\"inLanguage\":\"en-ZA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-ZA\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage\",\"url\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Featured-image.png\",\"contentUrl\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/Featured-image.png\",\"width\":850,\"height\":357,\"caption\":\"Budget template\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Practical Tips for Building a Budget Tracker on Excel &#8211; Template Included &#8211; Part 2\u00a0 \u00a0\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/#website\",\"url\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/\",\"name\":\"RegInsights\",\"description\":\"Thought Leadership\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-ZA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/#\\\/schema\\\/person\\\/37b1aec02c820663b50deb14aac2ee35\",\"name\":\"Charne Olivier\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-ZA\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f65cd8f3e13456d94eb74e73ba59602e94ccdc41050674742811be7e4996209d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f65cd8f3e13456d94eb74e73ba59602e94ccdc41050674742811be7e4996209d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f65cd8f3e13456d94eb74e73ba59602e94ccdc41050674742811be7e4996209d?s=96&d=mm&r=g\",\"caption\":\"Charne Olivier\"},\"description\":\"Charne Olivier - Articles provider for My Wealth Investment\",\"url\":\"https:\\\/\\\/www.regenesys.net\\\/reginsights\\\/author\\\/charne-olivier\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Practical Tips for Building a Budget Tracker on Excel - Template Included - Part 2\u00a0 \u00a0\u00a0 - RegInsights","description":"Advance your budgeting skills with our Excel template in Part 2 of Practical Tips for Building a Budget Tracker. Take control of your finances now","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2","og_locale":"en_US","og_type":"article","og_title":"Practical Tips for Building a Budget Tracker on Excel - Template Included - Part 2\u00a0 \u00a0\u00a0 - RegInsights","og_description":"Advance your budgeting skills with our Excel template in Part 2 of Practical Tips for Building a Budget Tracker. Take control of your finances now","og_url":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2","og_site_name":"RegInsights","article_publisher":"https:\/\/www.facebook.com\/RegenesysBusinessSchool\/","article_published_time":"2023-10-12T11:38:41+00:00","og_image":[{"width":850,"height":357,"url":"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png","type":"image\/png"}],"author":"Charne Olivier","twitter_card":"summary_large_image","twitter_creator":"@RegenesysB","twitter_site":"@RegenesysB","twitter_misc":{"Written by":"Charne Olivier","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#article","isPartOf":{"@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2"},"author":{"name":"Charne Olivier","@id":"https:\/\/www.regenesys.net\/reginsights\/#\/schema\/person\/37b1aec02c820663b50deb14aac2ee35"},"headline":"Practical Tips for Building a Budget Tracker on Excel &#8211; Template Included &#8211; Part 2\u00a0 \u00a0\u00a0","datePublished":"2023-10-12T11:38:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2"},"wordCount":806,"commentCount":0,"image":{"@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage"},"thumbnailUrl":"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png","articleSection":["Business and Finance"],"inLanguage":"en-ZA","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2","url":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2","name":"Practical Tips for Building a Budget Tracker on Excel - Template Included - Part 2\u00a0 \u00a0\u00a0 - RegInsights","isPartOf":{"@id":"https:\/\/www.regenesys.net\/reginsights\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage"},"image":{"@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage"},"thumbnailUrl":"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png","datePublished":"2023-10-12T11:38:41+00:00","author":{"@id":"https:\/\/www.regenesys.net\/reginsights\/#\/schema\/person\/37b1aec02c820663b50deb14aac2ee35"},"description":"Advance your budgeting skills with our Excel template in Part 2 of Practical Tips for Building a Budget Tracker. Take control of your finances now","breadcrumb":{"@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#breadcrumb"},"inLanguage":"en-ZA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2"]}]},{"@type":"ImageObject","inLanguage":"en-ZA","@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#primaryimage","url":"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png","contentUrl":"https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png","width":850,"height":357,"caption":"Budget template"},{"@type":"BreadcrumbList","@id":"https:\/\/www.regenesys.net\/reginsights\/practical-tips-for-building-a-budget-tracker-on-excel-template-included-part-2#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.regenesys.net\/reginsights\/"},{"@type":"ListItem","position":2,"name":"Practical Tips for Building a Budget Tracker on Excel &#8211; Template Included &#8211; Part 2\u00a0 \u00a0\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/www.regenesys.net\/reginsights\/#website","url":"https:\/\/www.regenesys.net\/reginsights\/","name":"RegInsights","description":"Thought Leadership","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.regenesys.net\/reginsights\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-ZA"},{"@type":"Person","@id":"https:\/\/www.regenesys.net\/reginsights\/#\/schema\/person\/37b1aec02c820663b50deb14aac2ee35","name":"Charne Olivier","image":{"@type":"ImageObject","inLanguage":"en-ZA","@id":"https:\/\/secure.gravatar.com\/avatar\/f65cd8f3e13456d94eb74e73ba59602e94ccdc41050674742811be7e4996209d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f65cd8f3e13456d94eb74e73ba59602e94ccdc41050674742811be7e4996209d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f65cd8f3e13456d94eb74e73ba59602e94ccdc41050674742811be7e4996209d?s=96&d=mm&r=g","caption":"Charne Olivier"},"description":"Charne Olivier - Articles provider for My Wealth Investment","url":"https:\/\/www.regenesys.net\/reginsights\/author\/charne-olivier"}]}},"rttpg_featured_image_url":{"full":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"landscape":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"portraits":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"thumbnail":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-150x63.png",80,34,true],"medium":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-300x126.png",300,126,true],"large":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",770,323,false],"1536x1536":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"2048x2048":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"post-thumbnail":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-270x180.png",270,180,true],"contentberg-main":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-770x357.png",770,357,true],"contentberg-main-full":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"contentberg-slider-stylish":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",850,357,false],"contentberg-slider-carousel":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-370x357.png",370,357,true],"contentberg-slider-grid-b":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-554x357.png",554,357,true],"contentberg-slider-grid-b-sm":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-306x357.png",306,357,true],"contentberg-slider-bold-sm":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-150x150.png",150,150,true],"contentberg-grid":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-370x245.png",370,245,true],"contentberg-list":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-260x200.png",260,200,true],"contentberg-list-b":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-370x305.png",370,305,true],"contentberg-thumb":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-87x67.png",87,67,true],"contentberg-thumb-alt":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-150x150.png",150,150,true],"gform-image-choice-sm":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",300,126,false],"gform-image-choice-md":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",400,168,false],"gform-image-choice-lg":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image.png",600,252,false],"web-stories-poster-portrait":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-640x357.png",640,357,true],"web-stories-publisher-logo":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-96x96.png",96,96,true],"web-stories-thumbnail":["https:\/\/www.regenesys.net\/reginsights\/wp-content\/uploads\/2023\/10\/Featured-image-150x63.png",150,63,true]},"rttpg_author":{"display_name":"Charne Olivier","author_link":"https:\/\/www.regenesys.net\/reginsights\/author\/charne-olivier"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.regenesys.net\/reginsights\/category\/a-z-topics\/business\" rel=\"category tag\">Business and Finance<\/a>","rttpg_excerpt":"The Excel template this article is based on, as well as a full explanation of it that includes part 1, can be requested from MyWealth Investments by e-mailing info@mywealthinvestments.co.za.\u00a0\u00a0 In last week\u2019s article, we started the discussion based on the budget template, as shown below. It is important to remember that the \u201ccurrent account\u201d box","_links":{"self":[{"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/posts\/147697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/comments?post=147697"}],"version-history":[{"count":0,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/posts\/147697\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/media\/147717"}],"wp:attachment":[{"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/media?parent=147697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/categories?post=147697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/tags?post=147697"},{"taxonomy":"country","embeddable":true,"href":"https:\/\/www.regenesys.net\/reginsights\/wp-json\/wp\/v2\/country?post=147697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}