Gift cards and store credit roll-forward

Files you need

• Gift card accounts: Each gift card's balance at the start and end of the period, with what was issued and expired. Gift card accounts are an Adobe Commerce feature, not part of Magento Open Source.For example: Adobe Commerce gift card accounts, Gift card provider balance report.
• Store credit balances(optional): Each customer's store credit at the start and end of the period, with what was issued and expired. Store credit is an Adobe Commerce feature; export it from the admin.For example: Adobe Commerce store credit export, Customer wallet balance report.
• Redemptions on orders: Gift card and store credit amounts used on orders in the period, one row each, with the gift card code or the customer's e-mail.For example: Adobe Commerce orders (gift cards and store credit used), Order export with gift card columns.

The Magento 2 / Adobe Commerce connector can fill: Gift card accounts, Redemptions on orders.

What Sawwi checks

• Gift card balance doesn't roll forward: Opening + issued − redeemed − expired doesn't equal the closing balance: a gift card movement is missing or a balance was changed by hand.
• Gift card redeemed above its balance: More was spent than the gift card held (opening + issued − expired).
• Negative gift card balance: A gift card closed the period below zero.
• Gift card redeemed with no issuance: An order used a gift card that isn't in the balances: it was never issued, or the balances are incomplete.
• Store credit balance doesn't roll forward: Opening + issued − redeemed − expired doesn't equal the closing balance: a store credit movement is missing or a balance was changed by hand.
• Store credit redeemed above its balance: More was spent than the store credit held (opening + issued − expired).
• Negative store credit balance: A store credit closed the period below zero.
• Store credit redeemed with no issuance: An order used a store credit that isn't in the balances: it was never issued, or the balances are incomplete.