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
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
NoteIf your export statement is in an .ofx file format, you can rename the file extension to .qbo for importing.
Step 2: Import the File
To import your file:
- From the left navigation panel, click Banking.
- From the Bank screen, double-click the bank and scroll down to its Transactions area.
- From the toolbar atop the Transaction screen, click Action > Import Transactions.
- 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.
- On the browser window, locate your file and either double-click it, or single-click it to highlight it, and then click Open.
- The file name populates the Choose File field. 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.