Skip to main content

Posts

Showing posts from 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 N…

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…

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…