Master the Data: An Introduction to Accounting Data

  1. Big Data Concepts

    • Big Data refers to data sets too vast and intricate for conventional systems to manage and analyze.

    • The Four Vs of Big Data:

      • Volume: Large quantities of data from various sources (e.g., social media, government records).

      • Variety: Multiple data formats (structured, unstructured, semi-structured).

      • Velocity: Speed of data creation and analysis (e.g., microsecond changes in stock prices vs. monthly financial statements).

      • Veracity: Data accuracy and trustworthiness, crucial for reliable insights.

    • Impact of missing data on analysis: Directly relates to Veracity, as inaccurate or incomplete data can lead to flawed conclusions.

    • Frequency of data updates: Pertains to Velocity.

    • Use of blog posts and photos as unstructured data.

    • Examples of structured vs. unstructured data:

      • Structured: Financial statements (e.g., balance sheets, income statements).

      • Unstructured: Social media content, customer reviews, blogs, photos.

  2. Financial Reporting and SEC Filings

    • 8-K: Reports significant unscheduled events.

    • 10-K: Annual financial report detailing a company's financial health and operations.

    • 10-Q: Quarterly financial statements, providing updated disclosures.

    • EDGAR: Electronic Data Gathering, Analysis, and Retrieval system, providing public access to corporate information.

    • Earnings Calls: Interactive sessions between management, analysts, and shareholders to discuss financial results and outlook.

  3. Accounting Systems

    • Managerial Accounting Systems:

      • Compare budgeted vs. actual performance.

      • Include forecasts and cost tracking for internal decision-making.

    • Financial Accounting vs. Managerial Accounting:

      • Financial Accounting: Information for external users (e.g., stockholders, banks).

      • Managerial Accounting: Information for internal users (e.g., management).

    • Ledgers:

      • General Ledger: Summarizes all business transactions from journal entries, foundational for financial statements.

      • Subsidiary Ledgers: Track specific details (e.g., fixed asset ledger, accounts receivable ledger, inventory ledger).

    • Fixed asset tracking: Distinguishes between tangible assets (e.g., property, plant, equipment) and intangible assets (e.g., goodwill, patents).

  4. Information Systems in Accounting

    • CRM (Customer Relationship Management) system: Manages customer interactions and data.

    • HRMS (Human Resource Management System): Handles employee-related information.

    • Supply Chain Systems: Track purchases, inventory, and logistics.

    • ERP (Enterprise Resource Planning) Systems: Integrate accounting, HR, supply chain, and other business processes into a unified system.

  5. Data Tools and Formats

    • Excel PivotTables:

      • Powerful tools for dynamic data summarization and analysis.

      • Utilize fields and functions (e.g., sum, count, average).

      • Offer dynamic updates to reflect changes in underlying data.

    • Structured vs. Unstructured Data:

      • Structured: Highly organized data.

      • Unstructured: Text from emails, social media, etc.

      • Tagged Unstructured Data: Uses tags to add context and structure (e.g., HTML/XML).

    • Computer Standards:

      • XBRL (eXtensible Business Reporting Language): Standard for financial data exchange, tagging data to provide accurate contextual information on financial statements.

  6. Data Sources and Uses

    • Accounting Data: Includes ledgers, journal entries, and tax returns, providing direct financial insights.

    • Non-Accounting Data: Examples include social media content and broader economic indicators, enhancing accounting practices with contextual and predictive insights.

    • Economic Data: Includes inflation rates, unemployment figures, and GDP for forecasting and market assessment.

      • Excludes: Company-specific tax information.

  7. Professional Practice

    • Skills auditors are expected to develop (per PwC):

      • Researching, identifying anomalies, and recognizing risk factors in underlying data.

      • Mining new data sources and applying insights to create business value.

      • Understanding relational and non-relational databases.

      • Utilizing exploratory multivariate statistics, inferential statistics, visualization tools, optimization methods, machine learning, and predictive analytics.

      • Applying process mining techniques and algorithms to analyze specific accounting ledger processes.

    • Use of data in budgeting and forecasting: Essential for predicting future sales, expenses, and optimizing strategies.

    • Importance of data accuracy and trustworthiness (Veracity): Ethical responsibilities in data handling profoundly influence data collection, protection, and usage for optimal decision-making.