Importing Bank Open Items From a Template

The below process highlights how to import an CM bank open items from a template. The template used to import CM Bank Open Items is available on the Dashboard Parish Process Documentation. This process should be performed at the parish entity-level.

This is a multi-part process. Please follow all parts to fully complete the import process of CM Bank Open Items.

Steps

Part 1: Download the Bank Open Itemsimport template

Click the Applications drop-down menu
Click Dashboards
Click Parish Process Documentation

Figure 1 - Dashboard: Parish Process Documentation

Click CM Bank Open Items Import Template in the Parish Cash Management Documentation section

Figure 2 - Download Bank Open Items Template

Download and open the import template in Excel.
1. The import template will open in a new browser window.
2. Download the template to your local computer.
3. Open the Bank Open Items import template in Excel
Save Import Template
1. Within Excel, click File -> Save As and save the file to your local machine.
2. It is recommended that you append your parish name to the filename.
  1. Ex: Intacct Import Template – Bank Open Items– Demonstration Parish

Part 2: populate the Bank Open Items import template

Part 2 of the process populates the import template with the Bank Open Items information. These steps refer to the column headers for entering data into the import template Excel file that will be used to import the bank open items information into Intacct. Please refer to Figure 3 - Bank Open Items Import Template for these steps.

Do not change the column headings of the import template. The column headings refer to Intacct internal names required to properly map the Bank Open Items information.

Figure 3 - Bank Open Items Import Template

In the DATEcolumn, enter the date (mm/dd/yyyy) of the open item.
1. The date should be less than beginning balance cutoff date.
The outstanding check number should be entered in the DOC_NO column.
The TYPE column defines the type of open item.
1. This value should be checkdebit for all bank checking open items.
Enter the amount of the open item in the AMOUNT column.
Enter who the bank item is due to in the PAYEE column.
Additional (optional) information can be added in the DESCRIPTION column.
After entering the bank open items data on each row, save the Excel import template file as a .CSVfile
1. Within Excel, select File -> Save As
2. Set the file type as CSV UTF-8
3. Click the Save button

Part 3: Import the Bank Open Items into Intacct

Click the Application drop-down menu
Click Cash Management application
Click the All tab
Click the Bank option

Figure 4 - Bank Reconciliation Option

On the Reconcile Bank Account – Reconciliationform…
1. Select the bank account to impot the open items to.
2. Select the Initial open items.

Figure 5 - Reconciliation: Initial Open Items

Select the Import button from the Initial Open Items screen

Figure 6 - Initial Open Items - Import

From the Initial Open Items form, click the Choose File button.
Ensure your email is defined so that you will receive a summary of the import results.
Click Import button

Figure 7 - Initial Open Items Form

After clicking import, the system will attempt to import the file that you selected. After a few moments, you will receive a notification telling you how many bank open items were imported successfully and how many had errors. Additionally, you will receive an email with descriptions of the errors in the file. If errors occur, the .csv file that you attempted to import will need to be updated and re-imported.