All Collections
Accounting
How to Manually Import Bank Feed Transactions
How to Manually Import Bank Feed Transactions
Ben Q avatar
Written by Ben Q
Updated over a week ago

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

Prepare Your Spreadsheet for Import

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:

  1. Transaction Date

  2. Transaction Amount

  3. Description

Transaction Amounts can be entered in two formats:

  1. Single Column (Amount)

  2. Multiple Columns (Debit/Credit)

The Single Column (Amount) describes bank feeds with transaction amounts in a single column, where the amount is determined by either a positive or negative number.
​
​Multiple Columns (Debit/Credit) describe bank feeds with transaction amounts in multiple columns. If your bank feed has this format, please ensure the amounts are in the correct column, and you'll be prompted to map each column accordingly.

Import Bank Transactions

Step 1: Upload Bank Transactions
The first step to importing bank feed transactions with a spreadsheet is to upload your file to the MyCase application.

  1. Go to the Accounting tab

  2. Select the Banking sub-tab

  3. Click the account you want to upload banking transactions to
    ​

  4. Click the Import Transaction from CSV button
    ​

  5. Click Browse to select the file or drag and drop the file into the space provided.

  6. 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 by clicking the Map Columns button.

Step 3: Map Columns
Map your spreadsheet column list to the required columns.

  1. Select your appropriate Bank Feed Type: Single or Multiple Column,

    Select Corresponding Fields, including the Transaction Date

  2. Select the Date Format

  3. Map the column from your spreadsheet that represents the Transaction Date

  4. Map the column from your spreadsheet that represents the Description

  5. Map the column from your spreadsheet that represents the Category (not required)

  6. Map the column in your spreadsheet that represents the Reference (not required)

  7. Click the Submit button
    ​

Note: Once all selections are made, the fields will change from orange to green.


​Step 4: View Result
Finally, a confirmation message will show how many transactions were successfully imported and any issues that may have occurred.
​

ibf4.png
Did this answer your question?