Skip to content
logo Knowledgebase

My 1099 totals are incorrect in Accounts Payable

Created on  | Last modified on 

Description

Cause

  • The 1099 year was not closed at the correct time.
  • The 1099 year was closed more than once and is in a future year.

1099 amounts do not include the following:

  • Taxes paid.
  • Discounts taken.
  • Deductions.
  • Payments made by credit card.
  • Payments made for distributions marked as "exempt".

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
CAUTION: Sage Customer Support does not assist with issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please get in touch with your Sage business partner, network administrator, or accountant for assistance. Please refer to our Scope of Support document for details.

IMPORTANT: Close your 1099 year in Accounts Payable every year-end to keep it up to date. See How do I close the year or the 1099 year in Accounts Payable?

 

Verify the 1099 year ending date is correct. See How do I verify whether my 1099 year is correct in Accounts Payable?

When the 1099 year is closed the amounts in the This Year field is written to the Last Year field and the Next Year field is written to the This Year field.
If the 1099 year is not closed for several years, the Next Year field will have the payments for several years combined in the amount. When the 1099 year is then closed, the combined amount in the Next Year field is written to the This Year field.

  • Example: The AP Settings, 1099 year ending date is 12/31/2023. Checks written in 2024 updated the Next Year field. Checks written in 2025 before the 1099 year is closed also update the Next Year field. When the 1099 year of 2023 is closed, the combined 2024/2025 amount in the Next Year field is written to the This Year field.
  • A warning message appears during Print Checks, Record Manual/Print Quick Checks, and Record Payments by Credit Card if the Check Date or Payment Date is more than one year after the current 1099 year.

 

Option 1: Recalculate 1099 totals

IMPORTANT: Do not use Recalculate 1099 Totals if you have archived (moved to history) payments dated in the 1099 reporting year. Use Option II below.

If you have a couple of vendor 1099 amounts to correct, you may want manually correct the amounts using Option II below.

If the 1099 year ending date was correct and you would like to validate the 1099 amounts, see How do I use the Accounts Payable Recalculate 1099 Totals tool to correct 1099 amounts?

 

Option 2: Manually adjust the 1099 totals

If payments for the 1099 reporting year was moved to the history file or if you want to include amounts that are not automatically included in the 1099 amounts.

  1. Verify the amount paid. See How do I verify my 1099 amount paid for a vendor in Accounts Payable?
  2. Manually adjust the vendor or GL prefix 1099 amounts. See How do I manually edit 1099 amounts for Accounts Payable vendors?



Chat with support

Related Solutions

´╗┐Why do Forms 1099-MISC and 1099-NEC not include credit card payments in Accounts Payable?