- 1. Review Vendors that qualify to receive 1099s and verify their relevant 1099 information.
Use the Vendors grid to query Vendors with a 1099 Type and qualifying YTD Taxable Total.
In the Vendors grid, add the 'Type 1099', 'Tax ID Type', 'ID #" and 'YTD Taxable Total' columns to the grid. Under 'Type 1099' filter by <> non 1099 to query all 1099 vendors. You can then use the YTD Total to filter on amounts (i.e. >=600). You can also save your filtered grid by using the 'REPORT' button.
Review the Tax ID Type and Id# (SSN or EIN) for all 1099 vendors to make sure they are correct and identified.
If Vendors do not have a Tax ID Type or Id#, update the vendor record to include this information.
Note Issue: For any title Mass Change Tax ID Type
- districts imported before 08/28/18, the Vendor import did not properly import Classic's Tin Type for vendors whose Classic TinType was set to EIN. Step-by-Step instructions and the mass change definition file are available to clean up the data for those districts who were impacted.
USASR-3296 corrected this problem and was included on the 7.8.3 release on 8/28/18 so any USAS instances that were imported with version 7.8.3 or later do not need to perform the mass change routine.
Use the Vendors grid to review Vendors that have a qualifying YTD Taxable Total that are not marked to receive a 1099.
In the Vendors grid, add the 'Type 1099', 'Tax ID Type', 'ID #" and 'YTD Taxable Total' columns to the grid. Under 'Type 1099' filter by non 1099 to query all non 1099 vendors. You can then use the YTD Total to filter on amounts (i.e. >=600). You can also save your filtered grid by using the 'REPORT' button.
If Vendors are marked as "Non 1099" but should be receiving a 1099, update the Vendor's Type 1099 field, Tax ID Type, and Tax ID # and verify the Name and Address marked as the 1099 Location.
Run the SSDT 1099 Vendor Report to check 1099 data in order to ensure 1099 names, addresses, ID # and amounts are correct. By default, the report includes all 1099 types. You have the ability to include all 1099 types regardless of YTD amounts or those meeting the IRS requirement. You may also run the report for specified 1099 Types (i.e. royalty payments)
NOTE: The current 1099 Vendor Report template shows the Vendor's Primary Name and Address. This template report is scheduled to be updated to show the 1099 Vendor information on JIRA Issue USASR-4045. The updated report definition is available here to download and import into your instance via the Report Manager. SSDT 1099 Vendor Report - Updated
The Vendor Name and Address used for 1099 reporting is based on the Vendor Location with the 1099 check box marked on the Vendor record. To update the 1099 address, modify the location or change the 1099 check mark to use a different location address.
Classic Vendors with the "1099:" prefix entered in the Name2 field were imported with a Vendor Location using that name marked as the 1099 Address. For districts that are processing 1099s in Redesign for the first time, all 1099 addresses should be reviewed for accuracy.
Note title Mass Change Locations
Issue: For any districts imported before 7/11/18, the Vendor import did not create a separate 1099 locations for those vendors whose Name 2 field in Classic started with "1099:". Step-by-Step instructions and the mass change definition file are available to clean up the data for those districts who were impacted.
USASR-3165 corrected this problem and was included on the 7.7.0 release on 7/11/18 so any USAS instances that were imported with version 7.7.0 or later do not need to perform the mass change routine.
- 2. Enter Vendor Adjustments to correct YTD Taxable Total amounts if needed.
If the YTD Taxable Total needs to be updated for a vendor (Void Prior FY Check, Royalties, combining Vendor records) the Vendor Adjustments option can be used to modify the YTD Taxable Total and YTD Total fields.
The Vendor Adjustments option can be found by clicking the View icon on the Vendor. The amount can be entered as positive or negative to increase or decrease the totals.
For more information see the Vendor Adjustments section on the Vendors page.
- 3. Enter all transactions for the current month
- 4. Attempt to reconcile USAS records with your bank(s)
- 9. Generate any additional Calendar Year End Reports desired
- The Proration Utility can be use to generate a template for Worker's Comp
- Reports place holder
- Reports place holder
- 10. Under Periodic, run the 1099 Extract program.
- NOTE: Select 2019 as the Payment Year
- Select the appropriate Output File Type:
- Edge Format (XML) is the output file to be used when printing 1099s
- IRS Format (TAP) is the output file used to generate the TAP file for IRS submission
- Review the File Name, TIN, Address and contact information
- Click on 'Generate Extract File' to generate the selected output file type
- Click on 'Print Report' to generate the 1099 Extract Report in PDF format
- 11. To close the month, under the Core menu, click on Posting Periods.
- Click on to create the new posting period. Select the month, enter the calendar year and checkmark the 'current' box to make the new posting period the current period.
- Click on if you would like to 'Close' the current period.
- The MonthlyCD report bundle will automatically run when the Posting Period is closed.