How To Calculate MAB in Excel of a Bank Account Statement

[dhiraz]

I wanted to calculate the MAB of My Multiple Bank Accounts. I Maintained a Excel File Where I Created Some Sheets of Every Account

Like This: 👇



I Calculated MAB from Other Tools so I Just Wanted a New Way To Calculated MAB Within Excel Sheet Using Some Formula

I Also Tried To Ask on Stack Overflow but My Account Got Banned Because of Poor Question Quality

So I Asked Here Because Here We Also Have Some Developer Types of People Which Can Help


I Someone Wants To Help 🔗 Use This Google Sheet For Experiment

 

[Tejo]

I wanted to calculate the MAB of My Multiple Bank Accounts. I Maintained a Excel File Where I Created Some Sheets of Every Account

Like This: 👇



I Calculated MAB from Other Tools so I Just Wanted a New Way To Calculated MAB Within Excel Sheet Using Some Formula

I Also Tried To Ask on Stack Overflow but My Account Got Banned Because of Poor Question Quality

So I Asked Here Because Here We Also Have Some Developer Types of People Which Can Help


I Someone Wants To Help 🔗 Use This Google Sheet For Experiment

Do you have any loan ?

Almost credit=debt

 

[dhiraz]

Do you have any loan ?

Almost credit=debt

No! I Don't Have Any Loans

If a Bank Account is 5 Years Old and Has Rs 50,000 in It as on Date, Then It is Obvious That Whatever Transactions Have Taken Place in the Past Days Will Be Equal to That.

 

[sxchzy]

so you basically do sum of 30 cells value which is the overnight closing bal of that acc and divide the same by 30 right

 

[dhiraz]

so you basically do sum of 30 cells value which is the overnight closing bal of that acc and divide the same by 30 right

No! I know a website where I put only dates and the closing balance of a month and the website calculates the mab perfectly

This is the website i am using currently: Taxadda

 

[sxchzy]

but do you have mab requirements for your accs?

 

[dhiraz]

but do you have mab requirements for your accs?

No! I Have HDFC Classic Banking Its Not Necessary To Maintain But I Also Have Some MAB Requirment Account So I Just Wanted To Keep a Record