Reconcile 1099 vendor amounts using the Payment History Report
Description
Cause
Resolution
[BCB:1:Backup warning:ECB]

 

Run the Payment History report

  1. Open Accounts Payable, Main, Reports, Payment History Report.
  2. Select Vendor Number from the dropdown for Sort Report By.
  3. Select one of the following criteria:
    • By Period = Fiscal Year and Period Range for the applicable 1099 calendar year.
    • By Date = Starting and Ending Date for the applicable 1099 calendar year.
  4. Select Print 1099 Vendors Only.
    • Note: This option appears only when you enable the 1099 Reporting checkbox in A/P Options.
  5. Use the Selection Field to run the report for a specific vendor or all vendors.
  6. Click Print or Preview.

Retain supporting reports for audit

  • Keep detailed reports that support 1099 payment totals for audit purposes.
  • Print the Accounts Payable Trial Balance Report for paid invoices and 1099 totals before you print the forms.  This assumes that you retain invoices for the full year.
  • If you don’t retain invoices for the full year:
    • Print the trial balance report before closing each month.
    • Include paid invoices and 1099 information for each month.
    • Maintain these reports to support year-end 1099 forms.

Compare totals and validate discrepancies

  • Compare the Payment History Report totals with:
    • Form 1099 eFiling and Reporting total
    • Vendor 1099 History
  • If the amounts don’t match, then:
    • Run the Check History Report.
    • Confirm all checks, electronic payments, manual checks, and reversals post to the correct fiscal year.
    • Reverse any check posted to the wrong year and re-enter it with the correct date.

Correct vendor 1099 history

If the reports are correct but the totals still don’t match, update the vendor record:
  1. Open Modules, Accounts Payable, Main, Vendor Maintenance.
  2. Enter the vendor in Vendor No.
  3. Click the Additional tab.
  4. Click 1099 History.
  5. Select the 1099 form type and calendar year.
  6. Update the amounts as needed.
  7. Click OK, then click Accept.

 

[BCB:155:Chat 100 US:ECB]



Steps to duplicate
Related Solutions

 How to correct the amounts printed on the 1099 form
 How to print and/or eFile Form 1099 and 1096 in Sage 100
 How to exclude an A/P invoice for a 1099 vendor
 1099 calendar year is missing or blank in Form 1099 Tax Reporting