Financial Accounting with Tally
UNIT-I: Basic Accounting & Company Configuration
Basic Concepts of Accounting, Financial Statements, Financial Statement Analysis, Cost Centre, Basic concepts of Inventory. Tally Configuration & INI setup, Data Directory & Folders configuration, Single & Multiple User, Tally Screen Components, Mouse / Keyboard Conventions & Key Combinations, Switching between screen areas, Quitting Tally. Maintaining Company Data, Basic Company Details, Create/Alter/Select/Load/Close a Company, Chart of Accounts, Company Features, Configuration.
UNIT-II: Voucher Entries & Advanced Transactions
Create, Alter & Display Groups and Ledgers, All accounting voucher types and transactions, Create and Alter new Voucher type, Item and Account Invoice transactions, Excise Invoice, Export Invoice, Transactions using Bill-wise details. Create, Alter & Display Cost Centre and Cost Categories, Cost Centre & Category allocation in voucher entry, Creating Cost Centre Class, Invoice entry in a Class situation. Create, Alter & Delete Foreign Currencies, Voucher entry using foreign currency, Bank Reconciliation, Interest calculations using simple & advanced parameters, Interest on outstanding balances & invoices, Use of voucher class, Adjustment of interest, Creation of voucher class.
UNIT-III: Budgeting, Job Costing & Reports
Create, Alter & Delete Budgets for groups, ledgers & cost centres, Defining credit limit & period, Display Budgets & Variances, Create, Alter & Delete a scenario. Enabling Job Costing in Tally, Master creation & configuration, Creation of Voucher type & Class for Stock Transactions, Transfer journal for Godowns, Consumption journal, Payment voucher, Godown summary report, Job Work Analysis, Material consumption summary. Reports: Balance Sheet, Profit & Loss, Ratio Analysis, Trial Balance, Cash/Bank Book, All Ledgers, Group Summary & Vouchers, Registers, Cost Centre Reports, Outstanding reports, Interest Reports, Cash/Fund Flow, Day Book, List of Accounts, Reversing Journals, Optional & Post-dated Vouchers.
UNIT-IV: Inventory Management & Reports
Create, Alter & Display Stock Groups and Items, Stock behavior via costing/market valuation, Sales/Purchase/Rejected stock behavior, Negative balance handling, Physical count adjustment. Create, Alter & Display Stock Categories, Units of Measure, Alternate Units, Standard Cost/Selling Price, Rate of Duty, MRP. Create & Allocate Godowns, All Inventory Voucher types, Inventory in Accounting Vouchers, Reorder Level, Tracking Numbers, Batch-wise details, Additional costs, Bill of Material, Cost Estimation, Price List & Levels, Zero Valued Entries, Actual vs Billed Quantity Transactions. Inventory Reports: Stock Summary, Stock Registers, Movement & Ageing Analysis, Order Books, Reorder Status, Bill Pendings, Exception Reports.
UNIT-V: Printing, Security, Data Management
Cheque Printing, Common and Format-specific Printing, Multi-Account Printing, Dynamic Reporting Options. Group Company Creation, Tally Vault, Security Control, Security Levels, Tally Audit. Backup & Restore, Company Split, Data Export/Import, ODBC Compliance, E-mail Use, Internet Publishing, Uploading, Web Browser & Online Help, Rewriting Data.

UNIT-I: Basic Concepts of Accounting, Financial Statements, Financial Statement Analysis, Cost Centre, Basic Concepts of Inventory, Tally Configuration & INI Setup

1. Basic Concepts of Accounting

Accounting is the process of recording, summarizing, and reporting financial transactions to provide insights into a business's financial performance and position. Key concepts include:

Example: A company sells products worth $1000 and incurs expenses of $600. The profit is calculated as:

Profit = Revenue - Expenses
Profit = $1000 - $600 = $400

2. Financial Statements

Financial statements summarize the financial activities of a company. The key statements include:

Example: The income statement of a company for the year might show $50,000 in revenue and $30,000 in expenses. The net income is:

Net Income = Revenue - Expenses
Net Income = $50,000 - $30,000 = $20,000

3. Financial Statement Analysis

Financial statement analysis involves evaluating the performance and financial health of a company through its financial statements. Key tools include:

Example: The current ratio is calculated as:

