How_do_I_export_variables_

How do I export variables?

Create an export file to send data for processing to a third party or vendor. The export file will only include the information that you have selected. You can choose which variables to include and you can rename the variable description to match the description the vendor will use to map it. This is for users who need to create a custom export file instead of including all of the variables that are defined in a report in the export file. 

 

Importing variables from a form 

Instead of starting with a blank list, you can import the variables from a report and then edit the variable list so it only includes the data requested by the third party or vendor.  

Warning! Importing report columns will replace the report columns in the list with the new report columns. 

 

To import variables from a form, click Import Variables from a Form .    

Import Variables from a Form button

 

Use the Import Form Export Variables window to select a form and then choose the default format for formatting amounts, dates, numbers, and yes/no values. If you're not sure which format to use, choose the default. You can change it later. Click OK to continue. 

Import Form Export Variables window

 

The report columns from the form display here. 

Report columns list

 

Selecting variables

To add a variable, click Select Variables 

 

Changing the export order

To change the order of the variable list, click on a variable and then click  or 

 

Renaming a variable

To change a variable description, click to select a variable from the variable list and then use the Description box to enter the description that you want to use in the export file. 

Description box

 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • How do I export a report as a delimited file?

      Use this option to create a file that can be used to send transmittal information to a third party program. Several options are available so you can set up the export options to create a file that will be easy to import. Exporting a report as ...
    • 1094/1095 Report Variables

      Use the ACA variables to filter, sort, and organize ACA information. [Report].Social Security number ACA Employee.Address 1 ACA Employee.Address 2 ACA Employee.City ACA Employee.Country ACA Employee.Delivery point ACA Employee.DOB ACA Employee.Email ...
    • 1094/1095 Report Variables

      Use the ACA variables to filter, sort, and organize ACA information. [Report].Social Security number ACA Employee.Address 1 ACA Employee.Address 2 ACA Employee.City ACA Employee.Country ACA Employee.Delivery point ACA Employee.DOB ACA Employee.Email ...
    • Rate calculation variables list

      Use the calculation variables to calculate rates. CostAdjustmentFactor Description: Cost adjustment factor from the Service table. Demand Description: Demand usage. IIf Description: Conditional test function. IIf(Condition, ValueIfTrue, ValueIfFalse) ...
    • 1094/1095 Form Variables

      Use the form variables to create a form layout for printing Form 1094 and 1095. Alignment Returns printer marks. 1099 Dividend Limit Returns 1099 dividend limit. 1099 Government Payments Limit Returns 1099 government payments limit. 1099 Interest ...