Export instance tax data—Consoles

From the Instance data tax export page, you can do the following:

  • Select the supplier of the tax software package that you want to use.

    The tax software package determines the format of your data export.

  • Select the year of the data that you want to export.

    Use the Start date and End date fields to define a short year. This is useful for new spin-off companies or for companies that cease to exist due to a merger or acquisition.

  • Export the instance's tax data to a file that you can save and share.

Subscription

Tax export
Regional availability

All regions

User type

Business
Permissions

Export instance tax data: Run

  1. On the application menu, select Tax export.

  2. Find the company with data that you want to export and choose Select.

  3. Review the information that populates on this page, then make any changes.

    Populates the ID of the company that you selected on the Instance data tax export list.  

    You cannot change this field.

    This field displays if you’re filing tax data for an entity.

    Select an entity.

    Select the supplier of the tax software package that you use:

    1. CCH ProSystem fx
    2. Lacerte Tax
    3. Thomson Reuters GoSystem Tax
    4. Other System (for all others, and for non-U.S. tax returns)
    If you prepare a non-U.S. tax return, you must export your instance's tax data to Other System.  CCH, Lacerte, and Thomson Reuters support U.S. tax returns only.
    1. Account number
    2. Account name or description

    3. Prior year-end balance

      If you export income statement accounts, there is no prior year-end balance.
    4. Current year-end balance
    5. Tax code
      Confirm that all accounts have tax codes when you import this data. When accounts have tax codes, accounts map to tax forms, such as Forms 1120 and 1065.
    1. Account number
    2. Account name
    3. Account description
    4. Type
    5. Current year-end balance

    There are 4 types in the Lacerte Tax system. Each type applies differently:

    Account Type:

    Normal Balance:

    Type:

    Balance Sheet Account

    Debit

    Asset

    Balance Sheet Account

    Credit

    Liability

    Income Statement Account

    Credit

    Revenue

    Income Statement Account

    Debit

    Expense

    1. Tax return code
      Confirm that all accounts have tax codes when you import this data. When accounts have tax codes, accounts map to tax forms, such as Forms 1120 and 1065.
    2. Account number
    3. Account name
    4. Prior year-end balance
    5. Current year-end balance
    6. M-3 return code
    Confirm that you enter tax return codes for all accounts to ensure that the full balance records on the Thomson Reuters GoSystem tax forms.
    1. Account number
    2. Account name
    3. Current year-end balance
    4. Tax return code (Optionally, displays data when enabled)
    5. M-3 return code (Optionally, displays data when enabled)

    Select this checkbox to include all accounts and accounts with a zero balance in the tax data export.

    Clear this checkbox to include only accounts with a balance in the tax data export.

    The date in this dropdown is based on the tax year. When the instance was created in the console, the tax year was selected.

    Displays the start and end dates of the tax year that you selected in the Year ending field.

    If you file a return for a short tax year due to a spin-off, merger, acquisition, bankruptcy, or other defining event, change the start and end dates.

    When you change the default Start date and End date, the year-end date does not change.

    Enter your email address if you want to be emailed when this export completes.

    You can enter a different email address for someone else to be notified instead.

    Populates the export file name.

     If you change the export file name, do not change the file extension (.csv).  Your export fails if you change the file extension.

    Optionally, use to assist with your record-keeping.

  4. Select Export.

    Intacct creates a discrete spreadsheet document and prompts you to save the document to a local drive.  

If there's an error with the export, or if you want to stop the export process, select Cancel.