Import Transactions

Bring transactions in from a bank file.

Import Transactions

Overview

Principal Plan imports transactions from files downloaded from your bank or financial institution. Open the import dialog from File > Import Transactions and select a file. Three file formats are supported:

Format Extensions Description
CSV .csv Comma-separated values. Supports US and international date formats.
QIF .qif Quicken Interchange Format.
OFX / QFX .ofx, .qfx Open Financial Exchange and Quicken Financial Exchange.

The Import Dialog

The import dialog has two tabs:

All settings are saved per account and restored the next time you import into that account.

Import Workflow

  1. Select a file using the file picker (or let the file watch feature open the dialog automatically).
  2. Choose the target account on the Basic tab.
  3. Adjust the default envelope and any advanced settings as needed.
  4. Click OK to run the import.

During import, Principal Plan parses the file and compares each transaction with existing records. When Smart Import is enabled, matching transactions are linked rather than duplicated, and unmatched cleared transactions within the matching window can be uncleared. New transactions are created with a pending status.

After import, the account ledger opens filtered to show the newly imported transactions. Because imported files usually come from your bank, this is a good time to reconcile the account balance. See Reconciling an Account for the reconciliation workflow.

Checkpoint

If Create Checkpoint Before Import is enabled in Settings — Accounts, a checkpoint of your data file is saved before the import begins. This gives you a restore point if the import produces unexpected results.

File Watch

When both Delete File After Import and Watch for this File are enabled, Principal Plan monitors the file path after import. If the file reappears (for example, from an automated bank download), the import dialog opens automatically for that account. This supports recurring hands-free imports.

Buttons

Button Description
OK Runs the import.
Cancel Closes the dialog without importing.
Help Opens this help topic.

Note: The entire help system is available as a single Markdown file suitable for teaching your favorite AI agent to be your personal Principal Plan expert. Download