FIS 8'4 1099

1
FIS 8.4 1099 Withholding Process Flow
Presented by Jenn Nguyen
January 23, 2006
2
FIS 8.4 1099 WithholdingProcess Flow

• IRS FTB Setup and Processing in PS 8.4
• Withholding Rules
• Withholding Types and Classes
• Withholding Jurisdictions
• Withholding Business Unit Vendor Categories
• Withholding Entity Setup
• Withholding Codes
• Withholding Report Control Definition
• Procurement Accounting Control
• Setup 1099 Calendar Year
• See FIS 8.4 BPP Setting Up Payables for IRS
  FTB Reporting and Processing for setup

3
FIS 8.4 1099 WithholdingProcess Flow

• 1099 New Changes as per IRS
• 15A Section 409A Deferrals
• 15B Section 409A Income
• 1099 CopyB Adding New Classes

4
FIS 8.4 1099 WithholdingProcess Flow
IRS FTB Process Flow
Create Reporting Information - FTB
(AP_WTHDRPT)
Create Withholding Vendor
Post Wthd (AP_WTHD)
WTHD_TRXN_TBL IRS FTB
PS_VOUCHER_LINE PS_VCHR_LINE_WTHD PS_PYMNT_VCHR_WT
HD PS_PYMNT_VCHR_XREF
Create a Withholding Voucher (IRS FTB
35)
Wthd 1099 Rpt Post (1099_RPT_PST)
WTHD_1099_TBL IRS
WTHD_RPT_TBL FTB
Create Split Payments for IRS FTB after running
Payment Selection -- (1)
Net Amt (2) Wthd Amt
WTHD_1099_COPYB WTHD_TO_SND_HDR WTHD_TO_SND_DTL W
THD_TO_SND_PAY
Budget Checking (FSPKBDP3 or FSPKBDP1)
FTB Forms 592 and 592B
Wthd 1099 Report (APY1099)
Voucher Post Request (AP_PSTVCHR)
IRSTAX.001 FILE
Wthd Sent File (WTHD_SNT)

• Create Wthd Vendor User defines the Vendor
  Category and uses to determine whether
  withholding will take place.
• Create a Wthd Vchr Split Payments is determined
  at the pay cycle.
• Run posting processes.
• Run Post Withhold Updates WTHD_TRXN_TBL for IRS
  FTB.
• Run Global Withholding (Create Reporting
  Information) for FTB Takes FTB data from
  WTHD_TRXN_TBL and updates WTHD_RPT_TBL.
• For 1099 Reporting (1) Run Withhold 1099 Report
  Post Takes IRS data from WTHD_TRXN_TBL and
  updates WTHD_1099_TBL, (2) Run Withhold 1099
  Report Takes IRS data from WTHD_1099_TBL and
  updates WTHD_1099_COPYB, WTHD_TO_SND_HDR, DTL ,
  PAY creates the IRS Tax file, (3) Run
  Withholding Sent File after the IRS Tax file is
  submitted to the IRS Takes IRS data from
  WTHD_TO_SND_HDR, DTL, PAY and updates
  WTHD_SENT_HDR, DTL, PAY.

Payment Selection (AP_APY2015)
Create Check Net Amt for Vendor
Payment Post (AP_PSTPYMNT)
WTHD_SENT_HDR WTHD_SENT_PAY WTHD_SENT_DTL
5
FIS 8.4 1099 WithholdingProcess Flow

• Identify Differences Adjust/Update 1099 Vendors
• Create a query 1099 Vendor Totals for calendar
  date range and compare data with WTHD_TRXN_TBL
• Review Withholding Voucher/Vendor Mismatch Report
  (APY9010)
• Review Duplicate Vendor Report (APY3215)
• Update Vendor Withholding
• Update Voucher Line Withholding
• Run Update Withholding
• Withholding Adjustment

6
FIS 8.4 1099 WithholdingProcess Flow

• 1099 Reference Tables
• Voucher Save VCHR_LINE_WTHD
• Payment PYMNT-VCHR_WTHD
• Withhold Post WTHD_TRXN_TBL
• 1099 Report Post WTHD_1099_TBL
• 1099 Report WTHD_TO_SND_DTL
  WTHD_1099_COPYB
• IRSTAX.001 FILE
  (output file)
• 1099 CopyB WTHD_1099_COPYB
• Withholding Sent File WTHD_SENT_DTL
  WTHD_SENT_HDR
  WTHD_SENT_PAY

7
FIS 8.4 1099 WithholdingProcess Flow

• State Tax Withholding
• Voucher Save VCHR_LINE_WTHD
• Payment PYMNT-VCHR_WTHD
• Withhold Post WTHD_TRXN_TBL
• Creating Reporting Information WTHD_RPT_TBL

8
FIS 8.4 1099 WithholdingProcess Flow

• Where to find additional Information
• Internal Revenue Service
• Website www.irs.gov
• Publication 1220 Instructions for filing
• Form 1099-Misc 1099 Misc Instructions
• Franchise Tax Board
• Website www.ftb.ca.gov