Match the reward calculated, credited and received. Keep its source and wallet snapshots alongside it, then save your record as a spreadsheet-compatible CSV or printed copy.
Start with the amounts you can identify. Unknown entries stay blank, and the worksheet keeps reward stock separate from claims, receipts and casino activity.
One illustrative USD cash record, separate comparisons
Opening reward + new reward + adjustmentSubtract credits and expired rewardUSD 7Uncredited reward stock
Wallet snapshots and activity are source references. Neither changes these two calculations.
Your working record
Enter the reward you want to reconcile
Use one earning period, currency and reward form. You can export a valid incomplete record; missing inputs remain unknown. The illustrative record loads fictional amounts for checking the workflow.
Keep the calculation and payment stages together, then save your record as a CSV file. Use one currency and one reward form for each record.
Download a local copy to keep your entries. Reloading clears the worksheet. Use a short programme label without account details.
Enter the known amounts to compare this record.
Arithmetic closing stock equals opening stock plus newly calculated reward plus the signed reward adjustment, minus credited and expired reward. Closing record difference is your entered closing stock minus that result.
A difference is a reason to check the record and its timing. An amount may still be pending or awaiting release. The worksheet does not establish an amount payable or predict a withdrawal.
CSV amounts are saved as text to preserve every decimal. Keep them as text when importing into a spreadsheet.
Your cashback record
Print the blank table or save the blank CSV worksheet. Fill one record per currency and reward form. The editable worksheet and calculated differences use JavaScript.
Blank reward record
Field
Your entry
Programme label
Period starts
Period ends
Currency
Reward form
Source or statement reference
Period cutoff and time zone, if known
Wallet or balance shown
Opening wallet snapshot
Opening snapshot date, time and zone
Closing wallet snapshot
Closing snapshot date, time and zone
Opening uncredited reward
Newly calculated reward
Reward adjustment or offset
Credited reward
Expired reward
Closing uncredited reward
Released reward
Claimed reward
Received reward
Blank activity reference in the chosen currency
Date
Activity type
Short label or source note
Amount
Settled eligible stakes
Returned payouts
Activity credit
Pending-round adjustment
Keep released, claimed and received stages separate. Arithmetic closing uncredited stock is opening stock plus newly calculated reward plus signed adjustment, minus credited and expired reward. An unknown amount stays blank.
Give every amount the same period and unit
Start with the reward line you want to check: a weekly cashback payment, a daily rakeback claim or an instalment from an earlier reward. Give it a short label and enter the calculation period. The date of a claim can fall outside the period in which its reward was earned.
Keep the programme's period intact. Choose its calculation dates. The fields store dates only, and the optional source reference keeps the cutoff time and time zone beside them. Do not combine separate daily calculations into a weekly net-loss figure. A payment date alone does not identify the calculation period.
Use one currency or asset. Keep BTC entries in BTC and USD entries in USD. A conversion needs its own rate and accounting rule; this worksheet performs no currency conversion. Use another record when the amounts cannot be reconciled in the same unit.
Choose cash or bonus reward. A bonus balance has a face amount, not an established cash value. Keep it separate from cash credits even when both use the same currency code.
Match claims to their reward. Confirm the claimed-versus-received comparison only when both entries concern the same named reward and period. A claim from an older calendar reward should not be matched to a newly calculated reward simply because both appeared today.
The reward-stage opening and closing fields mean uncredited reward stock, not your casino wallet balance. Put an already calculated but uncredited amount in the opening field. Record a credit only when that reward leaves the uncredited stock for the selected balance. Released money can still await collection, so the released field does not reduce reward stock by itself.
Activity rows are a reference for settled eligible stakes, returns, credits and pending-round adjustments. Their totals do not calculate cashback or change the reward-stock equation. If the underlying eligible loss is the question, use the worked net-loss reconstruction alongside this record.
Keep the statement behind each amount
The optional source and wallet group saves the reference that helps you recognise this reward later: a short statement label, the programme's period cutoff, the wallet shown and its opening and closing snapshots. Copy a known time zone exactly. A date-only period cannot establish when a programme's calculation day ends.
Returned payouts may mean a total that includes returned stakes, or winnings alone. Keep the convention used in your source and identify it in the activity label; do not mix those figures in one total. Enter a positive or negative pending-round adjustment only when that source establishes the direction. If the direction is unknown, keep the amount in the source note. The worksheet supplies no universal pending sign and does not cancel separate snapshots with the same label.
Reward-stage inputs
Earned but uncredited stock, newly calculated reward, adjustments, credits and expiry supply the stock calculation. Claimed and received amounts supply the separate same-reward comparison.
Source and activity references
Wallet snapshots, settled stakes, returns, activity credits and pending-round adjustments help you check the statement. They are saved without becoming another cashback calculation.
A signed wallet snapshot can be recorded as a reference. It does not change reward stock. If a reference amount is malformed, its own field shows an error and CSV export waits for the correction; complete valid reward comparisons remain visible.
A completed record with USD 15 claimed and USD 12 received
Select Load an illustrative record in the worksheet to enter this example. It uses USD cash rewards and made-up activity, not an account payment or a named casino's calculation. The USD 20 newly calculated reward is an entered example amount; no cashback percentage is inferred from the activity rows.
The entered closing amount is also USD 7, so the closing record difference is USD 0. That confirms this record's arithmetic. It does not confirm the programme's eligibility rules or the original calculation of the USD 20 reward.
Separate stages of the illustrative reward
Stage
Entered amount
How it is used
Released
USD 12
A reference stage, not another reward earned
Claimed
USD 15
Compared with receipts from the same reward
Received
USD 12
USD 3 less than the claimed amount in this record
The separate claim comparison is USD 15 - USD 12 = USD 3. It leaves a timing or record question to resolve. It is not another USD 3 of new reward, nor a finding that a payment rule has been broken.
The example's activity reference records USD 1,000 of settled stakes, USD 850 of returned payouts, a USD 10 activity credit and a signed USD -5 pending-round adjustment. These remain source notes. They are not added to cash reward stock, and the worksheet does not apply a universal loss formula to them.
Follow the difference that your record actually shows
A negative arithmetic closing stock means the credited and expired amounts exceed the stock available from the opening amount, new reward and signed adjustment. Check for a repeated credit, an adjustment with the wrong sign or entries taken from different periods. Keep the negative result while checking; replacing it with zero would hide the mismatch.
A positive claimed-minus-received difference can coexist with a matching stock record. A release may still await a claim, a recorded request may be pending, or a receipt may belong to another reward. Compare the reward name, period and stage before treating two amounts as a pair. The worksheet sets no payment deadline and predicts no withdrawal.
If a reward appeared but the amount is smaller, use the guide to lower cashback payments to check the rate, calculation base, minimum and timing.
If the amount of eligible loss cannot be reconstructed, return to the net-loss ledger. Recording a claimed amount cannot resolve an uncertain calculation base.
Use the casino rewards calculator for a separate formula scenario. Copy a supported result into the newly calculated field only with its assumptions intact. The calculator's nominal result is not a record of an actual account credit.
Put the programme beside the record
Weekly rewards and lifetime records need different notes
Record the amount that belongs to the selected product. A weekly cashback credit, daily rakeback and a lifetime cashback calculation can appear in the same account while referring to different activity and earning periods.
Booi: keep the weekly calculation and collection together
4-7% of adjusted weekly net losses. Wooden Lemur: 4%; Bronze Eagle: 4%. Higher statuses rise to 7% at Diamond Gorilla.
Earning period
Friday 00:00:00 to Thursday 23:59:59 UTC.
Availability and collection
Friday from 00:00 UTC, within an hour. Seven days; unclaimed cashback is replaced by the next weekly amount.
Reward and minimum
Real funds to Main Balance, available for withdrawal. 0x on the cashback reward. Cashback below USD/EUR1 cannot be activated. The separately stated minimum for withdrawing cashback is USD1; neither rule states an activation deposit.
Keep winnings, other real-balance credits and unfinished-round amounts with the source calculation. The stated minimum concerns activating the refund; it is not a deposit instruction. An earning cap is not established.
1-15% of the weekly cashback base, before other reward deductions. Keep each currency's reward record separate.
Starting balance plus deposits, less ending balance and withdrawals, with the programme adjustment for unsettled sports bets; apply the rate, then deduct other bonuses and rakebacks.
Bronze 1 after USD100 qualifying real-money turnover: 1%. Level 0 does not receive weekly rewards.
Earning period
Preceding calendar week.
Calculation and collection
Calculated Monday 00:00 UTC; claim before Sunday 23:59 UTC. Seven days.
Reward
Wager-free reward in each currency used for qualifying play. 0x on the reward.
Diamond 5's weekly rate is 15% after USD 30,000,000 accumulated qualifying real-money turnover. That threshold is turnover, not a loss figure or deposit. Keep daily rakeback and this weekly reward in separate records.
Save the pending-bet snapshots as the source shows them. Matching words on opposite sides of its formula do not establish identical amounts. Daily and level-up rewards are separate records; the worksheet does not infer a combined rate or a negative-reward floor.
5-15% public VIP range on the cumulative loss base; account rate applies.
Lifetime deposits plus received player transfers, less withdrawals, outgoing player transfers and current balance; apply the percentage, then deduct received cashback.
Reward treatment
Reward balance with redemption conditions; withdrawal of the principal is not established.
Wagering
x3; the exact wagering base is not specified.
Credit timing
Automatic credit; a universal recurring time and timezone are not specified.
Keep incoming and outgoing transfers and previously received cashback with this cumulative record. A fresh weekly loss is a different input. The separate daily Otkat Plus does not inherit the cashback rate; record only an amount you can identify.
Download the CSV after entering the amounts you can identify. Its fixed columns keep the programme, period, unit, source references, reward stages and comparison states together. Monetary values are saved as text to preserve long and very small decimals; keep that column as text in your spreadsheet.
Print reads the current draft, including a field you have just edited and any validation message. Without JavaScript, use the printable blank tables or blank CSV. Reloading clears entered values, so keep a local copy before leaving.
Reloading clears the entered draft. Download the CSV or print the current record before leaving the page. There is no account connection, upload or automatic saving.
Should an amount I cannot find be entered as zero?
Leave an unknown amount blank. Enter zero only when the selected record shows zero. A blank input can leave one comparison awaiting information while another complete comparison still works.
Why do wallet snapshots and activity rows leave the reward result unchanged?
They are references for the source behind the record. Reward stock uses the entered opening reward, newly calculated reward, signed reward adjustment, credited reward and expired reward. Wallet balances, stakes and returns do not supply a universal cashback formula.
Which dates and time zone should I record?
Enter the earning period as YYYY-MM-DD dates. Copy a known cutoff and time zone into the source reference; leave them blank when unknown. Snapshot date, time and zone fields preserve your note exactly and do not calculate a deadline.
Can a cash reward and a bonus reward share one record?
Use separate records for different currencies or reward forms. A bonus face amount is not established cash value. The worksheet performs no currency conversion or bonus valuation.
Does a claimed-minus-received difference prove that money is owed?
It identifies a difference only after you confirm that both amounts concern the same named reward and period. Check the stage, timing and source record before interpreting it as a payment problem. The worksheet establishes no amount payable.
