CSV/ OFX Files

Download your bank transactions as CSV or OFX files

Written By Roaa from Lunch Flow

Last updated 14 days ago

What are CSV / OFX Files?

CSV (Comma-Separated Values) and OFX (Open Financial Exchange) are standard file formats for financial data. Download your transactions in these formats to import them into any financial software, spreadsheet, or accounting tool of your choice.

How to Set Up

1. Add a file export destination in Lunch Flow:

  • Go to the Destinations page

  • Click Add Destination

  • Select CSV / OFX Export

  • Give your export configuration a name (e.g., "Monthly Export")

  • Click Add Destination

2. Configure which accounts to export:

  • Select accounts: Choose which bank accounts to include in your export

  • Set preferences: Configure your export settings

  • Click Save

3. Download your transactions:

  • Go back to the Destinations page

  • Find your file export destination

  • Click the download button to get your transactions in CSV or OFX format

File Formats

CSV (Comma-Separated Values)

Best for: Excel, Google Sheets, custom tools, and data analysis

Includes:

  • Transaction date

  • Amount

  • Description/Merchant

  • Account name

  • Currency

  • Balance

  • Transaction type

OFX (Open Financial Exchange)

Best for: Quicken, QuickBooks, and other accounting software

Includes:

  • Standard OFX format compatible with most financial software

  • Account information and metadata

  • Transaction details in structured format

Importing to Other Software

Excel / Google Sheets

  1. Download the CSV file from your Lunch Flow file destination

  2. Open Excel or upload to Google Sheets

  3. The data will automatically populate in columns

  4. Use for budgeting, analysis, or custom tracking

Quicken / QuickBooks / Accounting Software

  1. Download the OFX file from your Lunch Flow file destination

  2. Open your accounting software

  3. Look for File → Import → Import OFX (or similar)

  4. Select the downloaded file and follow the import wizard

Other Software

Most financial and budgeting software supports CSV or OFX import. Check your software's documentation for specific import instructions.

🔒 Security & Privacy

Your Lunch Flow API token grants access to your transaction data. Keep it secure and never share it publicly.

👉 Learn more about our Security & Privacy — encryption, compliance, and data protection.

FAQ

Which format should I choose?

  • CSV: More universal and works with any spreadsheet software. Best if you need flexibility and custom analysis.

  • OFX: Better for accounting software as it preserves financial metadata and account structure.

How often can I download files?

You can download transaction files anytime you need them. There's no limit on how frequently you can export your data.

Can I export multiple accounts at once?

Yes! When you set up your file export destination, you can select multiple accounts to include. All selected accounts will be included in your download.

Can I create multiple export configurations?

Absolutely! You can create multiple file export destinations with different names and account selections. This is useful if you want different exports for different purposes (e.g., one for personal accounts, another for business accounts).

What date range is included in the export?

The export includes all available transaction history for your selected accounts. The available history depends on when you connected your bank account to Lunch Flow.