Current Ratio = Current Assets / Current Liabilities
Current Assets = $50,000, Current Liabilities = $20,000
Current Ratio = $50,000 / $20,000 = 2.5

4. Cost Centre

A cost centre is a department or unit within an organization where costs are incurred, but it does not generate revenue. Its primary goal is cost control and monitoring.

Example of Cost Centre: If a factory's production department spends $10,000 on labor and $5,000 on materials, the total cost for that department is:

Total Cost = Labor + Materials
Total Cost = $10,000 + $5,000 = $15,000

5. Basic Concepts of Inventory

Inventory refers to the goods and materials held by a business for resale or production. Basic inventory types include:

Example: A company may hold:

Raw Materials = $10,000
Work-in-Progress = $5,000
Finished Goods = $15,000

Total Inventory = Raw Materials + Work-in-Progress + Finished Goods = $10,000 + $5,000 + $15,000 = $30,000

6. Tally Configuration & INI Setup

Tally is an accounting software that allows businesses to manage financial data efficiently. The configuration of Tally involves setting up various features and options such as:

Example: In Tally, you can set the financial year to start from April 1 and the currency symbol to ₹. You can also configure whether the company uses GST or not.

7. Tally Screen Components

The Tally screen consists of various components that facilitate the smooth operation of the software. These include:

Example: To create a new company in Tally, navigate to "Gateway of Tally" and select "Create Company."

8. Maintaining Company Data

Maintaining company data in Tally involves creating, altering, and managing company-specific details. Key aspects include:

Example: When you start Tally, you can select the "Load" option to open an existing company's data.

UNIT-II: Create, Alter & Display Groups and Ledgers, All Accounting Voucher Types and Transactions

1. Create, Alter & Display Groups and Ledgers

In Tally, groups and ledgers are essential for classifying transactions. Groups classify similar ledgers, and each ledger represents an account.

Example: To create a new ledger in the 'Assets' group for 'Bank Account', follow these steps:

1. Go to "Accounting Vouchers"
2. Select "Create Ledger"
3. Choose "Assets" as the Group
4. Enter "Bank Account" as the Ledger Name

2. All Accounting Voucher Types and Transactions

Tally provides various types of accounting vouchers for different types of transactions. Some common voucher types include:

Example: To record a receipt transaction for Rs. 5000, use the following steps:

1. Go to "Accounting Vouchers"
2. Select "Receipt" Voucher Type
3. Select "Cash" as the ledger
4. Enter the amount as Rs. 5000

3. Create and Alter New Voucher Type

You can create or alter new voucher types in Tally to match specific business needs. Tally allows customization of voucher types, such as adding new fields or changing existing ones.

Example: To create a new voucher type for 'Loan Receipt':

1. Go to "Gateway of Tally"
2. Select "Accounts Info" > "Voucher Types"
3. Click "Create" to add a new voucher type
4. Name it "Loan Receipt" and set the appropriate configurations

4. Item and Account Invoice Transactions

Tally allows the entry of both item invoices (inventory-related) and account invoices (non-inventory transactions). The difference is that item invoices track stock, while account invoices do not.

Example: For an item invoice:

1. Go to "Accounting Vouchers"
2. Select "Sales" Voucher Type
3. Choose the "Item Invoice" option
4. Enter the item details and the amount

Example: For an account invoice:

1. Go to "Accounting Vouchers"
2. Select "Sales" Voucher Type
3. Choose "Account Invoice" option
4. Enter the relevant account and amount details

5. Excise Invoice

Excise invoices are used in businesses that deal with excise duty. Tally helps to generate excise invoices for sales of exciseable goods.

Example: To create an Excise Invoice:

1. Go to "Accounting Vouchers"
2. Select "Sales" Voucher Type
3. Choose "Excise Invoice"
4. Enter the sales details along with excise duty calculation

6. Export Invoice

Export invoices are used when goods are sold internationally. Tally can be configured to handle export-related details, including export duty and tax exemptions.

Example: To create an Export Invoice:

1. Go to "Accounting Vouchers"
2. Select "Sales" Voucher Type
3. Choose "Export Invoice"
4. Enter export details like country, currency, and tax exemptions

7. Transactions Using Bill-wise Details

Bill-wise details are used to manage outstanding bills and their payments. This feature allows tracking of due amounts and payments for a particular bill.

Example: To record a bill payment using bill-wise details:

