SB Enterprise Help Center

1099Rs

Updated on

Summary

The 1099-Rs process is used to generate and print 1099-Rs. The employees included in the batch can be filtered by department and reporting group. If a specific employee in a department or reporting group should not be included in the batch, you can remove specific employees from the batch using the Edit step (PR> 1099-Rs> Edit). If you need to create a 1099-R from scratch (rather than using the paychecks made out to an employee to determine the gross distribution), you can create 1099-Rs using the Edit step (PR> 1099-Rs> Edit).

Below is the form that should be used with the process and is available from our form supplier, SOLV Group. If you have any questions regarding the form, contact SOLV Group at https://www.thesolvgroup.com. You can also download this Customer Connect Site User Guide from SOLV for information on how to place an order.

 

  • #LRA/B/C/2/D1 --LASER 1099 R Forms - 2 Up pre-printed form. Copies A, B, C, 2 or D1, two reports per 8 ½ x 11 page. Requires one print run for each copy filed. Uses envelope #DWMR below.
  • #DWMR(S) --Double Window ENVELOPES - Displays employer and recipient name and address. For use with the Laser Forms LMA & LRA above. DWMRS is a self seal envelope.

 

Springbrook will test the 2022 1009-R process using only the above form. If you do not order your forms from SOLV Group, check the format of the form above to make sure your forms are compatible.

The employee history that is included in the 1099-R batch is selected by the check date or batch date of the Computer Checks batch used to generate the payroll transactions. If you select batch date, the batch month and batch year attached to the Computer Checks batch will be used to select the transactions. For example, payroll checks processed in a Computer Checks batch with a batch month and batch year of 12/2022, a check date of 01/15/23, and a JE Date of 01/15/23, will be included in calendar year 2022. If the batch month and batch year is 01/2023, the checks in that batch will be included in calendar year 2023.

Step by Step

 

1     Open the 1099-Rs page.

  • The 1099-Rs process is a single batch process, meaning you can process only one batch at a time.
  • If there is an open batch in the 1099-Rs process, you will not be able to create a new batch. If you would like to create a new batch, you can either delete the existing batch by clicking the Delete icon   on the batch tile, or you can reset the steps in the batch by returning to the first step of the process. All of the information in the batch will be overwritten.
  • If there are no open batches in the process and you would like to create a new batch, click the Create New Batch button. This will open the New Batch view. The batch number, batch month, and batch year of the batch will not affect the transactions cleared in the process. The batch information is for reference purposes only.

 

2     Open the Batch Overview page.

  • The Batch Overview page provides a general overview of the selected batch.
  • The left navigation menu displays all the steps in the 1099-Rs process.
  • In the main section you'll see information about batch steps that are currently processing, next available batch steps, and the last completed batch step.
    • Batch steps that are currently processing will display a blue indicator bar to alert you that the step has not yet completed.
    • Once the preceding batch step is complete, the next available batch steps will be enabled and you can select the next step you would like to run.
      • While some batch steps are optional, any batch step that includes the Required tag   must be completed before the batch is allowed to proceed through to the Commit step.
  • The Batch Outputs section on the right will display any reports or exports that have already been generated in the 1099-Rs process.

 

3     Generate the 1099-Rs.

  • The Generate step is used to select the employees to include in the batch by department and reporting group. After the employees have been selected, you can remove specific employees from the batch using the Edit step.
  • Any 1099-R data already created in the batch (for example, if the 1099-Rs batch is on the Proof List step) will be overwritten when the Generate step is processed.
  • Open the Generate window (PR> 1099-Rs> Generate).
  • The Calendar Year field is used to enter the calendar year of the 1099-Rs generated in the batch.
    • The Calendar Year field will default to the current year minus one. For example, if the current date is 01/15/24, the Calendar Year field will display 2023.
  • The Date to Use drop-down menu is used to select which date will be used to select the payroll checks included in the batch.
    • Select Check if you would like to select the payroll checks by check date. All payroll checks with a check date during the year selected in the Calendar Year field will be included in the batch.
      • The check date is set during the Checks step of the Computer Checks process (PR> Computer Checks> Checks> Check Date field).
    • Select Batch if you would like to select payroll checks by the batch month and batch year of the Computer Checks batch used to create the checks. For example, payroll checks processed in a Computer Checks batch with a batch month and batch year of 12/2023, a check date of 01/15/24, and a JE Date of 01/15/24 will be included in the calendar year 2023 1099-Rs batch. If the batch month and batch year is 01/2024, the checks in that batch will be included in calendar year 2024.
      • The batch date is set when the batch is created using the New Batch window.
  • The Reporting Group field is used to process 1099-Rs for a specific reporting group. Click the Reporting Group field search button to select a reporting group from a list.
    • Reporting groups are created and maintained using the Reporting Groups Maintenance window (PR> Maintenance> Reporting Groups). Employees are attached to reporting groups on the Reporting Groups Maintenance window.
  • The Federal ID Number field will display the federal tax identification number of your organization.
    • The federal tax identification number is set up using the System Setup window (SS> Utilities> System Setup> General tab> Fed Tax ID field).
  • The Department column is used to filter the employees in the batch by the department attached to their employee record.
    • Check the toggle next to each department you would like to include in the batch.
    • Departments are attached to employee records using the Employee Maintenance window (PR> Maintenance> Employee> General tab> Department field).
    • Departments are created and maintained in the System Setup module (SS> Maintenance> Department Maintenance).
  • Running the Generate step will overwrite all 1099-Rs already generated in the batch.
  • Click the Submit button to generate the 1099s.

 

