Skip to Article Skip to Youtube

How to record Sales Return with Output VAT in Tally ERP 9


Recording the Sales Return entry with VAT is as similar as recording the Sales with VAT in Tally ERP 9 but here we need to take the Credit Note Voucher to record the Goods Return transaction in the Books of Accounts.

How to record Credit Note Voucher entry for VAT in Tally ERP 9
Recording Sales Returns with Output VAT @ 5% in Tally ERP 9

In order to start recording the Credit Note transaction using the Credit Note Voucher Type for Sales Returns with VAT first we need to create the Sales Return Ledger with VAT configuration in order to account it for VAT computation.

For the demo purpose here I have created the Sales Returns @ 5% ledger for recording the Sales Returns that comes under 5% VAT/Tax Class.

As similar to the VAT Sales entry here also we need to consider the Assessable value and VAT value of the Credit Note. So, enter the Assessable amount in the Sales Returns @ 5% ledger field and VAT amount in the Output VAT @ 5% ledger field. Here I have already created the Output VAT @ 5% Ledger under Duties & Taxes group and configured the VAT for Output VAT ledger.

Here you can use the Sales @ 5% VAT ledger also instead of Sales Returns @ 5% ledger and I will now show the similar effect in the VAT Computation Report.

Creating Goods Return ledgers with VAT configuration in Tally.ERP 9


Creating goods return ledgers (Sales Return and Purchases Return) in Tally ERP 9 Accounting Software is as similar as creating the Sales and Purchase Ledgers for VAT computation. Either, you can create your own set of separate ledgers for recording the Goods Returns in the Books of Accounts or you can use the existing Trading Ledgers to record the return goods.

How to create Sales Return with VAT Ledger in Tally ERP 9
Sales Return @ 5% VAT Ledger Creation in Tally ERP 9

Record Goods Returns without creating Sales Return Purchase Return Ledgers in Tally

In case if you want to use the existing Trading Ledgers without creating separate ledgers for Goods Return just choose the

  1. Sales with VATLedger and Output VAT Ledger while recording a Credit Note Voucher.
  2. And similarly choose the Purchases with VAT ledger and Input VAT ledger while recording a Debit Note Voucher.

So, you no need to create separate ledgers for recording the Goods Returns. But, if you want to distinguish the Returns Goods from regular Sales and Purchases then you need to create the corresponding Goods Return ledgers with VAT configuration. In that case go ahead with the following guide.

How to Create Sales Return Ledger in Tally

So, while creating the Sales Return ledger with VAT follow the same procedure that we did while creating the Sales with VAT but give a different name like Sales Returns @ 5% VAT.

  1. Name the Ledger as Sales Return @ 5% VAT
  2. Choose Sales Accounts group from the List of Groups for Under field.
  3. If the Accounts with Inventory is activated.
    • Under Statutory Information set Yes for Used for Assessable Value Calculation.
    • Select VAT from the list of Duty/Tax Type for Apportion for option.
    • And select Based on Value for Method of Apportion option and save the screen.
  4. If the method of accounting is Accounts Only
    • And select Sales @ 5% from the list of VAT/Tax Class and save the screen.

Now we have created the ledger for recording the Assessable Value and for VAT amount we can use the existing Output VAT ledger.

How to Create Purchase Return Ledger in Tally

How to create Purchase Return with VAT Ledger in Tally ERP 9
Purchase Return @ 5% VAT Ledger Creation in Tally ERP 9

For recording the Purchase Return ledger similarly follow the instruction of Purchase with VAT ledger creation but give a different name to the Return ledger like Purchase Returns @ 5% VAT.

  1. Name the Ledger as Purchase Return @ 5% VAT.
  2. Choose Purchase Accounts group from the List of Groups for Under field.
  3. If the Accounts with Inventory is activated.
    • Under Statutory Information set Yes for Used for Assessable Value Calculation.
    • Select VAT from the list of Duty/Tax Type for Apportion for option.
    • And select Based on Value for Method of Apportion option and save the screen.
  4. If the method of accounting is Accounts Only
    • And select Purchases @ 5% from the list of VAT/Tax Class and save the screen.

Now we have created the ledger for recording the Assessable Value and for VAT amount we can use the existing Input VAT ledger.

We have seen the Goods Returns Ledgers for only VAT @ 5% for creating Goods Returns Ledgers for other VAT types just select the appropriate VAT/Tax Class at the time of creating ledger.

