Showing posts with label Banking. Show all posts
Showing posts with label Banking. Show all posts

Thursday, February 17, 2011

How to export data’s directly in excel format from tally 7.2 and Tally 8

Tally 9 allow you to export data’s directly in excel format. But you can’t do it in tally 7.2 and tally 8.
Here is a small tutorial for you exporting tally data’s from version 7.2 in excel file.
Consider exporting daybook.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.
tally export screen
Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.
tally export ready screen
Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,
csv file
Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

How to change the data directory in Tally after installation?

Tally data directory is located in tally program folder by default. But you wish to change the data in another location, due to some reasons. Here is a handy guide how to do it.
Before doing it you should know about tally data. in tally program folder there is a subfolder called “data” in this subfolder there is one or multiple folders serially numbered each folder denotes a company data. You can see multiple files are stored if you opened this serially numbered folder.
Drive:Tally » Data » 10000» data files
From tally 9 version data folders are created with  five digit like “00001″ where as tally 7.2  has only four digits,starts from “0001″.

There are two methods of changing data location.

Method 1

Consider the case, you have installed tally in drive c:,by default tally data folder located in C: TallyData. And now you wish to change the data directory in D:data.
It is highly recommended to keep a back-up of all existing companies before changing the data directory.
Now go to C:Tally, copy the folder “Data”  and paste in D:
Go back to C:Tally Directory, find out Tally.ini tally inifile and open it. Locate the following wordings.
;; Specify location of Data files
Data = C:TallyData

Change it as below
;; Specify location of Data files
Data = D:Data

Save Tally.ini file & close it, open Tally program press F1 from the gateway of Tally. You will lead to select company screen where you can check the data directory is D:Data.
directory location
Now tally will automatically save all the data’s to D drive. Now you can delete the directory “Data” from program folder from which we copied to D drive.

Method 2

Consider the same as above; changing directory from c:tallydata to D:Data
Open tally, Go to company info menu; if your tally auto loading of company is disabled program will directly go to company info menu. if auto loading is enabled Gateway of tally will open. In this case Press Alt+F3 to go to company info menu.
Take a Backup of data to some where on your computer for example : E:
Now go to tally program folder and open “Tally.ini” and locate the following wordings.
;; Specify location of Data files
Data = C:TallyData
Change it as below
;; Specify location of Data files
Data = D:Data
save and close Tally.ini file. Open the program, Company info menu will open, Select Restore press enter , restoration window will open like below.
restore
the destination will be D:Data  and source will be the location where we have stored back up file, if the source  is different, type it manually, now select company from the list press enter and accept. The data is  stored in D:data. Check whether the data location is correct by Pressing F1. Now your tally data will start storing in D:Data.

Change the data directory in tally erp9 after installation

If you are using Tally ERP9 ,your data folder may be located at C:Tally.ERP9Data . If you need to change the location to D:Data , you can decide the location at F12 configuration.
Gateway of tally » F12 » Configuration » Data Configuration
Tally erp9 data config
After accepting the screen tally will ask you a confirmation for restart for effecting the changes made.
Now you need to  copy the data folder from C:Tally.ERP9 to D:

How To backup and restore tally data


Tally backup and restoration.

