ACC 682 Topic 7 breakage estimate workpaper example

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

This ACC 682 Topic 7 sample paper documents a gift card breakage estimate so every figure traces to a stored source. It was prepared for GCU ACC 682, Accounting and Data Analytics Core, catalog code ACC-682, in the Grand Canyon University MS in Accounting program. Sixty monthly cohorts show 91.5 percent of value redeemed by month 36, leaving 8.5 percent. About 3.0 points must be remitted under unclaimed property rules, so breakage is 5.5 percent. Under the proportional method, $18.3 million of redemptions yields $1.1 million of breakage. Promotional cards are excluded, the subledger agrees to the ledger and a rerun matches.

CourseACC 682 Accounting and Data Analytics Core
TopicTopic 7
Paper typeBreakage estimate workpaper
LengthAbout 970 words, 2 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramMS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 682 Topic 7

1

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.

What this page is doingThe title states the estimate and the workpaper's standard, that every figure can be traced to a stored source. The company and figures are illustrative composites; the standards and sources are real.
2

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

StepTransformationCards remaining
1Draw all cards issued in the last 60 months from the issuance table1,284,000
2Remove promotional cards issued free1,106,000
3Remove voided and fully refunded cards1,098,500
4Group cards into 60 monthly issuance cohorts1,098,500
5Join redemptions and compute cumulative percentage of value redeemed by month since issue1,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

LineValue
Cumulative redemption rate at month 3691.5%
Unredeemed share of value8.5%
Less share remitted to states3.0%
Breakage rate, share of value issued5.5%
Breakage as a share of expected redemptions6.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 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.