Thinking about building your own spreadsheet for CMS Batch Attestation?
There is more to the CMS Batch Attestation program, than simply submitting a spreadsheet with your measures.
Data not in your EHR: One of our prior newsletters listed the data elements that CMS requires, which are not typically contained in CEHRT products. It would be simple enough, but these data often vary by provider, or measure, or even by year. One practicality is that using spreadsheets (rather than a database) will require a lot of manual effort to page through groups of information in order to decide which supplemental values fit where.
Managing Attestation Statuses: Once a batch has been submitted, and CMS responds, you'll need a process to update individual EPs within each batch who have "passed" and those who have "failed", and group by remediation steps (including re-submission).
Organizing Providers into Batches: CMS requires homogeneity within a given batch. You certainly can't mix Stage 1 and Stage 2 EP's, and probably can't mix years, either. You'll also have to group attestations by "like" combinations of measures within each batch. A downside to doing this with spreadsheets, rather than a database, is keeping track of which EP is in which batch, and which batch type.
Testing the process: CMS does not have a test site! Your first submission will be using live data, to the live attestation site.
Bottom Line: Spreadsheets are great tools for analysis, ad-hoc reporting, and one-time processes. But something like Batch Attestation for large groups of providers feels to us like a database process, for a lot of good reasons. One excellent solution is Meaningful Use Monitor a comprehensive database compliance tool. MUM interfaces to your EHR and Practice Management System...if you decide to build your own make sure it does the same.
Also consider the time involved in this process if you decide to do it yourself. Our cost-effective tool saves time, money and your sanity.
And keep in touch with our newsletters ... we will share observations as we gain experiences on this potent tool from CMS.