Form 1099-G Reporting (F1099G)

The Form 1099-G Reporting (F1099G) page stores the data necessary to print the 1099-G Form and generate the associated transmittal file to the IRS. Records can only be inserted by the Forms Reporting Table Load batch process. Only the Reprint, Exclude Print, User-Defined 1, and User-Defined 2 fields can be updated on this page; all other fields are protected. Updates should be made to the most current record (Current Record=Yes). The data from this page is taken from the output files of the Offline 1099 Process. Any changes required to the data should be initiated by correcting records on the 1099 Reported Income (1099R) or 1099 External Reported Income (1099ER) tables.

Records on 1099R can also be corrected using the M1099 transaction. Refer the "1099 Business Tasks" topic in this user guide for guidance on corrections.

If records were consolidated from 1099R and 1099ER (i.e., On TAXOPT, Consolidate Internal and External Income was set), the internal record from 1099R will be loaded first as version 1 then the external record from 1099ER will be loaded as version 2. The Account Number on F1099G will be Account Number of the source record. The Consolidated Account Number will be the Account Number of the first record that was loaded first. For example, the Account Number on the 1099R record was 123 for $400. The Account Number of the record on 1099ER was 456 for $100. When the records were loaded to F1099G, the records will appear as follows:

If data differs between internal and external records for the same field, data from the internal (1099R) record will be kept. For example, the Name on 1099R is Johnathon Smith and the Name field on 1099ER is John Smith. Since 1099R records will be loaded first, Johnathon Smith will be displayed in the Name field.

Select Export > Viewable Columns or Export > Available Columns from the Export menu to export only the selected records to a CSV file.
Select Export All > Viewable Columns or Export All > Available Columns from the Export menu to download all data returned by the inquiry to a CSV file.
Select Export All > Spreadsheet from the Export menu to download all data returned by the inquiry to a spreadsheet. The maximum number of records that can be downloaded is 2000. If more than 2000 records have been returned in your search results, then an error is received. Refine your search results until the maximum number of records returned is 2000 or less.

Note: Refer to the “Export Grid Results to CSV” topic in the CGI Advantage Page/Table User Guide for detailed instructions on how to export the results to a CSV file and how to use an import wizard to open the file in Microsoft Excel.

Select Related Pages > Print Tax Form from the row-level menu to print a tax form for the selected form record. The link transitions to the Online Tax Form Printing Parameters page, where required parameters are entered for printing the selected form.
The 1099 Reported Income link transitions and filters the results based on the Calendar Year, Reporting Payer, Form Type, TIN, and TIN Type from the selected record.
The 1099 External Reported Income link transitions and filters the results based on the Calendar Year, Reporting Payer, Form Type, TIN, and TIN Type from the selected record.

Account Number	Consolidated Account Number	Version	Amount
123	123	1	$400
456	123	2	$500