Build a reseller credit ledger that reconciles
Track purchases, activations, extensions and reversals in credits and currency.
IPTVBlogs editorial desk · 
Record every event with a signed movement
Use columns for date, provider reference, transaction type, customer alias, credits in, credits out, currency, amount and operator. Store the provider receipt or activation reference separately. Keep account passwords and payment details out of the spreadsheet.
| Example movement | Credits in | Credits out | Balance |
|---|---|---|---|
| Opening balance | 25 | 0 | 25 |
| New activation | 0 | 3 | 22 |
| Extension | 0 | 1 | 21 |
| Provider-confirmed reversal | 1 | 0 | 22 |
Reconcile against the provider panel
Compare the ending balance with the supplier's balance at the same cutoff time. If a payment succeeded but a panel action failed, record the payment and action as separate events. Confirm the original activation reference before retrying. That helps avoid extending the same account twice.
Know what one credit means
A credit's price does not tell you how many subscription months it buys. Record the provider's credit-to-term rules and effective date. Keep taxes, processor fees and exchange costs in currency columns. Reconcile each supplier and each currency separately.
Sources
Questions readers ask
What belongs in a reseller credit ledger?
Record purchases, activations, renewals, transfers and confirmed reversals with the provider reference, quantity, time and ending balance. Keep customer passwords and card data outside the ledger.
How do I record a returned credit without overstating the balance?
Enter it only after the panel shows a confirmed reversal. Keep the original transaction and the new reversal reference, note the amount and date, and reconcile against the panel’s closing balance.