Data back up is most important for every accounting software .and it is recommended to keep data’s on an external storage device like CD, USB Drive etc. instead of keeping a single device, storing  data’s on  one or more device will give you more security against damage of storage device. There is one more good way if you are using internet at your work place. Compress the data by using any of the compressing software, like WinZip, winrar etc and send it as an attachment to your own email id, if you are following this, you don’t need a storage device, Gmail is always best to do this. What I recommend is to take back-up on a daily basis. Back up process require a couple of minutes but if you lost data you will have to work days, or weeks to re-enter the lost data.
There are two ways to take tally backup.
Method1
Open tally, go to company info menu, probably you will have to press Alt+F3 in case auto loading of company is enabled. Go to backup & Press enter
Company info»Backup
Back up screen will open
backup screenSelect source, you don’t need to change this because by default this will be your data directory folder. Press enter to allow cursor to come on next field. Now enter destination directory where you wish to store data back up on your computer, let’s store on D:Backup. Press enter you will prompt to select the company from a list on your right side. If you wish to take back up of all the company, select all. Press enter to accept the screen.
Open D:Backup; Make sure there is file starting with TBK Something like “TBK900.001” Copy this file to your external storage device. You are done.
Now Let us restore the data.
Go to    company info » Restore
restore screenIn restoration screen Destination comes first where you want to restore data. This must be your tally data folder. By default the destination directory will be your data directory and you don’t need to change it. Now select source, where you have stored your back up files. This may vary because you might store backup files on an external storage device, so enter the drive name where back up files located. Say I:Backup.Now select companies you want to restore from a list on its right side. Press enter to accept the screen.

Method2

This is the easier method. But not recommended .Just copy the “data” folder from where tally stored data. In most case you can find data folder in tally program folder itself. If you don’t know where the data folder is located. Press F1 from the menu Gateway of Tally and fid out the address.

Monday, February 14, 2011

How To Take service tax credit

Service Tax Credit

The Raja Chelliah Committee which initially recommended the levy of tax on service in India saw such a levy the context of the gradual movement towards unified VAT, covering both services and commodities, and eventually resulting in an indirect taxation regime which was, to the extent possible, revenue neutral. The inputtax credit mechanism with respect to the levy of service tax is a step in that direction, and is expected to benefit the taxpayer and the tax administration by:
  • Ensuring greater levels of tax compliance.
  • Promoting transparency.
  • Reducing cascading effect of taxes.
  • Increasing service sector competitiveness.
  • Minimising disputes in service tax administration.
The Finance Act, 2002 has amended Section 94 of the Finance Act, 1994 to provide for credit of Service Tax paid on input services used in the output services where both the input and output services fall within the same category of taxable services. As per section 94(2)(ee) of the Finance Act, 1994, Central Government has been empowered to make rules for the credit of service tax paid on the services consumed for providing a taxable service in case where the services consumed and service provided fall in the same category of taxable service.
Section 94(2)(eee) of the Finance Act, 1994 inserted with effect from May 14, 2003 empowers Central Government to make rules for the credit of service tax paid on the services consumed or duties paid or deemed to have been paid on goods used for providing taxable service. Presently, credit may only be availed in respect of service tax paid on inputs.
The Service Tax Credit Rules, 2002 have come into force from 16th August, 2002 for availing credit of input Service tax under same category. The date of applicability for availing credit under different categories is from 14th May, 2003. The applicable dates are, thus, as follows:
  • Where input and output services fall under same category input service challan/ bill/invoice issued on or after 16.8.2002;
  • In any other case input service challan/bill/invoice issued on or after 14.5.2003.
The manner of availing credit has been prescribed under the Service Tax Credit Rules 2002 as amended by the Service Tax Credit (Second Amendment) Rules, 2003 vide Notification No. 5/2003-Service Tax dated May 14, 2003 (''Credit Rules'').
In terms of Rule 3 of the Credit Rules an output service provider shall be allowed to take credit of the Service Tax paid on input service in the following manner, namely:-
  1. Where the input service falls in the same category of taxable service as that of output service, Service Tax credit shall be allowed to be taken on such input service for which invoice or bill or challan is issued on or after the sixteenth day of August, 2002.
  2. In any case, Service Tax credit shall be allowed to be taken on such input service for which invoice or bill or challan is issued on or after the fourteenth day of May, 2003.
