Please look for separate articles on frequent "how to" questions that provide advanced details for specific topic. The rest of questions is listed here until they added to a separate "advanced" article. You should find small but important details here if you are looking for an answer. Open a support ticket if your question is not answered here by advanced articles.
For 2QBO converters, Bank ID has to be up to five digits number. There are good number and bad numbers for QuickBooks, leave empty and the converter will use a good number.
For 2OFX converters and some accounting software like Sage, it is important to set bank id, branch id, account id to match what you have set for an account in your accounting software.
In QuickBooks you get to choose an account during the first QBO file import for specific account number and in other software like Sage, it checks the numbers to match OFX file and the account details.
Account number is important to use for multiple accounts, as QuickBooks links the account number on the QBO file to the account in QuickBooks you choose during import. For next QBO import with the same account number, QuickBooks will not ask to choose an account and will import directly into previously chosen account.
Make sure to use different account number when you convert transactions for different accounts.
INTU.BID is not a bank ID. If you have Quicken or QuickBooks installed on your computer, start CSV2QBO and click Look Up to locate your bank INTU.BID. Make sure the bank is listed for the account type you are converting your transactions for (checking vs credit card).
INTU.BID is bank identifier (bank label) for the QFX/QBO files only. It should be from 'allowed' bank to have your QFX/QBO file imported. If your bank is not listed, you can leave default value 3000 (Wells Fargo) - this is only only to the QFX/QBO file and you will choose actual account to import into during the import in Quicken/QuickBooks.
Quicken reads a QFX file and if it finds the account number on a QFX file is already "online linked" to previously chosen account in Quicken, Quicken imports data into that account automatically.
If you are importing for different accounts in Quicken, use different account ID when you convert to a QFX file. Quicken will link different account numbers to different accounts in Quicken.
The bank label shown by QuickBooks during a .QBO file import, is defined by INTU.BID value. Default INTU.BID is 3000 (Wells Fargo) and can be change by clicking on the Look Up button. If your bank is not listed, keep the default value to have your QBO file imported and ignore the Wells Fargo or other bank label.
For QDF, you need to open it in Quicken and then export as QIF. Once you have the QIF file, you can use QIF2CSV converter to convert to CSV or Excel format.
QFX is a Web Connect file. In Quicken, select File-Import-Web Connect
When you select the QFX file, you will be offered to choose existing account or create new account. Either one will work - you can just have the transactions under existing account or cut and paste transactions from new account to other account.
QFX files have INTU.BID - QFX bank identifier - it can be any 'allowed' bank and you can change it before converting to a QFX file.
QXF is not QFX format and cannot be used to import transactions. It is used to transfer whole data file from one Quicken to another.
QuickBooks has to be no older the three years to import .QBO files. Once QuickBooks is older than three years (usually the end of May is the cut-off date), QuickBooks does not import .QBO files anymore.
If your QuickBooks is good, but the file is not importing, then your QBO file is not correct. Use Bank2QBO to convert it to correct QBO file.
Quicken 2017, 2014 for PC/Windows and earlier imports 'correct' or 'importable' QIF files directly into bank or credit card accounts. Your Quicken must be Deluxe or higher edition. Quicken Starter edition does not import QIF files directly into bank or credit card accounts.
Quicken 2015, 2016 for PC do not import QIF files into bank or credit card accounts. Import QIF files into a cash account first and then move transactions under another account.
To import a QIF file under a cash account, the QIF file must not have an account header or have the account header with exact cash account name. Look for the QIF target option as "Quicken 2015-2016 for PC" when you convert to a QIF file.
ProperSoft converters do not create QXF files, but create QFX (Web Connect) files. Import QFX files through File-Import-Web Connect File.
If you have a good scanner and then software supporting export to excel, then you can use CSV2QFX or CSV2QIF to convert and load your transactions into Quicken. The scanning/recognition phase would be the most time and effort consuming.
The message means your QIF file is missing the account header and your QIF file is not a 'correct' QIF Quicken file. You can import into a cash account and then move transactions (cut and paste transactions) under another account.
The QBO format is a format you download from your bank or credit card company, so QBO files provide date, amount, payee, memo, check number details about transactions.
Transfers are not things covered by QBO or other similar formats. Accounting software usually provides you ability to select two transactions under different accounts with the same date and amount and declare both of them a "transfer".
For CSV2IIF, your CSV file must have the column called Category where you provide expense/income account for each transactions, and for transfer you may provide the account NAME for other account.
If an account is not listed under the existing account list when you import a QBO file, it means that the account is already "online linked". Please do the following:
in QuickBooks, open the Chart of accounts
select the account and click Edit account (pencil button)
click Online Settings button
select "Not enabled" and save changes
It is also important that you select correct account type (checking vs credit card) in CSV2QBO before saving the QBO file. QuickBooks checks the account type on the QBO file and if it sees the checking type, it will show you only checking accounts to select.
If you need to link back to your bank, remove online link after you import the QBO file the same way as described above and connect back to the bank.
The list of "allowed" banks you see in CSV2QBO is provided by QuickBooks installed on your computer. If your bank is not listed, use the default INTU.BID value 3000 (Wells Fargo).
The INTU.BID value has to be for any "allowed" bank, but the bank label you see during import is not relevant as you are choosing actual account in QuickBooks to import into.
IMPORTANT: if you have your existing account "linked" to direct bank download, you need to edit the account in QuickBooks first as QuickBooks does not import QBO files on already linked accounts and the account has to be unlinked first:
open the chart of accounts
select an account and click "Edit account" (pencil) icon
click Online Settings and select "not enabled".
For all conversions and account types (checking or credit card or other type), expenses (withdrawals) must be negative and payments to the account (deposits) must be positive. Some credit card companies provide CSV files with expenses as positive amounts and credit card payments as negative amounts, use "Change +/-" once per CSV file to reverse all amounts on the file before converting.
If your bank provides a CSV export files where the amount sits in a field without a positive or negative sign and the sign or some indication like word DEBIT or CREDIT is on a separate column, use the "record type" column in mapping to tell the parser where to look for the amount sign.
QFX format does not have the category. If you need to import the category, use QIF format.
To import under other account, enter different account ID before saving the QFX file.
When you will import this QFX file for the first time, Quicken will ask to select the account during import.
The bank label you see during import is defined by INTU.BID value on the QBO file (default is 3000, Well Fargo). You can change in CSV2QBO on the Settings tab (click the Look Up to find your bank, if you bank is not listed keep the default value).
For multiple accounts, you need to use different account #(ID) before saving the QBO file. You can use actual account IDs to avoid confusion.
The bank label you see during import is no more than a label you are choosing actual in QuickBooks to import into.
QuickBooks assigns INTU.BID+Account ID from the QBO file to the account you choose during import. You can remove this link by editing the account:
open the chart of accounts, select account and click Edit account
If your bank is not listed, keep default value (3000, Wells Fargo). The bank label you see during import is not relevant as you are choosing actual account in QuickBooks into which the transactions will be imported. The Wells Fargo label will show in bank feeds, which you have to select and click the Transaction list button to match transactions and add them to the register.
Before converting to a QFX file, click the Canada button to set default INTU.BID for a Canadian bank and create a new QFX file.
Before converting to a QFX file, click the US button to set default INTU.BID for a US bank and create a new QFX file.
Correct INTU.BID setting allows your file to be imported. You will choose actual account in Quicken during import, so INTU.BID on the QFX is not related to your Quicken account, but has to be form allowed bank.
Some INTU.BID values are good for bank and credit card accounts, and some only for either bank (checking, savings) or credit card accounts. If you use an INTU.BID supporting only one account type, you can convert to QFX/QBO files only for that account type. Use INTU.BID values supporting both account types.
Click the Look Up button in the converter to locate INTU.BID value for your bank. If your bank is not listed, use any other listed value supporting the account type (bank or credit card) for which you are converting your transactions.
"Bank" means it supports more than one format: OFX, QFX, QIF, QBO.
the best would be CSV2QIF as QIF files have simplified requirements for investment transactions.
Yes, you can download unlimited times before and after the purchase.
Your order is the registration code you use unlock downloaded trial application into the full version.
If your CSV or Excel file has two separate amount columns (DEBITS AND CREDITS or WITHDRAWALS AND DEPOSITS), click the Review Mapping button and map the Withdrawal and Deposit columns and set the Amount column to "do not use".
QBO format does not carry the category. QuickBooks provides renaming rules, and also passes the expense account assigned to the vendor in your QuickBooks records to imported transactions. You may also try CSV2IIF that allows to set category and class.
You may confirm with YNAB developers. They have renaming rules on the import.
No, QBO or CSV files that QuickBooks imports do not carry categories.
QFX format does not carry category. Use CSV2QIF to convert CSV or Excel files with categories. When a category matches the account name you have in Quicken, Quicken treat it as a transfer.
IMPORTANT: it must be an expense transaction - Quicken ignores income transactions that treated as transfer as it expects another pair transfer transaction to exist.
Double click the amount to reverse the amount sign for a specific transaction. Use "Change +/-" button to reverse all amounts per whole file.
Can Web Connect import (.QBO file) into QuickBooks include the "chart of accounts" account as a column, or does this have to be done manually for each credit card import transaction within QuickBooks?
QBO files do not have the category field. QuickBooks assign the category during import based on the following:
If a payee has associated expense account (category), it will be used for imported transaction. Edit the payee/vendor list categories before importing
Make sure that the Check Number column is mapped. Check the Transactions tab for the Check Number column to have expected values.
If you have an existing account in Quicken and it is "online linked", please unlink it first (it is called "Deactivate downloads" when you edit account in Quicken) and then import the QFX file again. When you import the QFX file, Quicken will ask to select existing or create new account and your account should be listed under existing account.
QBO format does not have the Class field (but IIF does, use CSV2IIF to convert). QuickBooks offers renaming rules to assign the class during import based on payee name and description patterns.
In CSV2QBO or PDF2QBO, click the Look Up button to locate your bank. If your bank is not listed, leave the default value 3000 (Wells Fargo) or select any other listed bank. The value is related only the QFX/QBO file to have it imported - you will choose actual account during import.
Yes, you can select multiple files on the file dialog and they all will be loaded into the converter and parsed. You may need to click the date column to sort transactions by date before converting. Make sure the transactions are for the same account.
Related articles for: