Columnar Sales Register in TallyPrime: 4 Steps + Easy Example

1. Understanding Columnar Sales Register in TallyPrime

The Columnar Sales Register in TallyPrime is a customizable report that allows you to view sales data in a tabular format with specific columns.

You can choose which columns to include and their order, making it a flexible tool for analyzing sales performance.

2. Key Features of Columnar Sales Register in TallyPrime:

1. Customization:

You can select which columns to include in the report, such as date, customer, product, quantity, rate, total amount, and more.

2. Grouping:

You can group sales data by customer, product, or other categories for better analysis.

3. Filtering:

You can filter the report based on specific criteria, like date range, customer, or product.

4. Total Calculations:

The report automatically calculates totals for various columns, such as total sales amount and quantity.

3. Accessing Columnar Sales Register in TallyPrime:

1. Go to Gateway of Tally: Open TallyPrime and navigate to the Gateway of Tally.
2. Select Reports: Press Alt+R (Reports).
3. Choose Columnar Sales Register: Select Columnar Sales Register from the list of reports.

4. Customizing the Report in TallyPrime:

• Select Columns: Press Alt+F12 (Configure) to customize the report.
• Choose Columns: Select the columns you want to include in the report.
• Arrange Columns: Drag and drop columns to rearrange their order.
• Set Widths: Adjust the width of each column to fit your needs.

5. Example of Columnar Sales Register in TallyPrime:

Let’s say you want to create a columnar sales register with the following columns:

• Date
• Customer
• Product
• Quantity
• Rate
• Total Amount

1. Access the Columnar Sales Register.
2. Select these columns in the configuration window.
3. Arrange the columns in the desired order.
4. Save the changes.

6. Benefits of Using Columnar Sales Register in TallyPrime:

• Customization: Tailor the report to your specific analysis needs.
• Clarity: The tabular format makes it easy to read and understand the data.
• Analysis: Identify trends, patterns, and outliers in your sales data.
• Decision Making: Support informed decision-making based on sales performance.

By effectively using the Columnar Sales Register in TallyPrime, you can gain valuable insights into your sales activities and make data-driven decisions to improve your business.