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 within two formats:

  1. Single Column (Amount)

  2. Multiple Columns (Debit/Credit)

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.

Import Bank Transactions

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.

ibf1.png

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.

ibf2.png

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

  1. Make sure you select your appropriate Bank Feed Type: Single or Multiple Column

  2. Select Corresponding Fields, including the Transaction Date

  3. Select the Date Format

  4. Map the column in your spreadsheet that represents the Transaction Date

  5. Map the column in your spreadsheet that represents the Description

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

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

ibf3.png

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.

ibf4.png
Did this answer your question?