Tally XML to QBO converter
Convert a Tally XML file to a QuickBooks Web Connect file (.qbo) in your browser: every transaction, with its date, payee, memo and amount. Your file never leaves your computer. 2 free a day, no sign-up.
No file to hand?
Convert to
Tally needs both ledger names exactly as they are in your company.
New company? Download the ledger setup file too and import it first (Import, then Masters).QuickBooks Desktop needs both account names exactly as they are in your chart of accounts.
QuickBooks makes any account it doesn’t know into a new bank account, so check the spelling.- Runs in your browser
- 2 free a day, no sign-up
- Tally XML in, QBO out
01 / Why convert
Moving books from Tally to QuickBooks? This turns your bank ledger’s vouchers into a .qbo that QuickBooks can import.
02 / What carries over
From Tally XML to QBO, field by field.
What the Tally XML file can hold, and where it goes in the QBO file.
| In the Tally XML file | In the QBO file |
|---|---|
| Date | Kept |
| Amount (money in and out) | Kept |
| Payee or description | Payee (32 characters), full text in the memo |
| Memo (extra text) | Kept |
| Check or reference number | Kept |
| Bank’s transaction ID (FITID) | Not in a Tally XML file |
| Running balance | Not in a Tally XML file |
| Account number | Not in a Tally XML file |
| Category | QBO has no place for it |
| Credit card (not a bank account) | Not in a Tally XML file |
03 / Importing it
Importing the QBO file.
QuickBooks Online
- Bank transactions (All apps, then Accounting), then the Link account menu, then Upload from file.
- Pick the .qbo file, then the QuickBooks account it belongs to.
- Each upload takes up to 1,000 transactions and 350 KB; the converter tells you when a file is bigger.
QuickBooks Desktop
- File, then Utilities, then Import, then Web Connect Files.
- Choose an existing account (or let QuickBooks create one), then review the transactions in Bank Feeds.
04 / The Tally XML file
Getting a Tally XML file.
TallyPrime’s and Tally.ERP 9’s exchange format. Each voucher has ledger lines that balance: a debit is written as a negative amount.
- TallyPrime: open the Day Book (or the bank ledger’s vouchers), press Alt+E (Export), set Format to XML (Data Interchange), then Export.
Have a bank statement PDF instead? The bank statement converter reads it in your browser too.
05 / Good to know
The details that matter.
- Export from TallyPrime as XML (Data Interchange). You pick the ledger: bank ledgers come first. Cancelled and optional vouchers are left out, and Tally’s UTF-16 files are read as they are.
- Converting the same file again gives the same transaction IDs, so QuickBooks and Quicken skip what they already have.
- QuickBooks Desktop may label the account “Wells Fargo”. Web Connect files need a bank id from Intuit’s list, and this is the one most converters use; the transactions are yours.
- QuickBooks Online takes up to 1,000 transactions and 350 KB per upload. The converter tells you when a file is bigger, so you can upload it in parts.
- Payee names are cut to 32 characters, the OFX limit QuickBooks enforces; the full text goes in the memo. Text is written as plain ASCII, which older importers need.
06 / Questions
Straight answers.
Is this Tally XML to QBO converter free?
Yes, for 2 files a day with no account. A free account (just your email, no password) gives you 2 more, and paid plans have no daily limit. It runs in your browser, and nothing is stored.
Is my Tally XML file uploaded anywhere?
No. The file is read and the QBO file is written by code running in this browser tab. Neither is sent to a server. You can check: open your browser’s developer tools, go to the Network tab, and convert a file.
Will QuickBooks import the same transactions twice?
No, as long as you import the same transactions: every transaction has an ID (FITID), and QuickBooks skips IDs it already has. Converting the same file again gives the same IDs.
Which ledger becomes the account?
The bank ledger: ledgers with bank details come first, then any ledger on the bank or cash side of payments and receipts. You can pick another in the panel.
Does it work for credit cards?
Yes. You can also set the account type to Credit card in the panel, and the QBO file is written as a card statement.
07 / More converters
Other files, same idea.
All of them run in your browser. For PDFs, start at the bank statement converter; every converter is on the converters page.