The 1099 totals are incorrect in Accounts Payable

Solution Properties

Solution ID:

222924650021507

Last Modified Date:

Fri Oct 30 18:48:29 UTC 2026

Taxonomy Path:

Category//Year end//Period end

Author:

sageadmin

The 1099 totals are incorrect in Accounts Payable

Description

Cause

The 1099 year wasn’t closed at the correct time
The 1099 year was closed more than once and is in a future year

1099 amounts don’t include the following:

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

Resolution

CAUTION:

Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Before you begin

Make a back-up of your data.
Verify if your 1099 year is correct in Accounts Payable.
Close the 1099 year, if needed.

When closing the 1099 year, the This Year amount moves to the Last Year field and the Next Year amount moves to This Year. If no one closes the 1099 year for several years, the Next Year field will have the payments for several years combined in the amount. When you then close the 1099 year, the combined Next Year amount moves to the This Year field.

A warning message appears in the following tasks if the Check Date or Payment Date is more than one year after the current 1099 year:

Print Checks
Record Manual/Print Quick Checks
Record Payments by Credit Card

Example: The AP Settings, 1099 year ending date is 12/31/2024. Checks written in 2026 updated the Next Year field. Checks written in 2025 before you close the 1099 year also update the Next Year field. When you close the 1099 year of 2024, the combined 2024/2025 amount in the Next Year field moves to the This Year field.

Use the Recalculate 1099 Totals tool

If the 1099 year ending date was correct, you can validate the 1099 amounts.

If you have a couple of vendor 1099 amounts to correct, you can manually correct the amounts instead of using the tool.

IMPORTANT: Don’t use Recalculate 1099 Totals if you’ve archived (moved to history) payments dated in the 1099 reporting year. Manually adjust the totals instead.

Manually adjust the 1099 totals

If you moved payments for the 1099 reporting year to history, you can manually adjust the 1099 totals. You can also use these steps if you want to include amounts that aren’t automatically included in the 1099 amounts.

Need more help?

Chat now

Steps to duplicate