Skip to main content

Steps for Processing 1099 Data

Written by Denisa Arjoca
Updated over a month ago

A 1099 Processing Menu can be found in the Central Repository module under the Administration menu.

The annual Processing steps involved for processing 1099 data are designed so that you can follow the six Processing menu options in order from beginning to end. Steps can be run as many times as needed.

1099 Processing Menu

The six menu options are listed below and are discussed in more detail in this section.

  • Edit 1099 Payer Information.

  • Generate 1099 Payee Data.

  • Edit 1099 Payee Information.

  • 1099 Final Error Check.

  • Print 1099 Forms.

  • Create 1099 Magnetic Media File.

Edit 1099 Payer Information

A 1099 Payer is the Company issuing the 1099 forms to the suppliers and subcontractors. The typical Coins ERP+ user only sets up one 1099 payer for each year, but Coins ERP+ can handle processing for multiple 1099 payers in the same year.

Use the Edit 1099 Payer Information function to add a Payer for the current 1099 year.

Edit 1099 Payer Information

1099 Year

Enter the current 1099 year. For example, 2025.

Payer Name

Enter the company/payer name as it should appear on the 1099. You must enter the payer name exactly as it should appear on the printed 1099 form since it cannot be changed once entered. This is because the 1099 data generated for this payer is tagged internally with this name. Changing this name would therefore break the link and stop processing.

Payer TIN Number

Enter the company/payer’s Federal Tax Identification Number.

Address

Enter the payer mailing address (Address, City, State, Zip Code), Contact Name, Phone number, and Email Address.

Companies to Process

Enter a comma-separated list of companies to include for processing in this 1099 group. This controls combining transactions from multiple Coins ERP+ companies for 1099 reporting.

When left blank, all data from all companies in Coins ERP+ (rather than just the company you are in) are reported under this payer.

To only report one or more specific lists of Coins ERP+ companies, enter a comma-separated list of company numbers with no spaces.

Produce 1099's for Amounts Over

The dollar amount cutoff for issuing a 1099 form to a payee.

Foreign Payer

Whether this is a foreign payer. When checked, this field indicates that it is a non-US business.

Payer's State Number

The payer's state number.

Wisconsin 1099 reporters: This field supports up to 17 digits in compliance with the State of Wisconsin requirements.

Last Year Filing 1099's

Whether this is the last year a 1099 will be issued from this payer.

Payer Name Control Code

The payer's name control code.

Are You Filing on Magnetic Tape

Whether you will be sending 1099 data to the government via magnetic media.

Transmitter Control Code

The transmitter control code.

Transmitter Media Number

The transmitter media number.

Generate 1099 Payee Data

The Generate 1099 Payee Data function allows you to create the 1099 data known as payee information.

Generate 1099 Payee Data

1099 Year

Enter the 1099 year to report on.

Payer Name

Use the lookup to select the payer name to process 1099s for.

The following processing takes place when this function is run:

  1. The payments to suppliers and subcontractors are totaled so that there is a value paid to each for the payment year based on the check date of each payment. A 1099 Payee Information record is created for each company/office with payments greater than the value entered for the Produce 1099s for Amounts Over in the Edit 1099 Payer Information function.

  2. The following data default from the Companies Workbench > 1099 Info tab into the newly created 1099 Payee Information record:

    • TIN Type.

    • TIN Number.

    • Bank Account Number.

    • Alternative 1099 Name.

    • Foreign Payee.

  3. Error checks are performed as this data is created. Error messages are noted on each payee record.

  4. A report of the data created is produced along with any error information for each payee record.

The generation of the 1099 data is processed by using the Report Generator. This processing can take some time depending on the volume of transactions in Coins. It is always recommended to run this type of processing in the background. A simple report is produced as a summary of the processing. Checking the status of this report alerts you that the 1099 data have been created successfully, created with errors, or are still being generated in background mode.

A sample report from the Generate 1099 Payee Data function is shown below.

Generate 1099 Payee Data Report

Edit 1099 Payee Information

