Skip to Article Skip to Youtube

How to activate VAT Commodity in Stock Item in Tally ERP 9


In order to start accounting for VAT Commodities in Tally ERP 9 Accounting Software we must incorporate the VAT Commodity in the Stock Item while creating the Stock Item in Tally Software. Simply creating the VAT Commodity will not produce the Commodity wise Report but it must be activated in Inventory.

How to configure VAT Commodity in Stock Item in Tally ERP 9
VAT Commodity selected for Stock Item - Cotton in Tally ERP 9

Before proceeding to activate the VAT Commodity, first you need to create the VAT Commodity. And after that open the Stock Item in alteration mode or in the Stock Item Creation screen itself you can configure the VAT Commodity for the Stock Item.

  1. Open the Stock Item in alteration mode.
  2. Get to the VAT Details section and choose any one of the VAT Commodities from the List of VAT Commodities for Commodity field.
  3. Enter the percent of VAT for the Stock Item in the Rate of VAT (%) field.

Now the Stock Item is configured with the VAT Commodity in Tally ERP 9 Accounting Software.

How to create a VAT Commodity in Tally ERP 9


When you are dealing with VAT in Tally ERP 9, it is the best way to create VAT Commodity for a group of Stock Items which are covered under VAT Schedule by the Commercial Tax Department of the concerned State. And Tally allows you to manage the VAT Commodity wise accounting.

How to create VAT Commodity in Tally.ERP 9
VAT Commodity Creation for Seeds in Tally ERP 9

So, it is advised to create VAT Commodities for Stock Items with which you trade, in Tally Software. Before, forwarding to create the VAT Commodity in the Statutory Management Software you need to configure VAT in the Company and it must have enables accounting with Inventory.

However, it is not mandatory to create the VAT Commodity, but if you need to produce VAT Commodity wise Report to the Sales Tax Department then you must create the VAT Commodity and that should be activated in the Stock Items.

In Gateway of Tally screen choose the Inventory Info under Masters

  1. Choose VAT Commodity.
  2. Create
  3. In the VAT Commodity Creation screen give a Name to the VAT Commodity.
    • Select VAT from the list of Tax Type for Used for field.
    • Enter the Commodity Code, Schedule Number, and Schedule Serial Number in the concerned fields.

Save the screen to create the VAT Commodity. Now you can configure the Commodity in the Stock Items for generating Commodity wise Report.

You can get VAT Commodity Details like Schedule and the Serial Numbers from the Commercial Taxes Department Website of your State.

How to restrict Ledgers in Voucher Type using Classes in Tally ERP 9


While recording the business transactions in Tally ERP 9 accounting software we can restrict certain Group of Ledgers to be used or not to be used in the Voucher Type Creation screen. And we can customize this by defining a Voucher Class in the Voucher Type creation screen.

How to create Voucher Class for a Voucher Type in Tally.ERP 9
Voucher Class defined for Cash Purchases

After you have created the Class for the Voucher Type it can be used while recording the accounts using the Voucher Type. So, let us try to create Voucher Classes for recording the Cash Purchases and Credit Purchases using the same voucher type.

So, at the time of recording the accounts using the Voucher Type, it should not allow the Sundry Creditor if the selected Voucher Class is Cash Purchases likewise, it should not allow the Cash in Hand if the selected Voucher Class is Credit Purchases.

How to define Voucher Class for recording Cash Purchases in Tally ERP 9

From the Voucher Types menu select Alter option to open the Purchase Voucher Type in the Voucher Alteration mode.

  1. Get to the Name of Class section and give a name to define the Voucher Type e.g. Cash Purchase and press the Enter Key.
    • In the Voucher Type Class screen select Bank Accounts, Bank OCC A/c, Branch/ Divisions, Sundry Creditors, and Sundry Debtors groups from the List of Groups for Exclude these Groups option.
    • And select only Cash-in-Hand group from the List of Groups for Include these Groups option.
    • In the Default Accounting Allocations for all items in Invoice (except for the items specified below) section
      1. Select a Purchase ledgerfrom the List of Ledger Accounts for Ledger Name option.
      2. Select Not Applicable for Default Accounting Allocation for option.

And accept the screen. Now Cash Purchases Voucher Class has been defined. And don’t save the Purchase Voucher Type Alteration screen and try to create another Voucher Class for Credit Purchases.

