| Course | ACC 682 Accounting and Data Analytics Core |
|---|---|
| Topic | Topic 7 |
| Paper type | Breakage estimate workpaper |
| Length | About 970 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 682 Topic 7
Gift Card Breakage of $1.1 Million, Traceable Without Asking Anyone: A Workpaper From Stored Queries to the Proportional Method
[Author Name]
Colangelo College of Business, Grand Canyon University
ACC-682: Accounting and Data Analytics Core
Topic 7 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.
Gift Card Breakage of $1.1 Million, Traceable Without Asking Anyone: A Workpaper From Stored Queries to the Proportional Method
Purpose
Workpaper B-3. Client: Copper Kettle Restaurants, a composite casual dining chain. Period: year ended December 31. Estimate: gift card breakage recognized as revenue. When a customer buys a gift card, the company receives cash for a promise to provide meals later. Some card value will never be redeemed. Under the revenue standard, if the company expects to be entitled to that unredeemed amount, it recognizes the expected breakage as revenue in proportion to the pattern of rights the customer exercises, that is, as cards are redeemed; if it does not expect to be entitled, it recognizes breakage only when redemption becomes remote (Financial Accounting Standards Board, 2014). Copper Kettle has 60 months of history, enough to expect entitlement, so the proportional method applies.
Sources
Two tables in the point-of-sale system's gift card module supply the data: the issuance table, with card number, issue date, value loaded, card type and state of sale; and the redemption table, with card number, redemption date and amount. Both are owned by the treasury systems analyst. Each was drawn on January 15 by the analyst using stored queries named GC_ISSUE_60M and GC_REDEEM_60M, and the queries and row counts are saved with this workpaper.
Transformations
The transformations run in the order below, with the card count after each step.
Table 1
Transformation Steps
| Step | Transformation | Cards remaining |
|---|---|---|
| 1 | Draw all cards issued in the last 60 months from the issuance table | 1,284,000 |
| 2 | Remove promotional cards issued free | 1,106,000 |
| 3 | Remove voided and fully refunded cards | 1,098,500 |
| 4 | Group cards into 60 monthly issuance cohorts | 1,098,500 |
| 5 | Join redemptions and compute cumulative percentage of value redeemed by month since issue | 1,098,500 |
Why Promotional Cards Are Excluded
Promotional cards given away free, for example with a large catering order, generate no cash and no contract liability, because no customer paid for them. Their non-redemption is not revenue; including them would inflate the breakage rate applied to paid cards. They are removed at step 2.
The same logic applies to cards issued in exchange for customer complaints, which are recorded as a reduction of revenue when issued and are also excluded.
Parameters
The cutoff. Across the 60 cohorts, cumulative redemption reaches 91.5 percent of value by month 36 and rises by less than 0.1 percentage point in any later month. After month 36, redemption is negligible, so the cohorts old enough to be past month 36 establish the ultimate redemption rate. The evidence is the cohort curve, retained as an attachment.
The remittance share. Unredeemed value is 8.5 percent. Under unclaimed property laws in the states where the cards are sold, part of that value must eventually be remitted to the state and is never the company's to keep. Applying each state's rules to the value of cards sold there gives a weighted remittance share of about 3.0 percentage points. That amount is a liability to the states, not breakage. The company expects to keep the remaining 5.5 percent of value issued.
The Computation
Under the proportional method, breakage is recognized as a share of each dollar redeemed. The ratio is breakage to expected redemptions: 5.5 divided by 91.5, about 6.01 percent. Applied to this year's redemptions of $18.3 million, breakage recognized this year is about $1.1 million. The entry debits the contract liability and credits revenue.
Table 2
Breakage Computation
| Line | Value |
|---|---|
| Cumulative redemption rate at month 36 | 91.5% |
| Unredeemed share of value | 8.5% |
| Less share remitted to states | 3.0% |
| Breakage rate, share of value issued | 5.5% |
| Breakage as a share of expected redemptions | 6.01% |
| Redemptions this year | $18.3 million |
| Breakage recognized this year | $1.1 million |
Why the Proportional Method and Not Another
Two alternatives were considered. Recognizing all expected breakage when cards are sold would record revenue before the company has provided anything, since the company cannot know which cards will go unused until time passes. Waiting until each card's redemption becomes remote, the method required when entitlement is not expected, would push revenue years later than the evidence supports, since the cohort history shows how much value will go unused. The proportional method sits between them: breakage is recognized as customers redeem, so revenue from breakage follows the same pattern as revenue from the meals themselves.
The method's accuracy depends on the curve. If this year's redemptions include a larger share of old cards than usual, the ratio would recognize breakage slightly faster than the pattern warrants. This year's redemptions were checked by cohort age and matched the historical mix within one percentage point, so no adjustment is needed.
Governance
The stored query that builds the cohorts is named GC_BREAKAGE_COHORT, version 2, and may be changed only by the treasury systems analyst with approval from the assistant controller; every change is recorded in the query's change log, which shows no changes this year. The gift card subledger balance at year end, $14.2 million, agrees to the contract liability for gift cards in the general ledger. A second accountant, who did not build the query, reran it from the stored version on January 18 and obtained the same breakage figure to the dollar. Because the estimate depends on data and code rather than on a spreadsheet maintained by one person, this governance is the main control over it (American Institute of Certified Public Accountants, 2017).
What Would Change the Estimate
The estimate should be revisited if redemption patterns shift, for example after a digital card launch, which may redeem faster, or if a state changes its unclaimed property rules. Either change would alter a parameter, not the method. The redemption curve for each new cohort should be compared with the historical curve each quarter, and a departure of more than two percentage points at month twelve would prompt a review (Kieso et al., 2019).
References
American Institute of Certified Public Accountants. (2017). Guide to audit data analytics. AICPA.
Financial Accounting Standards Board. (2014). Revenue from contracts with customers (Topic 606) (Accounting Standards Update No. 2014-09). FASB.
Kieso, D. E., Weygandt, J. J., & Warfield, T. D. (2019). Intermediate accounting (17th ed.). Wiley.
ACC 682 Topic 7 instructions, in plain terms
ACC-682 Topic 7 asks students to prepare a data-driven estimate workpaper. Many papers show a result without its path. The assignment rewards workpapers that state the estimate and the guidance, list sources with owners and extraction dates, and show transformations in order with counts. Students should state each parameter with its evidence, explain exclusions, compute the estimate under the chosen method and justify it over alternatives, and document governance: stored queries, change control, reconciliation and an independent rerun.
How the ACC-682 Topic 7 example is put together
The finished workpaper opens with the estimate and the rule it applies: under ASC 606, expected breakage is recognized in proportion to the pattern of redemptions, and only for amounts the company expects to keep. Figures are illustrative. Sixty monthly issuance cohorts show 91.5 percent of card value redeemed by month 36 and almost nothing after, leaving 8.5 percent expected unredeemed. Unclaimed property rules in the states concerned require about 3.0 points of that to be remitted, so the breakage rate is 5.5 percent of value issued. Applied to $18.3 million of redemptions this year, the proportional method recognizes $1.1 million. Promotional cards given away free are excluded, since no customer paid for them. The gift card subledger, $14.2 million at year end, agrees to the ledger, and a second accountant's rerun of the stored query returned the same figure.
ACC 682 Topic 7 rubric: what Excellent looks like
Faculty grading the breakage workpaper reward figures traceable without asking anyone. Excellent workpapers remove promotional cards because no customer paid for them. Credit goes to separating amounts owed to states from breakage. The rubric values the proportional method explained against its alternatives. The highest level documents query versions, change logs and a rerun by a second accountant. Workpapers that recognize all breakage at sale, or count promotional cards in the rate, usually land in a middle band. A stored, versioned query is expected.
ACC 682 Topic 7 help: mistakes that cost marks
The heaviest loss on this workpaper is a correct figure nobody else can produce, since an estimate living in its preparer's memory cannot be reviewed. Papers that describe the method in prose and omit the stored query, the filters or the extraction dates leave a reviewer to rebuild the work. Recognizing all expected unredeemed value as breakage ignores what the company must remit to states, and overstates revenue by the 3.0 points. Including promotional cards inflates the base with value no customer paid for. Recognizing breakage when cards expire, or at a fixed date, rather than in proportion to redemptions, applies a method the guidance does not use for an entity that expects breakage. Workpapers that skip governance, with no owner for the query and no change log, cannot show that next year's figure comes from the same logic.
Get an ACC-682 Topic 7 example written to your instructions
Send the ACC-682 Topic 7 instructions, the rubric and the data or estimate your section is documenting. A custom example is written to them, with sources identified to the table, transformations listed in order with counts, parameters evidenced, the computation shown, governance recorded and a reviewer's rerun documented, back in 24 to 48 hours. The first one is free.
More ACC 682 papers and MS in Accounting samples
- ACC 682 Topic 1: Disaggregation Judgment Paper
- ACC 682 Topic 2: Backlog Extraction Workpaper
- ACC 682 Topic 3: Embedded Lease Completeness Test
- ACC 682 Topic 4: Refund Liability Anomaly Review
- ACC 682 Topic 5: Rebate Accrual Pattern Dq Post
- ACC 682 Topic 6: Known Trend Chart Memo
- ACC 682 Topic 8: Error Materiality Conclusion Memo
- ACC 681 Topic 7: Related Sale Simulation Answer
- ACC 680 Topic 7: Substantive Analytic Simulation
- ACC 653 Topic 7: Transfer Pricing Policy Memo
- ACC 670 Topic 7: Segment Disaggregation Analysis
ACC 682 Topic 7 questions, answered
How is gift card breakage recognized under ASC 606?
If a company expects to be entitled to breakage, it recognizes the expected amount as revenue in proportion to the pattern of redemptions, subject to the constraint on variable consideration. If it does not expect breakage, it recognizes unredeemed amounts only when the chance of redemption becomes remote. Either way, amounts the company must remit to a government under unclaimed property laws remain a liability.
Why record who may change the query?
Because an estimate built from a stored query is only as stable as the query. If anyone can edit it without a record, next year's breakage may come from different logic while the workpaper looks the same. Naming an owner, restricting changes and keeping a log is the data governance that lets a figure be compared year to year and relied on in the statements.
What does the reviewer's rerun prove?
That the documentation is complete enough for someone else to follow. The second accountant used only the workpaper, the stored query and the named tables, and reached $1.1 million with no question put to the preparer. A rerun that needed a conversation would reveal a missing step. The rerun does not prove the parameters are right; the evidence for those is documented separately.
Where can I find a free ACC 682 Topic 7 sample paper?
Every part is above: the purpose, sources, transformations, exclusions, parameters, why the proportional method, the computation, governance and what would change the estimate. Send your gift card data layout for a free worked workpaper.
How is the 5.5 percent breakage rate reached in ACC 682 Topic 7?
Unredeemed value of 8.5 percent after month 36, less about 3.0 points owed to states under unclaimed property rules.