1. Home
  2. Tools
  3. Tally Bridge

Tally Bridge

Type or paste your ledgers, receipts, payments and journals into the tables — or import your Excel or bank statement — and download a file you can import straight into TallyPrime.

🔗 Excel → Tally XML• Ledgers · Receipts · Payments · Contra · Journals · Bank statements• Your data never leaves this browser

Use the table below like Excel — type, or copy rows from Excel and paste them in. Or fill the template and import it in one go.

Already in Tally — nothing loaded. Load your Tally masters so existing ledgers and groups are recognised and never re-created.
How to export masters from Tally
  1. Open the company in TallyPrime and press Alt+E (Export) → Masters.
  2. Choose All Masters and file format XML (Data Interchange), then Send. Tally saves a file such as Master.xml in its export folder (shown on the same screen).
  3. To spot vouchers already in Tally: Alt+E (Export) → Transactions, XML (Data Interchange), for the period you are working on, and load that file the same way.
  4. Click Load from Tally above and pick that file. It is read only in this browser.
  5. No XML? An Excel/CSV list also works — a column of names, with optional Under and Type (Ledger/Group) columns.
See the XML 
Fill the table to see the XML.

How it works

  • Groups (optional) are created under a standard Tally group or under each other — e.g. Rent & Utilities under Office Expenses under Indirect Expenses. Other group settings follow the parent.
  • Ledgers are created new under a standard group, your own group, or a group already in Tally, with an optional opening balance (amount + Dr or Cr).
  • Party details (new in version 2) — for ledgers under Sundry Debtors or Sundry Creditors: mailing name, address, state, PIN, GST type, GSTIN, PAN, contact person, mobile, phone and email; under All columns, bank details and MSME/Udyam too. Choose Party details above the table to see these columns. The GSTIN is checked (including its check digit) and fills in the state and PAN by itself.
  • Contra (new in version 3) — cash deposited, cash withdrawn, bank-to-bank transfers. Money goes into the Bank/Cash column ledger and out of the Other ledger. Your own voucher types (e.g. “Bank Receipt”) work too, once you Load from Tally.
  • Journals — one row per ledger line; lines with the same Entry no (J1, J2 …) make one voucher, with as many lines as you need. Debits must equal credits; bank and cash ledgers belong in receipts, payments or contra instead.
  • Bank statement — upload the Excel/CSV statement from net banking; the tool finds the columns, skips headings and totals (and tells you which), checks every running balance, and fills ledgers from your rules (e.g. narration contains RENT → Office Rent). Ready lines move to Receipts & Payments.
  • Already in Tally? Load a Transactions export from Tally and any row with the same date, ledgers and amounts as an existing voucher is flagged, with one click to remove it.
  • Alter existing changes a ledger or group already in Tally — rename it, move it to another group, or change a ledger's opening balance. Only the columns you fill are changed; blank means “leave as it is”. Load your Tally masters first.
  • Receipt: bank/cash is debited, the other ledger credited. Payment: the other ledger is debited, bank/cash credited. Always enter a positive amount.
  • Every row is checked as you go — the Check column shows ✓ with the debit and credit, or what to fix. The file downloads only when every row is clean.
  • Amounts are kept exact to the paisa. Dates can be DD/MM/YYYY.
  • Repeats inside the table are caught. The tool cannot see vouchers already in Tally — check the Day Book before importing the same period again.
  • Not covered yet: sales, purchases, GST/TDS, inventory, contra, split entries, bill-wise details and custom groups.

Example

Payment · Bank/Cash Demo Bank · Other ledger Office Rent · Amount 25,000
Goes into Tally as: Office Rent Dr ₹25,000, Demo Bank Cr ₹25,000.

Opening balance 2,50,000 Dr on a bank ledger appears in Tally as a debit balance of ₹2,50,000.

GSTIN 24ABCDE1234F1Z6 → State Gujarat (code 24), PAN ABCDE1234F, GST type Regular.

Importing into Tally

  1. Try it first in a separate test company (or a backup copy) — not your live books.
  2. Download the Groups + Ledgers XML (groups are written first). In TallyPrime: Alt+O → Import → Masters. Check the number created, the group tree and the opening balances.
  3. If you used Alter existing: take a backup, download the Alterations XML and import it the same way (Alt+O → Import → Masters). Check the changed ledgers and groups.
  4. Download the Vouchers XML (receipts, payments, contra and journals together). In TallyPrime: Alt+O → Import → Transactions. Check the number imported and the Day Book.
  5. Once it matches, use it on real books — after taking a backup.