Bluepeak Music Studio: Package Prepayments, a Declined Card, and Refund Hygiene
Bluepeak Music Studio sells 10-lesson packages for $2,500, paid up front, and records the entire amount as income on the day the card clears. Sessions are delivered over roughly four months. Last quarter 14 clients cancelled mid-package and received partial refunds totalling $6,300, which the studio booked by deleting the original invoice and reissuing a smaller one. One client's $1,800 card payment was declined six days after the invoice had been marked paid, and the bank had already bundled that payment into a lump-sum deposit that was matched in the feed. The studio also offers a 10% discount for payment within five days, and sales tax is charged at 8.25% on packages. The owner wants monthly revenue that reflects delivery and a clean trail for the upcoming review.
1. Design the recording flow for a $2,500 package so monthly revenue reflects sessions delivered rather than cash received.
Read the worked answer
Two-layer approach.
- At sale: create a service item (e.g. 'Lesson Package - 10') mapped to a Deferred Revenue liability account, not to income. Invoice the customer for $2,500 using that item, plus sales tax. The entry is Dr A/R, Cr Deferred Revenue, Cr Sales Tax Payable. No income is recognised yet, which is correct on an accrual P&L.
- At delivery: each month, post a journal entry Dr Deferred Revenue / Cr Lesson Income for the value of sessions actually delivered (e.g. 3 sessions × $250 = $750). If sessions are tracked well, a short recurring template per active client works; above ~20 active packages, move the schedule to a spreadsheet or app and post one summarised monthly JE by class.
Why not just invoice monthly? Because the cash was collected up front - an invoice-per-month creates a receivable that does not exist and makes A/R aging meaningless.
Controls:
- Reconcile the Deferred Revenue balance monthly to the schedule (packages outstanding × unrecognised sessions). This is the single number that catches missed recognition.
- Set an expiry rule and a stated refund policy; unused expired sessions need a decision (recognise as breakage income or refund) recorded consistently.
- Keep the sales tax where it landed at the time of sale - do not move tax through the deferred revenue account.
2. The $1,800 payment was declined after it had been marked paid and swept into a matched bank deposit. Walk through the correction, and say what must not be done.
Read the worked answer
Sequence matters.
- Do not delete the customer payment first. It is inside a bank deposit that was used to match the actual bank deposit line in the feed. Deleting it leaves the bank deposit short by $1,800 and knocks the reconciliation out.
- Open the Bank Deposit and remove that $1,800 line from it (edit the deposit, uncheck the payment). The deposit total now matches what the bank actually credited.
- Then delete the customer payment. The original invoice returns to open status with the $1,800 balance outstanding - which is the truth.
- Re-match the feed. The bank feed entry for the lump deposit may now be unmatched or matched to a now-wrong amount; re-link it to the corrected bank deposit.
- Handle fees separately. Any returned-payment fee the bank charged is its own small expense transaction - not an adjustment to the customer's invoice unless you contractually pass it on, in which case bill it as a separate line.
What not to do: do not post a journal entry to Bad Debt to make the invoice disappear. The customer still owes it, and a bad-debt write-off in the period the card declined misstates both A/R and the allowance decision. Write off only after collections efforts fail.
Root cause to fix: the payment was marked paid on the strength of an authorisation, not a settlement. Change the practice to record receipt when funds settle (or when the processor shows paid), and reconcile processor payouts to invoices monthly.
3. How should refunds and the 10% early-payment discount be recorded so gross sales and sales tax stay meaningful?
Read the worked answer
Refunds - never delete and reissue. Deleting the original invoice does three damaging things: it destroys the audit trail, it changes the sales tax that was computed on the original sale, and it leaves the customer's history showing a smaller sale than actually happened. Instead:
- Partial refund / price concession: issue a Credit Memo against the original invoice for the refunded amount, then a Refund Receipt (or a refund dated to the card) to return the money. Sales tax is reversed pro rata by QBO when you include the taxable line correctly on the credit memo.
- Return of unused package: credit memo against the deferred revenue item, not against income, so you are not reversing revenue you never recognised.
- Timing: the reversal belongs in the period the refund was agreed, even if the original sale was in a closed period.
Discount. Use the invoice's Discount line (percentage or amount) rather than lowering the line price, and map it to a Discounts Given contra-income account. Then:
- Gross sales stay honest and the discount is visible as a cost of getting paid early.
- Sales tax is computed on the discounted amount, which is the correct treatment for a discount taken at the time of sale - verify on the Sales Tax Detail report after the first few invoices.
- Contrast with a bad debt write-off or a courtesy credit: those are credit memos to a different account, not discounts. Mixing the two destroys the metric the owner is trying to read.