Tuesday, 28 August 2012

Lesson 39-Auto Bank Reconciliation

,

Auto Bank Reconciliation in Tally.ERP9 Release 3.61 onwards
For the benefit of business entities and users, Tally.ERP 9 has provided the facility of selecting the formats which include configurations and output file type for printing the cheques. Currently the formats of many banks with supporting file types - Excel, CSVand MT940 are made available. Depending on the formats pre-filled in the ledger master of the bank selected in payment/contra voucher and the output file types supported for it, the cheques can be printed. In Tally.ERP 9, Bank Reconciliation capability is enhanced to view, import the e-Bank Statements and to Auto Reconcile the transactions. For Auto Bank Reconciliation (importing Bank Statement), valid Tally.NET Subscription and Internet Connectivity are required for performing auto reconciliation.
To view, import and auto reconcile the e-banking transactions:
Go to Gateway of Tally > Banking > Bank Reconciliation > select the Bank > Bank Reconciliation Statement appears

For banks enabled with the feature of auto reconciliation in ledger master, the buttons:
·         B: Bank Statement and R: Reconcile Unlinked appear on the right side button bar.
·         D: Delete Unlinked button appears on the button bar above Info Panel.
Note:  The facility to Import and View Bank Statements will get enabled only for banks enabled with auto reconciliation feature in bank ledger creation / alteration mode.

Bank Statement

Bank Statement button with the facility to view and import is provided to meet the customers requirement. There could be cases where the user just want to view it and not import the statement directly or wants to view it before it is imported, mainly to confirm that it’s the same file that has to be imported.

Reconcile Unlinked

Once the transactions are imported and reconciled, if there are any entries appearing under the section Amount not reflected in Company Booksthe Reconcile Unlinked button needs to be used to reconcile it.

Delete Unlinked

Delete Unlinked button is provided to delete the unlinked vouchers.

View Bank Statement

Tally.ERP 9 makes it possible for the user to view the Excel, MT940 or .CSV files in a readable format, with an option of choosing to import or not to.
Click on B: Bank Statement button or press Alt+Bkey.
On pressing the button, the Bank Statement File screen displays the Directory which was specified as the Location of Bank Statements in F12: Configuration > Banking Configuration. Select the required file format in File Type field based on the format of bank statement being imported.
In File Name filed, a list of Excel fileswill get displayed. To view the Bank Statement which would be imported, click the button I: With View or press Alt+I.

Press F12: Configure. The option Show Imported Bank Statement will be displayed and set to Yesby default. Using this option, the bank statement which is already imported can be selected again for import. The files will be listed in alphabetical order with details of file type and import status (showing whether it is already imported or not).
The Bank Statement appears as shown:

·         Users can either import the statement using Import button or Quitthe Bank Statement screen by pressing Escape key or click on Ctrl+Q: Quit button (where the user is not intending to import the file).

Import Bank Statement

In the Bank Statement screen which is previewed press I: Import button. Users must ensure that the bank statements being imported haven’t been edited or altered in any way. If any changes are made, the error message - Not a valid format will be displayed while importing the statement.
During import, the Import progress bar gets displayed followed by the Success message with count ofTotal Entries in Bank Statement, transactions Reconciled and Additional Bank Entries.

The Bank Reconciliation Statement with Imported Bank Statement details appears as shown:

The Reconciliation found at the bottom of the screen shows:
o        Balance as per Company Books
o        Amounts not reflected in Bank
o        Amount not reflected in Company Books
o        Balance as per Bank
The Balance as per Company Books reflects the balance as on the last date (in the example, it is 30th April).
The Amounts not reflected in Bank are the debit and credit sums of all those vouchers, whose Bank Date is either BLANK, or LATER than 30-Apr (i.e. these vouchers have not yet been reflected in the bank statement).
The Amount not reflected in Company Books are entries which are present in the bank statement but are not recorded in company's books.
The Balance as per Bank is the net effect of the Book Balance offset by the amounts not reflected in the Bank – which must be equal to the balance in the bank statement.
Note: Some discrepancies may persist due to entries made in the bank statement, which may not have been entered in the books of accounts.

Auto Reconciliation of e-Banking Transactions

