Generate the Work File

After you enter data on the Form 1099 Processing form and define the state IDs, you generate a work file. The work file contains all the 1099 data currently in your vendor records.

You generate the work file before you use the Form 1099 Editor to change data in the work file. The edits that you make to the work file will affect 1099 processing only (that is, no changes to the permanent AP database will be made).

Prerequisite: You must do the following prior to generating the work file:

  • Select the appropriate year for processing.
  • Review the minimum RECIPIENT payments setting to ensure that only the applicable vendors will be included for the 1099 year being processed.
  • Upon completion of a 1099 year, run the 1099 Initialization utility.
  • Set up state (tax) IDs in order to have them automatically associated with recipient states.

To create the work file:

  1. In the Navigation pane, select Accounting > Form 1099 Processing.
  2. On the Actions bar, select Generate Work File.

    The work file is generated for both the 1099-MISC and 1099-NEC forms. There is no option to generate amounts separately for the two forms.

    When you regenerate the work file, any edits made prior to regenerating will be overwritten.

After you generate the work file you can edit it, verify payments, preview 1099s, and transfer 1099 data to a disk file for electronic reporting.