Field descriptions: 1099 report

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

Select all vendors

Run the report for all vendors set up for 1099 treatment.

From vendor and To vendor

Choose to only include data for a specific vendor or range of vendors.

By default the report includes all 1099 vendors.

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.

• Vendor and employee: sort data alphabetically by vendor or employee.

• 1099 category: sort data by 1099 category, for example, 1099-DIV, 1099-MISC, and 1099-INT. Vendors and employees appear alphabetically within each category.

• None: Do not 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:

• By default, amounts are associated with the billing entity.

• If Generate separate 1099s by paying entity is selected, amounts are associated with the paying entity based on the bank account from which the payment was made.

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.

• Only 1099: only show transactions tagged for 1099 treatment.

• Non-1099: only show transactions that are not tagged for 1099 treatment.

• Show all: show all transactions regardless of 1099 status.

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.

• Summary: includes Vendor, Amount, 1099 Box, and Total.

• Detail: includes extra columns and lines with more detail.

  For example, individual line items of payments are shown for each vendor or employee, along with bill number, payment document number, account, and more.

Exclude credit card payments

Select this checkbox to exclude credit card payments.

To tie out your 1099-MISC form with the 1099 report, select this option.

Include bills paid with credits or advances

Include bills 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.

Page orientation

Portrait is the default layout.

• Portrait: display or print the report pages vertically.

• Landscape: display or print the report pages horizontally.

Sort by

Sort numerically by Vendor ID or employee ID, or sort alphabetically by Vendor Name or employee name.

Vendor/Employee

Vendor/Employee ID

1099 category

The type of 1099. For example, 1099-MISC.

Box

The 1099 box for the line item amount.

Tax ID

Memo

Any memo or note that was added when the payment was made.

Bill amount

The total amount billed to the vendor or employee for the selected period.

Bill or Expense no

The vendor or employee transaction number entered on the transaction page.

Paid amount

The total amount paid to the vendor or employee for the selected period.

Vendor/Employee

The vendor or employee associated with the 1099 amounts.

Vendor/Employee ID

The ID of the vendor 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.

Bill no

The bill number associated with the payment.

GL Account

The account to which the line item payment is assigned.

Tax ID

The vendor or employee Tax ID.

Memo

Any memo or note added when the payment was made.

Bill amount

The total amount billed to the vendor or employee for the selected period.

Paid amount

The total amount paid to the vendor or employee for the selected period.

1099 category

The type of 1099. For example, 1099-MISC.