1099-B fields and locations

Use the following table to troubleshoot each box on Form 1099-B in Accounting CS.

Form 1099-B Fields and Corresponding Data Locations in Accounting CS
Field/Line	Field	Data Location	Notes
PAYER’S name	Payroll name	Setup Clients Main tab	N/A
PAYER’S address	Business address line 1	Setup Clients Main tab	Make sure the correct address is entered as the Business address if there are separate mailing and taxing addresses.
PAYER’S TIN	EIN/SSN	Setup Clients Main tab	N/A
RECIPIENT’S TIN	EIN/SSN	Setup Vendors Main tab	N/A
RECIPIENT’S name	Vendor name	Setup Vendors Main tab	N/A
Street address	Business address line 1	Setup Vendors Main tab Business address	Make sure the correct address is entered as the Mailing address if there are separate mailing and taxing addresses.
Street address (continued)	Business address line 2	N/A	N/A
City, state, country, ZIP	City, State, Zip, Country	N/A	Override information if the foreign state or country isn't available in the dropdown.
Account number	N/A	System Calculated field	The application populates this field with a unique account number.
2nd TIN not.	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the 2nd IRS notification incorrect recipient TIN checkbox.
CUSIP number	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Enter the registration number in the CUSIP# field.
FATCA filing requirement	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the FATCA filing requirement field.
Applicable check box on Form 8949	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Select the appropriate code from the Form 8949 dropdown.
Box 1a. Description of property	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Enter the description of the property in the Description field.
Box 1b. Date acquired	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Enter the acquired date in the Date of acquisition box.
Box 1c. Date sold or disposed	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Enter the sale date in the Date of sale/exchange box.
Box 1d. Proceeds	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 1d.
Box 1e. Cost or other basis	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 1e.
Box 1f. Accrued market discount	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Select a code from the Box 1F Code dropdown.
Box 1g. Wash sale loss disallowed	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 1g.
Box 2. Short-term gain or loss	N/A	System Calculated field	The application marks this checkbox based on the date of acquisition.
Box 2. Long-term gain or loss	N/A	System Calculated field	The application marks this checkbox based on the date of acquisition.
Box 2. Ordinary	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the Ordinary checkbox if the gain/loss is ordinary.
Box 3. Check if proceeds from collectibles or QOF	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the Proceeds from Collectibles or Proceeds from QOF checkbox.
Box 4. Federal income tax withheld	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 4.
Box 5. Check if noncovered security	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the Noncovered security checkbox.
Box 6. Reported to IRS: Gross proceeds or Net proceeds	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark as Gross proceeds or Gross proceeds less commissions/premiums.
Box 7. Check if loss is not allowed based on amount in 1d	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the Cannot take loss on return for Proceeds amt checkbox.
Box 8. Profit or (loss) realized in 20XX on closed contracts	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 8.
Box 9. Unrealized profit or (loss) on open contracts – 12/31/20XX	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 9.
Box 10. Unrealized profit or (loss) on open contracts – 12/31/XX	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 10.
Box 11. Aggregate profit or (loss) on contracts	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 11.
Box 12. Check if basis reported to IRS	1099 item Ellipsis	Actions Enter Transactions Check Distributions tab	Mark the Basis reported checkbox.
Box 13. Bartering	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 13.
Box 14. State name	Withholding state abbreviation	Setup Clients Main Tab Locations button	Populates the state based on the client's primary location.
Box 15. State identification no.	Withholding ID	Setup Clients Payroll Taxes Tab	Uses the client's state withholding ID based on the populated state.
Box 16. State tax withheld	1099 (drop-down)	Actions Enter Transactions Check Distributions tab	Choose a 1099 item that contains box 16.

For additional information on overriding data, refer to the Actions
Edit Payroll Tax Form
Recipient Data tab
.

This article applies to:

Product: Accounting CS
Subject: e-file

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Success stories

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Highlights

Help

Learn

1099-B fields and locations

This article applies to: