OnBalance Import - Manage Data dialog

Alerts and notices

Use the OnBalance Import - Manage Data dialog to map the client's OnBalance Express data to Accounting CS data.

In the the OnBalance Import dialog, click the Manage Data button.

Tabbed pages in this dialog

The grid in this tabbed page lists all transactions that were retrieved from OnBalance Express for the selected client. Mark the checkbox for each transaction you want to include in the import. To select all transactions in the list, right-click and choose Select all.

The grid in this tabbed page lists all OnBalance Express accounts available for import that are associated with a bank account. If an OnBalance Express account number or name matches an existing Accounting CS account number or name, the application automatically maps those accounts together. However, you can map the OnBalance Express account to a different account if necessary.

Manually map all remaining OnBalance Express bank accounts that will be included in the import. Note that if you are importing any transactions that use an OnBalance Express bank account, you must either map that bank account to an existing Accounting CS bank account, or you must add the OnBalance Express account as is.

The grid in this tabbed page lists all expense categories that the selected client used in OnBalance Express. If an OnBalance Express category matches an existing Accounting CS account, the application automatically maps those items together. However, you can map the OnBalance Express category to a different account if necessary. Map all remaining OnBalance Express categories to an existing Accounting CS account, or add the OnBalance Express category as is.

Fields & buttons

Click this button to clear all mapping you've done in the active tab during this import session.

Mark this checkbox to display all items that are available for import in the active tab. Clear the checkbox to display only the items that require you to manually map them.

This field is available on the Bank Accounts and Chart of Accounts tabs.

Select the default Accounting CS mapping option for any items that have not been mapped. The application automatically selects that option in the Accounting CS mapping column.

  • Add as is. The application adds the OnBalance Express item to Accounting CS using the OnBalance Express name/description.
  • Do not import. (Chart of Accounts tab only) The application will not import the OnBalance Express item to Accounting CS.
  • Blank. The application leaves the mapping column blank, requiring you to manually map those items.

If Accounting CS detects any mapping errors in the active tab, it displays the total number of errors found. Click the navigation buttons to scroll through the errors (highlighted in red or identified by the error Import mapping error icon) and address them as appropriate.

Click this button to print the list of mapped items in the active tab.

Click this button to save the mapping on each tabbed page. If you retrieved transactions from OnBalance Express and finished mapping all applicable data, the application begins the import process. You must specify an action (map to Accounting CS account, add as is, or do not import) for all items before the import can proceed. Accounting CS will flag any items that don't have a selected action, and then it will include them in the error count in the Error navigation section.

Click this button to close the OnBalance Import - Manage Data dialog without saving any mapping that you completed during this session or importing any data. If you saved any mapping at an earlier point, the application retains those mappings.

Related topics

Importing client data from OnBalance Express