The 1099D table defines the From and To date range associated with a Transaction Code that will be used to select records from the 1099 Journal. While the Offline 1099 Process normally selects records based on a calendar year (January 1– December 31), this table allows you to define the date range that a specific Transaction Code should be selected. For example, the Record Date of a transaction on 1099 Reporting Journal must be between or equal to the Record Date range provided on the 1099D record associated with the Transaction Code for the Calendar Year defined by the batch parameter. Other date ranges can also be entered to provide additional selection criteria for the transactions on the 1099 Journal. Those include the From and To Acceptance Dates and From and To Check/EFT Issue Date. The From and To Check/EFT Issue Dates are only allowed for Transaction Types of AD, DC and MD. When multiple date ranges are entered, the transaction must meet all criteria to be selected.
The following example shows how the From and To Acceptance Dates can be utilized by the Offline 1099 Batch process when specified on the 1099D table.
An example of the 1099D table setup for a JVA transaction would be:
Calendar Year: 2020
Transaction Code: JVA
From Record Date: 01-01-2020
To Record Date: 12-31-2020
From Acceptance Date: 01-01-2020
To Acceptance Date: 01-20-2021
From Check/EFT Issue Date: <blank>
To Check/EFT Issue Date: <blank>
This setup says “select from the 1099 Journal all reportable JVA transactions processed with an Acceptance Date (that is, Run Date) between 01-01-2020 and 01-20-2021 and a Record Date between 01-01-2020 and 12-31-2020”.
The following examples show how the From and To Check/EFT Issue Dates can be utilized by the Offline 1099 Batch process when specified on the 1099D table.
An example of the 1099D table setup for an AD transaction would be:
Calendar Year: 2020
Transaction Code: AD
From Record Date: 01-01-2020
To Record Date: 01-20-2021
From Acceptance Date: <blank>
To Acceptance Date: <blank>
From Check/EFT Issue Date: 01-01-2020
To Check/EFT Issue Date: 12-31-2020
This setup says “select from the 1099 Journal all reportable AD checks issued during the calendar year 2020 (that is, has a Check/Issue Date between 01-01-2020 and 12-31-2020) where associated transactions, including cancellations, were processed with a Record Date between 01-01-2020 and 01-20-2021”.
An example of the 1099D table setup for a DC transaction would be:
Calendar Year: 2020
Transaction Code: DC
From Record Date: 01-01-2020
To Record Date: 01-20-2021
From Acceptance Date: <blank>
To Acceptance Date: <blank>
From Check/EFT Issue Date: 01-01-2020
To Check/EFT Issue Date: 12-31-2020
This setup says “select from the 1099 Journal all reportable DC transactions processed with a Record Date between 01-01-2020 and 01-20-2021 to stale date checks issued during the calendar year 2020 (that is, has a Check/Issue Date between 01-01-2020 and 12-31-2020)”.
Entries on this table are not required for every disbursement transaction code. If a Calendar Year and Transaction Code combination does not exist on this table for the calendar year that the Offline 1099 Process will run against, the batch process will assume that the records posted during the calendar year are eligible for 1099 Reporting (assuming all other 1099 eligibility requirements are met).