Step-by-Step Guide for Completing 1099 Forms in Quickbooks Online

Feb 4, 2024

Step-by-Step Guide for Completing 1099 Forms in Quickbooks

The 1099 Form in QuickBooks is essential for reporting nonemployee compensations and third-party payments during the calendar year. It tracks payments to independent contractors and others not on the regular payroll. This tool helps ensure accurate income reporting to the IRS for these individuals, effectively serving as an information return. Using QuickBooks, small businesses can efficiently manage and report these payments, aligning with tax requirements for each calendar year.

Step 1: Generate a Transaction List by Vendor Report in Quickbooks

In QuickBooks, start by creating a ‘Transaction List by Vendor Report’. This report compiles vendor transactions from the past year and simplifies the summary of your vendor payments. This is particularly useful for 1099-NEC or 1099-MISC reporting.

To generate the report:

  1. Go to the Reports function in Quickbooks
  2. Run the Transaction List by Vendor report

Customize the report

  1. Add vendor as a column
  2. Change the report dates from January 1 to December 31 of the previous year for which you are preparing to file your 1099s.
  3. Filter by the transaction types such as checks, bill payments, expense, and non-credit card expenditures
  4. In the Rows/Columns section, select ‘None’ under ‘Group by’ so individual transactions are no longer grouped by Vendor

Export the report to Excel

  1. Delete the report titles
  2. Eliminate any blank rows
  3. Add a new ‘Payment Amount’ column and use if function to change negative values for payments to positive
  4. Add a new tab to the worksheet and title it ‘Pivot’

Create Pivot Table

  1. Highlight everything
  2. Click ‘Insert’ in the top Excel menu and select ‘Pivot Table’
  3. When using the ‘Create PivotTable’ menu, include all rows from your report in the table or range. Then, place the pivot table on the ‘Pivot’ tab you previously set up
  4. Put vendor in ‘Rows’, account in ‘Filters’, and payment amount in ‘Values’
  5. Filter the Account to only checking, savings, and other bank accounts. Do not include any credit card accounts in this process.
  6. Add another tab to the spreadsheet and call it ‘List’
  7. Copy/paste the pivot table to the ‘List’ tab and customize the columns to ‘Vendor’, ‘Sum of Amount’, ‘Y/N’, and ‘Reason’

Filter out payments that total <$600

  1. Highlight the list and select ‘Sort & filter’ Excel function
  2. Select ‘filter’
  3. On the ‘Sum of Amount’ column, select the filter and filter the list to payments Greater than or equal to $600

For each payment, verify the purpose and the vendor’s social security number. If they qualify for a 1099-NEC or 1099-MISC, mark ‘Y’ for yes. If not, mark ‘N’ for no.

For the 1099-NEC

  1. Include payments for services to those who are not employees (including parts and materials)
  2. Payments to attorneys in 1099-NEC

For the 1099-MISC

  • Include payments for at least $10 in Royalties – box 2 (not common)
  • Include payments of at least $600 for:
    • Rents – box 1
    • Prizes and awards (box 3)
    • Other income payments (box 3)
    • Generally, the cash paid from a notional principal contract to an individual, partnership, or estate (box 3)
    • Any fishing boat proceeds (box 5)
    • Medical and health care payments (box 6)
    • Crop insurance proceeds (box 9)
    • Gross proceeds paid to an attorney (box 10) (see Payments to attorneys, later)
    • Section 409A deferrals (box 12)
    • Nonqualified deferred compensation (box 15)

Mark payments as ‘N’ in the ‘Y/N’ column if they don’t qualify for 1099-NEC or 1099-MISC. If necessary, explain their exclusion.

Tip: Add a filter to the ‘Y/N’ column to filter out all non-qualifying payments

Step 2: Preparing 1099s

Start by using the ‘Prepare 1099s’ feature to generate a list of your 1099 payments in Quickbooks. This is your first step in ensuring the types of payments are in order. Once you have this list, your next task is to compare it with the Transaction List by Vendor you prepared earlier. This comparison is crucial for accuracy.

If you notice any differences between the two lists, it’s time to take a closer look. You may need to actively adjust the QuickBooks settings, especially the general ledger accounts for 1099 reporting. Additionally, adding notes to your Transaction List by Vendor can be helpful. These notes will clarify any discrepancies and ensure your 1099 forms are correct and ready to go.”

