Skip to main content

1099 Reports and Forms

Print Friendly

1099 Overview

1099 amounts can be tracked in Restaurant365, so that at year end the user can run a report to review those amounts for each vendor, make updates and then print the actual 1099 forms out of R365 (must purchase blank 1099 forms prior to printing).
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.
There are 2 reports associated with the 1099 process:
  1. 1099 Review report (located under Accounting – Reports in the Vendor section of the page)1099 Review is intended to be run first to see the 1099 amount for each applicable box for each vendor. This report allows you to drill into individual transactions marked as subject to 1099 to change the 1099 box or 1099 amount fields as desired.
  2.  1099 Form (located under Accounting – Reports in the Vendor section of the page)The 1099 Form report prints actual 1099 forms. It prints the most common 2 part format with a separate 1099 on the top half of a the page and bottom half of page. You can purchase the forms at a local office supply store or online and then put them in the printer and use the 1099 Form report to populate the forms.

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.


  1. To create the beginning balance invoice & payments, click on ‘Administration’, select ‘Beginning Balance’, then select ‘AP Invoice’.  Add the invoice number like 1099BegBal2014, 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 all is entered, Approve and Close.
  2. Next create the beginning balance payment, click on ‘Administration’, select ‘Beginning Balance’, then select ‘AP Payment’ and apply the payment to the invoice and approve and close.
  3. Repeat these steps for each vendor that you need to add 1099 YTD history for.  FYI you may need to reopen accounting periods to add the beginning balance transactions.


Was this article helpful to you?

Comments are closed.