Blog
Work out one month of card interest by hand with average daily balance
List each day's balance, average it, apply the daily rate and the days in the cycle, then compare with your statement. A worked cycle and a blank worksheet.
The interest line on a card statement looks like it came from a black box, but for most cards it comes from a short calculation you can repeat with a pencil: list the balance for each day of the cycle, average those balances, multiply by the daily rate and by the number of days. If your answer lands within a few cents of the statement, you understand the charge. If it does not, you have found a specific question to ask the issuer.
This worksheet does one month, start to finish, with a completed example and a blank version for your own numbers. You need your last statement, its list of transactions and a calculator.
What you are calculating
Most card issuers use some form of the average daily balance method. The idea is that interest should reflect not just what you owed at the end of the month but how much you owed on each day. A balance of $2,000 that is paid down to $1,500 on day 15 costs less than one that stays at $2,000 all month, and the calculation captures that.
Three pieces make up the formula:
- The daily balances. The amount you owed at the end of each day of the billing cycle.
- The daily periodic rate. The annual rate divided by the number of days in the year, usually 365, though some issuers state 360. Your agreement says which. See daily periodic rate for the definition.
- The number of days in the cycle. Usually 28 to 31.
The interest, in one line, is:
Interest = (sum of daily balances) x (daily periodic rate)
That is the same as the average daily balance times the daily rate times the days, since the average is the sum divided by the days. Either way you reach the same dollar figure, and showing both ways is a handy self-check.
A finance charge on your statement is the total interest and certain other charges for the cycle. In this worksheet we calculate only the interest on one balance at one rate. If your card has several rates, run the worksheet once for each balance type. Where your payment goes when a card has balances at different APRs explains why.
Step 1: collect your numbers
Gather these from the statement and the transaction list:
- The billing cycle dates. The statement shows the start and end, or the closing date. The number of days is the length of the cycle. If you have a statement closing date of the 1st, a cycle may run from the 2nd of one month to the 1st of the next.
- The balance at the start of the cycle. The previous statement's closing balance, including any interest already added.
- Every transaction and its posting date. Purchases, payments, credits, fees. Use the posting date, not the date you swiped, because the posting date is when the balance changed.
- The APR that applies, from the interest charge table on the statement. For purchases it is the purchase APR.
- The day count your agreement uses, 365 in this example.
Step 2: build the daily balance table
Start with the opening balance. Add purchases and fees on the day they post, and subtract payments and credits on the day they post. Group the days where the balance did not change into one row.
A completed example
This is a labeled hypothetical. The rate is an illustration, not a market rate. Say Alex's card has a $2,000 balance carried into a 30-day cycle at an illustrative 24 percent APR. During the cycle, a $150 purchase posts on day 10, a $300 payment posts on day 15 and an $80 purchase posts on day 22.
| Days | Number of days | Balance each day | Balance x days |
|---|---|---|---|
| 1 to 9 | 9 | $2,000 | $18,000 |
| 10 to 14 | 5 | $2,150 | $10,750 |
| 15 to 21 | 7 | $1,850 | $12,950 |
| 22 to 30 | 9 | $1,930 | $17,370 |
| Total | 30 | $59,070 |
Check the row arithmetic. Days 10 to 14: $2,000 + $150 = $2,150, times 5 days is $10,750. Day 15 brings a $300 payment: $2,150 - $300 = $1,850, times 7 days is $12,950. Day 22 brings an $80 purchase: $1,850 + $80 = $1,930, times 9 days is $17,370. The day counts (9 + 5 + 7 + 9) add to 30, which is a quick test that no day is missing or counted twice.
Steps 3 to 5: average, rate, multiply
Step 3: add up and average
Sum of the "balance x days" column: $18,000 + $10,750 + $12,950 + $17,370 = $59,070.
Average daily balance: $59,070 / 30 = $1,969.00.
That is the balance the issuer treats as having been outstanding all month. It is lower than the starting balance because of the payment on day 15, and higher than the ending balance of $1,930 because the balance was $2,000 or more for the first 14 days.
Step 4: find the daily rate
Daily periodic rate = APR / 365 = 0.24 / 365 = 0.00065753 (about 0.0658 percent a day).
If your agreement uses 360, divide by 360 instead, which gives a slightly higher daily rate. The Schumer box or the agreement gives the day count. How to read a credit card Schumer box line by line before you apply shows where to find it.
Step 5: multiply
Interest = average daily balance x daily rate x days in the cycle.
$1,969.00 x 0.00065753 x 30 = $38.84.
The shortcut gives the same answer: $59,070 x 0.00065753 = $38.84. If the statement's interest line for this balance shows $38.84, or a figure within a few cents, you have reproduced it.
Step 6: compare with the statement
Open the interest charge table on the statement and look at the row for this balance type. Compare your figure with the issuer's interest charged. Three outcomes are possible.
- They match within a few cents. Rounding explains any gap. You have confirmed how the interest works on your account.
- Yours is lower. Something in your table is missing or the issuer is counting a day differently. Check for fees, a transaction that posted earlier than you assumed, or interest already added to the balance.
- Yours is higher. Check whether the issuer's method differs from the one you used. The next section shows the usual differences.
Why your figure may differ from the statement
Several ordinary reasons can move the result by a small amount. Each has an example here, using Alex's cycle.
1. The method is not exactly the one you used. Issuers describe their balance computation in the agreement and in the Schumer box. Some methods leave new purchases out of the average. In Alex's cycle, leaving out the two new purchases keeps the balance at $2,000 until the payment and $1,700 after it: 14 days at $2,000 is $28,000 and 16 days at $1,700 is $27,200, for a total of $55,200. The average is $1,840 and the interest is $55,200 x 0.00065753 = $36.30, about $2.54 less than $38.84. The balance-computation row in the Schumer box tells you which method your card uses.
2. The day count. Using 360 days instead of 365 changes the daily rate to 0.24 / 360 = 0.00066667, and the interest to $59,070 x 0.00066667 = $39.38, which is 54 cents more than the 365-day result.
3. Daily compounding. If the issuer adds each day's interest to the balance, the next day's interest is charged on it. In Alex's cycle that raises the figure from $38.84 to about $39.22, a gap of 38 cents. Whether interest compounds daily or monthly depends on the agreement, and credit card interest myths tested, from daily compounding to grace periods tests common claims about compound interest on cards.
4. Posting dates. A purchase made on day 9 that posts on day 11 changes your table. The posting date is on the transaction list.
5. Fees and credits. A fee added during the cycle changes the balance. A refund that posts changes it the other way.
6. A grace period. If you had a grace period, there may be no interest at all on purchases, and your calculation does not apply to those. I paid my card in full but still got charged interest. Why? explains the cases.
7. A minimum interest charge. A card may have a floor, and very small balances can produce a charge larger than the calculation.
None of these is an error by itself. If the gap is large and none of them explains it, call the number on the back of your card and ask the representative to walk through the calculation. The CFPB complaint process is available if you do not get a clear answer.
What payment timing does to the figure
The same transactions, shifted in time, give different interest. That is the practical lesson of the worksheet, and you can see it with Alex's numbers.
| Scenario | Sum of daily balances | Average daily balance | Interest at 24% (365 days) |
|---|---|---|---|
| Payment of $300 on day 15 (the example) | $59,070 | $1,969.00 | $38.84 |
| Same $300 paid earlier, on day 5 | $56,070 | $1,869.00 | $36.87 |
| Same $300 paid later, on day 28 | $62,970 | $2,099.00 | $41.40 |
Paying on day 5 instead of day 15 lowers the interest by about $1.97, because $300 was kept off the balance for ten more days: $300 x 10 days x 0.00065753 = $1.97. Waiting until day 28 raises it by about $2.56. The amount is small here because the payment is small, but it scales with the size of the payment and the length of time. For a large balance, paying earlier in the cycle is the way to reduce interest without changing what you pay in total. how to time your payments within the billing cycle to cut interest works this through further.
Shortcuts and sanity checks
Once you have done the full table, a few quick checks help you spot a number that is off before you spend time on it.
The one-line estimate. Average daily balance x APR x days / 365. For Alex: $1,969 x 0.24 x 30 / 365 = $38.84. It is the same calculation written another way, which is why it is a good check that you did not slip on the daily rate.
The divide-by-twelve shortcut. People often estimate a month's interest as balance x APR / 12. For a steady $2,000 at 24 percent that gives $40.00. The day-based figure for a 30-day cycle is $2,000 x 0.24 x 30 / 365 = $39.45. The twelfths shortcut slightly overstates a 30-day cycle and slightly understates a 31-day one, since a year has 365 days and not 360. It is useful for comparing options and not for reproducing a statement.
The cycle length matters. With the same average balance, a 31-day cycle costs more than a 30-day one: $1,969 x 0.00065753 x 31 = $40.14 against $38.84. Over a year the days average out, but a given statement can look higher or lower because of how many days it covers. A February cycle will usually look cheaper than a March one even if you did nothing differently.
The percent-of-balance test. Divide the interest by the average daily balance: $38.84 / $1,969 = 1.97 percent for 30 days. Multiply by 365 / 30 and you get about 24 percent, which is the APR. If a statement's interest divided by its average daily balance, scaled to a year, is far from the stated APR, something unusual is in the charge, such as a fee or a different balance type.
The sign check. Interest should rise when the average balance rises and fall when it falls. If you paid a large amount early in the cycle and the statement's interest barely changed from last month, look at the posting date of the payment, since a payment that posted on day 29 does little for the average.
Your turn: the blank worksheet
Copy the table below and fill it in with your own cycle.
| Days (from to) | Number of days | Balance each day | Balance x days |
|---|---|---|---|
| 1 to __ | |||
| __ to __ | |||
| __ to __ | |||
| __ to __ | |||
| __ to __ | |||
| Total | (must equal days in cycle) | Sum = ____ |
Then complete these lines:
- Sum of balance x days: ______
- Days in the cycle: ______
- Average daily balance (line 1 divided by line 2): ______
- APR as a decimal (for example 0.24): ______
- Day count your agreement uses (365 or 360): ______
- Daily periodic rate (line 4 divided by line 5): ______
- Interest (line 1 multiplied by line 6): ______
- Interest on your statement for this balance: ______
- Difference (line 8 minus line 7): ______
If you would like a second opinion, the credit card interest calculator takes the same inputs. Use it to confirm your arithmetic, not to replace the exercise: the value of doing it once by hand is that you can see where the dollars come from.
Some tips for filling it in. Work from the transaction list in date order, and cross out each transaction as you place it. Round the daily rate to at least eight decimal places or keep it in the calculator, since rounding it early to 0.00066 shifts the result by about 15 cents in the example above. If a day has more than one transaction, apply them all and use the balance at the end of that day. If the cycle opens with interest from the previous month already added to the balance, use that opening figure as the statement shows it. And if your card has both purchases and a cash advance, run a separate table for each, because each has its own rate and its own balance.
What to do with the result
- If you matched the statement, you know the charge is a function of your balances and rate. If the number is bigger than you like, the lever is the balance, the timing of payments or the rate, in that order of practicality.
- If you did not match, write down the gap, the method you assumed, and the statement dates. Call the issuer and ask which balance computation method applies and whether the interest is compounded daily.
- If a charge looks wrong, and the issuer's explanation does not account for it, you can dispute a billing error in writing within 60 days of the statement that showed it. A phone call alone may not trigger the statutory protections.
- If you want to lower the number, consider where payments land in the cycle, whether a balance could move to a lower rate and how the balance is being paid down overall. From APR to daily rate to the interest line on your statement walks the same path from the rate side.
Key takeaways
- Most card interest can be reproduced by summing each day's balance, multiplying by the daily periodic rate (APR divided by 365, or the issuer's stated day count) and checking the day count equals the cycle length.
- In the worked cycle, balances that moved from $2,000 to $2,150 to $1,850 to $1,930 gave an average daily balance of $1,969 and interest of $38.84 at an illustrative 24 percent.
- The statement can differ by cents or a couple of dollars because of the balance method, a 360-day year, daily compounding or posting dates, and the Schumer box and agreement say which applies.
- Moving the same $300 payment from day 15 to day 5 cut interest by about $1.97 in the example, so earlier payments in a cycle lower interest without changing the total paid.
- If your hand calculation and the statement stay far apart after the usual explanations, ask the issuer to walk through the method, and use the CFPB complaint process if the answer is unclear.