How To Import Bank Transactions

If you choose to sync a bank account, FINSYNC will automatically import up to the last 90 days of transactional activity. In addition, FINSYNC will continue  to import new transactions daily. However, if you wish to add transactions more than 90 days old, or you do not wish to sync your bank account, you can manually import transactions.

You can either watch the video or follow the steps below to learn more on Importing Transactions

 



Please Note:

It is recommended to use a CSV file for import and also recommended to use the import template available in the Import screen within FINSYNC. Follow steps 1-3 below to access the CSV import template.

The dollar amounts for transactions must have a negative in front (to the left) of the number for any transaction that deducts from the account.

1. Click on the Banking tab from the top menu. On the left menu, click the bank account or charge account you with to use for importing transactions. 

2. Click the Import button located in the upper-right section of the screen

 

3. From Step 1 on the Import Transactions view (Image placed below), you can download a template file that shows the expected fields and format of the source data.

You are not required to use this template file. If you are able to download a CSV file from your bank's website that includes at least the transaction dates and amounts, you may be able to import this data directly.

4. Select Select File to locate your source CSV or Excel file.

 

5. In Step 3, select whether your source file has separate columns for payments and deposits or if they are combined in one column (as positive and negative numbers). Negative numbers must be displayed with a negative sign to the left of the number.

6. In Step 4, select each of the field names in FINSYNC that match the fields in your source file. For example, your source file may have a field called Category, which would be matched to the Account field in FINSYNC. This must match to the specific Chart of Account entries within FINSYNC. If you are not sure of the values, this should not be mapped and imported and these values can be updated directly within FINSYNC after the import.

7. Select Import Transactions. You will be notified of any issues with the data in your file, such as improperly formatted dates or empty fields.

It may take some time to complete the import and this will depend on the number of transactions. A status message will appears when the import is complete.

Look for these issues in your source file that can cause the import to fail:

  • Your "Amount" column(s) includes values of zero (0.00) or no value.
  • Your "Amount" column(s) includes non-numeric values.
  • A column from your file is matched with the wrong FINSYNC value. For example, your "Amount" column is matched with the "Account" value.