J.1.D Cash Collections Worksheet For HIGLAS Users.xlsx

XLSX spreadsheet 64 KB Posted Aug 3, 2020

Attached to: Part A/Part B Medicare Administrative Contractor (MAC) Jurisdiction L (JL)
Solicitation number: 75FCMC20R0008
Issued by: Department of Health and Human Services Centers for Medicare and Medicaid Services

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a federal contract opportunity solicitation for Medicare Administrative Contractor services in Jurisdiction L. The Centers for Medicare and Medicaid Services seeks a contractor to provide specified health insurance benefit administration services including Medicare claims processing and payment to support the Medicare Fee-For-Service Program in Delaware, Maryland, New Jersey, Pennsylvania, the District of Columbia, and parts of Virginia. Required services include processing and paying Medicare Part A and Part B claims. The contractor will also provide customer service and other administrative functions for the Medicare program in the designated jurisdiction, which covers approximately 5.8 million beneficiaries. The period of performance and value of the contract were not specified in the opportunity description provided.

View the file

Other files

File	Type	Posted
J.23 Government Provided Proposal Assumptions (GPPA) redline Amend 2.docx	DOCX document	Sep 16, 2020
J.23 Government Provided Proposal Assumptions (GPPA) clean Amend 2.docx	DOCX document	Sep 16, 2020
75FCMC20R0008 Amend 2.pdf	PDF	Sep 16, 2020
JL Solicitation 75FCMC20R0008 Sections B-M CLEAN Amend 1.pdf	PDF	Sep 4, 2020
Q and A RFP 75FCMC20R00008.xlsx	XLSX spreadsheet	Sep 4, 2020
J.34 CLIN 0001 Cost Proposal Template - Implementation clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.37 CLIN 0004 Cost Proposal Template - Option Year 2 (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.23 Government Provided Proposal Assumptions (GPPA) redline Amend 1.docx	DOCX document	Sep 4, 2020
J.48 CLIN 0015 Cost Proposal Template - Option Year 5 (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.43 CLIN 0010 Cost Proposal Template - Base Year (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.22 Basis of Estimate redline Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.22.A Historic & Proposed FTE, Hours & Gross Cost Instructions & Narrative redline Amend 1.docx	DOCX document	Sep 4, 2020
J.46 CLIN 0013 Cost Proposal Template - Option Year 3 (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.1 Statement of Work (SOW) clean Amend 1.docx	DOCX document	Sep 4, 2020
J.33 Cost Template Summary Sheet clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.21 Proposal Self-Check Tool clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.49 CLIN 0016 Cost Proposal Template - Option Year 6 (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.22.A Historic & Proposed FTE, Hours & Gross Cost Instructions & Narrative clean Amend 1.docx	DOCX document	Sep 4, 2020
JL Solicitation 75FCMC20R0008 Sections B-M REDLINE Amend 1.pdf	PDF	Sep 4, 2020
J.45 CLIN 0012 Cost Proposal Template - Option Year 2 (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.40 CLIN 0007 Cost Proposal Template - Option Year 5 (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.41 CLIN 0008 Cost Proposal Template - Option Year 6 (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.22 Basis of Estimate clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.38 CLIN 0005 Cost Proposal Template - Option Year 3 (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.42 CLIN 0009 Cost Proposal Template - Outgoing Contractor Workload Transition Activities clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.36 CLIN 0003 Cost Proposal Template - Option Year 1 (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.1 Statement of Work (SOW) redline Amend 1.docx	DOCX document	Sep 4, 2020
J.47 CLIN 0014 Cost Proposal Template - Option Year 4 (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.35 CLIN 0002 Cost Proposal Template - Base Year (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.23 Government Provided Proposal Assumptions (GPPA) clean Amend 1.docx	DOCX document	Sep 4, 2020
J.21 Proposal Self-Check Tool redline Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.39 CLIN 0006 Cost Proposal Template - Option Year 4 (PM, MIP, RAC) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
J.44 CLIN 0011 Cost Proposal Template - Option Year 1 (MPIP) clean Amend 1.xlsx	XLSX spreadsheet	Sep 4, 2020
75FCMC20R0008.pdf	PDF	Sep 4, 2020
J.37 CLIN 0004 Cost Proposal Template - Option Year 2 (PM, MIP, RAC).xlsx	XLSX spreadsheet	Aug 3, 2020
J.22.A Historic & Proposed FTE, Hours & Gross Cost Instructions & Narrative.docx	DOCX document	Aug 3, 2020
J.24 Attestations.docx	DOCX document	Aug 3, 2020
J.45 CLIN 0012 Cost Proposal Template - Option Year 2 (MPIP).xlsx	XLSX spreadsheet	Aug 3, 2020
J.10 Contractor Business Ethics COI and Compliance Program Requirements.docx	DOCX document	Aug 3, 2020
J.1.B List of Key Acronyms.docx	DOCX document	Aug 3, 2020
J.33 Cost Template Summary Sheet.xlsx	XLSX spreadsheet	Aug 3, 2020
J.35 CLIN 0002 Cost Proposal Template - Base Year (PM, MIP, RAC).xlsx	XLSX spreadsheet	Aug 3, 2020
J.23.A GPPA Audit & Reimbursement Tables.xlsx	XLSX spreadsheet	Aug 3, 2020
J.42 CLIN 0009 Cost Proposal Template - Outgoing Contractor Workload Transition Activites.xlsx	XLSX spreadsheet	Aug 3, 2020
J.2 Deliverable Schedule.docx	DOCX document	Aug 3, 2020
J.1 Statement of Work (SOW) - Jurisdiction L.docx	DOCX document	Aug 3, 2020
J.7 AB MAC Award Fee Plan and Self Assessment Template.docx	DOCX document	Aug 3, 2020
J.9 Non-Disclosure Statement.docx	DOCX document	Aug 3, 2020
J.40 CLIN 0007 Cost Proposal Template - Option Year 5 (PM, MIP, RAC).xlsx	XLSX spreadsheet	Aug 3, 2020
J.43 CLIN 0010 Cost Proposal Template - Base Year (MPIP).xlsx	XLSX spreadsheet	Aug 3, 2020

Show 40 more

Latest 50 of 79 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Allowance

Contractor Name:							LEGEND			Exhibit 1
						Warning: There could be an issue but there may not be.
Period Ending:						Issue: There is an issue such as missing data that needs to be resolved.
						This cell requires manual input
Allowance for Uncollectible Accounts Matrix
			NONFEDERAL-HI-MSP-CM-Registers-TOTAL	NONFEDERAL-HI-NONMSP-CM-Registers-TOTAL	NONFEDERAL-SMI-MSP-CM-Registers-TOTAL	NONFEDERAL-SMI-NONMSP-CM-Registers-TOTAL	NONFEDERAL-GEN-MSP-CM-Registers-TOTAL	NONFEDERAL-GEN-NONMSP-CM-Registers-TOTAL		NONFEDERAL-NA-NA-CM-TROR-TOTAL
			Col E	Col F	Col G	Col H	Col I	Col J
			HI Principal	HI Principal	SMI Principal	SMI Principal	General Fund	General Fund	Fund	TROR
Note: Amounts are from the TROR Supporting Reports			MSP	NON-MSP	MSP	NON-MSP	MSP	NON-MSP	Total	Report	Check
	TROR Line Item	HIGLAS Detail Activity Report/Register Line
A	(1) Beginning FY Balance	CMS Beginning Balance Report / (1) Beginning FY Balance	0	0	71	7,471,680	39	156,949	7,628,739	7,628,738	1
	(2) New Receivables (+)	CMS Transaction Register / LINE 2 NEW RECEIVABLES	0	0	0	12,715,571	0	0	12,715,571	12,715,571	0

(3) Accruals (+) (New Interest Receivables)						2	180,186		180,188	180,188	0
Transaction Register (support line 3)	CMS Transaction Register / LINE 3 ADJUSTMENT					0	56,235		56,235
CMS Adjustment Register (support line 3)	CMS Adjustment Register / LINE 3 MSP/NONMSP ADJUSTMENT					2	123,951		123,953
(5) Adjustments		0	0	263.000	(189,677)	121	18,428		(170,865)	(170,865)	0
(A) Reclassified/Adjusted Amounts (+ or -)	CMS AR Adjustments Register / LINE 5A MSP/NONMSP ADJUSTMENT	0	0	0	(538,772)	0	(612)	0	(539,384)	(539,383)	-1
(B) Adjustments Due to Sale of Assets (+ or -)	CMS AR Adjustments Register / LINE 5B MSP/NONMSP ADJUSTMENT	0	0	0	0	0	0	0	0	0	0
(C) Consolidations (+ or -)	CMS AR Adjustments Register / LINE 5C MSP/NONMSP ADJUSTMENT	0	0	0	0	0	0	0	0	0	0
(D) Forcloser Adjustments (+ or -)	CMS AR Adjustments Register / LINE 5D MSP/NONMSP ADJUSTMENT	0	0	0	0	0	0		0	0	0
(E) Written-Off Debts Reinstated for Collections (+)	CMS AR Adjustments Register / LINE 5E MSP/NONMSP ADJUSTMENT	0	0	263.000	349,095	121	19,040		368,519	368,518	1
(6) Amounts Written-Off (-)		0	0	0	(1,036,986)	0	(71,781)		(1,108,767)	(1,108,767)	0
(A) Currently Not Collectible (-)	CNC - CMS Adjustment Register / LINE 6A MSP/NONMSP ADJUSTMENT	0	0	0	(833,953)	0	(71,117)	0	(905,070)	(905,070)	0
(B) Written-Off and Closed Out (-)	CMS AR Adjustments Register / LINE 5E MSP/NONMSP ADJUSTMENT	0	0	0	(203,033)	0	(664)	0	(203,697)	(203,697)	0

Receivable Available to Be Collected 0 0 334.000 18,960,588 162 283,782 19,244,866 19,244,865 1

B	(4) Collections on Receivables (-)	CMS AR Applied Collections	263.000	10,786,074	121	70,611	10,857,069	10,857,069	0
	(A) At Agency		0	(10,606,769)	0	(43,429)	(10,650,198)	(10,650,198)	0
	(B) At Third Party		0	0	0	0	0	0	0
	(C) Asset Sales		0	0	0	0	0	0	0
	(D) Collections by Treasury through Offset and Cross-Servicing (-)		(263)	(179,305)	(121)	(27,182)	(206,871)	(206,870)	-1
	(E) Collections by Sales After Foreclosure (-)		0	0	0	0	0	0	0
	(F) Collections by Department of Justice (-)		0	0	0	0	0	0	0
	(G) Other - must footnote (-)		0	0	0	0	0	0	0

Collection Percentage n/a n/a 78.74% 56.89% 74.69% 24.88% 56.42% 56.42%

C Allowance Percentage (1-collection %) n/a n/a 21.26% 43.11% 25.31% 75.12% 43.58% 43.58%

D	Average of Allowance (current instruction require Medicare contractors to use five year historical allowance rate
		Average	n/a	n/a	16.31%	20.03%	25.31%	75.12%
		Current Period: Dec 31, 2010	n/a	n/a	21.26%	43.11%
		Sep 30, 2010	0.00%	0.00%	20.00%	15.00%
		Sep 30, 2009	0.00%	0.00%	10.00%	12.00%
		Sep 30, 2008	0.00%	0.00%	14.00%	10.00%
		Sep 30, 2007	n/a	n/a	n/a	n/a

E	(7) Ending Balance (TROR/Activity Registers)	CMS AR Overpayments Report	71	8,174,514	41	213,169	0	8,387,795	8,387,795	0
	Cost Report Settlements		0	0	0	0		0	0	0
	Claims Accounts Receivable		0	0	0	0		0	0	0
	Credit Balances		0	0	0	0		0	0	0
	Other (if cost reports issues include with cost reports)		0	0	0	0		0	0	0
	Physician/Supplier		0	8,129,931	0	213,169		8,343,100	8,343,100	0
	Beneficiary		0	44,583	0	0		44,583	44,583	0
	PIP Accrual		0	0	0	0		0	0	0
	GHP(Data/non-Data Match)		71	0	41	0		112	112	0
	MSP Prov/Phys/Supp/Bene		0	0	0	0		0	0	0
	MSP Beneficiary (Liability)		0	0	0	0		0	0	0
	Other MSP (Liability)		0	0	0	0		0	0	0
	Check		0	0	0	(2)		-2	-1	-1

(X1) Allowance Amount (Collection Percentage) n/a n/a 12 1,637,216 10 160,128 1,797,366

(X2) Individual Account Analysis-Not Applicable for Carriers (Part B) *************************************** CMS has granted a Waiver for Carriers **************************************

(X3)	Delinquencies Exceeding 180 Days	CMS AR Overpayment Report where parameter "Allowance Calc(Over 180 Days Delinquent))"=Y	71	2,750,314	41	165,436	2,915,862	2,915,861	1
	Cost Report Settlements[180]		0	0	0	0	0	0	- 0
	Claims Accounts Receivable[180]		0	0	0	0	0	0	- 0
	Credit Balances[180]		0	0	0	0	0	0	- 0
	Other (if cost reports issues include with cost reports)[180]		0	0	0	0	0	0	- 0
	Physician/Supplier[180]		0	2,749,790	0	165,436	2,915,226	2,915,225	1
	Beneficiary[180]		0	524	0	0	524	524	- 0
	PIP Accrual[180]		0	0	0	0	0	0	- 0
	GHP(Data/non-Data Match)[180]		71	0	41	0	112	112	- 0
	MSP Prov/Phys/Supp/Bene[180]		0	0	0	0	0	0	- 0
	MSP Beneficiary (Liability)[180]		0	0	0	0	0	0	- 0
	Other MSP (Liability)[180]		0	0	0	0	0	0	- 0

F Estimated Allowance Amount ALLOWANCE USING THE MOST CONSERVATIVE AMOUNT 0 0 71 2,750,314 41 165,436 2,915,862

Amount Reported on Trial Balance per Allowance Matrix (Using the conservative amount):
		Amount
	HI MSP Allowance Amount	0
	HI NON-MSP Allowance Amount	0
	HI Total Allowance	0

Fund Acct# 05961 SGL#131901 SGL# 131901 - Allow For Loss on REC-PRINC - 0

SMI MSP Allowance Amount	(71)
SMI NON-MSP Allowance Amount	(2,750,314)
SMI Total Allowance	(2,750,385)

Fund Acct# 05960 SGL#131901 SGL# 131901 - Allow For Loss on REC-PRINC (2,750,385.00)

General Fund MSP Allowance	(41)
General Fund NON -MSP Allowance	(165,436)
General Fund Total Allowance	(165,477)

Fund Acct# 050720 SGL#134901 SGL# 134901 - Allow For Loss on REC-INT (165,477.00)

Note: HIGLAS Interest is not split between HI/SMI but MSP/non-MSP. Therefore, contractors shall compare the current interest collection percentage vs. the over 180 days delinquent amounts.

NOTES:

(*) The above amounts are the allowance estimates for loss on receivable for the period-to-date.

(**) Therefore, the estimated amounts are the calculated ending balances to be reported on the Summary 2 Trial Balance by SGL account by fund (Ending Balance Column).

(***) When Line A1, Receivables Available to be Collected by component is less then or equal to zero (0) the component estimated allowance amount must equal zero (0).

(****) When the estimated allowance is greater than the Line 7, Ending Balance (Line E - above by Fund), the reported allowance amount must equal the Line 7, Ending Balance (Line E - above by Fund).

&"Arial,Bold"RFP # 75FCMC20R0008 &"Arial,Bold"&F Allowance

&A &D

Matrix-AB MAC

Contractor Name:	Exhibit 2
Contractor Number:
Period Ending :

400.14 - Exhibit 14 - Protocol for Estimating Allowance for Uncollectible Accounts

Fiscal Intermediary - Group 1

Allowance for Uncollectible Accounts Matrix
Part A (HI)
	Col. A	Col. B	Col. C	Col. D	Col. E
Sub-Group 1 (Non-MSP) Cost Report Settlements, Claims A/R, Credit Balance & Other Accounts Receivable	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
NONMSP	n/a	$ - 0	$ - 0	$ - 0	$ 165,436

Morgan: CMS:

This cell(F12) use to is referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69) in old version. It now references cell I83 on Allowance tab in new version, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row 83 applies the comparison between the available methods and should therefore flow to the Matrix.

Total $ - 0 $ - 0 $ - 0 $ - 0 $ 165,436

Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
MSP	n/a	$ - 0	$ - 0	$ - 0	$ 41

Total $ - 0 $ - 0 $ - 0 $ - 0 $ 41

	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
Sub-Group 1 (Non-MSP) Cost Report Settlements, Claims A/R, Credit Balance & Other Accounts Receivable	n/a	$ - 0	$ - 0	$ - 0

Morgan: CMS:

This cell(E22) was mapped to B22 in old version, but changed to E12 in the new version.	$ 165,436
	Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	n/a	$ - 0	$ - 0	$ - 0

Morgan: CMS:

This cell(E23) was mapped to B23 in old version, but changed to E17 in the new version. $ 41

Total Part A (HI) $ - 0 $ - 0 $ - 0 $ - 0 $ 165,477

Part B/A (SMI)
	Col. A	Col. B	Col. C	Col. D	Col. E
Sub-Group 1 (Non-MSP) Cost Report Settlements, Claims A/R, Credit Balance & Other Accounts Receivable	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
NONMSP	$ 1,637,216	$ - 0	$ 2,750,314	$ 2,750,314	$ - 0

Total $ 1,637,216 $ - 0 $ 2,750,314 $ 2,750,314 $ - 0

Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
MSP	$ 12	$ - 0	$ 71	$ 71	$ - 0

Total $ 12 $ - 0 $ 71 $ 71 $ - 0

	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
Sub-Group 1 (Non-MSP) Cost Report Settlements, Claims A/R, Credit Balance & Other Accounts Receivable	$ 1,637,216	$ - 0	$ 2,750,314	$ 2,750,314

Morgan: CMS:

This cell(E41) was mapped to D41 in old version, but changed to E31 in the new version.

Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability $ 12 $ - 0 $ 71 $ 71 Morgan: CMS:

This cell(E42) was mapped to D42 in old version, but changed to E36 in the new version.

Total Part B/A (SMI) $ 1,637,228 $ - 0 $ 2,750,385 $ 2,750,385 $ - 0

&"Arial,Bold"RFP # 75FCMC20R0008 &"Arial,Bold"&F Matrix-AB MAC

Matrix-B MAC

Contractor Name:	Exhibit 3
Contractor Number:
Period Ending :

400.14 - Exhibit 14 - Protocol for Estimating Allowance for Uncollectible Accounts

Carrier - Group 2

Allowance for Uncollectible Accounts Matrix
Part B (SMI)
	Col. A	Col. B	Col. C	Col. D	Col. E
Sub-Group1 (Non-MSP) Claims A/R, Credit Balance & Other Accounts Receivable	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
NONMSP	$ 1,637,216	$ - 0	$ 2,750,314	$ 2,750,314	$ 165,436

Morgan: CMS:

This Cell(F12) in the old version referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69). This was changed to reference cell I83, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row I83 applies the comparison between the available methods and should therefore flow to the Matrix.

Total $ 1,637,216 $ - 0 $ 2,750,314 $ 2,750,314 $ 165,436

Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
MSP	$ 12	$ - 0	$ 71	$ 71	$ 41

Total $ 12 $ - 0 $ 71 $ 71 $ 41

	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
Sub-Group 1 (Non-MSP) Claims A/R, Credit Balance & Other Accounts Receivable	$ 1,637,216	$ - 0	$ 2,750,314	$ 2,750,314

Morgan: CMS:

This cell(E22) was mapped to D22 in old version, but changed to E12 in the new version to be consistant with Matrix-FI tab.	$ 165,436
	Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	$ 12	$ - 0	$ 71	$ 71

Morgan: CMS:

This Cell(E23) was mapped to D23 in old version but changed to E17 in new version to be consistant with Matrix-FI tab. $ 41

Total Part B (SMI) $ 1,637,228 $ - 0 $ 2,750,385 $ 2,750,385 $ 165,477

&"Arial,Bold"RFP # 75FCMC20R0008 &"Arial,Bold"&F Matrix-B MAC

Data

TROR_Line	NONFEDERAL-GEN-MSP-CM-Registers-TOTAL	NONFEDERAL-GEN-NONMSP-CM-Registers-TOTAL	NONFEDERAL-NA-NA-CM-Registers-TOTAL	NONFEDERAL-NA-NA-CM-TROR-COUNT	NONFEDERAL-NA-NA-CM-TROR-TOTAL	NONFEDERAL-SMI-MSP-CM-Registers-TOTAL	NONFEDERAL-SMI-NONMSP-CM-Registers-TOTAL
(1) Beginning FY Balance	39	156949		30999	7628738	71	7471680
(2) New Receivables (+)				142633	12715571		12715571
(3) Accruals (+) (New Interest Receivables)					180188
(4) Collections on Receivables (-)					-10857069
(5) Adjustments				5489	-170865
(6) Amounts Written-Off (-)				27374	-1108768
(7) Ending Balance (TROR/Activity Registers)				42302	8387795
(A) At Agency		-43429			-10650198		-10606769
(A) Currently Not Collectible (-)		-71117		573	-905070		-833953
(A) Reclassified/Adjusted Amounts (+ or -)		-612			-539383		-538772
(B) Written-Off and Closed Out (-)		-664		26801	-203697		-203033
(D) Collections by Treasury through Offset and Cross-Servicing (-)	-121	-27182			-206870	-263	-179305
(E) Written-Off Debts Reinstated for Collections (+)	121	19040			368518	263	349095
Beneficiary			44583				44583
Beneficiary[180]			524				524
CMS Adjustment Register (support line 3)	2	123951
GHP(Data/non-Data Match)	41		112			71
GHP(Data/non-Data Match)[180]	41		112			71
Physician/Supplier		213169	8343100				8129931
Physician/Supplier[180]		165436	2915225				2749790
Transaction Register (support line 3)		56235

Changes to calcs

Tab	Cell Changed	Changed From	Changed to	Change Rationale
Matrix-Carrier	F22	D22	E12	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total" or "Historical Collection % Total".
Matrix-Carrier	E23	D23	E17	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total" or "Historical Collection % Total".
Matrix-Carrier	F12	Allowance!I69	Allowance!I83	Cell F12 - Estimated Allowance for Uncollectible A/R (Interest Only) – this is referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69). This should be referenced into cell I83, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row 83 applies the comparison between the available methods and should therefore flow to the Matrix.
Matrix-FI	E22	D22	E12	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-FI	E23	D22	E17	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-FI	E41	D41	E31	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-FI	E42	D42	E36	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-Carrier	F12	Allowance!I69	Allowance!I83	Cell F12 - Estimated Allowance for Uncollectible A/R (Interest Only) – this is referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69). This should be referenced into cell I83, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row 83 applies the comparison between the available methods and should therefore flow to the Matrix.

&"Arial,Bold"RFP # 75FCMC20R0008 &"Arial,Bold"&F Changes to calcs

Request_IDs

Original Workload	Cust_Class	Report	12/31/2010
99998	NONFEDERAL	AdjLn3rpt	11337101
99998	NONFEDERAL	AdjLn5_6rpt	11359879
99998	NONFEDERAL	AppCollrpt	11337102
99998	NONFEDERAL	AROvrrpt	11337104
99998	NONFEDERAL	AROvrrpt[180]	11324610
99998	NONFEDERAL	BBrpt	11337098
99998	NONFEDERAL	HIGLAS_TROR	11341019
99998	NONFEDERAL	TALn2rpt	11337099
99998	NONFEDERAL	TALn3rpt	11337100

&"Arial,Bold"RFP # 75FCMC20R0008 &"Arial,Bold"&F Request_IDs

Lookup_Values

Category	ORG NAME
CM	12/31/2010
ORG	Part B
Part	B
PM	11/30/2010
PQ	9/30/2010
PY	12/31/2009
WL	99998

HISTORICAL_ALLOWANCES

HISTORICAL_YEAR	NONFEDERAL-HI-MSP-CM-Registers-TOTAL	NONFEDERAL-HI-NONMSP-CM-Registers-TOTAL	NONFEDERAL-SMI-MSP-CM-Registers-TOTAL	NONFEDERAL-SMI-NONMSP-CM-Registers-TOTAL
2010			0.2	0.15
2009			0.1	0.12
2008			0.14	0.1

File details come from the government source that posted it. Updated Aug 3, 2020.