More articles

Miscellaneous asked questions

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.

What is Bank ID and Account number fields

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.

What is INTU.BID and where to get it

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.

When double click a QFX file, nothing happens.

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.

QB thinks it's a Wells Fargo bank, when it's Fidelity Investment

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.

Can I convert a QDF (quicken) file to Excel/ CSV?

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 vs QXF - When I use the file/import in quicken

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 is unable to verify the Financial Institution information for this download. Please try again later.

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 does not allow you to import QIF data to checking or saving accounts

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.

Quicken does not recognize a QFX file create by a ProperSoft converter

ProperSoft converters do not create QXF files, but create QFX (Web Connect) files. Import QFX files through File-Import-Web Connect File.

Can I scan my bank statements into and import into Quicken?

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.

When I import a QIF file into Quicken, "an account must be selected for this import data"

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.

Account transfers in a CSV/Excel file to upload into QuickBooks as a QBO file

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".

QuickBooks supports IIF and QBJ formats that you may use as well to create ACCOUNTING transactions to import into QuickBooks. ProperSoft offers CSV2IIF and CSV2QBJ converters.

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.

QuickBooks does not allow to select an existing account during QBO import

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:

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.

Add 1st Security of Washington or other bank to the list of banks

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:

The amount is being incorporated as credit instead as debit (expenditure)

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.

How to convert amounts without positive or negative sign

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.

How to assign a field to category to convert a CSV file to QFX format

QFX format does not have the category. If you need to import the category, use QIF format.

CSV2QIF or PDF2QIF create importable QIF files for all account types and all Quicken versions.

How to associate the CSV2QFX upload to a different quicken account?

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.

Incorrect bank name applied when a QBO file converted

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:

My bank is not available under bank IDs. When I import into QuickBooks it won't let me edit the financial institution.

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.

Canadian Quicken: the bank information can not be validated during QFX import

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.

Canadian user, Quicken US edition: the bank information can not be validated during QFX import

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.

The converter does not seem to know my bank exists

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.

What is INTU.BID for ONB Bank?

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.

What are the “bank2XXX” converters?

"Bank" means it supports more than one format: OFX, QFX, QIF, QBO.

Best method to import old brokerage transaction data into Quicken

the best would be CSV2QIF as QIF files have simplified requirements for investment transactions.

What is best product to import transactions with categories to QuickBooks?

IIF or QBJ format. Use CSV2IIF or CSV2QBJ. QBO files doe not carry categories.

Am I buying a download, not a CD?

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.

It either catches all the debits or all the credits…but not both

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".

Categories are not available in CSV2QBO mapping

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.

Must categories match in Mint and YNAB before importing from Mint to YNAB?

You may confirm with YNAB developers. They have renaming rules on the import.

Can we categorize the expenses and upload them to QuickBooks online?

No, QBO or CSV files that QuickBooks imports do not carry categories.

QFX Category doesn't transfer from one account to another

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.

Change amount sign changes all the select box for individual rows does not seem to work

Double click the amount to reverse the amount sign for a specific transaction. Use "Change +/-" button to reverse all amounts per whole file.

"chart of accounts" account category on a QBO 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:

Check Numbers on QBO files

Make sure that the Check Number column is mapped. Check the Transactions tab for the Check Number column to have expected values.

Import a QFX file into an existing account in Quicken

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.

Convert a CSV file with a Class column to the QBO format

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.

What is INTU.BID for Capital One?

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.

Can I combine multiple files before converting?

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: