DATA Act review finds errors in $2 billion of DHS transactions

concept image for data analytics 

Nearly $2 billion in financial transactions completed by the Department of Homeland Security could not be linked to their corresponding award-level transactions for Q2 of FY2017.

These misaligned transactions constituted about 38 percent of that quarter's total obligations, according to the DHS' inspector general. This was one of the data quality issues auditors found in their review of the department's compliance with the Digital Accountability and Transparency Act.

The OIG reported that DHS lacked sufficient controls over DATA Act submission processes, preventing the accurate, complete and timely submission of financial data. At the component level, agencies within DHS did not assess their internal controls over the accuracy of their DATA Act submissions. Specifically, auditors found the National Protection and Programs Directorate

and Federal Emergency Management Agency had "significant deficiencies" in the design and implementation of their data validation procedures.

Additionally, "despite its inability to align almost one quarter of its procurement obligations, DHS still certified that the data was accurate and complete," the report states. Auditors also reported that other spending data submissions lacked all the elements required by law.

In reply comments from oversight liaison Jim Crumpacker, DHS argued that OIG was applying accounting strictures not contained in the Data Act while ignoring flexibilities afforded to reporting agencies. DHS, he maintained, was comporting with the intent of the law.

"The reality is DHS can reconcile down to $230 million – within 5 percent of the total obligations – with the remaining amount largely attributable to governmentwide issues involving non-traceable costs related to inter-agency agreements, micropurchase transactions, financial system closeouts and other non-material low-risk transactions," Crumpacker wrote.

The comments also noted that the agency received plaudits from the Office of Management and Budget and Department of Treasury for the quality of its data and its commitment to Data Act implementation.

However, the auditors chided DHS for its component agencies' disparate financial systems, resulting in some spending data not being submitted in a timely fashion. OIG found that DHS's financial systems of record are not effectively integrated with procurement assistance systems, which risks adversely impacting data quality. The IG maintained that almost 64 percent of the 385 procurement and award transactions during the second quarter of fiscal year 2017 that were tested contained inaccurate data. OIG stated a sample transaction was deemed inaccurate if "any one of the data attributes we tested did not match to the agency's underlying records."

"We recognize that some misalignments among DHS' spending data may be due to legitimate reasons associated with existing business processes," the report states, "but we are concerned that timing differences 30 days or longer may not be legitimate."

OIG recommended that DHS's CFO strengthen the department's internal controls to make sure spending data files are aligned and verify which data errors are due to legitimate timing issues, and to verify that NPPD's DATA Act validation procedures have been finalized.

OIG also recommended DHS to develop quarterly performance metrics that measure the number and total value of misaligned transactions that cannot be traced to award files, a way to correctly assign program activity names and codes to ensure complete data, as well as a control process that ensures all changes made to data entries are appropriately approved and recorded.

Lastly, OIG recommended DHS incorporate DATA Act-specific controls into existing management processes at both the departmental and component levels.

DHS disagreed with OIG's recommendation that it needs to strengthen its data controls, arguing auditors did not take into account acceptable reasons for timing discrepancies, like systems limitations.

About the Author

Chase Gunter is a staff writer covering civilian agencies, workforce issues, health IT, open data and innovation.

Prior to joining FCW, Gunter reported for the C-Ville Weekly in Charlottesville, Va., and served as a college sports beat writer for the South Boston (Va.) News and Record. He started at FCW as an editorial fellow before joining the team full-time as a reporter.

Gunter is a graduate of the University of Virginia, where his emphases were English, history and media studies.

Click here for previous articles by Gunter, or connect with him on Twitter: @WChaseGunter


  • Contracting
    8 prototypes of the border walls as tweeted by CBP San Diego

    DHS contractors face protests – on the streets

    Tech companies are facing protests internally from workers and externally from activists about doing for government amid controversial policies like "zero tolerance" for illegal immigration.

  • Workforce
    By Mark Van Scyoc Royalty-free stock photo ID: 285175268

    At OPM, Weichert pushes direct hire, pay agent changes

    Margaret Weichert, now acting director of the Office of Personnel Management, is clearing agencies to make direct hires in IT, cyber and other tech fields and is changing pay for specialized occupations.

  • Cloud
    Shutterstock ID ID: 222190471 By wk1003mike

    IBM protests JEDI cloud deal

    As the deadline to submit bids on the Pentagon's $10 billion, 10-year warfighter cloud deal draws near, IBM announced a legal protest.

Stay Connected

FCW Update

Sign up for our newsletter.

I agree to this site's Privacy Policy.