Page 5 - Financial April 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:05:33 CT April 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
+04/18 04/18 03/18 02/18 01/18 12/17 11/17 10/17 +09/17
AMERIGROUP (AMG-TN) ($18,431.92) $0.00 ($1,588.90) ($1,285.33) ($761.12) ($1,440.94) ($5,918.01) $1,761.67 $9.61 ($9,208.90)
HOSPICE MEDICAID TN (HMT-TN) ($11,573.75) $0.00 $0.00 $0.00 $0.00 $0.04 ($6.18) $0.00 $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 $12,434.89 $7,150.46 $0.00
(BC)
MANAGED CARE - HUMANA (HUM) $29,841.63 $0.00 $0.00 $0.00 $4,063.74 $9,225.00 $0.00 $4,743.12 $11,809.77 $0.00
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) ($23,247.63) $0.00 ($1,049.24) ($1,374.95) ($4,394.22) ($4,119.44) $3,787.79 $1,825.21 ($1,220.64) ($16,702.14)
MEDICAID PENDING (MP) $25,950.77 $0.00 $7,849.29 $5,115.00 $3,135.00 $1,440.00 $5,095.00 $3,316.48 $0.00 $0.00
MEDICARE A (MCA) $296,169.68 $0.00 $28,440.39 $35,009.42 $26,196.67 $19,885.15 $24,079.54 $18,140.84 $30,873.46 $113,544.21
MEDICARE A COINS FROM INSURANCE (MAI) $19,611.50 $0.00 $0.00 $837.50 $1,172.50 $0.00 $1,974.00 $4,935.00 $987.00 $9,705.50
MEDICARE A COINS FROM MEDICAID (MAM) $110,744.00 $0.00 $5,360.00 $13,735.00 $15,410.00 $13,400.00 $6,415.50 $4,935.00 $12,008.50 $39,480.00
MEDICARE B (MCB) $30,780.05 $0.00 $10,704.18 $5,631.41 $2,812.45 $2,735.65 $798.07 $0.00 $1,186.04 $6,912.25
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,744.57 $0.00 $2,305.30 $1,348.10 $717.48 $697.91 $203.65 $0.00 $269.04 $1,203.09
MEDICARE B COINS FROM PRIVATE (MBP) $905.38 $0.00 $424.87 $88.24 $0.00 $0.00 $0.00 $0.00 $33.54 $358.73
PRIVATE PAY (PP) $2,844.13 ($6,355.00) $753.14 $0.00 $0.00 $1,560.38 $660.24 $0.00 $0.00 $6,225.37
RESIDENT LIABILITY (PL) $507.01 ($7.00) $97.19 $416.82 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
UNITEDHEALTHCARE MCO (UMC-TN) $13,550.51 $0.00 $8,166.90 $5,752.12 $1,321.00 $4,026.23 $2,368.51 ($701.10) ($557.76) ($6,825.39)
Total $504,709.80 ($6,362.00) $61,463.12 $65,273.33 $49,673.50 $47,409.98 $39,458.11 $51,391.11 $62,549.02 $133,853.63