After Importing the file, the bank dates will get filled in BankDates field automatically in BankReconciliation screen.
However, there may be transactions which have been executed at the bank’s end (example, bank charges, interest credit etc.) but not yet reflected in the books of accounts. Such transactions will appear under the Amount Not Reflected in Company Books in BRS statement with the required details.

User can either Reconcile Unlinkedtransactions to existing transactionsor create a new voucher (to create vouchers click on C: Create Vouchers button or press Alt+C key) using this information or delete them.
Note: It is suggested to save the Bank Reconciliation before reconciling the Unlinked Transactions to avoid mistakes.
1. Reconcile Unlinked
In this example, there is a withdrawal of 2,500 on 23-4-2012 which is not reconciled. To reconcile the transaction select the transaction displayed under Amount Not Reflected in Company Books and click on R: Reconcile Unlinked button or press Alt+R.

Application will display the transaction(s) matching the Transaction amount for selection. Select the appropriate transaction using spacebar and press Enter. The Status will be displayed as Reconciled Successfully.
2. Create a New Voucher
If there are any transaction which is not reflected in books of accounts, click on C: Create Voucher button or press Alt+C key to navigate to VoucherCreation screen.

On recording the transaction against the Amount Not Reflected in Company Books, the details displayed will be removed from the Amount Not Reflected in Company Books section indicating that the corresponding entry is found in the books of accounts.
3. Error on re-importing the Excel/csv file
While selecting the bank statement for importing, the statement which is already imported will also appear. To hide the imported statement, click S: Hide Imported button. On using this button only the statement which is not yet imported gets displayed. The Hide Imported is a toggle button which can also be used to Show Importedstatements.

In cases where the user has already imported an Excel/csv fileand tries to re-import it by mistake, an error message will be displayed indicating that Bank Details are reflected in your books of accounts.

4. View Difference in Bank Balance
To view difference in Bank Balance click on F12: Configureand the option Show Difference in Bank Balance to Yes.

The difference in Bank Balance (difference in Balance as per Bankand Balance as per Imported Bank Statement) will be shown in Bank Reconciliation Statement. In the Bank Reconciliation screen, the Balance as per Imported Bank Statement refers to the balance displayed on importing the bank statement for reconciliation.


You can see the Balance as per Books & Balance as per Bank is same.












Thursday, 23 August 2012

Lesson-38 Recycle Bin for Tally All Version

,
Now Computer is necessary for everyone like school, colleges, students, industries, shops etc. Everyone use computer or laptops & its typical error to create a bug/error or a virus in computer, because of this we lost our important files & sometimes by mistake we delete our important files, but many many thanks to Mr. Bill Gate for recycle bin option in Computer/Windows, where we found our delete files and restore them. 
Before some days i was attend a Tally.ERP9 seminar & know about another improved feature of Tally.ERP9, its recycle bin for Tally (7.2, 8.1, 9 & ERP9). It works like computer recycle bin, if you delete a voucher by mistake or its necessary to delete a voucher and after sometime you want to restore the voucher, then recycle bin option is works for maintain & restore your deleted voucher. But this time we thanks to Sweta Softwares, who invent this amazing feature. This is a free utility & you can download this from Click here
How to install this feature:
For Tally ERP 9 users. Open your Tally Installation folder, there is a file named Tally.ini. Open this file and find User TDS=Yes paste following codes after this line.


User TDL=Yes
tdl=c:\tally\rbin9-erp.tcp( address where you have placed this file)


For Tally 9 users
User TDL=Yes
tdl=c:\tally\rbin9v.tcp( address where you have placed this file)


For Tally 7.2 users
User TDL=Yes
tdl=c:\tally\rbin.tcp( address where you have placed this file)
Save the file and start Tally. You would see extra option of Recycle Bin.(shown in the picture )

After follow these steps a option will appear on Gateway of tally screen:


After this, when you delete any voucher in Tally; it is still available in the Recycle bin and you can restore it back; if required.or you can delete the same from recycle bin also by using Alt+D from the recycle bin also. Anytime, if you want to restore then go to recycle bin, open the voucher & press enter when it say to restore. Your voucher is shown in your accounts book again. This is free utility from Sweta Softwares

Tuesday, 21 August 2012

Lesson-37 How to Copy a ledger

,