How to Record Sales with Output VAT in Tally ERP 9


Recording VAT Sales is similar to VAT Purchase entry but we need to consider the Output VAT Ledger instead of Input VAT ledger while creating the Accounting Voucher in Tally ERP 9 Accounting Software.

How to record Sales for 5% VAT in Tally ERP 9
VAT Sales Voucher entry using Sale Voucher Type in Tally ERP 9

Here I have created the Sales @ 5% VAT and configured the 5% VAT for the Sales ledger to record the sales that comes under 5% VAT/Tax Class.

As similar to the VAT Purchase entry here also we need to consider the Assessable value and VAT value of the Sales Invoice. So, enter the Assessable amount in the Sales @ 5% VAT ledger field and VAT amount in the Output VAT @ 5% ledger field. Here I have already created the Output VAT @ 5% Ledger under Duties & Taxes group and configured the VAT for Output VAT ledger.

Open the Accounting Vouchers in Gateway of Tally and

  1. Choose Sales Voucher Type by pressing the F8 Key to record the Sales.
  2. If the Accounting Voucher Creation screen in As Voucher mode hold the Ctrl Key and press V Key (Ctrl + V) or click on V: As Invoice button in Button Area.
  3. Choose a Ledger from the List of Accounts in Party’s A/c Name field.
  4. Record all the Stock Items of the sales invoice and choose appropriate Sales Ledger for the Stock Items. Tally will automatically select the appropriate VAT/Tax Class, which you configured at the time of Sales Ledger creation.
  5. After selecting the Stock Items list select the Output VAT ledger then it will automatically calculates the VAT against the sale of the Stock Items selected.

Save the screen to complete the VAT Sale. This is how to record the VAT Sales in Tally.ERP 9 Accounting Software.

How to record Purchases with Input VAT in Tally ERP 9


Purchase transaction which includes VAT amount can be recorded in Tally ERP 9. Before that purchase ledger must have configure with appropriate VAT/Tax Class. And as well Input VAT ledger needs to be created for the computation of VAT for Sales Tax calculation.

How to record Purchases with Input VAT in Tally ERP 9
Purchases recorded with Input VAT in Tally ERP 9

So, here we have created Purchases @ 5% VAT and configured the 5% VAT for the purchase ledger to record the purchases that comes under 5% VAT/Tax Class. In the same sense if you need to record other VAT Class create your own set of purchase ledgers by configuring the appropriate VAT/ Tax Class.

In the Purchases @ 5% VAT ledger we just record the Assessable Value of the Purchase Invoice and not the whole amount of the Invoice and the rest of the amount i.e. VAT amount needs to be recorded in another Ledger which is called Input VAT in case of Purchases. So, here I have created Input VAT @ 5% ledger under Duties & Taxes group and configured the VAT for Input VAT ledger.

To record the VAT Purchase just open Accounting Vouchers in Gateway of Tally and

  1. Choose Purchase Voucher Type by pressing the F9 Key to record the Purchases.
  2. If the Accounting Voucher Creation screen in As Voucher mode hold the Ctrl Key and press V Key (Ctrl + V) or click on V: As Invoice button in Button Area.
  3. Choose a Ledger from the List of Accounts in Party’s A/c Name field.
  4. Record all the Stock Items of the purchase invoice and choose appropriate Purchase Ledger for the Stock Items. Tally will automatically selects the appropriate VAT/Tax Class, which you configured at the time of Purchase Ledger creation.
  5. After selecting the Stock Items list select the Input VAT ledger then it will automatically calculates the VAT against the purchase of the Stock Items selected.

Save the screen to complete the VAT Purchase. This is how to record the VAT Purchases in Tally.ERP 9 Accounting Software.

Install Google Adsense Publisher Toolbar extension in Chrome Browser.


Google Adsense provides the awesome tools to Adsense Publishers to work in better and faster. In the row Adsense team has developed Google Publisher Toolbar extension in integration with Google Chrome Browser.

How to Install Google Publisher Toolbar.
Here i am showing how the Google Publisher Toolbar shows the Ad Report

