QIF to Tally XML Converter
Upload your QIF file and download clean Tally XML. Fast conversion, no manual copy-paste.
Free · preview before you download · free account to export.
How to convert QIF to Tally XML
- 1
Upload your QIF file
Drag and drop your .qif file, or click to browse.
- 2
Convert it
Statement to Sheets reads the file and creates a clean Tally XML output.
- 3
Download your Tally XML file
Your Tally XML (.xml) file downloads automatically, ready to import.
Why convert QIF to Tally XML?
Use this when you have a file in one format and need a clean Tally XML file without rebuilding it by hand.
- Upload your QIF file and download Tally XML
- Avoid manual copy-paste and formatting cleanup
- Works with real-world exports that do not follow a perfect template
Example: before and after
A sample QIF file and the exact Tally XML this tool produces from it.
Input · .qif
!Type:Bank
D06/02/2026
T4200.00
PDirect Deposit ACME Payroll
^
D06/04/2026
T-86.43
PWhole Foods Market
^Output · .xml
<?xml version="1.0" encoding="UTF-8"?>
<ENVELOPE><HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER><BODY><IMPORTDATA><REQUESTDESC><REPORTNAME>Vouchers</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY></SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC><REQUESTDATA><TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER VCHTYPE="Receipt" ACTION="Create" OBJVIEW="Accounting Voucher View"><DATE>20260602</DATE><NARRATION>Direct Deposit ACME Payroll</NARRATION><VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME><ALLLEDGERENTRIES.LIST><LEDGERNAME>Bank Account</LEDGERNAME><ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE><AMOUNT>-4200.00</AMOUNT></ALLLEDGERENTRIES.LIST><ALLLEDGERENTRIES.LIST><LEDGERNAME>Suspense</LEDGERNAME><ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE><AMOUNT>4200.00</AMOUNT></ALLLEDGERENTRIES.LIST></VOUCHER></TALLYMESSAGE><TALLYMESSAGE xmlns:UDF="TallyUDF"><VOUCHER VCHTYPE="Payment" ACTION="Create" OBJVIEW="Accounting Voucher View"><DATE>20260604</DATE><NARRATION>Whole Foods Market</NARRATION><VOUCHERTYPENAME>Payment</VOUCHERTYPENAME><ALLLEDGERENTRIES.LIST><LEDGERNAME>Bank Account</LEDGERNAME><ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE><AMOUNT>86.43</AMOUNT></ALLLEDGERENTRIES.LIST><ALLLEDGERENTRIES.LIST><LEDGERNAME>Suspense</LEDGERNAME><ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE><AMOUNT>-86.43</AMOUNT></ALLLEDGERENTRIES.LIST></VOUCHER></TALLYMESSAGE></REQUESTDATA></IMPORTDATA></BODY></ENVELOPE>What ends up in your Tally XML file
| Tally XML field | Comes from |
|---|---|
| VOUCHER type | Receipt (money in) or Payment (money out) |
| DATE | Transaction date (YYYYMMDD) |
| NARRATION | Description |
| Bank ledger AMOUNT | Signed amount in Tally's sign convention |
| Suspense ledger AMOUNT | Offsetting entry so each voucher balances |
Tips
- Each transaction imports as a Receipt or Payment voucher against a Bank and a Suspense ledger — re-map the Suspense ledger in Tally to categorize.
- Files up to 8 MB are supported. Very large files may be summarized before AI conversion.
Frequently asked questions
Is the QIF to Tally XML converter free?
Yes — it's completely free, with no sign-up required.
What is a QIF file?
QIF (Quicken Interchange Format) is a long-standing plain-text format used by older Quicken versions, GnuCash, and many personal-finance apps.
What can I do with the Tally XML file?
Tally XML is the voucher-import format used by Tally accounting software to bulk-create accounting entries.
Is my financial data private?
Your file is processed only for the conversion, never sold, and not stored by this converter after the conversion runs.
Is there a file size limit?
Files up to 8 MB are supported, which covers even multi-year exports.
Other QIF conversions
Convert other files to Tally XML
Got a bank statement PDF instead?
Statement to Sheets turns statement PDFs into clean Excel, CSV, and accounting exports. Free to try.
Convert a statement