---
title: "Bank Activity Import Overview"
slug: "bank-activity-import-overview"
description: "Import bank activity manually using QBO/QFX, BAI, or CSV file formats from the Bank Activity page in R365."
updated: 2026-08-05T15:25:15Z
published: 2026-08-05T15:25:15Z
canonical: "docs.restaurant365.com/bank-activity-import-overview"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bank Activity Import Overview

Bank activity imports are used to upload transaction data from financial institutions into R365. This method requires downloading a file from the banking institution and importing it into the [Bank Activity page](/doc/docs/bank-activity-page). Manual imports give the user control over what data is imported as well when it is uploaded.

R365 supports importing the following bank file types: [BAI, QBO, QFX](/doc/docs/import-qbo-qfx-or-bai-bank-activity), and [CSV](/doc/docs/import-csv-bank-activity).

> [!NOTE]
> BAI Files
> 
> When BAI is selected, the Bank Account field is disabled.
> 
> The system matches the account identifier in the BAI file to a bank account record using, in order: BAI Account Number, Account Number, then Bank Account Number. The import fails if none of these fields match.

Imported transaction data can be used to create and [match deposits, withdrawals, and AP payments](/doc/docs/bank-activity-update-and-match-transactions). Transactions matched in Bank Activity are automatically selected during the [reconciliation process](/doc/docs/bank-reconciliation).

Prior to importing bank activity, [bank account records](/doc/docs/bank-account-record) need to be setup in R365. Users will be prompted to select the bank accounts to be used for upload in the import process.

Bank activity can also be uploaded through a [Direct Bank Connection](/doc/docs/direct-bank-connections-overview) or [BAI File Transmission](/doc/docs/bai-file-transmission).

> [!NOTE]
> **Bank Activity Duplicate Handling**
> 
> The **Bank Activity Enable Duplicates** setting controls whether duplicate transactions are allowed when importing bank activity. This includes file uploads, direct bank connections, and BAI connections.
> 
> By default, duplicates are **blocked**. To **allow** duplicates, enable this setting on the [System Preferences: Miscellaneous page](/doc/docs/system-preferences-miscellaneous#fields-in-section-b).

---

## QBO & QFX Files

When QBO or QFX is selected, the system reads transaction details directly from the file structure.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-2FAZKVNU.png)

## BAI Files

When BAI is selected, the Bank Account field is disabled.

The system matches the bank account number from the BAI file with the bank account record in R365. An exact match is required to proceed with the import.

> [!NOTE]
> Bank activity can also be uploaded through a [BAI File Transmission](/doc/docs/bai-file-transmission).

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1CCQDMIQ.png)

## CSV Files

For CSV imports, users are required to map fields from the bank file to the corresponding columns on the [Bank Activity page](/doc/docs/bank-activity-page). Learn more about [mapping fields for CSV imports.](/doc/docs/manage-csv-mapping)

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-A4PJU2JL.png)

A file format (Bank Administration Institute) used by banks to export account balance and transaction data. R365 imports BAI files on the Bank Activity page to match transactions before reconciliation.

A Quicken-based bank file format some banks provide for downloading transaction data. R365 reads transaction details directly from the file when it's uploaded on the Bank Activity page.

A Quicken-based bank file format similar to QBO, used to download transaction data from a bank's website. R365 reads it the same way it reads a QBO file, directly from the file structure.

## Related

- [Bank Activity Overview](/bank-activity-overview.md)
- [Uncleared Bank Transactions](/uncleared-transactions.md)
- [Bank Record](/bank-record.md)
- [Direct Bank Connections Overview](/direct-bank-connections-overview.md)