Page 5 - January Financial Workbook

Facility Code: 1 User: Zach Bell 1 Page 1 of 210 +06/17 ($930.24) ($11,261.18) $0.00 $0.00 $578.34 ($5,055.29) $0.00 $69,794.05 $8,389.50 $28,787.50 $2,844.11 $150.18 $524.11 $0.00 $6,325.37 $0.00 ($2,870.52) $97,275.93

180 07/17 $4,268.85 $6.30 $0.00 $0.00 $0.00 ($961.51) $0.00 $5,980.05 $1,316.00 $493.50 $846.17 $0.00 $215.87 $0.00 $0.00 $0.00 ($1,747.49) $10,417.74

150 08/17 ($7,321.84) ($177.01) $0.00 $0.00 $0.00 ($13,776.32) $0.00 $14,088.72 $0.00 $2,796.50 $1,432.67 $0.00 $224.10 $141.34 $0.00 $0.00 ($1,737.78) ($4,329.62)

Resident: All Status: Both Aging Type: A/R Aging Age By: Service Date Buckets: PCC Default Balance Filter Options: All Payers: All
120 09/17 $74.40 ($135.72) $0.00 $0.00 $0.00 $3,122.29 $0.00 $20,000.20 $0.00 $7,402.50 $1,789.30 $0.00 $239.01 $217.39 $0.00 $0.00 $184.05 $32,893.42

90
10/17 60 11/17 $9.61 $0.00 $0.00 $7,150.46 $11,809.77 $0.00 $0.00 ($263.06) $1,151.50 $30,873.46 $0.00 $0.00 $10,857.00 $0.00 $5,780.74 $0.00 $0.00 $269.04 $0.00 $33.54 $0.00 $1,172.23 $0.00 $636.29 ($65.17) $0.00 $68,779.12

Towne Square Care of Puryear - SNF A/R Aging Report January 2018 30 Current 12/17 01/18 $6,890.77 $23,027.58 $27,819.14 ($6.18) $10,426.72 $12,434.89 $0.00 $0.00 $4,743.12 $0.00 $9,225.00 $0.00 $0.00 $15,869.65 $14,122.70 $36,734.52 $8,251.48 $10,539.14 $10,909.30 $18,140.84 $24,079.55 $17,725.53 $0.00 $0.00 $3,454.50 $5,192.50 $8,060.82 $5,200.92 $8,671.75 $0.00 $0.00 $203.65 $534.46 $0.00 $0.00 $1,780.56 $3,364.50 $3,538.69 ($34.04) ($6

Future Cash $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($5,460.00) ($1,909.24) $0.00 ($7,369.24)

Total +01/18 $53,838.27 ($1,147.07) $19,585.35 $25,777.89 $578.34 $49,792.98 $30,851.42 $200,682.40 $9,705.50 $58,984.00 $34,626.48 $150.18 $2,210.24 $392.27 $10,721.35 ($1,981.03) $9,227.45 $503,996.02

Facility #: F Date: Apr 24, 2018 Time: 18:26:26 CT Payer AMERIGROUP (AMG-TN) HOSPICE MEDICAID TN (HMT-TN) MANAGED CARE - BLUE CROSS BLUE SHIELD (BC) MANAGED CARE - HUMANA (HUM) MANAGED CARE THERAPIES (MCT) MEDICAID BLUECARE TN (MBC-TN) MEDICAID PENDING (MP) MEDICARE A (MCA) MEDICARE A COINS FROM INSURANCE (MAI) MEDICARE A COINS FROM MEDICAID (MAM) MEDICARE B (MCB) MEDICARE B COINS FROM INSURANCE (MBI) MEDICARE B COINS FROM MEDICAID (MBM) MEDICARE B COINS FROM PRIVATE