Field descriptions: 1099 report
The following tables describe each field on the 1099 report page and the columns that appear in the summary and detail reports.
1099 report filters and settings
Time period
| Field | Description |
|---|---|
Reporting period | These periods are relative to the As of date. All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select. |
As of date | The date used as a baseline for the selected reporting period. The default is today's date. Format = MM/DD/YYYY |
Start date | Leave blank to include all information from the earliest date of your data up to and including the end date. Format = MM/DD/YYYY |
End date | Leave blank to include all information from the start date up to today. Format = MM/DD/YYYY |
Filters
| Field | Description |
|---|---|
Select all suppliers | Run the report for all suppliers set up for 1099 treatment. |
From supplier and To supplier | Choose to only include data for a specific supplier or range of suppliers. By default the report includes all 1099 suppliers. |
Select all employees | Run the report for employees set up for 1099 treatment. |
From employee and To employee | Choose to only include data for a specific employee or range of employees. By default these fields are cleared, which means the report will include all employees. |
Group by | Select how to sort data.
|
Entity or entity group | Required for top-level companies configured to Issue a separate 1099 per entity. Select an entity to view its 1099 amounts, or select an entity group to combine eligible amounts for the entities in the group. The entity associated with a 1099 amount depends on your Accounts Payable configuration:
|
Prompt on run | Require anyone who views the report to select an entity or entity group before running it. |
1099 form type | Select which 1099 form or forms to include. |
Transaction information | Select what kind of transaction information to include.
|
Show eligible amounts only | Only include payments that exceed the IRS minimum reportable amount.
|
Summary or detail | Depending on how much information you want to include, select either Summary or Detail.
|
Exclude credit card payments | Select this checkbox to exclude credit card payments. Credit card transactions are never included in 1099-MISC forms. To tie out your 1099-MISC form with the 1099 report, select this option. |
Include AP purchase invoices paid with credits or advances | Include AP purchase invoices tagged for 1099 treatment that were fully or partially paid with a credit or advance. To tie out your 1099 form with the 1099 report, select this option. |
Format
| Field | Description |
|---|---|
Page orientation | Portrait is the default layout.
|
Sort by | Sort numerically by Supplier ID or employee ID, or sort alphabetically by Supplier Name or employee name. |
Default 1099 summary report columns
If you run the 1099 report with a summary view, the following information appears.
| Report column heading | Description |
|---|---|
Supplier/Employee | The supplier or employee associated with the 1099 amounts. |
Supplier/Employee ID | The ID of the supplier or employee associated with the 1099 amounts. |
1099 category | The type of 1099. For example, 1099-MISC. |
Box | The 1099 box for the line item amount. |
Tax ID | The supplier or employee Tax ID. |
Memo | Any memo or note that was added when the payment was made. |
AP purchase invoice amount | The total amount billed to the supplier or employee for the selected period. |
AP purchase invoice or Expense no | The supplier or employee transaction number entered on the transaction page. |
Paid amount | The total amount paid to the supplier or employee for the selected period. |
Default 1099 detail report columns
If you run the 1099 report with the detail view, the following information appears.
| Report column heading | Description |
|---|---|
Supplier/Employee | The supplier or employee associated with the 1099 amounts. |
Supplier/Employee ID | The ID of the supplier or employee associated with the 1099 amounts. |
Entity | The entity associated with the 1099 amount. Depending on your Accounts Payable configuration, this is either the billing entity or the paying entity. |
AP purchase invoice no | The AP purchase invoice number associated with the payment. |
GL Account | The account to which the line item payment is assigned. |
Tax ID | The supplier or employee Tax ID. |
Memo | Any memo or note added when the payment was made. |
AP purchase invoice amount | The total amount billed to the supplier or employee for the selected period. |
Paid amount | The total amount paid to the supplier or employee for the selected period. |
1099 category | The type of 1099. For example, 1099-MISC. |
