What is Monthly Average Balance (MAB) in banking system and how can we calculate in M S Excel.

Monthly Average Balance (MAB) confuses many account holders and they wrongly take it as maintenance of a specified amount in their Savings Bank Account all the time.

However, MAB is actually calculated by adding up all end of day balances in an account in a month, and then dividing it by the number of days in that particular month. While calculating MAB, all bank holidays and working days are included too.

Suppose the “Monthly Average Balance” requirement of your bank is ₹ 10,000. It implies that the bank wants the average in your account to be ₹ 10,000. It does not means that you should have ₹ 10,000 balance at the end of every day. It’s your discretion as to how to go about it. You can maintain a balance of ₹ 10,000 every day or ₹ 3,00,000 (₹ 10,000*30) on any one day of the month which have 30 days in it or ₹ 3,10,000 (₹ 10,000*31) on any one day of the month which have 31 days in the month. Ultimately the average needs to come around ₹ 10,000.

So let's calculate it.

First of all we need bank statement as in picture below.

Here we can see Date, Deposit Amount, Withdraw Amount & Balance Amount & we are going to calculate MAB from these data.

• On April 1, the balance in the account is ₹ 35,000.
• On April 8, withdrawal of ₹ 20,000 takes place. EOD balance is ₹ 15,000.
• On April 16, deposit of ₹ 12,000 & withdraw of ₹ 10,000 takes place. EOD balance is ₹ 17,000.
• On April 22, withdraw of ₹ 15,000 takes place. EOD balance is ₹ 2,000.
• On April 27, deposit of ₹ 1,000 takes place. EOD balance is ₹ 3,000.

Summing up the EOD balances as shown in Picture above:

• From April 1 to April 7 (7 Days), sum of EOD balance will be ₹ (35,000*7) = ₹ 245,000.
• From April 8 to April 15 (8 Days), sum of EOD balances will be ₹ (15,000*8) = ₹ 120,000
• From April 16 to April 21 (6 Days), sum of EOD balances will be ₹ (17,000*6) = ₹ 102,000
• From April 22 to April 26 (5 Days), sum of EOD balances will be ₹ (2,000*5) = ₹ 10,000
• From April 27 to April 30 (4 Days), sum of EOD balances will be ₹ (3,000*4) = ₹ 12,000

Sum of all the EOD closing balances = 489,000

No. of days in April Month = 30 Days

MAB = (Sum of all the EOD closing balances) / (number of days in a month)

So, the Monthly Average Balance will be 489,000/30 i.e. 16,300.

Now if we want to calculate MAB in M S Excel by using formula the stay with me..

First of all we need bank statement  in excel format as in picture below.

now create a new table for MAB calculation by using some formulas shown in picture below.

For above calculation check formula description in below table

For more Information Follow my blog.

Thank You.

Print bank details in Invoice in Tally ERP 9

In today's new modern business era, credit transactions are paid through internet banking.  In order to save the customer time in this process of payment, the company prints its bank information in the invoice.

So let's start "How to Print Bank Details in In Invoice ?"

Step-1

Create a Bank ledger from.

Gateway of Tally ----> Accounts Info.----> Ledger ----> Create.

and mention all information like Account Holder Name, Account No., IFSC, Bank Branch Name as you can see in picture below.

Step-2

Go to Gateway of Tally ----> Accounting Voucher & Press F8 (Sales Voucher)

Press Alt+P or Click on Print option Top Left on screen.

Step-3

Here you can see a window as given in picture below.

Here press F12 (Configure) .

Step-4

In this configure window do Yes to the option Print Bank Details and select Your Bank Name from the List & Press Ctrl+A (Accept).

As you can see in this invoice your Bank details has been Printed in invoice..

Thank You.

For more Tally Related blog please Click Here.

Apply LOGO in Tally ERP9

 As we all know that the logo is a  printed symbol or design that a company or an organization uses as its special sign to aid and promote their products.

