Friday, March 19, 2010
INVENTORY VOUCHER
Purchase order :
It is the use for purchasing in the order way. In this case two things:
1. Order number (Filling order number)
2. Due date
Sales order:
It is the use for sales in the order way. In this case two things:
1. Order number (Filling order number)
2. Due date
Receipt note voucher:
In this case you given order for goods and these goods receipt by challan, than use these voucher. In this case two things remember:
1. Tracking number (tracking number is challan
Number)
2. Order number (that time to select order number)
Delivery note voucher:
In this case you take a order for goods and these goods deliver by challan, than use these voucher. In this case two things remember:
1. Tracking number (tracking number is challan
Number)
2. Order number (that time to select order number)
Rejection out:
In this case you receipt an challan (receipt note) and you return some goods (defective) than you make rejection out voucher. In this case one thing remember
1. Tracking number (these time to select tracking number not make a number)
Rejection in:
In this case you deliver an challan (Delivery note) and return some goods (defective) than we make rejection in voucher. In this case one thing remember
1. Tracking number (these time to select tracking number not make a number)
Stock journal voucher:
This voucher use for inter godown transfer that means transfer to one godown to another godown.
Physical stock voucher:
This voucher use for physical stock verification.
Friday, March 5, 2010
PAYROLL
Tally Payroll is integrated with Accounting to give the user the benefits of simplified Payroll processing and accounting.
Tally Payroll enables users to set up and implement salary structures, ranging from simple to complex, as per the organization’s requirements. You can also align and automate payroll processes and directly integrate them with main stream accounting applications. Payroll data can be viewed as part of the existing and configurable cost centre reports for business analysis.
Tally Payroll also supports configurable formats for pay slip printing; flexible salary/wage, attendance, leave and overtime registers; gratuity and expat report
To enable Payroll in Tally
Go to Gateway of Tally > F11: Features> Accounting Features
• Set Maintain Payroll to Yes
• You can set More than ONE Payroll / Cost Category to Yes if you wish to process payroll for multi group of Employees.
Four Easy Steps to Generate a Pay slip
The new enhanced Payroll in Tally requires minimal effort for accurate processing. Setting up Pay Heads, Employee Group, Employees, Salary Details and Attendance/Production Type is now a simple process with Tally’s four easy steps to generate a payslip.
Step 1
Create Pay Heads
The components of structured salary are created under Pay Head
Create the salary structure components in pay head. The Pay head creation in tally is very user friendly. Tally allows creating any complex type of pay head.
Step 2
Create Employee Masters
Create an Employee master. Enter the requisite Employee Details & Employee group by grouping employees under the function they perform; their department or designation.
Step 3
Create Salary Details
Create the applicable Salary Details for both Employee Groups as well as Individual Employees with earnings, deductions and basis of computation.
Step 4
Process Payroll and Generate the Payslip
Pass a Payroll voucher to enter all Earnings and Deductions in payroll transactions that are paid along with the Salary Payslip for all employees
Generate the Payslip that provides employee as well as attendance details, itemizes each component of the employee’s earnings and deductions, and displays the net amount paid to him for a given pay period. It also provides information to the employee as to how the net amount was arrived at.
Tax deducted at Source
TDS Process
1. Deductee (Seller) provides Services and Bill to the Deductor (Buyer).
2. Deductor makes the payment after deducting TDS.
3. Deductor remits the TDS amount into Bank (Treasury).
4. Bank (Treasury) remit the amount to the Government Account.
5. Deductor Issues Form 16A to Deductee for the TDS amount deducted.
6. Deductor Files the e-TDS to NSDL.
7. NSDL uploads the e-TDS information to Income Tax Department.
8. Deductee Files the Return with Form 16A to Income tax Department.
Issue of TDS Certificate
TDS certificate is a proof that deductor has deducted the tax and paid the same to the government. This proof is essential to the deductee to claim the credit of tax in his Income Tax returns.
U/s 203 of Income Tax Act, any person deducting the tax as per the provisions of:
• Section 192 (Salary) shall furnish a certificate of Deduction of tax in Form 16 or Form 16AA within one month from the close of Financial year in which such deduction was made.
Example: For the Financial Year 2007-2008, the TDS certificate must be issued on or before 30th April, 2008
• Section 193, 194, 194A, 194B, 194BB, 194C, 194D, 194E, 194EE, 194F, 194G, 194-I, 194J, 194K, 194LA, 195, 196A, 196B, 196C and 196D shall furnish a certificate of Deduction of tax in Form 16A with one month from the end of the month during which the credit has been given or the payment has been made, as the case may be.
• In case of a deductee to whom more than one TDS certificate was issued for the deductions made during the year, may on request from such deductee, a consolidated certificate in Form 16A may be issued within a period of one month from the close of such financial year.
Filing of e-TDS Returns
e-TDS Returns
The Income Tax department has now notified ‘Electronic Filing of Returns of Tax Deducted at Source Scheme, 2003’. It is applicable to all deductors furnishing their TDS return in electronic form. As per this scheme,
• It is mandatory for corporate deductors to furnish their TDS returns in electronic form (e-TDS return) with effect from June 1, 2003.
• For government deductors it is mandatory to furnish their TDS returns in electronic form (e-TDS return) from financial year 2004-2005 onwards.
• Deductors (other than government and corporates’ ) may file TDS return in electronic or physical form.
Deductors furnishing TDS returns in electronic form (e-TDS) have to furnish Form 27A. Form 27A is a control chart to be furnished in physical form along with CD/ Floppy containing the e-TDS returns. Form No 27A is required to be furnished separately for each TDS return.
Form 27A is a summary of e-TDS returns which contains control totals of ‘Amount paid‘ and ‘Income tax deducted at source’. The control totals mentioned on Form 27A should match with the corresponding control totals in e-TDS returns.
Returns and Timelines
The following Returns are required to be filed under TDS:
Financial Year Form No. Particulars Periodicity
2008-09 Form 26 Annual return of deduction of tax in respect of payments other than salary Annual
Form 27 Annual return of deduction of tax in respect of payments other than salary made to Non-residents Annual
Form 27A Physical control charts containing control totals mentioned in TDS returns furnished electronically. Form 27A in physical form to be submitted along with e-TDS annual return forms. With each e-TDS returns Form 26 and/ or Form 27. With each e-TDS returns Form 26 and/ or Form 27.
2008-09 Form 26Q Quarterly return of deduction of tax in respect of payments other than salary Quarterly
Form 27Q
Quarterly return of deduction of tax in respect of payments other than salary made to Non-residents. Quarterly
Form 27A Physical control charts containing control totals mentioned in TDS returns furnished electronically. Form 27A in physical form to be submitted along with e-TDS quarterly return forms With each e-TDS returns Form 26Q and/or Form 27Q.
Changes in Finance Act 2009
As per Finance Act, for the Financial Year 2009-10 surcharge or Cess is not applicable for TDS with effective from 1st April, 2009. For tax deduction only the specified TDS rates are considered.
Changes in the Surcharge and Cess are applicable as follows.
Nature of payment Whether surcharge is applicable whether education cess @ 2% and secondary and higher education cess @ 1% is applicable
Salary to a resident or non resident No Yes
Payment other than salary to a resident No No
Payment other than salary to a non-resident not being foreign company No Yes
Payment other than salary to a foreign company (payment or credit subject to TDS does not exceed Rs.1 Crore) No Yes
Payment other than salary to a foreign company (payment or credit subject to TDS exceeds Rs.1 Crore) Yes @ 2.5% of TDS Yes
TDS in Tally.ERP 9
TDS (Tax Deducted at Source) in Tally.ERP 9 provides an easy-to-use and flexible interface. It helps you to handle intricate cases and calculate the tax payable to the Income Tax Department.
Tally.ERP 9 calculates the tax of all parties/ suppliers where TDS deduction is mandatory. It calculates the TDS automatically and prints Form16A certificates, Forms 26Q, 27Q, 26, 27 and 27A (Cover Note) for Quarterly/ Annual Returns as per statutory requirement.
It allows the user to view and print various TDS reports, Challans and TDS Outstanding statements.
Features of TDS in Tally.ERP 9
The TDS functionality in Tally.ERP 9 supports the following features:
1. Simple and user-friendly.
2. Quick and easy to set up and use.
3. Accounting for tax payment of bills.
4. Flexibility for assisted calculation of TDS.
5. Complete tracking of each transaction from deduction to payment.
6. Challan management and printing for prompt and accurate filing of tax.
7. The Auto allocation feature prevents error-prone data entry and helps track the transactions faster.
8. Form 16A management:
9. Can be printed for a transaction
10. Can be printed for a period
11. Can be printed yearly
9. Allows multi-party printing.
10. Exporting of data in NSDL compliant TDS file format.
11. Electronic format (e-TDS return) with Form 26Q, 27Q, 26 and Form 27 and which will be validated by the utility, provided by the government.
12. Generates Form 16A, TDS Challan, TDS Computation and TDS Payable reports.
Friday, October 23, 2009
tally Key Combination Used for Navigation
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/Godowns /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 |
tally Special Function Key Combination
Special Function Key Combination
| Windows | Functionality | Availability |
| ALT + F1 | To close a company To view detailed report To explode a line into its details To select Inventory vouchers to alter | At all menu screens At almost all report screens At almost all screens in TALLY At the Inventory/ Payroll voucher creation or alteration screen. |
| ALT + F2 | To change the 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 screens |
| ALT + F5 | To select the Sales Order Voucher Type To view monthly and quarterly report | At Accounting / Inventory Voucher creation and alteration screens 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 screens |
| ALT + F7 | To select the Stock Journal Voucher Type To accept all the Audit lists | At Accounting / Inventory Voucher creation and alteration screens At Tally Audit Listing screen |
| ALT + F8 | To select the Delivery Note Voucher Type To view the Columnar report | At Accounting / Inventory Voucher creation and alteration screens At Ledger Voucher screen |
| ALT + F9 | To select the Receipt Note Voucher Type | At Accounting / Inventory Voucher creation and alteration screens |
| ALT + F10 | To select the Physical Stock Voucher Type | At Accounting / Inventory Voucher creation and alteration screens |
| ALT + F12 | To filter the information based on monetary value | At almost all report screens |
| Ctrl + F1 | To select payroll vouchers for alteration | At the Accounting/Inventory Voucher creation or alteration screen |
| CTRL + ALT + F12 | Advanced Configuration | At Gateway of Tally |
tally Special Key Combination
Special Key Combination
| Windows | Functionality | Availability |
| ALT + 2 | To Duplicate a voucher | At List of Vouchers – creates a voucher similar to the one where you positioned the cursor and used this key combination |
| ALT + A | To Add a voucher
To Alter the column in columnar report | At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination. Alters the column in all the reports which can be viewed in columnar format |
| ALT + C | To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)
To access Auto Value Calculator in the amount field during voucher entry | At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.
At all voucher entry screens in the Amount field |
| ALT + D | To delete a voucher To delete a master To delete a column in any columnar report (if it has not been already assigned a different function, as explained above) | At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual. All the reports screen which can be viewed in columnar format |
| ALT + E | To export the report in ASCII, Excel, HTML OR XML format | At all reports screens in TALLY |
| ALT + I | To insert a voucher
To toggle between Item and Accounting invoice | At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination. At creation of sales and purchase invoice |
| ALT + L | To select the Language Configuration | At almost all screens in TALLY |
| ALT + K | To select the Keyboard Configuration | At almost all screens in TALLY |
| ALT + O | To upload the report at your website | At all reports screens in TALLY |
| ALT + G | To select language for Tally Interface | At almost all screens of TALLY |
| ALT + M | To Email the report | At all reports screens in TALLY |
| ALT + N | To view the report in automatic columns | At all the reports where columns can be added |
| ALT + P | To print the report | At all reports screens in TALLY |
| ALT + R | To remove a line in a report | At all reports screens in TALLY |
| ALT + S | To bring back a line you removed using ALT + R | At all reports screens in TALLY |
| ALT + U | To retrieve the last line which is deleted using Alt + R | At all reports screens in Tally |
| ALT+ V | From Invoice screen to bring Stock Journal screen | At Invoice screen > Quantity Field > Press Alt + V to select the Stock Journal. |
| ALT + X | To cancel a voucher in Day Book/List of Vouchers | At all voucher screens in TALLY |
| ALT + R | To Register Tally | At almost all screens in TALLY. |
| CTRL + A | To accept a form – wherever you use this key combination, that screen or report gets accepted as it is | At almost all screens in TALLY, except where a specific detail has to be given before accepting |
| CTRL + B | To select the Budget | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen |
| CTRL + ALT + B | To check the Company Statutory details | At all the menu screens |
| CTRL + C | To select the Cost Centre
To select the Cost Category | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen |
| CTRL+ E | To select the Currencies | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen |
| CTRL + G | To select the Group | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen |
| CTRL + H | To view the Support Centre | At Almost all screens in Tally |
| CTRL + I | To select the Stock Items | At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen |
| Ctrl + Alt + I | To import statutory masters | At all menu screens |
| CTRL + K | To Login as Remote Tally.NET User | At Almost all screens in Tally |
| CTRL + L | To select the Ledger
To mark a Voucher as Optional | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At the creation and alteration of Vouchers |
| CTRL + O | To select the Godowns | At Stock Group/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen |
| CTRL + Q | To abandon a form – wherever you use this key combination, it quits that screen without making any changes to it. | At almost all screens in TALLY. |
| CTRL + R | To repeat narration in the same voucher type | At creation/alteration of voucher screen |
| CTRL + Alt + R | Rewrite data for a Company | From Gateway of Tally screen |
| CTRL + S | Allows you to alter Stock Item master | At Stock Voucher Report and Godown Voucher Report |
| CTRL + U | To select the Units | At Stock Groups/ Stock Categories/ Stock Items/ Reorder Levels/ Godowns/ Voucher Types / Units of Measure ( Inventory Info) creation/alteration screen |
| CTRL + V | To select the Voucher Types
To toggle between Invoice and Voucher | At Groups/Ledgers/Cost Centres/ Budgets/Scenarios/Voucher Types/ Currencies (Accounts Info) creation and alteration screen At creation of Sales/Purchase Voucher screen |
tally Function Key Combination
Function Key Combination
| Windows | Functionality | Availability |
| F1 | To select a company | At all masters menu screen |
| F1 | To select the Accounts Button | At the Accounting Voucher creation and alteration screen |
| F1 (ALT+F1) | To select the Inventory To view the detailed or condensed report | At the Inventory/Payroll Voucher creation and alteration screen In almost all the Reports |
| F1 (CTRL + F1) | To select Payroll Vouchers to alter | At the Accounting/Inventory voucher creation or alteration screen. |
| F2 | To change the current date To select company inventory features | At almost all screens in TALLY At the F11: Features screen |
| F3 | To select the company To select Company Statutory & Taxation features | At almost all screens in TALLY At F11: Features screen |
| F4 | To select the Contra voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F5 | To select the Payment voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F6 | To select the Receipt voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F7 | To select the Journal voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F8 | To select the Sales voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F8 (CTRL+F8) | To select the Credit Note voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F9 | To select the Purchase voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F9 (CTRL+F9) | To select the Debit Note voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F10 | To select the Reversing Journal voucher | At Accounting / Inventory Voucher creation and alteration screen |
| F10 (Ctrl + F10) | To select the Memorandum voucher | At Accounting / Inventory / Payroll Voucher creation and alteration screen |
| F11 | To select the Functions and Features screen | At almost all screens in TALLY |
| F12 | To select the Configure screen | At almost all screens in TALLY |