Reports
1099-MISC Report Using BK99CB
The BK99CB report prints all payees and their 1099-MISC data in an easy-to-read standard report format. This report is useful for verifying payees and dollar amounts.
To ensure the data on the report will match the 1099-MISC forms, answer all report prompts the same for the report and the form printing process. Under Options, the user can select to run the report with SSN masked.
When running this report or printing the forms for the recipients, it is not common to use selection criteria. The transactions selected without any selection criteria will meet the following requirements:
- Dated in the calendar year for which the 1099-MISCs are being processed.
- If a BKDB transaction, it must have a status of IS (issued), CX (canceled).
- If an OHDB transaction, it must have a status of PD.
- BKDB or OHDB transactions must be flagged with appropriate Relate To codes.
- Person/Entity is defined on the P/E Information page with appropriate 1099-MISC flag value.
Year-End 1099-MISC Report
When 1099-MISC forms are processed, a report is printed which summarizes the 1099-MISCs. This report should be reviewed prior to processing for submission. When reviewing this report, attention should be paid to the Payee ID column.
The Payee ID column consists of three parts: D, F, and Payee ID:
D | Identifies the database from which the Tax Identification Number and address information was extracted. The following values are possible: P - BusinessPlus Person/Entity Data Base |
F | Specifies which field of the database from which the Tax Identification Number was extracted. The following four values are possible: T - TIN Field |
Payee ID | Consists of the PE ID used for this Payee. |
The Payee ID will be appended with a sequence number that was automatically generated when the Payee ID was processed through the 1099-MISC process. This 3-digit number is a sequence number that will start with "001" and will increment by "1" for each time the 1099-MISC process is run. All Payee IDs in the same 1099-MISC run will receive the same sequence number. The sequence number will also print on the 1099-MISC form in the box called "Account Number."
It is very important that this report be reviewed prior to submission. Blank tax identification numbers and addresses are not valid for reporting purposes and should be corrected before submission to the IRS.
1099 Common Code Report (BK99CR)
The BK99CR report generates a list of the BusinessPlus common codes related to the 1099-MISC process. This is helpful for new users and for troubleshooting. The report will indicate if a 1099-MISC related common code is not defined. It will provide a description of the common code fields and the current defined values.
When the report is run, the user will be prompted to "Exclude COMB Common Codes from report." If the user answers "Y," the report will not display any of the CK99/COMBxx common codes and will display only the remaining 1099-MISC common codes. If the user answers "N," the report will display all 1099-MISC common codes including the CK99/COMBxx common codes. Note that the system will block a report from printing if the CK99/COMBxx setup is incorrect.