Intuit HelpIntuit
Using the Lacerte Trial Balance Utility to import Excel data
by Intuit• Updated 1 month ago
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:
- On the Tools menu, click Import/Export Data, then select Lacerte Trial Balance Utility.
- From the Trial Balance Utility (TBU) File menu, click New Company.
- Enter the Fiscal Year End, if not calendar, and select the Type of return (Company Name will auto-populate with the Lacerte Client Number).
- Click OK.
- From the Trial Balance Utility's File menu, click Import, and then select From Excel.
- 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.
- In the Find the File to Import field, type the location of the file you want to import.
- Click Browse to select the location.
- Click Next to continue.
- Verify the worksheet from the imported Excel file using the Worksheet list. If you are importing a *.csv file, this defaults to Sheet 1.
- 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".
- Click Next to continue.
- 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.
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
- After reviewing all information, click Finish to complete the Import process.
Sign in now for personalized help
Ask questions, get answers, and join our large community of Intuit Accountants users.
More like this
- Importing from Lacerte to Tax Plannerby Intuit•3• Updated January 02, 2024
- Entering amounts from Form 3921 in the individual module of Lacerteby Intuit•324• Updated 2 years ago
- Suppressing the 1065 balance sheet in Lacerteby Intuit•142• Updated 2 years ago
- Using the Schedule D Import Wizard in Lacerteby Intuit•33• Updated August 19, 2024
- How to generate the MFJ vs MFS comparison worksheet in Lacerteby Intuit•223• Updated over 1 year ago