1. Go to "Accounting Vouchers"
2. Select "Payment" Voucher Type
3. Choose the "Bill-wise Details" option
4. Enter the bill number, due date, and amount paid

8. Create, Alter & Display Cost Centre and Cost Categories

Cost Centres and Cost Categories help in tracking and allocating expenses to specific departments or projects. Cost centres represent individual units, while cost categories represent different types of costs.

Example: To create a cost centre for "Production Department":

1. Go to "Accounting Info"
2. Select "Cost Centres" > "Create"
3. Name it "Production Department"
4. Enter the relevant details

9. Cost Centre & Cost Category Allocation in Voucher Entry

Once cost centres and cost categories are created, they can be assigned to relevant voucher entries to track specific expenses.

Example: During a payment voucher entry, you can allocate the cost to the "Production Department" cost centre.

1. Go to "Accounting Vouchers"
2. Select "Payment" Voucher Type
3. Enter the voucher details
4. Allocate the cost to the relevant cost centre

10. Creating Cost Centre Class and Invoice Entry in a Class Situation

A Cost Centre Class is used when you want to group similar cost centres under a common class. This can simplify cost reporting.

Example: To create a Cost Centre Class:

1. Go to "Accounting Info"
2. Select "Cost Centre Class" > "Create"
3. Enter the class name, such as "Departmental Costs"
4. Assign relevant cost centres to the class

11. Create, Alter & Delete Foreign Currencies

Tally supports transactions in foreign currencies. You can create, alter, or delete foreign currencies used in your transactions.

Example: To create a new foreign currency:

1. Go to "Accounting Info"
2. Select "Currencies" > "Create"
3. Enter the currency name and symbol, e.g., USD

12. Voucher Entry Using Foreign Currency

When recording transactions in foreign currencies, Tally automatically converts them into the base currency based on the exchange rate.

Example: To enter a sales voucher using USD as the foreign currency:

1. Go to "Accounting Vouchers"
2. Select "Sales" Voucher Type
3. Choose the "Foreign Currency" option
4. Enter the amount in USD

13. Bank Reconciliation

Bank reconciliation is the process of comparing the bank's records with the company's ledger. Tally allows automatic reconciliation of bank accounts.

Example: To reconcile a bank account:

1. Go to "Banking"
2. Select "Reconciliation"
3. Choose the bank account to reconcile
4. Match the transactions with the bank's records

14. Interest Calculations Using Simple & Advance Parameters

Interest can be calculated in Tally using both simple and advanced methods, with options to adjust the calculation method.

Example: To calculate interest on outstanding balances using advanced parameters:

1. Go to "Accounting Vouchers"
2. Select the relevant voucher type
3. Choose the "Interest Calculation" option
4. Enter the parameters like interest rate, start date, and end date

15. Use of Voucher Class and Adjustment of Interest

A voucher class is used to automate recurring transactions. Adjustments can be made to the interest in the voucher class.

Example: To adjust interest in a voucher class:

1. Go to "Accounting Info"
2. Select "Voucher Classes"
3. Create or alter a voucher class
4. Set the interest adjustment parameters

16. Creation of Voucher Class and Invoice Entry in a Class Situation

The voucher class helps in setting predefined rules for voucher entries, like default ledgers and taxes.

Example: To create a voucher class for a special discount:

1. Go to "Accounting Info"
2. Select "Voucher Classes"
3. Create a new class for "Discount Sale"
4. Set the default discounts and ledgers

UNIT-III: Create, Alter & Delete Budgets, Credit Limits, Job Costing, and Various Reports

1. Create, Alter & Delete Budgets for Groups, Ledgers & Cost Centres

Budgets are used to set financial targets for groups, ledgers, or cost centres. They help track expenses and incomes against predefined targets.

Example: To create a budget for a ledger (e.g., "Sales"):

1. Go to "Accounting Info"
2. Select "Budgets" > "Create"
3. Choose the ledger "Sales"
4. Set the budget amount for a given period (e.g., Rs. 50,000 for the month)

Similarly, you can alter or delete budgets by selecting the relevant group, ledger, or cost centre and making the necessary adjustments.

2. Defining Credit Limit & Credit Period

Credit limits and credit periods are set to control the amount and time for which a customer or supplier can avail credit.

Example: To set a credit limit and period for a customer:

