Importing Bank Statements

Finance > Bank Accounts > Importing Bank Statements

Importing Bank Statements

Import bank statements in CSV or OFX format to bring transaction data into DiverDash. Review and map imported transactions to your chart of accounts.

Prerequisites

• FINANCE_MANAGE permission to import statements.

• A bank account already added in DiverDash.

• A bank statement file in CSV or OFX format from your bank.

## Overview

Importing bank statements brings your bank's transaction data into DiverDash. This saves you from manually entering every bank transaction. After import, you review the transactions and map them to accounts in your chart of accounts. Imported transactions are then available for reconciliation.

Supported Formats

Format	Description
CSV	Comma-separated values. Most banks offer CSV exports. Column mapping may be required.
OFX	Open Financial Exchange. A standard format supported by many banks. Columns are mapped automatically.

Importing a Statement

1. Navigate to Finance > Bank Accounts.

2. Click the bank account you want to import into.

3. Click Import Statement.

4. Select the file format: CSV or OFX.

5. Upload the statement file.

6. Click Upload.

CSV Column Mapping

If you upload a CSV file, DiverDash prompts you to map the columns:

1. Review the preview of your file's first few rows.

2. Map each column to the correct field:

   • Date: The transaction date.

   • Description: The transaction description or memo.

   • Amount: The transaction amount. Specify if your file uses separate debit/credit columns or a single amount column.

   • Reference: Optional. A reference number or check number.

3. Click Continue. OFX files are parsed automatically. No manual mapping is needed.

Reviewing Imported Transactions

After upload, DiverDash displays the imported transactions for review.

1. Browse the list of imported transactions.

2. For each transaction, verify:

   • The date is correct.

   • The description matches your bank statement.

   • The amount is accurate.

3. Assign each transaction to an account in your chart of accounts.

4. Mark transactions to import or skip (e.g., duplicates).

5. Click Confirm Import. Confirmed transactions are added to DiverDash and become available for reconciliation.

Mapping to Chart of Accounts

Each imported transaction needs an account assignment:

• Expenses: Map to the appropriate expense account (e.g., fuel purchases to "Fuel Expense").

• Income: Map to the appropriate income account (e.g., course payments to "Course Revenue").

• Transfers: Map to another bank or asset account if the transaction is a transfer between accounts.

DiverDash may suggest account mappings based on previous imports with similar descriptions.

Handling Duplicates

DiverDash checks for potential duplicates during import:

• Transactions with the same date, amount, and description as existing records are flagged.

• Review flagged transactions and choose to skip or import them.

• It is better to skip a suspected duplicate and verify manually than to create duplicate entries.

Tips

• Download statements in OFX format when available. It requires less manual mapping than CSV.

• Import statements regularly (weekly or monthly) to keep records current.

• Review every imported transaction before confirming. Automated imports can include bank fees or charges you may want to categorize separately.

• Save your CSV column mapping preferences. DiverDash remembers mappings for future imports from the same bank.

Troubleshooting

Problem	Solution
CSV file not parsing correctly	Check that the file is a valid CSV with consistent columns. Remove any header rows or footers added by your bank.
OFX file not recognized	Ensure the file has an .ofx extension and is a valid OFX file. Some banks use .qfx which is compatible.
Duplicate transactions imported	Use the duplicate detection during review. If duplicates were imported, void the duplicate entries.
Account mapping dropdown is empty	Ensure you have active accounts in your Chart of Accounts.
Date format is incorrect	Check the date format in your CSV. DiverDash expects common formats (YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY). Adjust column mapping if needed.

Related Pages

• Bank Accounts Overview

• Adding a Bank Account

• Bank Reconciliation

• Chart of Accounts

Next Steps

• Reconcile Bank Transactions to match your imported statements with DiverDash records.