{"id":12249,"date":"2020-03-24T19:00:40","date_gmt":"2020-03-24T19:00:40","guid":{"rendered":"https:\/\/margill.com\/?p=12249"},"modified":"2025-10-10T09:32:01","modified_gmt":"2025-10-10T13:32:01","slug":"12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets","status":"publish","type":"post","link":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/","title":{"rendered":"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets!"},"content":{"rendered":"<p>I love spreadsheets, they are absolutely amazing for doing so many things. They are hugely flexible, powerful and allow you do to just about anything (almost). However, as we all know, they are also very dangerous because of human error!<\/p>\n<p>I recently implemented Margill Loan Manager with a new client who had been using spreadsheets (Excel) to manage its loans. As loans were imported we noticed that the interest calculated in Margill Loan Manager was $6000 higher for a quarter (3 months) that in was in Excel.<\/p>\n<p>When we looked at the formulas used to calculate interest, we immediately found the error. Notice the top calculation 245,000 x 14.5% is interest for 1 year, then divided by 12 for 1 month and multiplied by 3 for three months (very basic calculation method):<\/p>\n<p id=\"ZHxXgic\"><img loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"169\" class=\"alignnone size-full wp-image-12250 aligncenter\" src=\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png\" alt=\"\" srcset=\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png 373w, https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999-300x136.png 300w\" sizes=\"auto, (max-width: 373px) 100vw, 373px\" \/><\/p>\n<p>In the second calculation in the spreadsheet, notice that instead of a multiplication sign in the formula (12*3), a comma was inserted by error (12,3), thus the almost $6000 difference in total interest for those three months!<\/p>\n<p id=\"AErOvjo\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"174\" class=\"alignnone size-full wp-image-12251 aligncenter\" src=\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4cc1a2740.png\" alt=\"\" srcset=\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4cc1a2740.png 369w, https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4cc1a2740-300x141.png 300w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><\/p>\n<p>The same error was replicated a couple of times in the same loan and in other loans since this was used as a template.<\/p>\n<p>This error could have cost the lender tens of thousands of dollars before being spotted.<\/p>\n<p>Had the error been done the other way around, so to the advantage of the lender, even more serious legal repercussions could have resulted had this been a consumer loan.<\/p>\n<p>So, if you use spreadsheets, do be double cautious. even better, invest in a proper loan servicing solution. Simply finding this error paid many times for the user&#8217;s Margill Loan Manager.<\/p>\n<p>See also:<\/p>\n<ul>\n<li><a href=\"https:\/\/margill.com\/loan-servicing-excel-pitfalls-solutions\/\">Loan Servicing with Excel? Pitfalls and alternatives<\/a><\/li>\n<li><a href=\"https:\/\/margill.com\/5-advantages-using-loan-servicing-software\/\">5 Advantages to using Loan Servicing Software<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I love spreadsheets, they are absolutely amazing for doing so many things. They are hugely flexible, powerful and allow you do to just about anything (almost). However, as we all know, they are also very dangerous because of human error! I recently implemented Margill Loan Manager with a new client who had been using spreadsheets [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[405,193,404],"tags":[266,267,268],"class_list":["post-12249","post","type-post","status-publish","format-standard","hentry","category-margill-loan-manager-documentation","category-knowledge-base","category-margill-loan-manager","tag-danger-servicing-loans-in-excel","tag-excel-errors","tag-spreadsheet-interest-errors"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets! - Margill<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets! - Margill\" \/>\r\n<meta property=\"og:description\" content=\"I love spreadsheets, they are absolutely amazing for doing so many things. They are hugely flexible, powerful and allow you do to just about anything (almost). However, as we all know, they are also very dangerous because of human error! I recently implemented Margill Loan Manager with a new client who had been using spreadsheets [&hellip;]\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Margill\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-03-24T19:00:40+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-10-10T13:32:01+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"373\" \/>\r\n\t<meta property=\"og:image:height\" content=\"169\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"Marc G\u00e9linas\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc G\u00e9linas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\"},\"author\":{\"name\":\"Marc G\u00e9linas\",\"@id\":\"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81\"},\"headline\":\"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets!\",\"datePublished\":\"2020-03-24T19:00:40+00:00\",\"dateModified\":\"2025-10-10T13:32:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\"},\"wordCount\":285,\"image\":{\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png\",\"keywords\":[\"danger servicing loans in Excel\",\"Excel errors\",\"spreadsheet interest errors\"],\"articleSection\":[\"Documentation\",\"Knowledge Base\",\"Margill Loan Manager\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\",\"url\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\",\"name\":\"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets! - Margill\",\"isPartOf\":{\"@id\":\"https:\/\/margill.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png\",\"datePublished\":\"2020-03-24T19:00:40+00:00\",\"dateModified\":\"2025-10-10T13:32:01+00:00\",\"author\":{\"@id\":\"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81\"},\"breadcrumb\":{\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage\",\"url\":\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png\",\"contentUrl\":\"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/margill.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/margill.com\/en\/#website\",\"url\":\"https:\/\/margill.com\/en\/\",\"name\":\"Margill\",\"description\":\"Loan Servicing Solutions \/ Interest Calculators\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/margill.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81\",\"name\":\"Marc G\u00e9linas\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets! - Margill","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:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/","og_locale":"en_US","og_type":"article","og_title":"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets! - Margill","og_description":"I love spreadsheets, they are absolutely amazing for doing so many things. They are hugely flexible, powerful and allow you do to just about anything (almost). However, as we all know, they are also very dangerous because of human error! I recently implemented Margill Loan Manager with a new client who had been using spreadsheets [&hellip;]","og_url":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/","og_site_name":"Margill","article_published_time":"2020-03-24T19:00:40+00:00","article_modified_time":"2025-10-10T13:32:01+00:00","og_image":[{"width":373,"height":169,"url":"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png","type":"image\/png"}],"author":"Marc G\u00e9linas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc G\u00e9linas","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#article","isPartOf":{"@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/"},"author":{"name":"Marc G\u00e9linas","@id":"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81"},"headline":"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets!","datePublished":"2020-03-24T19:00:40+00:00","dateModified":"2025-10-10T13:32:01+00:00","mainEntityOfPage":{"@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/"},"wordCount":285,"image":{"@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png","keywords":["danger servicing loans in Excel","Excel errors","spreadsheet interest errors"],"articleSection":["Documentation","Knowledge Base","Margill Loan Manager"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/","url":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/","name":"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets! - Margill","isPartOf":{"@id":"https:\/\/margill.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png","datePublished":"2020-03-24T19:00:40+00:00","dateModified":"2025-10-10T13:32:01+00:00","author":{"@id":"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81"},"breadcrumb":{"@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#primaryimage","url":"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png","contentUrl":"https:\/\/margill.com\/wp-content\/uploads\/2020\/03\/img_5e7a4c9aa1999.png"},{"@type":"BreadcrumbList","@id":"https:\/\/margill.com\/en\/12000-reasons-why-to-use-loan-servicing-software-as-opposed-to-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/margill.com\/en\/"},{"@type":"ListItem","position":2,"name":"12,000 Reasons why to use Loan Servicing Software as opposed to Spreadsheets!"}]},{"@type":"WebSite","@id":"https:\/\/margill.com\/en\/#website","url":"https:\/\/margill.com\/en\/","name":"Margill","description":"Loan Servicing Solutions \/ Interest Calculators","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/margill.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/margill.com\/en\/#\/schema\/person\/72f5aeeb0d0d040309ac495539c5fb81","name":"Marc G\u00e9linas"}]}},"_links":{"self":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts\/12249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/comments?post=12249"}],"version-history":[{"count":1,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts\/12249\/revisions"}],"predecessor-version":[{"id":20499,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/posts\/12249\/revisions\/20499"}],"wp:attachment":[{"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/media?parent=12249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/categories?post=12249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/margill.com\/en\/wp-json\/wp\/v2\/tags?post=12249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}