Skip to Article Skip to Youtube

Completed Quarter wise C Form Utilisation Files.


You might have searching about the C Form uitlisation Template File some sample files that already done without mistakes. Here i have gathered my work and put in a single place for all the 4 quarters along with the Empty Template file. You can download the files from my Sharing Files List.

Complete C Form Utilization Template File Collection from AccountsGuy.Net
Download the empty and completed C Form Utilization Template File Collection from AccountsGuy.Net

You can find the complete bunch of files in our online directory which includes 4 Quarterscompleted files and an Empty uitlisation File. You are not required to login to download.

Download single file from C Form Utilization Template File Collection Screen Download the file after it has been opened in the Google Drive

After you have opened the file in bottom corner you can find the Download button just click that and save the file in your computer. You can learn about the C Form uitlisation Template file and know even some useful tips that helps you to complete the file.

How to rectify C Form Utilization File uploading errors?


In order to prepare the C Form Utilisation Template File we have to following the guidelines of the Excel Template file. If the data is not feed as per the rules of the Excel file it can not be uploaded to the CDSC at e-Returns Portal of Andhra Pradesh Commercial Tax website.

How to rectify C Form Utilization File uploading errors?
Rectifying Uploading Errors while Uploading C Form Utilization Template File

Some of the rules of the C Form Utilisation Template Files are Date and TIN Number formats. In some other cases we will be in dilemma when we do not have the exact information about Transportation, Commodity details like no vehicle number provided, no transporter name given.

You would get some problems while attempted to upload the Template file and here I have written some points to keep in mind while preparing the C Form Utilisation Template File.

Never change pre-defined content in the C Form Utilisation Template File

You are not allowed to change any content that is already present in the C Form Utilization Template file that you have downloaded. If any changes are done it will not be processed by the website but you can change the name of the file. By default the file name will be C_Form_Utilization_Template and you can change it to as you wish like Raj and Co., - Q1 (2012).

Trying to enter TIN number starts with zero in the C Form Utilsation Template File

