How to Import Credit Notes from Excel to Tally Prime
How to Import Credit Notes from Excel to Tally Prime
Credit notes are used for sales returns, pricing adjustments, or post-sales discount allocations. Learn how to bulk import them from Excel.
Who is this for: Tally Setup Docs
In daily business, sales returns and rate differences must be documented through Credit Notes to ensure correct GST liability adjustments. When managing e-commerce sales returns or bulk distributor cancellations, recording each transaction manually is a significant bookkeeping challenge. Bulk importing credit notes solves this bottleneck.
What is a Credit Note in Tally?
A Credit Note is an accounting document issued by a seller to a buyer to reduce the amount owed. It corresponds to an adjustment in GSTR-1 under Table 9B.
Key Uses:
- Return of goods by the customer (Sales Return).
- Rate difference adjustments (overcharging in the original invoice).
- Post-sale discounts or scheme rebates.
Required Excel Columns for Credit Note Import
To successfully import sales returns, structure your Excel template with these columns:
| Column Name | Format | Description | Example Value |
|---|---|---|---|
| Date | DD-MM-YYYY | Date of the credit note | 15-04-2026 |
| Credit Note No | Alphanumeric | Unique document identifier | CN/2026/004 |
| Customer Name | Text | Exact buyer ledger name in Tally | Acme Retailers |
| Original Invoice No | Alphanumeric | Linked bill number for GST matching | INV/2026/0452 |
| Taxable Value | Decimal | Net value of goods returned (excluding tax) | 8000.00 |
| CGST / SGST / IGST | Decimal | Tax values to reverse | CGST: 720, SGST: 720 |
Accounting entries and GST Mappings
A credit note reverses the original sales entry. In Tally, the double-entry legs are:
Debit: Sales Returns / Sales Account (8000.00) Debit: CGST Input / Output Tax (720.00) Debit: SGST Input / Output Tax (720.00) Credit: Customer Account (9440.00)
Tally requires you to enter the **Original Invoice Number** and **Date** under the statutory GST details. If these are missing or mismatched, the credit note will show up in the GSTR-1 error logs on the GST portal.
How to Import Credit Notes
Method 1: Native Import via Tally Prime
- Create a mapping template under Import > Manage > Mapping Templates.
- Choose Credit Note vouchers and map your columns.
- Ensure the GST tax allocations and customer ledger tags are mapped.
- Go to Import > Transactions to load the data.
Method 2: Automating Credit Notes via PDF Scanning
TrulyInvoice automates the extraction and entry of credit notes from scanned copies or customer-provided PDFs:
- Direct OCR Extraction: Upload the credit note PDF or scanned image. TrulyInvoice extracts original invoice numbers, dates, taxable values, and tax splits automatically.
- Ledger & Tax Matching: Maps buyer ledgers and tax categories directly to Tally Prime.
- Pushes vouchers directly over localhost port 9000 at flat plans starting at ₹399/month.
Frequently Asked Questions
Q: What happens if I do not link the original invoice in a credit note?
A: Although the voucher will import into Tally, it will be flagged as an "Unresolved Mismatch" in the GST compliance report, preventing correct GSTR-1 filing.
Q: Can I import credit notes containing inventory details?
A: Yes. If the return involves physical stock, your Excel template must include Item Name, Quantity, and UOM. Tally will auto-increment the inventory count in the designated godown upon import.
Q: What is the TrulyInvoice flat pricing?
A: TrulyInvoice charges a flat rate of plans starting at ₹399/month for unlimited statement and invoice synchronization, enabling automated data entry directly to Tally Prime.
Automate Your Tally Bookkeeping 🚀
TrulyInvoice makes Tally data entry effortless. Upload purchase bills, sales invoices, or bank statements and sync them to Tally instantly.
Founder & Chief Architect of TrulyInvoice