Workfiles Generated During 1099 Processing

The system generates or the user updates the following workfiles during 1099 processing:

Workfile

Description

One Time Payment - 1099 Information (F0411AB9)

Address book information for one-time payment suppliers, as well as the required 1099 information, such as the legal name and payables type.

1099Audit File (F045144)

Account ledger information for expenses such as G/L account numbers, dates, document numbers, voucher company, and G/L distribution companies. This file also includes payment numbers and payment dates.

1099 Adjustment File (F045145)

Company, type of return, address number, and amount.

1099 A/P Workfile (F045143)

Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID.

Based on the F0411, F0413, and F0414 tables.

1099 G/L Workfile (F045141)

Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID.

Based on the F045144 file and AAI ranges for PXxxxx.

1099 Securities Identification (F04510)

CUSIP information.

1099 Combined Workfile (F04514)

Company, supplier number, supplier tax ID, type of return, payment amount, and company tax ID.

Based on a combination of the F045141, F045143, and F045145 workfiles.

1099 Transmittal File (F1099T)

1099 data generated in the format required by the IRS 1220 Publication that you submit to the IRS.

Based on the F04514 workfile.