BPI Credit Card Finance Charge Calculator in a Spreadsheet

Quick Answer: BPI charges interest day by day: each day's unpaid balance times a daily rate equal to the monthly finance charge rate × 12 ÷ 360, added up for the cycle. On the rates BPI listed when we read its page on 27 October 2026 (3% a month on most cards, 2.5% on BPI Free+), a Php 20,000 balance carried for 31 days with Php 850 paid on day 20 costs Php 609.80. A cash advance adds a Php 200 fee, and interest runs on the advance plus that fee from the posting date.

To check a BPI credit card finance charge you need four numbers from your Statement of Account and one rule from BPI's terms. The numbers are the previous balance, the statement date, each payment's date and amount, and the card's monthly rate. The rule is that interest accrues daily at the monthly rate × 12 ÷ 360. A short spreadsheet then reproduces the charge to the centavo.

Where does BPI publish its method?

Three BPI pages carry everything this calculator uses. Rates change, so open them before relying on any figure here:

• Credit Card Fees and Charges lists the monthly finance charge rate per card, the cash advance fee, and the minimum amount due formula. When we read it, it was marked "Updated as of July 2026".
• Sample Interest Calculations works through a retail balance, a cash advance and an installment with real numbers.
• The BPI Credit Card Terms and Conditions, section on finance charges, states the daily method in words.

The terms say finance charges arise when you pay less than the Total Amount Due by the Payment Due Date, and that they run "from the day after the Statement Date until the outstanding balance and applicable interest are fully paid." Purchases made in the current cycle are excluded. For cash advances, interest runs from the transaction posting date instead, with no grace period.

Rates on BPI's page when we checked

BPI defines the nominal rate as the one multiplied by the average daily balance, and the effective rate as average monthly interest divided by the average principal balance; for cash advances the effective figure also counts the Php 200 fee. The effective rate is a disclosure for comparing cards. Your statement charge is built from the nominal rate, so that is the figure the calculator needs.

How do you reproduce BPI's own example?

BPI's sample for a regular card assumes a Php 20,000 balance on a 1 January statement, a due date of 21 January, Php 850 paid on the due date, and a next statement on 1 February. The steps:

1. Daily rate: 3% × 12 = 36% a year; 36% ÷ 360 = 0.001 per day.
2. Before the payment: 2 January to 20 January is 19 days. Php 20,000 × 0.001 × 19 = Php 380.00.
3. After the payment: 21 January to 1 February is 12 days. (Php 20,000 − 850) × 0.001 × 12 = Php 229.80.
4. Finance charge on the February statement: 380.00 + 229.80 = Php 609.80.

For BPI Free+ the same balance gives a daily rate of 2.5% × 12 ÷ 360 = 0.000833, and BPI's page shows Php 316.54 + Php 191.42 = Php 507.96. Note that BPI rounds the daily factor to 0.000833 in that example; carry the full fraction in a spreadsheet and you get 316.67 and 191.50, a few centavos higher. If your own reproduction misses by a small amount, rounding of the daily factor is the first suspect.

Building the calculator in a spreadsheet

A daily ledger is the most faithful version because it handles any number of payments. Set up a sheet with the inputs at the top:

• B1 statement date (e.g. 1/1/2027)
• B2 next statement date (2/1/2027)
• B3 balance carried from the statement (20000)
• B4 monthly finance charge rate (3%)

Then a day-by-day table starting in row 7:

The finance charge is =ROUND(SUM(D7:D37),2). With the example, a Php 850 payment typed on 21 January gives Php 609.80.

If you prefer a single cell, split the cycle into segments between payments and sum balance × days × daily rate, which is what BPI's step-by-step does. For one payment: =ROUND((B3*(P-B1-1) + (B3-PayAmt)*(B2-P+1)) * B4*12/360, 2), where P is the payment date. The day counting matters: BPI counts 2–20 January as 19 days and 21 January–1 February as 12, so the payment day itself already carries the lower balance.

Where do the payment dates come from? The Statement of Account lists each payment with its posting date. If you keep several months of statements as PDFs, a converter such as QuickBankConvert can turn them into rows with date, description and signed amount, and you paste the payment lines into column B instead of retyping them. Check the converted totals against the printed Total Amount Due before trusting them.

BPI credit card cash advance calculator

Cash advances follow a different clock. Interest starts on the posting date, and it is charged on the advance plus the Php 200 fee. BPI's example: Php 20,000 posted on 2 January, statement on 1 February.

• Principal for interest: 20,000 + 200 = Php 20,200
• Days: 2 January to 1 February = 31
• Interest: 20,200 × 0.001 × 31 = Php 626.20
• First-month cost including the fee: 626.20 + 200 = Php 826.20

In a sheet: =ROUND((Amount+200) * Rate*12/360 * (NextStatement-PostDate+1), 2). Each separate withdrawal carries its own Php 200 fee, so three Php 5,000 advances cost Php 600 in fees where one Php 15,000 advance costs Php 200. That is why BPI notes that the effective cash advance rate varies with the amount and the number of transactions in a cycle. For the general mechanics of card cash advances outside the Philippines, see our guide to credit card cash advance interest.

What cap does the Bangko Sentral set?

BSP Circular No. 1165, dated January 2023, limits interest or finance charges on credit card transactions to an annual rate of 36%, caps the monthly add-on rate on credit card installment loans at 1%, and allows no charge on cash advances beyond a processing fee of at most Php 200 per transaction. It also says the BSP reviews these ceilings every six months, so look for later circulars before quoting the cap. BPI's 3% a month equals 36% a year, the same ceiling.

Minimum amount due, and why paying it keeps interest high

BPI's fees page gives the formula. If the total outstanding balance is Php 850 or less, you pay it all. Otherwise BPI takes 3.57% of the balance after removing new retail purchases, new cash advances and adjustments posted that month; if the result is Php 850 or less, the minimum is Php 850, and any past-due amount is added in full. As a formula:

=IF(TOB<=850, TOB, MAX(850, 0.0357*(TOB-NewItems)) + PastDue)

BPI's own 12-month sample, paying only the minimum and the posted interest on a Php 20,000 purchase, still shows Php 10,650 of principal after a year and Php 5,242.24 of interest. The terms also list how a payment is applied: installment amortizations first, then finance charges, membership and cash advance fees, then older balances before new ones.

Checking a charge on your own statement

1. Note the statement date, previous balance and finance charge printed on the Statement of Account.
2. Copy each payment's posting date and amount into column B.
3. Confirm your card's monthly rate on BPI's fees page.
4. Compare the sheet's total with the printed charge. A difference of centavos is rounding; a larger gap usually means a payment posted on a different date than you assumed, or a cash advance in the balance that started accruing on its own date.
5. If the gap remains, call BPI or raise it through its official channels with your sheet in hand.

For the US-style APR method and how it differs, read how to calculate credit card interest or the credit card interest calculator in Excel.

Related guides

• Credit card statement to Excel
• Credit card cash advance interest
• How to calculate credit card interest