Choose what the record should measure
A digital gift card creates at least two useful records: how it was funded and how its value was later used. Begin by deciding whether the main measure is cash paid by the household or the cost of goods acquired. Both views can be maintained, but they should not be combined into a total that counts the same prepaid value twice.
Record whether the card was purchased by the household or received from someone else. A received card can support future purchases without creating a matching debit in the recipient's bank account. Preserve that funding context without inventing a cash receipt or making any assumption about how it should be treated for another reporting purpose.
Establish the opening prepaid balance
Keep the card's documented value, funding date and relevant purchase evidence. Use a safe working identifier rather than exposing the full redemption code in a broadly shared record. The purpose is to connect activity to the correct card, not to make the card usable by anyone who sees the worksheet.
If the amount paid differs from the value loaded, retain both facts with their labels. A discount, separately documented bonus or another arrangement can make them different. Do not alter one figure merely to make it equal the other, and do not assume that the stored value can be converted back into cash.
Reconcile an illustrative redemption sequence
Suppose a fictional card is bought for 1,000 currency units and carries 1,000 of usable store value. A purchase redeems 350 and another redeems 275. Total value used is 625 and the remaining card balance is 375. The prepaid ledger should reproduce that sequence from the opening value and supported redemptions.
Under a cash-at-funding view, the household paid 1,000 when buying the card. The later 350 and 275 redemptions do not create another 625 of bank outflow. A goods-acquired view can classify those redemptions by what they bought while retaining the funding event separately. State which total is being used whenever the two views are shown together.
| Prepaid event | Remaining value |
|---|---|
| Opening value | 1,000 |
| Redeem 350 | 650 |
| Redeem 275 | 375 |
Keep mixed-payment orders understandable
A purchase may use part of the card and another payment method. Record the full receipt amount and each supported funding component. The card redemption reduces prepaid value, while the additional account payment is a fresh cash event. Connect them to one purchase rather than creating several unrelated purchases with the same receipt.
Do not assume that an order used the card simply because its merchant matches the card's store. Preserve the actual payment breakdown where available. A household can pay the same recipient through several methods, and the evidence should determine which balance was affected.
Handle adjustments by their actual destination
A completed adjustment might appear as restored card value or as another documented payment movement. Record the destination shown by the evidence rather than assuming every refund reaches the original bank account. Keep the original redemption and adjustment connected so the balance can be reconciled.
An approval or support message is not the same as value already restored. Show expected adjustments separately until completion is supported. If the available balance differs from the working ledger, investigate missing redemptions, duplicate entries and completed adjustments before inserting an unexplained balancing amount.
Finish with cash and value clearly separated
At review, show the supported cash paid for funding, the value redeemed and the remaining documented balance. Keep any uncertainty attached to a specific event or amount. A remaining prepaid balance is not additional cash in the household's bank account, even when it may be relevant to a future purchase plan.
Carry the closing card value into the next prepaid ledger while recording only new funding as new cash outflow. The finished record should explain where the value came from, what used it and what remains, with a consistent distinction between paying for the card and spending the value it already holds.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