1. Go to "Accounting Info"
2. Select "Ledgers" > "Create"
3. Enter the customer's name
4. Set the credit limit (e.g., Rs. 20,000)
5. Define the credit period (e.g., 30 days)

3. Display Budgets & Variances

After setting up budgets, you can display them alongside actual figures to analyze any variances (differences) between the budgeted and actual amounts.

Example: To display budget and variances:

1. Go to "Display"
2. Select "Budgets"
3. Choose the relevant group or ledger
4. View the comparison between the budgeted and actual amounts

4. Create, Alter & Delete a Scenario

Scenarios in Tally allow you to manage different situations or versions of budgets, such as best-case, worst-case, and most likely scenarios.

Example: To create a new scenario:

1. Go to "Accounting Info"
2. Select "Scenarios" > "Create"
3. Name the scenario (e.g., "Best Case")
4. Set the desired budget or targets for that scenario

Similarly, you can alter or delete existing scenarios by selecting the relevant scenario.

5. Enabling Job Costing in Tally

Job costing allows you to track the costs associated with specific jobs, such as a manufacturing project or a service contract. It helps in calculating the profitability of individual jobs.

Example: To enable Job Costing:

1. Go to "Gateway of Tally"
2. Select "F11: Features"
3. Enable "Job Costing" by setting it to "Yes"

6. Master Creation & Configuration for Job Costing

For job costing to work effectively, you must create job cost masters that define the job parameters.

Example: To create a Job Cost Master:

1. Go to "Job Costing"
2. Select "Create Job Cost Master"
3. Enter the Job Name (e.g., "Manufacturing Job 1")
4. Set the job details, such as start and end dates, and any relevant cost centres

7. Creation of Voucher Type & Voucher Class for Stock Transactions

Voucher types and classes help streamline stock transactions such as purchases, sales, and stock adjustments. A voucher class can automate certain details, like tax calculations and account allocations.

Example: To create a new voucher type for stock transactions:

1. Go to "Accounting Info"
2. Select "Voucher Types" > "Create"
3. Enter "Stock Purchase" as the voucher type
4. Set the details, such as applicable taxes and ledgers

8. Creation of Transfer Journal for Transfer of Stock Between Godowns

The transfer journal helps in transferring stock from one godown (warehouse) to another.

Example: To create a transfer journal:

1. Go to "Stock Journal"
2. Select "Transfer" as the type
3. Enter the stock details, specifying the godown to transfer stock from and to

9. Consumption Journal Transactions

The consumption journal helps in tracking the use of stock or materials, often for production processes.

Example: To record a consumption journal:

1. Go to "Stock Journal"
2. Select "Consumption" as the type
3. Enter the details of materials consumed for production

10. Payment Voucher

The payment voucher is used to record payments made by the company, whether in cash or through bank transfer.

Example: To record a payment voucher:

1. Go to "Accounting Vouchers"
2. Select "Payment" as the voucher type
3. Enter the payment details (e.g., paid to a supplier for goods purchased)

11. Godown Summary Report

The Godown Summary Report provides a summary of stock movement across various godowns.

Example: To view the Godown Summary:

1. Go to "Display"
2. Select "Stock Summary"
3. View the stock movement details for each godown

12. Job Work Analysis

The Job Work Analysis helps to track the cost incurred on job work and assess its profitability.

Example: To view Job Work Analysis:

1. Go to "Display"
2. Select "Job Work Analysis"
3. View the report based on job costing for the selected job

13. Material Consumption Summary

The Material Consumption Summary report provides details on the materials consumed in production.

Example: To view Material Consumption Summary:

1. Go to "Display"
2. Select "Material Consumption Summary"
3. View the consumed materials over a selected period

14. Reports

Various reports in Tally help in financial analysis and monitoring business health. Some commonly used reports include:

15. Accounts Books and Registers

Tally offers several useful books and registers, such as:

UNIT-IV: Stock Groups, Stock Items, Inventory Management, and Reports

1. Create, Alter & Display Stock Groups and Stock Items

Stock Groups are used to classify stock items into different categories, whereas Stock Items represent the individual products being managed in the inventory.

Example: To create a Stock Group for "Electronics":

1. Go to "Inventory Info"
2. Select "Stock Groups" > "Create"
3. Enter the name "Electronics"
4. Assign it to a higher group like "Finished Goods"

