1.0Sacks Cargo https://sackscargo.comadminhttps://sackscargo.com/author/admin/rich600338<blockquote class="wp-embedded-content" data-secret="aQg3P2d3dH"><a href="https://sackscargo.com/average-collection-period-formula-calculator-excel/">Average Collection Period Formula Calculator Excel template</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://sackscargo.com/average-collection-period-formula-calculator-excel/embed/#?secret=aQg3P2d3dH" width="600" height="338" title="“Average Collection Period Formula Calculator Excel template” — Sacks Cargo " data-secret="aQg3P2d3dH" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /* <![CDATA[ */ /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); /* ]]> */ </script> The Average Collection Period represents the number of days that a company needs to collect cash payments from customers that paid on credit. For the formulas above, average accounts receivable is calculated by taking the average of the beginning and ending balances of a given period. More sophisticated accounting reporting tools may be able to […]