The publisher must have an authorized Google Adsense Account as well the Google Chrome browser must have installed in their computer to use this awesome Chrome Extension. So, install the Google Chrome and follow the instructions.

  1. Open the Google Chrome to install the Google Publisher Toolbar. Just click on top right corner Customize and Control Google Button which resembles three lines button and select Settings option.
  2. In the Setting screen click on Extensions link on your left hand side.
  3. Scroll down to the end of the screen and click on Get more extensions link.
  4. In the new tab you can see the Chrome web store, just type Google Publisher Toolbar in the Search the store field and press the Enter key.
  5. Find out the Google Publisher Toolbar and click on ADD TO CHROME button.

It would take some time to download in your computer after downloading it will be installed automatically. Sometimes you need to click on the icon in Bottom Left corder in the Chrome browser to install.

After the extension has been installed successfully in the browser you will see Google Publisher Toolbar extension beside the Customize and Control Google Chrome button. Click on the extension and Login to your Google Adsense Account User id and Passwords by pressing the Allow Button. You can see now the earnings of your Adsense account without opening the Adsense website.

How to transfer Masters from a Company to another one in Tally ERP 9


When business people start accounting in a new Company in Tally ERP 9, they can import the Masters like Ledgers, Stock Items etc if they have already done last year accounting in Tally Accounting Software, instead of creating all the Masters from the scratch.

How to Export Masters like Ledgers, Groups, Stock Items in Tally ERP 9
Exporting all the Masters like Ledgers, Groups, Stock Items etc., in XML format in Tally ERP 9

It can be done with the help of Export and Import of Data features available in the Tally software.

How to export Masters (Accounting, and Inventory) in Tally ERP 9

Before we import the Masters into the new Company we must extract the Masters from the old Company using the Export option. In Gateway of Tally screen

  1. Choose Display option.
  2. List of Accounts
  3. Press Alt + E Keys or click on E : Export button laid in the Horizontal Button Bar.
  4. In the Export Report screen press Backspace Key.
  5. As Tally ERP 9 supports XML file format for data interchange, choose XML (Data Interchange) from the list of formats in Format field to export the masters.
  6. Specify the Disk Drive Path where the xml file to be created in the Export Location field.
  7. Choose All Masters in Type of Masters field.
  8. Set Yes for Export Closing Balances as Opening field.
  9. And enter the date upto what date the closing balances to be take for the Masters in To Date field e.g. Financial Year end date 31-3-14.

Accept the screen to create the xml file which is known as the exported file.

How to Import Masters in new Company in Tally ERP 9

After exporting process is completed come back to the Tally ERP 9 and switch to the new Company in which company you want to import the Masters. In Gateway of Tally

How to import Masters like Ledgers, Groups, Stock Items in Tally ERP 9
Importing Masters like Ledgers, Groups, Stock Items etc., from XML format in Tally ERP 9
  1. Select Import of Data.
  2. And go with Masters.
  3. You will see a screen where you need to provide the file name of your exported XML file name in Import File Name (XML) field. e.g. filename.xml.
  4. And select the option as per your requirement for the Treatment of entries already existing.
  5. Choose any one of the following Behaviour options for Treatment of entries already existing.
    • Combine Opening Balance option will enable to import data of different branches and consolidate the opening balances. You can also select this option when the opening balances of existing masters are Zero and need to be overwritten by the balances in the data being imported.
    • Ignore Duplicates option imports all the Masters without considering the duplicates Masters are available in the importing company.
    • Modify with New Data option is to replace the existing balances with those existing in the data imported and also overrides the other options available in Behaviour list.

So, as the final output you can see the number of all the Ledgers in your new company without creating them from scratch and using Transfer method by XML Export and Import options available in Tally ERP 9 form one company to another company.

How to record Bank Payment using the Voucher Class in Tally ERP 9


After we have defined the Voucher Class in Payment Voucher Type we can use them while recording the payments in Tally ERP 9 Accounting Software.

How to select a Voucher Class in Voucher Type Creation screen in Tally ERP 9
Selecting Voucher Class in Payment Voucher Type for making Bank Payment in Tally ERP 9

Here we have already created the Voucher Class in the Payment Voucher Type to record only Bank related payments. And the name of the Voucher Class is Cheque Payment and that should be selected while recording Payment in Accounting Voucher Creation screen.

In the Accounting Voucher Creation screen

  1. Choose the Payment Voucher Type.
  2. The screen will ask you to choose the Voucher Class from the Voucher Class List
  3. Choose the Cheque Payment.

Then you will the Voucher Class: Cheque Payment words on the top of the screen. And obviously the Bank Ledger that you have choose while creating the Voucher Class will be used automatically by the Payment Voucher Type.