Example: To create a Stock Item like "Mobile Phone":

1. Go to "Inventory Info"
2. Select "Stock Items" > "Create"
3. Enter the name "Mobile Phone"
4. Assign it to the "Electronics" stock group
5. Define the unit of measure (e.g., Piece)

2. Stock Item Behaviour Using Costing and Market Valuation Methods

Stock item behavior defines how the cost and valuation are managed. Costing methods include FIFO, LIFO, and Weighted Average, and Market Valuation methods control the valuation based on the market price.

Example: Setting up costing for a stock item:

1. Go to "Inventory Info"
2. Select "Stock Items" > "Alter"
3. Choose the item "Mobile Phone"
4. Set the "Valuation Method" to "FIFO" or "Weighted Average" as per your requirements

3. Stock Item Behaviour: Additional Features

Additional behaviors allow you to manage stock in more detailed ways:

4. Create, Alter & Display Stock Categories

Stock categories allow grouping of stock items based on various criteria, such as type, usage, or other attributes.

Example: To create a new Stock Category like "Smartphones":

1. Go to "Inventory Info"
2. Select "Stock Categories" > "Create"
3. Enter the name "Smartphones"
4. Assign it to a relevant parent category if necessary

5. Create, Alter & Display Units of Measure

Units of measure define how stock items are quantified, such as pieces, kilograms, liters, etc. You can also create compound units for combinations of base units.

Example: To create a new unit "Box" as a compound unit:

1. Go to "Inventory Info"
2. Select "Units of Measure" > "Create"
3. Enter "Box"
4. Define it as a compound unit, based on the number of pieces in a box (e.g., 10 pieces)

6. Define Standard Cost & Selling Price

Setting up standard cost helps you track the expected cost of items. Selling price is defined to set up the price at which goods are sold to customers.

Example: To define a standard cost and selling price for a stock item:

1. Go to "Inventory Info"
2. Select "Stock Items" > "Alter"
3. Choose the item "Mobile Phone"
4. Set the "Standard Cost" (e.g., Rs. 8,000)
5. Set the "Selling Price" (e.g., Rs. 10,000)

7. Define Rate of Duty & MRP

Define the rate of duty (like GST or other applicable taxes) and the maximum retail price (MRP) of items to ensure compliance with regulations and accurate pricing.

Example: To define the rate of duty and MRP for an item:

1. Go to "Inventory Info"
2. Select "Stock Items" > "Alter"
3. Enter the "Rate of Duty" (e.g., 18% GST)
4. Enter the "MRP" (e.g., Rs. 15,000)

8. Create, Alter & Display Godowns

Godowns are physical locations where stock items are stored. You can manage multiple godowns in Tally.

Example: To create a new godown:

1. Go to "Inventory Info"
2. Select "Godowns" > "Create"
3. Enter the name "Warehouse 1"
4. Define its location (e.g., "Mumbai Branch")

9. Allocation of Items to Godowns

Allocating items to godowns helps track inventory across various locations.

Example: To allocate a stock item to a godown:

1. Go to "Inventory Info"
2. Select "Stock Items" > "Alter"
3. Choose the item "Mobile Phone"
4. Allocate it to the relevant godown, such as "Warehouse 1"

10. Inventory Voucher Types and Transactions

Inventory vouchers are used for recording various stock transactions like purchases, sales, stock transfers, and adjustments.

Example: To record a stock purchase:

1. Go to "Accounting Vouchers"
2. Select "Purchase"
3. Enter the stock item "Mobile Phone"
4. Specify the quantity and rate

11. Create & Use Bill of Material (BoM)

A Bill of Material is used in manufacturing businesses to define the raw materials needed to produce a finished product.

Example: To create a BoM for assembling a mobile phone:

1. Go to "Inventory Info"
2. Select "Bill of Materials" > "Create"
3. Choose the finished product "Mobile Phone"
4. List the components like "Screen," "Battery," and "Charger" with their required quantities

12. Reports

Several inventory-related reports in Tally help track stock movements and manage inventory effectively. These reports include:

UNIT-V: Advanced Features in Tally

1. Cheque Printing

Cheque printing in Tally allows you to print payment cheques directly from the software, which streamlines the payment process for businesses.

Example: To print a cheque in Tally:

