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 STATISTICS | RFP# 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) | 186 | 2,158,658 | 6,210 | 186 | 2,158,658 | 3,715 | 186 | 2,158,658 | 3,170 | 186 | 2,158,658 | 2,724.49 | 186 | 2,158,658 | 3,875.00 | 19,694 |
| Commerce and Insurance (2) | 46 | 99,325 | 10,633 | 80 | 121,205 | 4,320 | 68 | 107,360 | 7,408 | 107 | 144,551 | 15,464.75 | 89 | 145,880 | 5,075.53 | 42,902 |
| Environment & Conservation (3) | 323 | 343,951 | 17,855 | 175 | 123,738 | 21,762 | 1093 | 1,070,729 | 23,434 | 7062 | 2,610,782 | 44,636.75 | 107,687 | |||
| Finance and Administration (4) | 124 | 73,451 | 8,017 | 256 | 171,366 | 5,420 | 149 | 85,217 | 6,027 | 70 | 49,168 | 2,435.00 | 3,602 | 913,749 | 3,140.00 | 25,038 |
| Health (5) | 22 | 21,188 | 9,071 | 40 | 24,861 | 994 | 455 | 828,367 | 495.00 | 455 | 828,367 | 2,715.00 | 13,275 | |||
| Labor and Workforce (6) | 32 | 112,063 | 27,427 | 27,427 | ||||||||||||
| Tennessee Student Assistance Corporation (7) | 153 | 2,800,851 | 300 | 300 | ||||||||||||
| Transportation (8) | 124 | 607,126 | 3,100 | 124 | 258,935 | 2,600 | 1714 | 3,004,830 | 3,442.00 | 505 | 1,434,251 | 19,128.54 | 28,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 .