DSO
& Bad Debt Ratio Worksheet (click here for calculation worksheet)
Company Profile & AR Metrics
Note: The responses
provided in this section will be kept confidential.
1. What is the primary service
your company provides?
LTL
TL
RAIL
AIR CARRIER
3PL
FUEL
LEASING
FACTORING
2. Is your company
regional or national/international?
National/International
Regional
Other
3. What are your company’s
annual sales?
Under $100M
$100M-500M
Over $500M
4. What
percent of your receivables was 0-30 days from date of invoice?
5. What
percent of your receivables was 31-60 days from date of invoice?
6. What
percent of your receivables was 61-90 days from date of invoice?
7. What
percent of your receivables was over 91 days from date of invoice?
(Total for #4-7 should equal 100%)
8. What was your company’s
average days sales outstanding for July 2007-December 2007?
9.
What was your company’s bad debt ratio for July 2007-December 2007?
General Practices
Note: The responses provided in
this section will NOT be kept confidential, so that survey participants
may inquire further about responses.
10. What
percentage of your BOL’s does your company receive electronically (EDI,
web or other) prior to freight billing?
11. What
percentage of your invoices does your company send electronically (EDI,
email, web, other)?
12.
Over the past 15 months, has your company seen an increase in turnover
in their customer service department? (Customer service is defined
as the department that would receive complaint calls from customers.)
Yes
No
Dont_ Know
13.
If you answered #12 Yes, what was the percentage increase?
14.
Does your company use a Collection Efficiency Index (CEI)?
If Yes, what was your Collection Efficiency Index
(CEI) for the last six months of 2007?
Yes
No
15.
What is the average number of accounts your collectors handle?
16.
Do you measure the time your collectors spend on the phone?
If Yes, what was the average time per day per
collector over the last six months of 2007?
Yes
No
17.
What percent of your revenue is from accessorial changes?
18. What
percent of your accessorial revenue is collected?
19. Do
you track billing and rate errors together or separately? (A
billing error is defined as any error on the freight bill not related to
the rate, such as wrong billing address, missing delivery instructions,
wrong weight, etc. A rate error is anything related to the
accurate rating of a freight bill, such as wrong class, base rate,
discount, accessorial charge, etc.)
Together
Separately
Do Not Track
20. What
is your % of billing errors to total invoices, if tracked separately
from rating errors?
21. What
is your % of rate errors to total invoices, if tracked separately from
billing errors?
22. What
is your % of combined billing and rate errors to total invoices, if you
don't track separately ?
23. Do
you Interline with other carriers on a regular basis?
Yes
No
24. Since
most agreements honor the Interline carrier's customer pricing, do you
obtain the correct rates prior to invoicing
If No, do you issue rebills or allow the carrier to pay short and write
off the balance due?
Yes
No
N/A
Rebill
Write-Off
Other
N/A
25. Do
you use an automated web scraping method for gathering payment status
from freight payment service companies? If
Yes, what is the average invoice age you run the program?
Yes
No
Sometimes
NACM
Member Completing the Survey - REQUIRED
REQUIRED
NACM
Member number - REQUIRED
REQUIRED