1099 WH Manual Adjustments

Purpose: Use this document as a reference for manually maintaining 1099 withholding transactions in ctcLink.

Audience: Accounts Payable staff

You must have at least one of these local college managed security roles:

  • ZZ 1099 Processing

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

You can adjust withholding manually if necessary. This process is for manually adjusting posted withholding transactions by Supplier or adding withholding entries from a legacy or third-party system.

Whenever possible, we advise you to make your adjustments through “Withholding Supplier Update” or “Withholding Invoice Line Update”. These types of adjustments update the underlying Withholding tables, unlike the manual adjustments which only update the Withholding Transaction table.

1099 WH Manual Adjustments

Navigation: Suppliers > 1099/Withholding > Maintain > Adjust Withholding

  1. The Withholding Adjustment search page displays. Enter field values:
    1. Enter Supplier SetID = "WACTC".
    2. Enter Supplier ID of the supplier you are updating.
    3. Enter your college-specific Supplier Location.
  2. Select Search.
Withholding Adjustment Find an Existing Value page with example data populated in the search fields.
  1. The Withhold Adjustments page displays. Enter field values:
    1. Enter Business Unit.
    2. Enter Start Date = 01/01/20XX (current year).
    3. Enter End Date = 12/31/20XX (current year).
  2. Select Search.
Withhold Adjustments page. Within the Search Criteria section, the Business Unit, Start Date, End Date, and Search button are highlighted.

Due to the IRS update on withholding type, all posted transactions need to be updated with the new withholding type.

To do this, add two rows: one with the old withholding type and a negative balance to offset the original transaction, and another with the new withholding type to post the reporting amount.

  1. Enter a new adjustment by inserting a new line. Select the Add a New Row [+] icon.
  2. On the Main Information tab enter the following:
    1. Business Unit.
    2. Entity.
    3. Type.
    4. Jurisdiction.
    5. Class.
    6. Rule.
Withhold Adjustments page. Within the Adjustments section on the Main Information tab, all fields are highlighted.
  1. Select the Transaction Info tab.
  2. Enter a negative balance to offset the old withholding type and add the basis amount to the row with the new withholding type.
Withhold Adjustments page. With the Adjustments section on the Transaction Info tsab, the Basis Amt fields are highlighted.

The Liability Amount displays the amount of backup withholding that is retained to remit to the withholding entity. The Paid Amount displays the amount of the withholding liability that has been paid to the withholding entity. These two fields should always be zero.

For Payment Date, all adjustments should have a Payment Date of December 31st of the 1099 reporting year. In addition, the Declaration Date displays the date on which the withholding is declared and is used for withholding entities who use a date other than payment date (accounting date for example) to report withholding transactions. Because we use Payment Date, it should be the same date that we entered for Payment Date, which is December 31st of the 1099 reporting year.

  1. Select the Adjustment Reason tab.
  2. This tab is used to record why the adjustment was made. The Creation Date is the date you are entering the adjustment, and the User ID is the person making the adjustment. For the Description, you should include a reference as to why the adjustment was made.

Each transaction row that you enter is then added to the Withholding Transaction table (WTDH_TRXN_TBL). It is also added to or subtracted from the totals already in the Withholding Transaction table.

Withhold Adjustments page. Within the Adjustments section on the Adjustment Reason tab, the Description fields are highlighted.
  1. Select Save.
  2. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.