PracticeISCFree practice exam

ISC · Information Systems and Data Management · 6 practice questions

Auditing ERP Automated Controls: ITGCs and Data Conversion

ERP automated controls support audit reliance only when their supporting IT general controls are effective. Below: follow a new ERP's three-way match from access testing and data conversion to the reliance decision.

The ruleBefore relying on ERP automated controls, establish that relevant ITGCs and application controls are designed and operating effectively throughout the reliance period. For a new implementation, also test the completeness and accuracy of converted data.

Try one first

Company R implemented an integrated ERP in Year 1 that consolidates procurement, accounts payable, and the general ledger. The ERP automates three‑way invoice matching and posts matched invoices to the general ledger, shortening the month‑end close and reducing manual reconciliations. Vendor master data is centralized and security uses role‑based access. However, management has not completed a segregation‑of‑duties (SOD) review (one role currently allows both vendor‑master maintenance and invoice posting), and IT change management for application configuration changes is informal with no formal approval logs. Considering these facts, what is the most likely effect on the external auditor's Year 1 planned audit procedures?
Hint

Which underlying controls must an auditor evaluate before relying on an application's automated processing?

Step by step

  1. Identify the control and its dependencies

    Company R's new ERP matches purchase orders, receiving reports, and vendor invoices before posting payables; opening payables and vendor records were migrated from its legacy system. Staff retained elevated production access after conversion, and configuration changes lack documented approval.

  2. Test access before trusting the match

    Identify who can change vendor records, matching tolerances, and user permissions, and test authorization, segregation of duties, and independent monitoring. Determine whether temporary conversion privileges were removed and whether privileged activity was reviewed throughout the intended reliance period.

  3. Test changes and IT operations

    Inspect evidence that production configuration changes were authorized, tested, and approved before implementation. Test relevant IT operations controls, including processing and exception monitoring, for the period of intended reliance.

  4. Verify the conversion

    Reconcile legacy opening payables to ERP cutover balances and control totals. Reperform selected vendor mappings and trace migrated invoices to source records, emphasizing manual overrides and ambiguous matches to test completeness and accuracy.

  5. Test the automated match

    Test whether the configured quantity and price tolerances accept permitted matches and block exceptions, with evidence covering the intended reliance period. Reduce substantive testing only to the extent supported by effective relevant ITGCs, reliable conversion results, and effective application controls.

  6. Respond to unresolved weaknesses

    If Company R's elevated access or unapproved changes undermine the match, test compensating controls or expand substantive procedures over affected vendor balances and transactions. Communicate identified deficiencies promptly to appropriate recipients and do not treat planned remediation as evidence of current effectiveness.

Key points

  • Remember: someone who can change the matching rules can undermine the match without changing an invoice.
  • Matching total payables does not prove that invoices reached the correct vendor records.
  • A promised access fix does not provide evidence that controls operated effectively before the fix.

How the exam traps you

  • Reduce substantive testing because the ERP successfully matches invoices. Test supporting ITGCs and the match itself before relying on automation.
  • Accept conversion because total payables agrees with the legacy system. Also trace individual invoices and vendor mappings; allocation errors can leave totals unchanged.
  • Wait for planned remediation without changing the audit approach. Respond now with tested compensating controls or expanded substantive procedures, and communicate deficiencies promptly.

5 more, each from a different angle

0 of 5 answered · 0 correct

Question 2

Halcyon Industries' IT manager is preparing a briefing on emerging technologies in business operations. Three terms have come up frequently: ARTIFICIAL INTELLIGENCE (AI), MACHINE LEARNING (ML), and ROBOTIC PROCESS AUTOMATION (RPA). Which statement most accurately describes the relationships among these three concepts?
Hint

AI = umbrella (human-intelligence-mimicking systems). ML = SUBSET of AI (systems that learn from data). RPA = SEPARATE category (rule-based task automation via bots). Intelligent automation = RPA + AI/ML.

Question 3

Polaris Bancorp's audit team is auditing the company's recently deployed AI-based loan approval model. Which of the following audit procedures is LEAST useful for evaluating the model?
Hint

AI/ML audit toolkit: data audit, reproducibility, holdout testing, fairness metrics, explainability TOOLS (SHAP/LIME, quantitative), governance docs, monitoring. NOT useful: 'interviewing the model' for reasoning, models don't think; outputs are post-hoc, unreliable.

Question 4

Company X migrated to a new ERP on January 1, Year 2. The legacy AR subledger used unique numeric customer IDs. During conversion, an automated script created customer master records and migrated open invoices by matching legacy records to new ERP customer name and address fields; the script allowed manual overrides for ambiguous matches. After go‑live, management reported some legacy customers now exist under multiple new customer numbers and some invoices appear assigned to different customer records. As the external auditor concerned about AR completeness and accuracy after the conversion, which procedure is most appropriate to detect mapping errors and misallocated invoices caused by the conversion?
Hint

Think about procedures that directly test the conversion logic and trace individual legacy records into the new ERP; include records with manual overrides or ambiguous matches in your sample.

Question 5

Halberd Manufacturing implemented an RPA bot to automate the daily reconciliation of 800 invoices between the ERP and the bank statement. Six months in, the bot is failing weekly because vendor email formats keep changing, occasional invoice scans are blurry, and some invoices arrive in unexpected non-PDF formats. The CFO is frustrated. Which is the BEST diagnosis?
Hint

RPA suitability check: stable structured inputs + rule-based logic + high volume = good fit. Variable inputs break RPA, fix with input standardization OR AI augmentation (Intelligent Automation = RPA + AI/ML).

Question 6

Parker Co. uses an enterprise resource planning (ERP) system with a shared database. When the shipping department confirms a customer shipment, the system automatically updates inventory records, creates the accounts receivable entry, and records the sale in the general ledger. Management concludes that, because the ERP system is integrated, month-end reconciliations and transaction-processing controls are no longer important. Assuming the system is configured as described, which conclusion is best supported?
Hint

Focus on what integration does well and what it does not do by itself. Automation improves processing, but it does not automatically remove the need for controls.

Drill all 170 Enterprise and accounting information systems questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

Why do ITGCs matter when auditing an ERP three-way match?

The match depends on protected configuration and master data. Uncontrolled privileged access can change tolerances or vendor records, undermining apparently successful automated processing.

Is reconciling total payables enough to test ERP data conversion?

No. Equal totals can hide invoices assigned to the wrong vendor. Test individual mappings and migrated invoices as well as cutover control totals.

Can auditors rely on ERP controls after ITGC weaknesses are fixed?

Remediation alone is not enough. Test whether the relevant controls operated effectively during the period of intended reliance, and separately address the earlier affected period.

Watch it solved

A full CPA ISC task-based simulation on Enterprise and accounting information systems, worked step by step.

ISC Simulation: Mapping Controls Through Order-to-Cash on YouTube

Practice ISC like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on Enterprise and accounting information systems

All Enterprise and accounting information systems practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.