How to create Class for recording Credit Purchases in Tally ERP 9

Creating a Class for Credit Purchases quite similar as explained above but a few changes needs to be done. Type another name just below to the Cash Purchase Voucher Class e.g. Credit Purchases and press the Enter Key.

  1. In the Voucher Type Class screen select Bank Accounts, Bank OCC A/c, Cash-in-Hand groups from the List of Groups for Exclude these Groups option.
  2. And select Branch/ Divisions, Sundry Creditors, Sundry Debtors group from the List of Groups for Include these Groups option.
    • In the Default Accounting Allocations for all items in Invoice (except for the items specified below) section Select a Purchase ledgerfrom the List of Ledger Accounts for Ledger Name option.
    • Select Not Applicable for Default Accounting Allocation for option.

And accept the screen and now save the Voucher Type Alteration screen for effecting the Class changes to the Purchase Voucher Type. Now try to record the Purchases by selecting the appropriate Voucher Class.

In order to show the effect in Purchase and Sales Voucher Types the Voucher Creation screen should be in Invoice mode and not in Voucher mode.

How to configure Cheque Printing for any Bank in Tally ERP 9


Earlier, Tally user had to configure cheque dimensions manually for printing the Cheque Leafs using the software. But, now Tally ERP 9 has came up with predefined Cheque Formats for almost all the Banks available in the market.

How to configure Cheque Printing in Tally.ERP 9
State Bank of India Cheque Configured for Printing in Tally ERP 9

You do not need to worry about configuration of Cheque Printing with the exact dimensions. In order to auto configure the Cheque of your Bank, your computer must be connected with the Internet to access the available Banks at your Country and concerned the Cheque Formats. So, you do not need to issue the Hand written Cheques to your business people. After you have recorded the Payment Voucher you can take the Print out of the worth payment in your Cheque Leaf.

You can configure the Cheque Printing for your Bank Ledger if the ledger account is of Bank Accounts or Bank OD A/c groups. In the Ledger Creation or Ledger Alteration screen

  1. Select Yes for Set/Alter Bank Details option.
    • In the Bank Details screen select appropriate Bank Name from the List of Banks for Select your Bank option.
    • Under General Configuration section select Yes for Set Cheque Printing Configuration option.
    • Then you will see the Cheque Format Selection screen where you will see the specimen of the Cheque based on the selection of your Bank for Select your Bank option in the earlier screen.

If you see the different Cheque Preview just choose the appropriate format from the List of Cheque Formats in the left side. If you do not see the exact cheque specimen then you need to go with User defined format to manually configure the Cheque printing dimensions. Accept all the Bank screens and save the Ledger Creation and Ledger Alteration screen.

When you select the Bank Ledger which is configured for Cheque Printing you can print on the Cheque after you have recorded the Payment transaction. It is better to take print on white paper and check it before printing on the Cheque Leaf.

How to add SB or OD Account details in Bank Ledger in Tally ERP 9


In Tally ERP 9 Accounting Software, Banking section made easy and even we can store our Bank Account details like Saving or Current Bank Account Number, IFSC Code etc.,. If we have our Bank details in our Books of Accounts we can easily send them to the Dealers and Marking Staff to enable them for the Payment of Outstanding Bills from their Banks.

How to add Bank Account Details in Ledger Account in Tally ERP 9
Adding account details in Bank Ledger in Tally ERP 9

This application allows the user to add the following Bank Details.

  1. Account Number
  2. Account Holder Name
  3. Branch Name
  4. BSR Code
  5. And IFS Code known as IFSC Code

These are the major elements of Bank Account. In order to store your Current Account or Savings Bank Account details open your Bank Account Ledger in Ledger Alteration Mode.

  • Select Yes for Set/Alter Bank Details and press Enter Key.
  • In the Bank Details screen you can find the Account Details section where you can update your Bank Ledger with your Bank Account information.

How to create VAT calculating Ledgers (Input, Output) in Tally ERP 9


Apart, Trading Account ledgers like Purchases and Sales ledgers we need to create Input VAT and Output VAT ledgers for every Trading Ledger. And this is the common way of VAT computation where Invoice amount will be divided into Assessable and VAT amounts. The Assessable amount will be recorded in the Trading ledgers where as the VAT amount will be recorded in the VAT ledgers here called as Input VAT and Output VAT ledgers.

