Report: 1099

The 1099 Report assists your agency in identifying general ledger expenses that may be subject to filing of Form 1099 with the IRS. It identifies the vendor, broker, or employee, the 1099 category and type, and the transaction amount.

In order for data to pull to this report, the general ledger number involved in the check, receipt or journal entry must be sub-ledgered by vendor, broker or employee in Chart of Accounts Setup.

Report Selections

What is this?

Report Date Range

Options	What is this?
From List	Use this option to select a pre-defined date range from the list. The default option is: Current Quarter minus 1.
Select End Date	Use this option to type in a specific date range not covered by the choices in the From List option.

Business Unit

Click the link to open the Business Unit Selections form and make your selections.

Vendors, Employees, Brokers

Options	What is this?
All	Default selection is All.
Only Vendors	Choose this option to select All or a specific vendor.
Only Employees	Choose this option to select All or a specific employee.
Only Brokers	Choose this option to select All or a specific broker.

Include Reference Detail

Defaults as checked. If checked the printed report includes information about the type of entry (check, receipt or journal entry), and the source reference number.

This can be helpful when auditing the report in case you need to refer back to the source of the entry.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Report Fields

Report Fields	Description
Entity Information	Entity name and address, email address expressed as a link, and SSN (employees only) or Tax ID number. This information prints only if the appropriate fields are completed in entity setup forms (employee, broker and vendor).
Date	Entry date.
Category/Description	1099 category and voucher description. Defaults from the entity setup form (employee, broker or vendor) and/or from information selected at the time the check, receipt or journal entry is created.
Type	Prints the 1099 Type (if any) associated with the selected 1099 Category.
GL Type	The type of general ledger transaction (check, receipt, journal entry).
Check #/Ref #	Check # (if applicable)/source reference number. If the check has not been printed yet, the check number is unassigned.
Amount	Line item amount.
Total	Totals are reported for each Category/Type combination.

CSV Columns

CSV Columns	Description
ID#	Entity's Tax ID or social security number.
LastName	Last name of the entity.
FirstName	First name of the entity.
Email	Entity's email address.
Address1	Entity's address line 1.
Address2	Entity's address line 2.
City	Entity's city.
State	Entity's state.
Zip	Entity's zip code.
Category	1099 Category.
Type	1099 Type.
Date	Entry Date.
Description	Description from the source journal (check, receipt, or journal entry).
GLType	The type of general ledger transaction (check, receipt, journal entry).
Check #/Ref	Check number/source reference number. If the check has not been printed yet, the check number is unassigned.
Amount	Amount