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
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!!!
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.