Import Bank Transactions via QBO/Excel/CSV File

You can import transactions from your operating, trust, and credit card accounts.

Your firm would likely import bank transactions when:

• Migrating to the application for the first time
• Transferring transaction history from another source rather than just starting with the correct chart of account balances
• Importing monthly credit card statement transactions

Step 1: Export the Transactions from Your Bank/Accounting Program

The two most common sources of firm transaction exports are:

• Exporting an Excel or CSV file from your firm’s previous accounting program
• Exporting a QBO statement from your bank’s website. Almost all banks offer this file format, and it is the easiest format to import.

If your bank does not offer the QBO file format, you can use any of these options to convert your file:

• A third party utility
• Our support team

Step 2: Import the File

To import your file:

1. From the left navigation panel, click Banking.
2. On the Bank screen, double-click the bank.
3. From the tabs atop the Bank’s details, click Transactions.
4. From the toolbar atop the Transaction screen, click Action > Import Transactions.
5. From the Import Transactions screen, Click Choose File.

   Important
   The system displays:

   • A green Matched icon beside a transaction with only one match of the same date and amount.
   • A green Matched icon beside a transaction, if the ref.# and amount of transactions match for check withdrawals.
   • A gray Matched icon beside a transaction, if there is more than one match of the same amount, or same date and amount found. To find the right match, click on the orange Details icon to the right.
   • A gray Add icon indicating no match exists and you must add the transaction.
6. On the browser window, locate your file and either double-click it, or single-click it to highlight it, and then click Open.
7. The file name populates the Choose File field. To the right of Choose File, click Upload.
   The Raw Data Mapping screen opens, displaying the transactions.
8. From the drop-downs in the header, define your column names.
   This may not be necessary for all the columns but you must define columns for date, payee name, and amount.
9. Once you have defined the column names, you can add a mapping profile which helps you to import future transactions to the same profile.
10. From the toolbar atop the imported transaction screen, click on the save icon beside mapping profile.
    
11. In the New Mapping Profile window that opens, give your profile a name which could be your bank account name or type.
12. The radio button below will default to the bank type selected but you can choose another bank type.
13. Once you have entered your profile name and selected your bank type, click Save.
14. 
    Important: The transactions are displayed for review purposes only. You must add or match a transaction to import it.

Once you import your transactions, see Manage Transactions Received via Bank Feed or Import File.