Page 5 - May Financial Workbook

F Facility #: Towne Square Care of Puryear - SNF Facility Code: 1
Date: Jul 23, 2018 A/R Aging Report User: Zach Bell
Time: 16:06:23 CT May 2018 Page 1 of 2
Resident: All Status: Both Aging Type: A/R Aging Age By: Service Date Buckets: PCC Default Including adjustments to: July 2018 Including cash to: July 2018 Balance Filter
Options: All Payers: All

Payer Total Future Cash Current 30 60 90 120 150 180 210
+05/18 05/18 04/18 03/18 02/18 01/18 12/17 11/17 +10/17
AMERIGROUP (AMG-TN) ($20,187.86) $0.00 ($1,755.94) ($1,588.90) ($1,285.33) ($761.12) ($1,440.94) ($5,918.01) $1,761.67 ($9,199.29)
HOSPICE MEDICAID TN (HMT-TN) ($11,573.77) $0.00 ($0.02) $0.00 $0.00 $0.00 $0.04 ($6.18) $0.00 ($11,567.61)
MANAGED CARE - BLUE CROSS BLUE SHIELD $19,585.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,434.89 $7,150.46
(BC)
MANAGED CARE - HUMANA (HUM) $29,841.63 $0.00 $0.00 $0.00 $0.00 $4,063.74 $9,225.00 $0.00 $4,743.12 $11,809.77
MANAGED CARE THERAPIES (MCT) $578.34 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $578.34
MEDICAID BLUECARE TN (MBC-TN) ($24,058.01) $0.00 ($1,742.86) ($116.66) ($1,375.05) ($4,394.22) ($4,119.44) $3,787.79 $1,825.21 ($17,922.78)
MEDICAID PENDING (MP) $35,256.48 $0.00 $10,205.00 $6,950.00 $5,115.00 $3,135.00 $1,440.00 $5,095.00 $3,316.48 $0.00
MEDICARE A (MCA) $316,526.17 $0.00 $20,356.49 $28,440.39 $35,009.42 $26,196.67 $19,885.15 $24,079.54 $18,140.84 $144,417.67
MEDICARE A COINS FROM INSURANCE (MAI) $19,611.50 $0.00 $0.00 $0.00 $837.50 $1,172.50 $0.00 $1,974.00 $4,935.00 $10,692.50
MEDICARE A COINS FROM MEDICAID (MAM) $110,744.00 $0.00 $0.00 $5,360.00 $13,735.00 $15,410.00 $13,400.00 $6,415.50 $4,935.00 $51,488.50
MEDICARE B (MCB) $36,836.86 $0.00 $1,169.10 $10,704.18 $5,631.41 $4,086.06 $6,349.75 $798.07 $0.00 $8,098.29
MEDICARE B COINS FROM INSURANCE (MBI) $150.18 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $150.18
MEDICARE B COINS FROM MEDICAID (MBM) $6,972.20 $0.00 $227.63 $2,305.30 $1,348.10 $717.48 $697.91 $203.65 $0.00 $1,472.13
MEDICARE B COINS FROM PRIVATE (MBP) $1,008.75 $0.00 $103.37 $424.87 $88.24 $0.00 $0.00 $0.00 $0.00 $392.27
PRIVATE PAY (PP) $11,983.35 $0.00 $1,537.57 $753.14 $0.00 $324.82 $2,482.21 $660.24 $0.00 $6,225.37
RESIDENT LIABILITY (PL) $412.73 $0.00 ($109.88) $105.69 $416.92 $0.00 $0.00 $0.00 $0.00 $0.00
UNITEDHEALTHCARE MCO (UMC-TN) $12,327.26 $0.00 ($1,223.25) $8,166.90 $5,752.12 $1,321.00 $4,026.23 $2,368.51 ($701.10) ($7,383.15)
Total $546,015.16 $0.00 $28,767.21 $61,504.91 $65,273.33 $51,271.93 $51,945.91 $39,458.11 $51,391.11 $196,402.65