Setting Up 1099s in Dynamics 365 Finance & Supply Chain Management

It’s almost that time of the year again, time for year end tax prep! We’ve put together a process to help you set-up 1099s in Dynamics 365 Finance and Supply Chain Management (formerly Dynamics 365 Finance and Operations), so they can be sent to vendors and to the Internal Revenue Service (IRS). As a reminder, the filing deadline is January 31, 2021 for vendors and for the IRS whether you file electronically or by paper.

Process Overview

1099 processing refers to reviewing and issuing IRS 1099 forms, both to the taxable recipient (vendor) and to the IRS. This blog explains the activities in Dynamics 365 Finance and Supply Chain Management related to 1099 processing.

Process Flow

AP-1099

User Roles

Dynamics 365 Standard Roles:

  • Accounts Payable Manager – for Vendor Maintenance & Setup
  • Accounting Manager (there are many roles but this one should cross over all forms shown here)

Vendor Setup

Setup for a 1099 vendor:

  • Expand the Tax 1099 fast tab
  • Select the Report 1099

Not applicable to 1099:
Select the W-9 received box if the W-9 form has been received from the vendor

Not applicable to 1099:
Select the Check for W-9 box to verify that the vendor has submitted a W-9 form. If the vendor has not submitted a W-9 form, a warning message will appear when you create or update a vendor invoice

  • Enter the Federal tax ID
  • Choose from the list of available Tax ID types
  • Choose from the list of available 1099 boxes
AP-1099
  • If the organization is owned outside of the USA, select the Foreign entity indicator
  • Select the Second TIN checkbox if you were notified by the IRS twice within 3 calendar years that the payee provided an incorrect taxpayer identification number (TIN)
  • Select from the list of available choices in the Name to use on the 1099
  • Enter the DBA if applicable
  • Enter the alphanumeric name control ID that the IRS requires to be printed on the mailing label to help validate the vendors EIN in the Name control
AP-1099

To set up state 1099 information: in the Action Pane within the Vendor tab, select Vendor state tax IDs.

AP-1099

From here, enter the information in this form:

AP-1099

The above setup makes all transactions for the vendor default to 100% reportable for 1099.

If we are just tagging the vendor for 1099 activity when we have already processed payments to this vendor (when 1099 reportable transaction have already occurred), Dynamics 365 has provided a function to go back and mark these transactions as 1099 reportable:

AP-1099
  • The ‘Update 1099’ button updates all records. This function is very useful for tagging transactions for a vendor where we missed initially setting 1099 on. Note: if we have already tagged records as only partially 1099 reportable on this vendor, this will retag all records as 100% reportable, so use this function with care.
  • The ‘Vendor settlement for 1099’s’ shows what records Dynamics 365 has marked as reportable for this vendor. This is the same form accessed from the ‘Vendor settlement for 1099s’ all vendors view, explained further below.

Mark Invoice Only Partially Liable for 1099 Reporting

After vendors are set up with 1099 information, all invoices naturally default to 100% of invoice amount as being 1099 reportable. If we want to only partially tag an invoice amount as 1099, follow the procedure below:

Enter the invoice as usual (the amount is #1), then click the ‘1099’ tab.

AP-1099

Fill in the amount subject to 1099 (note the negative sign for regular invoices).

AP-1099

After the invoice is paid, we can see that the proper reportable amount is shown.

AP-1099

1099 Processing and Year End Activities

Generally, 1099s are ready to process when all payables are paid through check date 12/31 of the year to be reported. 1099s are issued to any vendor who received a check dated during the year reported; 1099s are contingent upon check date, not invoice date.

The paper form to the vendor should be mailed by January 31st of the following year. The electronic file of 1099 payments is due to the IRS by the last day of February of the following year (the 28th or 29th). The reason for the time between issuing the vendor form and transmitting to the IRS is to allow for any errors pointed out by vendors to be corrected prior to filing the 1099 information with the IRS.

Review 1099 minimums. These minimum reporting amounts rarely change, but Dynamics 365 has provided a screen to review and adjust these. Verify with IRS documentation that the Tax 1099 field minimums are correct in Dynamics 365.

AP-1099

The minimum amounts can be adjusted to a higher or lower amount. For each vendor, Dynamics 365 will issue a 1099 when the amount paid in a tax year exceeds the minimum for the tax year for the 1099 type.

Review 1099s for duplicate taxpayer numbers. This would be when two vendors are using the same taxpayer number on their vendor record.

AP-1099

 

AP-1099 AP-1099

Review and adjust 1099 information.

Both summary and detailed review reports are provided within Dynamics 365.

AP-1099

(1) Is a summary view of 1099 information listed by vendor

(2) Is a report that lists invoice information detail by vendor

(1) Vendor settlement for 1099s’ summary view:

AP-1099

This form has multiple functions.

  • Edit vendor reportable amounts. Click the ‘Vendor 1099 transactions’ button to open a form for the selected vendor. This allows specific transactions to be adjusted (that may not be 1099 reportable in full).
AP-1099

Use the ‘Edit’ button to adjust any of the settled amounts:

  • Add manual reportable amounts. Click the ‘Manual 1099 transactions’ button to create a reportable transaction on a vendor that happened outside of Dynamics 365 processing. This can be used for data migration (to capture legacy transaction prior to cutover) or to record activity from GL/another system that we want to report on from Dynamics 365.
AP-1099

Use the ‘New’ button from this form to add a 1099 record:

  • Create the export file for the IRS. Use the ‘Create export file’ to begin the process of IRS reporting (covered in detail later in this blog).
  • Print vendor 1099 forms. Use this form, when ready, to print the vendor forms to mail.
AP-1099

(2) Tax 1099 detail report. This report is used to review, in detail, Dynamics 365 1099 reportable amounts by vendor.

AP-1099

 

AP-1099

File with IRS

Create IRS file. When ready to file forms with the IRS, return to the ‘Vendor settlement for 1099s’ form.

  • Select Create export file button:
AP-1099

The first time you do this, you will need to indicate to Dynamics 365 that you are filing these forms directly from the software (no 3rd party ISV vendor is required for this, but we need to mark this).

AP-1099

Return to the previous screen.

AP-1099

Now the ‘Create export file’ opens the file production program.

AP-1099

Note options for creating a Test file, which is recommended if you have never filed electronically with the IRS in the past. Since test files may take some time for the IRS to process, you should work through any file testing in advance of the 1/31/18 filing deadline.

Additional Resources for Year-End Reporting:

(USA) Set up vendors for 1099 reporting: https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/usa-set-up-vendors-for-1099-reporting

Year-end close: https://docs.microsoft.com/en-us/dynamics365/finance/general-ledger/year-end-close

If you have any questions about using this process in Dynamics 365 Finance and Supply Chain Management, please connect with us.

Contact Us About Your AX Needs

We specialize in providing technical assessments, break-fix support, optimization services, and solution expansion projects for Dynamics AX (Dynamics 365 for Finance and Operations).

Contact Us

Contact Us About Your AX Needs

Contact Us