PDA

View Full Version : Figuring out Clickbank Refund Totals



qualitygoods
November 29th, 2005, 04:54 PM
Do you ever wonder why your estimated Pay Check Refund totals are always different than Clickbanks? Here is a formula to figure it out. No more guess work. You'll know your exact Pay Check amount each and every time before Clickbank even posts the total.

I'll use this Month as an example.

For Pay Period Nov. 1 to Nov. 15:

Go to the credit and debit reports.

Date: Nov. 8
Range: 16 days
Show: Refunds
Click the Search button

Do the same thing with Chargebacks and with Bounces. Same Date and Range. Add the 3 together. This is the exact Refund amount that has been taken off your Pay Check for the Pay Period 2005-11-16.

That formula works only for the first pay period of the Month. Next Month it will be the same, the only difference will be the date. Dec. 8 instead of Nov. 8.

Pay Period Nov. 16 to Nov. 30

Date: Nov. 24
Range: 14 days
Show: Refunds
Click the search button

Do the same thing with Chargebacks and Bounces. Add the 3 together.

This one won't be the same from Month to Month. The only difference is the range (and the Month of course). Calculate the number of days from the 24th to the 7th of the following Month. Nov. 24th - Dec. 7th = 14 days.

Instead of calculating: If there is 30 days in a Month, then the range is 14 days. 31 days in the Month, then the range is 15 days.

Accurate every time. No more wondering exactly what your pay check is going to be until Clickbank actually posts the amount.


For those of you that do not know how to calculate a CB Pay Check:

Credits (sales) - Debits (Refunds) + bonus + Release (allowance from 6 Pay Periods ago)
Take 10% of that total. This is your allowance for the Pay Period.

Now, take your total from above, subtract the Allowance, then subtract $2.50 for administration fees. This is your Pay Check amount.

ColaDesigns
December 5th, 2005, 11:10 PM
thanks dude, very helpful indeed... did you figure this out and type this whole thing or copy paste something you've seen before on this?

qualitygoods
December 5th, 2005, 11:30 PM
thanks dude, very helpful indeed... did you figure this out and type this whole thing or copy paste something you've seen before on this?
I figured it out on my own and typed it out. My totals were always different than Clickbanks and I wanted to know why. So I tried to figure out exactly which dates that they use to calculate the refund totals. When I figured that out, then I went back and calculated every Paychecks refund total over the past year. I came up with the same refund total that Clickbank did every single paycheck.

Give Clickbank credit. At least they are consistant and use the exact same dates when calculating the refunds.