This Edit 1099 Payee Information function allows you to view and edit the 1099 Payee data that was created with the Generate 1099 Payee Data function. Records that will print on the 1099_NEC are identified with a check in the Non-Employee Compensation column. Any unchecked records will print on the 1099_MISC.

Edit 1099 Payee Information

Some things to note about this function:

  • A payee record can be added or changed in this function.

  • The Generate function can be run as many times as needed, but if a payee record was generated, then changed with this function, the changes are lost when the data is regenerated.

  • If a new payee record is added with this function, and then the Generate function is run again, the new payee record remains unchanged by the Generate function.

For a 1099-NEC record, the Non-Employee Compensation (1099-NEC) box will be checked and only applicable fields in the Amounts section of the page will be available to be edited.

Edit 1099 Payee Information 1099-NEC Record

For a 1099-MISC record, the Non-Employee Compensation (1099-NEC) box will not be checked and only applicable fields in the Amounts section of the page will be available to be edited.

Edit 1099 Payee Information 1099 - MISC Record

1099 Final Error Check

When the payee data has been reviewed and all errors have been fixed, the 1099 Final Error Check function should be run to verify that all errors have been resolved. The selection screen for this function works in the same manner as the Generate selection screen.

1099 Final Error Check

Below is a sample of the 1099 Final Error Check report.

1099 Final Error Check Report

Print 1099 Forms

When printing 1099 forms, you should be on the most recent version of Adobe Reader. You must also make sure you select to print the 1099 forms with no scaling, i.e., actual size rather than “print to fit” and Portrait orientation rather than Auto or Landscape.

The Print 1099 Forms function allows 1099 data to be printed to special pre-printed 1099 forms. If any 1099 records have an error, the number of error records is displayed with a message; no 1099s are printed until the errors are resolved.

The Coins ERP+ W-2 and 1099 print programs are based on the forms provided by National Document Solutions (NDS). To order forms, call NDS Customer Service at 844-562-4900 or order online from www.coinsallsource.com.

Print 1099-NEC Forms

The 1099-NEC print batch must be generated separately from the 1099-MISC print batch.

Print 1099 - NEC Forms

Form

Select the 1099 Form - NEC.

1099 Year

Payer Name

These fields are used in the same way as the Generate and Error Check selection screens; in other words, you can select a payer for which to print 1099 data.

1099 Form Type

Match the Form Type to the Form selected at the top of the page. This will determine which records are included in the Print batch.

From / To Payee Number

These fields allow you to print one form, or a small subset of forms, from the entire group. This can be useful if part of a group of forms is destroyed due to a paper jam or other printing problem.

Print 1099-MISC Forms

The 1099-MISC print batch must be generated separately from the 1099-NEC print batch.

Print 1099 - MISC Forms

Form

The Federal and Payee versions of the 1099-MISC have been redesigned to print on either paper form.

1099 Year

Payer Name

These fields are used in the same way as the Generate and Error Check selection screens; in other words, you can select a payer for which to print 1099 data.

1099 Form Type

Match the Form Type to the Form selected at the top of the page. This will determine which records are included in the Print batch.

From / To Payee Number

These fields allow you to print one form, or a small subset of forms, from the entire group. This can be useful if part of a group of forms is destroyed due to a paper jam or other printing problem.

Create 1099 Magnetic Media File

Use the Create 1099 Magnetic Media File function to create a magnetic file for the 1099s. In Coins ERP+ v12.05 and later versions, a new field has been added for Filing Type selection. This field allows the ability to choose filing type of FIRE or IRIS.

Create 1099 Magnetic Media File

Magnetic Media File Name

The government requires the file submitted to be named “IRSTAX”, but you can change the name if you wish to do a test run. Just make sure that the final creation of the file is named “IRSTAX”. Do not create the file under a different name and rename the file using an operating system command. This is because the file name is also stored in the ASCII file. Renaming the file at the operating system level does not change the name saved within the ASCII file.

Save File in Directory

The ASCII file is located on the Coins ERP+ server at the Save File in Directory. It is best to use the directory name that defaults, but this can be changed.

If the Report Generator does not have permissions to access the directory, no file is created.

Did this answer your question?