Most firms choose to import their bank feed through the MyCase integration with Plaid (learn more here). However, if you want to import your transactions manually or your financial institution does not support Plaid, you can still import your transactions via a spreadsheet (.csv file).

Prepare Spreadsheet for Import
Import Bank Transactions

Before importing your file into MyCase, you want to prepare it to ensure that everything is accurate and there are no duplicate entries. While you won't need to have a specific format, three required fields must be included in your spreadsheet:

Transaction Amounts can be entered within two formats:

Single Column Format describes bank feeds with transaction amounts in a single column where the amount is determined by either a positive or negative number.

Multiple Columns Format describes bank feeds with transaction amounts in multiple columns, Debits and Credits. If your bank feed has this format, please ensure that the amounts are in the correct column, and you'll be prompted to map each column accordingly.

Step 1: Upload Bank Transactions
The first step to importing your bank feed transactions via a spreadsheet is to upload your file to the MyCase application. Complete this by clicking to browse to select the file or drag and drop the file into the space provided. Once this is done, click the Upload Bank Transactions button.

Step 2: Processing Transactions

During this step, a preview of the imported spreadsheet is shown. Confirm that all columns are imported correctly and that the data appears correctly. Then, map these columns to the appropriate MyCase fields.

Step 3: Map Columns
As shown below, map the columns list in your spreadsheet to the required columns.

Step 4: View Result
Finally, there will be a confirmation message showing how many transactions were successfully imported or any issues that may have occurred.