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
.
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close