Difference between revisions of "Report: 1099s"

From Agency Systems Wiki
Jump to navigation Jump to search
m (updated to show 1099-NEC, with link to the RPT file)
 
(3 intermediate revisions by 2 users not shown)
Line 28: Line 28:
 
</table>
 
</table>
 
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.
 
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.
*The 1099 amounts reported for [[Vendor Profile|vendors]] are calculated from the [[Report: Check Register: Non-Policy Related Checks (Vendor Payables)|check transactions coded to each vendor]].
+
*The 1099 amounts reported for [[Vendor Profile|vendors]] are calculated from the [[Voucher Transaction|voucher invoices]] and [[Report: Check Register: Non-Policy Related Checks (Vendor Payables)|check transactions coded to each vendor]].
 
*The 1099 amounts for brokers (agents) are calculated from invoice transactions.  
 
*The 1099 amounts for brokers (agents) are calculated from invoice transactions.  
  
'''If you have manually entered 1099 totals on the [[Vendor Profile|vendor]] or broker (agent) profiles, the manually entered amount will display on the 1099 reports and forms instead of being calculated.'''
+
'''If you have manually entered 1099 totals on the [[Vendor Profile|vendor]] or [[Client_Profile#Client_Profile_1099_Information_Tab|broker (agent) profiles]], the manually entered amount will display on the 1099 reports and forms instead of being calculated.'''
  
 
== Access and Window Options ==
 
== Access and Window Options ==
The 1099 report window can be opened by selecting '''A/P -> 1099-MISC Forms'''.
+
The 1099 report window can be opened by selecting '''Vendor -> 1099 MISC-Forms'''.
  
Access to the 1099 report is controlled through the [[Security System|security system]] '''A/P -> 1099-MISC Forms -> View''' setting.
+
Access to the 1099 report is controlled through the [[Security System|security system]] '''A/P -> 1099 MISC-Forms -> View''' setting.
  
 
[[File:Menu-1099.png]]
 
[[File:Menu-1099.png]]
Line 53: Line 53:
 
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.
 
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.
 
----
 
----
#Select '''AP -> 1099-MISC Forms'''.
+
#Select '''Vendor -> 1099 MISC Forms'''.
 
#Select '''Report By:''' Only Broker Clients, Only Vendors, or Both.
 
#Select '''Report By:''' Only Broker Clients, Only Vendors, or Both.
 
#:[[File:Menu-1099-reportby.png]]
 
#:[[File:Menu-1099-reportby.png]]
Line 68: Line 68:
 
#*'''Test Magnetic Media:''' Exports a data file saved to \Empire\Programs\IRSTAX.001 for testing 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.
 
#*'''Replace Magnetic Media:''' Exports a data file saved to \Empire\Programs\IRSTAX.001 for electronic submission to update an existing submission.
#*'''Laser Forms (1099-MISC):''' One page per result, used with modern laser or inkjet printers.
+
#*'''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+ | [http://files.agencysystems.com/support/Builds/1099lasfm.rpt RPT File]
 +
 
 
#Enter the '''Transmit Code''' and '''Name code''', '''only''' when selecting '''Output -> Magnetic Media'''.
 
#Enter the '''Transmit Code''' and '''Name code''', '''only''' when selecting '''Output -> Magnetic Media'''.
 
#Select '''Print'''.
 
#Select '''Print'''.

Latest revision as of 16:27, 23 January 2024

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.