Drushtant Infoweb Pvt. Ltd

TDS on Expenses-with Inventory (Purchase Voucher)

We have already discussed about Vat and excise in tally and tds in tally.

However in day-to-day business transactions, some times you have to face some complex cases e.g. a sales or purchase transaction where both Vat and TDS  is charged so how you will account this ?

This article will help you to record such transactions, where TDS on Expenses with Inventory applied for purchase vouchers

Example: On 2-8-2009 ABC Company received the bill for Rs. 52000 (for the supply of 1000 cartons @ 50 per carton and VAT @ 4%) from AK Enterprises. Cartons are printed with the company logo and other information as required on which (including the VAT amount) TDS is applicable.

The above transaction will be recorded in a Purchase Voucher

Step 1: Create Stock Item

Go to Gateway of Tally > Inventory Info. > Stock Item > Create

  • In the Name field enter the
Read More

How to enter Receipt Voucher in Tally ?

So, far we had a discussion about how to create a company ?,  Creating a company in Tally is the first step is  learning the basic of accountancy . Now you need to create some ledgers and assign the applicable group to the same.

Today, I will let you know how to post receipt voucher in tally.

Any money/cheque received from debtors against sales Invoices or on Account and  or for all transactions where money  received will be  accounted or entered into Tally.ERP 9 using the Receipt Voucher.

You can use reference  as advance receipt, New, Against or on account if you have enabled bill wise entry in Supplier’s ledger master. It will help you to record transactions bill by bill

To view the Receipt Voucher screen:

Go to Gateway of Tally > Accounting Vouchers

In Tally F6  is  used to enter receipt voucher whether it is a

Read More

Shoper 9 |A product from Tally 9 for Malls & large inventory

The modern business is that of Shopping malls, Super Markets and products having bar code

These Malls and units have 1000 or even more product to dealt with and it is almost impossible to manage these inventory through a traditional Accounting software.

Generally Product sold by these malls contains a bar code which make it easy to identity,manage, accounting and billing of such products.Here Tally Solutions come out with its innovative software called Shoper 9 to handle all types of requirement of such Malls.

This retail management software product convincingly addresses pain points such as data exchange between head office, warehouses and stores, providing a robust interface. Favoured by leading Indian specialty stores, Shoper 9 has catered to the apparel, footwear and textile segments with tremendous success.

The Shoper 9 philosophy is ease of use. And there’s a tested support system in place to ensure its smooth functioning. Professional support

Read More

How to configure SMS in tally.erp 9

We have already discussed flooded new and advanced features in release 2.0 of tally.erp 9. One of such feature is SMS in tally, now tally use can get all the required details from their tally data while on move through sms .

All you need is an activeTNS and release 2.0 of tally.erp 9. If you are ready with this minimum requirement then learn how to set up your tally.erp 9 release 2.0 for SMS facility.

Below is a video tutorial to learn sms set up in tally.

If you like the video and sms feature then try to set up yourself. All queries are welcomed on our support forum

Read More

How to Configure Server for Synchronization

Tally.erp 9 offers a host of benefits to user which no other Accounting / ERP software company provides at such affordable price.

We have already discussed about remote edit, job control panel and auto back up in tally which are very useful and need of today’s business community.

Data Synchronization is one such need software which is very useful for seamless transmssion of data between branches and Head office.

Below is the process to configure Server for Synchronization.

To configure the Server Company for Synchronization, follow the steps shown below:

Go to Gateway of Tally > F12: Configure > Advanced Configuration

In the Advanced Configuration screen,

Under Client/Server Configuration section,

  • Set the option Tally is acting as to Server to run Tally.ERP 9 as Synchronisation Server
  • Specify the required port number (e.g. 9009) in the Port field.

Tab down to Connection Configuration section:

  • Set the duration in seconds for Connection
Read More

Works Contract | How to deal in Tally : Works Contracts.

Works Contracts can be managed in Tally a more systematic way