Tally.ERP9 is the one of the best ERP Accounting software in the World. It improve its features day by day, every release has a new feature according to Indian Accounting Standards. Why I m telling about Indian Accounting Standards, because Tally.ERP9 is very successful software in India. I was post lots of tutorial on Tally.ERP9, but this time I talk with you about a great feature of Tally.ERP9, Today we know about a amazing feature of Tally.ERP9, a unique option in Tally is copy a ledger group, inventory, voucher type from a company to another company (with full details & configuration). However, A accountant maintain lots of companies in Tally.ERP9, some companies are group with each other, some are subsidiaries companies & some are holding companies. Some accounts (debtors, creditors, loans, banks, expenses, income etc.) are same in lots of companies. For Example, I maintain two company in Tally.ERP9.

1st  is ABC Limited & 2nd is XYZ Limited, & a party Goga International is dealing with both companies in same manner (it means Goga International Sales items from both companies, therefore Goga international is shows Creditor in both companies). 1stwe create a ledger in ABC Limited named Goga International (see below picture).


Above image is show how to create a sundry creditor with advance entries, XYZ Limited has the same ledger with same configuration. So what you can do? You exit from ABC Limited, select XYZ Limited & then you go account info, ledger & create. Its too lengthy & time wasting option.

When you create above creditor in ABC Limited you must open XYZ Limited in your gateway of tally sidebar. (See below image).



After create ledger (Goga International), exit from ledger creation & select alter-> Goga International, Press F3 (This option shows you change the Company) select XYZ Limited & Press Ctrl + A or select yes when say to accept the ledger creation, exit Tally.ERP9 now (its not necessary to exit the program, but for safety reason make sure to exit), reopen the program & see both companies have same ledger with same configuration.  (See below image).





Monday, 20 August 2012

Calculate Interest U/s 234B & 234C

,
Due Date to file income tax return for person other than companies and non Audit case is 31.08.2012 .Many person have not paid their Advance tax in time .By the way advance tax for person other than companies is payable if tax due in a financial year is more than 10000 before the TDS amount .Such person have to pay advance tax in three instalments.
  1. 30% of tax assessed =15 September of previous year
  2. 60% of tax assessed=15 December of previous year 
  3. 100% of tax assessed = 31March of previous year 
Here  tax Assessed means = Tax due minus Tax deducted at sources.


Further for capital gain amount person can pay prospective instalments only.so If you have not paid your tax pro-rata bases in advance as shown above you have to pay interest u/s 234C .Further If you have not paid your full taxes by 31.03.2012 for Ay 2012-13 then you have pay interest under section 234B on balance amount of tax .




 Interest U/s 234A is payable only if you miss the Income tax due date for Ay 2012-13 ie 31.08.2012.And I hope you are not interest in calculation under this section .However the given calculator will calculate interest under this section also where ever applicable.
Interest Rate: Interest Rate is 1% per month or part there of in all the above cases


Saturday, 18 August 2012

PAN - A DETAIL GUIDE

,
Generally Lots of peoples don't know about PAN (Permanent Account Number) & its necessity. Some general questions are: What is pan, its necessity, why its required in bank transaction, why its compulsory, how to verify pan, who is the pan authorities, who is liable to take PAN etc. So, here is some FAQ (Frequently asked questions) on PAN is posted here.
1. What Is PAN?
Permanent Account Number (PAN) is a ten-digit alphanumeric number, issued in the form of a laminated card, by the Income Tax Department, to any “person” who applies for it or to whom the department allots the number without an application. PAN enables the department to link all transactions of the “person” with the department. These transactions include tax payments, TDS/TCS credits, returns of income/wealth/gift/FBT, specified transactions, correspondence, and so on. PAN, thus, acts as an identifier for the “person” with the tax department. PAN was introduced to facilitates linking of various documents, including payment of taxes, assessment, tax demand, tax arrears etc. relating to an assessee, to facilitate easy retrieval of information and to facilitate matching of information relating to investment, raising of loans and other business activities of taxpayers collected through various sources, both internal as well as external, for detecting and combating tax evasion and widening of tax base.
A typical PAN is AXJPG4358D.
First three characters i.e. “AXJ” in the above PAN are alphabetic series running from AAA to ZZZ Fourth character of PAN i.e. “P” in the above PAN represents the status of the PAN holder. “P” stands for Individual (Personal), “F” stands for Firm, “C” stands for Company, “H” stands for HUF (Hindu Undivided Family), “A” stands for AOP (Association of Persons), “T” stands for TRUST etc. Fifth character i.e. “G” in the above PAN represents first character of the PAN holder’s last name/surname (G from Surname-Sumit Kumar Gogawat). Next four characters i.e. “4358” in the above PAN are sequential number running from 0001 to 9999. Last character i.e. “D” in the above PAN is an alphabetic check digit.

