Guidelines for filling Form 15CA Bulk Upload

File Based (Bulk) Upload of Form 15CA 
 

Facility for upload of multiple Form 15CA records in single file is available to registered TANs at www.tin-nsdl.com . 

Pre-requisites for bulk upload of Form 15CA records: 

Register your TAN online at TIN website and create your TAN registration account.

Prepare the file as per the prescribed file format. Click here to download the file format.

Validate the file with File Validation Utility (FVU version 1.0) to ensure format level 
correctness of the file.

Login to your TAN registration account

           Upload the successfully FVU validated file. On successful validation file name with        
      extension .fvu will be created.

Tally Shortcut Keys : Special Function Key Combination

Friends,

Special Function Key Combination

Windows	Functionality	Availability
ALT + F1	To close a company To view detailed report To explode a line into its details	At all the menu screen At almost all report screen At almost all screens in TALLY
ALT+ F2	To change the system period	At almost all screens in TALLY
ALT + F3	To select the company info menu To create/alter/shut a Company	At Gateway of Tally screen
ALT + F4	To select the Purchase Order Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F5	To select the Sales Order Voucher Type To view monthly and quarterly report	At Accounting / Inventory Voucher creation and alteration screen At almost all report screens in TALLY
ALT + F6	To select the Rejection Out Voucher Type To change the Sales Order Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F7	To select the Stock Journal Voucher Type To accept all the Audit lists	At Accounting / Inventory Voucher creation and alteration screen At TallyAudit Listing screen
ALT+ F8	To select the Delivery Note Voucher Type To view the Columnar report	At Accounting / Inventory Voucher creation and alteration screen At Ledger Voucher screen
ALT + F9	To select the Receipt Note Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F10	To select the Physical Stock Voucher Type	At Accounting / Inventory Voucher creation and alteration screen
ALT + F12	To filter the information based on monetary value	At almost all report screens
CTRL + ALT + F12	Advanced Config	At Gateway of Tally

 

Key Combination used for navigation

 

Windows	Functionality	Availability
PgUp	Display previous voucher during voucher entry/alter	At voucher entry and alteration screens
PgDn	Display next voucher during voucher entry/alter	At voucher entry and alteration screens
ENTER	To accept anything you type into a field. To accept a voucher or master To get a report with further details of an item in a report.	You have to use this key at most areas in TALLY At the receivables report – press Enter at a pending bill to get transactions relating to this bill (e.g., original sale bill, receipts and payments against this bill, etc)
ESC	To remove what you typed into a field To come out of a screen To indicate you do not want to accept a voucher or master.	At almost all screens in TALLY.
SHIFT + ENTER	Collapse next level details	At Voucher Register screen and Trial Balance report
SHIFT + ENTER	To explode a line into its details	In almost all Reports: At a Group/Stock Group/Cost Category/Godown/Stock Category – displays Sub Groups and Ledgers/Stock Items/Cost Centres/Secondary Godowns/Secondary Stock Categories At a Voucher – displays its entries and narration At a Stock Item- displays its godowns and batch details At Voucher Register screen – displays the next level details At Trial Balance report - displays the next level details
CTRL + ENTER	To alter a master while making an entry or viewing a report	At voucher entry and alteration screens At all reports

VAT RETURN Ver.1.2.2 -- uploading errors

Friends,


FILING VAT RETURN Ver.1.2.2?. How to handle uploading errors


It is the time for e-filing your VAT Return. My staff prepared Form no 231 using Excel-2007 and validated the file creating the .rem file. However when they tried to upload the file it did not upload but threw a message like:

FROM ERRORS REPORT
Sr No.	Line No.	Box No.	Error Description
1	0	0	Error In Start Routine Unable to recognize OLE stream

I tried many variations to get it uploaded but nothing succeeded. I visited many website to get a solution for this but instead of getting a solution I found many visitors were asking the facing the same problem and no answer was available. Eventually I visited the departmental site to find out the solution. On the Home Tab of the site Mahavat.gov.in, I came across the following:-

Instruction sheets for eServices

Know everything about e- Enrollment and e-Returns

(F) Probable Queries

Q.-Whether I can use MS office 2007 for preparing electronic templates?.

Ans : No. You have to use MS office 2003 version.

What a pity. Many of us have shifted to Office-2010, but the site does not support the contents of even MS office 2007. Many of us have already discarded MS Office 2003. What is the solution?
1) Either keep two hard discs with dual booting. One for booting with Office-2003 and another for booting with advanced MS Office-2007.( I did it and got even more problems than solutions) 

OR

2) Try the following procedure:

a. Prepare Form 231 using MS Excel- 2007 and while saving, save it as “Save as Excel 97-2003 workbook” which is compatible with Excel 97-2003.

b. Validate and create the .Rem file. Now if you try to upload this file you will get the above error message. Instead try this:

c. Open the Rem file. Before opening the file the program will display the following message:
“The file you are trying to open (name of the rem file, say “abcd-rem.xls”) is in different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?”

d. Say yes and open the file.

e. Immediately after opening it and without doing anything to it save it as “Save as Excel 97-2003 workbook” which is compatible with Excel 97-2003. This will remove the advanced features of Excel-2007 which are not compatible with Excel 97-2003

f. Now try uploading it. I hope it will now upload properly without any error message.

Gratuity entitlement - Who is entitled for gratuity ?

Friends,

All employees except an apprentice are entitled to gratuity. Once it was held that for a temporary casual labourer, in the absence of any discontinuance of service under Section 2(A) of Payment of Gratuity Act, 1972, the authorities could not deny gratuity, the Madurai Bench of Madras High Court has ruled.

This Court, while defining as to who was an employee under Section 2(e) of the Act in Arunachalam S. vs M.D. Southern Structurals reported in 2001 2 LLJ 1457 had held that all employees were entitled to gratuity except an apprentice.This ruling was held by Mr Justice K. Chandru, who heard a writ petition from Pioneer Spinners, Paramakudi Taluk, Ramanathapuram District, challenging an order passed by the Regional Labour Commissioner (Central) (R-1) Chennai-6, confirming order dated February 28, 2007 of R-2 (Assistant Labour Commissioner (Central), Madurai-2. The employee P. Sulochana (R-3) claimed before the controlling authority, the difference in gratuity of Rs 15,485.34. Her claim was that the period from July 17, 1977 to August 8, 1980 was not taken into account. The petitioner contended that during the period, she was working as a casual labourer and as a temporary daily rated worker. According to petitioner, Sulochana was a trainee not covered by the term employee under Section 2(e) of the Act. The controlling authority rejected both the contentions and directed petitioner-management to pay the sum claimed by Suluchana within 30 days. The petitioner filed an appeal under Sec 7(7) stating that since Sulochana was only a casual labourer or badli worker, the service could not be a continuous one. The controlling authority rejected the contention.

The Judge ruled that the appellate authority found that no material was produced to show that R-3 was engaged as an apprentice. In the absence of any such evidence, even assuming that the workman was only a casual labourer, he was not excluded from provisions of the Act. The term employee defined did not make any distinction between temporary worker and permanent worker. What was excluded was only an apprentice. Hence, the writ petition stood dismissed. The controlling authority was directed to pay the amount to her.