Miscellaneous asked questions

Please look for separate articles on frequent "how to" questions that provide advanced details for the specific topic. The rest of the questions is listed here until they are 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.

Use the ProperConvert app to convert your transaction files to required by your accounting software file format.

What are Bank ID and Account number fields

For 2QBO converters, Bank ID has to be up to five digits number. There are good numbers 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 the specific account number and in other software like Sage, it checks the numbers to match the OFX file and the account details.

The 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 the next QBO import with the same account number, QuickBooks will not ask to choose an account and will import directly into a previously chosen account.

Make sure to use different account numbers 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 a bank identifier (bank label) for the QFX/QBO files only. It should be from the '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 to the QFX/QBO file and you will choose an 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 a previously chosen account in Quicken, Quicken imports data into that account automatically.

If you are importing for different accounts in Quicken, use a 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 is shown by QuickBooks during a .QBO file import is defined by INTU.BID value. Default INTU.BID is 3000 (Wells Fargo) and can be changed 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 another bank label.

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

Extract data from a Quicken QDF file.

You need to get a Quicken installed on your computer and then use it to open a QDF file. Once you have a QDF file opened, export data as a QIF file and use the ProperConvert app to export your data to CSV or Excel/XLS/XLSX format.

Search for "Quicken download" and find the latest Quicken installer to access a QDF file. If you know for which Quicken version your QDF file is, download that Quicken installer or next year Quicken installer to access the file (in case your QDF file version is slightly higher then downloaded Quicken verson).

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 the existing account or create a new account. Either one will work - you can just have the transactions under an existing account or cut and paste transactions from a new account to another 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 the 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 than 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 the correct QBO file.

Quicken does not allow you to import QIF data to checking or savings 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 the 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 the 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 transaction, and for transfer, you may provide the account NAME for another account.

QuickBooks does not allow to select of 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 the 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 the 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 another 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 an 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 the credit instead of as a debit (expenditure)

For all conversions and account types (checking or credit card or another 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 a 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 the 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.

Bank2QIF creates importable QIF files for all account types and all Quicken versions.

How to associate a QFX file to a different quicken account?

To import under another account, enter a 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 (for example, INTU.BID 3000 is the Wells Fargo label). You can change it in Bank2QBO on the right sidebar (click the Look Up to find your bank, if your bank is not listed keep the default value).

For multiple accounts, you need to use a 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 the default value (3000, Wells Fargo). The bank label you see during import is not relevant as you are choosing an 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 the 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 the 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 an actual account in Quicken during import, so INTU.BID on the QFX is not related to your Quicken account but has to be from the 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: CSV, Excel, PDF, TXT, MT940, OFX, QFX, QIF, QBO.

The best method to import old brokerage transaction data into Quicken

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

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

IIF or QBJ format. Use Bank2IIF or CSV2QBJ. QBO files do 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 to unlock the 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 which allows setting 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 the category. Use Bank2QIF to convert CSV or Excel files with categories. When a category matches the account name you have in Quicken, Quicken treats it as a transfer.

IMPORTANT: it must be an expense transaction - Quicken ignores income transactions that are treated as transfers 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 the "Change +/-" button to reverse all amounts per the 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 the account in Quicken) and then import the QFX file again. When you import the QFX file, Quicken will ask you to select existing or create a new account and your account should be listed under the 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 Bank2QBO, CSV2QBO or PDF2QBO, click the Look Up button to locate your bank. If your bank is not listed, try using another allowed bank for example INTU.BID 3000 (Wells Fargo) or select any other listed bank. The value is related only to the QFX/QBO file to have it imported - you will choose the 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.

Quicken 2016 is changing account currency on QFX import [guide]

As reported on the Quicken community forum when Quicken 2016 R7 US edition (only this release) a QFX file with USD currency is imported on non-USD account (Quicken allows to choose non-USD account during QFX import), the account currency is changed to USD currency. A user cannot change the account currency back, so this is considered an issue that hopefully will be changed in the next release.

Quicken users face the issue with importing QFX files on non-USD accounts (again, this is about the US edition of Quicken 2016 R7) that could be resolved by changing the currency of the QFX file from non-USD to USD and import the QFX file successfully. With Release 7, importing QFX files with USD currency on non-USD accounts makes the account currency USD.

It is strongly advised to make a backup before importing any file into Quicken.

With release R7, Quicken 2016 US edition users have only one option to import transactions into a non-USD account: convert to QIF file, import into a proxy CASH account, and then move transactions under a non-USD account.

How to extract transactions from Quicken for macOS to Excel?

Quicken for Mac (macOS) exports transactions as QMTF format. This format is similar to the QIF format and the ProperConvert app supports it. Once the QMTF file is loaded, convert to CSV/Excel or another format compatible with your accounting software.

Related articles