How to create Input VAT Ledger for VAT Purchases in Tally.ERP 9
VAT Ledger Creation in Tally ERP 9

And here Input VAT ledger to be used along with Purchases ledger, where as Output VAT ledger to be used along with Sales ledger while recording VAT Purchases and VAT Sales in Tally ERP 9 Software.

And let us start creating the Input VAT and Output VAT ledgers in Tally Software for VAT 5% Purchases and VAT 5% Sales.

Creating Input VAT @ 5% Ledger in Tally ERP 9

After you have configured Sales Tax (VAT), and created VAT Purchases @ 5% ledgers in a Company, we need to create Input VAT @ 5% ledger, where VAT amount against the Assessable Value of Purchases needs to be calculated and reported in as per VAT rules. We can get the VAT amount of various VAT/Tax Classes such as 1%, 5%, 14.5% by creating the various Input VAT ledger. So, it is recommended to append VAT Percent at the end of the Ledger name to distinguish it from other VAT Classes. In the Ledger Creation screen

  1. Name the Ledger as Input VAT @ 5%
  2. Choose Duties & Taxes group from the List of Groups for Under option.
  3. Select VAT from the list of Types of Duty/Tax for Type of Duty/Tax option.
  4. Choose Input VAT for VAT Sub Type option.
  5. Select Input VAT @ 5% for VAT/Tax Class option.
  6. Choose any one of the Rounding Methods for Rounding Method option.
  7. Enter the digit for Round Limit e.g. 0, 1, or 2. And save the screen.

Creating Output VAT @ 5% Ledger in Tally ERP 9

Likewise Input VAT ledger creation we need to create the Output VAT ledger for the computation of VAT on Assessable Sale value. In the Ledger Creation screen

  1. Name the Ledger as Output VAT @ 5%
  2. Choose Duties & Taxes group from the List of Groups for Under option.
  3. Select VAT from the list of Types of Duty/Tax for Type of Duty/Tax option.
  4. Choose Output VAT for VAT Sub Type option.
  5. Select Output VAT @ 5% for VAT/Tax Class option.
  6. Choose any one of the Rounding Methods for Rounding Method option.
  7. Enter the digit for Round Limit e.g. 0, 1, or 2. And save the screen.

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

How to create Trading Accounts with VAT configuration in Tally ERP 9


At the time of creating Trading Accounts like Purchases and Sales Ledgers in Tally ERP 9 Accounting Software, we must configure those Ledger Accounts with the appropriate VAT/Tax Class. As soon as we update the Company with the VAT information in Statutory Features, trading ledger accounts will automatically shows the Statutory Information in the Ledger Creation or Alteration screen.

How to create VATable Purchase Ledger in Tally ERP 9
VAT @ 5% Purchase Ledger Creation in Tally.ERP 9

And let us start creating the Trading Accounts with VAT Configuration in Tally Software for VAT 5% Purchases and VAT 5% Sales.

Creating VAT 5% Purchases Ledger in Tally ERP 9

We have already learned how to create a Purchase Ledger without VAT. And now, let's try to add some stuff to the Purchase Ledger for VAT computation purpose, after configuration of VAT in your Company. You need to create different Purchase Ledgers for various VAT types which know in Tally as VAT/Tax Class such as Purchases @ 1%, Purchases @ 5% etc. So, it is recommended to append VAT Percent at the end of the Ledger name to distinguish it from other VAT Classes. In the Ledger Creation screen

  1. Name the Ledger as Purchases @ 5%
  2. Choose Purchase Accounts group from the List of Groups for Under option.
  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.

Creating VAT 5% Sales Ledger in Tally ERP 9

We have already learned how to create a Sales Ledger without VAT, now try to configure VAT to the Sales Ledger. In the Ledger Creation screen

  1. Name the Ledger as Sales @ 5%
  2. Choose Sales Accounts group from the List of Groups for Under option.
  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.

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

How to Backup and Restore a Company data in Tally ERP 9


The Account Package Software, Tally ERP 9 supports to carry the data where ever you want. And the Tally will not restrict you to stick on to only one computer to work only. We can carry the Company data from Branch Office to Head Office from Office to Home using the Backup and Restore options available in Company Info menu.

How to Backup a Company in Tally ERP 9
Backing up a Company data in Tally ERP 9

Even we can access the Company Data remotely using Tally .Net facility but there must be internet connection available in both the sides. So, to access the Company Data through offline mode tally having this feature. And this is very helpful at the time of auditing the accounts by the Auditors of the company they just simply take the ;Backup ;from the Clients computer and ;Restores ;the information in their computer and they will finish the Auditing work.

Backup the Company Data

Backup ;is nothing but taking softcopy of the company data on removable storage devices like Flash Drive (Pen Drive) or Compact Disk (CD). When you take the backup a Company or group of Companies a file named ;TBK900.001 ;(where the ;TBK900 ;is the primary name and ;.001 ;is the secondary name or extension name) will be created. This file format is only understood by the Tally Software. To start the backup process

  1. Select ;Backup ;option from ;Company Info. Menu.
  2. You will see ;Backup Companies on Disk ;screen.
  3. Come to the ;Destination ;and give the ;Disk Drive path ;where you want to save your backup file like H:\, G:\ (for Pen Drives) C:\, D:\, E:\ (for local Disk Drives).
  4. Select a Company or group of Companies for backing up specific company or companies or select ;All Items ;for backing up all the companies from the ;List of Companies. At the end select ;End of List ;to complete the selection of companies.
  5. Finally accept the screen.

As soon as you accept the Backup Companies on Disk screen tally will show the Progress Bar and as soon as the progress bar finishes TBK900.001 file will be created in the Destination path. Just open the Disk Drive location where you have taken the backup. There you can find the Backup file named ;TBK900.001. And this is the single file having all the information about your Books of Accounts concerning to the selected companies.

Restore the Company Data

How to Restore a Company in Tally ERP 9
Restoring Company in Tally ERP 9

In order to work in Tally we must have a Company created or we must restore the ;Data file ;which contains the company data. Restoring is nothing but the loading the Company Data back to the Data directory in the Tally Installed location. For restoring the data you need the ;TBK900.001 ;file. Tally will understand this file only, other than this tally will not recognize to restore into Tally software. To restore we need to perform the following steps.

  1. Select ;Restore ;option from ;Company Info. ;menu.
  2. You will see ;Restore Companies on Disk ;screen.
  3. Come to the ;Source ;and give the ;Disk Drive path ;where you backup file.
  4. Select at least one Company or group of Companies for restoring specific companies or select ;All Items ;for restoring all the companies from the ;List of Companies. At the end select ;End of List ;to complete the selection of companies.
  5. Finally accept the screen.

As soon as you accept the ;Restore Tally will process, the same will be shown in the screen with Progress Bar. Now you can start working with the restored companies in your Tally Software.

Create User Defined Voucher Type for Bank Payments in Tally ERP 9


We can create a separate Voucher Type for recording the Bank Payments in Tally ERP 9 Accounting Software. And it is the best way segregate Payment entries based on the Instrument type such as Cheque Payments or Cash Payments. Here is the way in Tally ERP 9 Accounting Software. We can create our own Voucher Types for such user defined requirements.

User Defined Voucher Type Creation for Bank Transactions such as Cheque Payments in Tally ERP 9
User Defined Voucher Type creation for Bank Payments

You can create as many User Defined Voucher Types as you wish. Here User Defined means which you create based on your own requirement. As well further you can restrict to show particular Group of Ledgers such as Bank Accounts Groups or select an exact Ledger Name for such payment such as State Bank of India Ledger by defining Classes in Voucher Type Creation/Alteration screen under Name of Class section.

  1. In Gateway of Tally screen select Accounting Info option.
  2. Voucher Types
  3. Create

In Voucher Type Creation screen give name as per your requirement here i want voucher type for cheques payments only so i gave it as Cheque Payments.

  1. Go to General section choose Payment from the List of Voucher Types for Type of Voucher option (Do not select other than that).
  2. Select any one of the following Types of Numbering for Method of Voucher Numbering option
    • Automatic Type of Numbering will automatically assign a number for the voucher entry at the time of creating a Voucher.
    • Manual will allow the user to provide a Number for the Voucher creation.
    • Multi-user Auto will be similar to Automatic type of Numbering but it is applicable if Tally used in multi user.
    • None type of Numbering will not give any number for your Voucher.
  3. Leave all the options as it is.
  4. Finally accept the screen.

Now you have successfully created Voucher Type on your own for your Bank Payments. If you want to further allow only Bank Ledgers in this voucher type then you need to create Define Class for the Voucher Type under Name of Class section in the Voucher Type Creation or Alteration screen.

Design customized Numbering format for Vouchers Type in Tally ERP 9


In Accounting Software, Tally ERP 9 we can customize the Voucher Number to be given to the Voucher entries for various Voucher Types, while recording Accounts. For instance, if the amount is received through Bank we can create Voucher Number that starts with BNK/1 for Receipt Voucher Type. Like wise to recognize Sales made to other States can be identified by creating Voucher Number that starts with CST in Sales Voucher Type e.g. CST/001.

Design customized Numbering format for Vouchers Type in Tally ERP 9
Customized the Voucher Number Format for Bank Payments

Therefore, this kind of customization can be done to Voucher Types in Tally Software. And let us design a Voucher Number Format for Payment Voucher Type for recording Bank Payments. For recording the Bank related payments i have created User Defined Voucher Type named Cheque Payments under Payment Primary Voucher Type.

Using the Use Advance Configuration option in Voucher Type Creation/Alteration screen we can create our own customized Voucher Number for the Voucher Type. I have the following criteria for my Voucher Number that the Voucher Number should start with Cq.Pay/ where i can remember Cq means Cheque and Pay means Payment so when i when i see the print out of the voucher entry i can quickly recognize as it is meant for payment made using Cheque instrument and followed by the automatic numbering and end with Financial Year /2014-15.

In order to design your own customized number for the Voucher Type, open the Voucher Type in alteration mode. In the screen

  • Choose Automatic from the list of Type of Numbering for Method of Voucher Numbering option.
  • And set Yes for Use Advance Configuration option.

You can do the same thing at the time of creating your Own Voucher Type. Then you will be navigated to a new screen like one seen in the above image. And configure the criteria for your Voucher Number using the following settings.

  1. Give the starting number from which digit your Voucher Number should start with for Starting Number option. If you give 8 your Voucher Number will starts with 8.
  2. Mention the width of the Numerical Part of the Voucher Number should be using the Width of Numerical Part option. If you give 3 then your Voucher Number will look like this 008.
  3. If the Numerical Part is having only one Digit like 5 or 8 you can fill the remaining width of the Numerical Part with Zero using Prefill with Zero option. Set Yes for this option to do so then the Voucher Number will like this 008 otherwise it will be like this 8.
  4. You can restart the Numerical Part of the Voucher Number from a specific digit using the Restarting Number. If I set Applicable Date as 1-4-2014, Starting Number as 5, and Particulars as Yearly. The Voucher Numbering will starts with 5 irrespective of Starting Number of the Numerical Part. Then the Voucher Number will be 005 from 1-4-2014 after a Year i.e. from 1-4-2015 it will again starts with 005.
  5. You can add a constant data before the Numerical Part of the Voucher Number using the Prefix Details option. Suppose I set Applicable Data as 1-4-2014 and Particulars as Cq.Pay/ then the Voucher Number will look like this Cq.Pay/001.
  6. As well you can add a constant data at the end of Numerical Part of the Voucher Number using the Suffix Details option. Suppose I set Applicable Data as 1-4-2014 and Particulars as /2014-15 then the Voucher Number will look like this Cq.Pay/001/2014-15.

And this is the procedure to set the Advance Configuration for Method of Voucher Numbering in Tally ERP 9. Hence, the final output will be for starting number as Cq.Pay/001/2014-15. You can do this trick for any Voucher Type in Tally ERP 9 Software. Start designing your own Voucher Numbering format as per your requirement.

How to request for re-dispatch of newly applied PAN Card


When we applied for a PAN Card, we get that through Registered Post to the Communication address mentioned in the Application form. But what happens when we fail to receive the PAN Card due to went to vacation holidays or some other reason. Your local Post Man will return the Document to the sender address.

How to request for re-dispatch of new pan card
PAN Card Application Acknowledgement - Below you can Find the Contact Details of the PAN Department

We must take the precaution before that takes place, like information your neighbors to receive the PAN Card on behalf of you. Even we tell the neighbors we can not expect that they shall receive surely. So, it is the best idea to contact your Local Post man who dispatches the Documents at your location and request him to keep with him for a couple of days until you collect it.

