New audit data standard addresses inventory subledger

Standardizing data can improve efficiency of the audit process.

A new audit data standard issued by the AICPA Assurance Services Executive Committee (ASEC) addresses the inventory subledger and is intended to accommodate basic analysis of the inventory process.

Through its Emerging Assurance Technologies Task Force, ASEC is developing audit data standards designed to make the acquisition of data more efficient and effective through standardization of the format for fields and files commonly requested for audits and other purposes.

Although use of the audit data standards is voluntary, public and private companies can benefit from applying them. Standardizing the data that auditors regularly request allows companies to replicate the information request process, reducing the time and effort needed to provide data to auditors.

Companies also can analyze the standardized data for internal purposes, and external auditors can more easily perform enhanced data analytics on data that are standardized.

The inventory subledger standard is designed to help auditors acquire the data that they need to perform their analysis as part of an audit. The new standard should be used in conjunction with the base standard for audit data standards, which was developed in 2015.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.

PODCAST

What’s next for potential CPA licensure changes

A new model proposed by NASBA and the AICPA is designed with an eye on the future for newly licensed CPAs. The AICPA's Carl Mayes, CPA, provides background on the project and a look ahead to 2020.