Bank statement import and transaction matching

**Purpose**

1.1. Enable automated import of raw bank statements from multiple sources to accounting platforms.
1.2. Auto-match imported transactions to ledger entries, invoices, or expenses.
1.3. Reduce manual reconciliation effort and errors.
1.4. Support compliance and real-time financial tracking for accountants and finance teams.
1.5. Facilitate multi-account, multi-currency data extraction and mapping.
1.6. Prepare reconciled data for reporting, audit, and tax purposes.

**Trigger Conditions**

2.1. New bank statement available in an online banking portal or via email.
2.2. Scheduled daily/weekly import from SFTP, API, or direct bank feed.
2.3. Detection of a new file in secure storage (Dropbox, Google Drive, S3, etc.).
2.4. Receipt of a webhook from a partner or data provider (Plaid, Salt Edge).
2.5. Manual trigger by accountant for off-cycle reconciliation.

**Platform Variants**

3.1. **Plaid**
• Feature: /transactions/get endpoint to fetch transactions; /accounts/balance/get for real-time balances.

3.2. **Salt Edge**
• Feature: /transactions endpoint in Data API for downloading statement data.

3.3. **Bank of America API**
• Feature: CashPro® API, use Account Reporting endpoints (GET /bankstatements).

3.4. **Chase Treasury APIs**
• Feature: /reports/transactions endpoint.

3.5. **Yodlee**
• Feature: Data API /transactions to retrieve raw statement data.

3.6. **Nordigen (now GoCardless)**
• Feature: /transactions endpoint for Open Banking account transactions.

3.7. **Xero**
• Feature: BankStatements API for direct import; Bank Transactions API for matching.

3.8. **QuickBooks Online**
• Feature: Accounting API /banktransactions; use /purchase endpoint for matching.

3.9. **Sage Intacct**
• Feature: Bank feeds import; match via /GLTransaction endpoint.

3.10. **SAP Concur**
• Feature: Expense Import Service for bank feeds; Transaction Match feature.

3.11. **Zoho Books**
• Feature: /bankaccounts/statements API.

3.12. **FreshBooks**
• Feature: Bank Import Tool; /bank_transactions API.

3.13. **Wave**
• Feature: Bank Connection and Transaction Import API.

3.14. **Oracle NetSuite**
• Feature: Banking SuiteApp; import via /bankstatementparser.

3.15. **CSV/Excel Automation**
• Feature: Cloud storage (Dropbox, OneDrive) new file trigger; parse and map.

3.16. **Google Sheets**
• Feature: Google Sheets API to fetch parsed/standardized transaction data.

3.17. **Hubdoc**
• Feature: Bank fetch configuration; auto-push to accounting software.

3.18. **Expensify**
• Feature: Bank Import Rule; transaction auto-matching configuration.

3.19. **Microsoft Power Automate**
• Feature: Connectors for banking platforms and CSV import.

3.20. **AWS S3**
• Feature: Event on new S3 object (bank statement); Lambda function parses and routes.

3.21. **Dropbox**
• Feature: New file in folder trigger; parsed by integration workflow.

3.22. **Google Drive**
• Feature: File upload event; automate with Drive API.

3.23. **Revolut Business API**
• Feature: Transaction listing endpoint to retrieve bank movements.

3.24. **Wise (formerly TransferWise) API**
• Feature: /v3/profiles/{profileId}/statement endpoint.

**Benefits**

4.1. Enhances accounting speed, accuracy, and audit trail.
4.2. Minimizes manual data entry and reconciliation errors.
4.3. Supports multi-bank, multi-currency, and high-frequency transaction operations.
4.4. Delivers up-to-date financial insights and compliance readiness.
4.5. Frees up staff time for higher value tasks and faster closing.