We have already discussed a lot about vat and excise in tally and also read about concept of VAT. Today we will see the concept of works Contract and how to deal in Tally

Works Contracts, on Which VAT, Service Tax and TDS are applicable can be recorded in Tally.ERP 9. Works Contract transactions can be recorded in Purchase Voucher (Account Invoice Mode)


Example: On 10-10-2009 ABC Company received Bill -0052 from  Shreya Builders & Developers for Rs. 58,384.80 for the given Work Contract.

In the above transaction – Purchase Cost of the Works Contract is Rs.54000, VAT is @ 4%, Service Tax @ 4.12%. On the Total AmountTDS @ 1% to be Deducted.

Follow the given steps to record the above works contract

Step 1: Create Masters for Works Contract

  1. Party Ledger
Read More

learn tdl | how to create a new field in Ledger Master ?

So, far a great response to our first TDL program its time to go ahead.Before  you read this article, you must know how to configure TDL in tally otherwise you will not be able to use the TDL.

Once again I have to remind that TDL is domain specific language and its  Tally’s programming language which help you to customize your default tally reporting, menu etc. It is very easy to learn tally but you need to have great hands of practice to learn the same.

There is no book available in the market to learn this programming language!

Below is a programming code which will help to create a new field in your ledger Master  creation/alteration mode.

;; user who are interested can learn tally tdl,
;;UDF definition
[System: UDF]
MyUDF: String: 1000

;;Modify Ledger Master entry screen and add a line
[#Part: LEd Other Details]
Add: Line: MyLine

[Line: My Line]
Field: Short Prompt,My Field
Local: Field:

Read More

Sale of Services with Inventory

Sometimes, back, I have written an article on how to create an item ledger with vat and excise duty details, so that the sales invoice entry will automatically pick the duty calculation on the item.

In response to the same, some of my readers including Mr. Gautam and Mr. Shahid have raised query on how to create an item with service charges excluding vat on service/repairing income ?

Here is the solution to this problem.

Let’s assume  on 28-08-2010   Red Express Company sold 10 Nos. Auto parts @ 1500 per Part  to M/s.Zoom Auto co. along with a repairing charges of Rs. 5000.00

To account the above transaction

1. Create Income Ledger : Repairing Charges (Income) under the group Direct Income.

2.Set Inventory Values affected to No

IF you are not under the preview of service tax then set no to service tax filed under statutory details.otherwise set     it   to

Read More

Excel to Tally| Learn TDL online

Tally.erp 9 is one of the simplest accounting software,any person having a good commerce background knowing basic of accounting can handle it easily. however, notice people and esp. those who have a different background found it very difficult to create ledger and post entries in tally.
Excel is the simple Microsoft application and anyone can handle it very very easy.
as in Excel, all you need is just to feel up the cells and save it!
So, what about if there is a utility that you type entries in excel then import the same in tally ? Is it hard ?
yes really hard but I made it easy for you. I have developed a utility a very simple utility for you guys now you don’t need to learn tally.
All you need is just download the utility. The utility is simply superb as per screen shot shown in

Read More

Columnar Sales Register in tally | How to view ?

Earlier, I have posted articles on how to pass entries for sales/purchase  under category of vat and excise in tally.erp 9

Today, we will see how to generate sales report in tally.erp 9. Printing columnar report is important in accounts esp. to generate sales and purchase register for vat assessment.

Tally.ERP 9 provides you the capability to generate columnar reports for different periods. Select the option F5: Columnar from the button bar, in the Sales Voucher Register screen.

Set the options listed to Yes or No, depending on how you want the Sales Register to be displayed.

Type of Column

Select the type of column from the screen.

If you select Ledger or Group as Type of Column, you will be provided with one more list for choosing the ledger/group. Your choice will be displayed under Name of Account.

All Items (automatic columns)

If this option is selected, every ledger

Read More
error: Alert: Content is protected !!