How to Import Journal Entries from Excel to Tally Prime (Free Template)

In corporate accounting, journal vouchers (JV) are used to record non-cash transactions, period-end adjustments, payroll allocations, depreciation, and tax adjustments (like TDS or GST reversals). Manually entering hundreds of adjustment transactions at the end of the month is highly inefficient. Bulk importing them from an Excel template resolves this issue.

Required Excel Column Format for Journal Entries

Unlike simple payment or receipt vouchers (which have a single debit/credit leg against a bank account), a journal entry can have multiple debit and credit legs. Your Excel template must be structured to support this:

Column Name	Data Type	Description	Example Value
Date	DD-MM-YYYY	Date of the journal voucher	31-03-2026
Journal No	Alphanumeric	Unique voucher reference number	JV/2026/0014
Debit Ledger	Text	Exact name of the ledger to debit	Depreciation A/c
Credit Ledger	Text	Exact name of the ledger to credit	Office Computers
Amount	Decimal Number	Transaction amount (must match Dr/Cr legs)	12500.00
Narration	Text	Description of the adjustment	Being depreciation charged for Computers

Tally XML structure for Journal Entries

Tally Prime requires the XML data block to contain multiple ledger listings under <ALLLEDGERENTRIES.LIST> tags. Below is a complete working XML example for a journal voucher:

&lt;ENVELOPE&gt;
  &lt;HEADER&gt;
    &lt;TALLYREQUEST&gt;Import&lt;/TALLYREQUEST&gt;
    &lt;TYPE&gt;Data&lt;/TYPE&gt;
    &lt;ID&gt;Vouchers&lt;/ID&gt;
  &lt;/HEADER&gt;
  &lt;BODY&gt;
    &lt;DATA&gt;
      &lt;TALLYMESSAGE&gt;
        &lt;VOUCHER VCHTYPE=&quot;Journal&quot; ACTION=&quot;Create&quot;&gt;
          &lt;DATE&gt;20260331&lt;/DATE&gt;
          &lt;VOUCHERTYPENAME&gt;Journal&lt;/VOUCHERTYPENAME&gt;
          &lt;NARRATION&gt;Depreciation charged u/s 32&lt;/NARRATION&gt;
          &lt;ALLLEDGERENTRIES.LIST&gt;
            &lt;LEDGERNAME&gt;Depreciation A/c&lt;/LEDGERNAME&gt;
            &lt;ISDEEMEDPOSITIVE&gt;Yes&lt;/ISDEEMEDPOSITIVE&gt;
            &lt;AMOUNT&gt;-12500.00&lt;/AMOUNT&gt;
          &lt;/ALLLEDGERENTRIES.LIST&gt;
          &lt;ALLLEDGERENTRIES.LIST&gt;
            &lt;LEDGERNAME&gt;Office Computers&lt;/LEDGERNAME&gt;
            &lt;ISDEEMEDPOSITIVE&gt;No&lt;/ISDEEMEDPOSITIVE&gt;
            &lt;AMOUNT&gt;12500.00&lt;/AMOUNT&gt;
          &lt;/ALLLEDGERENTRIES.LIST&gt;
        &lt;/VOUCHER&gt;
      &lt;/TALLYMESSAGE&gt;
    &lt;/DATA&gt;
  &lt;/BODY&gt;
&lt;/ENVELOPE&gt;

Importing Journal Vouchers in Tally Prime

Once your data is prepared:

Method 1: Native Import via Tally Prime 4.0/5.0

Create a mapping template under Import > Manage > Mapping Templates.
Choose Journal Vouchers, and map the Excel headers to Tally fields.
Specify the debit ledger, credit ledger, and amount columns.
Import the file under Import > Transactions.

Method 2: Automating Purchase Invoices and Statements

While journal adjustments are imported using native Excel mapping, your high-volume transactions like purchase bills and bank statement entries can be automated:

Direct OCR Upload: Scan and upload supplier invoice PDFs or bank statement files directly. TrulyInvoice's AI extracts line items without manual data entry.
Auto Ledger Association: Automatically map vendor names and tax heads to Tally ledgers.
Real-Time Verification: Flags duplicate invoice references and checks tax math on a visual screen before pushing.
Pushes vouchers directly over localhost port 9000 at flat plans starting at ₹399/month.

Frequently Asked Questions

Q: Why does my journal import fail with "Voucher out of balance" error?

A: In double-entry accounting, the sum of all debits must equal the sum of all credits in a single voucher. If there is a difference of even ₹0.01, Tally rejects the entry.

Q: Can I use a journal voucher to transfer cash between bank accounts?

A: No. In Tally, bank-to-bank or cash-to-bank transfers must be recorded using Contra vouchers (`F4`) to ensure accurate bank reconciliation reports.

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.

Start Free TrialNo credit card required • Unlimited sync flat plan ₹399/mo

How to Import Journal Entries from Excel to Tally Prime