Report: 1099s

From Agency Systems Wiki
Revision as of 16:27, 23 January 2024 by Pstuntz (Talk | contribs) (updated to show 1099-NEC, with link to the RPT file)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Related Pages
Related Categories

Agency Systems has the capability to calculate 1099 amounts, then either print to the IRS 1099 laser forms, or create an electronic file for submission.

If you have manually entered 1099 totals on the vendor or broker (agent) profiles, the manually entered amount will display on the 1099 reports and forms instead of being calculated.

Access and Window Options

The 1099 report window can be opened by selecting Vendor -> 1099 MISC-Forms.

Access to the 1099 report is controlled through the security system A/P -> 1099 MISC-Forms -> View setting.

Menu-1099.png

  • Report By: Only Broker Clients, Only Vendors, or Both.
  • Balance Method: Debit Balances Only, Balances > $599.99, or All Balances.
  • Output: Listing, Forms (1099-MISC), Magnetic Media, Test Magnetic Media, Replace Magnetic Media, Laser Forms (1099-MISC)

Report Process

It is recommended to preview or print the 1099: Output -> Listing report first in order to:

  • Verify the correct address and tax id information stored for the vendor and/or agent profiles.
  • Verify the number of 1099 forms required. (1099 laser forms must be purchased at your local office supply store.)

After verifying the listing output and purchasing the 1099 forms, repeat the 1099 report and select Output -> Laser Forms (1099 MISC).

Each batch will only print a single page per entry. If you have 20 forms to print, first print all Copy A, then repeat the process and print Copy B.


  1. Select Vendor -> 1099 MISC Forms.
  2. Select Report By: Only Broker Clients, Only Vendors, or Both.
    Menu-1099-reportby.png
  3. Select Balance Method: Debit Balances Only, Balances > $599.99, or All Balances.
    Menu-1099-balmethod.png
  4. Select the Start Date and End Date for the tax reporting period.
  5. Deselect any desired Organization Type.
  6. If desired, enter a start and end Vendor/Broker value to limit the results. (Only available if Report By is limited to a single type.)
  7. Select an Output:
    Menu-1099-output.png
    • Forms (1099-MISC): One page per result, used with continuous feed paper printers (Legacy dot matrix printers).
    • Listing: Summary for all Vendors/Brokers with totals for review.
    • Magnetic Media: Exports a data file saved to \Empire\Programs\IRSTAX.001 for electronic submission.
    • Test Magnetic Media: Exports a data file saved to \Empire\Programs\IRSTAX.001 for testing electronic submission.
    • Replace Magnetic Media: Exports a data file saved to \Empire\Programs\IRSTAX.001 for electronic submission to update an existing submission.
    • Laser Forms (1099-NEC): One page per result, used with modern laser or inkjet printers.
January 2024 Revision of 3 per page 1099NEC for builds 9600+ | RPT File
  1. Enter the Transmit Code and Name code, only when selecting Output -> Magnetic Media.
  2. Select Print.