Step 2. Print 1099 Reconciliation Reports
Use the 1099 Reconciliation Report to print invoice and check information for 1099 type vendors and to verify 1099 totals. You need to make sure all 1099 vendors appear on the report and all 1099 invoices are correct. In step 3, you will reconcile the 1099 vendor total to the 1099 invoice total. When you're done, the grand total on the 1099 Reconciliation Report - All 1099 Vendors should match the grand total on the 1099 Reconciliation Report - All 1099 Invoices.
Why do I need to complete this step?
Taking the time to find and fix the errors right now will save you a lot of time with completing the Accounts Payable Year-end Checklist. If you have a lot of 1099 vendors, this step may require a lot of work and time. However, completing this step will make converting the 1099 year-end information much easier because you won't need to enter the correction in two separate applications.
Correcting an error in the converted 1099 information, means
(1) correcting the error twice: once in the converted information and once in the vendor information in Accounts Payable; or
(2) correcting the error in Accounts Payable and then reconverting the 1099 information to the Government Reporting application.
Watch a webinar - 1099 Reconciliation report
Learn how to set up and print the 1099 reconciliation report.
First, print the 1099 Reconciliation Report - All 1099 Vendors
1. Open Connect Accounts Payable > Vendors > 1099 Reconciliation Report.
2. Use the Title box to select 1099 Reconciliation Report - All 1099 Vendors.
Title
3. Change the Report Dates to select the tax year (1/1/YYYY to 12/31/YYYY).
Report dates
4. Click Print (CTRL+P).
Place the report aside and print the 1099 Reconciliation Report for all 1099 invoices.
Second, print the 1099 Reconciliation Report - All 1099 Invoices
1. Open Connect Accounts Payable > Vendors > 1099 Reconciliation Report.
2. Use the Title box to select 1099 Reconciliation Report - All 1099 Invoices.
Title
3. Change the Report Dates to select the tax year (1/1/YYYY to 12/31/YYYY).
Report dates
4. Click Print (CTRL+P).
Place the report aside. Continue to Step 3. Review 1099 Reconciliation Report.
202411, 2024Dec12
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
Step 4. Print final copy of 1099 Reconciliation Report
If you made any changes to the 1099 vendor information, you'll need to reprint the 1099 Reconciliation Report - All 1099 Vendors and the 1099 Reconciliation Report - All 1099 Invoices. The grand total on the 1099 Reconciliation Report - All Vendors ...Step 3. Review 1099 Reconciliation Report
Compare balances on the 1099 Reconciliation Report - All 1099 Vendors to the balances on the 1099 Reconciliation Report - All 1099 Invoices. Both reports should have the same total. If the reports do not balance, look for a check or invoice that ...Quarterly Reporting and Reconciliation
Quarterly Reporting Checklist You want to take time to reconcile each quarter. When you reconcile a quarter, you are making sure everything in the quarter is balanced and everything looks good. Reconciling helps you identify any problems, fix them, ...Payroll Year End - Reconciliation Worksheet
You can use this worksheet to reconcile quarterly reports, annual 941 report, employee tax summary, and payroll history. After you print the reports (as part of the year end checklist), enter the values or totals from the reports into the worksheet. ...How do I print the Unupdated Payments Report?
Use this report to search for payments that have not been unupdated to other Connect applications. Unupdated payments will not be reported as paid in the related Connect application even though the payment was received in the Cash Receipting ...