12 September 2005

Excel Add-in to convert amount in figures to words by Premal

Gentlemen:
AmtInWords.xla is attached to this mail. It is an MS Excel Add-in written by me to convert amount available in figures to words.
Installation
Copy the attached file to the folder where excel stores the add-ins. (To know where excel stores the add-ins, open any workbook, click on Tools - Add-ins - Browse)
Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the path to this Addin - Ok
Usage
You can use the functions AmtInWords and AmtInWordsUS in any worksheet. The syntax is:
=AmtInWords(decimal number/cell reference, [currency code])
=AmtInWordsUS(decimal number/cell reference, [currency code])
Examples follow:
=AmtInWords(10000000)
=AmtInWords(123456.77)
=AmtInWords(C4)
=AmtInWordsUS(B3) ' Shall give the amount in millions (US format)
=AmtInWordsUS(B3,"USD") ' Shall give the amount in millions (US format) and in US currency (Dollars)
=AmtInWords(C4,"GBP") ' Shall give the amount in lakhs and in UK currency (Pounds)
Notes
The system shall NOT give you any warning/error if you use:
=AmtInWords(C4,"USD") ' Amount in lakhs and in US currency (Dollars)
OR
=AmtInWordsUS(C4,"GBP") ' Amount in millions and in UK currency (Pounds)

At present 3 currency codes are supported:
INR (the default ... not required to be given separately)
USD
GBP
Let me know how you find it and/or your suggestions.
Regards
Premal

06 September 2005

Non Refundable Charges for Empanlement by Bank of Rajasthan

Dear Fellow Professionals,

Please go through the attachment note the bold sentence.(Emphasis supplied). A nationalised bank is inviting application for empanelment of concurrent auditors with processing fee alongwith the application form. It is high time we all should protest such actions.

It is a shame on the entire profession. Had it been a refundable Earnest Money Deposit, we could understand. What is the logic of asking for non-refundable processing fee? Are we chartered accountants are begging before this bank or other banks for assignments and all so that they are forced to limit the enquiries? It is utter non-sense. We all should unite and tell the bank that this is not the way to assign an audit to a noble professional who is specially trained and experience for this job. ICAI should take up this matter with the bank authorities. It is just like equating a chartered accountant with a street vendor. The bank should be coming to us for getting the audits done and not the other way round and ask for a processing fee also!!!. Ridiculous!!. STAND UP AND SAY NO!

Suppose, out of around 65000 CA's, at least 2000 all over India apply for the same, the bank will be getting Rs. 40.00 lakhs, which will be sufficient for them to pay the concurrent audit fee for at least 40 branches for one year. What a brilliant idea!!!

Your opinion on this is highly appreciated.

04 September 2005

A POEM OF ACCOUNTS

A POEM OF ACCOUNTS

IN THE JOURNAL PAPER OF MY HEART,
I HAVE WRITTEN A JOURNAL ENTRY

DEBITING MY LOVE & CREDITING MY AFFECTION,
NOW PARTNER , YOU WRITE THE NARRATION.

YOUR BEAUTY IS CAPITAL OF OUR BUSINESS,
AND YOUR EYES ARE STOCK IN TRADE.

NOW LET US ENTER INTO A TRANSACTION,
WITHOUT PROVIDING DEPRECIATION.

YOUR FIRST LOVE , I HAVE ALREADY INDICATED,
ON THE LEDGER FOLIO COLUMN.

ANYWAY OUR REALIZATION ARE BASED ON
DOUBLE ENTRY SYSTEM.

OUR LOVE IS REAL AND TANGIBLE,
WHICH CAN BE REALIZED,
INTEREST ON THE SAME CAN BE CAPITALIZED.

PARTNER YOU ARE LIKE A CONTRA - ENTRY,
YOU ARE ON MY DEBIT SIDE & CREDITSIDE
BOTH AT THE SAME TIME

CAN IT BE POSTED INTO LEDGER ?
THAT YOU DECIDE.

AND SO MY PARTNER , NOW LET US RECTIFY
ALL OUR ERRORS AND TOTAL THE TRIAL BALANCE OF OUR AFFAIRS
AND EMOTIONS

A POEM OF ACCOUNTS

WITHOUT MAINTAING ANY SUSPENSE A/C AND
ANY DIFFERENCE IN THE TRIAL BALANCE

IN THE BALANCE SHEET OF OUR LIFE.
OUR CHILDREN WILL BE ASSET & LIABILITIES
IF THEY ARE BOYS , SHALL WE CALL
THEM SUNDRY DEBTORS ?
IF THEY ARE GIRLS WE CALL THEM
SUNDRY CREDITORS.
BUT IF WE HAVE A BOY & A GIRL,
OUR BALANCE SHEET WILL TALLY AUTOMATICALLY
AND THE AUDITOR WILL CERTIFY LIKE THIS,
THE ACCOUNTS SHOW A TRUE & FAIR VIEW OF LOVELY
BUSINESS CONDUCTED DURING LIFE IS ACCOUNTS.

Empanel as Concurrent Auditors

BANK OF MAHARASHTRA invites online applications from practicing firms of Chartered Accountants, in the prescribed format, who are willing to...