R365 offers the ability to track any 1099 eligible transactions by Vendor.  This is set on the Vendor record and is unique to each Vendor.  Refer to the following articles for more information on forms 1099 & 1096.


The Vendor record has a 1099 Box field and invoices also have 1099 Box and 1099 Amount fields. The 1099 report is generated not from the 1099 Box on the vendor but the 1099 Box on each invoice. The report is calculated by summing the 1099 Amount on each invoice that was paid during the year for each vendor. The 1099 Box on the vendor is the default so when you create an invoice for a vendor that has a 1099 Box, the system will assign that same 1099 Box to the invoice and put the Amount of the invoice in the 1099 Amount field. Then, when the invoice is paid it, will show up in the 1099 report. 

If the user doesn’t want that particular invoice to be subject to 1099, wants it to go to a different 1099 Box, or wants only a portion of the amount to be 1099 then they can change the 1099 Box or 1099 Amount fields on that invoice. Set the 1099 Box on each vendor prior to creating invoices for that vendor (most common box is Box 7). The setting will not update invoices already created for the vendor prior to setting the 1099 Box, so the 1099 Amount and 1099 Box fields on those existing invoices would need to be updated manually. If there is a large number of invoices to update, please contact R365 Support.

1099 Historical Data

To add 1099 history (payments from your old system for the current year) to a Vendor, you need to create a Beginning Balance AP Invoice and Payment for the YTD 1099 amount from your old system. Before following the steps below, please ensure that the period is open; if it is currently closed, please reopen it before creating any Beginning Balance transactions. 

  1. To create the Beginning Balance Invoice and Payments:
    •  Hover over ‘Administration’, then ‘Beginning Balance’, and select ‘AP Invoice’
    • Add the invoice number as '1099BegBal2019', add the Vendor, update the invoice date to a date prior to your Go-Live date in R365, add the amount into the amount field, and then select the Location to set the Legal Entity
    •  Once entered, Approve and close
  2. Next, create the Beginning Balance Payment by hovering over ‘Administration’, then ‘Beginning Balance’, and select ‘AP Payment’. Apply the payment to the invoice, and then Approve and close.
  3. Repeat these steps for each Vendor that you need 1099 YTD history.
    • Note: These transactions may remain on the AP Aging report. Although they will clear each other out, they will still show unless 'Hide $0 Balances' is toggled to 'Yes' in the Report Parameters.

1099/1096 Reports and Forms

Electronic 1099s through tax1099.com

Click here for more information on the 1099tax.com export.

Pre-2017 tax year - Print 1099

Click here for instructions on how to print physical copies of the 1099 report.

Pre-2017 tax year - Print 1096

Click here for instructions on how to print physical copies of the 1096 report.