To generate the list of 1099 payments in Quickbooks’ “Prepare 1099s” function:

  1. Hover over Payroll
  2. Click on Contractors
  3. Click “Prepare 1099s”
  4. Continue to 1099s

Follow the steps below for each section in the Prepare 1099s function

Company

Review that all your company information is correct

Accounts

Map the GL accounts to the proper 1099 payment type

Common payment types:

  • Non-employee compensation Box 1 1099-NEC
  • Rents Box 1 1099-MISC

Tell Quickbooks Online to which account should code 1099 by using the dropdown arrow to see all GL accounts

Contractors

1. Review your contractors’ info but do not add any information until step 4 review

2. To see which contractors meet the 1099 threshold, click next

Review

  1. Review the list of 1099 payments for accuracy
  2. Enter any missing information for vendors
  3. Ensure the total payments to each contractor meet the minimum threshold (usually $600) for 1099 issuance. You won’t see payments made using credit cards or third-party services like PayPal on your 1099 forms.
  4. Print out an information sheet (Quickbooks Report) to compare with the Transaction List by Vendor.

Compare the information sheet from the “Prepare 1099s” function to the Transaction List by Vendor

If the payment totals match, no further adjustment is necessary. If payments do not match, you may need to adjust one of the following:

  1. The accounts selected in the QB 1099 function
  2. If there are still payments not appearing, include a note on the ‘Transaction List by vendor’ report

Step 3: Review and Submit 1099 before Due Date

Before sending your final 1099 forms to the IRS, double-check them for accurate and complete vendor information.

  1. Ensure that the 1099 information sheet matches the 1099 Transaction List by Vendor Report
  2. Verify all 1099 vendor information is correct
  3. Review excluded payments for accuracy
  4. Select Save to store your updates.
  5. Once you’ve finished reviewing, use the ‘Prepare 1099s’ function to send the final 1099 forms to the IRS. Do this within one business day to make sure you file them on time.”

Submit the Final 1099s to the IRS utilizing the “Prepare 1099s” function

  1. Hover over Payroll
  2. Click on Contractors
  3. Click 1099 Function
  4. Print the 1099 information sheet
  5. Save Files (Vendor 1099 Sheet_FINAL)
  6. Finish preparing 1099s

1099 E-File Service

Continue to e-file

  1. Double-check your information to ensure accuracy. Avoiding tax errors is crucial to avoid tax penalties!
  2. Pay for service
  3. Choose delivery option
  4. File and deliver
  5. Download a copy of each 1099 for your records
  6. Print for Contractors
  7. Click View & Save
  8. Click Continue
  9. Print your records
  10. File and Submit
  11. Print Screen for the filing confirmation
  12. Sign out

Questions about opening a bank account?

We’re here to help.

Tyler Wilcox, CPA

 

Tyler’s extensive background in accounting, tax, and financial consulting set the foundation for Velu’s outsourced accounting solutions for nonprofits and small businesses. As a fractional CFO, he goes beyond routine duties, guiding organizations with strategic insights for sound financial decisions. Velu’s services address the unique challenges faced by nonprofits and small businesses, fostering sustainable growth. Tyler places great emphasis on meticulous attention to detail in financial record-keeping, implementing efficient systems to ensure transparency and streamline operations.

Learn more about Tyler and the Velu team on our About Us page. We’re excited to connect with you!

Related Posts

How to Open a Bank Account for a Nonprofit

How to Open a Bank Account for a Nonprofit

Opening a bank account is a crucial step for any nonprofit organization. It establishes financial credibility and aids in efficient money management. Whether you're new or organizing your finances, you need to know how to set up a nonprofit bank account. This is...

read more
Federal Grant Requirements Guide for Nonprofit Leaders

Federal Grant Requirements Guide for Nonprofit Leaders

Federal grants can provide essential funding for nonprofits, but managing these grants requires a thorough understanding of federal requirements and meticulous compliance. Here’s a comprehensive deep dive into what nonprofit leaders need to know to successfully...

read more
Nonprofit Board Member Application Template

Nonprofit Board Member Application Template

Board members play a crucial role in the success of a nonprofit organization, providing guidance on its mission and financial management. A well-crafted board member application is essential for identifying and selecting the right individuals to join your board. This...

read more