Skip to main content

​
CSV/PDF Import System

AI2Fin supports importing financial data from various sources including CSV files and PDF bank statements. This flexible import system works with any bank or financial institution’s export formats worldwide.

Start Importing

Access the Bank Transactions page to upload your CSV or PDF files.

​
Supported File Formats

​
File Types Supported

CSV Files

CSV Support:
  • Bank statement exports
  • Credit card statements
  • Accounting software exports
  • Custom CSV formats
  • Multi-currency data

PDF Files

PDF Support:
  • Bank statement PDFs
  • Credit card PDFs
  • Receipt PDFs
  • Invoice PDFs
  • Multi-page documents

​
Global Bank Support

AI2Fin works with any bank worldwide that provides CSV or PDF exports. The system automatically detects and processes common formats from banks globally.
Supported Formats:
  • Any CSV export from banks worldwide
  • PDF bank statements from any institution
  • Credit card statement exports
  • Accounting software exports (QuickBooks, Xero, etc.)
  • Custom business CSV formats
Flexible Processing:
  • Automatic field detection
  • Multiple date formats
  • Various currency formats
  • Different decimal separators
Essential Fields:
  • Date: Transaction date (any standard format)
  • Description: Transaction description or merchant name
  • Amount: Transaction amount (positive/negative or debit/credit)
Optional Fields:
  • Balance: Account balance after transaction
  • Reference: Transaction reference number
  • Type: Transaction type
  • Category: Existing category (if available)

​
Import Process

​
Step-by-Step Import

1

Prepare Your File

  1. Export transactions from your bank or financial institution
  2. Ensure file is in CSV or PDF format
  3. Check required data fields are present
  4. Remove any password protection
2

Upload to AI2Fin

  1. Go to Bank Transactions page
  2. Click “Upload CSV” or “Upload PDF” button
  3. Select your file
  4. Confirm file details
3

Map Data Fields

  1. Review automatic field detection
  2. Confirm date format
  3. Check amount format
  4. Verify description field
4

Process Transactions

  1. Review import summary
  2. Start processing
  3. Monitor progress
  4. Review results

​
Automatic Field Detection

Smart Detection

AI2Fin automatically detects and maps common field names from banks worldwide, regardless of language or format.
Date Fields:
  • Date, Transaction Date, Posted Date
  • Effective Date, Processed Date
  • Value Date, Settlement Date
Description Fields:
  • Description, Transaction Description
  • Details, Particulars, Narration
  • Payee, Merchant, Reference
Amount Fields:
  • Amount, Transaction Amount
  • Debit, Credit, Net Amount
  • Withdrawal, Deposit
When Manual Mapping is Needed:
  • Non-standard field names
  • Custom CSV exports
  • Third-party software exports
  • International bank formats
Mapping Process:
  1. Select source field
  2. Choose target field
  3. Preview mapping result
  4. Confirm and proceed

​
Data Processing

​
Automatic Processing

AI Categorization

Automatic Features:
  • Smart transaction categorization
  • Merchant identification
  • Business/personal classification
  • Tax deductibility assessment

Data Validation

Validation Checks:
  • Date format validation
  • Amount format checking
  • Duplicate detection
  • Data completeness verification

​
Processing Options

Processing Options:
  • Skip Duplicates: Automatically skip existing transactions
  • Update Existing: Update existing transactions with new data
  • Create New Only: Only import new transactions
  • Full Replace: Replace all existing data
Date Range:
  • Import all transactions
  • Import from specific date
  • Import within date range
  • Skip future-dated transactions
Automatic Cleaning:
  • Remove extra spaces and characters
  • Standardize date formats
  • Normalize amount formats
  • Clean description text
Manual Review:
  • Review flagged transactions
  • Correct data issues
  • Handle special characters
  • Validate business transactions

​
Import Results

​
Processing Summary

Import Summary

View detailed import results including successful imports, errors, and warnings.
Import Statistics:
  • Total transactions processed
  • Successfully imported count
  • Failed imports count
  • Duplicates skipped
Processing Details:
  • Import duration
  • Processing speed
  • Data quality score
  • AI categorization accuracy
Common Import Errors:
  • Invalid date formats
  • Missing required fields
  • Corrupted data
  • File format issues
Error Resolution:
  • Detailed error messages
  • Suggested fixes
  • Data correction tools
  • Re-import options

​
Post-Import Actions

1

Review Imported Data

Check imported transactions for accuracy and completeness.
2

Verify AI Categorization

Review AI categorization suggestions and make corrections as needed.
3

Handle Errors

Address any import errors or data quality issues.
4

Update Categories

Refine categories and rules based on imported data.

​
Advanced Features

​
Bulk Import Management

Multiple File Import

Batch Processing:
  • Import multiple CSV/PDF files
  • Process files sequentially
  • Combine data from multiple accounts
  • Merge import results

Scheduled Imports

Automation:
  • Set up recurring imports
  • Automatic file processing
  • Email notifications
  • Import status monitoring

​
Data Integration

Multi-Account Support:
  • Import from multiple bank accounts
  • Map accounts to categories
  • Track account-specific transactions
  • Generate account-based reports
Account Configuration:
  • Set account names and types
  • Configure account-specific rules
  • Set default categories
  • Manage account visibility
Historical Import:
  • Import historical transactions
  • Maintain transaction history
  • Year-over-year comparisons
  • Long-term trend analysis
Data Archival:
  • Secure data storage
  • Historical data access
  • Backup and recovery
  • Data retention policies

​
Best Practices

​
File Preparation

File Quality

Ensure files are clean and properly formatted before import.

Date Consistency

Use consistent date formats across all imports for better processing.

Regular Imports

Import data regularly to maintain up-to-date financial records.

Data Validation

Review imported data for accuracy and completeness.

​
Import Optimization

Optimization Tips:
  • Import in smaller batches for large files
  • Use consistent field naming
  • Clean data before import
  • Review import settings
Performance:
  • Optimal file sizes (under 10MB)
  • Standard CSV/PDF format
  • Minimal formatting
  • Clear field headers
Quality Assurance:
  • Verify bank export accuracy
  • Check for missing transactions
  • Validate amount calculations
  • Review description clarity
Maintenance:
  • Regular data audits
  • Update import rules
  • Monitor categorization accuracy
  • Refine business rules

​
Troubleshooting

Common Issues:
  • File format not supported
  • Missing required fields
  • Invalid date formats
  • Corrupted file data
Solutions:
  • Check file format and encoding
  • Verify field headers
  • Standardize date formats
  • Clean file data
Quality Problems:
  • Incomplete transaction data
  • Incorrect categorizations
  • Duplicate transactions
  • Missing business context
Resolution:
  • Review and correct data
  • Provide AI feedback
  • Remove duplicates
  • Add business context

​
Security & Privacy

​
Data Protection

Secure Upload

Security Features:
  • Encrypted file upload
  • Secure data transmission
  • Protected data storage
  • Access control

Privacy Compliance

Privacy Features:
  • GDPR compliance
  • Data minimization
  • User consent management
  • Right to deletion
Ready to import your data? Visit the All Transactions page to start importing your bank statements, or explore Smart Categorization to learn how AI processes your imported data. AI2Fin CSV/PDF Import - Seamlessly integrate your financial data with intelligent processing.