Importing Custom G/L Direct Data

The import feature imports trial balance data into a tax return that has been activated for G/L Direct processing and stores the data in the Chart of Accounts worksheet grid. The applicable tax products are Corporation, S Corporation, Partnership, and Exempt Organization.

You can create custom import templates that designate column data types, such as account number, account description, and tax code. In addition, the custom import feature allows you to create template specifications for account numbers.

To import custom G/L Direct data, do the following:

1. Open a return that has been activated for G/L Direct Processing.

Note: See Setting up G/L Direct for information about activating returns for G/L Direct processing.

2. Select TB Import > Select a Custom Import from the Import group on the G/L Direct tab.
3. Enter the file path or browse to and select a name for the import file.
4. Select an import template from the Select custom import list.

Note: See Configuring Custom G/L Direct Imports for information about configuring import settings.

5. Select your import options. Explain the import options.

   The following options can be included in or excluded from your import. Check those you want included. Remove any check marks from items you do not want included in your import. The Accounts with zero balances option is always available. The availability of other options is determined by the import template you selected.

   Option	Description
   Account descriptions	Import account descriptions to the chart of accounts.
   Prior year balances	Import prior year balances to the chart of accounts.
   Accounts with zero balances	Import accounts that have a zero current year balance. If the box is unchecked, then only accounts with nonzero balances will be imported to the chart of accounts.
   Tax codes	Import tax codes to the chart of accounts.
   Entity/property numbers	Import entity/property numbers to the chart of accounts.
   Account types	Import account types to the chart of accounts.

6. Click Import to process the selected file and display the G/L Direct - Confirm Import Update window.
7. Do one of the following:
   • Click Yes to update the return with the imported data.
   • Click No to abandon the import process.
   • Click View Exceptions to review any exceptions that may have occurred during processing. The G/L Direct - Import Processing Exceptions window is displayed. See Using the G/L Direct Import Processing Exceptions Log for more information.