If you have failed to take the above precaution you have choice to request the PAN Card Issuer to re-dispatch your PAN Card, but you can not instruct them to send to another address they will sent to the address mentioned in the Application only, upon a request letter.

So, before you are going to write a request letter you should know the Office Address where your PAN Card is lying at whether at Hyderabad, Mumbai, Delhi etc. And you can know the status by search with your Coupon Code or Application Number in the concerned website.

After that find the contact details of the concerned office address in the Acknowledgement paper. Just prepare a request letter and in the letter mention your Application details along with your information mentioned in the application. Take the printout of the Request Letter and sing it. You can email it by scanning the paper or Fax it and inform them.

If the PAN Card applicant is a Firm or Company then the Request Letter must be printed in the Official Letter Head of the Business, signed by the Authorized Person of the Organization and properly sealed with the Company Stamp.

Then within 2 business working day you will get the reply from the concerned department. If you still don’t get any reply from their side. Remind them about your request.

How to enable Value Added Tax and CST (Sales Tax) in Tally ERP 9


Every business organization, who deals with Sale of Goods needs to pay off the VAT to the State Government as per VAT rules. So, you must know the amount of VAT Tax to pay off against the Assessable Value that you compute for a specific period. You can start this article after reading About VAT article if you are the beginner otherwise continue to read how to start VAT Accounting in Tally ERP 9 Accounting Software.

How to enable VAT in Tally ERP 9 Accounting Software
VAT is enabling in Tally ERP 9

It is the most important thing to enable Statutory & Taxation features of the Company to effect the VAT automatic calculation in the ERP Software. In order to start Statutory Accounting of Sales Tax in Tally Accounting Software first, we need to enable the Value Added Tax (VAT) in the Statutory & Taxation features of the Company.

In order to successfully configure Sales Tax in ERP Software we need to update certain information of the Statutory & Taxation features of the Company. Here, I am going to configure the Value Added Tax settings for the Company where the TIN number has been received from Andhra Pradesh state.

  1. In Gateway of Tally screen click on F11: Features button in Button Area.
  2. In Company Features menu choose Statutory & Taxation option.
  3. Then you will be seeing Company Operations Alteration screen.
  4. Set Yes option for Enable Value Added Tax (VAT) under Statutory & Taxation section. As well set Yes option for Set/Alter VAT Details option.
    • In Company VAT Details screen select the State from which state the TIN Certificate was received. Based on the selection of the state, Tally software will ask your VAT and CST Registration information.
    • For the Type of Dealer option select your dealership type from Types of VAT Dealer list.
    • Enter the date from which the VAT provisions are applicable for the dealer in the Regular VAT Applicable From field.
    • As well you can add additional details about your Business and concerned Commercial Tax Office under Additional Information section in the screen. After you have finished updating the Additional Information you will be navigated again to Company Operations Alteration screen.
  5. Under Tax Information section in the Statutory & Taxation features provide your TIN number and CST Number in the corresponding fields.

If you are enabling VAT for a state other than Andhra Pradesh state you will be seeing other options in the Company VAT Details screen.

And finally accept the Statutory & Taxation features in the Company Operations Alteration screen. Now your Company is enabled for VAT Accounting in Tally Software and start recording your accounting for automatic VAT Reporting and VAT Computation.

How to create Customized Voucher Type in Tally ERP 9


Tally ERP 9 Accounting Software having various default Voucher Types such as Accounting, Inventory, and Payroll Voucher Types for recording the Financial, Statutory, Inventory, and Employees related transactions in ERP Application. Apart that it allows the users to create their own set of Voucher Types to customize the Books of Accounts in Tally Software.

How to create Voucher Types in Tally ERP 9 Accounting Software
Voucher Type created for Purchases @ VAT 5%

In order to meet the requirements of the Business People, Tally having the Voucher Type Creation screen to create our set of Customized Voucher Types. For instance, we can create a customized Voucher Type to record only Bank receipts, where we can restrict the Accounting Voucher Creation screen to restrict Cash Ledger while recording a Bank Receipt using Class concept which we will discuss later.

So, let us start creating a Voucher Type for recording Purchases @ VAT 5%.

  1. In Gateway of Tally screen select Accounting Info option.
  2. Voucher Types
  3. Create

Now you can see the Voucher Type Creation screen.

  1. Give a name for your Voucher type e.g. Purchases @ VAT 5%.
  2. Under General section choose a predefined Voucher Type for Type of Voucher option.

