Skip to main content

HDFC, SBI, Citi, SCB, BoB, ICICI(Any Bank) - Minimum Account Balance(MAB)/Average Monthly Balance(AMB) Calculator(Excel)

# LittleSavings

Some banks like SBI giving an option to check your minimum account balance for a month through online banking.

But few banks like HDFC, this option is not available, where only End of the Day(EOD) balance is printed in balance statement.

Using your EOD balance, anyone can calculate the whether Minimum Account Balance(MAB)/Average Monthly Balance(AMB) has been maintained in the account or not.

Here is, How to Calculate the MAB/AMB for any bank account?:

MAB = [(DAY 1+Day 2.....DAY N) of EOD BALANCE] / [No of Days].

Based on the above formula, the simple calculator has been designed.
Download Excel link for MAB Calculator.

Snippet of Calculator:
To maintain 10,000 min balance, if one has kept 60,000 for 6 days, he can meet MAB/AMB.

littlesavings - how to calculate for HDFC MAB

How to use calculator:

* To calculate your MAB, open the attachment sheet - MAB calculator.
* Enter your EOD balance of an account, you wish to find MAB.
* The Minimum account balance shown on the right side.

Related Posts:
How to save your money from Min Account Balance Penalty