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 CosmoLex 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

Watch a Video

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
• A CosmoLex Certified Consultant
• Our support team

Step 2: Import the File

To import your file:

1. From the left navigation panel, click Accounting.
2. Atop the Accounting left navigation, click Bank.
3. From the Bank screen, either double-click the bank, or single-click it to highlight, and then from the toolbar atop the screen, click Details.
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. In the lower right corner, click Upload.
   The Raw Data Mapping screen opens, displaying the transactions.
   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.