Bank & Statement Import

Bring bank transactions into your books through live feeds, PDF extraction, or file uploads -- with intelligent matching that handles categorization for you.

Overview

Kantivo provides three distinct approaches for pulling bank data into your desktop accounting system: live bank feeds, PDF statement extraction, and CSV/Excel file uploads. You can rely on a single method or combine all three depending on your banking situation.

Once transactions arrive, Kantivo's intelligent matching engine categorizes them using your saved rules and learned patterns. The matching engine improves over time, reducing manual categorization with every import.

Bank Feed (Automatic Sync)

Linking your financial institution directly to Kantivo gives you on-demand access to new transactions without manual file handling. This is the fastest path from bank to books on your desktop.

How to Connect Your Bank

1. Open the Bank Import section from the sidebar menu
2. Select 🏦 Connect New Bank
3. Type your bank's name in the search field and pick the correct match
4. Authenticate through the secure, encrypted Teller widget (your credentials never touch Kantivo)
5. Choose which accounts you want linked
6. Connected accounts appear under "Manage Bank Connections"

Mapping Bank Accounts

Once connected, each bank account needs to be paired with a corresponding entry in your local Chart of Accounts:

1. Locate the account under Unmapped Bank Accounts
2. Press Map Account
3. Pick the appropriate local account (for instance, "Business Checking")
4. The account shifts to Mapped Bank Accounts and becomes eligible for syncing

Syncing Transactions

1. Press ⚙️ Initialize to define the starting date for your first retrieval
2. Press 🔄 Sync to pull the latest transactions into Kantivo
3. Retrieved transactions are routed into the Transaction Matching pipeline
4. Use 🔄 Sync All to refresh every mapped account simultaneously

Resetting Sync

If you need to re-fetch transactions from a different starting point, press ↺ Reset on the relevant mapped account and select a new date.

Manual Import Methods

For situations where a live feed is not available or not preferred, Kantivo accepts three file-based import formats:

How to Import CSV/Excel Files

1. Go to Bank Import in the sidebar
2. Press 📁 Import Transactions
3. Browse for your CSV or Excel file
4. Specify the Bank Account the transactions belong to
5. Confirm the correct Date Format
6. Inspect the preview table, then press 🎯 Smart Matching to begin categorization

Statement Bucket (PDF Import)

The Statement Bucket allows you to feed raw PDF bank statements directly into Kantivo's local processing engine. There is no need to convert files to CSV beforehand -- the extraction happens entirely on your desktop.

How to Use Statement Bucket

1. Open 🪣 Statement Bucket
2. Drag your PDF onto the upload area, or click to select a file manually
3. Indicate which financial institution issued the statement
4. Press Process Statement
5. Verify the extracted transactions and import them into your books

Supported Banks

The PDF parser recognizes statement layouts from most major US banks, including:

• Chase
• Bank of America
• Wells Fargo
• Capital One
• Citi
• US Bank
• PNC
• And many more...

Transaction Matching

Every imported transaction passes through the Transaction Matching pipeline. This is where you review, categorize, and approve items before they are committed to your local PostgreSQL ledger.

How to Access Transaction Matching

1. Select 🎯 Transaction Matching from the Bank Import page
2. Browse transactions grouped by their current match stage
3. Approve items that were auto-categorized, or assign categories manually where needed
4. Post approved transactions to your books

Match Stages

Imported transactions are sorted into six stages that reflect how each one was categorized:

Creating Mapping Rules

Mapping rules let you define conditions that automatically assign accounts and entities to incoming transactions. Once a rule is active, recurring charges and deposits are handled without intervention.

How to Create a Rule

1. Open ⚙️ Mapping Rules
2. Press ➕ New Rule
3. Define your conditions (for example, description contains a keyword, amount equals a value, etc.)
4. Select the destination account
5. Optionally link a vendor or customer to the rule
6. Save your rule

Example Rules

Matches Existing Feature

It is common to record a transaction by hand -- such as a check you wrote -- before the corresponding bank charge clears. The "Matches Existing" detector identifies these potential overlaps so you avoid double-counting.

How It Works

• Kantivo compares each imported transaction against records already in your local database
• Matching criteria include dollar amount, date proximity (within 14 days), and description similarity
• Each potential match displays a confidence percentage between 70% and 100%

What to Do

• Yes, Same Transaction: The import is discarded since the entry already exists in your books
• No, Different Transaction: The item moves to the Review stage for proper categorization

Tips & Best Practices

Before Importing

• Confirm that a corresponding bank account already exists in your Chart of Accounts
• Stick to a consistent date format across all your imports to prevent parsing errors
• Process one month of data at a time for more manageable review sessions

Creating Effective Rules

• Partial keyword matches (like "ELECTRIC") catch vendor name variations automatically
• Combining multiple conditions (description plus amount) increases precision
• Assign priority levels to control the order in which rules are evaluated

Efficient Workflow

• Clear the Auto and Rule stages first -- these are the quickest to approve
• Move to Smart matches next, verifying or adjusting the AI's suggestions
• Tackle Review items last, since they require the most manual attention
• Always inspect the Matches Existing stage before posting to prevent duplicate entries

Troubleshooting

Transactions not importing?

• Confirm the file is a supported type: CSV, Excel (.xlsx/.xls), or PDF
• Double-check that the date format you selected matches the format used in the file
• Verify the file contains the three required columns: date, description, and amount

Duplicate transactions appearing?

• Review the "Matches Existing" stage before approving any imports
• Narrow your date range to avoid overlap with previously imported periods
• Check your import history to ensure the same file has not been uploaded twice

Rules not matching?

• Verify rule priority -- higher-priority rules execute before lower ones
• Confirm the keyword is accurate (matching is case-insensitive but the text must be present)
• Use the built-in "Test Rule" function to validate your conditions against sample data

PDF not extracting correctly?

• Make sure the PDF contains selectable text rather than a scanned image
• Experiment with a different bank format selection in the dropdown
• Reach out to support if your bank's statement layout is not yet recognized

Bank feed not connecting?

• Double-check that your bank login credentials are current
• Determine whether your bank requires multi-factor authentication and complete any extra steps
• Some institutions impose temporary rate limits on external connections -- wait a few minutes and retry
• When your bank is not listed, switch to PDF or CSV import as an alternative

Bank feed showing "Disconnected"?

• Financial institutions periodically require you to re-verify your identity
• Press Reconnect and complete the authentication process again
• If you recently updated your bank password, the old session token may have been revoked