Provided that the output service provider shall be allowed to take such credit, on or after the day on which he makes payment of the value of input service and the Service Tax paid or payable as indicated in invoice or bill orchallan referred to in sub-rule (1) of rule 5. No credit is available if the output service is exempt from service tax. In the interest of clarity it is imperative to explain the following terms in detail: Output services - 'Output service' means any taxable service rendered by service provider to a customer, client, subscriber, policy holder or any other person. [Rule 2(b) of Credit Rules]. Input services - 'Input service' means any service received and consumed by a service provider in relation to rendering output service. [Rule 2(c) of Credit Rules]. Meaning of 'same category of taxable service' - Two services shall be deemed to be falling in the same category of taxable service, if the input service and the output service fall within the same sub-clause of clause (105) of section 65 of the Finance Act, 1994. (Illustration: The services provided by a photo studio to a customer and by a developing and processing lab to a studio fall in the same category of service i.e. 'photography service') Meaning of 'in relation to' –Service tax paid on input services is eligible for credit only when it is received and consumed in relation to taxable output service. The Supreme Court in Doypack Systems Pvt. Ltd. vs. Union of India [1988 (36) ELT 201 (SC)] held that the expression 'in relation to' is a very broad expression, which pre-supposes another subject matter. These are words of comprehensiveness, which might both have a direct significance as well as an indirect significance depending on the context. The words 'in relation to' are the same as those used in Cenvat Credit Rules in respect of eligibility of inputs for Cenvat credit. This term has been interpreted in broad terms, i.e. as long as there is reasonable nexus (direct or indirect) between input and output services, the credit will be available. However, if input service is unrelated to output services, the credit will not be available. On the other hand, input services like courier services and telephone services may be held to be 'in relation' to taxable output service. Credit of tax on input service will be available only if service tax is payable on output services. If output services are exempt from tax or not taxable at all, credit of input service tax is not available. However, if input service is partly used for taxable service and partly for exempt or non-taxable service, credit of service tax paid on input services is available as per provisions of rules 3(4) and 3(5). [Rule 3(3) of Servicetax Credit rules]. If the input and output service does not fall in same category, it may be than the input service may be used in relation to taxable output service as well as exempt service or service which is not taxable at all. In such case, assessee is required to maintain separate records for input services used in relation to taxable output services. In such case, he can avail full credit of service tax on input services. [Rule 3(4) of the Credit Rules]. In case of common services, assessee may not be able maintain separate records of input services used in relation to taxable service and other services, the assessee will be entitled to credit of service tax upto a maximum of 35% of output services. [Rule 3(5) of Credit Rules. Service tax is payable by 25th of following month [25th of following quarter if assessee is individual, proprietary firm or a partnership firm]. However, the assessee can only avail credit of service tax as available at the end of month/quarter as applicable. [proviso to Rule 4(1) of Servicetax credit Rules]. Thus, even if tax is payable by 25th of following month/quarter, credit available as at end of month/quarter alone can be utilised for payment of service tax of that month/quarter. In terms of Rule 5 of the Credit Rules, credit can be availed based on a bill, an invoice or achallan. Such a document shall contain details regarding:
  1. Name and address of the service provider.
  2. Service tax registration Number.
  3. Serial number.
  4. Date of issue.
  5. Description and value of the input service.
  6. Service tax paid/ payable.
The service provider is required to maintain records reflecting the following details
  1. Serial number and date of document on which credit is availed.
  2. Name and address of the service provider.
  3. Service Tax registration number.
  4. Description of service received.
  5. Value of service received.
  6. Amount of credit availed.
  7. Date of utilisation of credit.
  8. Amount of credit utilised and balance thereof.
Return in the prescribed form (in terms of Rule 5(4) of the Credit Rules)is required to be filed along with Form ST3.
It may be noted that the Finance Act, 1994 does not prescribe a time limit within which service tax credit should be availed and utilised. However,in CCE v. Mysore Lac & Paint Works Ltd. [1991 (52) ELT 590 (T)] it was held that MODVAT credit has to be taken within in a reasonable period. Further the Supreme Court in the case of Government of India v. Citedal Fine Pharmaceuticals [1989 (42) ELT 515 (S.C)] in the context of recoveries under Rule 12 of the Medicinal & Toilet Preparation Rules 1956 observed ''In the absence of any period of limitation it is settled that every authority is to exercise the power within a reasonable period. What would be reasonable period, would depend on the facts of each case''.
Hence credit taken by an assessee, should be within a reasonable time, and such reasonable time within which to avail credit could be one year, in view of the analogous provisions of refund under section 11B of the Central Excise Act, 1944.. In any event, as far as 'utilisation' of such credit is concerned, it can be done at any time.
In brief, the present position regarding the availing of service tax credit is as under:
  • Credit is only available if input service is in relation to output service.
  • If input and output services fall in same category, full credit is available.
  • Credit can only be availed once the service tax on the input service has been paid.
  • No credit is available if the output service is exempt from service tax.
  • No inter sectoral (i.e manufacturing and services and vice-versa) credit is allowed. The position has been clarified vide circular no. 56/5/2003 dated April 25, 2003.
  • If input and output services do not fall in same category, full input service tax credit will be available only if separate records of input services used in relation to output taxable services are maintained.
  • If separate records are not maintained, then credit of input tax will be available subject to ceiling of 35% tax payable on output services. Even here, the input services should have been used in relation to output service.

Tuesday, February 9, 2010

How To get duplicate PAN card

A duplicate PAN Card can be issued under the following conditions
  • Lost/misplaced PAN card by the assessee.
  • The assessee did not receive the PAN card, even after the dispatch of the PAN card by the Department under certificate of posting.
  • Presence of errors in the PAN card issued to the assessee in accordance with incorrect information given by the assessee while filling Form 49A or due to subsequent change of name etc.
If in case the PAN card is lost and also if there is an error in PAN Cards due to incorrect information by the applicant an amount of Rs.10/- will be charged from the applicant for the issue of a laminated duplicate PAN Card.

How to Apply for duplicate PAN card

To apply for Duplicate PAN Card, you need to fill the PAN reissue form which you can get either from the nearest Income Tax office or from any agent or from any CA. You can search in sites like sulekha.com and justdial.com to find such agents. You can not apply for duplicate PAN Card online.
The applicant is required to provide his older PAN Card number along with 2 recent photographs to get a New Pan card along with duplicate PAN card fees.
You will receive your new Pan card within 2-4 weeks at your address mentioned in the form.

Wednesday, February 4, 2009

How To transfer bank accounts


How to Transfer Money Between Bank Accounts


Perhaps you have more than one checking account or you have both a checking and a savings account. You would like to move money from the savings account to the checking account or vice versa, but you are not sure how to accomplish this task. There are a variety of ways to transfer money between bank accounts; just choose the one that works best for your lifestyle.
Instructions
  1. 1
    Visit your local bank branch and arrange for a money transfer in person. Although this is not the fastest way to transfer money, if you are the type of person who enjoys chatting it up with the bank tellers, this is the way to go. Simply approach the teller, provide him or her with identification, and indicate how much money you want moved from one account to the other.
  2. 2
    Call your bank's toll-free customer service line. Many banks allow you to transfer money between accounts over the telephone. Since you are not withdrawing money, it is considered an acceptable transaction to complete over the phone. The customer service representative may ask you a few questions for identification verification before proceeding with your transaction.
  3. 3
    Click on your bank's website and get an online account. Signing up for online banking is relatively simple and you can complete this in a few minutes. Once you have an online login and password, you can see all your accounts in one convenient website screen. Click the "Transfer" hyperlink and choose the account in which to transfer the money. Online banking is safe and secure what with modern SSL-encrypted website technology.
  4. 4
    Go to your bank's nearest automatic teller machine (ATM). Most ATMs have a selection to transfer funds between accounts; carefully read all the options after putting in your debit card and entering your personal identification number to choose the appropriate transaction.