eCommerce Cash Flow: The Gift Card Trap (And How to Handle Deferred Revenue)

Imagine it is the end of November. Your Black Friday and Cyber Monday campaigns were a massive success. Alongside your core products, you heavily promoted digital gift cards and upfront annual subscriptions.

By the end of the month, you have sold a massive amount of gift cards. The cash hits your bank account. Seeing that spike in your storefront dashboard, it is a very natural assumption to make that you have the capital on hand to fund your Q1 inventory planning.

But there is a potential problem: that money isn't actually revenue.

When January and March roll around, those customers return to your site to redeem their cards. Suddenly, your warehouse is busy packing orders, your business is incurring the Cost of Goods Sold (COGS), and you are paying for shipping, but absolutely zero new cash is entering the business.

By March, you realise you have been fulfilling a liability that you failed to account for, effectively obscuring your cash flow forecasting. 

Here is why this happens, and how growing eCommerce brands fix it.

The Challenge of Deferred Revenue 

The root of this cash flow trap often lies in how standard eCommerce platforms report sales.

If you treat your storefront payouts as your primary metric for revenue, you are likely using a form of cash accounting. In the eyes of a basic storefront, a gift card sale often looks the same as a t-shirt sale: a customer paid money, so it is recorded as income.

However, in proper retail accounting, selling a gift card (or taking an upfront payment for a 12-month subscription) creates deferred revenue.

Deferred revenue is money you have collected, but have not yet earned by delivering a product or service. Until that customer actually redeems the card and you ship them a physical item, that cash is legally and financially a liability on your balance sheet. You owe those customers that exact amount in stock.

If you record this liability as top-line revenue in November, you risk artificially inflating your Q4 profits while setting yourself up for a significantly tighter cash flow situation in Q1.

How to Improve Your Cash Flow Forecasting

To scale sustainably, you need a clear picture of when your cash will actually be available to spend. This means establishing a workflow that separates earned revenue from future liabilities, and predicting when those liabilities will be called in.

Here are the two steps to get your cash flow forecasting back on track.

1. Upgrade Your Retail Accounting Process

The first step is to stop relying solely on blended storefront payouts for your financial reporting. You need a system or process that acts as a bridge between your eCommerce channels and your general ledger (like Xero or Sage Intacct).

When a customer buys a £100 gift card, your accounting process needs to recognise the nature of the transaction. It should record the cash inflow, but log the £100 as a liability (deferred revenue) rather than earned income. 

Later, when the customer buys a £100 product using that card, your ledger should be updated, moving that £100 out of liabilities and officially recognising it as earned revenue, right when the COGS are incurred.

Keeping your profit margins and tax liabilities perfectly aligned across thousands of orders usually requires a central operational hub. This is where a Retail-First ERP system like Brightpearl by Sage steps in, automatically acting as this bridge to ensure accurate accounting without your finance team drowning in manual data entry.

2. Use Data to Forecast Redemption Timing

Properly categorising the liability in your ledger is a great start, but operators also need a sense of when that liability is going to hit the warehouse.

If you aren't sure when customers are going to redeem their gift cards or claim their subscription boxes, it becomes difficult to accurately forecast your inventory needs or your Q1 cash position.

You can solve this by analysing your historical data to forecast redemption timing. Look back at previous years to identify patterns. For example, you might find that historically, 60% of your holiday gift cards are redeemed in the third week of January, and 30% are saved until the launch of your spring collection in March. Factoring these trends into your Q1 purchasing decisions allows you to hold back the right amount of cash to cover those upcoming COGS.

Mastering Your True Cash Position

When you combine accurate deferred revenue accounting with predictive analytics, you gain a massive operational advantage: the ability to forecast your cash position months in advance.

You will have a much clearer view of how much of your current bank balance is safe to spend on growth, and how much needs to be held back to cover future redemptions. You can move away from relying on storefront dashboards, and start running your business on clearer financial data.

If you are looking to automate this process, Brightpearl by Sage natively connects your eCommerce storefront to your accounting ledger to handle deferred revenue automatically, while its built-in Retail Analytics helps predict exactly when those liabilities will turn into actual orders.

Ready to get a clear view of your cash flow?

Book a demo today to discover how Brightpearl helps you manage your financials.