Accounts Receivable Quarterly Activity Quarter Ending September 30 ...
Accounts Receivable Quarterly Activity Quarter Ending September 30, 2016
Agency
Type of Receivable
Current
1-30 Days
Past Due 61-90 Days
31-60 Days
91-120 Days
Over 120 Days
Cost of Collection
Write-off
General Assembly Secretary of State State Auditor
Accounts Receivable Accounts Receivable Interfund Receivable
2,459 1,143,209
1,439 10,153 -
447 6,338 -
6,010 -
532 6,887 -
41 86,757 28,399
9,349 -
11,739 -
State Treasurer
Accounts Receivable Notes Receivable Other Receivables Accounts Receivable Intergov. Receivable Notes Receivable Interfund Receivable Other Receivables Accounts Receivable Intergov. Receivable Interfund Receivable Accounts Receivable Notes Receivable Accounts Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Other Receivables Accounts Receivable Accounts Receivable Intergov. Receivable
408,541 45,464 15,428 135,930 506,094 854,793 375,686 696,651 836,046 39,986 5,985,058 534,859 55,750 5,586,235 355,428
429,983 825,080 14,007 5,047,994 44,686 25,401 301 320,237 840,447 53,966 599,825 164,759 1,899 3,811,600 10,614 7,364 2,492,438 125,950
2,772,263 3,246 5,340 5,674 135,017 153,398 385,295 28,599 66,482 5,005 897,677 5,673 7,697 2,424,394 164,213
2,418,729 444 525 574 84,259 232,493 19,741 10,818 859,911 3,182 2,112 1,847,192 102,884
879,041 8,146 11,357,987 100,544 57,152 5,879 89,305 85,115 118,850 174,046 44,893 8,432 18,781 2,083,733 5,275 5,199 2,065,743 -
30,095,379 29,066 8,533,990 78,201 44,451 116 71,542 4,115,021 20,184 83,276 41,740 0 16,471,171 -
361,923 8,127 127,556 -
7,900 1,255,991 -
DPI
Justice
Agriculture Agriculture Finance Labor Insurance
Administration
OSC DOT
Notes Receivable Other Receivables DEQ
Wildlife DPS
DHHS - Central Administration DHHS - Aging DHHS - Child Development DHHS - Social Services DHHS - DMA
DHHS - Blind DHHS - Health Service Reg DHHS - Vocational Rehab DHHS - DMH/DD/SAS DHHS - Disability Determination DHHS - Public Health
Taxes Receivable Accounts Receivable Intergov. Receivable Notes Receivable Interfund Receivable Other Receivables Other Receivables Accounts Receivable Intergov. Receivable Notes Receivable Interfund Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable
179,676
-
-
-
-
671,759
-
-
2,482,780
1,991,612
1,551,858
1,868,034
7,769,155
17,469,086
-
-
2,251,161 5,915,254 1,195,668,117 4,749,792 2,846,204 207,409 908,046 4,573,714 500 1,996,544 58,386 1,025 82,018
262,351 155 171,681 891,186 500 472,431 750 1,727,478 5,171,368 209,196 211,171,729 508,070
400,489 69,217 307,029 500 154,433 168,946 1,660,084 232,483,009 25 5,888 86,900 7,074,346 408,755
785,137 235,449 251,876 327,487 500 161,734 187 1,777,604 3,740,155 15,013 880 2,622,647 83,823
19,680 2,281 14,955 34,314 500 4,063 333 1,719,651 1,030,231 65,059 111,522 5,677,503 258,242
608,222 478,959 1,262,998 674,627 710,882 397,443 79,810 18,511 12,389,869 107,275,419 81,528 1,529,974 428,788 65,558,935 7,248 947,473
2,150 11,189 16,686 7,312 18,396 5,660 13,444 31,840 217,356 9,198 24,057 4,953 357,390 4,953 33,255
22 189,535 526,607 18,594,397 -
Accounts Receivable Quarterly Activity Quarter Ending September 30, 2016 Accounts Receivable Taxes Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Other Receivables
Information Technology Commerce
(a)
Revenue Natural Cultural Resources Community Colleges Board of Elections Education Lottery Admin. Hearings Housing Finance Agency NC Global TransPark Ports Authority
Gateway University Research Park
OSC Central Accounts
Taxes Receivable Other Receivables Accounts Receivable Intergov. Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Notes Receivable Accounts Receivable Intergov. Receivable Accounts Receivable Intergov. Receivable Notes Receivable Other Receivables Taxes Receivable Accounts Receivable Interfund Receivable Accounts Receivable
11,048,321 321 -
1,117,964 2,411,211 2,700,397 -
987,380 3,090,023 1,893,863 160 -
9,212,130 3,350,040 -
143,996 984,189 3,364,137 11,405 -
419,282 70,474,042 147,011,597 7,703 1,415
-
76,575,509
35,528,978
7,250
42,962,727
1,103,940,502
(b)
481 28,000 6,197,785 674,549,093 28,453 73,534 575,051 176,417 -
1,973 92 31,800 23,281,495 285 47,096,907 14,615 3,031,618 79,160 231,362 87,225 275 -
16,444 125 115,750 44,180 12,951,506 3,998 1,205,245 1,202 135,931 -
242 27,300 8,924 4,043,950 7,225 355,016 163,852 -
16,929 4 2,250 44,033 12,037,074 85,753 351,161 325 -
2,945 344,450 680,507 9,529,191 1,154 854,584 17,249 85,272 1,722 345
(b)
394,068,538
$ 307,413,025
$ 1,932,175,697
$
$
34,635,327
$
93,827,010
$
1,603,662,825
(a)
The Accounts Receivable balances are provied as gross numbers without an allowance for doubtful accounts that is calculated at fiscal year-end. Certain General Fund Accounts Receivable amounts are not included nor apportioned to this aging schedule. The smaller tax types administered by the Department have been transferred from legacy tax systems to the ETM system. Accounts receivable reporting in ETM is not functional as of the due date of this report. Certain Highway Fund Accounts Receivable amounts are not included nor apportioned to this aging schedule. Certain motor fuels taxes administered by the Department have been transferred a legacy tax system to the ETM system. Accounts receivable reporting in ETM is not functional as of the due date of this report. this report. The Unauthorized Substance Tax Accounts Receivable amount of $489 million has not been included nor apportioned to this aging schedule. This aging breakdown is not available for this tax type. Historically, 2% of the Unauthorized Substance Tax is collectible. The Insurance Tax Accounts Receivable amount of $122415 has not been included nor apportioned to this aging schedule. The aging breakdown is not available for this tax type. The amounts reflected in the "Write-Off" column represent write-off amounts for the period October 1, 2016 through December 31, 2016. The write-off adjustments are already reflected in the Accounts Receivable balances in this report. A negative write-off amount occurs when previously written-off accounts are reversed for the purpose of applying payments and conducting new collection activities A new receivable for 911 Service Charge is included on this quarterly report. This is the first quarter there have been outstanding receivables related to the 911 Service Charge and because it is considered a service charge rather than a tax (see G.S. 143B-1403), the new 911 receivables are included as a line item under Other Receivables instead of Taxes Receivable
(b)
Unable to Determine
30,029 -
$
6,600,739 5,593,664 168,185 25,613,210
-
19 -
25,826 50,000 14,247 -
318,528 104,966 86,331 -
1,384,896
$
59,071,832
Agency
Type of Receivable
Current
1-30 Days
Past Due 61-90 Days
31-60 Days
91-120 Days
Over 120 Days
Cost of Collection
Write-off
General Assembly Secretary of State State Auditor
Accounts Receivable Accounts Receivable Interfund Receivable
2,459 1,143,209
1,439 10,153 -
447 6,338 -
6,010 -
532 6,887 -
41 86,757 28,399
9,349 -
11,739 -
State Treasurer
Accounts Receivable Notes Receivable Other Receivables Accounts Receivable Intergov. Receivable Notes Receivable Interfund Receivable Other Receivables Accounts Receivable Intergov. Receivable Interfund Receivable Accounts Receivable Notes Receivable Accounts Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Other Receivables Accounts Receivable Accounts Receivable Intergov. Receivable
408,541 45,464 15,428 135,930 506,094 854,793 375,686 696,651 836,046 39,986 5,985,058 534,859 55,750 5,586,235 355,428
429,983 825,080 14,007 5,047,994 44,686 25,401 301 320,237 840,447 53,966 599,825 164,759 1,899 3,811,600 10,614 7,364 2,492,438 125,950
2,772,263 3,246 5,340 5,674 135,017 153,398 385,295 28,599 66,482 5,005 897,677 5,673 7,697 2,424,394 164,213
2,418,729 444 525 574 84,259 232,493 19,741 10,818 859,911 3,182 2,112 1,847,192 102,884
879,041 8,146 11,357,987 100,544 57,152 5,879 89,305 85,115 118,850 174,046 44,893 8,432 18,781 2,083,733 5,275 5,199 2,065,743 -
30,095,379 29,066 8,533,990 78,201 44,451 116 71,542 4,115,021 20,184 83,276 41,740 0 16,471,171 -
361,923 8,127 127,556 -
7,900 1,255,991 -
DPI
Justice
Agriculture Agriculture Finance Labor Insurance
Administration
OSC DOT
Notes Receivable Other Receivables DEQ
Wildlife DPS
DHHS - Central Administration DHHS - Aging DHHS - Child Development DHHS - Social Services DHHS - DMA
DHHS - Blind DHHS - Health Service Reg DHHS - Vocational Rehab DHHS - DMH/DD/SAS DHHS - Disability Determination DHHS - Public Health
Taxes Receivable Accounts Receivable Intergov. Receivable Notes Receivable Interfund Receivable Other Receivables Other Receivables Accounts Receivable Intergov. Receivable Notes Receivable Interfund Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable
179,676
-
-
-
-
671,759
-
-
2,482,780
1,991,612
1,551,858
1,868,034
7,769,155
17,469,086
-
-
2,251,161 5,915,254 1,195,668,117 4,749,792 2,846,204 207,409 908,046 4,573,714 500 1,996,544 58,386 1,025 82,018
262,351 155 171,681 891,186 500 472,431 750 1,727,478 5,171,368 209,196 211,171,729 508,070
400,489 69,217 307,029 500 154,433 168,946 1,660,084 232,483,009 25 5,888 86,900 7,074,346 408,755
785,137 235,449 251,876 327,487 500 161,734 187 1,777,604 3,740,155 15,013 880 2,622,647 83,823
19,680 2,281 14,955 34,314 500 4,063 333 1,719,651 1,030,231 65,059 111,522 5,677,503 258,242
608,222 478,959 1,262,998 674,627 710,882 397,443 79,810 18,511 12,389,869 107,275,419 81,528 1,529,974 428,788 65,558,935 7,248 947,473
2,150 11,189 16,686 7,312 18,396 5,660 13,444 31,840 217,356 9,198 24,057 4,953 357,390 4,953 33,255
22 189,535 526,607 18,594,397 -
Accounts Receivable Quarterly Activity Quarter Ending September 30, 2016 Accounts Receivable Taxes Receivable Accounts Receivable Intergov. Receivable Interfund Receivable Other Receivables
Information Technology Commerce
(a)
Revenue Natural Cultural Resources Community Colleges Board of Elections Education Lottery Admin. Hearings Housing Finance Agency NC Global TransPark Ports Authority
Gateway University Research Park
OSC Central Accounts
Taxes Receivable Other Receivables Accounts Receivable Intergov. Receivable Accounts Receivable Accounts Receivable Accounts Receivable Accounts Receivable Notes Receivable Accounts Receivable Intergov. Receivable Accounts Receivable Intergov. Receivable Notes Receivable Other Receivables Taxes Receivable Accounts Receivable Interfund Receivable Accounts Receivable
11,048,321 321 -
1,117,964 2,411,211 2,700,397 -
987,380 3,090,023 1,893,863 160 -
9,212,130 3,350,040 -
143,996 984,189 3,364,137 11,405 -
419,282 70,474,042 147,011,597 7,703 1,415
-
76,575,509
35,528,978
7,250
42,962,727
1,103,940,502
(b)
481 28,000 6,197,785 674,549,093 28,453 73,534 575,051 176,417 -
1,973 92 31,800 23,281,495 285 47,096,907 14,615 3,031,618 79,160 231,362 87,225 275 -
16,444 125 115,750 44,180 12,951,506 3,998 1,205,245 1,202 135,931 -
242 27,300 8,924 4,043,950 7,225 355,016 163,852 -
16,929 4 2,250 44,033 12,037,074 85,753 351,161 325 -
2,945 344,450 680,507 9,529,191 1,154 854,584 17,249 85,272 1,722 345
(b)
394,068,538
$ 307,413,025
$ 1,932,175,697
$
$
34,635,327
$
93,827,010
$
1,603,662,825
(a)
The Accounts Receivable balances are provied as gross numbers without an allowance for doubtful accounts that is calculated at fiscal year-end. Certain General Fund Accounts Receivable amounts are not included nor apportioned to this aging schedule. The smaller tax types administered by the Department have been transferred from legacy tax systems to the ETM system. Accounts receivable reporting in ETM is not functional as of the due date of this report. Certain Highway Fund Accounts Receivable amounts are not included nor apportioned to this aging schedule. Certain motor fuels taxes administered by the Department have been transferred a legacy tax system to the ETM system. Accounts receivable reporting in ETM is not functional as of the due date of this report. this report. The Unauthorized Substance Tax Accounts Receivable amount of $489 million has not been included nor apportioned to this aging schedule. This aging breakdown is not available for this tax type. Historically, 2% of the Unauthorized Substance Tax is collectible. The Insurance Tax Accounts Receivable amount of $122415 has not been included nor apportioned to this aging schedule. The aging breakdown is not available for this tax type. The amounts reflected in the "Write-Off" column represent write-off amounts for the period October 1, 2016 through December 31, 2016. The write-off adjustments are already reflected in the Accounts Receivable balances in this report. A negative write-off amount occurs when previously written-off accounts are reversed for the purpose of applying payments and conducting new collection activities A new receivable for 911 Service Charge is included on this quarterly report. This is the first quarter there have been outstanding receivables related to the 911 Service Charge and because it is considered a service charge rather than a tax (see G.S. 143B-1403), the new 911 receivables are included as a line item under Other Receivables instead of Taxes Receivable
(b)
Unable to Determine
30,029 -
$
6,600,739 5,593,664 168,185 25,613,210
-
19 -
25,826 50,000 14,247 -
318,528 104,966 86,331 -
1,384,896
$
59,071,832
