Latest Entries »
Oct 26, 2009
TCS Reports
Oct 25, 2009
Challan Reconciliation for TCS
Printing TCS Challan
Payment Voucher Creation of TCS
Or else you have to debit TCS ledger and credit Bank Account for payment of TCS in payment voucher.
Sales Voucher for TCS
Sales Ledger Creation for TCS
Party Ledger Account for TCS
Is TCS applicable : Set this 'yes' for applicability of TCS.
TCS details screen will appear, enter the following there:
Buyer/Lessee: Select appropriate type from the list given.
Is Lower/No Collection Applicable: Set this as 'yes' if there is any exemption, orelse set it to 'no'.
Section Number : This is set to 206C by default.
TCS Lower Rate(%): Set it as per rate applicable.
Creation of TCS Ledger Account
Name : Enter the name of the ledger account to be opened.For example TCS on Timber Ledger.
Under : Ledger should be created under Duties and Taxes.
Type of Duty/Tax : Select TCS from the list given.
Nature of Good/Contracts/Licence/Lease : Select the nature from the list provided.You can view the details of the TCS rates from Gateway of tally -> Display -> Statutory Info -> TCS Nature of Goods.
Inventory values are affected : Set this as 'No'.
Configuration Set up for TCS
- Tax Assessment Number(TAN) : Enter the 10 digit TAN of the company, allotted by the Income Tax Department.
- Income Tax Circle/Ward : Enter the Tax Circle/Ward under which the company is being assessed.
- Deductor/Collector Type : Select the proper option from the given list.
- Name of the person responsible : Name of the official of the company who is responsible for collection and deposit of TCS, is to be given.
- Designation : The designation of the person whose named is mentioned in the previous field has to be entered.
Tax Collected at Source (TCS)
Oct 24, 2009
Printing Form 16A for TDS
In order to Print Form 16A, go to Gateway of tally -> Display -> Statutory Reports -> TDS Reports -> Print Form 16A. Select the TDS party ledger from the list, specify the details to get Form 16A printout.
TDS Reports
Challan Reconciliation
Oct 23, 2009
Printing TDS Deposit
TDS Challan Printing
TDS Deposit to Government
TDS ledger : Give the particular expense account.
Deductee status : Give here the information that the company is a company or non-company.
After entering the details select the bank account and then accept payment voucher screen and save the entry.
After Deducting TDS, Payment to Party
Expense Booking
Go to Journal Voucher screen(Gateway of Tally -> Accounting Vouchers -> F7), select the expense ledger in the particulars column and enter the amount in the Debit column. Then select the name of the party, from whom TDS is to be deducted. Press enter. You will be able to view Bill-wise Details.
In Bill-wise Details screen, select the New Ref under Method of Adj., enter other details, then select the TDS ledger from the list, the rate will be displayed automatically. Press 'Y' to accept the voucher.
Oct 22, 2009
Configuration Set up for TDS
Creating Ledger Account of Party/Deductee
Is TDS applicable : Set 'yes' this option.
Is Lower/No Deduction Applicable : If lower deduction is not applicable then set this option to 'no'.
Ignore surcharge : In certain cases, when the limit for TDS is reached, surcharge on TDS is levied. If this option is set as 'yes', surcharge will be deducted without any consideration to the exemption limit. If this option is set as 'no', surcharge will be calculated, only when the exemption limit is crossed.
Creation of TDS Ledger Accounts
Name : Enter the name of the ledger account to be created i.e. TDS Account.
Under : Ledger should be created under Duties and Taxes.
Type of Duty/Tax : Select TDS from the list given.
Nature of Payment : Select the nature from the given list.
Ignore TDS exemption limit : For certain payments there is a limit, crossing which, TDS will be deducted. If you set the option as 'yes', TDS will be deducted only when the amount of payment exceeds that limit.
Oct 21, 2009
Company TDS Deductor Details
- Tax Assessment Number : Enter 10 digit TAN number of the company.
- Income Tax Circle/Ward(TDS) : Enter the Income Tax Circle/Ward number under which the Company is assessed.
- Deductor Type : Two options are there Government and other. Select the right option.
- Name of the person responsible : Here name of the company official responsible for deposit of TDS is to be given.
- Designation : Give the designation of the person whose name has been displayed in 'Name of the person responsible'.
Activating TDS in Tally
Oct 19, 2009
Tax Deduction at Source(TDS)
The TDS is treated as Income Tax payment by the receiver at the time of assessment. A TDS certificate is to be given to the receiver.
Some of the incomes are - salary, interest, dividend, interest on securities, commission and brokerage ,etc
Oct 18, 2009
VAT Form and VAT Return
To view the periodical VAT return go to
Gateway of tally -> Display -> Statutory Report -> VAT reports -> VAT Forms. The form for VAT differs according to the state you have selected in the company creation screen.
VAT Return
An assessee falling under the purview of VAT is supposed to file return through Form No. 100. As Tally is VAT complaint it generates the Return based on the transactions entered into. For VAT return form go to
Gateway of tally -> Display -> Statutory Report -> VAT reports -> VAT Forms.
Oct 17, 2009
VAT Payable/Carried Forward
When Output Tax is greater than Input Tax, VAT Payable is Output Tax - Input Tax.
(Output Tax > Input Tax, VAT Payable= Output Tax - Input Tax)
When Output Tax is less than Input Tax, VAT Refundable is Input Tax - Output Tax. Balance Amount is carried forward to next period.
(Output Tax < Input Tax, VAT Refundable= Input Tax - Output Tax)
VAT Report
(Gateway of Tally -> Display -> Statutory Reports -> VAT Reports)
Oct 16, 2009
Branch Transfer when VAT is applicable
For example if goods are to be transfered from Kolkata branch to Mumbai branch. In this case of branch transfer outward for kolkata branch create ledger named Delhi branch under Branch/Division group.
Transfer out a/c under sales group and set 'Yes' at the option 'use in VAT'. Select Consignment/Branch transfer outwards and set 'yes' at Inventory values are effected.
In the sales invoice , select the delhi branch a/c in the Party's A/c Name field and at sales ledger select Transfer Out Ledger.
In case of transfer inward, create the ledger as Transfer in a/c under purchase group and voucher class is Consignment/Branch transfer inward.
Oct 15, 2009
Rate Difference in VAT
Sometimes it might happen that subsequent to a sale or purchase, the rate per unit of item is revised. In this case, rate difference allowed on purchase or sales are also entered through Debit Note and Credit Note, thus, reducing the purchase and sales value, respectively.
Debit note to supplier
For example your supplier reduces price due to competition and allowed a rate reduction of Rs. 100/each on 5 units of a good supplied to you and issued a credit note for Rs. 520(Rs.100 x 5 + 4% of Rs. 500). Then you pass an entry in Debit note by selecting the name of items and entering the rate difference (Rs.500 in this case) in the amount column and after entering item details, in the next row, press enter and select Input VAT @ 4%.
In the same way you can pass entry in Credit note in case you
VAT in Purchase Return and Sales Return(Debit Note/Credit Note
Sales Return
For example Mr. Rajiv Ghosh returned two monitors worth Rs. 10000/- due to some defects on which VAT @ 4% is charged. Therefore the total value comes to Rs 10400/-( Rs. 10000 + 4% of Rs. 10000)
In this case, select sales @ 4% ledger in the Sales Ledger field in the credit note voucher type. In the item field, give details of item returned worth Rs. 10000. After the items enter, press enter to move the additional aentry area, where you have to select Output VAT@4%, Press Ctrl + A to save the entry.
Purchase Return
For example some goods are returned to supplier due to defects, that are subject to 4% VAT.
In this case, at Debit note field , at purchase ledger field, select Purchase 4% ledger and at item field, enter the details of items, which is to be returned. In the next row press enter to move to the additional accounting entries where you have to select Input VAT @4% from the list of ledger to automatically compute the amount of VAT. Then Press Ctrl + A to save entry.
Oct 13, 2009
More than one VAT Rate Invoice entry
- Create Purchase @ 4% Account, Purchase @ 12.5% Account. It should be under Purchase account with VAT rate applicable like Purchase @ 4%, Purchase @ 12.5%.
- Create Input VAT @ 4% Account and Input VAT @ 12.5% Account under Duties and Taxes and select VAT under Type of Duties/taxes and Input VAT @ 4% and Input VAT @ 12.5% under default Tax and VAT class.
- Create suppliers account under sundry creditors if not created.
- Press F12 -> Invoice configuration -> set no at Use common ledger account and no at Allow selection of VAT/Tax class during voucher entry.
- Give item details at the entry at accounting allocation, select purchase-exempted ledger. Then enter item details for each item, select respective Purchase ledger and select the VAT class for each item.
- After completing the item details, select the input VAT A/c for each rate one by one, to get VAT computed on VAT-able items.
Oct 11, 2009
Sales entry with single VAT rate.
At Sales @ 4% A/c, select the sales ledger with VAT rate applicable like sales @4%.
Go to Accounting Vouchers from Gateway of Tally and press F8 for sales. There select Sales @ 4% under sales ledger and select sales @ 4% under VAT/TAX class. Enter the item details there. Then after that press enter and select VAT ledger, for example output VAT @ 12%, from the list and provide the rate to be charged. Press Ctrl + A to save the enty.
Oct 10, 2009
Ledgers to be created for VAT
Purchase and Sales Ledger
Then create purchase and sales ledger for each VAT rates, for example Sales @ 4%, purchase @ 4%, sales @ 12%, purchase @ 12%,etc. You can provide any other suitable name too but do set 'yes' at 'Used in VAT return?' to link the ledger to VAT computation and VAT return.
At VAT/Tax class field, select the applicable VAT classification, which would be selected as default on entry of the sales/purchase ledger.VAT Ledger
In the same way create input and output VAT ledger, for example Output VAT @ 4%, Input VAT @ 4%,Output VAT @ 12%, Input VAT @ 12% etc.
Activation of VAT
Press F11 -> Press F3 -> Set 'enable value added tax(VAT)' as 'yes' -> Enable 'Set/alter VAT details' option as 'yes' -> Enter VAT TIN number and PAN number there -> press enter and save it.
Then come back to Gateway of Tally and press F12 then select Invoice/Orders Entry and press enter. Set 'Allow selection of VAT/Tax class during entry' and 'Warn on Mismatch in VAT Rates' as 'yes'. Then save it.
Oct 9, 2009
Value Added Tax(VAT) in Tally
Types of Dealers.
A trader having turnover less than specified limit must not register under VAT Act but if they want to avail the facility of Input Tax Credit, they can register themselves. But traders who have exceeded the limit have to register themselves.
Unregistered Dealer.
Dealers having turnover less than the limit are not registered under the VAT act. They can maintain normal accounts in tally.
Registered Dealer.
Under the VAT Act, registered dealers may have either of the following status:
- Composite Dealer : Dealer having turn over less than the limit determined for composition, and have opte for composition scheme. They need not maintain VAT accounts but are required to maintain proper accounts to get the turnover figure for computation of composite tax.
- Registered Dealer : Dealers exceeding the specified limit must register under VAT Act. They can claim input tax credit and maintain accounts properly as per VAT rules.
Budget
Activating Budget.
In order to activate budget Press F11 -> press F1 -> specify 'yes' at the option 'Maintain Budgets and Controls'.
Creating a Budget.
From Gateway of Tally, go to Accounts Info and and select budget. There create a new budget, it will lead you to budget creation screen.
Information to be provided.
Name of the budget can be given as Quarterly budget, Corporate budget,etc.
The top level is primary budget. You can set up more than one primary budget. Under each primary budget, sub-budgets with different names can be created.
Specify the period of budget.
You may want to set/alter the budget for group of ledger accounts or for ledger accounts individually or for cost centres or all of them. We shall take up budget for group first.
Specify 'yes' at group. If you want to set budget for a group, thereby setting budget for all ledgers under the group. Fill in the following fields.
Oct 8, 2009
Post Dated Entries
This entries are useful in cases like post dated cheques are receipt or paid, or in case of bills.
Reversing Journal
There is a possibility that by mistake you have to rectify the mistake without deleting the entry, as deleting the entry will effect the Profit and Loss Account and Balance Sheet.
In this case you have to use Reversing Journal. These adjustment has to be done by placing the proper ledger in debit side and the other ledger in credit side.
Memorandum Voucher
For memorandum voucher go to Accounting Vouchers and press Ctrl + F10.
Why memorandum Voucher is used??
This question can be answered by a simple example.
Suppose a employee of a company is being sent to some place for a week or so. Company provides him Rs. 3000 as travelling expenses and tells him that he has to show each and every expenses made by him. In this case the Accountant enters Rs. 3000 as expenses but he unaware of the actual amount at that very moment, he will come to know about it after the employee returns.
In this case, the you will pass an entry n memorandum voucher showing that Rs. 3000 has been given to the employee as travelling expenses. Then after the employee comes back you will come to know about the exact amount and then go to Display -> Day book -> select the voucher entry previously made -> Make necessary changes -> Press F5 for payment/F6 for receipt.If the expenses made by the employee is more than what was paid by the company before then payment has to made, and if the expenses are less then receipt is to be done.
Optional Voucher
It can be done while passing vouchers i.e. receipt, payment, journal, contra, etc. It can be done in any voucher. If you want it to be shown in the Profit and Loss Account then open the entry and press Ctrl + L again.
To change the date press F2.
Bank Reconcilliation Statement(BRS)
The process in Tally is linked to the information that is provided while creating bank ledger. You will notice that the moment you select the 'bank account' group for a bank ledger, the field- "Effective Date for Reconciliation" appears. Normally this would be the 'Book Beginning from' date itself. You can also specify any other date reconciliation as per your needs. It may be noted that any transaction prior to the 'Effective Date for Reconciliation' will not be considered for reconciliation purpose. After creating all bank accounts and passing the necessary transaction purpose. After creating all bank accounts and passing the necessary transactions with them you need to reconcile the Bank Book with the Bank Statement.
In order to that perform the following:
Gateway of Tally -> Display -> Accounts Books -> Cash/Bank Book(s).
Select the bank whose balance you want to reconcile. Select the month which the bank balance you want to reconcile. Press F5. Put the dates of clearing amount i.e. the date when the amount goes out of bank.
Oct 7, 2009
Job Costing
First press F11 and then F1, set "Use Cost Centre for Job Costing" as 'yes'.
Go to cost Catagory(Accounts info -> Cost Catagory -> Create) and create a catagory named project or sites. Then go to Cost centre(Accounts info -> Cost Centre -> Create) and create the name of the projects or sites where the work is being done. While creating thes cost centre set 'use job costing' as 'yes'.
Then create godown from where the material are supplied to these site/projects.
Then we have to alter voucher type Stock journal and create a class named job costing there and set "Use class for job costing" as "yes".
Then inorder to transfer the stock item from godown to site/project area, go to accounting vouchers press ALT + F7 select stock journal and class as job costing. Then pass the entry.
Receiving Interest
Then receive interest through Accounting Voucher.
Interest Calculation
Then press F11 and then press F1, set "Activate interest calculation" and "use advanced parameter" as 'yes'.
Then Alter the ledger Investment created and set the 'interest calculation option' as 'yes'. There you give the all the information required i.e. the rate of interest, time period, rounding(rounding off the decimal value), etc.
Printing of Vouchers and other documents
Negative stock warning
Actual and Billed Quantity entry in Voucher
Oct 6, 2009
Manufacturing Entry
Incase BOM is yes i.e. the item you are creating is a finished product. So you have to enter the raw materials used for the product and the quantities needed for producing 1 unit of the finished product.
Finally to record manufacturing transaction using the manufacturing journal entry, from the gateway of tally, go to inventory voucher, press ALT + F7 and select "manufacturing entry" and press enter.
Select the name of the finished good from the pop-up list, then select the godown from the list where the finished goods will be stored. Give the number of units of finished goods you want to manufacture . Press enter to save all the materials.
There can be expenses for manufacturing a product, you can show that on the right hand side in terms of percentage or by typing the amount, you have to create a ledger under expenses(direct/indirect).
Transfer Stock
On the left hand side select the name of the commodity you want to transfer and the name of the godown from where you want the commodity to be send and on the right hand side write the destination place of the commodities. The stocks will be transferred.
Point of Sale
First you have to create a voucher by going to Accounts Info -> Voucher Types -> Create -> Give the name as 'Point of Sale' -> Then type of voucher as 'Sales' -> Set POS invoicing as yes -> In place of print message 1 you can give an ending message you want to convey to your customers -> Give name of class as 'POS'.
Then select the name of the company whose vouchers are used and the banks where the amount for credit cards and cheques will be deposited and then give the percentage to be allocated.
(If you see that you have not created a required ledger then press ALT + C. You can create a new ledger. Same method is applicable in case of stock items and other fields)To bring the mode Point of sale got to Accounting vouchers and then press F8 and from there chosse Point of sale and select POS invoicing. Then pass the voucher. If the modes of payment are not given then press Ctrl + P.
Linking Price List at Customer ledger account
Price List and Price Level
In order to enter the rates first press F11 and then F2. Set 'Separate Discount Column' and 'Multiple Price Level' as 'yes', there you have to enter the names of different price levels. For example whole-sellers, retailers, of season etc. Then press enter if you have written all the names.
Then go to Inventory Info from Gateway of Tally and select price list there and press enter. Enter the following information there and save it.
Then apply it in vouchers entries.
Oct 5, 2009
Voucher Entry using Cost Centre Class
Cost Centre Class
In order to use the cost centre class features, press F11 then press F1. In the screen set the option 'Use pre-defined Cost Centre Allocation during entry?' to 'yes'.
Then give a name to the Cost Centre Class you are creating. Then you will get a new screen where you have to enter the following information:
Cost Category: Select the parent cost category, for which you want to use the class, from the list of categories that appears on the right side.
Name of Cost Centre: Select the cost centre from the list of cost centres falling under the cost category selected in the cost category name field.
Percentage: Enter the percentage of cost to be allocated to each cost centre, based on which, cost allocation will be made.
Cost Allocation in Voucher
Then at the time of passing a voucher entry when you will select that ledger and enter the amount involved against the ledger, the Cost allocations for that ledger will appear. Here you have to specify the Cost category(Department/Branches/Executives) and then name of the Cost centres(Bangalore/Mumbai/Kolkata/Dehli) from the list of Cost categories and list of Cost centres.
Type the amount for that particular cost centre in the amount column. You can allocate cost to multiple cost centres if the total amount entered for that cost centre is less than the total amount involved in the transaction.
Once you specify amount to cost centres under one cost category you can go for selection of another Cost catagory just by pressing Enter to move to the next field.
Cost Catagory and Cost Centre
Suppose there are three departments
- Marketing
- Administration
- Services
and four branches
- Bangalore
- Mumbai
- Kolkata
- Delhi
and four Executives
- Mr A
- Mr B
- Mr C
- Mr D
In this case you have to create 'Department', 'Branch' and 'Executives' in Cost Catagory.
To create cost catagory first press F11, then press F1 and specify 'yes' at the option 'Maintain Cost Centres' and 'More than ONE cost category'.
Then from Gateway of tally -> Accounts info -> Cost Catagories -> Create.
After you have created the Cost Catagories come back to Gateway of Tally by pressing ESC.
Then Create Cost Centres ( Gateway of tally -> Accounts info -> Cost Centre -> Create).
Select 'Department' in place of category and then create Marketing, administration and service, and in the same way by selecting the category as 'Branches' you can create the cities under it. If you see that it has taken the category as 'Department' and you are willing to change it then press 'SHIFT + Tab'.
For deleting any cost category and cost centre go to alter and select the cost centre or catagory and press 'ALT + D'.
Oct 4, 2009
Creating Godown
Then go to Inventory Info -> Godown -> Create.
A company may have Godowns in different places, they can maintain stocks of different godowns through this.
Creating new voucher
Give the name of the voucher class then select the type of voucher. Then select whichever items should be included or excluded in the voucher. Press enter and then press 'y' i.e. yes to confirm.
To pass entry through that new voucher
Suppose you have created a new voucher under the type of voucher PAYMENT then go to Accounting Vouchers and press F5 then select the new voucher from there.
Oct 3, 2009
Creating stock group and stock catagory
And under that you can create stock categories such as samsung, nokia, sony ericsson, etc. under mobile group and lenova, acer, hcl, etc. under laptop group. Under this stock categories you can keep your stock items. This will help the company to maintain its stock items.
To create Stock Group
Gateway of Tally -> Inventory info -> Stock Group.
To create Stock Categories
Gateway of Tally -> Inventory info -> Stock Category.
(Note: If stock category is not shown then you have to activate it. In order to activate it press F11 from Gateway of tally -> Inventory features/press F2 ->'Maintain stock category' -> yes)
Transaction Entry
Then press F11 and activate 'Allow invoicing' and 'Enter purchases in invoicing format'. Type 'y' i.e. yes to activate these. Then save by pressing enter and at last again y to confirm. Then again press F11 and then F2 and activate 'Allow purchase order processing', 'Allow sales order processing' and 'Use tracking number(delivery/receipt note)' in the same way. After this you can pass any entry through this different vouchers. The vouchers are as follows:
- F4 for Contra Entry.
- F5 for Payment Entry.
- F6 for Receipt Entry.
- F7 for Journal Entry.
- F8 for Sales Entry.
- F9 for Purchase Entry.
- F10 for Reversing Entry.
- Alt + F4 for Purchase Order.
- Alt + F9 for Purchase Challan.
- Alt + F5 for Sales Order.
- Alt + F8 for Sales Challan.
- After making purchase order and challan, in order to get a purchase bill press F9.
- After making sales order and challan, in order to get a sales bill press F8.
Deleting a ledger or stock item
Gateway of tally -> Accounts info -> Ledger -> Alter -> then select the ledger and press enter -> press Alt + D -> press 'y' to confirm and 'n' to deny.
In order to delete a stock item go to
Gateway of tally -> Inventory info -> Stock item -> Alter -> then select the stock item and press enter -> press Alt + D -> press 'y' to confirm and 'n' to deny.