2. Why Is It Necessary To Have PAN?
It is mandatory to quote PAN on return of income, all correspondence with any income tax authority. From 1 January 2005 it will be mandatory to quote PAN on Challans for any payments due to Income Tax Department. It is also compulsory to quote PAN in all documents pertaining to the following financial transactions:-
(a) Saleor purchase of any immovable property valued at five lakhs rupees or more;
(b) sale or purchase of a motor vehicle or vehicle, [the sale or purchase of a motor vehicle or vehicle does not include two wheeled vehicles, inclusive of any detachable side-car having an extra wheel, attached to the motor vehicle;]
(c) a time deposit, exceeding fifty thousand rupees, with a banking company ;
(d) a deposit, exceeding fifty thousand rupees, in any account with Post Office Savings Bank;
(e) a contract of a value exceeding one lakhs rupees for sale or purchase of securities;
(f) Opening a bank account;
(g) Making an application for installation of a telephone connection (including a cellular telephone connection);
(h) Payment to hotels and restaurants against their bills for an amount exceeding twenty-five thousand rupees at any one time;
(i) payment in cash for purchase of bank drafts or pay orders or banker’s cheques for an amount aggregating fifty thousand rupees or more during any one day;
(j) deposit in cash aggregating fifty thousand rupees or more with a bank during any one day;
(k) payment in cash in connection with travel to any foreign country of an amount exceeding twenty-five thousand rupees at any one time.
3. How does Income Tax Department ensure that PAN is quoted on transactions mentioned above?
It is statutory responsibility of a person receiving document relating to economic or financial transactions notified by the CBDT to ensure that PAN has been duly quoted in the document.
4. Is it compulsory to quote PAN on return of income?
Yes, it is compulsory to quote PAN on return of income. A penalty of Rs.10,000/- is livable in case of any default.
5. How will these authorities verify PAN?
A facility for verifying PAN is available on the website of the Income Tax department. Kindly click
6. Who must have a PAN?
i. All existing assesses or taxpayers or persons who are required to furnish a return of income, even on behalf of others, must obtain PAN.
ii. Any person carrying on any business or profession whose total sales, turnover or gross receipts are or is likely to exceed five lakh rupees in any previous year;
iii. Any person, who intends to enter into financial transaction where quoting PAN is mandatory, must also obtain PAN.
iv. The Assessing Officer may allot PAN to any person either on his own or on a specific request from such person.
7. Can a person obtain or use more than one PAN?
Obtaining or possessing more than one PAN is against the law, for which penalty of Rs.10,000/- may be imposed {Kindly refer Section 139A (5) (c) read with Rule 114B for more details} {Section139A (6)} {Kindly refer Section 272B}
8. Where to apply for PAN?
In order to improve PAN related services, the Income Tax department has authorized UTI Investor Services Ltd (UTIISL) to set up and manage IT PAN Service Centers in all cities or towns where there is an Income Tax office and National Securities Depository Limited (NSDL) to dispense PAN services from TIN Facilitation Centers. For convenience of PAN applicants in big cities, UTIISL has set up more than one IT PAN Service Center and likewise there are more than one TIN Facilitation Centers.
9. How to apply for a PAN? Can an application for PAN be made on plain paper?
PAN application should be made only on Form 49A. A PAN application (Form 49A) can be downloaded from the website of Income photocopied (on A4 size 70 GSM paper) or obtained from any other source. The form is also available at IT PAN Service centers and TIN Facilitation centers.
10. Can an application for PAN be made in Form 49A obtained from anywhere?
Yes, PAN application may be made on Form 49A obtained from any source other than IT PAN Service Centers or TIN Facilitation Centers. For instance, a PAN application may be made on form downloaded from the website of Income Tax department or UTIISL or NSDL; or on form printed by local printers or a photocopy of downloaded or printed form.
11. Can an application for PAN be made through Internet?
Yes, application for fresh allotment of PAN can be made through Internet. Further, requests for changes or correction in PAN data or request for reprint of PAN card (for an existing PAN) may also be made through Internet. Online application can be made either through the portal of NSDL (https://tin.tin.nsdl.com/pan/index.html ) or portal of UTITSL (http://www.utitsl.co.in/utitsl/uti/newapp/new-pan-application.jsp ). The charges for applying for PAN online are the same i.e. Rs. 94 (including service tax) for Indian communication address and Rs.744 (including service tax) for foreign communication address, i.e. there are no additional charges. Payment of application fee can be made through credit/debit card or net-banking.
Once the application and payment is accepted, the applicant is required to send the supporting documents through courier/post to NSDL/UTITSL.
12. Is there any TATKAL facility for allotment of PAN?
No.
13. How to find an IT PAN Service Center or TIN Facilitation Center?
Location of IT PAN Service Centers or TIN Facilitation Centers in any city may be obtained from local Income Tax Office or any office of UTI/UTIISL or NSDL in that city or from websites of the Income Tax department (www.incometaxindia.gov.in or UTIISL(www.utiisl.co.in) or NSDL (http://tin.nsdl.com)
14. What services are provided by these IT PANService Centersor TIN Facilitation Centers?
{Section 139A (7) read with Section 272B }
Tax department or UTIISL or NSDL (www.incometaxindia.gov.in,www.utiisl.co.in ortin-nsdl.com) or printed by local printers or slip. After obtaining PAN from the Income Tax department, UTIISL or NSDL as the case may be, will print the PAN card and deliver it to the applicant.
15. What if I submit incomplete Form 49A?
IT PAN Service Centersor TIN Facilitation Centersshall not receive any incomplete and deficient PAN application. However, these case may be.
16. What documents and information have to be submitted along with the application for Form 49A?
a. Individual applicants will have to affix one recent, coloured photograph (Stamp Size: 3.5 cms x 2.5 cms) on Form 49A;
b. Any one document listed in Rule 114 must be supplied as proof of 'Identity' and 'Address'; and
c. Designation and code of the concerned Assessing Officer of Income Tax department will have to be mentioned in Form 49A.
17. Which documents will serve as proof of 'Identity' in case of Individual applicants, including minors and HUF applicants?
Copy of school leaving certificate or matriculation certificate or degree of a recognized educational institution or depository account or credit card or bank account or water bill or ration card or property tax assessment order or passport or voter identity card or driving license or certificate of identity signed by a MP or an MLA or a Municipal Councilor or a Gazetted Officer.
In case the PAN applicant is a minor, any of above documents of any of the parents or guardian of such minor shall serve as proof of Identity; In case PAN application is made on behalf of a HUF, any of above documents in respect of Karta of the HUF will serve as proof of Identity.
18. What is proof of 'Address' for Individual applicants, including minors and HUF applicants?
Copy of electricity bill or telephone bill or depository account or credit card or bank account or ration card or employer certificate or passport or voter identity card or property tax assessment order or driving license or rent receipt or certificate of address signed by a MP/ MLA/Municipal Councilor / a Gazetted Officer; In case the PAN applicant is a minor, any of above documents of any of the parents or guardian of such minor shall serve as proof of Address; In case PAN application is made on behalf of a HUF, any of above documents in respect of Karta of the HUF will serve as proof of Address.
19. What documents will serve as proof of Identity and Address for other applicants?
IT PAN Service Centers or TIN Facilitation Centers will supply PAN application forms (Form 49A) and forms for Request For New PAN Card Or/ And Changes In PAN Data', assist the applicant in filling up the form, collect filled form and issue acknowledgement centers will assist applicants to correctly fill up form 49A or 'Request For New PAN Card Or/ And Changes In PAN Data', as the Copy of Certificate of Registration issued by the Registrar of Companies or Copy of Certificate of Registration issued by the Registrar of Firms or Copy of Partnership Deed or Copy of Trust deed or Copy of Certificate of Registration Number issued by
Charity Commissioner or Copy of Agreement or Copy of Certificate of Registration Number issued by Charity Commissioner or Registrar of Co-operative Society or any other Competent Authority or any other document originating from any Central or State Government Department establishing Identity and Address of such person.
20. How to find 'Assessing Officer code'?
Assessing Officer code may be obtained from Income Tax Office where you submit your return of income. Applicants who have never filed return of income may find out Assessing Officer code with the help of IT PAN Service Center or TIN Facilitation Centeror jurisdictional Income Tax Office.
21. Is a photograph compulsory for making an application for PAN?
A photograph is compulsory only in case of 'Individual' applicants.
22. What is the procedure for applicants who cannot sign?
Officer, under official seal and stamp.
23. Is father's name compulsory for female (including married/divorced/widow) applicants?
Only father's name is required to be filled in the PAN application (Form 49A). Female applicants, irrespective of marital status, should write only father's name in the PAN application
24. Is it compulsory to mention telephone numbers on Form 49A?
Telephone number is not compulsory, but if provided it may help in faster communication.
25. Who can apply on behalf of non-resident, minor, lunatic, idiot, and court of wards?
Section 160 of IT Act, 1961 provides that a non-resident, a minor, lunatic, idiot, and court of wards and such other persons may be represented through a Representative Assessee. In such cases, application for PAN will be made by the Representative Assessee.
26. I had applied to the department but I do not know my PAN?
Please contact the Aaykar Sampark Kendra (ASK) at 0124-2438000 (or 95124-2438000 from NCR) or visit
In such cases, Left Hand Thumb impression of the applicant should be affixed on Form 49A or 'Request For New PAN Card Or/ And Changes In PAN Data' at the place meant for signatures and got attested by a Magistrate or a Notary Public or a Gazetted Officer the www.incometaxindia.gov.inand go to 'know your PAN'.
You can also visit NSDL Website & track your Newly applied or Changed PAN / TAN Status to enter your Acknowledgement no on the site. In individual case, you can mention your acknowledgement no. (method also applicable on companies & others) & In companies cases you may enter Name of Company & Date of incorporation. Results shows your pan card details, If a new pan card (In new pan card applied) allotted to you, then PAN NO. (e. g. AAAAA1234A) is showing on the screen. Take printout the screen for future reference, or if it is delivered by department then it must shows courier or track no. for find the status.
27. Are there any charges to be paid at IT PANService Centersor TIN Facilitation Centers?
UTIISL and NSDL have been authorized to collect Rs.85 + Service Tax as applicable, per PAN application and this includes cost of a tamper proof PAN card. This amount will have to be paid in cash at IT PAN Service Center or the TIN Facilitation Center.
28. Do you need to apply for a PAN when you move or transfer from one city to another?
Permanent Account Number (PAN), as the name suggests, is a permanent number and does not change during lifetime of PAN holder. Changing the address or city, though, may change the Assessing Officer. Such changes must, therefore, be intimated to nearest IT PAN Service Center or TIN Facilitation Center for required correction in PAN databases of the Income Tax department. These requests will have to be made in a form for 'Request For New PAN Card Or/ And Changes In PAN Data'
29. I had applied to UTITSL/ NSDL a month ago but I have not received my PAN card and I have to file my return of income.
Please write a email to pan@incometaxindia.gov.in
30. Will the existing PAN cards issued by the Department remain valid?
All PAN allotted and PAN card issued by the Department will remain valid. All persons who have been allotted a PAN need not apply again.
31. Income Tax Department has issued me a PAN card; can I obtain a new tamper proof PAN card?
PAN card surrendered. The payment of Rs.60 + Service Tax as applicable, will also have to be made.
32. I had applied for PAN and received PAN number but have not received the PAN Card?
Center quoting the PAN allotted to you.
33. How will the new PAN card be delivered to me?
The UTIISL or NSDL, as the case may be, will ensure delivery of new PAN card at the address indicated by you in the PAN For obtaining the tamper proof PAN card an application will have to be made in the form for 'Request For New PAN Card Or/ And Changes In PAN Data' to IT PAN Service Center or TIN Facilitation Center, in which existing PAN will have to be indicated and old Apply in the form for 'Request For New PAN Card Or/ And Changes In PAN Data' at any IT PAN Service Center or TIN Facilitation application form or form for 'Request For New PAN Card Or/ And Changes In PAN Data'
Please contact Aaykar Sampark Kendra (0124-2438000 or 95124-2438000 from NCR)  or www.incometaxindia.gov.in or send an
34. I want to pay taxes today but I do not have a PAN?
It takes about 15 days to get a new PAN allotted. However, PAN can be obtained in around 5 days if application is made through Internet and processing fee paid through credit card. It is advisable to initiate action for obtaining PAN will in time.
35. Who should be contacted for inquiries regarding PAN applications?
All such inquiries should be addressed to:

For UTIISL
The Vice President
IT PAN Processing Centre,
UTI Investor Services Ltd
Plot No. 3, Sector - 11
CBD_ Belapur
Navi Mumbai-400 614
e-mail.- utiislgsd@
mail.utiisl.co.in
Tel No. 022-27561690
Fax No. 022-27561706

For NSDL
The Vice President
Income Tax PAN Services Unit,
NSDL
4th Floor, Trade World, A Wing
Kamala Mills Compound,
S. B. Marg, Lower Parel,
Mumbai-400 013
e-mail.- tininfo@nsdl.co.in
Tel No. 022-2499 4650
Fax No. 022-2495 0664

Coupon number or Acknowledgement number, as the case may be, should be mentioned in all communications.

Friday, 17 August 2012

Number to Words in Excel - Another Method

,
Recently one of my visitor ask me about my previous post of convert number to excel in word is not working in his excel sheet. I am again check my link sheet for working properly or not. Its working but viewers did not add it in Excel Add-in & have problem to convert number into words (or Rupees INR). So now i put another method to convert number into words. Perhaps its working better than my previous method & easy to install in Excel File. Tally Knowledge team is convert this function script for specially our indian viewers. But this script working with any currency & in any country code. For indian users, by using this script you can convert number to indian rupees also. Let we do it with some very easy steps.

Download the script file from click Here!
Open your excel sheet & press ALT+F11, it start your excel visual editor.



Click on Insert Menu & Module.

A new window will appear in your visual editor, paste this script file code in this new window. Press Ctrl+S to save your file.

Now put numerical value in any cell of your ms excel worksheet (suppose you enter amount in cell no. A2, in another cell enter this formula =spellnumber(A2) you must give reference of that particular cell which you want to show in words. See below image.

Its all done. This function is work for only single particular sheet, if you want to work this method on your all sheet then you must re-install your msoffice application & when you open your 1st Excel sheet put this method again & save as your excel sheet as macro workbook sheet, after do these steps this function is work with your all excel worksheets.

Wednesday, 15 August 2012

Lesson-36 How to Create POS Invoice

,
POS (Point of Sales) Invoice is generally used for make cash or credit sales. Customer pay the bill by cash or credit card & POS invoice show the details of Credit Card, cash, discount, or bank details in same invoice. Basically POS invoice are used in Malls & Mega Stores, when customer purchase a large quantity of goods they want discount on those goods, POS (Point of Sales) invoice show the gross amount before and after the discount. POS invoice also taxable and non taxable, so let we know how to make POS Invoice. 

To make POS invoice we must create a new voucher type, Gateway of Tally->Voucher Type->Create (see below image)

POS Invoice Configuration

The payments against POS Invoices are generally made by way of Cash, Gift Vouchers, Cheques/Drafts or through Credit/Debit Cards.  To account for receipt of payments from customers by different modes, set the required option to Yes and select the required ledger in the respective fields.

Default Ledger for POS Invoice

1.      Set Yes in Gift Vouchers field to enable the option during POS Invoice Entry and select the Gift Vouchers under Ledger Namefield (if does not exist, create using Alt+C. The Gift Vouchers ledger should be created under Sundry Debtors group).
2.      Set Yes in Credit/Debit Card Payment field to enable the option during POS Invoice Entry and select the required Bank Ledger  under Ledger Name field
3.      Set Yes in Cheque/DDfield to enable the option during POS Invoice Entry and select the required Bank Ledger under Ledger Name field
4.      Set Yes in Cashfield to enable the option during POS Invoice Entry and select the required Cash Account under Ledger Name field
Note:
 For Gift Vouchers, the ledgers should be created under Sundry Debtors Group.
 For Credit/Debit Cards, the respective Bank Ledger should be created under Bank account or Bank OD/OCC.
 For Payment through Cheque/DD, the respective Bank Ledger should be created under the group Bank Accounts or Bank OD/OCC.
 For Cash, the Ledger should be under group Cash-in-Hand.

To create POS Voucher Type without Voucher Class
To enable POS Invoicing in Tally.ERP 9. create a POS Invoice Voucher Type. You may also alter an existing Sales voucher type for this feature to be enabled.
Go to Gateway of Tally > Accounts Info > Voucher Type > Create

POS Invoice Class

Name: Enter the name of the Voucher type (for e.g.: POS Invoice).
Type of Voucher: Select the type of Voucher as Salesfrom the predefined Voucher Types.
Abbreviation: By default, Sales text will appear in the abbreviation field.  However, you can enter the abbreviation as per your requirements
Used for POS Invoicing?: On selecting the Sales voucher type from the list, Used for POS Invoicing? Option appears, set this option to Yes
Print Message 1 and Print Message 2: These two additional fields for messages appear on enabling the above POS feature, which can used for custom messages viz., *Thank You* or *Visit Again* and so on as per your requirements. The same will be printed at the bottom of the POS invoice.
Default Print Title: You can specify the printing title of the POS Invoice and the same will be printed in the Invoice.
Note:
1. Once Use POS for Invoicingoption is set to Yes in voucher type, you will not be entitled to set this field to No, if you have passed any POS Invoice.
2. To know about advanced configurations refer detailed information on Use Advance Configuration usage.

To create POS Voucher Type without Voucher Class

To enter a simple transaction using a POS Invoice with single payment mode:
Go to Gateway of Tally > Accounting Vouchers > Select F8: Sales
1.      Select the POS Invoice as the Voucher type from the list of Voucher types.
2.      Select the Godown, Sales Ledger and VAT/Tax Class as applicable.
3.      Select the Item using the Bar code reader to scan the bar code or select the Item from the list.
4.      The Rates of the Item is picked up from Set Standard Rates screen (Stock Item Creation screen) or from the Price List screen.
5.      Select VAT/Tax Ledger from the list of Ledger Accounts.
6.      By default for the first time, the POS Invoice screen will appear in Single Mode Payment.
The screen will appear as below with the Cash and Cash tendered fields:

POS Invoice Entry

7.      Accept to save.
Configurations in POS Invoice:

POS Invoice Options

1.      Allow Party Details in POS Invoice: By setting this option to Yes, you are able to select the Customer’s Ledger.  If you do not want to create a separate Ledger for the Buyer and still would like to print the customer’s name in the Invoice print, select Not Applicable from the List of Ledger Accounts and specify the Buyer’s name and address details in the Buyer’s details.
2.      Skip Qty field during POS Invoicing (faster entry):  By default, the same will be set to Yesso that while passing the Invoice, the cursor will skip the Quantityfield.  The user may set this option to No, to specify the required number of quantity.
3.      Allow modification of Rate field during POS Invoicing:  The rates are automatically picked as per the Standard ratesdefined in the Stock Item master or from the Price List. However, you can change the rate during entry, by setting this option to Yes.

Creating a POS Invoice with Multi-Mode Payment

To create a POS Invoice with Multi Mode Payment, click on the Multi Mode Pymtbutton in the Button bar, to account for receipt of payments through other modes like Gift vouchers, Credit card/Debit Card  or by cheque/DD etc.
To enter POS Invoice with Multi Mode Payment:
Go to Gateway of Tally > Accounting Vouchers > Select F8: Sales  
1.      Select the POS Invoice as the Voucher type from the list of Voucher types.
2.      Select Multi Mode Pymt option from the Button Bar or press Ctrl+P.
3.      Select the Godown, Sales Ledger and VAT/Tax Class if applicable.
4.      Select the Item using the Bar code reader to scan the bar code or select the Item from the list.
5.      The Rates of the Item is picked up from Set Standard Rates screen (Stock Item master) or from the Price List screen.
6.      Select VAT/Tax Ledger from the list of Ledger Accounts.
7.    Allocate the Bill amount to the relevant modes of payment.

POS Voucher Entry

Select Yes & Save the voucher, also take printout of the voucher for Customer.






Required Help!

Alexa

Dhiti