When you enter the Supplier TIN number in Seller TIN column that starts with zero (0) the starting zero will be removed. Every TIN number must consist of only 11 digits is should neither exceed nor reduce. In that case enter the TIN number preceding with a Single Quotation ( ' ) special character from the keyboard and don't enter 2 single quotations.

Only select from list when comes to the List Cells

In the case of Quarter and Commodities you are not advised to enter your own matter instead you are strictly advised to select the matter from the List.

TIN number is of Head Office and Invoice received from Branch

In that case you are simply advised to type whatever the address printed in the place of Seller irrespective of the Head Office address.

I have written few of the tips to prepare the C Form Utilisation Template File if you are having any additional you can share it in the Comment section.

How to download and prepare C Form Utilisation Template Excel File?


In order to request for the Statutory C Forms the VAT Dealer must submit the CST Purchases against C Form details through a C Form Template excel file at VAT Dealer e-Returns portal of Andhra Pradesh Commercial Tax Department website. In the file the VAT Dealer must mention the invoice details quarter wise in a Year.

How to download and prepare C Form Utilisation Template Excel File?
Download Utilisation Template File

As and when you have the sufficient balance in your VAT Dealer Account for obtaining the Online Statutory Forms you can upload the C Form Utilization file in the e-Returns Portal of the VAT Dealer which contains the details of CST Purchase details.

So, the VAT Dealer has to download the C Form Template File and prepare the Template File. There are numerous websites showing the links to download the Utilization Template file but it is recommended to download the Utilization Template file directly from the Commercial Taxes Department website.

And here I am demoing you the process of downloading the C-Form Utilization Template file.

  1. Login to your e-Returns Portal
  2. Put the cursor over CDSC Help/Templates.
  3. And click on C Form Template and save the file in your Computer Hard Disk or any Removable Storage devise.

In order to fill the Utilization Template file keep all the Inter-State Purchases Against Form-C invoices with you and open the C Form Utilization file downloaded earlier. On the top left corner in that Excel file you can find Purchaser TIN for that enter your TIN number. For Quarter select the corresponding range of months from the list. And for Year enter the year of invoicing mentioned in the collected Invoices. After that you need to record each invoice in a new row.

Completed C Form Utililzation Template File Image
C Form Utilization Template File
  1. SL.No must start with 1 and should be increased by 1 for every new record.
  2. Type the supplier details like TIN Number, Name, and Addresss in the corresponding columns.
  3. Enter the transportation details like Vehicle No and Transporter Name in the subsequent columns.
  4. Later furnish the Invoice Number and Date of Invoice.
  5. Select the Commodity and Units of Measurement from the list and enter total Quantity of the products and Value of the Invoice.

While updating the Utilization file keep in mind the formats of Purchaser TIN, Seller TIN, Invoice Date, Quantity and Value. We have a list of completed each Quarter file download links in C Form Utilization Template File Collection. And this is how to download and prepare the C Form Template Files from Andhra Pradesh Commercial Tax Department website.

Why CDSC of AP Commercial Tax rejects your DD for issuing Online Statutory Forms?


The Computerized Dealer Service Center (CDSC) of Commercial Taxes Department of Andhra Pradesh state might reject your Demand Draft for issuing the Online Statutory Forms if any mistakes are found in the DD.

Most of the Public Sector Banks are employing the in-experienced candidates in the major posts. They might do mistake while preparing Demand Draft. Hence, the erroneous DD will simply be sent back to your address without sending for clearance by the Manager, CDSC O/o CTO, Hyderabad if any mistake is found in the Demand Draft that you send to the Manager, CDSC.

In my experience i have seen the following mistakes done by the bankers in discarding their duty while preparing Demand Draft.

  1. In favour of Name should be printed as Commissioner (CT), Hyderabad or Commissioner CT, Hyderabad on DD they might print like this Commissioner (CT Hyderabad or Commissioner (CT).
  2. Banker Stamp would be missing on DD. Along with the signature of authorized person it must be stamped with his name and employee code.
  3. Check whether there is any spelling mistake in Infavour Of place.
  4. Is the amount payable exactly 1,000 or multiplies of thousands.
  5. That DD must be payable at Hyderabad only.
  6. And finally check the signature of the Authorized Person who issued the DD and Banker Stamp as i said in the second point of my experience.

Scrutinize a DD after it has been Drafted by the Banker

Precaution is better than cure so, be careful while taking the DD. So, verify all the Details are correct in the Demand Draft and see the Details in the Letter that you have enclosed to while sending to the CDSC.

How to check the CDSC Balance to request for Statutory Forms?


The Computerized Dealer Service Center (CDSC) will credit the DD realized amount to the corresponding VAT Dealer account at e-Returns portal after the complete process is completed from their side and the same will be shown under Form Request in CDSC submenu.

How to check the CDSC Balance to request for Statutory Forms?
Balance at CDSC

In order to see the available balance for requesting the Statutory Forms login to VAT Dealer e-Returns portal and do the following steps to check the available balance for obtaining the Statutory Forms.

  1. Click on Form Request in CDSC sub menu under CDSC/EDSC menu in top of the screen.
  2. Then you will see the WAYBILLS/STATUATORY FORM REQUEST screen.
  3. In the screen you can see the Available Balance which is pointed in the above image.

If you have send a DD for obtaining the Statutory Forms through Online you will find the available balance there. If the balance is zero you have to send the e-mail to the CDSC for crediting the DD amount to your Dealer Account. And this is how to check the balance to request for Statutory Forms from AP Commercial Tax Department website.

How to take Online Statutory Forms from AP Commercial Tax website?


The process of obtaining the Statutory Forms like CST Way Bills, VAT Way Bills, and C, H, F Forms has been simplified by the Commercial Tax Department of Andhra Pradesh State. The Dealers are not required to visit their local CTO for these Statutory Forms. You can get them on 24x7 days in every month and every year.

How to take Online Statutory Forms from AP Commercial Tax website?
Online Statutory Forms from VAT Dealer e-Retnrs Portal

In Andhra Pradesh state we can obtain the Statutory Forms through online in two different ways. First is at a Free of Cost Statutory Forms and second one is on Chargeable Statutory Forms.

How to obtain Free of Cost Statutory Forms from AP VAT Dealer Account?

Obtaining the Free of Cost Statutory Forms are the easiest and simple. We can obtain these forms directly from your computer after submitting the suitable information from the VAT Dealer Account at e-Returns Portal. Using the CREATE E WAYBILLS/C, F FORMS sub menu under e-WayBills/C, F Forms menu the VAT Dealer can take the Print out the Statutory Forms.

How to obtain Chargeable Statutory Forms from AP VAT Dealer Account?

This is a different way of obtaining the Statutory Forms. If the VAT Dealer is required to submit the bulk information to obtain the Statutory Forms this is the best method at low cost. The Statutory Forms will be sent to the Dealer Business address through Post or Courier. This process is completely based on Internet.

For obtaining the Statutory Forms from the CTO website without contacting the local CT authority you need to send DD of minimum Rs. 1,000/- or multiplies of Rs. 1,000. If your estimated Statutory Forms cost more than Rs. 1,000/- then you need to send 1,000 x 2 i.e. Rs. 2,000/- like wise 1,000 x 3, 4, 5 based on your requirement. And the DD must be drafted in favour of Commissioner (CT), Hyderabad and payable at Hyderabad only.

After drawn the DD just write a formal letter to Manager CDSC, O/o of Commissioner, CT, Hyderabad. and the content must like requesting them to activate your TIN number for obtaining the Statutory Forms through online or download the Letter of Application for Statutory Forms enabling through Online and fill the missing content with your information and take print out in A4 paper.

Before sending the DD along with the Request Letter verify the details and take the Photostat copies of the DD and Request Letter after signing. Sent them to the following address through Post or Courier.

Manager CDSC,

O/o of Commissioner, CT,

CT Complex,

MJ Road Nampally,Hyderabad.

Keep the photostat copies and the Courier slip under your safe custody. Check the status of the Courier of Post through Online Tracking System whether has been delivered or not. And write an e-mail to CDSC by mentioning your DD number and TIN Number. After 3 to 4 days your account will be activated for obtaining the Statutory Form.

After a couple of days verify your balance at WAYBILLS/STATUATORY FORM REQUEST page in your Dealer Account at AP Commercial Tax website. If the available balance is zero once again e-mail to CDSC regarding the issue. And this is the way how we can activate our TIN number for obtaining the Statutory Forms through online. Still facing problem contact us and we will do this job on behalf of you.

Submitting Purchases, Sales, and Returns Details to Commercial Tax in A.P.


This is the first step in the process of submitting the Monthly VAT Returns in Andhra Pradesh state Commercial Tax Department website. And this procedure is called as Invoice Tracking System and started in April 2015 and made it mandatory on June 2015 onwards in Andhra Pradesh state.

Submitting Purchases, Sales, and Returns Details to Commercial Tax in A.P.

In the Invoice Tracking System every VAT Dealer has to submit the Purchases, Sales, Purchase Returns and Sales Returns details electronically by logging into their VAT Dealer Account before they submit their monthly VAT Returns. Here Purchase details are called as Annexure I and Sales details are called as Annexure II. The VAT Dealer must keep the following points while preparing the Annexure I and Annexure II Excel Template files.

  1. The VAT Dealer has to submit the Purchases from VAT Dealers and the Sales made to the VAT Dealers within Andhra Pradesh state only.
  2. The VAT Dealer should not submit the Purchases from outside the Andhra Pradesh state and the Sales made to the outside the state.
  3. The VAT Dealer should not submit the Cash Sales and Cash Purchases
  4. The VAT Dealer should not submit the Purchase from TOT Dealers and Sales to TOT Dealers.

How to Download the Purchases, Sales, Purchase Returns and Sales Returns Excel Template files

The Commercial Tax Department has designed the Excel Template files for preparing the Purchases, Sales, Purchase Returns and Sales Returns details and every VAT Dealer has to fill the template files with the purchase, sales, and returns details. In the VAT Dealer account four different sets of Template Files will be available for Purchases, Sales, Purchase Return and Sales Returns.

In order to download the Excel Template Files login to your VAT Dealer account from AP Commercial tax e-Return portal.

  1. In the Home screen of the VAT Dealer Account click on Returns menu.
  2. In order to download the Annexure I Excel Template file click on Upload Purchase Details sub menu.
  3. And click on Download template for Purchases hyperlink and save the Purchases Excel Template file in your Computer System.
  4. In order to download the Annexure II Excel Template file click on Upload Sales Details sub menu and click on Download template for Sales hyperlink and save the Sales Excel Template file in your Computer System.
  5. For Purchase Returns and Sales Returns you will be having the sub menu available for the template files.

How to fill up the Purchases, Sales, Purchase Returns and Sales Returns Excel Template files

In order to fill up the Purchases details just open the Purchases Excel Template file downloaded from the e-Returns portal.

  1. Enter your TIN Number and Choose the month of VAT Return from the list of Months and enter the Year of the VAT Return.
  2. After that you have to record the Purchase details like TIN number of the seller, Invoice Number, Date of Invoice, amount of Invoice (Including VAT), Commodity, and VAT Tax percent.
  3. Provide the serial numbers starting from 1 and increase every record by 1.

So you have to provide the invoice details followed by a serial number. And for Sales, Purchase Returns and Sales Returns also you have to follow the same procedure but you have to open corresponding Excel Template files downloaded from the e-Returns portal.

How to upload the Purchases, Sales, Purchase Returns and Sales Returns details in VAT e-Returns Portal

After we have prepared the Purchases, Sales, Purchase Returns and Sales Returns Template files the VAT Dealer have to upload them from the VAT Dealer Account. In order to upload the Purchase details login to your VAT Dealer account from AP Commercial tax e-Return portal.

  1. In the Home screen of the VAT Dealer Account click on Returns menu.
  2. In order to upload Annexure I Excel Template file click on Upload Purchase Details sub menu.
  3. Click on Choose File button and select the prepared Purchases Excel Template file from your Computer.
  4. And click on Upload button and click on Yes button to submit the Purchase details.

Now you have uploaded the Purchases details in order to upload the Sales Template file

  1. In the Home screen of the VAT Dealer Account click on Returns menu.
  2. In order to upload Annexure II Excel Template file click on Upload Sales Details sub menu.
  3. Click on Choose File button and select the prepared Sales Excel Template file from your Computer.
  4. And click on Upload button and click on Yes button to submit the Sales details.

You can follow the same procedure for uploading the Purchase Returns and Sales Returns Template files but you have to choose the Upload Purchase Returns Details sub menu to upload the Purchase Returns Template File and Upload Sale Returns Details sub menu to upload the Sales Returns Template File under Returns menu. And the rest of the procedure is as same as in the case Purchase Uploading.

How to confirm the Purchases and Sales details in VAT e-Returns Portal

Now all the Purchases, Sales, Purchase Returns and Sales Returns details are uploaded and the next step is to confirm the uploaded details. In order to confirm the Purchases details login to your VAT Dealer account from AP Commercial tax e-Return portal.

  1. To confirm the uploaded Annexure I and Annexure II files click on Returns menu and choose the Confirm Invoice Details sub menu.
  2. In the Confirm Invoice Details screen select the month for which you are confirming the Annexure details and Choose Purchases for Invoice Type and click on Get Details button.
  3. If you find the List of Invoice details under Mismatch section rectify them before you confirm otherwise click on Confirm Invoice details button.

For the confirming the Sales also do the same procedure but choose the Sales under Invoice Type. Now both the Purchases and Sales details are confirmed. And this is the procedure of preparing and submitting the Invoice Details to the Commercial Tax Department in Andhra Pradesh State.

Who is Sundry Creditor in the Balance Sheet as per Accounts?


The term Creditor is commonly used word in Accounting, and Finance field. In general practice the word Creditor is used as Supplier, Owner, Lender etc., A Creditor is also referred in Trading, Business prospects. It might be either living entity like a Proprietor or a corporate sector like a Private Limited Company or Multi National Company.

What does mean by Creditor as per Accounts?
Creditor

Sundry Creditor is mostly used to represent the financial information about the supplier, or service providers. Whenever you get something from a person, or organization then he will become as a Creditor when he do not get something in return for the transaction on the spot.

When an organization or a person sells either services or goods to his customer on credit bases then he will be treated as Creditor in the business transaction.

Or

When a person lends money to a person that lender will be treated as Creditor in the view of the borrower.

In the Financial world term Creditor is very frequently used, especially in reference to Loans, Bonds, and Mortgages. It derives from the notion of credit. In past, it was also referred to reputation or trustworthiness.

Sundry Creditor is a Liability for the Company as the Firm owes to the outside person as the firm utilizes the other services or purchased something on credit. Then he will be the Creditor and List of Creditors will be shown as Sundry Creditors in the Balance Sheet under Liabilities.

How to learn Tally.ERP 9 without purchasing the License?


Tally.ERP 9 Software has come up with two different modes such as Licensed and Education. Whoever wants to learn Tally.ERP 9 Software can use the Educational version without purchasing the Serial Number.

How to learn Tally.ERP 9 without purchasing the License?
Operating Tally.ERP 9 in Education Mode

Education Mode is a non-licensed version of Tally.ERP 9, using which you can learn almost all Tally.ERP 9 Features. It is highly cost effective for all to learn Tally ERP in Licensed Version. So, Tally Solutions has released its software package with Educational mode as well. To learn in Educational Mode you do not need to either Rent or Purchase Serial Number of Tally.ERP 9 Software.

Education mode allows you to make Voucher Entry only on 1, 2 and 31 of every month. So, you can not make Voucher Entries for ending date of April 30, June 30, September 30, November 30, and February 28 or 29, as they do not have 31 as their ending date.

First you need to get Install Tally.ERP 9 Latest Release in your computer, just follow the following instructions.

In order to work in Education Mode open Tally.ERP 9 Application.

  1. In the Startup screen select on W: Work in Educational Mode.
  2. Tally Software provides Single User and Multi User accessing feature to your Companies. Just click on I : Silver Education Mode (Single User).
  3. I will write about Gold Education Mode (Unlimited Multi-User) upon your request.

Now you can create a Company and start Recording Account in Tally.ERP 9 using Educational Mode. And this is how to work with Tally.ERP 9 in Education Mode.

How to update Tally.ERP 9 with latest Statutory Updates?


With the co-operation of various States, Territories and Central Government Taxation Departments Tally Solutions Team updates the Tally.ERP 9 Accounting Software with latest Statutory Forms to submit through Electronic Filing System and generating the Statutory Reports like Monthly VAT Returns Form 200 in case Andhra Pradesh State.

How to Update Tally.ERP 9 with latest Statutory Updates?
Update Stat.900 in Tally.ERP 9

Whenever an amendment is made for Taxation irrespective of the State and Territory, Country; Tally Solutions will in first place to give updates to its users with the new Statutory Updates. The Tally Subscribers can update their Tally.ERP 9 Software by just downloading the State.900 file from the Tally Solutions official website at free of cost. Even the Education Mode users can also update Free Version of the Software with the latest statutory updates.

The Statutory file named Stat.900 contains information about Direct Taxes like Service Tax, Income Tax and Indirect Taxes like Value Added Tax (VAT) etc., For Taxation updates you need to update the Stat.900 file. Here Stat is the name of the file and the extension of the file is 900. As the most of the Tally Users are of small Entrepreneurs, Accountants and Auditors, they need the updated software for Accounts. Hence, Tally Solutions think about them and designed the software to show the latest update whenever available.

Stat.900 file will be located in the directory where you have installed Tally.ERP 9 SoftwareStat.900 file is a type of 900 which can be recognized by Tally.ERP 9 only.

How to know the available latest version of Statutory File for Tally.ERP 9?

If there is any latest version of Stat File is available for the Tally.ERP 9 Accounting Software we can know the alert it from the Software itself if we have the Internet connection. In order to know the alert open the Tally.ERP 9

  1. Look at the bottom of the Gateway of Tally screen.
  2. Find the Configuration Pane in the Information Pane.
  3. You can point out something like State xxx (Stat 239).
  4. If there is an update available beside that you can see the Number available like 184 available.
  5. Just click on that you can get the download location of the file or click here to get the file.
  6. Scroll down to the Statutory files for Tally.ERP 9 Series A Release. and download the Statutory Masters Version file to your Computer Desktop.
  7. Just copy Stat file from Desktop and paste it in the Tally ERP 9 software installed location.

And this is how to update the Tax related in components in Tally.ERP 9 by downloading the Stat.900 file in your Tally.ERP 9 installed Disk Drive.

How to learn Shortcut Keys in Tally.ERP 9 for faster working?


Knowing the Shortcut Keys of a Computer Software is very important for the Operator. Likewise, Tally.ERP 9 is also having the Shortcut Keys. If the User is familiar with the Shortcut Keyes in Tally work will be finished faster than before.

How to learn Shortcut Keys in Tally.ERP 9 for faster working?

Tally.ERP 9 has been designed to smooth functioning of accounting. In further to fasten the working with the software Tally Solutions has provided the shortcut ways to operate the software. Hence, Shortcut Keys are being classified according to the kinds of Keys like Function Keys, Special Keys, and Function Keys with Combination of ALT/CTR for switching between different reports, screens, vouchers, etc..

Here instead of listing out all the Shortcut Keys, i have classified for better understanding them.

Working with Function Keys (F1, F2, F3 ... F12) in Tally.ERP 9

These Shortcut methods will help you in the selection process of Companies, Different Kinds of Vouchers like Purchase, Sales, Receipt, Payment and Journal; as well to Configure the Tally.ERP 9 Application Software and to Set the Features of a Company.

Working with Special Keys (ALT, CTRL, Space bar, Alphabets, and Numerical) in Tally.ERP 9

Apart from Function Keys you can use the Alphabets or Numbers with combination of ALT (Alternate) or CTRL (Control) Keys for selection, addition, deletion, alteration, duplication of Ledger, Vouchers, Entries and much more.

Shortcut Keys in Tally ERP9 - Working with Function Keys with combination of ALT and/or CTRL Keys

As in the case of the Special Keys you can use the Function key with Combination of ALT and/or CTRL keys for performing special tasks like Displaying the Summary Report of the Stock Items, Ledger Statement with complete details regarding each and every transaction like Bank Details of Receipts and Payments, Inventory details of Purchases or Sales.

Shortcut Keys in Tally ERP 9 - Keys for Navigating the Screen

And finally there are some other keys which are not mentioned above these are used to navigate the user across the screens like moving to the next voucher in the Day Book or likewise collapsing the detailed view etc.,

These are the complete list of Shortcut Keys in Tally.ERP 9 if you discover any new Shortcut Keys you can share them with the readers by commenting in this article.

What is Table Search and Contains With Search in Tally.ERP 9?


Tally.ERP 9 Accounting Software having the Search Facility to enable the user to filter the Ledgers, Groups, Inventory, Voucher Types etc., When the user enter a text in the field for the selection of an item from the list he will get a filtered list based on his text entered in field using the Starts With or Contains With Search functionality.

What is Table Search and Contains With Search in Tally.ERP 9?
Enabling Contains With Search in Tally.ERP 9

Every Application Software will be having the search functionality built by default. It is common requirement of every software user which will help him to find out the exact or something closer to the required information from the entire content.

Tally Solutions Pvt. Ltd., has implemented the Search functionality in the name of Table Search, where the required data will be highlighted to the user based on the text and searching method that he configured in his Tally.ERP 9 Software.

What is Table in Tally.ERP 9?

Table, it is just a technical word used in Tally.ERP 9 to refer a List of Companies, Ledgers, Inventory Items, Unit of Measurements etc., which are displayed while you enter some text in the field in any screen of Tally.ERP 9 Software for which you would have some option.

What is Table Search in Tally.ERP 9?

Table Search is nothing but to select or identify a specific Company, Ledger, Stock Item or anything in the Table (list) of Ledgers, Stock Items or anything by entering some part of Ledger or Stock Item Name.

How many Table Search methods are available in Tally.ERP 9?

Tally.ERP 9 has come up with two different methods of Searching for Masters and Vouchers and they are Starts With Search and Contains With Search methods and let us see them in details.

Table Search will be displayed based on the Text entered.
Table Search displayed when selecting a Group for the Ledger

What is Starts With Search in Tally.ERP 9?

This is the default and is available since the oldest versions of the Tally.ERP 9 Accounting Software. Here the user can see a specific list of Masters such as Ledgers, Stock Items, etc. by entering the beginning letters of the Masters. Here remembering the beginning letter of the Masters is complicated for the user in the large scale business dealings. Hence Tally.ERP 9 has introduced another Search method called Contains With Search. And let use us see about it.

What is Contains With Search in Tally.ERP 9?

Contains With Search option enables the user to find out a Master by entering any piece of word of the Master name irrespective of the position of the Searching Word in the entire Name. Management would ask you about a particular Ledger name which contains word “Kurnool”. You can not expect that in the beginning for your search. Hence you need to use the advanced search option Contains Search.

How to configure Contains with Search in Tally.ERP 9?

In order to configure the Contains with Search in Tally.ERP 9 click on F12: Configure Button in Button Area

  1. From the Configuration Menu click on General option.
  2. Get to the Table Configuration section in the General Configuration screen.
  3. Set Yes for User ‘Reducing List’ for Tables field.
  4. Here you have another advantage that you can search the Stock Item by its Quantity instead of the Stock Item Name. For that you need to set as Yes for Apply for all Columns field.

And this is the all about Table Search in Tally.ERP 9 and how we can configure the Contains With Search in Tally.ERP 9 Accounting Software.

How to change Ledger setting and information in Tally.ERP 9?


After a Ledger has been created in a Company the user can change the settings or add some information about the Ledger in Tally.ERP 9. If there is no Voucher Entry found in the Ledger Account Statement the user can delete the entire Ledger from the Company.

How to change Ledger setting and information in Tally.ERP 9?
Alter Ledger in Tally.ERP 9

When a Ledger is created it will be having the Name, Aliases, Advance settings, Notes, Address, and Other Information and after it has been created we can change them including the Name of the Ledger in Tally.ERP 9.

For changing the information about a ledger we have to Alter the Ledger. In Tally.ERP 9 we can use the Ledger Alteration screen to change information of a ledger. Here let us change the Bank Details of Karnataka Bank OD Account Ledger in AccontsGuy.Net Company.

  1. Select Accounts Info under Master from Gateway of Tally screen.
  2. Choose Ledgers.
  3. Click on Alter option under Single Ledger then you will see the List of Accounts, just choose a Ledger from the list.

You will see the Ledger Alteration screen here you can change anything link Name of the Ledger or Bank Mailing Details, and Bank Details. After changing the information come to the last field and save the screen. And this is how to change a Ledger information in Tally.ERP 9.

How to create Simple and Compound Units in Tally.ERP 9?


In Tally.ERP 9 Inventory Software we have to create the Units to measure the Stock Items in the Books of a Company and the software allows us to create Simple Units for normal counting and Compound Units for complicated Stock Items calculation.

Image : Simple Unit for Inventory Creation in Tally ERP 9
Simple Unit creation in Tally.ERP 9

When we record the Purchases or Sales in the Tally.ERP 9 with Stock Items we can generate the Stock Summary Report and there we can measure the Stock Items with the help of Units that we assigned to the Stock Items.

In Tally.ERP 9 Stock Item can be measured in terms of weight, length or something else. For instance, there is a holding stock of 30 numbers of Long Notebooks. So, here we are going to create such a measurement. For Units creation

  1. Choose Inventory Info option in Gateway of Tally screen.
  2. There select Units of Measure.
  3. Select Create option.

And here we can create either Simple Unit or Compound Unit. In order to create Compound Unit at least two Units must be available.

How to create Simple Unit in Tally.ERP 9?

By default you will be creating the Single Type of Unit in Tally. If you see Compound in the field Type, just change that option to Simple.

  1. Give a name for the Symbol like Nos., Kgs, or Ltrs (40 Nos.).
  2. If required give a Formal Name for the symbol like Numbers, Kilograms, or Liters.
  3. If you want to have decimal number for the measurement to count then give number for the decimals like 1, or 2 (0.50 Kgs or 0.5 Kgs).

And accept the screen to save the changes.

How to create Compound Unit in Tally.ERP 9?

Tally.ERP 9 allows you to create a Compound Unit by using the two different Simple Units that you have created earlier. And here let us create a Compound Unit for measuring Packets (Pkts) where each packet contains 450 Grams weight. So, first we need to create Simple Units Pkts and Grams and after that just select Compound option in the field Type in the Unit Creation screen.

  1. For the First Unit select a Unit from the list example Pkts (Packets).
  2. For the Conversion enter the numbers that make the First Unit from the Second Unit example 450.
  3. For the Second Unit select a unit from the list like Kgs (Kilograms).

Hence, here we have created a Compound Unit for a Stock Item where 1 Packet contains 450 Grams. And this how to create Simple and Compound Units in Tally.ERP 9!

How to create Groups and Displaying the List of Groups in Tally.ERP 9?


Tally.ERP 9 will be having the 28 pre-defined Primary and Sub-Groups, out of which 15 are Primary Groups and 13 are Sub-Groups. Apart that we can create our own set of Groups using the Group Creation screen.

Summary of List of User defined groups in Tally ERP 9.
Closing Balances of Customized Groups in Tally.ERP 9

In Tally ERP 9 there are two kinds of Groups for Ledgers. The first one is Pre-Defined or Default Groups for Ledgers which are ready-made. We can neither delete nor change its Group, but we can alter all the options including the Name of the group except Group Head. With my practical knowledge i am telling you that do not try to alter the name of the default Group/s.

And the Second one is User-Defined Groups which are created by the user based on his requirement to show in the Financial Statements. In Tally.ERP 9 there is no limit for creating the User-Defined Groups for Ledgers.

How to Create User-Defined Group in Tally.ERP 9

Here Mr. K Venkkatesh works as an accountant for AccountsGuy.Net. He has to generate the outstanding payable to Seed Suppliers, Packing Material Suppliers, Seed Testing Laboratory companies repeatedly. By creating the Customized Groups we can get such reports.

In order to create the Group open Tally ERP 9 and select the Company for which you want to create Group for a Ledger.

  1. Select Accounts Info under Masters from Gateway of Tally.
  2. Click on Groups and finally select Create under Single Groups.
  3. Give name for the Group and select the Accounting Head of the Group,
Creating User Defined Group in Tally ERP 9 under Sundry Creditors
Group Creation in Tally.ERP 9

How to Display the Groups in Tally.ERP 9

Below you can see the final output of the Customized Groups in Tally.ERP 9. And let us see how to Display the List of Groups available in the Company in Tally.ERP 9. Get back to the Gateway of Tally screen.

  1. Select Display under Reports.
  2. And click on List of Accounts in the Display menu.
List View of Default Primary Groups, Sub Groups, and Ledgers in Tally ERP 9
List view of Ledgers and Groups in Tally.ERP 9

In the above screen the Italicized Names displayed in the Main Area of the Tally Window are the Ledgers, highlighted are the Sub Groups counting to 13 and names in bold not highlighted are the Primary Groups counting to 15. And this is how to create the Groups for Ledgers and listing the List of Groups in Tally.ERP 9.

Prerequisites for Installing Tally.ERP 9 Accounting Software.


There are some important things to be considered while installing Tally.ERP 9 Accounting Software in your Desktop Computer or Laptop. The user has to keep the check list before installing the Software.

Prerequisites for Installing Tally.ERP 9 Accounting Software.
Prerequisites to Install Tally.ERP 9

Before installing Tally ERP 9 Accounting Software you must know the few things. Tally.ERP 9 Application Software is a Platform dependent and it supports only Windows Operating System. As well computer must be configured with the following components so that you can install and work Tally ERP 9  without any trouble.

So, it is clear that Tally can not run in other than Windows platform, neither Linux nor in Unix Operation Systems (OS). If you are installing it in a single computer and that too operated by you only then it is not at all a problem for you to install. You can install on your own. If it is connected with other computers and having the Users only the Administrator of the Computer can install the Tally ERP Software as he bagged such installing permission.

There are two kinds of requirement in your computer.

  1. Hardware Requirements
  2. Software Requirements

Minimum Hardware Requirements for Installing Tally ERP Software

As per Hardware Requirements you do not need to bother unless your computer is manufactured in the year 2000 or above. If your computer is older consider the below hardware requirements.

  • Processor must be Intel Pentium IV or above.
  • Minimum memory capacity of ROM must be at least 256 MB and memory capacity of RAM 512 MB.
  • Free hard disk space must be at least 75MB (excluding data)
  • Monitor Resolution must be at least 800 x 600 but recommended is 1024 x 768 or higher.

Minimum Software Requirements for Installing Tally ERP Software

And come to the Operation System that is OS it can be only installed in single user operation system that too in Microsoft Windows Operating System.

  • Single User Tally ERP 9 can be installed in any one of the Microsoft Windows OS Versions those are Microsoft Windows 98/ME/NT/2000/2003/2008/XP/Vista.
  • Multi-User Tally ERP 9 you can only install the Tally License Server on Microsoft Windows NT/2000/2003/XP/Vista.

There are the important things the user has to consider and prepare before installing Tally.ERP 9.

What is Tax on Turnover (TOT) and how to apply for TOT Dealership?


Before the Value Added Tax(VAT), there was General Sales Tax(GST) in force and it was common to all business people irrespective of business turnover. But after the introduction of VAT it become as a complicated issue for small merchants to pay the Tax on Sales and to maintain the Books of Accounts.

What is Tax on Turnover (TOT) and how to apply for TOT Dealership?
Form VAT 001

As per the AP VAT Act 2005 on or after March 1, 2005 every Trader whose turnover exceeds Rs. 40 Lakh has to register as a VAT Dealer and he has to pay the tax on Sales and must maintain the Books of Accounts and other Records. And for those Traders whose turnover does not exceeds Rs. 40 Lakh are exempted from VAT purview.

The Commercial Tax Department not allowed to collect the VAT amount on Sales from such Traders instead they have introduced the Tax On Turnover which is termed as TOT and is a kind of Indirect Tax. Merchants whose turnover is in between Rs. 5 Lakh and Rs. 40 Lakh for the 12 months has to obtain the TOT Dealership Certificate from the concerned Commercial Tax Office. For this the Applicant has to complete the FORM TOT 001 and submit it to the concerned Commercial Tax Officer in his circle.

How to Register for TOT Certificate from Commercial Tax Department?

All the Merchants whose turnover exceeds Rs. 5 Lakh and does not exceeds Rs. 40 Laksh has to obtain the TOT Certificate from the Commercial Tax Department by submitting the Form TOT 001. It is mandatory to register as a TOT Dealer, if the turnover lies in between the above said amounts.

If the Trader is not applied for VAT Registration they will be issued by a Notification of General Registration as a TOT Dealer, provided your taxable turnover exceeds Rs. 5 Lakh but not Rs. 40 Lakh for 12 months after 31-12-14.

If you are applying for Registration as a TOT dealer under the APVAT Act 2005 on or after 1-4-2005, you must complete a simple application in form TOT 001 and take it to your Tax Office. You will receive a Notice of General Registration if your application is satisfactory.

There are some Obligations are framed for TOT Dealer

There some obligations framed by the APVAT Act 2005 for the TOT Dealers and the terms are jotted down.

  1. The TOT Dealer has to submit the summary report of his Turnover (Sales) each quarter to the Commercial Tax Department through e-Returns.
  2. After e-Returns quarterly the TOT Dealer has to pay the Tax either from Treasury Bank or through Online Payment System from Commercial Tax Department website for each quarter ending June, September, December, and March by the end of the following month.
  3. If, the TOT Dealers fails to file and pay the levy dealer will be charges with penalty and interest charges.
  4. The TOT Dealer is not allowed to claim the Input/Credit Taxes from the Purchase Invoices he made from the VAT Dealer.
  5. He is not authorized to issues TAX INVOICE.

And this about the Tax on Turnover (TOT) and how can a trader register for the TOT Dealership from Commercial Tax Department? And What the TOT Dealer has to do and not to do after obtaining the TOT Certificate.

What is Financial Year, Fiscal Year and Natural Business Year in Accounts?


In Accounting some terms will be having the Synonyms and likewise the Accounting Term Financial Year also having some words like Fiscal Year, Natural Business Year and we will be discussing more about it here.

What is Financial Year, Fiscal Year and Natural Business Year in Accounts?
Financial Year

As the word says Financial Year mean the information related to Money, or Moneys worth the term Financial or Budget Year refers information about the a complete year about financial information about a particular entity, organization or firm.

A Financial Year sometimes also called as Budget Year and it is a period of a Year or 12 consecutive Months or 52 to 53 consecutive Weeks or 355 to 356 consecutive Days of an organization's activities. And it is used for calculating annual Financial Statements and Taxation require such reports once per twelve consecutive months, but it is not mandatory that the period would be a Calendar Year i.e. 1 January to 31 December. It varied between business and countries. The Fiscal Year may also refer to the year used for Income Tax Reporting.

A Natural Business Year is a period of 12 consecutive months, terminating in a natural low point in the sales activity of a business. The natural business year is an ideal choice, Since the natural low point at the end of the period should coincide with a decline in the accounts receivable, accounts payable, and inventory that a business states in its accounting records.

The term Fiscal Year is associated with Companies having Financial Reporting year that do not end on December 31. And this is about some Financial Year terms explained in accounts and it would be an appreciation if you have any additional input provided in this connection in the comment section below.

How to record Trade Advances received from Customer in Tally.ERP 9?


In Tally.ERP 9 we can record the Advances received from Customer (Customer Advances/Trade Advances/Unearned Revenues) using the Receipt Voucher Type while recording the receipt from the Customer.

What is the Accounting Entry for Advances Received from Customers?

In the above Balance Sheet we have shown an amount of Rs. 25,000/- as Advances from Customers which shows the worth of the firm where as if you would have combined the amount with Sundry Creditor it shows the liability of the company to its suppliers which makes the bad effect on the balance sheet.

How to record the Advances from Customers in Tally.ERP 9

In Tally.ERP 9 Accounting Software we have to create the Customer Advances Ledger and some other people might give the name as Trade Advances or Unearned Revenues. After we have created the ledger using the Receipt Voucher Type we can record the Advances Received from Customers. While recording the receipts in Tally just Debit either Cash Ledger or Bank Ledger and Credit the Customer Ledger.

How to show the Customer Advances in Balance Sheet in Tally.ERP 9.

Showing the Customer Advances in the Balance Sheet is the most important thing which states the Financial Position of the firm. Do not venture to combine the Customer Advances with the Sundry Creditors under Current Liabilities on Liabilities side of Balance Sheet, then it states that the firm has a sum of liability to its suppliers.

The proper way of showing the Customer Advances in the Balance Sheet tells to the external people like bankers and financers as the goodwill of the company as it gets advances from its customers prior to the stock delivery or service.

In order to display the Balance Sheet Select the Company from the List of Companies

And there you can see the Customer Advances under the Liabilities in the Balance Sheet and this is how to record and display the Customer Advances in Tally.ERP 9.

How to create Customer Advances Ledger Account in Tally ERP 9?


Usually, Customer Advances are shown in the Balance Sheet of an enterprise to show the business efficiency. So, that firm will get good response from the Inventors and Bankers to attain the Short Term or Long Term Capital. We can create a Ledger Account for Customer Advances in Tally.ERP 9 Accounting Software.

How to create Customer Advances Ledger Account in Tally ERP 9?
Trade Advances Ledger in Tally.ERP 9

We have discussed more about the Customer Advance in Accounting Treatment for Advances Received from Customers post. You can create a ledger for such nature of transaction and can provide a suitable name for that like Advances from Customer, Received Advances, Unearned Revenues, or Trading Advances and you have to show it under the Current Liabilities.

Let us create the Ledger for Trading Advances in Tally ERP 9.In the Ledger Creation screen

  1. Enter the name of the ledger in Name field e.g., Customer Advances.
  2. If you want to give another name to the same field give it in Alias field e.g., Unearned Revenues.
  3. And select the Current Liabilities from the List of Groups for Under field.

Finally, accept the screen. Now the ledger account has been create for Unearned Revenues and this is how to create Customer Advances Ledger in Tally ERP 9 Accounting Software.

What is the Accounting Entry for Advances Received from Customers?


Advances Receipts is the common practice of every Business and it is seen everywhere in the world. When we want to buy a Car we have to first Look the Car by paying off the Advance amount at Car Show Room. The Car Show Room accountant will have to consider it as an Advance from the Customer.

What is the Accounting Entry for Advances Received from Customers?

Likewise whenever an amount is received from any customer before the delivery of the consignment it is good idea to write them as Advances from Customer and it will be good to see while preparing the Balance Sheet of a Company.

Finalizing the Accounts of Books at the time of Assessment of Income Tax Returns is most import thing that an Accountant, CA must consider about the Balance Sheet presentation of the firm. They have to understand the scope of the business and have to prepare the Balance Sheet keeping the business nature and prospectus in the view.

If anything goes wrong the status of the Balance sheet will reflect the negative financial position of the business in the industry. The same thing was done in the Balance Sheet of AccountsGuy.Net because of showing the Customer Advance under Sundry Creditor.

What are Advances from Customers

Whenever a business gets Advances from its customers it is treated as the Unearned Revenues for which the business is liable to supply the Stock or Service for the worth of the Advances it has received.

Accounting Treatment for Advances from Customers

As per basic accounting concept the accounting treatment for Advances received from the customers will be treated as liability as we already discussed above. So, we need to Credit the Customer Advances or Unearned Revenues Ledger and Debit either Cash or Bank Ledger. Hence, the accountant has to pass following accounting entry in the books of their Firm

 Cash or Bank A/c Dr 25,000
        To Customer Advances A/c   25,000

As we stated above the Customer Advances will be shown in the Balance Sheet. And this is the Accounting Treatment for Trade Advances received from Customers.

How to Link Adwords to Youtube Channle for Video Advertisement?


We can start advertising your Youtube Videos using your Adwords Account which you have already created and added some funds to it. And it is possible through Linking process of an Adwords Account to your Youtube Channel. This process is simple and within few seconds you can start using your Adwords funds for promoting your Youtube Channel Videos.

Image: Linking Google Adwords Account to Youtube Account

Before you link Adwords Account you need to note down your Adwords Client ID. Just open your Adwords Account on top right corner you notice your Client ID which contains nine digits separated by an Hyphen for every three digits like xxx-xxx-xxx. Just copy that number in the text editor.

After that you have to open your Youtube Analytics page for that

  1. Login to your Youtube Account
  2. Just click on the dropdown button beside the Upload button on top middle of the page.
  3. Select the Analytics button from the dropdown list.
  4. In the Analytics page select Channel Settings in left side and after that select Advance option.
  5. Click on Link Adwords for video account button from the page.
  6. Just paste your Adwords Client ID which you noted down before.
  7. Assign a name for linking your Adwords Account to Youtube and select the appropriate options and click on Finish button.

You can notice that Adwords Account linked to your Youtube Channel. After you have added you can either change the setting or Unlink your Adwords account when ever you need. And you can add more than one Adwords Accounts to your Youtube Channel.

VAT Returns submission procedure in Andhra Pradesh State explained.


After the Telanga Region is divided from Andhra Pradesh state the Commercial Tax Department of Andhra Pradesh state after bifurcation has changed its policies and the way of Monthly VAT Returns submission procedure also. In the 2015-2016 Financial Year, it has introduced a new electronic Filing System called Invoice Tracking System.

VAT Returns submission procedure in Andhra Pradesh State explained.

And in this article we are going to understand it in better way and let us see how we can upload the Monthly VAT Returns from June 2015 onwards from VAT Dealer e-Returns Portal. Earlier the VAT Dealers were uploading the VAT 200 Form by providing the Purchases and Sales Summary Report only of the particular month but from June 2015 onwards every VAT Dealer has to upload the Invoice Details and file VAT 200A Form before submitting VAT 200 Form.

In order to complete a month VAT Return VAT Dealer must go through the following procedure and it is mandatory.

  1. Login to the VAT Dealer Account using the TIN Number and Password.
  2. First the VAT Dealer must complete the Invoice Tracing System where he has to prepare the Annexure I and Annexure II Excel Template files, Upload, and Confirm from his Dealer Account in AP Commercial Tax Department portal.
  3. After the Invoice Tracing is done he has to complete the VAT 200A Form.
  4. After you have gone through the first two steps the final stage is common VAT 200 Form with which we are familiar already.

And this is the procedure of submitting the Monthly VAT Returns to the Andhra Pradesh state Commercial Tax Department from June 2015 onwards. And this is how to submit the monthly VAT Returns in Andhra Pradesh state.