Import Transactions

Transaction Import

Principla Plan transaction import allows the user to import transactions from a file. These can be in the form of a QIF or a OFX file.

File Menu

To import a file selecet "File" then "Import" then whatever type of file you are importing.

Dialog Box

Account

Select which account to import transactions into.

Import Automatically

Import Automatically: Imports only new transactions and ignores transactions determined to be already in the system. If unchecked, all transactions in the file will be imported.

Unclear Missing Transactions: Unclears previously cleared transactions, if they are not listed in the new import file, but should be.

Assume Check Numbers are Unique: Assumes that check numbers are unique. In some rare cases, banks reuse numbers which will confuse the import algorithm.

Max valid check number: Some banks use very large check numbers to indicate other types of transactions. You can indicate that these are not checks by setting a max valid number.

Matching Threshold: The maximum number of days between an existing transaction's date and the import files post date. If the dates are too far apart, the system will assume they are not the same transaction. This is ignored for checks, which often clear the bank many days after the date they are written.

Data Transformation

Envelope: Select the default envelope for all new transactions.

Code +: Enter the code value for all deposit transactions.

Code -: Enter the code value for all payment transactions.

View Imported Transactions

When you confirm your import options you are presented with an account ledger showing newly cleared, newly uncleared and any other uncleared transactions.