Now save the screen to create the Voucher Type now we have just created the Voucher Type in order to impose any restriction we need to create Class for the Voucher Type.

What is the meaning of Accounting or Accountancy


Accounting or Accountancy is the process of transforming the Book-Keeping data into understandable financial information about a business entity to users such as shareholders and management. The communication between the Accountants and Management generally in the form of Financial Statements that show in money terms. The art lies in selection of Information that is relevant to the user and is reliable. The Principles of Accountancy are applied to business entities in three divisions of practical art, named Bookkeeping, Accounting, and Auditing.

The American Institute of Certified Public Accountants (AICPA) - "The art of recording, classifying, and summarizing in a significant manner and in terms of money, transactions and events which are, in part at least, of financial character, and interpreting the results thereof."

Accounts recording system found in Mesopotamia(Assyrians) date back more that 7,000 years. On that time, people relied on primitive Accounting methods to record the growth of crops and herds. Since then Accountancy improving over the years and advancing as business advanced.

In this modern trend Accounting is called as "The Language of Business" as every shareholder, entrepreneur, even small business people would understand and speak the basic Accounting terms. So, it plays the role of language among the different groups of people in the form of Financial Statements, and Reports. In order to satisfy needs of different people interested in the Accounting Information, different branches of Accounting have developed namely Financial Accounting, Cost Accounting, and Management Accounting.

How to operate Bank Ledger in Reconciliation mode using Tally ERP 9


As soon as we select a Bank Ledger for reconciliation we can see the screen transforms to Reconciliation Mode with a different format than the regular Account Ledger format. There we can see the range of date (period) between what dates we are going to reconcile the bank account in Tally ERP 9, and the Voucher Entries. And we will be seeing a Blank Column enables to enter the Date. So, start reconciling our SBI Bank Ledger.

How to reconcile Bank Ledger in Tally ERP 9
Reconciling SBI Bank Ledger in Tally.ERP 9

First change Period for which date range you are Reconciling the Bank Ledger in Tally ERP 9. Take the Bank Statement or Passbook and look at the first entry in the Bank Passbook and keep focus on concerned Voucher Entry in Bank Reconciliation in Tally just enter the date of the transaction took place at bank in Bank Date column in the Bank Reconciliation screen.

For instance I have recorded Cash Deposit of Rs. 45,000/- on 9th of April 2014 in Tally but in Bank Pass book it recorded on 10th day. So, in the Bank Reconciliation screen i just type the 10-04-2014 date in the Bank Date column for the concerned voucher entry. Press Enter Key to move to the next record and repeat the same thing for all the Voucher Records in Tally. If you want to move to the previous record you can use the Up Arrow Key for moving to the next record use the Down Arrow Key in the keyboard.

After you have done all the record in the screen save the screen. And, once again check the Bank Ledger in Reconcile Mode at the end of the statement you can see the Balance as per Company Book and Balance as per Bank will be same if you are corrected reconciled your Bank Ledger in Tally if you find any deviation just re check the Passbook with your Bank Ledger in Reconciliation mode.

How to generate Cash Ledger Report holding at CDSC in AP CTD website


In order to obtain the Statutory Forms from the Commercial Tax Department, our Dealer Account must have the required Credit Balance at the Computerized Dealer Service Center(CDSC) to request for various Statutory Forms likes C Forms, F Forms, H Forms. Way Bills, etc.,

How to generate Cash Ledger statement in AP Commercial Tax Department
Cash Ledger statement generated in AP Commercial Tax Department website

If you are first time going to request for Statutory Forms online then you must sent a DD to CDSC to credit your account for obtaining the Statutory Forms. Otherwise you can check the available balance for requesting statutory forms using your available credit balance. If there is sufficient funds available for obtaining the forms, then you can go to upload the Template File to obtain the Forms otherwise add funds to your account.

So, let us see the how we can generate the Cash Ledger Report, where we can see the charged amount for various Statutory Forms requested and received as well the Cash deposited into the CDSC Account for obtaining the various statutory forms.

  1. Login to your eReturns portal of AP Commercial Tax Department with TIN number and password.
  2. In your Dealer Account just keep your mouse on Report menu.
  3. In the drop down menu click on Form and Waybills sub menu.
  4. And choose Cash Ledger.
    • In the Cash Ledger Report screen choose the date range for From Date and To Dates and click on Submit button.