4     Edit the 1099-Rs.

  • The Edit step is used to edit the generated 1099-Rs, or remove specific employees from the batch.
  • Open the 1099-R Selection window (PR> 1099-Rs> Edit).
  • All of the employees selected in the Generate step will display in the 1099-R Selection window. You can add, edit, and delete 1099-Rs using this window.
  • Select a record and click DELETE to delete the selected 1099-R. This will remove the 1099-R from the batch.
  • Select a record and click EDIT to view the actual 1099-R form.
  • Click ADD to create a new 1099-R.
  • It is highly recommended that you review each 1099-R. The 1099-R Proof List (PR> 1099-Rs> Proof List) will only display the gross distribution, federal taxes withheld, state distribution, and state taxes withheld.
  • The Date of Payment field is used to specify the date payment was made for reportable death benefits. This is an optional field and should only be used when reporting the payment of death benefits to the IRS.
  • 1099-R check boxes like the Total distribution (Section 2b) check box will need to be manually entered. Select Yes in the Total Distribution drop-down to place a check in the Total Distribution box.
  • Click the Save button when complete to save the 1099-R.

 

5     Print a Proof List.

  • The Proof List Report displays the gross distribution, federal taxes withheld, state distribution, and state taxes withheld on each 1099-R in the batch.
  • Open the Proof List window (PR> 1099-Rs> Proof List).
  • Once the required report settings have been specified, click the Print button   to print your report.
  • Click the options arrow on the right side of the Print button to see other print options.
    • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
    • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
    • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
    • Enter a Date and Time to generate the report and click SUBMIT.

 

6     Print the 1099-Rs.

  • Open the Print window (PR> 1099-Rs> Print).
  • The Form Offset field is used to adjust the alignment of the forms on the page. Increase or decrease the value in the Form Offset field to change the top margin of the forms.
    • Start with a form offset of zero and then increase the value if the forms do not align properly on the page.
  • Click the Print button to generate the forms immediately.
    • This only generates the forms, it will not print the forms. After the forms have been generated, you can print them out at any printer.
  • Once the forms have been generated, you can print them out.
    • Double click on the Forms job in the Jobs Viewer to download a PDF of the 1099-Rs.
    • Before printing the forms on the blank 1099-R forms, print one or two forms on blank pages to verify the top of the form alignment is correct. If the form alignment is incorrect, regenerate the forms using a different form offset (PR> 1099-Rs> Print> Form Offset field).
    • Once the alignment seems correct, load the blank 1099-R forms into the printer and print a few 1099-Rs, rechecking the alignment. If the copies look correct, print the batch.
  • Review the printed 1099-Rs for accuracy.

 

7     Export the 1099-Rs.

  • Organizations that generate more than 100 1099-Rs are required to file electronically. The Export step is used to generate the required electronic file.
  • For additional information regarding 1099-R electronic submission requirements, please see IRS Publication 1220 at: https://www.irs.gov/pub/irs-pdf/p1220.pdf
  • The Your NameYour EmailPhone, and Extension fields are used to identify who is generating the export file.
  • The TCC field is used to enter the Transmission Communication Code assigned to your organization by the IRS. This is the same TCC number used for filing other 1099s.
    • The Your Name, Phone, and TCC fields are all required.
  • Check the Create as test file toggle to generate a test 1099-R export file that can be submitted through the IRS FIRE Test System.
  • Check the Combine state and federal toggle if your organization participates in the Combined Federal/State Filing Program (CF/SF).
  • Check the Allow Employees with no Employee Number toggle to include employees who do not have employee records in Cirrus.
    • If an employee included in the 1099R batch does not have an employee number in Cirrus, the export file will display the employee name entered on the Edit step for that data row.
  • The export file includes:
    • "T" Record - Transmitter of the electronic file.
    • "A" Record - Payer or institution making payments, the type of document being reported, and other miscellaneous information.
    • Multiple "B" records - Payee, specific payment amounts, and information pertinent to the form.
    • "C" record - Summary of payee "B" records and money amounts for each payer per type of return.
    • "K" records - Summary of State totals if the file includes records from multiple states and the Combine state and federal toggle is checked. Each state will have a separate "K" record.
    • "F" record - End of transmission.
  • Click the Submit button to generate the Export file. 
    • In the Jobs Viewer, the 1099-R export line will display PR 1099Rs in the Batch Type column and Export / 1099Rs in the Description column.
    • If the export file generates successfully, the Status column will display Complete.
      • Click on the 1099-R line item to download the export file and complete the export process.
    • If the export file did not generate successfully, the Status column will display Review.
      • Click the Details column to open the Errors window and review the export file.
      • By examining the error details, you can see which records in the export caused the Stop Errors so they can be addressed and the file can be generated successfully.

 

8     Clear the 1099-Rs in the batch if you need to generate them for another department or reporting group.

  • Before you clear the 1099-Rs in the batch, make sure the printed version of the forms are correct.
  • Select Clear 1099-Rs from the 1099-Rs menu.
  • Click the Clear Batch button and the batch will be cleared.
Previous Article PR Workers' Compensation Code Hierarchy
Next Article PR Accrual Adjustments
Still Need Help? Contact Us