Excel to Tally Importer

Convert Excel sales data to Tally ERP9/TallyPrime XML for bulk voucher import. Saves hours of manual data entry in Tally.

Features

• Reads sales data from sales.xlsx using pandas
• Generates tally_import.xml in Tally XML format
• Supports Sales Vouchers for bulk import
• Ignores sensitive data - sales.xlsx is in .gitignore

Installation

pip install -r requirements.txt

## How to Use
1. Put your sales data in `sales.xlsx` with columns: Date, VoucherNo, Ledger, Amount
2. Run the script:
```bash
python excel_to_tally.py
3. Import `tally_import.xml` in Tally: `Gateway of Tally > Import > Vouchers`

## Tech Stack
- Python
- Pandas 
- OpenPyXL
- XML

## Important Note
`sales.xlsx` contains sample/private data and is added in `.gitignore` so it won't be uploaded to GitHub.

## License
MIT License - Free to use