Using the Lacerte Trial Balance Utility to import Excel data

When working on a trial balance in Lacerte, you may find a need to import an Excel spreadsheet to simplify the process and reduce redundant data entry. Down below we'll go over how to do so.

To import a trail balance stored on an excel spreadsheet into the Lacerte Trial Balance Utility:

1. On the Tools menu, click Import/Export Data, then select Lacerte Trial Balance Utility.
2. From the Trial Balance Utility (TBU) File menu, click New Company.
3. Enter the Fiscal Year End, if not calendar, and select the Type of return (Company Name will auto-populate with the Lacerte Client Number).
4. Click OK.
5. From the Trial Balance Utility's File menu, click Import, and then select From Excel.
6. Select the type of return you are filing for this client. This information is used when the SmartMap database assigns Lacerte input fields to your trial balance accounts.
7. In the Find the File to Import field, type the location of the file you want to import.
8. Click Browse to select the location.
9. Click Next to continue.
10. Verify the worksheet from the imported Excel file using the Worksheet list. If you are importing a *.csv file, this defaults to Sheet 1.
11. For each column to import, select the appropriate column heading. Select Do Not Import for each column that should not be imported. The only column that is required to import on this page of the wizard is "Account Name".
12. Click Next to continue.
13. In the Type column, select the account type associated with the account. Type the first letter of the account type (A, L, R or E) or select the account type from the drop-down list.

14. After reviewing all information, click Finish to complete the Import process.