The daily collected balance method calculates interest on a loan or deposit by applying the periodic interest rate to the balance that has actually cleared and is available in the account at the end of each day. You enter the starting balance, the annual percentage rate (APR), and the number of days in the billing cycle, and the calculator returns the interest charged or earned for that period. This method is common for credit cards, checking accounts, and some business loans, and it differs from the average daily balance method because it ignores deposits or payments that have not yet cleared.
Formula
The daily collected balance method uses a simple formula:
Interest = Balance × (APR / 100) × (Days in period / 365)
- Balance – the collected balance at the end of each day (in dollars).
- APR – the annual percentage rate, expressed as a percentage (e.g., 18 for 18%).
- Days – the number of days in the billing cycle (typically 28–31).
- 365 – the number of days in a year (some institutions use 360, but 365 is standard for consumer accounts).
If the balance changes during the cycle, you compute the interest for each day separately and then sum the daily amounts. The calculator above assumes a constant balance for the entire period, which is the simplest case. For a changing balance, you would repeat the calculation for each day’s collected balance.
Worked Example
Using the default values from the calculator:
- Starting balance (p) = $1,000
- APR = 18%
- Days = 30
Step 1: Convert APR to a daily rate. Since the formula uses APR/100, the daily rate is 18/100 = 0.18 per year. For 30 days, the fraction of the year is 30/365 ≈ 0.08219178.
Step 2: Multiply the balance by the annual rate and the time fraction:
Interest = $1,000 × 0.18 × (30/365)
Step 3: Calculate: $1,000 × 0.18 = $180. Then $180 × 30 = $5,400. Divide by 365: $5,400 / 365 ≈ $14.7945.
Step 4: Round to the nearest cent: $14.79.
The calculator gives the same result because it performs exactly this arithmetic.
Assumptions
- The balance is constant for the entire billing cycle.
- Interest is calculated on a simple basis, not compounded daily within the period.
- The year is assumed to have 365 days.
- The APR is the nominal annual rate, not the effective annual rate.
- No fees, penalties, or grace-period adjustments are included.
How the Daily Collected Balance Method Differs from Other Methods
Several methods exist for calculating interest on loans and deposits. The daily collected balance method is one of them, and it is important to understand how it compares:
- Average daily balance method – Sums the balances at the end of each day, divides by the number of days, then applies the periodic rate. This method includes pending transactions if they are posted, but it averages them out.
- Previous balance method – Uses the balance at the start of the billing cycle, ignoring any payments or purchases during the cycle. This is often the most expensive for borrowers.
- Adjusted balance method – Subtracts payments made during the cycle before applying the rate, but does not add new purchases. This is favorable to borrowers.
- Daily collected balance method – Only counts balances that have cleared (collected). A check that has not cleared is not counted, even if it appears in the account. This is stricter than the average daily balance method.
For credit cards, the daily collected balance method can result in higher interest charges than the average daily balance method if you make a large payment that takes several days to clear, because the payment is not counted until it clears.
When to Use This Calculator
Use this calculator when you want to estimate the interest on an account or loan that uses the daily collected balance method. Common situations include:
- Credit card balances where the issuer states it uses the daily collected balance method.
- Business checking accounts that pay interest on collected balances.
- Short-term loans where interest accrues daily on the available balance.
To get an accurate estimate, you need to know your exact collected balance each day. If your balance changes, you should calculate the interest for each day separately and sum the results. This calculator gives a quick estimate for a constant balance, which is useful for planning or for comparing offers.
Common Mistakes and Misconceptions
One common mistake is confusing the daily collected balance method with the average daily balance method. The key difference is that the collected balance method only counts funds that have cleared. If you deposit a check on Monday but it does not clear until Wednesday, the funds are not counted for Monday and Tuesday. This can reduce the interest you earn on deposits or increase the interest you pay on a loan.
Another mistake is using 360 days instead of 365. Some financial products, especially commercial loans, use a 360-day year, which results in slightly higher interest. Always check the terms of your agreement to see which day count convention is used.
Rounding errors can also occur if you round intermediate steps. For example, if you round the daily interest to the nearest cent each day, the total for 30 days may differ by a few cents from the direct calculation. The calculator above rounds only the final result.
A common misconception is that the APR is the same as the interest rate charged each day. The APR is an annual rate; the daily rate is APR/365. If you have an APR of 18%, the daily rate is approximately 0.0493% (18/365). Applying this daily rate to the balance for 30 days gives the same result as the formula above.
How to Read the Result
The result is the interest charged or earned for the billing period, assuming a constant collected balance. For a loan, this is the amount you would pay in interest for that period. For a deposit account, this is the interest you would earn. The result does not include any fees, and it assumes no payments or deposits during the period.
If you want to know the annual interest, multiply the period interest by (365 / days). For the example above, $14.79 × (365/30) ≈ $180, which is 18% of $1,000, as expected.
Remember that this is an estimate. The actual interest may differ if your balance changes, if the institution uses a 360-day year, or if there are grace periods or other adjustments. Always check your statement or the lender’s disclosure for the exact calculation.
Frequently Asked Questions
What is the difference between collected balance and ledger balance?
The ledger balance is the total of all posted transactions, including checks that have not yet cleared. The collected balance is the ledger balance minus any uncollected funds (e.g., checks deposited but not yet cleared by the issuing bank). Interest is calculated on the collected balance, not the ledger balance.
Does the daily collected balance method apply to credit cards?
Yes, some credit card issuers use this method. It is less common than the average daily balance method, but it is used, especially for business credit cards or cards with high transaction volumes. The card agreement will specify the method used.
How can I reduce interest charges if my card uses this method?
Because only collected balances count, making payments earlier in the billing cycle can reduce the collected balance sooner, thereby reducing interest. However, if a payment takes days to clear, it will not reduce the collected balance until it clears. You can also avoid carrying a balance, which eliminates interest entirely.
Is the daily collected balance method the same as daily compounding?
No. The daily collected balance method calculates simple interest on the collected balance each day, but it does not compound within the billing period. Daily compounding would add each day’s interest to the balance before calculating the next day’s interest. The calculator above uses simple interest.
What if my balance changes during the billing cycle?
You would need to calculate the interest for each day separately using that day’s collected balance, then sum the daily amounts. For example, if you have $1,000 for 15 days and $2,000 for 15 days, the interest would be (1,000 × 0.18 × 15/365) + (2,000 × 0.18 × 15/365) = $7.40 + $14.79 = $22.19. The calculator above assumes a constant balance, so it gives an estimate only for that case.
Why do some institutions use 360 days instead of 365?
Using 360 days increases the daily interest rate slightly (APR/360 instead of APR/365), which means more interest charged or earned. This convention is often used in commercial lending and some mortgage products. Consumer credit cards typically use 365 days, but always check the agreement.
This result is an estimate for educational purposes; your lender’s or bank’s disclosure provides the exact figures for your account.
Related
Formula used
in p | Starting balance | $ | 1000 | 0 | 100000000 in apr | Annual interest rate (APR) | % | 18 | 0.01 | 100 in days | Days in billing cycle | days | 30 | 1 | 366 out int | Interest for period | $ | p * (apr / 100) * (days / 365) | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Secured Loan with Savings Account: How It Works$405.53
- Secured Loan Servicing: How It Works & What to Know$405.53
- Secured Loan With a Car Title? How It Works$405.53
- Secured Loan Interest Rates: How They Work$405.53
- Secured Loan Requirements: What Lenders Check$405.53
- Secured Loan Home Improvement: How It Works$405.53