ProConnect HelpIntuit HelpIntuit

Using the Lacerte Trial Balance Utility to import Excel data

SOLVEDby IntuitLacerte Tax6Updated July 13, 2022

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.PCG_LAC_ L19njx4ka-001.png

If the accounts in the file are grouped by account type, you can expedite the data entry by selecting the account type for the first account in each group. When you do this, all blank rows

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

Was this helpful?

You must sign in to vote, reply, or post
Lacerte Tax

Sign in for the best experience

Ask questions, get answers, and join our large community of Intuit Accountants users.

More like this