Contents x
    Import QBO, QFX, or BAI Bank Activity
    • 06 Jan 2025
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Import QBO, QFX, or BAI Bank Activity

    • Updated on 06 Jan 2025
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Bank activity imports allow users to upload transaction data from their financial institutions into the Bank Activity page where users can match of bank transactions with records in R365 before starting bank reconciliation. This method requires downloading a file from the banking institution and importing it into the Bank Activity page. Imported transaction data can be used to create and match deposits, withdrawals, and AP payments.

    Bank activity can also be uploaded through a Direct Bank Connection or BAI File Transmission or with a CSV file.

    Security

    To import bank activity, users must have the following permission:

    Banking → Bank Activity → Process Bank Activity

    Import QBO, QFX, or BAI Bank Files

    Click steps to expand for additional information and images.

    1) Download bank activity from the bank website.

    Users can download bank transactions from their desired bank account and date range.

    Example Screenshot:

    R365 Tip

    The QuickBooks or Quicken format option typically produce the QFX or QBO file format.

    2) In the accounting application, hover over Banking, then select Get Bank Activity.

    The Bank Activity page will open.

    3) Click Upload a File in the top ribbon.

    4) Select the Bank Account to upload transactions to.

    5) Select the desired File Type: QBO/QFX or BAI.

    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.

    6) Click Select Files to open the files explorer.

    7) Navigate to the Downloads folder.

    8) Find and select the downloaded bank file.

    The transactions from the file will populate on the bank activity page.

    Troubleshooting

    BAI

    • Failed Import

      • Issue:

        • Bank Activity is not uploaded.

      • Resolution:

    • BAI File Type

      • Issue:

        • bai2 file type is provided instead of bai.

      • Resolution:

        • Rename the file from bai2 to bai.

          • E.g. ABC.bai2 would be renamed to ABC.bai .

    Was this article helpful?
    What's Next