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
3PL
FUEL
LEASING
OTHER
SELECT ONE -RESUBMIT FORM IF MORE
THAN ONE CATEGORY APPLIES
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 2008-December 2008?
# days
INSERT
DSO FROM WORKSHEET HERE
9. By
how much has your DSO increased or decreased compared to the first six
months of 2008?
Increase
Decrease
# days or
N/A
10.
What was your company’s bad debt ratio for July 2008-December 2008?
%
N/A
INSERT RATIO FROM WORKSHEET HERE
11. What
was your Collection Effectiveness Index for the last six months of 2008?
%
N/A
INSERT NUMBER FROM WORKSHEET HERE
General Practices
Note: The responses provided in
this section will NOT be kept confidential, so that survey participants
may inquire further about responses.
12. What
is your spend on credit data per active account? Calculate by
dividing how much your company spends on external credit reports, data,
automated screening, etc. by the average number of accounts having A/R
balance a the end of each month.
$
or
N/A
13.
Do you accept credit card payments? If so, what % of your A/R (in
dollars) is usually paid by credit card?
Yes
No
N/A
%
14.
What percent of your revenue is from accessorial charges?
%
or
N/A
15.
Do you obtain authorization for detention charges? If so, what %
is usually obtained while the driver is waiting, as opposed to after the
fact?
Yes
No
N/A
%
16. What
percentage of your load tenders or bills of lading are received
electronically and imported into your order entry system?
% or
N/A
17.
Please break down your invoice delivery method by type:
% Paper
% EDI
% Email
(e.g. image sent by email)
% Online Presentment
(e.g. email notifies customer
to go online)
% Other
% None (e.g. customer pays
without receiving invoice)
% N/A
Total above should equal 100%
18. What
percentage of your invoice payments are received electronically?
%
None
Don't know
19. Do
you charge for paper invoices?
Yes
No
N/A
20. What
percentage of your invoice payments are applied to open invoices
automatically? Please calculate number of invoices (not payments) auto
applied as a % of total paid invoices.
% or
N/A
21.
In the past 6 months, has your outsourcing strategy using 1st party
collections expanded or contracted?
Expanded
Contracted
No Change
N/A
22. Do
you measure the length of time to respond to customer disputes? A
customer dispute is defined as any overpayment, partial payment or
nonpayment where the customer lets you know why they are disputing it
and therefore the bill(s) are put into dispute status. (Yes, No, N/A)
If
yes, please indicate number of days.
Yes
No
N/A
# of days
23.
Do you assess finance charges?
If yes, do you charge on invoices paid late or on both paid late and
unpaid beyond terms?
If yes, what percentage of finance charges invoiced do you collect?
Yes
No
Sometimes
N/A
Paid late
Unpaid beyond terms
Both
N/A
%
N/A
Don't know
24. What
percentage of your bad debt is associated with fraud? (Fraud is defined
as theft of services.)
%
Don't know
NACM
Member Completing the Survey - REQUIRED
(for survey distribution verification purposes only)
REQUIRED
NACM
Member number - REQUIRED
(for survey distribution verification purposes only)
REQUIRED