Then you can see the Cash Ledger statement pertaining to that particular period. There you can see the transactions occurred in your Cash statement as well as the available Cash Balance for requesting the various Statutory Forms.

Tally software updates for Telangana state with Release 4.9


As on 2nd June the Andhra Pradesh state has been divided into residual Andhra Pradesh state and Telangana state. All the Statutory and Accounting methods for State Taxation are also need to be maintained as per the Rules and Acts of the corresponding states. In connection with that Tally ERP 9 Accounting Software has also updated its software design.

How to change a Company State to Telangana in Tally ERP 9 Software.
Selecting Telangana state in Company creation screen in Tally ERP 9

Here with Release 4.9, Tally Software has added the newly formed state Telangana in its software for the comfort of the Tally users.

So, just install the latest Release 4.9 or above to avail off this feature. If you have a licensed version and having Tally.Net Subscription validity then simply upgrade your software without downloading and installing the latest version.

If you have a company already created then you alter it in order to change your State in which your company resides. For Andhra Pradesh state you do not need to change your State but in case of Telangana you have to change it to Telangana State as the Statutory things will update.

How to select Telangana State for a Ledger in Tally
Selecting Telangana state for a Ledger in Tally.ERP 9

If you have the suppliers and customers located in Telangana state then you can change their state to Telangana in the corresponding Accounting Masters like Ledger, which you can find in the above picture.

How to activate Android Device Manager for Smart Phone or Tablet


We can locate, and lock our Android device if we have lost it. And even we can erase the data stored in our lost Smart Phone or Tablet device remotely using the Android Device Manager in Google Play Account. In order to lock your device and erase the date, we need to activate the Android Device Manager in your device, apart other Device Managers supported by the Device Manufacture.

How to Activate Android Device Manager in your Phone Remotely using Google Play
Lock and Erase options for your Android Device is activating remotely

As i already told you that you need to have a Google Account and that should be added to your Android Device to secure your Device from thefts. And after that you need to configure your Device Settings to allow the Android Device Manager to access your Device. And you can change the settings of your Device either using your Device or from your Android Device Manager page itself.

Activate Android Device Manager through settings in your your Android Device

In order to activate Android Device Manager in your Android Device either it is Smart Phone or Tablet.

How to activate Android Device Manager in your Smart Phone
Android Device Manager is Activate in Device Settings
The settings are demonstrated for Motorola Smart Phone model Moto E for other android device models the settings would change slightly.
  1. Open your device Settings, which you can find under Apps or Widgets or some other location in your Device.
  2. Scroll down to the Security option and open it.
  3. Find the Device Administrator or such a similar option in the Security screen and open it.
  4. Here activate the Android Device Manager option.

Enable Lock your Android Device and Erase data options remotely.

Apart that even you can change your device settings directly from your Android Device Manager page itself and here we see how we can do that remotely from Google Play Account.

  1. Sign in to your Google Play Account.
  2. Click on Gear Icon on top right corner and choose the the Android Device Manager option from the drop down list.
  3. A new page asks to to login once again to your Google Account just login.
  4. There click on Enable Lock & Erase option.

Your Android Device Manager will be activated in your Mobile Phone remotely. If you open the Device Manager in your Smart Phone Settings you can find that the option is activated.

How to remove Custom Domain Address for your Blog in Blogger


Blogger allows the publishers to redirect their Blog Address to a Custom Domain URL and, as well the Blogger makes it possible to remove the third party URL for their blog if they do not wish to continue to point their Custom Domain Address to their Blog Address.

How to remove custom domain address for your blog.
Removing the Third Party URL in Blogger

After you have pointed the third party domain address to your blog address in the Settings page we can revert back our Blog to the original blog address aftermath, in case if we have not renewed Domain Address.

Just open your Blog Address in your account

  1. Get to the Settings page of your Blog.
  2. Scroll to the Publishing section in the page.
  3. Just click the Cancel (x) icon next to the Edit link.

Now try to open your original Blog Address like myblog.blogspot.in instead of your custom domain url like www.accountsguy.net. Earlier when you type your Blog Address i.e. myblog.blogspot.in it was redirecting to your Custom Domain URL, but now it will not redirect to your custom domain url as you removed it.