How to convert Amount to Words in Excel

Some time we need to change a numeric amount to words i.e. Rs. 4500 in words Rs. Four Thousand Five Hundred. We do this with a very simple add-in installation to our excel worksheet. This add-in has 3 amazing functions called = INR() (Indian Rupees Initial (Rs.),  REVINR(), and RSWORDS (). The INR() function converts a number to the Indian Style Comma formatted currency as you can see in the snapshot. The commas are placed in the right places separating lakhs and crores. But the result that you get is in the Text Format. So you cannot directly use the result in a formula for calculations. To overcome this issue I have added another function called REVINR().

INR () function convert the whole number include sign of Rs. with the amount. (See following pic).

The REVINR() function simply converts the result obtained from using INR function back to the number format so that you can use it in calculations as demonstrated in following image.

The RSWORDS() function converts any number to currency in the form of words. This can be quite useful if you generate your invoices using Excel and you want the amount to be displayed in words.

How to install this AddIns?

Installing AddIns in Excel is very simple. First you download the AddIn from the link at the bottom of this post and save it on your computer.

Open Microsoft Excel. Click on Tools>Add-Ins. Click on Browse and navigate to wherever you saved the AddIns.xla and then click OK. You have installed the AddIn.

How to use AddIns?

You can use this AddIns by directly entering the functions into a cell like =INR(XX), =REVINR(XX) and =RSWORDS(XX) where XX is the reference of the cell you want to convert.

Another way is to use the Insert Function window which you can open either through the fx button on the toolbar or though the Insert>Function menu. In the category dropdown box choose User defined and you will see the above three functions of AddIns.

Click here to Download this Add ins

Daily Penalty on Late TDS Return

Income Tax Department issue a notice towards Late Penalty of Rs. 200 (daily) will be liable on TDS Returns filing after 15th July 2012. The notice iffective from 1st July 2012, if you file your TDS Return after 15th July 2012 then you must paid Rs. 200 as late fees for one day, or if you are filing two days late then you must pay Rs. 400. TDS Return will not accepted without Late payment fees Challans. This law is circulated under section 234-E of Income Tax Act. 

So file your TDS Return before 15th July 2012 & avoid penalty.

Lesson-35 Configure Multiple Address

The Multi Address feature in Tally.ERP 9 allows you to maintain multiple mailing details for your company and ledgers, i.e.

·  Create multiple addresses for your company and use them in your invoices and reports. For instance:

·  Print the required addresses of your Branches/Locations in your commercial invoices and reports.

· Print Head Office address along with the Branch/Godown/Registered Office address in your Rule 11 Invoice.

· Create a single ledger with multiple addresses along with their statutory taxation details. For instance, purchasing goods from a supplier having multiple locations. This will help in minimizing the creation of same party ledger for different branches in your company.

· Print multiple addresses in Payment / Receipt vouchers. For instance, company is maintaining centralized accounting system and the payment is received in the Branch Office. In this case, the address of Branch office is printed in the receipt voucher and recorded in/sent to Head Office.

Enabling Multi Address

To enable Multi Address in Tally.ERP 9:

·         Go to Gateway of Tally F11: Accounting Features.

·         Under Other Features set Maintain Multiple Mailing Details for Company & Ledgers to Yes.

To add multiple mailing details for your company:

·         Set the option Set/Alter Company Mailing Details to Yes as shown:

·         Press Enter.

·         The Address Type screen appears.

·         Type the name of the Branch/Location (E.g. Branch Office).

·         Press Enter.

Note: Primary under Address Type contains the Mailing Details provided in the Company Creation screen. You may also alter the primary mailing details from this screen.

·         The Mailing Details screen appears.

·         Enter the Mailing Name, Address, PIN Code, etc. in the respective fields provided.

The filled Mailing Details screen appears as shown:

·         Press Enter, the Address Type screen appears.

·         Similarly, type another Address Type name to create the Mailing Details.

·         Press Enter.

·      TheCompany Operations Alteration (F11 Features > Accounting Features) screen appears  as shown:

·         Accept to save the settings.

Use Multiple Addresses for Ledger Accounts

To create multiple addresses for a single ledger:

·         Go to Gateway of Tally > Accounts Info> Ledgers > Create.

·         The Ledger Creation screen appears.

·         Click F12: Configure button or press F12.

·         The Master Configurationscreen appears.

·         Under Ledger Configuration, set the option Use MULTIPLE Addresses to Yes, as shown:

·         Savethe settings.

Note: The option Use Multiple Addresses can also be enabled from Gateway of Tally> F12: Configure> Accts / Inventory Info.

·         Type the name of the Party in the Name field (E.g. Supplier A).

·         Select the groupfrom the list of groups (E.g. Sundry Creditors).

·         Set / Fill the other required fields.

·         Set the option Set/Alter Multiple Mailing Details to Yes.

·         Press Enter.

·         The Address Type screen for the ledger being created appears.

·         Type the name of the Party’s Location (E.g. Supplier A WH-1).

·         Press Enter.

·         The Mailing Details screen appears.

·         Enter the MailingName, Address, State, PIN Code, and the Statutory & Taxation Information in the respective fields provided.

The filled Mailing Detailsscreen appears as shown:

·         Press Enter, the Address Type screen appears.

·         Similarly, type another Address Type name to create the required Mailing Details.

·         Press Enter, the Ledger Creation screen appears.

·         Type the other required details and Save the ledger.

 

Use Multiple Addresses in Voucher / Invoice Entries

To opt for the required address type while passing transactions, follow the steps shown:

Example: Purchase Invoice.

·         Go to Gateway of Tally> Accounting Vouchers > F9(F9:Purchase)

·         The Accounting Voucher Creation screen appears.

·         Select the required Date, type the Supplier Invoice No. and Date.

·         Under Party A/c Name, select the Party (Supplier A) and press Enter.

·         The Supplier Detailsscreen appears, displaying the Primary mailing details.

·         In the Address Type field of Consignee, select the required address type of the Company (E.g. Branch Office) as shown:

·         Press Enter.

·     In the Address type field of Supplier, select the required address type of the Supplier (E.g. SupplierA-WH-1) as shown:

·         Press Enter.

Note: The Consigneedetails appear only when you have enabled the option Allow Separate Buyer and Consignee Names in F12: Configure.

·         The Supplier’s Detailsscreen after selecting the required Address Type appears as shown:

·         Complete the transaction and Save the invoice.

Note: Similarly, you can select the Customer ledger and choose the required Address Type in the Sales Invoice and other required voucher types.

Print Multiple Addresses in Reports

 

You can print the mailing details of the required branches/locations created for your company in all your reports in Tally.ERP 9.

Print Reports

Example: Balance Sheet

·         Go to Gateway of Tally > Display> Balance Sheet > Alt + P.

·         From the Print menu, click T: Titlingor press Alt + T.

·         The Control on Report Title screen appears.

·        Under Additional Information, go to Company Address to Print and select the required Address Types from the list as shown:

·         Press Enter.

·         Set the other required options and press Ctrl + A or Enter to go back to the Print menu.

·         Press Y or Enter to print the report.

·         The report will print the selected Company Address as shown:

Print Multiple Addresses in Vouchers and Invoices

Example: Receipt Voucher

To print the Receipt Voucher with the required address of your company:

·         Select the Receipt Voucher and click on Print button or press Alt + P.

·          The Voucher Printing screen appears, click T: Titling or press Alt + T.

·         The Control on Report Title screen appears

Under Additional Information, go to CompanyAddress to Printand select the required Address Type from the list as shown

·         Press Enter.

·         Set the other required options and press Ctrl + A or Enter to go back to the Print menu.

·         Press Y or Enter to print the report.

·         The voucher will print the selected Company Address as shown:

Note: Similarly, you can print the required address types for other vouchers and invoices.