RFP_31701-03816_SWC_Collection_Services_Attachment_6_7.xlsx

XLSX spreadsheet 13 KB Posted

Attached to
Statewide Collection Agency Services - UPDATED
Solicitation number
RFP 31701-03816
Issued by
Tennessee

About this file

This attachment to RFP 31701-03816 presents accounts receivable statistics for Tennessee's Statewide Collection Agency Services across eight state agencies from 2021 through 2025. The document provides critical baseline data for evaluating collection performance and agency debt portfolios, covering the Children's Services, Commerce and Insurance, Environment & Conservation, Finance and Administration, Health, Labor and Workforce, Tennessee Student Assistance Corporation, and Transportation departments. The attachment documents the number of accounts, account balances, and amounts collected annually for each agency, enabling prospective bidders to understand the scope and complexity of collection services required across the state portfolio.

The data reveals significant variation in collection volumes and performance across agencies, with total accounts ranging from 857 in 2021 to 9,594 in 2024, and total account balances peaking at approximately $8.8 million in 2024. Collection amounts total $264,594 across the five-year period, reflecting the challenging nature of state receivables including defaults, unpaid licensing and permit fees, parks accounts receivable and penalties, insurance-related receivables, administrative penalties, grant and loan forgiveness obligations, and damage claims. The accounts receivable types vary by agency, indicating that successful bidders must demonstrate capability in managing diverse debt categories and customer bases while achieving measurable collection results across multiple state departments.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet 1

ACCOUNTS RECEIVABLE STATISTICSRFP# 31701-03816
Attachment 6.7

2021 2022 2023 2024 2025 Total

State Agency Number of Accounts Account Balance Amount Collected Number of Accounts Account Balance Amount Collected Number of Accounts Account Balance Amount Collected Number of Accounts Account Balance Amount Collected Number of Accounts Account Balance Amount Collected Amount Collected

Children's Services (1)1862,158,6586,2101862,158,6583,7151862,158,6583,1701862,158,6582,724.491862,158,6583,875.0019,694
Commerce and Insurance (2)4699,32510,63380121,2054,32068107,3607,408107144,55115,464.7589145,8805,075.5342,902
Environment & Conservation (3)323343,95117,855175123,73821,76210931,070,72923,43470622,610,78244,636.75107,687
Finance and Administration (4)12473,4518,017256171,3665,42014985,2176,0277049,1682,435.003,602913,7493,140.0025,038
Health (5)2221,1889,0714024,861994455828,367495.00455828,3672,715.0013,275
Labor and Workforce (6)32112,06327,42727,427
Tennessee Student Assistance Corporation (7)1532,800,851300300
Transportation (8)124607,1263,100124258,9352,60017143,004,8303,442.005051,434,25119,128.5428,271

Total 857 3,415,762 82,313 861 2,858,764 38,810 1,649 6,222,815 40,338 9,594 8,796,356 69,198 4,837 5,480,907 33,934.07 264,594

Types of Accounts Receivable per Agency
(1) Defaults
(2) Unpaid Licensing and permit fees
(3) Parks Accounts Receivable and Penalties/Fees
(4) Accounts Receivable FSA or insurance
(5) Penalties, Bad checks
(6) Administrative Penalties
(7) Grant/Loan Forgiveness
(8) Damage claims/Insurance Adjustments & Settlements

File details come from the government source that posted it. Updated .