Here we are going to know that how to apply LOGO in Invoice or Reports by using Tally ERP 9.

Steps for printing Logo in Tally...

1. From Gateway of Tally press F11 (Features) & Then press F1 (Accounting Features).

2. Do YES for the option "Enable Company Logo" as you can see in the Picture below.

 

After that

3. Here we can see some Instructions about your logo file.

now we have to resize the LOGO Image if the logo file does not full fill all requirements.

for resize any image read my blog 

How to resize a Logo file for Tally ERP 9...????

4. We have to type or copy location from Logo file and paste it in to the "Location of Logo" option.

"But many students faces the problem that how to copy location of a file"

    Don't worry here I am telling you the ans. of  "HOW"

👉 Open Microsoft Office Word.

👉 Press Ctrl+K (Hyperlink)

👉 Select your Logo file.

👉 Select this location and copy it.

 and paste it using Ctrl+Alt+V in "Location of Logo" as given in Step no. 4

And press ENTER.

That's it.. 

Thanks for your Attention.

---------------------------------------------------------------------------------------------------------

For more information like this-

👉 Follow me on Instagram

👉 Subscribe my YouTube channel.

Important Links

1. Subscribe my     YouTube Channel 

2. Follow me on     Instagram

3. Join me on         Facebook

----------------***********------------------

Blog Links

1. Introduction of computer.

2. ORIGIN OF COMPUTERS

3. What is Accounting Ledger and which ledger goes in to which Group ???

4. How to Filter a Report in Microsoft Excel.

5. How to resize a Logo file for Tally ERP 9...????

6. Apply LOGO in Tally ERP9

7. Print bank details in Invoice in Tally ERP 9

8. What is Monthly Average Balance (MAB) in banking system and how can we calculate in M S Excel.

9. How to Upload files in Google Drive in Mobile Device.

10. Convert an Amount from Numerics to Word (Indian Rupees) in Excel 2010

11. Excel Convert Data English to Hindi

How to resize a Logo file for Tally ERP 9...????

If you want to print Logo on your Invoice in Tally ERP 9 then Tally shows you a recommendation for Logo file as you can see in picture below.

Recommended size is 96 pixel in width by 80 pixels in height.

So here I am telling about resizing your logo size as per requirement of tally.

It is recommended to keep a copy of your original Logo file.

After that...

1. Right click on logo

2. Move your cursor to the "open with" option       and then select "Microsoft Office" option

3. Now click on "EDIT PICTURE" appear in            tool bar just below Menu bar.

4. Click on "Resize" option in task pen on the       right of window.

5. In the next window click on "custom width x height" type 96 and 80 as shown in picture below and click on OK button.

That's it.. 

NOTE:- THIS IS RECOMMENDED SIZE NOT COMPULSORY SIZE.

THANKS FOR READING MY BLOG.

For more information-

👉 Follow me on Instagram

👉 Subscribe my YouTube channel.

How to Filter a Report in Microsoft Excel.

The basic Excel filter allows you to view specific rows in an Excel spreadsheet, while hiding the other rows. Filter is one of the most powerful feature in M S EXCEL for DATA ANALYSIS. There are many types of filters in Excel like Text Filter, Number Filter, Date Filter.

Here I am going to show you few types of Filter.

First of all you have to create a TABLE in which you want to apply filter and click anywhere in table.

after creating table select option filter from DATA Tab.

or You can select option from HOME Tab also.

after applying filter you can see arrows inside the heading cells.

Now your file is ready for filter... 

Filter of Single Data:-

If you want to filter a single data from a column that is called Single data filter. for this you have to click on ARROW inside heading from you want data.

As you can see in picture below filter option will be appear like this.

In this you can enter required Data. in search box.

and then press enter.

As you can see in picture below the result will be showing like this and the ARROW sign converted in to FILTER.

You can clear filter from-

1. DATA tab.       2. HOME tab        3. Filter Sign.