1. 1099 Year-End Processing Guide
  2. Understanding the 1099 A/P - G/L Combined Register

Understanding the 1099 A/P - G/L Combined Register

Regardless of whether you use the 1099 A/P Ledger method, the G/L method, or a combination of both methods to process 1099s, you must run the 1099 A/P - G/L Combined Register (R04512FB). The 1099 A/P - G/L Combined Register merges data from these tables into the 1099 Merged Worktables (F04514):

  • 1099 A/P Worktable (F045143)

  • 1099 G/L Worktable (F045141)

You should run the 1099 A/P - G/L Combined Register report twice. The first time you run the report, leave the Edit Type processing option blank. When this processing option is blank, the system performs a search for duplicate tax ID numbers, and then prints a report that lists the 1099 workfile records with error messages next to any records for which a duplicate tax ID exists. The system uses the company tax ID and tax ID fields to locate duplicates. Use this report to distinguish between suppliers who should have duplicate tax ID numbers (and should therefore be combined for 1099 processing), and those who should not have duplicate tax ID numbers. You must research the suppliers who should not have duplicate tax ID numbers, and correct the invalid numbers.

After you fix the invalid tax ID numbers, run the report again, and enter a 1 in the Edit Type processing option. This setting instructs the system to combine records with duplicate tax ID numbers for 1099 processing. This setting also instructs the system to determine whether a 1099 should be created, by comparing the total amounts for each supplier to the minimum amounts that are specified in the processing options. Your software is delivered with the processing options set to the minimum amounts established by the IRS.

To print a report that shows the same amounts as the actual 1099 returns, ensure that the minimum amounts are the same as those for the Write Media program (P04515) and that no one has changed them.