PSL+: Prep and Review Your 1099 Data

This article will walk you through how to prep and review your 1099 data before generating your forms.

Jump to a section in this guide:

Step A: Verify the accuracy of company information

Step B: Verify vendor 1099 information

Step C: Transaction 1099 Tagging

Step D: Review 1099 Reports

Step E: Edit 1099 tagging

Step A: Verify the accuracy of company information 

Ensure your company information is accurate to avoid delays and possibly fines or penalties from the IRS for incorrect or late filings. The company information below is required by the IRS, and will be displayed as the PAYERS information on 1099 forms. 

1. Open Setup > Company Code and locate the correct company to autofill the other fields.
2. Verify or correct all information in the Company Entry window.
   

Step B: Verify vendor 1099 information 

Incorrect vendor 1099 information and tagging payments with a 1099 code are the most common barriers to successfully completing your 1099s. 

1. Open Accounts Payable > Vendor > Vendor Entry and verify the accuracy of all fields.
2. For the TIN Information section: 
   1. Name will be the name printed on the 1099 form; if it is left blank in the TIN Information section, the Name from the Vendor Information section will be printed on the 1099 form
   2. Work State is a required field
   3. Type is not required but recommended - options are available by clicking the field and pressing F2 
      
   4. The 1099 is not required but strongly recommended - options are available by clicking the field and pressing F2
      
      

   5.  Notes about the 1099 field:

      1. Selecting a 1099 type in this field will auto-tag all new payments to this vendor, so they will be calculated when you generate a 1099

      2. If you select a 1099 type after transactions have posted, the 1099 type won’t be retroactively applied; it will only be applied to new AP, PO, and PC transactions you create

Step C: Transaction 1099 Tagging

The 1099 amounts for each vendor will be accurate only if every payment transaction (AP, PO, PC) has a 1099 tag. As a shortcut to tagging each payment, you can give each vendor a default 1099 tag that will auto-populate with every new payment created. See “Notes about the 1099 field” above for more information.

1. Open Accounts Payable > AP Entry, or Purchase Order > PO Entry, or Petty Cash > PC Entry.
2. Create a payment and ensure State Worked is filled in; it will be prepopulated with the default from the vendor setup screen.
3. Click in the 9 column and press F2 to display options; this will not open unless you have State Worked and other required fields filled in first.
   1. If you are creating a new payment, this will be pre-populated with the default type entered into the 1099 field of the vendor setup screen; see “Notes about the 1099 field” above for more information.

Step D: Review 1099 Reports

How to review and download a summary report in PSL

Ensure all your 1099 vendors and their transactions are properly coded, so your 1099s will calculate correctly. The 1099 Forms and Report screen has several options to help confirm your data is accurate.

1. Open Accounts Payable > 1099 & ICR Reports > 1099 Forms and Report
2. Click on Summary Report.
   1. Before clicking print or preview, make sure your selection criteria is accurate
   2. All fields in yellow are required
3. Enter Tax Year.
4. Enter Company.
   1. If there are multiple companies within your project, please select the appropriate company.
5. Click Preview.
   
   1. Review all data before saving the file in Adobe.
6. If all data is correct, click File > Save As.
   
   
7. Title the file with "Show Name & Summary Report."

Blank Tax ID shows any vendors without a Tax ID.

Duplicate Tax ID shows any vendors having the same Tax ID as other vendors in the system.

Include State Worked will add that information to your reports.

Bank allows you to filter by different banks used for the 1099-tagged payments.

Include Non-1099able Items adds all vendor payments not marked as 1099, to confirm accurate coding.

Additional T4A information:

When generating T4A reports such as Summary, ensure you check the T4 Only box and Target Currency is set to CN.

Step E: Edit 1099 tagging

Use the Posted Transaction Editor to correct missing or incorrect vendor 1099 tags.

1. Verify State Worked is entered – if not, field 9 will be greyed out and not editable.
2. Add the appropriate 1099 code to each distribution line within the 9 column then click the Accept icon to save changes,
   1. Note: If you need to split distribution lines and you can’t do so, request “Full access” to the Posted Transaction Editor from your approver who will send a request to PSL+ Support.
      
      Additional T4A information:
3. Ensure you have the T4A indicator in payments.
   
   
   1. If a T4A payee is missing “T” in the #9 field of an AP or other payment, PSL+ cannot generate the T4A reports and prints.
   2. Email PSL.Support@castandcrew.com to request your tags are updated; send information to indicate what tags you used in Free Fields 1-4 to identify T4A payees in your database.