Integration with Lacerte Tax

Alerts and notices

If you are licensed for Lacerte Tax, you can import AdvanceFlow trial balance data to Lacerte Tax.

Before using Lacerte Tax integration features, ensure that the following tasks have been completed in AdvanceFlow.

  1. Lacerte Tax is selected as a vendor in the Firm Settings tab of the Administration area.  
  2. Lacerte Tax is selected in the Vendor drop-down list of the Engagement Properties dialog for any engagements with the trial balance data that you want to import from within Lacerte Tax. See Editing engagement properties for information on how to view or change this setting.

    Note: All entity types that Lacerte Tax supports for import from AdvanceFlow are listed in the Entity drop-down list of the Engagement Properties dialog.

  3. Verify in the AdvanceFlow Trial Balance tab that the Lacerte tax codes are assigned to the appropriate accounts in AdvanceFlow. If necessary, Add the Tax Code column to the view to see this information. See Customizing the trial balance view for information on how to add or remove columns in your trial balance views. Refer to Assigning tax codes from within a trial balance for information on how to assign the Lacerte tax codes to your accounts in the Trial Balance tab
  4. Create the tax export file. See Exporting trial balance data for more information.


    • The resulting export file will be named using the AdvanceFlow client number with the extension formatted as XBY (where X = the Lacerte entity type code and Y = the last digit of the tax year).
    • The allowed entity type codes are as follows:
      • P = Partnership (1065)
      • C = Corporation (1120)
      • S = S Corporation (1120-S)
      • R = Non-profit (990 or 990-PF)
      • I = Individual (1040)
    • Example: if the client number in AdvanceFlow is 123ABC, the entity type is a partnership, and the tax year is 2015, the resulting export file would be named 123ABC.PB5
  5. Navigate to the export file (you specify this location in the save options during the export process), and copy it to the correct location for import to Lacerte. The import location will be a folder in the Lacerte program folder, [X]:\Lacerte\[YY]tax (where X represents the drive on which Lacerte was installed, and YY represents the last two digits of the tax year). The import folder varies based on the entity type as follows:
    • Partnership: [X]:\Lacerte\[YY]tax\PDATA
    • Corporation: [X]:\Lacerte\[YY]tax\CDATA
    • S Corporation: [X]:\Lacerte\[YY]tax\SDATA
    • Non-profit: [X]:\Lacerte\[YY]tax\RDATA
    • Individual: [X]:\Lacerte\[YY]tax\IDATA
  6. Verify that the export file name matches the ID for the corresponding client in Lacerte Tax. Update the file name as needed.


    • The export file name cannot be more than eight characters.
    • If the export file name does not match an existing Lacerte client ID, Lacerte creates a new client that matches the export file name during the import process.

The import process is automatically initiated when you start the Lacerte Tax application. You can also initiate the import process by choosing Client > Tax Type in Lacerte Tax, and selecting the appropriate entity type.


  • Data export for Lacerte Tax is available only for engagements with a year-end date of 12/31/2012 or later.
  • For additional information on importing trial balance information from within Lacerte Tax, refer to your Lacerte Tax documentation.

Was this article helpful?

Thank you for the feedback!