Import a DIF file into allocation and apportionment

Import and export Allocation & Apportionment (A&A) data for Forms 1065 and 1120 using DIF templates and spreadsheet files in A&A Data Entry.
For 1065 and 1120, use the provided templates for importing and exporting data with A&A Data Entry. To transfer A&A factor details, tabulate them in the spreadsheet, save it as a DIF file, and import it into A&A Data Entry. You can also export details from Data Entry to a DIF spreadsheet file.
note
Download all the current DIF templates from the landing page of your product and select
Data imports and exports
.
Before importing, save the Microsoft Excel file as a DIF file by selecting
File
, then
Save As
, then
DIF
(Data Interchange Format) in your spreadsheet application.
Don’t insert rows or columns in the spreadsheet, as the KAT template needs to remain unchanged.
Detach and save the templates:
  1. Right-click the ZIP file, and select
    Save Target As
    .
  2. Detach into a designated folder on your hard drive.
  3. Expand the ZIP file into its 2 components.
    • For 1065:
      1065_AA.DIF
      and
      1065_AA.KAT
    • For 1120:
      1120_AA.DIF
      and
      1120_AA.KAT
  4. Import the data into the tax application
    : Use the
    Import DIF
    window to import the data in the source file into the tax application.
    note
    Make sure the DIF/KAT file selected is the correct return type for your import.
  5. Standardize your spreadsheet format (layout) so that it can be used for other clients.
  6. Save a version of the spreadsheet as a DIF file.
  7. On the top menu, select
    Tools
    , then
    Import
    .
  8. In the
    DIF Import File
    section, select
    Browse for File
    to locate the source DIF file.
  9. In the
    DIF Template File
    section, select
    Browse for File
    to locate the KAT file. All DIF template files need to have a
    *.KAT
    extension.
  10. Select
    Import
    .

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close