Average Quarterly Balance (AQB) is the average balance to be maintained in the account over a period of a quarter.
It is the sum of the end of day balance in the account for each day in the quarter, divided by the number of days in the quarter.
Say if your account is subjected to maintain an AQB of Rs. 10,000 /-, that means the
EOD balance x Number of Days
AQB = 10,000 = ————————————————
Number of days in Quarter
Let’s assume the number of days in Quarter are 90 (30days for 3 months),
Also, assume you maintained same EOD balance through out the quarter, thus your AQB becomes
AQB = 10,000 = EOD balance constantly maintained through out the quarter
so, you at least need to maintain a minimum of Rs. 10,000 at any time during the quarter.
Say, withdraw all of your money and left your account in zero balance for 10 days, you can still avoid your AQB charges by maintaining balance that is worth of 10,000 x 10 = 1,00,000 for at least one day within the quarter.
A more detailed calculation example is below:
|Sample statement to illustrate example|
|Sr. No.||Date||Narrarion||Withdrawal||Deposit||Closing balance|
|1||1-Jan-07||Credit interest capilized||50||4,000|
|4||25-Jan-07||Cheque Deposit- MICR clearing||13,000||25,000|
|5||5-Feb-07||Broadway automobile POS 43860000000012||1,000||24,000|
|6||19-Feb-07||Cash Deposit Mumbai||9,000||33,000|
|8||2-Mar-07||Cheque paid-MICR inward clearing||1,500||2,500|
|9||15-Mar-07||Cheque Deposit- MICR clearing||25,000||27,500|
|Sr. No.||Time Period||Calculation||Amount(Rs)|
|1||EOD Balance from 01-Jan-07 to 9-Jan-07||4,000 x 9||36,000|
|2||EOD Balance from 10-Jan-07 to 15-Jan-07||14,000 x 6||84,000|
|3||EOD Balance from 16-Jan-07 to 24-Jan-07||12,000 x 9||1,08,000|
|4||EOD Balance from 25-Jan-07 to 04-Feb-07||25,000 x 11||2,75,000|
|5||EOD Balance from 05-Feb-07 to 18-Feb-07||24,000 x 14||3,36,000|
|6||EOD Balance from 19-Feb-07 to 25-Feb-07||33,000 x 7||2,31,000|
|7||EOD Balance from 26-Feb-07 to 01-Mar-07||4,000 x 4||16,000|
|8||EOD Balance from 02-Mar-07 to 14-Mar-07||2,500 x 13||32,500|
|9||EOD Balance from 15-Mar-07 to 30-Mar-07||27,500 x 16||4,40,000|
|10||EOD Balance on 31-Mar-07||25,500 x 1||25,500|
|Total EOD balances for the quarter Jan-Mar-07||15,84,000|
|Divide by the no. of days in the quarter||90|
|Average Quarterly Balance (AQB)||17,600|
Average Quarterly Balance (AQB) Excel Calculator.