1. Go to "Gateway of Tally"
2. Select "Accounts Info" > "Bank Accounts"
3. Choose the bank account
4. Select the option for "Cheque Printing"
5. Choose the payment voucher and press "Print"
6. Configure the printer settings and print the cheque

2. Common Printing Options

Printing options in Tally allow you to customize various document prints, like invoices, ledgers, and reports, based on your preferences.

3. Different Printing Formats

Tally supports various printing formats for different business documents, such as invoices, reports, and cheques.

Example: To change the printing format for invoices:

1. Go to "Gateway of Tally"
2. Select "Print Configuration"
3. Choose "Invoice" and select the preferred format
4. Customize the layout (e.g., add your company logo or modify fields)

4. Multi-Account Printing

Multi-account printing allows you to print multiple account statements or vouchers at once, saving time when handling bulk printing tasks.

Example: To print multiple ledgers at once:

1. Go to "Gateway of Tally"
2. Select "Accounts Books" > "Ledger"
3. Choose the multiple ledgers to print
4. Select "Print" to print all selected ledgers

5. Dynamic Report-Specific Options

Dynamic report-specific options in Tally allow users to customize and filter reports based on specific criteria such as date range, group, and category.

Example: To view a dynamic Profit and Loss statement:

1. Go to "Gateway of Tally"
2. Select "Display" > "Profit & Loss A/c"
3. Use the filter options to select the specific date range or categories

6. Creating Group Company

A Group Company in Tally is useful when managing multiple companies under a single umbrella for reporting purposes.

Example: To create a group company:

1. Go to "Gateway of Tally"
2. Select "Create Company"
3. Choose "Group Company" as the company type
4. Enter the required details for the group (e.g., name, GST details)

7. Use of Tally Vault

Tally Vault is a feature that provides enhanced security for company data, allowing password protection and encryption for sensitive data.

Example: To activate Tally Vault:

1. Go to "Gateway of Tally"
2. Select "Company" > "Create/Alter"
3. Enable "Tally Vault" and set a secure password for the company data

8. Using Security Control & Defining Different Security Levels

Security control in Tally allows the admin to set different levels of access for users, ensuring data security and control over actions.

Example: To define user roles and security levels:

1. Go to "Gateway of Tally"
2. Select "Security Control"
3. Create or alter users and assign specific security levels (e.g., Admin, Data Entry)

9. Use of Tally Audit

Tally Audit is used to monitor and track changes in financial data, ensuring transparency and accuracy in accounts.

Example: To enable Tally Audit:

1. Go to "Gateway of Tally"
2. Select "Company" > "Audit"
3. Enable auditing and review changes made to company data

10. Backup & Restore

Backup and Restore features in Tally help safeguard company data by creating copies and restoring them if necessary.

Example: To create a backup of company data:

1. Go to "Gateway of Tally"
2. Select "Backup"
3. Choose the directory where the backup should be stored
4. Click "Yes" to complete the backup process

11. Splitting Company Data

Data splitting in Tally allows you to divide company data into multiple periods (e.g., financial years) for easier management and archiving.

Example: To split company data:

1. Go to "Gateway of Tally"
2. Select "Company" > "Split Company Data"
3. Define the split date and save the new data set

12. Export & Import of Data

Data export and import features allow Tally users to move data between different systems or software.

Example: To export data from Tally:

1. Go to "Gateway of Tally"
2. Select "Export"
3. Choose the format (e.g., XML, Excel)
4. Select the data to be exported and specify the location

13. ODBC Compliance

ODBC (Open Database Connectivity) compliance in Tally allows the integration of Tally data with other software applications that support ODBC.

Example: To use ODBC in Tally:

1. Go to "Gateway of Tally"
2. Enable "ODBC Server" under configuration settings
3. Use compatible software to connect to Tally via ODBC

14. Use of E-mail & Internet Publishing

Tally allows users to send reports and data via email and publish them on the internet directly from the software.

Example: To send an invoice via email:

1. Go to "Gateway of Tally"
2. Select "Send by E-mail"
3. Choose the invoice to send and enter recipient details
4. Click "Send"

15. Rewriting Data

Rewriting data in Tally ensures that the data is cleaned, reorganized, and optimized for better performance.

Example: To rewrite data:

1. Go to "Gateway of Tally"
2. Select "Rewrite Data"
3. Confirm the action and allow Tally to optimize the data