Page 5 - June 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:07:21 CT June 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
+06/18 06/18 05/18 04/18 03/18 02/18 01/18 12/17 +11/17
AMERIGROUP (AMG-TN) ($21,628.75) $0.00 ($1,440.89) ($1,755.94) ($1,588.90) ($1,285.33) ($761.12) ($1,440.94) ($5,918.01) ($7,437.62)
HOSPICE MEDICAID TN (HMT-TN) $1,305.65 $0.00 $12,879.42 ($0.02) $0.00 $0.00 $0.00 $0.04 ($6.18) ($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 $0.00 $19,585.35
(BC)
MANAGED CARE - HUMANA (HUM) $29,841.63 $0.00 $0.00 $0.00 $0.00 $0.00 $4,063.74 $9,225.00 $0.00 $16,552.89
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) ($25,253.55) $0.00 ($1,195.54) ($1,742.86) ($116.66) ($1,375.05) ($4,394.22) ($4,119.44) $3,787.79 ($16,097.57)
MEDICAID PENDING (MP) $42,681.48 $0.00 $7,425.00 $10,205.00 $6,950.00 $5,115.00 $3,135.00 $1,440.00 $5,095.00 $3,316.48
MEDICARE A (MCA) $332,211.31 $0.00 $15,685.14 $20,356.49 $28,440.39 $35,009.42 $26,196.67 $19,885.15 $24,079.54 $162,558.51
MEDICARE A COINS FROM INSURANCE (MAI) $19,611.50 $0.00 $0.00 $0.00 $0.00 $837.50 $1,172.50 $0.00 $1,974.00 $15,627.50
MEDICARE A COINS FROM MEDICAID (MAM) $129,001.50 $0.00 $10,050.00 $7,872.50 $5,695.00 $13,735.00 $15,410.00 $13,400.00 $6,415.50 $56,423.50
MEDICARE B (MCB) $46,168.57 $0.00 $0.00 $10,500.81 $10,704.18 $5,631.41 $4,086.06 $6,349.75 $798.07 $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) $8,519.20 $0.00 $0.00 $1,774.63 $2,305.30 $1,348.10 $717.48 $697.91 $203.65 $1,472.13
MEDICARE B COINS FROM PRIVATE (MBP) $1,195.81 $0.00 $0.00 $290.43 $424.87 $88.24 $0.00 $0.00 $0.00 $392.27
PRIVATE INSURANCE (PI) $320.00 $0.00 $320.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
PRIVATE PAY (PP) $104.58 ($12,400.00) $785.20 $1,611.01 $415.73 $0.00 $324.82 $2,482.21 $660.24 $6,225.37
RESIDENT LIABILITY (PL) ($10,271.33) ($12,176.68) $796.13 $586.61 $105.69 $416.92 $0.00 $0.00 $0.00 $0.00
UNITEDHEALTHCARE MCO (UMC-TN) $11,142.96 $0.00 ($1,184.30) ($1,223.25) $8,166.90 $5,752.12 $1,321.00 $4,026.23 $2,368.51 ($8,084.25)
Total $585,264.43 ($24,576.68) $44,120.16 $48,475.41 $61,502.50 $65,273.33 $51,271.93 $51,945.91 $39,458.11 $247,793.76