ProConnect HelpIntuit HelpIntuit

How to import QuickBooks Online trial balance data into Lacerte

by Intuit Updated 1 month ago

Step 1: Open Prep for taxes

Each client has their own dedicated Prep for taxes page. There are two ways to get to Prep for taxes:

  • If you’re working in a client’s QuickBooks Online account:
    1. Select the Accountant Tools dropdown.
    2. Select Prep for taxes.
  • If you're in QuickBooks Online Accountant:
    1. Go to the Clients tab.
    2. Find your client and select Prep for taxes from the Actions column.

Step 2: Review your client’s accounts (Optional)

Start your work in the Review & adjust tab. Your client’s annual Balance Sheet and Profit and Loss Reports are side-by-side so you can make quick comparisons. You’ll also see last year’s totals, account differences, and any adjusting entries you’ve made.

To dive into a specific account:

  1. Expand the list of accounts.
  2. Select the account total from the column for the current year.
  3. Review the transactions in the account.

Step 3: Make adjusting journal entries (Optional)

Prep for taxes makes it easy to record adjusting journal entries if needed. These lets you adjust transaction totals without changing the original record. To make an adjusting journal entry while you're on the Review & adjust tab:

  1. Expand the list of accounts.
  2. Find the account you want to adjust.
  3. From the Actions column, select Make adjustment.

 You can attach notes and documents to keep track of work on individual accounts as needed:

  1. From the Actions column, select the small arrow ▼ icon.
  2. Select Add attachment or Add note.

 Icons appear next to each account for easy reference.

 Change the accounting method view

You can toggle between accounting method views to make your review easier. This won’t affect your client’s settings or view in QuickBooks Online.

  1. Select the pencil icon at the top.
  2. Toggle between Cash basis and Accrual basis.

Review the Change List

The Change List in the Review & adjust tab acts as an audit log. Every time someone makes a change in Prep for taxes, it appears on this list.

To approve these changes so QuickBooks applies them, select Accept changes.

The Change List in the Review & adjust tab acts as an audit log. Every time someone makes a change in Workpapers, it appears on this list.

To approve these changes so QuickBooks applies them, select Accept changes.

The Change List in the Review & adjust tab acts as an audit log. Every time someone makes a change in Workpapers, it appears on this list.
L4EUJdqX3_UK_Changelist1.png

To approve these changes so QuickBooks applies them, select Accept changes.

Step 4: Map accounts to tax forms

After reviewing your client’s accounts, you’ll assign them to specific lines on tax forms. Prep for taxes automatically assigns most accounts to tax lines. Any unassigned accounts will appear in the “We found unmapped accounts” section.

  1. Go to the Tax Mapping tab.
  2. Select Intuit Lacerte Tax from the Select your professional software dropdown.
  3. If any lines are unmapped:
    • Select Assign tax line.

      Image Alt Text
    • Select the appropriate tax line to map to.

      Image Alt Text
    • Select Save

Step 5: Download the Comma Separated Value (CSV) file

The downloadable CSV file is formatted for Lacerte tax preparation software:

  1. Select Tax options
  2. Select Export CSV

    Image Alt Text
  3. If prompted for a location to save the file, save it somewhere easy to locate such as your Downloads folder or Desktop.

Step 6: Import the CSV file into Lacerte using the Trial Balance Utility

  1. Open Lacerte
  2. Highlight the desired client on the client list
  3. Select the Trial Balance tab
    • If the tab isn't visible, select the Tools menu Import/Export Data  Lacerte Trial Balance Utility.
  4. On the Welcome to Lacerte Trial Balance Utility window, select Import From Excel
  5. Select the Form to associate the trial balance with
  6. Select Browse, and browse to the CSV file you saved previously
  7. Select Next
  8. For each column to import, select the appropriate column heading. In general:
    • Column A (Tax Input Field) should be set to Do Not Import
    • Column B (Balance) should be set to Ending Balance
    • Column C (Account) should be set to Account Name
    • Column D (Type) should be set to Account Type
  9. Select Next
  10. If any accounts are missing a type, select the type from the drop-down list
    • Tip: If the accounts in the file are grouped by account type, you can select the account type for the first and last account in each group. This will fill in all blank rows with the same tpe.
  11. Select Finish to complete the import process.
  12. Review of the information in Trial Balance Utility
    • Use the Journal Entries tab to make necessary adjustments
    • Use the Tax Line Assignment tab to map the accounts to the desired input fields for Lacerte.
      • You can use SmartMap, or alternatively select the Screen, Schedule, and Lacerte Input Field from the dropdowns
  13. Select Post to Tax Return at the bottom of the window.
Lacerte Tax 2023Lacerte Tax 2024QuickBooks Online AdvancedQuickBooks Online Plus

Sign in now for personalized help

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

More like this

Dynamic AdsDynamic Ads