R | This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package. |
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 subledgered by vendor, broker or employee in Chart of Accounts Setup.
This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox > Reports takes you to the Reports - All list, where you can make your selection.
Click 1099 Report. This opens the Report - 1099 selection form. Make your selections, pull down the File menu and select to:
Print Preview
Create CSV to export the report to the program of your choice.
Print Cover Page
|
Report Selections |
What is this? |
||||||||||
|
Report Date Range |
|
||||||||||
|
Business Unit |
Click the link to open the Business Unit Selections form and make your selections. |
||||||||||
|
Vendors, Employees, Brokers |
|
||||||||||
|
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 |
Description |
|
Entity Information |
Entity name and address, email address expressed as a link, and SSN (employees only) or Tax ID number. |
|
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 |
Description |
|
ID# |
Entity's Tax ID or social security number. |
|
LastName |
Last name of the entity. |
|
FirstName |
First name of the entity. |
|
|
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 |
|
My Vertafore Support | Vertafore University | NetVU Network | Vertafore.com © 2015 Vertafore, Inc. and its subsidiaries. All Rights Reserved. Vertafore, the Vertafore design, AMS360, Vertafore Producer Advantage, Producer Plus, AgencyEDGE, ReferenceConnect, BenefitPoint, Engage, and WorkSmart are registered trademarks of Vertafore, Inc. or its subsidiaries. Third party marks belong to their respective holders. AMS360 Classic Help updated 5/18/2016 11:01 PM |