About importing QIF files
A QIF file is a specially formatted text file that's used to
transfer data between financial programs.
Importing
(To
bring information in from another program or Web site and have
Money convert it to the file format Money uses. ) QIF files
is a convenient way to enter transactions into Money without having
to retype the information. You can reconcile transactions in your
Money
account
(A
group of transactions in Money for a single bank, brokerage,
retirement, loan, or credit card account. Accounts can also track
assets such as houses or vehicles, or investments that you want to
watch but do not own. See also watch account.) with
transactions in your imported QIF file. Reconciling prevents:
- Duplicate transactions
These occur if you've already entered transactions into your
Money account and then import a QIF file containing the same
transactions. When reconciling, you can view and remove these
duplications.
- Transactions imported as cleared before
reconciling
These can also occur if a QIF file is imported after your bank
statement
(Bank or brokerage records of transactions processed in
your accounts. Statements can be on paper, or they can be
downloaded or imported from your bank's Web site. ) is
printed (for example, the QIF file may have cleared
transactions (A transaction that has been processed by your bank
or brokerage and that is reflected in your account balance.)
that aren't on the bank statement). When you reconcile your Money
account with the imported QIF file, mark the imported transactions
as uncleared. This will help you if you choose to balance
((Advanced Account Register only) Verify that your bank
balance and your Money account balance agree, after verifying
transactions and making adjustments for items entered into Money
that haven't cleared your bank. ) your account with your
bank statement.
- Account balance not available
The QIF file format does not include account balance
information. Money will be unable to display a balance for these
statements.