| Course | ACC 680 Auditing and Data Analytics Core |
|---|---|
| Topic | Topic 3 |
| Paper type | Journal entry testing workpaper |
| Length | About 980 words, 2 pages |
| Format | APA 7 student paper |
| School | Grand Canyon University (GCU) |
| Program | MS in Accounting |
| Updated | September 2026 |
Free sample paper for ACC 680 Topic 3
Journal Entry Testing Workpaper: A Population Proven Complete, Six Risk-Based Criteria, 37 Entries Examined and One Reserve Release Escalated
[Author Name]
Colangelo College of Business, Grand Canyon University
ACC-680: Auditing and Data Analytics Core
Topic 3 Assignment
[Instructor Name]
[Date]
The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.
Journal Entry Testing Workpaper: A Population Proven Complete, Six Risk-Based Criteria, 37 Entries Examined and One Reserve Release Escalated
Purpose
Workpaper reference J-1. Client: Ridgeway Medical Supply, a composite distributor. Year ended December 31. This workpaper responds to the risk of management override of controls. Auditing standards require the auditor to test the appropriateness of journal entries recorded in the general ledger and other adjustments, whatever the auditor's assessment of controls, because management is in a unique position to override controls that otherwise appear effective (American Institute of Certified Public Accountants, 2002).
Data Extraction
Source system: the company's enterprise resource planning general ledger module, including the separate consolidation ledger used for intercompany and top-side entries. Extract date: January 22, after the year-end close was finalized. Extract run by the company's IT manager in the presence of an audit team member, using a query supplied by the audit team. Fields obtained: entry number, line number, account, amount, debit or credit, posting date, effective date, user ID, source (manual or automated), description and approval ID.
Completeness and Accuracy
No result from the file can be relied on until the file is shown to contain the whole population (American Institute of Certified Public Accountants, 2020). The test is an account-by-account roll-forward: for each account, the opening trial balance plus the year's entries in the file must equal the closing trial balance.
The first roll-forward failed. Forty-two accounts did not tie, all of them intercompany or equity accounts. Investigation found that the query drew only from the primary ledger and omitted 1,140 entries in the consolidation ledger, which is where top-side adjustments are posted. Those are exactly the entries most relevant to override, so the omission mattered. The query was corrected and the file re-extracted. The second roll-forward tied for every account. The final population is 412,600 entries.
Criteria
Each criterion is linked to a fraud risk identified in planning, and each threshold was set before the run.
Table 1
Selection Criteria
| Criterion | Planning risk it responds to | Threshold |
|---|---|---|
| Entries to revenue or reserve accounts after the close date | Management may adjust results after seeing preliminary figures | After day 5 of the close |
| Entries posted by users outside the finance department | Unauthorized access to the general ledger | Any |
| Round amounts of $50,000 or more | Estimates or fabricated entries tend to be round | Divisible by 10,000 and at least $50,000 |
| Manual entries to accounts used fewer than 10 times in the year | Concealment in accounts that receive little review | Fewer than 10 postings |
| Entries with blank or generic descriptions | Entries lacking a business explanation | Blank, or one word such as adjust |
| Weekend postings by the controller or above | Senior override outside normal review hours | Saturday or Sunday |
Thresholds were set with the population in mind. A round-amount floor of $50,000 keeps the criterion focused on entries large enough to matter while excluding routine small adjustments; a lower floor would have returned several thousand entries with little added risk. The seldom-used account threshold of fewer than 10 postings was set after reviewing the account activity distribution, where most active accounts receive hundreds of postings a year. Automated entries generated by the billing and payroll interfaces were not excluded, because an interface can also be used to post an inappropriate entry.
Results
The run returned 214 entries meeting at least one criterion and 37 meeting two or more: 33 meeting exactly two and 4 meeting three.
Table 2
Results by Criterion
| Criterion | Entries meeting it |
|---|---|
| Entries to revenue or reserve accounts after the close date | 41 |
| Entries posted by users outside the finance department | 28 |
| Round amounts of $50,000 or more | 62 |
| Manual entries to accounts used fewer than 10 times in the year | 47 |
| Entries with blank or generic descriptions | 55 |
| Weekend postings by the controller or above | 22 |
| Total criterion hits | 255 |
| Entries meeting at least one criterion | 214 |
| Entries meeting two or more | 37 |
Follow-Up
All 37 entries meeting two or more criteria were examined, together with a selection of 25 from the 177 meeting one criterion, weighted toward post-close revenue and reserve entries. For each, the team obtained the supporting documentation, confirmed that the entry was approved by someone other than its preparer and assessed whether the business reason was consistent with the evidence.
Sixty-one of the 62 examined entries were supported. Most of the round-amount entries were monthly accruals for bonuses and utilities, recalculated and agreed to later invoices or payroll. The weekend postings by senior staff related to a quarter-end system outage and were approved on the following Monday by the chief financial officer, with support attached.
The Escalated Entry
Entry 2024-JE-88417, posted on January 9, after the close, by the controller: a debit of $180,000 to the warranty reserve and a credit to cost of sales, with the description "reserve true-up." The entry met three criteria: post-close reserve entry, round amount and a controller posting on a Saturday. No calculation, memo or approval accompanied it, and the controller's explanation, that recent claims were lower than expected, was not supported by the claims data, which showed claims rising in the fourth quarter. The release increased pretax income by $180,000, about 9 percent of performance materiality. The matter was communicated to the engagement partner on January 29 and is carried to the summary of possible misstatements and to the assessment of management integrity.
Conclusion
Except for entry 2024-JE-88417, the journal entries tested were appropriate and supported. The escalated entry is unresolved and precludes a conclusion that the risk of management override has been adequately addressed until it is resolved. Further procedures, including inquiry of the chief financial officer and the audit committee chair and extended testing of the controller's other post-close entries, are planned and documented at J-2 (Arens et al., 2020). Data analytics made it practical to apply the criteria to every entry, which a manual selection could not (American Institute of Certified Public Accountants, 2017).
References
American Institute of Certified Public Accountants. (2002). Consideration of fraud in a financial statement audit (Statement on Auditing Standards No. 99). AICPA.
American Institute of Certified Public Accountants. (2017). Guide to audit data analytics. AICPA.
American Institute of Certified Public Accountants. (2020). Audit evidence (Statement on Auditing Standards No. 142). AICPA.
Arens, A. A., Elder, R. J., Beasley, M. S., & Hogan, C. E. (2020). Auditing and assurance services: An integrated approach (17th ed.). Pearson.
What the ACC 680 Topic 3 instructions ask for
ACC-680 Topic 3 asks students to document journal entry testing. Many papers jump to the criteria. The assignment rewards workpapers that state the purpose in terms of management override, record the extraction, and test completeness and accuracy with a roll-forward before running any criterion. Students should link each criterion to a planning risk with a threshold set in advance, report results by criterion and combination, document support for examined entries and escalate unsupported entries with a conclusion that reflects what remains open.
Inside the ACC 680 Topic 3 example
The finished workpaper begins with the data, not the criteria, all figures illustrative. The extract of 412,600 entries is rolled forward account by account, opening trial balance plus the year's entries against the closing balance, and the first roll-forward fails: 1,140 consolidation-ledger entries were missing from the file. After re-extraction every account ties. Six criteria follow, each linked to a fraud risk named in planning: entries to revenue or reserves after the close, entries by users outside finance, round amounts over $50,000, manual entries to seldom-used accounts, entries with blank descriptions and weekend postings by senior staff. The run returns 214 entries meeting at least one criterion and 37 meeting two or more. All 37 are examined, plus a selection of the rest. One, a $180,000 reserve release posted by the controller after close with no support, is escalated.
ACC 680 Topic 3 rubric: what Excellent looks like
Faculty grading the journal entry workpaper reward the population proven whole. Excellent workpapers record a failed roll-forward and its cause. Credit goes to criteria tied to specific risks and thresholds explained. The rubric values examining every entry that meets several criteria. The highest level escalates an unsupported post-close reserve release and withholds a clean conclusion. Workpapers that run criteria on an untested extract, or that choose criteria unconnected to any planning risk, usually land in a middle band. Examining a selection of single-criterion entries is also expected.
Common ACC 680 Topic 3 mistakes, and how to avoid them
Journal entry work most often loses credit before any entry is examined, because nobody showed the population was complete. A workpaper reporting 214 selected entries from an extract nobody reconciled to the trial balance may be testing part of the ledger, and here the missing consolidation entries are where post-close adjustments tend to live. Criteria lifted from a software menu, with no link to the fraud risks identified in planning, produce selections no reviewer can evaluate. Treating every selected entry as an exception misreads what a criterion is: meeting one is a reason to look, not a misstatement. Papers that examine single-criterion hits and ignore combinations miss the ranking that makes the volume workable. The reserve release is the case markers check, and a paper filing it with routine exceptions has not treated override as the risk under test.
Get an ACC-680 Topic 3 example written to your instructions
Send the ACC-680 Topic 3 instructions, your classroom rubric and the entry data or case your section assigned. We write a custom example to them, with the population reconciled to the trial balance, criteria tied to planning risks and fixed in advance, results counted by combination and every selected entry resolved or escalated, back in 24 to 48 hours. The first one is free.
More ACC 680 papers and MS in Accounting samples
- ACC 680 Topic 1: Analytic Assertion Coverage Map
- ACC 680 Topic 2: Benford Screen Risk Memo
- ACC 680 Topic 4: Exception Triage Log
- ACC 680 Topic 5: Full Population Testing Dq Post
- ACC 680 Topic 6: Analytic Evidence Working Paper
- ACC 680 Topic 7: Substantive Analytic Simulation
- ACC 680 Topic 8: Review Note Response Memo
- ACC 670 Topic 3: Revenue Recognition Signal Analysis
- ACC 669 Topic 3: Book-tax Income Reconciliation
- ACC 663 Topic 3: Personal Financial Statement Review
- ACC 653 Topic 3: Quality Cost Trade-off Report
ACC 680 Topic 3 questions, answered
Why must journal entries be tested at all?
Because management is positioned to override controls, and recording fictitious or inappropriate entries is one of the most direct ways to do it. The PCAOB's standards and those of the AICPA Auditing Standards Board both require procedures over journal entries and other adjustments in response to that risk, regardless of how well controls appear to work. Full-population analytics make it practical to apply criteria to every entry rather than to a sample.
What does the roll-forward prove?
That the extracted entries, added to the opening trial balance, produce the closing trial balance for every account. If they do, the file contains the complete set of postings for the year, and any criterion applied to it covers the whole ledger. If they do not, some entries are missing or duplicated, and results from the file describe only part of the population. The test is cheap and it comes first.
How are criteria chosen?
From the risks identified in planning, not from what the software can do. Pressure to meet earnings targets suggests post-close entries to revenue and reserves; weak access controls suggest entries by users outside finance; complex estimates suggest entries to reserve accounts. Each criterion should name the risk behind it and fix its threshold before the run, so the selection can be defended as a response rather than a search.
Where can I find a free ACC 680 Topic 3 sample paper?
The full workpaper sits above, with the purpose, data extraction, completeness and accuracy, the criteria, results, follow-up, the escalated entry and the conclusion. Give us your client scenario for a free worked workpaper.
Why did the first roll-forward fail in ACC 680 Topic 3?
The query omitted 1,140 entries in the consolidation ledger, where top-side adjustments are posted, so 42 accounts did not tie until the file was re-extracted.