Missing Form APs?

Missing Form APs?

In May of 2024, I?posted on LinkedIn?a brief note about working with data from Form APs filed with the PCAOB. In a comment on my LinkedIn posting,?Olga Usvyatsky?suggested that “the variation is not limited to firms’ names - for instance, I find errors in reporting CIK codes of the clients intriguing.” I thought it would be interesting to investigate the issue raised by Olga, but doing so would be greatly facilitated by an alternative source for data on auditor-client relationships.

Recently, I discovered that it is relatively straightforward to process XBRL data filed using SEC EDGAR using data sets prepared by the SEC and posted on its website. There are two data sets: the?Financial Statements?and?Financial Statement and Notes?data sets, with the latter being roughly ten times as large as the former. For the task we consider here, we need to use the?Financial Statement and Notes?data set.

In essence, I compare the auditors listed in firms’ 10-K filings with data on Form APs, with a focus on my success rate in matching the two. In Table 5 of the note, we can see that the auditor with the greatest number of non-matches is B F Borgers CPA PC, an auditor featured in a Financial Times?article by George Steer?that showed that the auditor Ben Borgers had used 14 different names—including the name “Ben F orgers”—on Form AP filings.?While more research would be needed to investigate the reasons for “missing” data, having Borgers emerge as the “winner” yet again suggests that missing Form AP filings might be another red flag worth pursuing.

This note was written using?Quarto?and compiled with?RStudio, an integrated development environment (IDE) for working with R. The source code for this note is available?here?and the latest version of the note is?here.

Olga Usvyatsky

Researcher, analyst, accounting expert

3 个月

Nice analysis! I think at least one recent PCAOB enforcement action mentioned a missing Form AP. Arguably, the completeness of Form AP data is important because it allows to estimate metrics such as the busyness of a partner. Form AP is also an easy publicly available source to identify clients affected by sanctions against audit firms (e.g., seeing a list of former Borgers clients).

For that application, even easier than the dataset you mention, is the API, also provided for free by the SEC.

要查看或添加评论,请登录

Ian Gow的更多文章

  • db2pq: A Python library for making parquet data

    db2pq: A Python library for making parquet data

    If you use WRDS data, there are many benefits to storing the data as parquet files. The parquet format is described in…

    2 条评论
  • DuckDB/parquet versus WRDS PostgreSQL

    DuckDB/parquet versus WRDS PostgreSQL

    From a coding perspective, Empirical Research in Accounting: Tools and Methods is kind of two books in one. While the…

  • Write SQL without writing SQL

    Write SQL without writing SQL

    I figure there is some merit to the claim that “SQL has become an even more indispensable too for the savvy analyst or…

    5 条评论
  • Working with dates and times

    Working with dates and times

    In a recent post on LinkedIn, I mentioned that one goal of Empirical Research in Accounting: Tools and Methods…

    1 条评论
  • Recommendation: Chanticleer podcast

    Recommendation: Chanticleer podcast

    For Australian students of business and finance, I strongly recommend the Chanticleer podcast as a great way to stay on…

    2 条评论
  • WRDS at Speed

    WRDS at Speed

    Users of data from Wharton Research Data Services (WRDS) may find the newly updated version of my Python package…

  • Gino's response to Data Colada

    Gino's response to Data Colada

    For some the big legal filing this week was the indictment of Donald Trump in Washington DC. But others in academia…

    5 条评论
  • Videos for our research course

    Videos for our research course

    Two weeks I posted a short piece about the PhD course book that Tony Ding and I are working on. One thing I feel may…

  • An accounting research course book

    An accounting research course book

    For those of you involved in academic accounting research, please check out the work-in-process draft of the course…

    8 条评论
  • The purpose of an accounting professor?

    The purpose of an accounting professor?

    Recently, Professor Alex Edmans of London Business School posted a paper entitled “The Purpose of a Finance Professor”…

    7 条评论

社区洞察

其他会员也浏览了