QBO to Tally XML converter
Convert a QuickBooks Web Connect file (.qbo) to a Tally XML file 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?
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
- QBO in, Tally XML out
01 / Why convert
Transactions downloaded for QuickBooks can go into TallyPrime too: each becomes a Payment or Receipt voucher against your bank ledger.
02 / What carries over
From QBO to Tally XML, field by field.
What the QBO file can hold, and where it goes in the Tally XML file.
| In the QBO file | In the Tally XML file |
|---|---|
| Date | Kept |
| Amount (money in and out) | Kept |
| Payee or description | In the narration |
| Memo (extra text) | In the narration |
| Check or reference number | In the narration |
| Bank’s transaction ID (FITID) | Tally XML has no place for it |
| Account number | The ledger name you type |
| Currency | Tally XML has no place for it |
| Credit card (not a bank account) | Tally XML has no place for it |
03 / Importing it
Importing the Tally XML file.
TallyPrime
- Open the company. New company? First import the ledger setup file: Alt+O (Import), then Masters.
- Then Alt+O (Import), then Transactions, and pick the vouchers file.
- Import each file once: Tally does not skip vouchers it already has.
Tally.ERP 9
- Gateway of Tally, then Import of Data, then Vouchers (Masters for the ledger file).
04 / The QBO file
Getting a QuickBooks Web Connect file (.qbo).
Intuit’s bank download for QuickBooks: an OFX file with Intuit’s bank id added. It carries each transaction’s date, amount, payee, memo, check number and the bank’s own transaction ID.
- Online banking: Transactions, then Download, then “QuickBooks Web Connect (.qbo)”.
Have a bank statement PDF instead? The bank statement converter reads it in your browser too.
05 / Good to know
The details that matter.
- A QBO file with several accounts (checking and savings in one download, say) lets you choose the account.
- OFX 1.x and 2.x are both read, along with the bank’s corrections to earlier transactions.
- Tally refuses the whole file if a ledger in it doesn’t exist, so type both ledger names exactly as they are in your company. The ledger setup file creates them in a new company.
06 / Questions
Straight answers.
Is this QBO to Tally 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 QBO file uploaded anywhere?
No. The file is read and the Tally 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 importing twice create duplicates in Tally?
Yes: Tally XML has no duplicate check, so import each file once. If you need to redo it, delete the imported vouchers first.
My QBO file has several accounts. Which one is converted?
The first, until you choose another: when a file holds more than one account (checking and savings, say), the panel lists them all.
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.