ACC 680 Topic 3 journal entry testing workpaper example

Auditing and Data Analytics Core Grand Canyon University Free custom sample in 24 to 48h

This ACC 680 Topic 3 sample paper is a journal entry testing workpaper that proves the population before reading any result. It was prepared for GCU ACC 680, Auditing and Data Analytics Core, catalog code ACC-680, in the Grand Canyon University MS in Accounting program. An account-by-account roll-forward of 412,600 entries first fails because 1,140 consolidation-ledger entries are missing, then ties after re-extraction. Six criteria linked to planning risks return 214 entries, 37 meeting two or more. All 37 and a selection of the rest are examined, and a $180,000 post-close reserve release by the controller without support is escalated.

CourseACC 680 Auditing and Data Analytics Core
TopicTopic 3
Paper typeJournal entry testing workpaper
LengthAbout 980 words, 2 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramMS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 680 Topic 3

1

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.

What this page is doingThe title lists the workpaper's sequence, which shows the population whole before any result is read. The company and figures are illustrative composites; the standards and sources are real.
2

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

CriterionPlanning risk it responds toThreshold
Entries to revenue or reserve accounts after the close dateManagement may adjust results after seeing preliminary figuresAfter day 5 of the close
Entries posted by users outside the finance departmentUnauthorized access to the general ledgerAny
Round amounts of $50,000 or moreEstimates or fabricated entries tend to be roundDivisible by 10,000 and at least $50,000
Manual entries to accounts used fewer than 10 times in the yearConcealment in accounts that receive little reviewFewer than 10 postings
Entries with blank or generic descriptionsEntries lacking a business explanationBlank, or one word such as adjust
Weekend postings by the controller or aboveSenior override outside normal review hoursSaturday 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

CriterionEntries meeting it
Entries to revenue or reserve accounts after the close date41
Entries posted by users outside the finance department28
Round amounts of $50,000 or more62
Manual entries to accounts used fewer than 10 times in the year47
Entries with blank or generic descriptions55
Weekend postings by the controller or above22
Total criterion hits255
Entries meeting at least one criterion214
Entries meeting two or more37

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 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.