Exhibit 2 - Financial Spread Sheet.xlsx
XLSX spreadsheet 45 KB Posted
- Attached to
- Accounts Receivable Services Federal contract opportunity
- Solicitation number
- 75H71324Q00040
About this file
This document includes a solicitation for accounts receivable services and a related federal contract opportunity. The solicitation seeks quotes for accounts receivable services to be provided to the Department of Health and Human Services Indian Health Service. Services include posting medical, dental, optometry, behavioral health and pharmacy payments from insurance companies into the agency's patient accounting system. Quotes are due by April 8, 2024. The performance period is one base year with four one-year options, from an estimated award date of April 15, 2024 through April 14, 2025. Evaluation will be based on price and demonstrated prior experience in areas such as ICD-10 and CPT coding, explaining insurance payment adjustments, and accounts receivable processes. The set-aside is for Indian Small Business Economic Enterprise.
The solicitation provides the NAICS code, attachments including the statement of work and wage determination, and instructions for submitting quotes. The federal agency is the Department of Health and Human Services Indian Health Service. The solicitation number is 75H71324Q00040.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| ATTACHMENT 7 - FY 2023 WORKLOAD.pdf | ||
| ATTACHMENT 6 - Q-A 75H71324Q00040 REVISED 04042024.docx | DOCX document | |
| ATTACHMENT 6 - Q-A 75H71324Q00040.docx | DOCX document | |
| Exhibit 3 - File for low pmt.docx | DOCX document | |
| Exhibit 1 - Insurance Websites.xlsx | XLSX spreadsheet | |
| ATTACHMENT 4 - WAGE DETERMINATION.pdf | ||
| ATTACHMENT 5 - IHS IEE REPRESENTATION FORM.pdf | ||
| Exhibit 4 - Batch document example (PI-02032021-3)_Redacted.pdf | ||
| ATTACHMENT 3 - BUSINESS ASSOCIATE AGREEMENT.pdf | ||
| ATTACHMENT 2 - STATEMENT OF WORK.docx | DOCX document | |
| ATTACHMENT 1 - SCHEDULE OF ITEMS.xlsx | XLSX spreadsheet |
Show all 11
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| MCD | $ 127,396.16 | VAF | $ 654.00 | ||||||||
| PI | $ 1,473.49 | ERROR:#N/A | $ 8,043.80 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | |||||
| MCR | $ 1,029.65 | EOB | $ 1,448.17 | ||||||||
| TOTAL | $ 140,045.27 | <------ | -----------> | $ 140,045.27 | DEPOSIT | BATCH | |||||
| Date | Check Amount | ABA/RT | Account Num | Check Num | Remitter Name | TYPE | MATCH INDEX | AR ACCOUNT INDEX | TICKET | NAME | POSTED |
| 1/2/24 | 18.09 | B330567651 | 42000013 | 9200311613 | MEDIMPACT | ERROR:#N/A | B33056765142000013 | ERROR:#N/A | 652664 | ||
| 1/2/24 | 19.10 | 2260076803 | 42000013 | 444444440792473 | PRIME THERAPEUTI | EOB | 226007680342000013 | PRIME THERAPEUTICS BCTX | 652664 | ||
| 1/2/24 | 117.00 | 1930238155 | 323070380 | 261174939 | REGENCE BCBSO - | PI | 1930238155323070380 | REGENCE OF OREGON FEDERAL | 652664 | ||
| 1/2/24 | 145.89 | 4330441200 | 91000019 | 121000243258580 | OPTUMRX | ERROR:#N/A | 433044120091000019 | ERROR:#N/A | 652664 | ||
| 1/2/24 | 186.76 | 6930238155 | 111000025 | 154981222 | REGENCE BCBCO | PI | 6930238155111000025 | BC BS OF OREGON | 652664 | ||
| 1/2/24 | 189.14 | 1930951989 | 41001039 | 27914187 | SAMARITAN CHOICE | PI | 193095198941001039 | SAMARITAN CHOICE PLANS | 652664 | ||
| 1/2/24 | 553.28 | B330567651 | 42000013 | 9200311010 | MEDIMPACT | ERROR:#N/A | B33056765142000013 | ERROR:#N/A | 652664 | ||
| 1/2/24 | 676.81 | B330567651 | 42000013 | 9200310747 | MEDIMPACT | ERROR:#N/A | B33056765142000013 | ERROR:#N/A | 652664 | ||
| 1/2/24 | 1,429.07 | 1260076803 | 42000013 | 555555550495709 | PRIME THERAPEUTI | EOB | 126007680342000013 | PRIME THERAPEUTICS | 652664 | ||
| 1/2/24 | 6,649.73 | 4330441200 | 91000019 | 121000243281943 | OPTUMRX | ERROR:#N/A | 433044120091000019 | ERROR:#N/A | 652664 | ||
| 1/2/24 | 654.00 | 9101036151 | 101036151 | VAFA TREAS 310 | VAF | 9101036151101036151 | VA MEDICAL BENEFIT (VMBP) | 652664 | |||
| 1/2/24 | $22.00 | 101000187 | 145592435591 | 104922299 | GEHA | PI | 101000187145592435591 | GEHA | 830752 | ||
| 1/2/24 | $1,029.65 | 71000288 | 22985798 | 1290018 | NAVITUS HEALTH SOLUTIONS | MCR | 7100028822985798 | D-NAVITUS 610602 | 830752 | ||
| 1/2/24 | $268.80 | 31100209 | 40008488 | 31689790 | CIGNA DENTAL | PI | 3110020940008488 | CIGNA DENTAL | 830752 | ||
| 1/2/24 | $602.00 | 31100209 | 38876534 | 1000873399 | KAISER PERMANENTE | PI | 3110020938876534 | KAISER CLAIMS | 830752 | ||
| 1/3/24 | 52,439.74 | 9300A10020 | 41001039 | 600176737 | OR DHS HP MMIS | MCD | 9300A1002041001039 | OREGON MEDICAID | 653433 | ||
| 1/3/24 | 74,956.42 | 9300A10020 | 41001039 | 600176343 | OR DHS HP MMIS | MCD | 9300A1002041001039 | OREGON MEDICAID | 653433 | ||
| 1/3/24 | 14.95 | 1362739571 | 124384877 | 91006028345 | AARP SUPPLEMENTA | PI | 1362739571124384877 | AARP GROUP HEALTH | 653433 | ||
| 1/3/24 | 36.42 | 9000004108 | 81000605 | 105314127 | GEHA | PI | 900000410881000605 | GEHA | 653433 | ||
| 1/3/24 | 36.42 | 9000004108 | 81000605 | 105314128 | GEHA | PI | 900000410881000605 | GEHA | 653433 |
File details come from the government source that posted it. Updated .