How to Import Debit Notes from Excel to Tally Prime
How to Import Debit Notes from Excel to Tally Prime
Debit notes document purchase returns or price overcharges by suppliers. Learn the required columns, accounting entries, and how to bulk import them from Excel.
Who is this for: Tally Setup Docs
In business operations, returning damaged or incorrect goods to suppliers requires you to issue a Debit Note. Recording purchase returns in a timely manner is essential to reconcile your accounts payable and ensure your GSTR-3B Input Tax Credit (ITC) calculations are accurate. Manually recording each itemized return is slow; bulk importing them via Excel resolves this.
What is a Debit Note in Tally?
A Debit Note is an accounting document sent by a buyer to a supplier to reduce the amount owed to them. It corresponds to an ITC reversal under GST GSTR-3B guidelines.
Key Uses:
- Return of goods to the supplier (Purchase Return).
- Rebate or rate difference adjustments under supplier credit schemes.
- Escalating purchase values (rare).
Required Excel Columns for Debit Note Import
To successfully import purchase returns, structure your Excel template with these columns:
| Column Name | Format | Description | Example Value |
|---|---|---|---|
| Date | DD-MM-YYYY | Date of the debit note | 22-04-2026 |
| Debit Note No | Alphanumeric | Unique document identifier | DN/2026/009 |
| Supplier Name | Text | Exact supplier ledger name in Tally | Varun Enterprises |
| Original Bill No | Alphanumeric | Linked purchase bill number for GST matching | PB/2026/1024 |
| Taxable Value | Decimal | Net value of goods returned (excluding tax) | 5400.00 |
| CGST / SGST / IGST | Decimal | Tax values to reverse | CGST: 486, SGST: 486 |
Accounting entries and GST Mappings
A debit note reverses the original purchase entry. In Tally, the double-entry legs are:
Debit: Supplier Account (6372.00) Credit: Purchase Returns / Purchase Account (5400.00) Credit: CGST Input Tax (486.00) Credit: SGST Input Tax (486.00)
Tally requires you to enter the **Original Bill Number** and **Date** under the statutory GST details. Mismatches here will cause errors in your GSTR-3B ITC reconciliation logs.
How to Import Debit Notes
Method 1: Native Import via Tally Prime
- Create a mapping template under Import > Manage > Mapping Templates.
- Choose Debit Note vouchers and map your columns.
- Ensure the GST tax allocations and supplier ledger tags are mapped.
- Go to Import > Transactions to load the data.
Method 2: Automating Debit Notes via PDF Scanning
TrulyInvoice automates the extraction and entry of debit notes from scanned supplier copies or PDFs:
- Direct OCR Extraction: Upload the debit note PDF or scanned image. TrulyInvoice extracts original bill numbers, dates, taxable values, and tax splits automatically.
- Ledger & Tax Matching: Maps supplier 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: Does a debit note decrement inventory in Tally?
A: Yes. If the return involves physical stock, your Excel template must include Item Name, Quantity, and UOM. Tally will automatically decrement the inventory count in the designated godown upon import.
Q: What is the difference between debit note and credit note in purchase returns?
A: A buyer issues a **debit note** to record the purchase return in their books (debiting the supplier ledger). The supplier issues a corresponding **credit note** in their books to record the sales return (crediting the customer ledger).
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