| DSO & Bad Debt Ratio Worksheet (click here for calculation worksheet) | |
| Company Profile | |
| What is the primary service your company provides? |
SELECT ONE -RESUBMIT FORM IF MORE THAN ONE CATEGORY APPLIES |
| Is your company national or regional? | |
| What are your company’s annual sales? | |
| AR Metrics | |
| What was the aging breakdown (in days beyond terms) of your company’s total accounts receivables from July 2005 through June 2006? Total should equal 100%. |
%=0-30 days %=31-60 %61-90 %=over 91 IMPT: BUCKETS SHOULD BE IN DAYS BEYOND TERMS BE SURE TOTAL IS 100% |
| What was your company’s average days sales outstanding for July 2005 through June 2006? | # days INSERT DSO FROM WORKSHEET HERE |
| What was your company’s bad debt ratio for July 2005 through June 2006? | % INSERT RATIO FROM WORKSHEET HERE |
| Overall, how has your AR performance trended from July 2005 to the end of June 2006? | |
| From what date do you age your invoices? | |
| Do you restart the aging date when a correction is made to an invoice? | |
| Collection Practices |
|
| What percentage of revenue was turned over to an outside collection agency / outsourcing firm from July 2005 through June 2006? |
First Party
%
Third Party
% N/A - Don't use outside agencies |
| Of revenue turned over to collection agencies from July 2005 through June 2006, what is the gross (no adjustments) percent that has been collected? |
First Party
%
Third Party % N/A - Don't use outside agencies |
| What are your primary criteria for placing an account for 3rd party collections? | |
| Do you change your "due" amount for delinquent payment (i.e. penalty, interest or revocation of discount)? | REQUIRED |
| Is your collections department decentralized, centralized, or a combination of both? | |
| What is your supervisor/team leader to collector ratio? | to 1 |
| What is your average number of of past due accounts handled per collector for national accounts? | |
| What is your average number of of accounts, both current and past due, handled per collector for smaller (non-national) accounts? | |
| Do you offer incentives for collectors? | |
| Credit Practices | |
| Do you use a decision support system in credit approval? | |
| If yes, do you use the scores to determine your collection treatment plan? | |
| Do you use credit limits? | |
| If yes, do you use credit limits to determine your collection treatment plan? | |
| Do you require credit applications for new accounts? | |
| What is the maximum amount of credit you would extend without doing credit check? | $ |
| Invoice Practices | |
| For what percentage of your BOL’s do you receive a 204/211 prior to freight billing? | % None Don't know |
| Do you offer a discount for electronic invoicing or electronic BOL submission? | |
| What is your average-days to invoice? | Based on: Pickup Date or Delivery Date# days Don't know |
| What
percentage of your invoices did you send via EDI from July 2005 through
June 2006? Is this a higher or lower % of prior year's EDI’s? |
%
None
Don't know Higher Lower About same |
| What percentage of invoices were you handling electronically other than EDI at the end of 2005 (e.g., online invoice presentment, email invoicing, fax, etc.)? | % None Don't know |
| What percentage of your paper invoices requires a POD or BOL copy as a prerequisite for payment? | % None Don't know |
| Do you charge a fee for providing paper attachments for POD’s or BOL? | |
| AR Practices | |
| What percentage of your remittances is received via EDI 820’s? | % Don't know |
| What is your auto write-off tolerance? | $ |
| What percentage of invoices is collected at the time of pickup or delivery? | % Don't know |
| What % of your A/R is paid by a Paying Agency? | % Don't know |
| What % of your Paying Agency A/R is beyond 90 days? Between 60 to 90? | % beyond 90 days % between 60 - 90 |
| Do you use Paying Agents websites for payment status on freight bills? If Yes, is this done manually or automated? | Manual Automated N/A |
| NACM
Member Completing the Survey - REQUIRED (for survey distribution verification purposes only) |
REQUIRED |
| NACM
Member number - REQUIRED (for survey distribution verification purposes only) |
REQUIRED |
© 2004 NACM Houston
Thank
you for your participation!
Responses must be received by
September 21, 2006
NACM South
Texas Home
Transportation Revenue
Management Group Home
Member Login -
Employment Opportunities -
Current
Calendar of Events -
NACMost Products &
Services -
Staff Directory -
Partner Programs -
Education &
Professional Development -
Request More Information
-
Photo Gallery - Credit Links