Columnar Sales Register in tally | How to view ?

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

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

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

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

Type of Column

Select the type of column from the screen.

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

All Items (automatic columns)

If this option is selected, every ledger account will be displayed in separate column.

All Item (in one col.)

If this option is selected, all the ledger accounts are displayed in one single column.

Group

You can also select a group of ledger accounts to be displayed together in one column, e.g., Sales accounts. For other columns, you can use the additional options, namely Related accounts (automatic columns) or Related Items (in one col.).

Related Items (automatic columns or in one column)

Related items means all the ledger accounts used in a voucher. Hence, the report will be similar to All Items (automatic columns). This option is helpful when used in conjunction with a Group or a specific ledger account in the first column.

Ledger

Select a specific ledger account e.g., VAT/Sales Tax. All other accounts can be put in one or more columns.

Change Voucher Types

Use this button to view a different register from within an existing register. E.g. If you are in Sales Register and want to view the Payment register, press F4: Chg Vch and select Payment.

On the same way, you can generate columnar purchase register too.

If you have any query, then please post it on the support forum only

About the author /


Mahendra is founder and CEO of the I Vision Infotech, Authorised Tally Sales and Service Partner and helping Tally users to learn Tally and accounting free through this site

9 Comments

  1. Laks

    Hello,

    I am new learner . I learnt tally using our website only.

    We have sales Invoice in Excel format.

    I want my Sales Invoice amounts to be entered into tally ERP9.

    cenvat , Edu cess, Hr.sec edu cess, VAT – all these amount to be entered in Sales Register.

    But these cenvat amounts are in
    Duties – ( Deposits Assets)and
    Sales Taxe VAT are in the heading of
    Taxes – (Deposits (Assets).
    only basic sales value is in Sales account.

    How to enter the same in Sales Voucher.

    Please can u help me.

    With warm regards
    Chellamlaks

    • Mahendra

      Dear Chellamlaks,
      I am sorry but I am not able to get you exactly what your query is.
      . Do you want entry in excel format or direct in tally ?
      If you are referring to enter the same direct in tally, then it is possible to do the same. Check my articles under category of vat and excise.
      alternatively, please post it on forum.tallynine.com with clear understand so that I can resolve the same

  2. Mridul

    Hello Sir,

    Your Suggestions are helpful.
    Sir I want to know that can I create an extra column in sales or purchase voucher as per my own requirement.

    Please reply me as soon as possible.
    Thanking you.

    MRIDUL

    • Mahendra

      Thanks for your input Mridul,
      to create an extra column in sales/purchase register, you need to learn Tally TDL or have to contact some TDL professionals.

  3. abdul bari

    dear sir,

    how can activate ctrl+f12 function in sales /purchase register actualy i want to know the sales in area wise

  4. Manish

    how would we create a report in tally 9.Actually we are in to distribution of electronic goods.so we provide price protection to our dealers for 7 days.now i want to generate a report for few of my stock items sold to dealers in last one week.Is it possible to generate such a report.Pls help

  5. Gopal Krishan

    can some body explain me in detail, how we can genrate the sales invoice

  6. vikas

    Thanks for defining Related Items
    Related Items (automatic columns or in one column)
    Related items means all the ledger accounts used in a voucher. Hence, the report will be similar to All Items (automatic columns). This option is helpful when used in conjunction with a Group or a specific ledger account in the first column.

  7. Jatinder

    Dear sir ,
    I m new to tally and my query is about how to maintain account of a customers to whom we sale some Gud and also we make purchace from them is I have to make two different accounts in sundry debitors and sundry creditors

Post your comments

Your email address will not be published. Required fields are marked *

Categories

Follow on Twitter

You might also likeclose
Wordpress SEO Plugin by Wordpress SEO Plugin