www.TallyERP9Help.Com

Sales Register (Sales Day Book) in Tally.ERP 9

Sales Register displays the monthly summary of sales transactions and closing balances. The list of transactions pertaining to each month can be viewed by selecting that month and viewing its details. Tally.ERP 9 permits you to change the display according to the information required.

The period of the report and the content details can be modified. Columnar periodic reports can be generated using Alt+N: Auto Column button for different periods as shown by the columnar details list. Tally.ERP 9 also allows you to compare similar data of two or more companies stored in the same data directory.

Uses of Sales Register

  • The periodic turnover can be analysed using the F2: Period button.

  • The periodic taxes on such turnovers can be easily computed.

  • Errors made while recording the transactions can be easily traced.

  • Sales returns during the year can be analysed and timely action can be taken to remove the undesirable causes.

  • Performance analysis of godown, salesperson, sales area etc. can be done with the help of cost centre and cost category report

Sales register displays the monthly summary of sales made during the selected period.

To view Sales Register,

Go to Gateway of Tally > Display >Account books > Sales Register

The Sales Register screen is displayed as shown:


[Img-13]

By default, all registers display Monthly Summary with transactions and closing balances.

Drill down into each month to view the sales voucher register for that month, which finally takes the user to the accounting voucher alteration (secondary) screen.

Select a month and press Enter to see the Sales Voucher Register.


[Img-14]

A list of all sales vouchers pertaining to the month you selected is displayed. You can use the options in the button bar to change the display according to your preferences. You can change the period of the report as well as the depth of information.

Use F12: Configure to see the report with some or all of the following information, namely Narrations, Bill-wise details, Cost Centre details and Inventory details.


[Img-15]

Click on F1: Detailed to view the reports in detailed format from within the Sales Voucher Register screen.


[Img-16]

Export Sales/Purchase Register in Excel to generate Pivot Table

The Sales/Purchase Register can be exported in excel to be compatible to generate pivot table so that the user may generate reports of various combinations based on specific requirements. This will eliminate the need for customisation of the existing reports to prepare sales/purchases data in the required format.

To export the Sales Register for Pivot Table,

From the Sales Voucher Register screen,

  1. Click E: Export or press Alt+E, the Exporting Sales Register screen appears.

  2. Select the required language from the list of Languages displayed.

  3. Select Excel (Spreadsheet) under Format from the list of Formats displayed.

  4. By default, the exported file will be stored in C:\Program Files\Tally.ERP9 for Windows 7 and C:\Tally.ERP9 for Windows XP operating systems.

  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.

  6. Press Enter to accept the default Output Sheet Name.

  7. To update the existing file select Yes in Update Existing File.

  8. Set Yes to the option Export for Pivot Table.

Note: This option appears only when the Sales/Purchase Voucher Register / Extract is exported, and when the Company is maintaining Accounts withInventory.

  1. To update the existing file select Yes in Update Existing File.

  2. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.

  3. Select Yes for the Field with Colour, to retain the background colour in the exported file.

Set the following options that appear only when the option Export to Pivot Table is enabled, especially to configure them while generating pivot table reports, i.e.,

  1. Set Yes to Show Company Name in case you want the Company Name column to be used.

  2. Set Yes to Show Item Properties to show the item properties, such as, Alias, Part No, Description, Remarks, etc.

  3. Set Yes to Show Ledger Properties to show the ledger properties, such as, Alias, Group, Notes, etc.

  4. Set Yes to Show Statutory Details to show the VAT / TCS details.


[Img-17]

  1. Accept to export the Sales Register Vouchers to an excel file for pivot table.

  2. Open the exported file from the specified folder.


[Img-18]

  1. The excel sheet opens as shown:


[Img-19]

  1. Create a Pivot table and set the Report filter, Row labels, Column labels and Values based on your requirement to generate a customised report.

Note: The steps to Create Pivot table varies between the different versions of Microsoft Excel. Refer to the help file of respective MS Excel versions for the procedure.

The report generated from Pivot table Item-wise Godown-wise Batch-wise Party-wise is displayed as shown:


[Img-20]

Note: The Export for Pivot Table will extract the data of only those Sales vouchers having Inventory allocated.

The procedure to Export Purchase Register in Excel to generate Pivot Table is similar to that of Export Sales Register in Excel to generate Pivot Tableexplained above.

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications