Import Transactions

Transaction Import

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

File Menu

To import a file select "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.

Analyze History: Turn on envelope prediction based on matching old transactions.

Match Score: Rough matching score 0-100. Increase this if too many matches are wrong. Reduce to increase the number of matches.

Match Days: This is the number of days to look back when attempting to match.

Payable Regex Filter: Allows regex based transformation of imported Payable To field. Provides a way to clean up some messy fields.

Memo Regex Filter: Allows regex based transformation of imported Memo field.

Swap Payable to and Memo: Swaps the fields.

Swap Payment and Deposit: In some rare cases, the imported transaction sign is backwards resulting in negative deposits and positive withdrawals.

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.