Skip to content

Process 1099s

Use the 1099 Processing screen to prepare your 1099s, then export the records to a file and submit it through a 1099 filing service.

The process is:

  1. Prepare your 1099s on the 1099 Processing screen.
  2. Export the 1099 records to a spreadsheet.
  3. Upload the file to a filing service, which submits and prints the forms.
  • Each vendor’s 1099 setup and W-9 must be on the vendor record. Attach the W-9 to the vendor so it isn’t reported as missing. See Set up an AP vendor and Store vendor documents.
  • To export the files, you need report permission for Form 1099 MISC (Box 1 Rent) and Form 1099-NEC (Box 1 Non Employee Comp).
  1. Go to Accounting › Vendors › 1099 Processing.
  2. Select the Legal Entity and Tax Year, then select Continue.

1099 Processing with Legal Entity, Tax Year and Continue

From this screen you can see which vendors are missing W-9s or are set up incorrectly, make manual adjustments, and send W-9 request letters.

  1. On the Create Records tab, check Ignore Limit and Ignore 1099 Type, then select Create Records. This lists all vendors so you can fix any vendor record errors.

    Create Records with Ignore Limit and Ignore 1099 Type checked

  2. A message shows how many 1099 records were processed. Select OK.

    The message showing how many 1099 records were processed

  3. On the Review tab, vendors with a setup problem show Invalid 1099 Type in the Error column. Select a record to see a description of the errors in Errors at the bottom. Use this to check that each vendor has the right 1099 type.

    Invalid 1099 Type in the Error column, and the Errors box

  4. To fix a vendor, select the line and select Vendor to open the vendor record.

    A record selected and the Vendor button

  5. To see vendors without a W-9 attached, check Missing Images.

    The Missing Images filter checked

  1. When the vendors are cleaned up, uncheck Ignore Limit and Ignore 1099 Type, and select Create Records again.

    Create Records with Ignore Limit and Ignore 1099 Type unchecked

    The Review tab now lists only the vendors you’ll send 1099s to.

    The Review tab listing vendors to receive 1099s

  1. Select the record and select Manual Adjust.

    The Manual Adjust button

  2. To change an amount, enter the difference, not the new total. The amounts already shown are for reference only; whatever you enter is added to the original amount. For example, if Box 7 shows 280,504.59 and you want it to be 250,000.00, enter -30504.59.

    The manual adjustment box amounts

  3. To move an amount from one box to another, enter a negative amount in the box it’s moving from and a positive amount in the box it’s moving to. For example, to move 4,000.00 of Interest Income to Box 7, enter -4000 in Interest Income, clear Box 1, and enter 4000 in Box 7.

  4. Select Insert. The adjustment shows in the list above.

    Moving an amount to Box 7 and the Insert button

  5. Select Create Records again to include the adjustment.

    The message to run Create Records again

To remove an adjustment, select it on the ManualAdjustments tab, select the delete button, and select Create Records again. Each vendor can have only one manual adjustment, so delete the old one before you add a new one.

The ManualAdjustments tab with the delete button

On the Output tab, select Export List to see the data in a spreadsheet.

The Output tab with Export List

Export the 1099 files for the filing service

Section titled “Export the 1099 files for the filing service”

When the 1099s are final, produce the files to send to your 1099 service. The files have the fields a service needs to submit 1099-NEC and 1099-MISC forms. They’re formatted for eSmart Payroll (esmartpayroll.com) but should work with the service of your choice.

Report permissions for the two 1099 reports

  1. On the Reporting tab, select Reports.

  2. Run Form 1099 MISC (Box 1 Rent) and Form 1099-NEC (Box 1 Non Employee Comp). Select the Tax Year and, if you have more than one legal entity, the Legal Entity.

    The Form 1099 MISC (Box 1 Rent) report with Legal Entity and Tax Year

  3. A Save As dialog opens. It might be behind another window. Save the file; this is the file you submit. It’s saved in XLS format.

    The Save As dialog for the 1099 file

  4. A temporary report also opens, showing what was saved in the file. You can close it without saving.

  1. Go to esmartpayroll.com and create an account or sign in.

  2. Select the Company & Employees tab and follow the steps to add your company.

  3. Under I want to file a Federal Form, select 1099-NEC or 1099-MISC.

  4. Under I want to batch file 1099-NEC, select Start E-File.

    I want to batch file 1099-NEC and Start E-File

  5. Choose the file options and browse to the file you saved from Nexsyis.

    The Upload Data File options

  6. Review the file contents and select Next.

  7. Check the column mapping. The fields should map automatically. Select Next.

    The Map Upload Information screen

  8. Complete the checkout.

    The Shopping Cart Information screen

Prepare for next year: W-9 request letters

Section titled “Prepare for next year: W-9 request letters”

To request W-9s from vendors that are missing one, select W9 Request Letter on the Review tab. Nexsyis fills in each vendor’s name and address on the letter.

The W9 Request Letter button