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
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
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
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
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
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.
dear sir,
how can activate ctrl+f12 function in sales /purchase register actualy i want to know the sales in area wise
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
can some body explain me in detail, how we can genrate the sales invoice
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.
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
Sir, i am working in a manufacturing company.
How to know all sales and purchase entries are correct in tally
Sir, Can we move or change the place of column in columnar option,
I know yes or no option before using columnar but i want to know can we change the place of column in columnar,
Please guide.
If you know TDL (Tally’s programming knowlege then you can do cchanges things you want in Tally.
Else No, you can’t do that on your own.