| | Reconcile 1099 vendor amounts using the Payment History Report |
| Resolution | | [BCB:1:Backup warning:ECB] Run the Payment History report - Open Accounts Payable, Main, Reports, Payment History Report.
- Select Vendor Number from the dropdown for Sort Report By.
- 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.
- Select Print 1099 Vendors Only.
- Note: This option appears only when you enable the 1099 Reporting checkbox in A/P Options.
- Use the Selection Field to run the report for a specific vendor or all vendors.
- 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: - Open Modules, Accounts Payable, Main, Vendor Maintenance.
- Enter the vendor in Vendor No.
- Click the Additional tab.
- Click 1099 History.
- Select the 1099 form type and calendar year.
- Update the amounts as needed.
- Click OK, then click Accept.
[BCB:155:Chat 100 US:ECB]
|
|