1. CSV (Comma-Separated Values)
2. QBO (QuickBooks Online)
3. IIF (Intuit Interchange Format)
4. QIF (Quicken Interchange Format)
5. OFX (Open Financial Exchange)
6. TXT (Text files)
   

Steps to Import Bank Transactions

1. Open Cloud Banking. From the CustomBooks™ application Home Page, click the Cloud Banking icon within Accounting & Banking, or from the left menu, go to Bank > Cloud Banking.
   
2. In Cloud Banking, select the bank account in the Account dropdown field.
3. Click the Upload/Import from a File button (CSV icon) on the yellow command bar. It might be in the More Actions dropdown depending on your resolution or screen size.
   
4. Download the file. Login to the bank website and then download the bank transactions. The Bank Import Wizard supports *.csv, *.qbo, *.iif, *.qif, *.ofx, and *.txt formats. When the file is downloaded and ready to import, click the Open Import Wizard button.
   
   
   
   
5. File Mapping. On the Import Wizard: File Mapping window, choose the file from your computer disk. Enter the column # that correspond to the CustomBooks™ fields or select it from the CustomBooks™ Field column. Once the file mapping is done, click the Continue button.
   
   CustomBooks™ Fields: Date, Description, Money in (deposit), Money out (payment), Money in and Money out (if the deposit and payment amount is in the same column), Check Number, Memo, Currency.
   
   
   
   Note: The Bank Import Wizard CSV Mapping is also accessible through the CSV Mapping TAB on the bank account details in Chart of Accounts.
   
   
   
   
   
6. File Reading and Consistency Check. The Bank Import Wizard will show a preview of the bank transactions, it also shows if there are errors or incorrect mapping. Using the Back button, you can review and correct the mapping. Click Continue button to proceed.
   
   
   
   
7. Specifying the Date Range. Choose whether you would like to upload all the transactions or specify the date range. Then click the Continue button to finalize and complete the bank transactions import.
   
   

Importing Transactions to an Online Bank Account

If you manually import bank transactions to a bank account that is already connected to Cloud Banking, the Bank Import Wizard has a safeguard in place to prevent duplication of transactions. When you import transactions to an online bank account, it will only import transactions with dates before the bank feed start date. This is designed to prevent the import of transactions that have already been fetched by the automatic bank feed.

It’s important to be aware of potential issues that can arise if the period of the bank transactions you’re trying to import overlaps with the bank feed start date. Here are some problems you might encounter:

1. Invalid Period Error: Error message "The file doesn't contain transactions prior to m/d/yyyy (bank feed start date). Please upload another file". This error occurs when the file doesn’t contain transactions prior to the bank feed start date. The system expects to find transactions from before the bank feed start date when you’re manually importing transactions.
   
   Example: The bank transactions period you're trying to import is from 2/9/2024 to 2/12/2024. When you connected the bank account to online banking, you set the bank feed start date to 1/1/2024. Since the transactions period (2/9/2024 - 2/12/2024) isn't before the bank feed start date (1/1/2024), the bank import wizard will not import the transactions and gives an alert or error message instead.
   
   
   
   
2. Incomplete Import: If the bank feed start date falls within the period of the bank transactions you’re trying to import, the Bank Import Wizard will only import the transactions until the bank feed start date. This is because the system assumes that any transactions from the bank feed start date onwards will be fetched automatically by the bank feed. As a result, you may find that not all transactions in your file have been imported.
   
   Example: The period of the bank transactions you're importing is from 2/9/2024 to 2/12/2024, however, when you connected the bank to online banking, the bank feed start date was set to 2/10/2024. Bank Import Wizard will only import bank transactions starting from 2/9/2024 until 2/10/2024.
   
   

Where to find the Bank Feed Start Date? It's in the Import Settings TAB when you open the bank account details in the Chart of Accounts.

1. Go to Chart of Accounts.
   
2. Open the bank account.
   
3. Go to Import Settings Tab.
   
4. Bank Feed Start Date.
   
   
   

Steps to Import Bank Transactions to an Online Bank Account

1. Check the Bank Feed Start Date. Go to Chart of Accounts > open the bank account details > go to Import Settings Tab > Bank Feed Start Date. Make sure that period of the bank transactions that being imported doesn't overlap the bank feed start date.
   
2. Open Cloud Banking. From the CustomBooks™ application Home Page, click the Cloud Banking icon within Accounting & Banking, or go to Bank > Cloud Banking.
   
3. In Cloud Banking, select the bank account in the Account dropdown field.
4. Click the Upload/Import from a File button (CSV icon) on the yellow command bar. It might be in the More Actions dropdown depending on your resolution or screen size.
   
5. Download the file. Login to the bank website and then download the bank transactions. The Bank Import Wizard supports *.csv, *.qbo, *.iif, *.qif, *.ofx, and *.txt formats. When the file is downloaded and ready to import, click the Open Import Wizard button.
   
6. File Mapping. On the Import Wizard: File Mapping window, choose the file from your computer disk. Enter the column # that correspond to the CustomBooks™ Fields or select it from the CustomBooks™ Field column. Once the file mapping is done, click the Continue button.
   
   CustomBooks™ Fields: Date, Description, Money in (deposit), Money out (payment), Money in and Money out (if the deposit and payment amount is in the same column), Check Number, Memo, Currency.
   
   
   
   
7. File Reading and Consistency Check. The Bank Import Wizard will show a preview of the bank transactions, it also shows if there are errors or incorrect mapping. Using the Back button, you can review and correct the mapping. Click Continue button to proceed.
   
   
   
   
8. Specifying the Date Range. Choose whether you would like to upload all the transactions or specify the date range. Then click the Continue button to finalize and complete the bank transactions import.