You are here: netFORUM Pro Modules > Accounting > Lockbox Usage > Importing Data into a Lockbox Using the Data Import Wizard

Importing Data into a Lockbox Using the Data Import Wizard

The netFORUM Pro Pro Data Import Wizard also allows you to import lockbox files you receive from your bank. This feature allows you to process large numbers of lockbox transactions at once without keying in the payment information.

Once you set up your lockbox template, you will not need to modify this template unless your organization changes banking institutions, or your bank changes the data it includes/excludes in your lockbox files.

To upload a lockbox template into netFORUM Pro Pro using the Data Import Wizard:

  1. Locate the lockbox file (on your hard drive) you wish to import. Remember it must be an Excel file.
  2. Give the file a unique name that you will be able to recognize from a list. The name of the file is how this lockbox template will be known in netFORUM Pro Pro. This name will appear in lists and in any applicable drop-down menus within the application.
  3. Click the Administration hyperlink on the Module Menu to launch the Administration module.

  1. Hover over the Overview option to expand the Overview options on the right side of the Administration fly-out menu.
  2. Click the Data Import link. This will launch the Data Import Wizard.
  3. Click the Browse button to locate the lockbox file you wish to import.
  4. After locating and selecting the correct lockbox file, click the Save button.

The Quick Preview of Uploaded Worksheets section of the Data Import Wizard will update to show a snapshot of the data that was just uploaded.

  1. Expand the Excel Worksheet drop-down menu next to the Import Lockbox line item in the Import Table Name column of the Data Import Wizard.

  1. Select the name of the lockbox worksheet from this drop-down menu.
It is important that you make this selection next to the Import Lockbox line item. The Import Lockbox line item will dictate what import table column values you have available to you when you map the data columns from your lockbox file in the next step.
  1. Set the Header Row and First Data Row numbers to correspond with the worksheet you just uploaded (i.e. setting the Header Row at number 1 will pull in the first row of the worksheet as a header row for your import.)
  2. Click the Next button. You will be taken to the page where you will map the Excel Column to the Import Table Column in netFORUM Pro Pro.
  3. Map the Excel Columns from your lockbox worksheet to their corresponding netFORUM Pro Pro Import Table Column values.

If you do not see the Import Table Columns that you need for your Excel Columns in the Import Table Column drop-down menu, you will need to make a New Feature Request (NFR) to Abila to have those columns added. In the meantime, you will need to pick an Import Table Column value that closely matches what you need for that Excel Column.
  1. After you have completed mapping the columns, click the Next button. You will receive a message informing you that everything is prepared for the final import of data.
  2. Click the Finish button.
  3. Click the OK button on the confirmation pop-up window that appears after clicking the Finish button. Your import will begin and you will receive a status update as to its success. If there are any failures, you may need to examine the lockbox file to correct any errors.

Viewing the Lockbox Information After Data Import

To view lockbox information after the import:

  1. Click the Go to Lockbox hyperlink
  2. Visit the Lockbox group item in the Accounting module.

To view lockbox information in the Accounting module:

  1. Click the Accounting hyperlink on the Module Menu to launch the Accounting module.
  2. Click the Lockbox group item to view the available actions.

  1. Locate the lockbox you just uploaded. You can either use the Find functionality to locate your lockbox, or click List to see all of the lockboxes currently created for this entity and then select yours from that list.

  1. Click the name of the lockbox to view its Lockbox Information page.
  2. Click the Edit button to view the Process Bank Lockbox Report for your newly uploaded lockbox.

  1. From the Process Bank Lockbox Report, you can perform all of the tasks normally associated with lockboxes (and outlined in the Using the Manual Lockbox Function topic available in netFORUM Pro Online Help.)